bhelx/nola-transit

Figure out GTFS data problems

Opened this issue · 2 comments

bhelx commented

Gonna keep a list of things here. I'm discussing with the following people at transdev:

We are using the V version of the GTFS feed, folder name 20170101V.
The reason is it's the only one that passes the Google validator and has correct route short names.

Algiers Ferry calendar

The Service ids seem to suggest there are no weekday services. The trips on there route only have service ids (2,3,4,6).

Service 4

This service id has no days as well as 601

Service 601

Some trips on the Marigny/Bywater line have the service id 601. I'm assuming this is meant
to be service_id 1 for now so I updated db:

UPDATE trips
SET service_index = 1, service_id = 1
WHERE service_id = 601;

We should put this in the cleanup scripts and also confirm that it's removed from the calendar table.

Empty trip headsigns

Some trips have no headsign for some reason

This one here:

10490,6,2599638,Canal St. via General Meyers Ave. & Delgado Comm. College/Federal City,,0,1273027,48126
10490,6,2599639,,,0,1273028,48165
10490,6,2599640,Canal St. via General Meyers Ave. & Delgado Comm. College/Federal City,,0,1273027,48126

All of these:

10463,1,2584199,,,0,1272261,48022
10463,1,2584200,,,0,1272262,48022
10463,1,2584215,,,0,1272261,48022
10463,1,2584201,,,0,1272262,48022
10463,1,2584216,,,0,1272261,48022
10463,1,2584202,,,0,1272262,48022
10463,1,2584203,,,0,1272262,48022
10463,1,2584204,,,0,1272262,48022
10463,1,2584205,,,0,1272262,48022
10463,1,2584206,,,0,1272262,48022
10463,1,2584207,,,0,1272262,48022
10463,1,2584208,,,0,1272263,48022
10463,1,2584209,,,0,1272262,48022
10463,1,2584210,,,0,1272263,48022
10463,1,2584211,,,0,1272262,48022
10463,1,2584212,,,0,1272263,48022
10463,1,2584213,,,0,1272262,48022
10463,1,2584214,,,0,1272263,48022
10463,1,2584217,,,0,1272262,48022
10463,1,2584218,,,0,1272262,48022
10463,1,2584219,,,0,1272262,48022
10463,1,2584220,,,0,1272262,48022
10463,1,2584221,,,1,1272261,48023
10463,1,2584222,,,1,1272262,48023
10463,1,2584225,,,1,1272261,48023
10463,1,2584226,,,1,1272262,48023
10463,1,2584227,,,1,1272261,48023
10463,1,2584228,,,1,1272262,48023
10463,1,2584229,,,1,1272262,48023
10463,1,2584230,,,1,1272262,48023
10463,1,2584231,,,1,1272262,48023
10463,1,2584232,,,1,1272262,48023
10463,1,2584233,,,1,1272262,48023
10463,1,2584234,,,1,1272263,48023
10463,1,2584235,,,1,1272262,48023
10463,1,2584236,,,1,1272263,48023
10463,1,2584237,,,1,1272262,48023
10463,1,2584238,,,1,1272263,48023
10463,1,2584239,,,1,1272262,48023
10463,1,2584240,,,1,1272263,48023
10463,1,2584241,,,1,1272262,48023
10463,1,2584242,,,1,1272262,48023
10463,1,2584223,,,1,1272262,48023
10463,1,2584224,,,1,1272262,48023

These M.L. King trips

10466,1,2584881,,,0,1272295,48031
10466,1,2584882,,,0,1272296,48031
10466,1,2584883,,,0,1272295,48031
10466,1,2584884,,,0,1272296,48031
10466,1,2584885,,,0,1272295,48031
10466,1,2584886,,,0,1272296,48031
10466,1,2584887,,,0,1272295,48031
10466,1,2584888,,,0,1272296,48031
10466,1,2584889,,,0,1272295,48031
10466,1,2584890,,,0,1272296,48031
10466,1,2584891,,,0,1272295,48031
10466,1,2584892,,,0,1272296,48031
10466,1,2584893,,,0,1272295,48031
10466,1,2584894,,,0,1272296,48031
10466,1,2584895,,,0,1272295,48031
10466,1,2584896,,,0,1272296,48031
10466,1,2584897,,,0,1272295,48031
10466,1,2584898,,,0,1272296,48031
10466,1,2584899,,,0,1272295,48031
10466,1,2584900,,,0,1272296,48031
10466,1,2584901,,,0,1272295,48031
10466,1,2584902,,,0,1272296,48031
10466,1,2584903,,,0,1272296,48031
10466,1,2584904,,,0,1272296,48031
10466,1,2584905,,,1,1272295,48034
10466,1,2584906,,,1,1272296,48034
10466,1,2584907,,,1,1272295,48034
10466,1,2584908,,,1,1272296,48034
10466,1,2584909,,,1,1272295,48034
10466,1,2584910,,,1,1272296,48034
10466,1,2584911,,,1,1272295,48034
10466,1,2584912,,,1,1272296,48034
10466,1,2584913,,,1,1272295,48034
10466,1,2584914,,,1,1272296,48034
10466,1,2584915,,,1,1272295,48034
10466,1,2584916,,,1,1272296,48034
10466,1,2584917,,,1,1272295,48034
10466,1,2584918,,,1,1272296,48034
10466,1,2584919,,,1,1272295,48034
10466,1,2584920,,,1,1272296,48034
10466,1,2584921,,,1,1272295,48034
10466,1,2584922,,,1,1272296,48034
10466,1,2584923,,,1,1272295,48034
10466,1,2584924,,,1,1272296,48034
10466,1,2584925,,,1,1272295,48034
10466,1,2584926,,,1,1272296,48034
10466,1,2584927,Dorgenois and Washington Avenue,,1,1272295,48033
10466,1,2584928,,,1,1272296,48034
10466,1,2584929,,,1,1272296,48034
10466,1,2584930,Dorgenois and Washington Avenue,,1,1272296,48033

Route 55?

10475,1,2588696,,,0,1272455,48072
10475,1,2588697,,,0,1272456,48072
10475,1,2588698,,,0,1272455,48072
10475,1,2588699,,,0,1272456,48072
10475,1,2588700,,,0,1272455,48072
10475,1,2588701,,,0,1272456,48072
10475,1,2588702,,,0,1272455,48072
10475,1,2588703,,,0,1272456,48072
10475,1,2588704,,,0,1272455,48072
10475,1,2588705,,,0,1272456,48072
10475,1,2588706,,,0,1272455,48072
10475,1,2588707,,,0,1272456,48072
10475,1,2588708,,,0,1272455,48072
10475,1,2588709,,,0,1272456,48072
10475,1,2588710,,,0,1272455,48072
10475,1,2588711,,,0,1272456,48072
10475,1,2588712,,,0,1272455,48072
10475,1,2588713,,,0,1272456,48072
10475,1,2588714,,,0,1272455,48072
10475,1,2588715,,,0,1272456,48072
10475,1,2588716,,,0,1272455,48072
10475,1,2588717,,,0,1272456,48072
10475,1,2588718,,,0,1272455,48072
10475,1,2588719,,,0,1272456,48072
10475,1,2588720,,,0,1272455,48072
10475,1,2588721,,,0,1272456,48072
10475,1,2588722,,,0,1272455,48072
10475,1,2588723,,,0,1272457,48072
10475,1,2588724,,,0,1272457,48072
10475,1,2588725,,,0,1272457,48072
10475,1,2588726,,,0,1272457,48072
10475,1,2588727,,,0,1272457,48072
10475,1,2588728,,,0,1272457,48072
10475,1,2588729,,,0,1272457,48072
10475,1,2588730,,,0,1272457,48072
10475,1,2588731,University of New Orleans,,1,1272455,48074
10475,1,2588732,,,1,1272456,48075
10475,1,2588733,,,1,1272455,48075
10475,1,2588734,,,1,1272456,48075
10475,1,2588735,,,1,1272455,48075
10475,1,2588736,,,1,1272456,48075
10475,1,2588737,,,1,1272455,48075
10475,1,2588738,,,1,1272456,48075
10475,1,2588739,,,1,1272455,48075
10475,1,2588740,,,1,1272456,48075
10475,1,2588741,,,1,1272455,48075
10475,1,2588742,,,1,1272456,48075
10475,1,2588743,,,1,1272455,48075
10475,1,2588744,,,1,1272456,48075
10475,1,2588745,,,1,1272455,48075
10475,1,2588746,,,1,1272456,48075
10475,1,2588747,,,1,1272455,48075
10475,1,2588748,,,1,1272456,48075
10475,1,2588749,,,1,1272455,48075
10475,1,2588750,,,1,1272456,48075
10475,1,2588751,,,1,1272455,48075
10475,1,2588752,,,1,1272456,48075
10475,1,2588753,,,1,1272455,48075
10475,1,2588754,,,1,1272456,48075
10475,1,2588755,,,1,1272455,48075
10475,1,2588756,,,1,1272456,48075
10475,1,2588757,,,1,1272455,48075
10475,1,2588758,,,1,1272457,48075
10475,1,2588759,,,1,1272455,48075
10475,1,2588760,,,1,1272457,48075
10475,1,2588761,,,1,1272457,48075
10475,1,2588762,,,1,1272457,48075
10475,1,2588763,,,1,1272457,48075
10475,1,2588764,,,1,1272457,48075
10475,1,2588765,,,1,1272457,48075
10475,1,2588766,,,1,1272457,48075

Route 90:

10485,1,2591396,S. Claiborne Avenue via Carrollton Avenue,,0,1272628,48108
10485,1,2591397,,,0,1272627,48161
10485,1,2591398,,,0,1272628,48161
10485,1,2591399,,,0,1272627,48161
10485,1,2591400,,,0,1272628,48161
10485,1,2591401,,,0,1272627,48161
10485,1,2591402,,,0,1272627,48161
10485,1,2591403,,,0,1272627,48161
10485,1,2591404,,,0,1272627,48161
10485,1,2591405,,,0,1272627,48161
10485,1,2591406,,,0,1272627,48161
10485,1,2591407,,,0,1272629,48161
10485,1,2591408,,,0,1272627,48161
10485,1,2591409,,,0,1272629,48161
10485,1,2591410,,,0,1272627,48161
10485,1,2591411,,,0,1272629,48161
10485,1,2591412,,,0,1272627,48161
10485,1,2591413,S. Claiborne Avenue via Carrollton Avenue,,0,1272629,48108

This one on route 101:

10489,1,2592454,Canal Street via O'Keefe Ave. and Loyola Ave.,,0,1272705,48122
10489,1,2592455,,,0,1272705,48163
10489,1,2592456,Canal Street via O'Keefe Ave. and Loyola Ave.,,0,1272705,48122

This one on route 202:

10496,1,2593659,,,0,1272578,48156
10496,1,2593654,"Canal Street, New Orleans",,0,1272784,48155
10496,1,2593660,"Canal Street, New Orleans",,0,1272787,48155

This one on route 65:

10481,6,2590397,Canal Street via Crowder Blvd. and Read Blvd.,,0,1272547,48098
10481,6,2590409,,,0,1272553,48099
10481,6,2590398,Canal Street via Crowder Blvd. and Read Blvd.,,0,1272548,48098

Marigny / Bywater shape

Seems like maybe we are missing a point for this shape:

screen shot 2017-04-08 at 4 20 58 pm

bhelx commented

Current GTFS used is 2018-Winter B - V. Still some calendar problems but slightly better than the last one.

bhelx commented

I've yet to get a reply from any of the people managing GTFS.