sfcta/cycletracks-crusher — pull request #1 by frproulx (2014-08-04 03:42:44+00:00)
Title: Update cycletracks.py

Tried running this with 1000 first records in the San Francisco dataset and ran into some issues that seem to come back to the addition of the "notes" field. Hope this helps!

First is that it wasn't identifying the "trips" table. Changed line 80 to look for 'notes'
Second is that it predictably freaks out whenever a note has a comma. Added a "max splits" (9) argument to the string split in the Trip line tuple.
Third edited things so that the notes get added to the Trips output table.

Still getting a few exceptions which appear to trace back to one user, userid=192, whose zip codes are a garbled mess. Added exception handling to function printToFile to deal with this.