Frank Purcell

I just tried gtfsdb with the Sherbrooke gtfs, and I do see both problems with sqlite. Things work fine with Postgres. (UTF-8 issues look similar to issues with MS Sql...

I used the link above, Xavier. bin/gtfsdb-load --database_url sqlite:///gtfs.db https://www.donneesquebec.ca/recherche/dataset/e82b9141-09d8-4f85-af37-d84937bc2503/resource/b7f43b2a-2557-4e3b-ba12-5a5c6d4de5b1/download/gtfssherbrooke.zip sqlalchemy.exc.ProgrammingError: (pysqlite2.dbapi2.ProgrammingError) You must not use 8-bit bytestrings unless you use a text_factory that can interpret 8-bit bytestrings (like text_factory...

RE: trimet.org GTFS not working with SQLite: Use the --ignore_blocks flags (will skip creating a roll-up view of trips assigned to a block). bin/gtfsdb-load --database_url sqlite:///gtfs.db --ignore_blocks http://developer.trimet.org/schedule/gtfs.zip

This shouldn't be the case, and it wasn't the case in years past. That said, I've recently seen similar issues on Windows. Ever since upgrading setup tools and buildout (needed...

GTFS for The Netherlands loads for me with the Postgres / Postgis database: bin/gtfsdb-load --database_url postgresql://postgres@localhost:5432 --is_geospatial http://gtfs.ovapi.nl/new/gtfs-nl.zip Not sure what's needed to support the MS database, but willing to...

I've got a TODO item to add some route info involving multi-byte names from gtfs-nl to gtfsdb's test data, since the actual gtfs-nl.zip is a bit big for testing.

No idea where Cherriots is hosting/hiding their GTFS data now. It's got to be somewhere, since their main trip planner is Google Transit. I'm asking folks who've done work in...

BTW, the new page for Cherriots' gtfs data: https://www.cherriots.org/data/ And the link to their gtfs is: https://www.cherriots.org/media/doc/salem-or-us.zip

An alternative approach (if you don't need updates more frequently than once per minute): launch a new process via cron for each update. I have a cron job that launches...

> > is there an arg for it Doh!, that would help. I just pushed a commit with the -1 or --once flag to iterate the loop a single time.