Skip to content

Python scripts to import a GTFS dataset into a basic MySQL database.

Notifications You must be signed in to change notification settings

yelper/py-gtfs-mysql

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

18 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

GTFS MySQL IMPORT SCRIPT
Author: Tom Lee ([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, and has not been thoroughly checked for completeness
against the GTFS spec -- some optional fields or tables may not 
currently be supported (but should be trivial to add).

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:

1. Create a database, e.g. CREATE DATABASE gtfs

2. Run table creation scripts against the database:

	cat sql/*.sql | mysql -p -u USERNAME -h HOST -D gtfs
	
3. Edit settings.py with your mysql details.

4. Put your GTFS files into the gtfs/ folder

5. Run the import script:

	python load_gtfs.py
	
6. Run the time index creation script:

	python build_indices.py
	
7. Build something neat

About

Python scripts to import a GTFS dataset into a basic MySQL database.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • Python 100.0%