{"repo":"public-transport/gtfs-via-postgres","free":true,"listed":false,"github":"https://github.com/public-transport/gtfs-via-postgres","clone":"git clone https://github.com/public-transport/gtfs-via-postgres.git","description":"Analyse GTFS Schedule data by importing it into a PostgreSQL database.","language":"JavaScript","stars":146,"topics":["gtfs","postgresql","postgres","sql","transit","public-transport","gtfs-schedule","gtfs-static","public-transportation"],"license":null,"category":"databases-storage","readme_excerpt":"gtfs-via-postgres Import GTFS Static/Schedule datasets into a PostgreSQL database , to allow for efficient querying and analysis. - ✅ handles daylight saving time correctly but retains reasonable lookup performance - ✅ supports frequencies.txt - ✨ joins stop times.txt / frequencies.txt , calendar.txt / calendar dates.txt , trips.txt , route.txt & stops.txt into views for straightforward data analysis (see below) - 🚀 is carefully optimised to let PostgreSQL's query planner do its magic, yielding quick lookups even with large datasets (see performance section) - ✅ validates and imports translations.txt - ✨ exposes (almost) all data via GraphQL using PostGraphile, and as a RESTful API using PostgREST To work with the time-related data ( stop times etc.), gtfs-via-postgres supports two \"mental models\": - the time- unexpanded data that is almost directly taken from the GTFS Schedule data – This is useful if you want to do network analysis. - the time- expanded view that \"applies\" every trip's stop times rows to all of its service days – This is useful for routing & queries from the traveller's perspective. [!NOTE] If you don't have a good reason to use PostgreSQL (e.g. because you use one of gtfs-via-postgres ' unique features like GraphQL support), I recommend you to use gtfs-via-duckdb . It is a fork of and the spiritual successor to gtfs-via-postgres . Refer to the comparison below for details. Installation Or use npx . ✨ There are also prebuilt binaries and Docker images avai","default_branch":null,"files":null,"tree":[],"storefront":"/r/public-transport","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/public-transport/gtfs-via-postgres/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}