Enhanced Zip Code Validation

DataKind-DC / CARES

US CARES Act Payment Protection Program data, cleaned for analysis

GNU General Public License v3.0

6 stars 7 forks source link

Enhanced Zip Code Validation #2

Open kbmorales opened 4 years ago

kbmorales commented 4 years ago

posted by @JohnMcCambridge

[ ] check that zip codes are real, not just of proper format
[ ] check that the zip code, state field, are aligned
[ ] check that zip code, state field, city name, state file name, and congressional district field are all in alignment.

JohnMcCambridge commented 4 years ago

Sourcing a free, up to date zip code list may be more difficult than anticipated. See for example https://github.com/DataKind-DC/CARES/blob/5238db70941040db7ed49c8f957b605a18e4a5ab/code/data_dictionary.R#L48 for an attempt to use a list from simplemaps.com which might in fact just be based on the rather old ZCTA list from Census.

MDshuey commented 4 years ago

I've done geospatial "spot-checks" to see if points lie within the right areas (for example, administrative division with GADM shapefiles ). If other quality shapefiles exist we can overlay them, maybe this one for zip

Edit: To clarify, we could use this data to cross-check zip codes that a) they exist and are in the correct b) State and c) County