codeformilwaukee / WeCountCovid19

A repository for analyzing the WeCountCovid19.com survey
http://www.WeCountCOVID19.com
GNU General Public License v3.0
10 stars 1 forks source link

Zip-to-MKE neighborhoods #16

Closed AntonellaAzzarello closed 4 years ago

AntonellaAzzarello commented 4 years ago

On the 4/4/2020 call, it was mentioned that neighborhood names may mean more to the community than zip codes. Couple options were discussed (please add if I missed any)

  1. Find a online resource that has zip codes to MKE neighborhoods
  2. Perhaps a person or persons knows the MKE neighborhoods so well, they may be able to provide this clarification/identification.
  3. [Insert new ideas]
AntonellaAzzarello commented 4 years ago

I had initially found this resource, but have not previously used it nor validated it.

BarkleyBG commented 4 years ago

Nice find!

BarkleyBG commented 4 years ago

You may get good feedback if you join the Milwaukee Slack and go to the code-for-mke channel, and then post a question there. I am not sure if other people have looked for this info before.

Aycrazy commented 4 years ago

You may find this repo with crosswalks made by our upcoming hack night presenter John Johnson helpful ;) https://github.com/jdjohn215/Milwaukee-Geo-Crosswalks

It's not zips. But census tract level info could be helpful at some pt for your analysis

Aycrazy commented 4 years ago

I'm also very confident that I can make you this crosswalk with geopandas or R. If someone is already taking this on, i'm happy to just coach them through it so they can learn

Aycrazy commented 4 years ago

Something you may want to consider is whether you want Zipcode of ZCTAs (Zip Code Tabulated Areas) -- these are meant to be more-or-less standard across time, where as zipcodes change. They also are meant for easier alignment with census data at the census track or block level. County ZCTA shapefile can be found here: http://gis-mclio.opendata.arcgis.com/datasets/zip-code-tabulation-areas-zcta

Alternatively, here is the Census Tiger Zip Shapefile from 2017. https://catalog.data.gov/dataset/tiger-line-shapefile-2017-county-milwaukee-county-wi-topological-faces-polygons-with-all-geocod

Aycrazy commented 4 years ago

You can use this google map Wisconsin Voices Made for the census with a zip code layer I added called (zipcodes) to see the relationship between zips and neighborhoods (they don't always align).

Here is a link to ascertain which neighborhoods fall into which zipcodes: https://github.com/Aycrazy/undercounted_map/blob/master/nhood_x_zip.geoJson -- geo json https://github.com/Aycrazy/undercounted_map/blob/master/nhood_x_zip.zip -- shapefile

BarkleyBG commented 4 years ago

assigning to Luke

BarkleyBG commented 4 years ago

Closing and moving to #46