gtfs-via-postgres
gtfs-via-postgres copied to clipboard
implement features of gtfs-server
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 table?
- [x]
CREATE INDEX stop_geom ON public.stop USING gist ("position")