Skip to content

Generate an SQLite database from a GTFS feed.

License

Notifications You must be signed in to change notification settings

PavelVPV/gtfs-to-sqlite

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

50 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

gtfs-to-sqlite

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.

About

Generate an SQLite database from a GTFS feed.

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages

  • Java 91.9%
  • Python 7.4%
  • Shell 0.7%