frostline icon indicating copy to clipboard operation
frostline copied to clipboard

Some zipcodes with PHZ data are not in zipcodes.csv file, and therefore have no api json file

Open philvarner opened this issue 3 years ago • 0 comments

For example, 90840 is in the US (CONUS) PHZ csv, but not in zipcodes.csv, so it results in a 404 https://phzmapi.org/90840.json

This seems to be opposite of the case mentioned in the readme (some zips don't have PHZ data).

According to https://public.opendatasoft.com/explore/dataset/us-zip-code-latitude-and-longitude/table/ there should be 43,191, whereas the csv only has 29,809 rows (incl header).

I think the underlying cause of this is that the UPDATE silently has no effect if there was no row inserted for that zip from the zipcodes.csv.

Running some modified code, I see:

PHZ zipcodes with no location: 11348 zipcodes with no PHZs: 36

Using the CSV from the OpenDataSoft URL above, I see:

PHZ zipcodes with no location: 459 zipcodes with no PHZs: 2530

So, it looks like there are still some PHZ zips not covered by the ODS list.

philvarner avatar Feb 01 '21 05:02 philvarner