A tool for generating an SQLite database from a GTFS feed.
Java Runtime Environment 8 or higher.
Using Homebrew:
brew tap aytee17/homebrew-tap
brew install gtsql
usage: gtsql -p <gtfs_path> [-u <gtfs_url>] -d <database_path>
-p,--path <gtfs_path> Path to the GTFS data (.zip or directory)
-u,--url <gtfs_url> HTTP URL to the GTFS data
-d,--database <database_path> Path to the database file
- Before attempting to generate the database consider validating your feed through Google's transit feed validator and correcting any errors.
- If your GTFS static feed contains custom fields not defined in the GTFS specification they will be ignored when the files are parsed. To include them in the database, add the custom field to
resources/GTFS_Specification.json
following the conventions of the other fields. - If the feed you are working with uses
calendar_dates.txt
instead ofcalendar.txt
, updateresources/GTFS_Specification.json
to reflect this in all foreign key references tocalendar
.