gtfs-to-sqlite

July 19, 2018 ยท View on GitHub

A tool for generating an SQLite database from a GTFS feed.

Requirements

Java Runtime Environment 8 or higher.

Installation

macOS

Using Homebrew:

brew tap aytee17/homebrew-tap
brew install gtsql

Usage

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

Notes

  • 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 of calendar.txt, update resources/GTFS_Specification.json to reflect this in all foreign key references to calendar.