CoP: Data Science: project to visualize the cities in LA county that offer public 311 data sets and how comprehensive they are

[ExperimentsInHonesty]

Overview

Hack for LA Leadership wants to publish a map to show the amount of 311 data available in the Greater LA area

Audiences for the map and chart

• Public: so that citizens in the Greater LA Metro Area can see which governments are sharing data
• 311 team: They will be using the data to see if adding 311 data sets from other cities is part of their product roadmap.
• general internal interest: so that we can decide what additional projects might come from the findings

Greater LA area defined by Wikipedia

Action Items

• [x] Make a spreadsheet of all cities and counties in the Greater LA Area.
  • [x] city_name
  • [x] county_name
  • [x] portal_url
  • [x] currently_publishing_311_data (true/false)
  • [x] 311_data_url (if there is a specific link - like a portal search string)
  • [x] reason_for_not_publishing (if they are not and have said why)
• [x] #135
• [x] Present this sheet at the Data Science meeting to members and leadership in case the resulting data calls for changes to the next steps.
• [ ] Create a Matrix that compares the schemas from all the 311 data sets, to identify what fields each contains with a taxonomy table if necessary
• [ ] Create a plan with the Data Science team to create an appropriate visualization for the data.

Resources/Instructions

Spreadsheets of cities and counties in Greater LA http://www.harker.com/OpenData/socrata-data-portals.html https://data.ca.gov/ https://data.lacounty.gov/browse?q=311&sortBy=relevance

[akhaleghi]

Created a spreadsheet that includes all cities in Los Angeles, Orange, and Ventura Counties. Need to define which shouldn't be included here, as well as define which (if any) cities in San Bernadino and Riverside Counties should be included.

https://docs.google.com/spreadsheets/d/1Vjmof0CfFPGyWDlDbChc_hk1MF6pSdGEwcFcAMeQCIQ/edit?usp=sharing

[akhaleghi]

@meganghaz, please provide an update on this issue (or let me know if you are no longer working on it)

Progress: "What is the current status of your project? What have you completed and what is left to do?" Blockers: "Difficulties or errors encountered." Availability: "How much time will you have this week to work on this issue?" ETA: "When do you expect this issue to be completed?" Pictures (if necessary): "Add any pictures that will help illustrate what you are working on."

[ExperimentsInHonesty]

@meganghaz, Please provide update

1. Progress: "What is the current status of your project? What have you completed and what is left to do?"
2. Blockers: "Difficulties or errors encountered."
3. Availability: "How much time will you have this week to work on this issue?"
4. ETA: "When do you expect this issue to be completed?"
5. Pictures (if necessary): "Add any pictures that will help illustrate what you are working on."

[akhaleghi]

@meganghaz There haven't been any updates on this issue so we're going to move it to the backlog. Let me know if you'd like to continue working on it.

[akhaleghi]

@mru-hub please update this issue when you have a chance to document your progress @Lalla22 are you still involved with this issue?

[mru-hub]

Our quest to identify cities and counties in the Greater LA Area that are currently publishing 311 data, and to document all the 311 public datasets (hosting website information and URLs), has encountered significant obstacles. Unfortunately, we have been unable to locate any readily available resources hosting this data.

Initially, we attempted to contact city councils directly, but we were met with the requirement to submit public record request forms to each individual city council. This approach, however, might not be the perfect solution.

After discussing with other members of the team, we have made a collective decision: if we cannot readily find the data or if it is not publicly accessible, we will update our Excel file to indicate its absence.

[ExperimentsInHonesty]

This was a project to visualize the coverage of the publicly available data sets. I don't see a visualization in this issue. So why is the issue closed?