Frequently Asked Questions & Answers:

Zip Code Info.:
Q: What is the difference between the Pro-Zipcode base product and the Deluxe version?
A: Pro-Zipcode is usually used in marketing and has one record per zip code with the primary city for that zip code. There are almost 43,000 records in this file.

Pro-Zipcode Deluxe can have multiple cities per zip code (when zip codes cross city limits) and is primarily used in Order Entry applications where you key in a zip code to find the correct city and state. It is also used in marketing where the correct city name is needed as well. There are about 56,000 records in this file.

Q: What format does the file come in?
A: The files come in a comma-delimited ASCII file. This is a standard format that will load into Microsoft Excel, Access or other databases. You can also get it in a fixed-length format which is used by AS400 and mainframe computers.

Q: What is the file layout?
A: Please download a demo version of the file from our Download Page. With the demo, we include ‘readme’ help files which have the file layout and other helpful information such as how to load the file into Excel or Access.

Q: Do you have county info.? What file do I purchase to get it?
A: Pro-Zip code and Pro-Zip code Deluxe base products include the primary county name. If you need the county FIPS codes, then you would need to get the FIPS add-on product. If you need to know all of the possible counties a zip code may cross over, you would need our Multi-County Zip Code data.

Q: Do zip codes cross county lines? Do you include all counties for a zip code?
A: Zip codes cross county lines on occasion. When it does, we include the primary county or that zip code based on the total number of address. We do not include alternate county names in our Pro-Zipcode and Deluxe products, but we do have them in our Multi-County Zip Code data.

Q: Do zip codes cross area code boundaries? Do you include all area codes for a zip code?
A: Zip codes also cross area code boundaries and we include the primary area code for that zip code. We do not include alternate area codes in our Pro-Zipcode and Deluxe products, but we plan on having them in a new product: Multi-Area Codes.

Q: When do you add new area codes in your data?
A: If an area code has just split within the last two months or so, we will not include that new area code. We wait at least two months after a split begins before we’ll include the new area code in the product. The reason for that is because when a split begins, not everyone can dial the new area code. It usually takes over a month for all the phone companies to be programmed to use the new area code.

Q: How often do the zip / postal codes really change?
A: U.S. Zip codes change sporadically. Most of the time there’s just a few changes, but every now and then (especially around July 1st) there will be major changes. Canadian postal codes are undergoing some major changes, so each version usually has thousands of changes. Mexican postal codes also change, but sometimes they don't make the changes available to us more than once a year. We recommend that you update your files every time we send you new versions of the data.

Q: I have addresses, but I have some missing or bad zip codes, how do I get them fixed?
A: If you have addresses, but have bad or missing zip codes, you can go to www.SemaphoreCorp.com and purchase a product called ZP4. That can clean up your database. We recommend that about once a year you purchase one of their additions (which is about $90.00) and run it through your database to clean up your addresses. Use our products to keep the data clean at data entry time.