Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[FEAT] Load council geometries and serve geojson from API #909

Closed
mattyweb opened this issue Jan 26, 2021 · 0 comments · Fixed by #910 or #911
Closed

[FEAT] Load council geometries and serve geojson from API #909

mattyweb opened this issue Jan 26, 2021 · 0 comments · Fixed by #910 or #911
Assignees
Labels
Size: 5pt Can be done in 19-30 hours

Comments

@mattyweb
Copy link
Collaborator

Description

Want to load the current GeoJSON into the database and create and endpoint that will serve it up from the API.

The immediate benefit is that the client won't need to bundle the (huge) file and we'll be able to update the GeoJSON without needing new client releases.

The longer term benefits are that we'll be able to do spatial queries in the app (e.g. calculate centroids, query for points by distance, etc.). We will also be able to automate the process of downloading the new GeoJSON when there are changes.

Action Items

  1. Need to use postgis docker image
  2. Need to enable postgis extension with alembic
  3. Need to load a table with geometry (MULTIPOLYGON) from current GeoJSON
  4. Need to add model and ORM query
  5. Need to add endpoint

Resources

https://geoalchemy-2.readthedocs.io/en/latest/orm_tutorial.html
https://geohub.lacity.org/datasets/neighborhood-councils-certified/
https://postgis.net/docs/reference.html#Geometry_Accessors
https://github.com/jgriffith23/postgis-tutorial

@mattyweb mattyweb added the Size: 5pt Can be done in 19-30 hours label Jan 26, 2021
@mattyweb mattyweb self-assigned this Jan 26, 2021
@mattyweb mattyweb added this to the Initial v2 Launch milestone Feb 9, 2021
@ExperimentsInHonesty ExperimentsInHonesty moved this to Done (without merge) in P: 311: Project Board Jun 7, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Size: 5pt Can be done in 19-30 hours
Projects
Status: Done (without merge)
Development

Successfully merging a pull request may close this issue.

1 participant