GeoNames Forum

There has been a change to some Arizona ZIP codes ... see the info below for details.

http://pinalcountyaz.gov/Departments/NewsInformation/Lists/News%20and%20Announcements/DispFormA.aspx?List=a034c985-f072-4734-926b-9dcdba43664a&ID=853

Can you update the US ZIP codes to reflect this change?

Hi

I cross checked on the usps website and could not find these changes. The cities are listed with the 852xx zip codes instead of the 851xx :
http://zip4.usps.com/zip4/citytown.jsp

(for instance Mesa, AZ with 8520x)

Are you living in the area and can you confirm that the change really took place?

Best

Marc

Thx for the quick reply.

No, I don't live in the area.

The map of changes is here:
http://www.usps.com/communications/newsroom/localnews/az/2009/New_851_ZIP_Boundary.pdf

Mesa, AZ zip codes did not change on July 1, 2009 so that's why they don't appear as changed.
Try Florence, AZ or Kearny, AZ to see the changes.

Starting July 1, 2010, the old zip codes will no longer be valid as both are valid for 1 year after July 1, 2009.

Does it mean we should only change it after July 1, 2010, as it is still valid till then?

Best

Marc

Both (old zip code and new zip code) are valid now...but only the new zip code will be valid after July 1, 2010.
I'll leave it up to you to decide if you want to make zip code changes now where both old and new zip codes are supported between now and June 30, 2010 or if you simply want to update on July 1, 2010 and support the new zip codes.

Where can I find the zip codes?

Which zip codes are you referring to?

Marc
can you provide an update on refreshing the US ZIP code data that would have this fix?
Thank you.

Effective July 1, the following communities will be affected by the zip code change: Arizona City, Casa Grande, Coolidge, Eloy, Florence, Kearny, Maricopa, Queen Creek, Red Rock, Stanfield, Superior and Winkelman.

Does 'Maricopa' refer to the entire county or only to the city?

Marc

The city.

the city was changed some time ago:

http://www.geonames.org/postalcode-search.html?q=Maricopa%2C+az%2C+85138&country=

and

http://www.geonames.org/postalcode-search.html?q=Maricopa%2C+az%2C+85139&country=

Yes, they are fixed.
Thank you.

I compared the geonames US postal codes with the free US postal codes provided by zipcodeworld.com, and found some major discrepancies:
Code:

 --------------
 SELECT
 COUNT(*)
 FROM
 zipcodeworld z
 LEFT JOIN
 geonames g ON z.zip = g.zip
 WHERE
 g.zip IS NULL
 --------------
 
 +----------+
 | COUNT(*) |
 +----------+
 |      850 |
 +----------+
 1 row in set (0.16 sec)
 
 --------------
 SELECT
 COUNT(*)
 FROM
 geonames g
 LEFT JOIN
 zipcodeworld z ON g.zip = z.zip
 WHERE
 z.zip IS NULL
 --------------
 
 +----------+
 | COUNT(*) |
 +----------+
 |     2325 |
 +----------+
 1 row in set (0.13 sec)
 
 --------------
 SELECT
 z.*
 FROM
 zipcodeworld z
 LEFT JOIN
 geonames g ON z.zip = g.zip
 WHERE
 g.zip IS NULL
 --------------
 
 +-------+----------+
 | zip   | state_id |
 +-------+----------+
 | 00601 | PR       |
 | 00602 | PR       |
 ...
 | 96970 | MH       |
 | 97471 | OR       |
 +-------+----------+
 850 rows in set (0.11 sec)
 
 --------------
 SELECT
 g.*
 FROM
 geonames g
 LEFT JOIN
 zipcodeworld z ON g.zip = z.zip
 WHERE
 z.zip IS NULL
 --------------
 
 +-------+
 | zip   |
 +-------+
 | 00210 |
 | 00211 |
 ...
 | 99584 |
 | 99779 |
 +-------+
 2325 rows in set (0.13 sec)
 
 Bye

What is the best way to submit corrections to geonames?