Author: Tom Lee ([email protected])
Modified for Montgomery County by: Afua Ankomah ([email protected])
-
This is a simple set of scripts that will import a GTFS dataset into a lightweight MySQL database. The work is based on Washington, DC's WMATA GTFS dataset, but is being modified specifically for Montgomery County's GTFS dataset.
-
In addition to the GTFS fields, a number of columns have been created to assist in the conversion of GTFS's string-based date/time representations to more useful Unix timestamp-style second counts.
DEAD-SIMPLE USAGE:
-
Create a database, e.g. CREATE DATABASE MOCOGTFS
-
Run table creation scripts against the database:
cat sql/*.sql | mysql -p -u USERNAME -h HOST -D mocogtfs
-
Edit settings.py with your mysql details.
-
Put your GTFS files into the gtfs/ folder
-
Run the import script:
python load_gtfs.py
-
Run the time index creation script:
python build_indices.py
-
Build something neat
This is a simple site developed to showcase the data retrieved from the Montgomery County MD website.