GitHub - katestarbird/TweakTheTweet: Collects and processes tweets using TtT syntax

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 11 Commits
README		README
TtT_MySQL_processing.rb		TtT_MySQL_processing.rb
TtT_config_processing.rb		TtT_config_processing.rb
TtT_create_database.rb		TtT_create_database.rb
TtT_go.rb		TtT_go.rb
TtT_helpers.rb		TtT_helpers.rb
TtT_location_parsing.rb		TtT_location_parsing.rb
TtT_pickup.py		TtT_pickup.py
TtT_tweet_parsing.rb		TtT_tweet_parsing.rb
TtT_update_google_spreadsheet.rb		TtT_update_google_spreadsheet.rb
config.yml		config.yml

Repository files navigation

Tweak the Tweet project

Initial code by Kate Starbird - University of Colorado

Tweak the Tweet asks users of Twitter (during crises) to format their tweets a specific way to make them machine-parseable.

This project contains code to collect tweets and process them into a MySQL database and a public Google Spreadsheet.

Requirements:
Python (for the collection)
Ruby (for the processing/MySQL/Google Spreadsheet API connection)
MySQL

You'll have to configure your system to work with the Ruby-MySQL connection.
If you're using a MAC, MySQL-Ruby won't work with MySQL in the 64-bit mode. You have to install MySQL as 32-bit.

To get started:
1) Set up a MySQL database.

3) Edit the config.yml file. You will need to set passwords, keys, collection terms, and filtering terms. You'll need a bounding box for the affected area. You can set geographic names to add to location text to send to GeoKit for geolocating. You can set primary tags, data tags, etc. You can also determine which primary tags must have geolocation to be accepted. Etc.

4) Run the TtT_create_database.rb script to generate the correct tables. This will use the config file to determine what the tables look like.

5) Edit the TtT_pickup.py code to include the terms you would like to collect on. You also need to set your Twitter username and password - and specify the MySQL connection details.

6) Run the TtT_pickup.py code - and keep it running.

7) Run the TtT_go.rb - and keep it running.

443A