311Data: 311 request types with no council (councilId=0) assigned to it

[priyakalyan]

Overview

We need to take a look at all the 311 request type data with no council id or council name assigned to it. In the 311 data server, the councilId has been assigned as 0 and the councilName as 'No Council' for such request types.

Action Items

• Determine if all of the 'No Council' request types fall outside of the NC boundary.
• Check the pattern for the other years.
• Plot a histogram of all such request types.

Resources/Instructions

• Here is an interactive plot of 311 request with no council id for the year 2021- noCouncil. The 311 data is obtained by making an API call to LA 311 Data API, fetching all rows of data for the year 2021.
• The link to the neighborhood council shape file is here.
• The link to the metro rail stops shape file is here
• tools: google colab, geopandas, pandas, folium

[EchoProject]

Hi @priyakalyan, is this issue still relevant? If so, could you provide an update?

[priyakalyan]

Hi @EchoProject, sorry for a late reply. Last time I checked, Zak was working on this issue. I have slacked him asking for an update. This issue was created to make sure that all the no council data were falling outside the NC boundary. If Zak is not working on it anymore, then I will look at it and close the issue.

[zaklang123]

Hi @EchoProject, I'm currently working on this issue. I'm making slow, but steady progress. I've just figured out how to use Geopandas and Folium, so I think I'm ready to start going through the action items.

[mc759]

@zaklang123 Do you have an update for us on this issue?

Please update:

• Progress:
• Blockers:
• Availability:
• ETA:

Thanks!

[zaklang123]

Hi,

I'm almost done with this issue. I just have the histogram part left to complete. I did try to contact EmpowerLA to understand why there are certain gaps in the neighborhood councils, but I have not heard back from them. I plan on having the project done early next year.

Thanks

[akhaleghi]

@zaklang123 is there any work left to be done on this issue?

[ExperimentsInHonesty]

Where is the histogram this issue was supposed to create?

[ryanfchase]

I think we can take this off the HfLA: Open Roles board, that might have been a mistake