gtfs-via-postgres
gtfs-via-postgres copied to clipboard
public-transport
Process GTFS Static/Schedule by importing it into a PostgreSQL database.
- [x] https://github.com/duckdb/duckdb/discussions/7029 – feature released as `0.8.0`. - [x] https://github.com/duckdb/duckdb/discussions/6873#discussioncomment-5580208 - [x] https://github.com/duckdb/duckdb/issues/63#issuecomment-1502425536 - [ ] https://github.com/duckdb/duckdb/issues/604 - [ ] https://github.com/duckdb/duckdb/discussions/3638 - [ ] https://github.com/duckdb/duckdb/discussions/12410 - [x] https://github.com/duckdb/duckdb/issues/12901 -...
https://git.sr.ht/~mil/mobroute/tree/5e5c453fd9f48da51f5a0947b8a04b42049897cd/item/db/dbschemaextra/sqlviews
Being able to query a trip's simplified route type by joining it via the extended route type would be great, e.g. to get all buses. https://developers.google.com/transit/gtfs/reference/extended-route-types
@dancesWithCycles asked in the [`berlin-gtfs-rt-server` project](https://github.com/derhuerst/berlin-gtfs-rt-server) (which transitively depends on `gtfs-via-postgres`) **how to programmatically import GTFS and switch some running service (e.g. an API) to the newly imported data**. I'll...
I think the `arrivals_departures` view is what I'm most interested in, but for the simple iOS app I'm building I'd like to avoid hosting a database. Would it be possible/reasonable...
e.g. by writing Prometheus-/OpenMetrics-compatible metrics into a file. - if an error occurred during the import - some of the [import metadata](https://github.com/public-transport/gtfs-via-postgres/blob/112e38bfb57a71be06db8a1d60f545b6c9fd1ffe/docs/import-metadata.md) (which could also be extended to include the...
I suggest to explicitly set SRID 4326 for shape geometries in [shapes_aggregated](https://github.com/public-transport/gtfs-via-postgres/blob/fc0e4c5f243f6fa58e9d85751e1e0a3a4207de77/lib/shapes.js#L40C2-L40C13), e.g. ``` ST_SetSRID(4326, ST_MakeLine(array_agg(shape_pt_loc))) AS shape ``` That way, subsequent (materialized) views coud create a spatial index like...
https://github.com/google/transit/pull/278
Metadata
Owner
Metadata
Process GTFS Static/Schedule by importing it into a PostgreSQL database.