mfdz
DELFI (VVS): Stuttgarter U-Bahnen als route_type 'straßenbahn' angegeben
Beschreibe den Fehler
Sämtliche U-Bahn-Linien des VVS sind mit route_type == 3 (Bus) angegeben:
"route_id","agency_id","route_short_name","route_long_name","route_type","route_color","route_text_color","route_desc"
"de:vvs:20069_:",7993,"U19","",3,"","",""
"de:vvs:20019_:",7993,"U19","",3,"","",""
"de:vvs:20016_:",7993,"U16","",3,"","",""
"de:vvs:20015_:",7993,"U15","",3,"","",""
"de:vvs:20014_:",7993,"U14","",3,"","",""
"de:vvs:20013_:",7993,"U13","",3,"","",""
"de:vvs:20012_:",7993,"U12","",3,"","",""
"de:vvs:20011_:",7993,"U11","",3,"","",""
"de:vvs:20009_:",7993,"U9","",3,"","",""
"de:vvs:20008_:",7993,"U8","",3,"","",""
"de:vvs:20007_:",7993,"U7","",3,"","",""
"de:vvs:20006_:",7993,"U6","",3,"","",""
"de:vvs:20005_:",7993,"U5","",3,"","",""
"de:vvs:20004_:",7993,"U4","",3,"","",""
"de:vvs:20003_:",7993,"U3","",3,"","",""
"de:vvs:20002_:",7993,"U2","",3,"","",""
"de:vvs:20001_:",7993,"U1","",3,"","",""
Korrekt wäre route_type == 1
Aktualisierungszeitpunkt der GTFS-Daten: 22.1.2024
Downloadlink der GTFS-Daten: Open-Data ÖPNV
Im heutigen Datensatz werden sie als Straßenbahn (route_type 0) ausgegeben:
"de:vvs:20069_:",7993,"U19","",0,"","",""
"de:vvs:20019_:",7993,"U19","",0,"","",""
"de:vvs:20016_:",7993,"U16","",0,"","",""
"de:vvs:20015_:",7993,"U15","",0,"","",""
"de:vvs:20014_:",7993,"U14","",0,"","",""
"de:vvs:20013_:",7993,"U13","",0,"","",""
"de:vvs:20012_:",7993,"U12","",0,"","",""
"de:vvs:20011_:",7993,"U11","",0,"","",""
"de:vvs:20009_:",7993,"U9","",0,"","",""
"de:vvs:20008_:",7993,"U8","",0,"","",""
"de:vvs:20007_:",7993,"U7","",0,"","",""
"de:vvs:20006_:",7993,"U6","",0,"","",""
"de:vvs:20005_:",7993,"U5","",0,"","",""
"de:vvs:20004_:",7993,"U4","",0,"","",""
"de:vvs:20003_:",7993,"U3","",0,"","",""
"de:vvs:20002_:",7993,"U2","",0,"","",""
"de:vvs:20001_:",7993,"U1","",0,"","",""
In Datensätzen Stand Oktober 2023 waren sie als route_type 1 ausgegeben.
Der VVS veröffentlicht sie übrigens mit dem extended route_type 402 (U-Bahn, ich hätte eher 403 Stadtbahn gewählt, aber das lässt sich diskutieren):
"de:vvs:20001_:","VVS","U1","Fellbach - Hauptbahnhof - Heslach Vogelrain","402","CC9966","000000","VVS_ticketing"
"de:vvs:20002_:","VVS","U2","Neugereut - Charlottenplatz - Botnang","402","FF6600","FFFFFF","VVS_ticketing"
"de:vvs:20003_:","VVS","U3","Plieningen - Möhringen - Vaihingen","402","804D19","FFFFFF","VVS_ticketing"
"de:vvs:20004_:","VVS","U4","Untertürkheim - Charlottenplatz - Hölderlinplatz","402","8368AE","FFFFFF","VVS_ticketing"
"de:vvs:20005_:","VVS","U5","Killesberg - Hauptbahnhof - Leinfelden","402","33FFFF","000000","VVS_ticketing"
"de:vvs:20006_:","VVS","U6","Gerlingen - Hauptbahnhof - Flughafen/Messe","402","FF00FF","FFFFFF","VVS_ticketing"
"de:vvs:20007_:","VVS","U7","Mönchfeld - Hauptbahnhof - Ostfildern","402","66B18C","FFFFFF","VVS_ticketing"
"de:vvs:20008_:","VVS","U8","Ostfildern - Degerloch - Vaihingen","402","B3B15F","000000","VVS_ticketing"
"de:vvs:20009_:","VVS","U9","Hedelfingen - Hauptbahnhof - Vogelsang (-Botnang)","402","FFD900","000000","VVS_ticketing"
"de:vvs:20011_:","VVS","U11","Hauptbahnhof - Berliner Platz - Charlottenplatz - NeckarPark (Stadion)","402","A4A5A5","FFFFFF","VVS_ticketing"
"de:vvs:20012_:","VVS","U12","Remseck - Hauptbahnhof - Dürrlewang","402","AFC5E9","000000","VVS_ticketing"
"de:vvs:20013_:","VVS","U13","Feuerbach - Bad Cannstatt - Hedelfingen","402","E1ACC0","000000","VVS_ticketing"
"de:vvs:20014_:","VVS","U14","Mühlhausen - Charlottenplatz - Vaihingen","402","8EBF4D","000000","VVS_ticketing"
"de:vvs:20015_:","VVS","U15","Stammheim - Hauptbahnhof - Ruhbank (- Heumaden)","402","004DFF","FFFFFF","VVS_ticketing"
"de:vvs:20016_:","VVS","U16","Giebel - Feuerbach - Bad Cannstatt - Fellbach","402","BAD900","000000","VVS_ticketing"
"de:vvs:20019_:","VVS","U19","Neugereut - Bad Cannstatt Wilhelmsplatz - NeckarPark (Stadion)","402","FFB300","000000","VVS_ticketing"
"de:vvs:20069_:","VVS","U19","Bad Cannstatt Wilhelmsplatz - NeckarPark (Stadion)","402","A4A5A5","FFFFFF","VVS_ticketing"
Was beim direkten Vergleich zudem auffällt: In der Datenweitergabe-Transformations-Kette gehen leider Angaben wie route_long_name, route_color, route_text_color verloren...
Der DELFI-Export kennt leider keine Stadtbahn, sondern nur Straßenbahnen und U-Bahnen als Verkehrsmittel. Daher gab es Unklarheiten, was auszuwählen ist. Für den nächsten Export ändern wir es wieder auf U-Bahn.
Viele Grüße Anke Beckert (DELFI-Team)
Hallo Anke Beckert! Vielen Dank für die Info und die angekündigte Umstellung. Wenn der DELFI-Export keine Stadtbahn kennt, bedeutet dies, dass nicht das gesamte Spektrum an "quasi-Standard" extended route_types genutzt werden kann?
Hallo Holger Bruch, derzeit wird nur die Standard-Liste und nicht die Extended-Liste der route_types umgesetzt.
Viele Grüße Anke Beckert (DELFI-Team)
Schon seit einer Weile, insbesondere aber auch im Datensatz vom 12.8.2024 ist der route_type wieder 1.
select * from routes where agency_id='7993' and route_short_name like 'U%';
┌──────────────────┬───────────┬──────────────────┬─────────────────┬────────────┬─────────────┬──────────────────┬────────────┐
│ route_id │ agency_id │ route_short_name │ route_long_name │ route_type │ route_color │ route_text_color │ route_desc │
│ varchar │ int64 │ varchar │ varchar │ int64 │ varchar │ varchar │ varchar │
├──────────────────┼───────────┼──────────────────┼─────────────────┼────────────┼─────────────┼──────────────────┼────────────┤
│ de:vvs:20017_:_1 │ 7993 │ U5 │ │ 1 │ │ │ │
│ de:vvs:20019_:_1 │ 7993 │ U19 │ │ 1 │ │ │ │
│ de:vvs:20016_:_1 │ 7993 │ U16 │ │ 1 │ │ │ │
│ de:vvs:20015_:_1 │ 7993 │ U15 │ │ 1 │ │ │ │
│ de:vvs:20014_:_1 │ 7993 │ U14 │ │ 1 │ │ │ │
│ de:vvs:20013_:_1 │ 7993 │ U13 │ │ 1 │ │ │ │
│ de:vvs:20012_:_1 │ 7993 │ U12 │ │ 1 │ │ │ │
│ de:vvs:20011_:_1 │ 7993 │ U11 │ │ 1 │ │ │ │
│ de:vvs:20009_:_1 │ 7993 │ U9 │ │ 1 │ │ │ │
│ de:vvs:20008_:_1 │ 7993 │ U8 │ │ 1 │ │ │ │
│ de:vvs:20007_:_1 │ 7993 │ U7 │ │ 1 │ │ │ │
│ de:vvs:20006_:_1 │ 7993 │ U6 │ │ 1 │ │ │ │
│ de:vvs:20005_:_1 │ 7993 │ U5 │ │ 1 │ │ │ │
│ de:vvs:20004_:_1 │ 7993 │ U4 │ │ 1 │ │ │ │
│ de:vvs:20003_:_1 │ 7993 │ U3 │ │ 1 │ │ │ │
│ de:vvs:20002_:_1 │ 7993 │ U2 │ │ 1 │ │ │ │
│ de:vvs:20001_:_1 │ 7993 │ U1 │ │ 1 │ │ │ │
├──────────────────┴───────────┴──────────────────┴─────────────────┴────────────┴─────────────┴──────────────────┴────────────┤
│ 17 rows 8 columns │
└──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┘
Ich schließe daher diesen Eintrag.
Dass jedoch nur die Standard-Liste und nicht die extended-Liste umgesetzt wird, scheint zumindest Stand heute nicht mehr zu gelten @BeckertAnke , oder? Da der VVS selbst 402 verwendert, woher rührt der Wert 1?
select route_type, count(*) from routes group by route_type;
┌────────────┬──────────────┐
│ route_type │ count_star() │
│ int64 │ int64 │
├────────────┼──────────────┤
│ 0 │ 314 │
│ 1 │ 81 │
│ 2 │ 35 │
│ 3 │ 19754 │
│ 4 │ 73 │
│ 5 │ 15 │
│ 100 │ 201 │
│ 101 │ 72 │
│ 102 │ 72 │
│ 103 │ 8 │
│ 106 │ 592 │
│ 109 │ 209 │
│ 201 │ 355 │
│ 300 │ 88 │
│ 400 │ 9 │
│ 700 │ 6630 │
│ 900 │ 44 │
│ 1000 │ 8 │
├────────────┴──────────────┤
│ 18 rows 2 columns │
└───────────────────────────┘
Die GTFS-Kennungen der lokalen Organisationen werden leider nicht mit an den DELFI-Datenpool übertragen (gibt die Schnittstelle nicht her). Daher erfolgt beim Import der Daten eine manuelle Zuordnung der Verkehrsmittel auf die GTFS-Standardliste. Ausnahmen gibt es beim Fernverkehr (Schiene und Bus) sowie bei Bedarfsverkehren, wo durch uns eine Zuordnung auf die GTFS-Extended-Liste erfolgt.
Danke für die Erläuterung. In welcher Form werden die Verkehrsmittel über die Schnittstelle übertragen/welche Schnittstelle wird für die Übertragung genutzt?