midwire / free_zipcode_data

Free US and world-wide postal codes in SQLite and CSV format
MIT License
86 stars 24 forks source link

Incorrect Zip Codes to County data mapping #3

Closed MOZGIII closed 5 years ago

MOZGIII commented 6 years ago

Expected Behavior

85602 zip code to have two counties.

85602,Benson,AZ,COCHISE,,32.035885,-110.262611
85602,Benson,AZ,PIMA,,...,...

There's no surjection between the set of zip codes and set of counties.

A somewhat helpful explanation of this fact in reality by census bureau: explanation_zcta_county_rel_10.pdf

The problem is generic, not just this zip code is affected. As I said, there's no surjection between the set of zip codes and set of counties in general.

Actual Behavior

85602 only has a single county: AZ, COCHISE.

85602,Benson,AZ,COCHISE,,32.035885,-110.262611

Steps to reproduce the problem

  1. Look into the data.
  2. Look at here: https://www2.census.gov/geo/pdfs/maps-data/data/rel/explanation_zcta_county_rel_10.pdf

midwire commented 6 years ago

@MOZGIII thanks for reporting this. We are considering a refactor and plan to disconnect this relationship.

midwire commented 5 years ago

Latest version 1.0.2 should resolve this issue. Please re-open if additional problems.