North America City and ZIP-Postal Code File

This Geocode File includes a list of data records for cities and postal codes in the North America that are accessible in PC*Miler and are included in the US, Canada, Mexico, Puerto Rico, Greenland, Saint Pierre and Miquelon, and the US Virgin Islands. It also includes the corresponding ZIP/Postal Code where data is available. The file is comma delimited and sorted in ascending order based on the state/province, county name then ZIP/Postal Code.

PC*Miler LICENSE REQUIREMENT:

A base license of the corresponding version for at least one of the following PC*Miler products, and an additional fee, are required before this Geocode File can be provided:

  • PC*Miler

  • PC*Miler Web Services (any Feature Level)

FILE EXCERPT:

statename,countyname,placename,zip
AR,Newton,Marble Falls,72648
FL,Lee,North Fort Myers,33903
HI,Honolulu,Honolulu,96826
MH,Tacámbaro,El Gigante,61652

FILE NOTES:

  • State/province abbreviations included in this file are FIPS codes.

  • This file is in Unicode format and includes characters outside the 0 to 127 ASCII range. Some place names do have special characters such as Õ, é, and ü. This file must be opened using UTF-8 or Arial Unicode MS format so that all characters display appropriately.

  • This file only includes data released in the base version related to the Geocode File purchased. It does not include information added for a relatable quarterly data update.

  • You may see locations in the United States that are listed without a US ZIP Code. If you scroll the list, you will then see the location with the ZIP Code listed. This is not a typo or an error.

  • PC*Miler’s US ZIP Code database does include PO Box ZIP Codes according to the following rules: if USPS had designated the only ZIP Code assigned to a location as a PO Box ZIP, then it was added to the database; if the USPS has designated a street address for a PO Box ZIP Code, then it was added to the database; and if neither, and you enter a PO Box ZIP, you’ll receive a message: “This is a non-routable PO Box". Freight to be picked up from or delivered to a USPS facility should be routed using the street address delivery ZIP Code for that facility.

  • In the file you may see some cities in Mexico listed as a calendar date such as “16 de Septiembre”.  According to the Correos de Mexico, these are valid city locations that relate to the Postal Code assigned to that city.

VERSION SPECIFIC FILE NOTES:

  • Beginning in PC*Miler 28, Central American countries that were previously included in the North America region have been removed from that region and are now included in South America.