shirchen / muni_analyzer Goto Github PK

Issue seems to be that some parts are captured in GMT, while we are querying in UTC, leading to inconsistent results.

Still pulling schedule using mysql in analyzer. Need to change that Postgres because I am using a separate library which automatically updates Muni schedule into Postgres format.

Two issues found:

• 4128445 | Thu Sep 8 20:13:00 2011 | Thu Sep 8 20:51:00 2011 | Missed or uncaptured run | Missed or uncaptured run | Missed or uncaptured run | | Debug
• Here we have a bus that started way early and was counted towards the previous trip, which is incorrect. Implementing realtime capture should solve this

Second issue:

• 4128439 | Thu Sep 8 20:28:00 2011 / 1315513680 | Thu Sep 8 21:06:00 2011 | Missed or uncaptured run | Missed or uncaptured run | Missed or uncaptured run | | Debug

Here it seems that the route was actually covered by bus_id 5463 but it did not originate at the starting point

• A solution is to keep truck of used trip_ids for a particular day and once it has been used -- remove it from available trips

Move the following code around:

• All code dealing with pulling and massaging schedule should go into its own class
• Same for code dealing with pulling all GPS data

Probably best to start with a rail line, like 'N' because of consistency of start and end points.

Lotsa work, but will make everything a ton easier. WIll look like:

• load a dictionary of all possible trips at runtime, then keep a queue into which we will add a trip that has started, and track it until it finished.

At the moment, before re-running analyze_data.py we need to delete the database of previous analysis, otherwise we get duplicate rows.
Proposed fixes:

• check existence of trip_id and start_time in the db before adding a row

• Change route to trip in schema and code

• Imprecise bounding boxes at the start and end points cause wrong schedules to be given out
• What to do about half-trips?
  • Could have dynamic trip allocation by recalculating the trips once they get to a certain point

Buses that are turned around before getting to end destination are not properly handled.

Should be marked as an incomplete route.