derhuerst/vbb-gtfs

GTFS data for Berlin & Brandenburg public transport (VBB).

VBB public transport data

Deprecated. Please download from vbb-gtfs.jannisr.de.

---

This is was open GTFS data for the Berlin Brandenburg public transport service (VBB), published as CC BY 3.0 on the Berlin Open Data website.

I do not own this data, it is owned by VBB Verkehrsverbund Berlin-Brandenburg GmbH. VBB claims it is valid from end of August to December 2016, although they often break this promise.

vbb-gtfs's Issues

stops.txt contains three leading bytes which do not belong there

The October dataset's stop_times.txt references a lot of stations that do not exist in stops.txt.

Parts of the build log of vbb-stations, taken every 100k lines:

Unknown station 130000080002 at stop_times.txt arrival with trip ID 77013114 sequence # 0
Unknown station 130000080011 at stop_times.txt arrival with trip ID 77013114 sequence # 1
Unknown station 130000080341 at stop_times.txt arrival with trip ID 77013114 sequence # 2
Unknown station 130000088241 at stop_times.txt arrival with trip ID 77013114 sequence # 3
Unknown station 130000080361 at stop_times.txt arrival with trip ID 77013114 sequence # 4
Unknown station 130000080351 at stop_times.txt arrival with trip ID 77013114 sequence # 5
Unknown station 130000082651 at stop_times.txt arrival with trip ID 77013114 sequence # 6
Unknown station 130000082661 at stop_times.txt arrival with trip ID 77013114 sequence # 7
Unknown station 130000082671 at stop_times.txt arrival with trip ID 77013114 sequence # 8
Unknown station 130000082681 at stop_times.txt arrival with trip ID 77013114 sequence # 9

Unknown station 250000006802 at stop_times.txt arrival with trip ID 76976464 sequence # 15
Unknown station 250000008402 at stop_times.txt arrival with trip ID 76976464 sequence # 16
Unknown station 250000000402 at stop_times.txt arrival with trip ID 76976464 sequence # 17
Unknown station 250000000601 at stop_times.txt arrival with trip ID 76976464 sequence # 18
Unknown station 250000002801 at stop_times.txt arrival with trip ID 76976464 sequence # 19
Unknown station 250000002001 at stop_times.txt arrival with trip ID 76976464 sequence # 20
Unknown station 250000000201 at stop_times.txt arrival with trip ID 76976464 sequence # 21
Unknown station 250000001401 at stop_times.txt arrival with trip ID 76976464 sequence # 22
Unknown station 250000001301 at stop_times.txt arrival with trip ID 76976464 sequence # 23
Unknown station 250000000702 at stop_times.txt arrival with trip ID 76976464 sequence # 24

Unknown station 100000621802 at stop_times.txt arrival with trip ID 76961184 sequence # 3
Unknown station 100000620702 at stop_times.txt arrival with trip ID 76961184 sequence # 4
Unknown station 100000621401 at stop_times.txt arrival with trip ID 76961184 sequence # 5
Unknown station 100000620901 at stop_times.txt arrival with trip ID 76961184 sequence # 6
Unknown station 100000622902 at stop_times.txt arrival with trip ID 76961184 sequence # 7
Unknown station 100000620601 at stop_times.txt arrival with trip ID 76961184 sequence # 8
Unknown station 100000620501 at stop_times.txt arrival with trip ID 76961184 sequence # 9
Unknown station 100000634102 at stop_times.txt arrival with trip ID 76961184 sequence # 10
Unknown station 100000634002 at stop_times.txt arrival with trip ID 76961184 sequence # 11
Unknown station 100000595602 at stop_times.txt arrival with trip ID 76961184 sequence # 12

Unknown station 270000042302 at stop_times.txt arrival with trip ID 79044265 sequence # 16
Unknown station 270000030702 at stop_times.txt arrival with trip ID 79044265 sequence # 17
Unknown station 270000000902 at stop_times.txt arrival with trip ID 79044265 sequence # 18
Unknown station 270000039202 at stop_times.txt arrival with trip ID 79044265 sequence # 19
Unknown station 270000010302 at stop_times.txt arrival with trip ID 79044265 sequence # 20
Unknown station 270000035102 at stop_times.txt arrival with trip ID 79044265 sequence # 21
Unknown station 270000040002 at stop_times.txt arrival with trip ID 79044265 sequence # 22
Unknown station 270000040902 at stop_times.txt arrival with trip ID 79044265 sequence # 23
Unknown station 270000039502 at stop_times.txt arrival with trip ID 79044265 sequence # 24
Unknown station 270000004702 at stop_times.txt arrival with trip ID 79044265 sequence # 25

Unknown station 060024102372 at stop_times.txt arrival with trip ID 78860513 sequence # 18
Unknown station 060180001834 at stop_times.txt arrival with trip ID 78860512 sequence # 0
Unknown station 060180002824 at stop_times.txt arrival with trip ID 78860512 sequence # 1
Unknown station 060162001814 at stop_times.txt arrival with trip ID 78860512 sequence # 2
Unknown station 060160002804 at stop_times.txt arrival with trip ID 78860512 sequence # 3
Unknown station 060160001001 at stop_times.txt arrival with trip ID 78860512 sequence # 4
Unknown station 060120003652 at stop_times.txt arrival with trip ID 78860512 sequence # 5
Unknown station 060120004621 at stop_times.txt arrival with trip ID 78860512 sequence # 6
Unknown station 060120005010 at stop_times.txt arrival with trip ID 78860512 sequence # 7
Unknown station 060100004704 at stop_times.txt arrival with trip ID 78860512 sequence # 8

Find the full log here: errlog.gz

weird route "S" "by DB Regio AG"

cat routes.txt | grep '^853,'

853,N04---,S,,,109,http://www.vbb.de,,

cat agency.txt | grep '^N04---,'

N04---,DB Regio AG,http://www.bahn.de/brandenburg,Europe/Berlin,de,0331 2356881

weird route "Ausfl" by "DB Regio AG"

cat routes.txt | grep '^767,'

767,N01---,Ausfl,,,100,http://www.vbb.de,,

cat agency.txt | grep '^N04---,'

N01---,DB Regio AG,http://www.bahn.de/brandenburg,Europe/Berlin,de,0331 2356881

calendar_dates contains an invalid service_id

calendar_dates.txt contains a service_id of 000000 in the lines 166312 to 166573:

000000,20160324,1
000000,20160325,1
000000,20160326,1
000000,20160327,1
000000,20160328,1
000000,20160329,1
000000,20160330,1
000000,20160331,1
000000,20160401,1
000000,20160402,1
000000,20160403,1
000000,20160404,1
000000,20160405,1
000000,20160406,1
000000,20160407,1
000000,20160408,1
000000,20160409,1
000000,20160410,1
000000,20160411,1
000000,20160412,1
000000,20160413,1
000000,20160414,1
000000,20160415,1
000000,20160416,1
000000,20160417,1
000000,20160418,1
000000,20160419,1
000000,20160420,1
000000,20160421,1
000000,20160422,1
000000,20160423,1
000000,20160424,1
000000,20160425,1
000000,20160426,1
000000,20160427,1
000000,20160428,1
000000,20160429,1
000000,20160430,1
000000,20160501,1
000000,20160502,1
000000,20160503,1
000000,20160504,1
000000,20160505,1
000000,20160506,1
000000,20160507,1
000000,20160508,1
000000,20160509,1
000000,20160510,1
000000,20160511,1
000000,20160512,1
000000,20160513,1
000000,20160514,1
000000,20160515,1
000000,20160516,1
000000,20160517,1
000000,20160518,1
000000,20160519,1
000000,20160520,1
000000,20160521,1
000000,20160522,1
000000,20160523,1
000000,20160524,1
000000,20160525,1
000000,20160526,1
000000,20160527,1
000000,20160528,1
000000,20160529,1
000000,20160530,1
000000,20160531,1
000000,20160601,1
000000,20160602,1
000000,20160603,1
000000,20160604,1
000000,20160605,1
000000,20160606,1
000000,20160607,1
000000,20160608,1
000000,20160609,1
000000,20160610,1
000000,20160611,1
000000,20160612,1
000000,20160613,1
000000,20160614,1
000000,20160615,1
000000,20160616,1
000000,20160617,1
000000,20160618,1
000000,20160619,1
000000,20160620,1
000000,20160621,1
000000,20160622,1
000000,20160623,1
000000,20160624,1
000000,20160625,1
000000,20160626,1
000000,20160627,1
000000,20160628,1
000000,20160629,1
000000,20160630,1
000000,20160701,1
000000,20160702,1
000000,20160703,1
000000,20160704,1
000000,20160705,1
000000,20160706,1
000000,20160707,1
000000,20160708,1
000000,20160709,1
000000,20160710,1
000000,20160711,1
000000,20160712,1
000000,20160713,1
000000,20160714,1
000000,20160715,1
000000,20160716,1
000000,20160717,1
000000,20160718,1
000000,20160719,1
000000,20160720,1
000000,20160721,1
000000,20160722,1
000000,20160723,1
000000,20160724,1
000000,20160725,1
000000,20160726,1
000000,20160727,1
000000,20160728,1
000000,20160729,1
000000,20160730,1
000000,20160731,1
000000,20160801,1
000000,20160802,1
000000,20160803,1
000000,20160804,1
000000,20160805,1
000000,20160806,1
000000,20160807,1
000000,20160808,1
000000,20160809,1
000000,20160810,1
000000,20160811,1
000000,20160812,1
000000,20160813,1
000000,20160814,1
000000,20160815,1
000000,20160816,1
000000,20160817,1
000000,20160818,1
000000,20160819,1
000000,20160820,1
000000,20160821,1
000000,20160822,1
000000,20160823,1
000000,20160824,1
000000,20160825,1
000000,20160826,1
000000,20160827,1
000000,20160828,1
000000,20160829,1
000000,20160830,1
000000,20160831,1
000000,20160901,1
000000,20160902,1
000000,20160903,1
000000,20160904,1
000000,20160905,1
000000,20160906,1
000000,20160907,1
000000,20160908,1
000000,20160909,1
000000,20160910,1
000000,20160911,1
000000,20160912,1
000000,20160913,1
000000,20160914,1
000000,20160915,1
000000,20160916,1
000000,20160917,1
000000,20160918,1
000000,20160919,1
000000,20160920,1
000000,20160921,1
000000,20160922,1
000000,20160923,1
000000,20160924,1
000000,20160925,1
000000,20160926,1
000000,20160927,1
000000,20160928,1
000000,20160929,1
000000,20160930,1
000000,20161001,1
000000,20161002,1
000000,20161003,1
000000,20161004,1
000000,20161005,1
000000,20161006,1
000000,20161007,1
000000,20161008,1
000000,20161009,1
000000,20161010,1
000000,20161011,1
000000,20161012,1
000000,20161013,1
000000,20161014,1
000000,20161015,1
000000,20161016,1
000000,20161017,1
000000,20161018,1
000000,20161019,1
000000,20161020,1
000000,20161021,1
000000,20161022,1
000000,20161023,1
000000,20161024,1
000000,20161025,1
000000,20161026,1
000000,20161027,1
000000,20161028,1
000000,20161029,1
000000,20161030,1
000000,20161031,1
000000,20161101,1
000000,20161102,1
000000,20161103,1
000000,20161104,1
000000,20161105,1
000000,20161106,1
000000,20161107,1
000000,20161108,1
000000,20161109,1
000000,20161110,1
000000,20161111,1
000000,20161112,1
000000,20161113,1
000000,20161114,1
000000,20161115,1
000000,20161116,1
000000,20161117,1
000000,20161118,1
000000,20161119,1
000000,20161120,1
000000,20161121,1
000000,20161122,1
000000,20161123,1
000000,20161124,1
000000,20161125,1
000000,20161126,1
000000,20161127,1
000000,20161128,1
000000,20161129,1
000000,20161130,1
000000,20161201,1
000000,20161202,1
000000,20161203,1
000000,20161204,1
000000,20161205,1
000000,20161206,1
000000,20161207,1
000000,20161208,1
000000,20161209,1
000000,20161210,1

weird station IDs

curl -s 'https://vbb-gtfs.jannisr.de/latest/stops.txt' | grep '^M'

M000008010088,"","Dresden-Klotzsche",,"51.114667000000","13.789110000000",1,
M000008000058,"","Büchen",,"53.474972000000","10.623298000000",1,
M000008003774,"","Lübeck St Jürgen",,"53.842321000000","10.702942000000",1,

IDs beginning with M might break lots of things, because

• their IDs are longer than usual and some libs have no other choice than taking the ID length as a heuristic
• usually IDs have numeric digits only

lines exist more than once

S5:

curl -s 'https://vbb-gtfs.jannisr.de/latest/routes.txt' | grep '"S5"'
# 10157_109,1,"S5","",109,"","",""
# 10158_109,1,"S5","",109,"","",""
# 10159_109,1,"S5","",109,"","",""
# 10160_109,1,"S5","",109,"","",""
# 10456_700,1,"S5","",700,"","",""
# 16034_109,1,"S5","",109,"","",""
# 16564_109,1,"S5","",109,"","",""

S75:

curl -s 'https://vbb-gtfs.jannisr.de/latest/routes.txt' | grep '"S75"'
# 10165_109,1,"S75","",109,"","",""
# 10166_109,1,"S75","",109,"","",""

As noted in derhuerst/generate-vbb-graph#3.