Скачать или смотреть NiFi for Transit: GTFS Realtime Feeds with PostgreSQL Lookups

NiFi for Transit: GTFS Realtime Feeds with PostgreSQL Lookups

https://github.com/tspannhw/FLaNK-Hal...

gtfs-realtime-bindings

Halifax Canada

We built two lookup tables in PostgreSQL

-- public.halifaxlookupstops definition

-- Drop table

-- DROP TABLE public.halifaxlookupstops;

CREATE TABLE public.halifaxlookupstops (
stop_id int4 NOT NULL,
stop_code int4 NULL,
stop_name text NULL,
stop_desc text NULL,
stop_lat float8 NULL,
stop_lon float8 NULL,
zone_id text NULL,
stop_url text NULL,
location_type text NULL,
parent_station int4 NULL,
stop_timezone text NULL,
wheelchair_boarding int4 NULL,
CONSTRAINT halifaxlookupstops_pkey PRIMARY KEY (stop_id)
);


-- public.halifaxlookuproutes definition

-- Drop table

-- DROP TABLE public.halifaxlookuproutes;

CREATE TABLE public.halifaxlookuproutes (
route_id int4 NOT NULL,
agency_id text NULL,
route_short_name int4 NULL,
route_long_name text NULL,
route_desc text NULL,
route_type int4 NULL,
route_url text NULL,
route_color text NULL,
route_text_color int4 NULL,
CONSTRAINT halifaxlookuproutes_pkey PRIMARY KEY (route_id)
);


Halifax GTFS Feeds
https://gtfs.halifax.ca/realtime/Trip...

https://gtfs.halifax.ca/realtime/Aler...

https://gtfs.halifax.ca/realtime/Vehi...