Work in Progress: Location History of Almost All CARTA Buses and Shuttles!
Dataset Loaded into QGIS with an OpenStreetMap Background
We needed high resolution historical data on where our buses were. It's very important to scheduling, troubleshooting issues, and performance management.
The pipeline runs approximately every hour.
| column | example | description |
|---|---|---|
| vehicle_id | "0135" |
The 4-letter unique internal identifier for the specific vehicle. |
| timestamp | 1775438284 |
The number of seconds since the epoch in Unix time. |
| latitude | 35.0577 |
The North-South geographic coordinate of the vehicle. |
| longitude | -85.2691 |
The East-West geographic coordinate of the vehicle. |
| geometry | GEOMETRY('OGC:CRS84') |
The special geometry column only used in the data.parquet file |
- You can query the data with SQL using duckdb.
Post an issue here or email the package author at [email protected].