computedtables

Overview ¶

Mobsql - Computed Tables Example:

• Loads a Mobility DB GTFS feed by specifying Mobility Database feed ID
• Subsequently computes a GTFS-derived table called
• Upon successful load, run in SQLite CLI:
• sqlite3 foo.db 'select * from _ctfoo'
• Note: this is the same mechanism Mobroute uses to create CSA connections tables and similar; you can use computed-tables to store application specific logic and build out GTFS-derived SQL tables automatically updated on compute cycles