tsdataclinic / TREC

Transit Resilience for Essential Commuting (TREC)

https://trec.tsdataclinic.com/

Other

6 stars 2 forks source link

Adding an API server for map data #36

Closed indraneel closed 1 year ago

indraneel commented 1 year ago

30 will create a database of POIs/polygons. This issue will create an API layer for the UI to access those things as needed.

The API layer will serve two kinds of data:

all data (not geographic data) each row as JSON data
geographic data from each row as vector tiles

As part of this ticket, we can stick to FastAPI and use PostGIS functions directly for vector tile rendering: https://medium.com/nyc-planning-digital/using-the-new-mvt-function-in-postgis-75f8addc1d68

rough sketch of API endpoints needed:

get a list of all cities
for a given city:
- get all hospitals
- get all stops
- get all routes
- get flood layers

How will the API be used?

on load, load all data for a given city
send bounding box from UI to API and get back active city within bbox