NiFi for Transit: GTFS Realtime Feeds with PostgreSQL Lookups скачать в хорошем качестве

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...