ZIPList Can-USA Geocode TM (August 2008)
This database conveniently combines two of our other products, ZIPList5 Geocode and ZIPList Canada Geocode, into a single ZIP code database which covers both the USA and Canada in a single product.
Description
This comma-delimited ASCII data file lists every active ZIP code and postal code for both the USA and Canada. Includes latitude, longitude, city, state/province, area code, county (USA only), time zone, and daylight saving time.
You can incorporate this data into your own dealer/store locator applications to find all stores within a radius or to find the closest store. (We include the distance calculation equations.) Or use this data file with popular commercial database programs such as MS Access, dBase, Paradox, FoxPro, etc.
- More than 830,000 records
- Covers all 50 states and all 13 provinces, including Nunavut
- Updated monthly (Canadian data updated quarterly)
- Available for immediate download in native MS Access, dBase, and Paradox formats
Record Layout
The data records of the ZIPList Can-USA Geocode file consist of twelve quote-delimited, comma-separated, ASCII text fields, arranged as follows:
| Field | Type | Length | ||
|---|---|---|---|---|
| City Name | Variable length ASCII | 30 maximum | ||
| State/Province Code | Fixed length ASCII | 2 | ||
| ZIP/Postal Code | Fixed length ASCII | 6 alphanumeric characters, plus embedded space | ||
| Area Code | Fixed length ASCII | 3 numeric characters | ||
| County Name (USA only) | Variable length ASCII | 25 maximum | ||
| Time zone | Variable length ASCII | 5 maximum (EST, CST, MST, etc.) | ||
| DST | Fixed length ASCII | 1 ("Y" or "N") | ||
| Country | Fixed length ASCII | 1 ("C", or "U") | ||
| Latitude | Fixed length ASCII | 7 characters: nn.nnnn | ||
| Longitude | Variable length ASCII | 7 or 8 characters: nnn.nnnn | ||
| ZIP code type (USA only) | Fixed length ASCII | 1 character (P, U, M, or blank) | ||
| County FIPS (USA only) | Fixed length ASCII | 5 numeric characters |
The City name field contains the one "preferred" city name for this particular ZIP/postal code. This database contains only one record for each active ZIP/postal code, and does NOT list any possible "alias" city names. If you need alias city names you should consider ZIPList Can-USA Max, which includes all of the information in this database, plus alias city names and other useful data.
Note that some city names in Quebec contain special diacritical marks. The character set employed for these characters is ISO-8859-1. An English-only version of this product is available for those applications which cannot use the French spellings.
The State/Province field contains the standard 2-character abbreviation for the state or province.
The ZIP/postal code field contains only valid ZIP/postal codes currently defined by the US Postal Service or Canada Post Corporation (CPC). Obsolete ZIP/postal codes which have been "retired" from service are not included in this database.
The Area code is the "most prevalent" area code for that one postal code. If multiple area codes apply to that one postal code, only the primary area code is listed. Overlay area codes are not listed.
The County Name field identifies the "most prevalent" county for the 5-digit ZIP code listed in a given record. Note: This field applies to ZIP code (USA) records only. In all Canadian records this field is empty.
The Time zone field always contains the standard time zone designation for a particular postal code. If that postal code falls within a political entity which participates in daylight saving time (DST) during the summer months, the DST field is set to "Y". Otherwise the DST field is set to "N".
The Country field contains a single character which identifies whether the record is a USA record ("U") or a Canadian record ("C").
The latitude and longitude fields contain the geographic coordinates in degrees to four decimal places, providing a general level of accuracy of under 100 feet. Latitude and longitude are measured north from the equator or west from the prime meridian. Longitude for all records is presented as a positive number to minimize the file size.
For larger Canadian cities, we resolve the latitude and longitude based on the first three characters of the postal code (known as the "Forward Sortation Area", or FSA), which corresponds to the 5-digit ZIP code level in the US. The larger Canadian cities often have more than 50 FSAs. This keeps the cost of the product within reason, yet provides a level of resolution perfect for dealer locator and store locator applications.
For rural Canadian areas, in most cases, the database contains the latitude and longitude of the center of the city or town. For villages and very small towns in close proximity the database contains the latitude and longitude of the general geographic area. In general, the latitude and longitude values relate to the geographic centroid of the ZIP code or postal code area, not the population centroid.
The ZIP Code type field (USA only) identifies special ZIP codes used for PO Boxes, companies, or the military.
The County FIPS code (USA only) is a 5-digit numeric field containing a unique numeric identification assigned to that county by the US government. The County FIPS code field and the County Name field identify the "most prevalent" county for the 5-digit ZIP code listed in a given record.
Sample Records
"City","ST","ZIP","AC","County","TZ","DST","Country","Lat","Long","Type","FIPS"
"Scotch Lake","NS","B1Y 3X1","902","","EST+1","Y","C","46.1800","60.3700",,
"Barrachois","NS","B1Y 3X2","902","","EST+1","Y","C","45.7300","63.2700",,
"Millville","NS","B1Y 3X3","902","","EST+1","Y","C","45.0000","64.8200",,
"Little Bras d'Or","NS","B1Y 3X4","902","","EST+1","Y","C","46.2300","60.2800",,
"Hillside Boularderie","NS","B1Y 3X5","902","","EST+1","Y","C","46.2300","60.3800",,
"Florence","NS","B1Y 3X6","902","","EST+1","Y","C","46.2700","60.2700",,
"Mill Creek","NS","B1Y 3X7","902","","EST+1","Y","C","45.7679","64.3645",,
"Point Aconi","NS","B1Y 3X8","902","","EST+1","Y","C","46.3300","60.3000",,
"Bras d'Or","NS","B1Y 3X9","902","","EST+1","Y","C","46.2500","60.2800",,
"Hillside Boularderie","NS","B1Y 3Y1","902","","EST+1","Y","C","46.2300","60.3800",,
Click here to download a self-extracting file containing sample records in Access 97 format (about 28 KB).
Click here to download a self-extracting file containing sample records in comma-delimited ASCII format (about 21 KB).
Available File Formats
| Format | Compression | Download Size | ||
|---|---|---|---|---|
| Comma-delimited ASCII | self-extracting | 3.0 MB | ||
| Microsoft Access 2000 | self-extracting | 4.1 MB | ||
| Microsoft Access 97 | self-extracting | 3.5 MB | ||
| Paradox 9 | self-extracting | 3.2 MB | ||
| dBase 3/4 | self-extracting | 3.1 MB | ||
| Comma-delimited ASCII | PKZip | 3.0 MB | ||
| Comma-delimited ASCII (CDROM only) | uncompressed | 53 MB |
Licenses
We offer these licenses for ZIPList Can-USA Geocode:
- Workstation License - single-user, single workstation
- Enterprise License - unlimited users on unlimited sites within one company
Prices
| August 2008 data | Annual Subscription Quarterly* updates save up to 59% |
Annual Subscription Monthly** updates save up to 66% |
|
|---|---|---|---|
| Workstation License: | $79.95 | $239.00 | $549.00 |
| Enterprise License: | $199.00 | $479.00 | $949.00 |
*Quarterly updates: Pay this fee one time. You'll receive the latest ZIPList Can-USA Geocode data every three months for a full year (a total of four versions), starting with the August 2008 version.
**Monthly updates: Pay this fee one time. You'll receive the latest ZIPList Can-USA Geocode data every month for a full year (a total of 12 versions), starting with the August 2008 version. Note: US ZIP code data is updated monthly, but Canadian postal code data is updated only quarterly.
Prices subject to change without notice.
Delivery
| Internet: | Download ZIPList Can-USA Geocode immediately after you place your order online via our secure server. After we check your credit card (which usually takes only a few seconds) we'll return an order confirmation page to your browser containing the information you need to download the data from our server.
We'll also include an invoice which states what you ordered and paid. Please print out a copy of this invoice for your records! If you place your order via phone, fax or mail we will process your order usually within 1 business day. After we process your order we will send you an email message with the download information. We'll include an invoice which states what you ordered and paid. No shipping and handling charges for Internet delivery. |
||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CDROM: |
Normally we process and ship all orders within 1 business day using the shipping method you chose. The following shipping and handling charges apply: |
||||||||||||||||||
|
Payment
All orders must be prepaid. We do not accept Purchase Orders. We accept Visa, MasterCard, Discover Card and American Express for online or telephone orders.
We also accept checks and money orders in US funds drawn on a US bank. The payment must include shipping and handling charges, if applicable. Orders which do not include appropriate shipping and handling charges will be delayed. If you need an invoice to submit to your accounting department to have a check cut please contact us at 800-571-3914 or 281-292-3270 to place your order. We will prepare a pro forma invoice and send it to you via email, fax, or snail mail. However, your order will not be shipped until we receive payment in full.
Attention Texas residents: Orders for delivery to a Texas address, whether downloaded via the Internet or delivered on CDROM, must include sales tax of 6.25% on the total amount of the order, including shipping and handling, if any. A sales tax of 6.25% of the order total will automatically be added to all Texas orders processed through our online ordering system. Tax exempt organizations in Texas must fax a tax exemption certificate to us at 281-292-3608 and should contact us at 800-571-3914 to place their orders. Orders which do not include appropriate sales tax or a valid tax exemption certificate will be delayed.
30-Day Money-Back Guarantee
We back ZIPList Can-USA Geocode with our 30-Day Money-Back Guarantee. If you are not satisfied with ZIPList Can-USA Geocode we will cheerfully refund the purchase price of the product.
What our Customers say about our Database Products and about us
Other ZIP code Products -
ZIP code Product Search -
About Us -
Home
Sales: sales@zipinfo.com
Support: support@zipinfo.com
Mail: CD Light, LLC, 230 N Tranquil Path Dr, The Woodlands TX 77380-2758
Voice: 800-571-3914 or 281-292-3270
Fax: 281-292-3608