Add reporting on city councils

[mattyweb]

Dependency

post v2 get District Types API from Data Science community of practice https://github.com/hackforla/data-science/issues/118

Overview

The goal of this feature is for users to be able to report on service requests within their City Council districts.

Assumptions

1. city will provide city council geometries in a single GeoJSON file
2. city councils will have a name and a shape
3. we can use this: https://geohub.lacity.org/datasets/la-city-council-districts-adopted-2012

Development Work

• [ ] Add city council table with ids/names (similar to the new councils table) | Backend | Need to modify migration that currently creates the councils table.
• [ ] New migration to add geometries for city councils | Backend | We currently have long and lat columns and i think need to transform these into points
• [ ] Add metadata endpoint for city councils (similar to the new councils endpoint) | Backend |  
• [ ] New city council open-requests/counts endpoints | Backend | Not clear yet whether the counts would be included in /open-requests or would come from a separate endpoint
• [ ] Modify /comparison endpoints and underlying services to accept list of city councils | Backend | Do we need city councils in the comparison reports? They are not uniform, contiguous, etc.
• [ ] Include city council metadata in data we initially load from server | Frontend | This would be included in the general refactor we've been discussing where we load metadata from the API, and store it in redux, rather than taking it from a constants file
• [ ] Add city council geojson to map as another layer | Frontend |  
• [ ] Modify comparison-tool dropdowns to allow city council selection | Frontend |  

Resources

From the city of LA's open data website Business Improvement Districts Map Interface A business improvement district is a geographically defined area within the City of Los Angeles, in which services, activities and programs are paid for through a special assessment which is charged to all members within the district in order to equitably distribute the benefits received and the costs incurred to provide the agreed-upon services, activities and programs. The assessment money is collected by the City or by the County through a special contractual arrangement with the city. Because the assessment funds collected in a given district cannot legally be spent outside of that BID, the City creates a trust fund for each BID, with funds periodically released to support operations.

[mattyweb]

Some commentary here: I'm not sure the value of including city councils is worth the confusion they cause. City councils do not share borders with Neighborhoods. That is, part of a Neighborhood A will be in City Council X and part will be in City Council Y. It's really a completely different way of mapping onto the data. Given more work to support both, supporting both would add confusion and our target is neighborhood councils it seems that just including Neighborhoods would be the better choice.

[github-actions[bot]]

This issue is stale because it has been open 90 days with no activity. Remove stale label or comment or this will be closed in X days.

[EchoProject]

Adding this Issue to items for review for the product roadmap.