gtfs-via-postgres
gtfs-via-postgres copied to clipboard
public-transport
Process GTFS Static/Schedule by importing it into a PostgreSQL database.
### Feature request: Support import of fare_leg_rules.txt Please don't see this as an "urgent" feature reuqest. I just noticed, while trying to import the Finnish GTFS feed, that `fare_leg_rules.txt` is...
https://martin.maplibre.org https://github.com/maplibre/martin/blob/b970b2169fbf9e4ad23522af8f78c28b1b095d61/README.md#usage
e.g. https://reports.calitp.org/gtfs_schedule/2022/12/282/index.html - [x] dates with/without service? - [x] service hours per weekday? - [ ] changed identifiers between feed versions - [x] https://github.com/cal-itp/data-infra/issues/2234 - [ ] https://github.com/cal-itp/data-infra/issues/1225 - [x]...
https://github.com/denysvitali/gtfs-server/tree/ff5a814a952716f1461b33480bcc78021255a29f/nb/sql/queries - [ ] `CREATE UNIQUE INDEX calendar_service_id_idx ON public.calendar USING btree (service_id, feed_id)` - [ ] `CONSTRAINT calendar_date_service_id_date_feed_id_key UNIQUE (service_id, date, feed_id)` - [x] store feed metadata in a...
https://github.com/conveyal/gtfs-lib/tree/3826eeda92f488f9d9ab4022d08be3b1281980de/src/main/java/com/conveyal/gtfs - [ ] [JSON import stats](https://github.com/conveyal/gtfs-lib/tree/3826eeda92f488f9d9ab4022d08be3b1281980de#load-and-validation-results) - [ ] GTFS-Fares - [x] GraphQL API? - [ ] trip patterns? – lists of stops a route visits
This feature should be behind a flag, e.g. `--stops-name-search`. - https://rachbelaid.com/postgres-full-text-search-is-good-enough/ - https://www.postgresql.org/docs/14/textsearch-controls.html - https://www.postgresql.org/docs/14/textsearch-dictionaries.html
`ERROR: new row for relation "feed_info" violates check constraint "valid_default_lang"` Was fixed by changing `feed_lang` from `en` to `en_US.utf8` but `en` seems to be used in the example amtrak GTFS...
https://github.com/evansiroky/gtfs-sequelize
As of #2, `gtfs-via-postgres` supports all `frequencies.txt` rows with `exact_times=1`, but not those with `exact_times=0`. > [Frequencies.txt](https://gtfs.org/reference/static/#frequenciestxt) represents trips that operate on regular headways (time between trips). This file can...
Metadata
Owner
Metadata
Process GTFS Static/Schedule by importing it into a PostgreSQL database.