National Transit Map: GTFS to Socrata Catalog

This script publishes GTFS-formatted data from transit agencies represented in the National Transit Database (NTD) to the https://data.bts.gov catalog. It creates one record in the data.bts.gov catalog for each agency and saves the current GTFS feed .zip file. It also updates the National Transit Map - Map of Stop Locations dataset that visualizes transit stops on a nationwide map.

Getting setup

1. Ensure you have the username and password for a Socrata account with Publisher permissions.
2. Set the following environment variables: SOCRATA_BTS_USERNAME SOCRATA_BTS_PASSWORD

Running the script

The script can be run in three different modes:

python3 publish_to_catalog.py catalog

python3 publish_to_catalog.py catalog_test

python3 publish_to_catalog.py stops_map

Training videos

1. Training Video: Catalog Script Overview
2. Training Video: Updating The Agency Feed Dataset

Dataset links on data.bts.gov

• NTM: National Transit Map - All Agency Feeds: Public dataset with GTFS feeds for all transit agencies in the NTM.
• National Transit Map - Map of All Stop Locations: Dataset that visualizes NTM transit stops on a nationwide map.
• NTM - PRIVATE: Ingest Script Log: Private dataset that records a record each time the ingest script has been run.
• NTM - PRIVATE: TEST DATASET for Agency Feeds: Private dataset that allows running the script in test mode (python3 publish_to_catalog.py catalog_test) on fake agency data.

Get in touch

Email [email protected] if you have questions, feedback, or you would like to contribute.

Credits

This project developed as a partnership amongst the U.S. Department of Transportation, TOTAGO, and Trillium Solutions.