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

• Make a spreadsheet of all cities and counties in the Greater LA Area.
  • city_name
  • county_name
  • portal_url
  • currently_publishing_311_data (true/false)
  • 311_data_url (if there is a specific link - like a portal search string)
  • reason_for_not_publishing (if they are not and have said why)
• CoP: Data Science: Find and document all the 311 public data sets #135
• 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