GTFS-Issues
GTFS-Issues copied to clipboard
DELFI: Stops an gleicher Koordinate und abweichender parent station
Eine Vielzahl von stops haben, trotz gleicher Koordinate, abweichende parent stations.
SELECT a.parent_station, a.stop_id, b.parent_station, b.stop_id, a.stop_name, b.stop_name, a.stop_lat , a.stop_lon
FROM gtfs.stops a, gtfs.stops b
WHERE a.stop_lat = b.stop_lat
AND a.stop_lon = b.stop_lon
AND a.location_type=0
AND b.location_type=0
AND a.parent_station != b.parent_station;
parent_station | stop_id | parent_station | stop_id | stop_name | stop_name | stop_lat | stop_lon
----------------------+-------------------------+----------------------+-------------------------+-------------------------------------------------+-------------------------------------------------+------------+-------------
de:09185:354 | de:09185:354:0:2 | 000000000354_G | 000010035402 | Karlskron,Rathaus | Karlskron,Rathaus | 48.678175 | 11.410152
de:13071:3001_G | de:13071:3001 | de:13071:3015_G | de:13071:3015 | Demmin Jarmener Str. | Demmin Kinderheim | 53.905651 | 13.052814
de:13071:3177_G | de:13071:3177 | de:13071:3707_G | de:13071:3707 | Törpin | Törpin Ausbau | 53.773049 | 13.085483
de:12073:900340591 | de:12073:900340591_G | de:13075:4135_G | de:13075:4135 | Schmölln,Dorf | Loddin | 0.003676 | 7.449145
de:12073:900340591 | de:12073:900340591_G | de:13075:4053_G | de:13075:4053 | Schmölln,Dorf | Neuendorf (Lütow) | 0.003676 | 7.449145
de:12073:900340591 | de:12073:900340591_G | de:13075:4077_G | de:13075:4077 | Schmölln,Dorf | Zecherin Ausbau | 0.003676 | 7.449145
de:12073:900340591 | de:12073:900340591_G | de:13075:411_G | de:13075:411 | Schmölln,Dorf | Kröslin Kommune | 0.003676 | 7.449145
de:09673:27096 | de:09673:27096:0:1_G | de:09673:4860 | de:09673:27096:0:1 | Brendlorenzen Hauptstr. 32 | Brendlorenzen Hauptstr. 39 | 50.329659 | 10.213607
de:13075:4077_G | de:13075:4077 | de:13075:4135_G | de:13075:4135 | Zecherin Ausbau | Loddin | 0.003676 | 7.449145
de:13075:4077_G |
...
(1632 rows)
Aktualisierungszeitpunkt der GTFS-Daten: 15. Mai 2020
Downloadlink der GTFS-Daten: https://cms.opendata-oepnv.de/fileadmin/datasets/delfi/20200515_fahrplaene_gesamtdeutschland_gtfs.zip