Skip to content

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

@philvarner

Description

@philvarner

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions