Home

SFCTA Prospector

We're building a data warehouse for SFCTA! Find all kinds of details and documentation about it here. The organization of this wiki is expected to evolve along with the progress of this medium-to-long term project.

Phase 1: Setup Data Warehouse and Visualization Infrastructure

The first phase of this project was implemented in May-June 2017. Several decisions about the technologies and architecture of this system were made especially in the context of CMP and Dynamic Transit Assignment (Fast-Trips) data. A PostgreSQL database backend was setup along with PostGREST restful API. Prototype visualizations were setup on Prospector. The effort culminated with the release of a map visualization of TNC trips in SF - TNCs Today Data Explorer.

Phase 2: CMP 2017 Visualizations

The main objective of the current phase will be to develop neat visualizations using CMP data and releasing them to the public along with CMP 2017 final report.