An application for documenting, researching, querying, and maintaining the trees of NYC's streets.
Database side
- Evaluate Graphql
- Give up on graphql
- Use postgresql w/ postGIS, for using our #geospatialData
- Figure out how to programmatically load the tree census data into a postregsql instance that has postGIS enabled. We'll probably need to transform the geospatial data into some specially named columns.
Backend side
- Create an api server wrapping postgresql, to answer basic queries:
- Geospatial queries
- What are the closest trees, given this address?
- What are the closest trees, given this latitude/longitude?
- What's the closest tree of X specie?
- Aggregation queries
- How many trees are there of X specie?
- What is the most commonly-occurring tree specie in NYC?
- What is the most commonly-occurring tree specie in X borough?
- What is the most commonly-occurring tree specie on X street?
- Zoom+enhance queries
- Tell me more about this specific tree
- Geospatial queries
Frontend side
- Evaluate flutter
- Just write the app!