ZIPList Can-USA Max TM (August 2008)

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 900,000 records
• Covers all 50 states and all 13 provinces and territories, including Nunavut
• Updated monthly
• Available for immediate download

• MSA/PMSA codes: list of all valid MSA/PMSA/CMSA codes with the associated area name
• CBSA/Division codes: list of all valid MSA/PMSA/CMSA codes with the associated area name
• State FIPS codes: list of all state FIPS codes, including the territories
• Market area codes: list of active market area codes with the associated area name and population
• Area code list: complete list of all area codes for North America, including overlay area codes

We update every ZIP code record in ZIPList Can-USA Max monthly, so you always receive the latest and most up-to-date data. We license our ZIP code data directly from US Postal Service and our postal code data directly from Canada Post Corporation.

ZIPList Can-USA Max documentation also includes a tutorial and equations for calculating the distance in miles between ZIP codes using latitude and longitude.

Record Layout

Field		Type		Length
City Name		Variable length		30 maximum
State/Province Code		Fixed length		2
ZIP/Postal Code		Fixed length		6 alphanumeric characters, plus embedded space
Country		Fixed length		1 ("C", or "U")
ZIP code type (USA only)		Fixed length		1 character (P, U, M, or blank)
Preferred		Fixed length		1 ("P","A", or "N")
Area Code		Fixed length		3 numeric characters
County FIPS (USA only)		Fixed length		5 numeric characters
County Name (USA only)		Variable length		25 maximum
Time zone		Variable length		5 maximum (EST, CST, MST, etc.)
Daylight Saving Time		Fixed length		1 ("Y" or "N")
Latitude		Fixed length		7 characters: nn.nnnn
Longitude		Variable length		7 or 8 characters: nnn.nnnn
MSA (USA only)		Fixed length		4 numeric characters or blank
PMSA (USA only)		Fixed length		4 numeric characters or blank
City Name Abbreviation (USA only)		Variable length		13 maximum, mixed case or blank
Market Area (USA only)		Fixed length		3 numeric characters or blank
CBSA (USA only)		Fixed length		5 numeric characters or blank
Division (USA only)		Fixed length		5 numeric characters or blank
Population (USA only)		Variable length		12 numeric characters max

The City field identifies a city name associated with the ZIP/postal code. There can be several different city names associated with a particular ZIP or postal code. If so, that ZIP/postal code may appear in several different records, each with a different city name. The Preferred field (described below) identifies whether the city name in this record is the primary city name or an alias (alternate) city name for this ZIP/postal code.

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 codes currently defined by the US Postal Service or postal codes defined by Canada Post Corporation (CPC). Obsolete ZIP/postal codes which have been "retired" from service are not included in this database.

The Country field contains a single character which identifies whether the record is a USA record ("U") or a Canadian record ("C").

The ZIP Code type field (USA only) identifies special ZIP codes used for PO Boxes, companies, or the military.

The Preferred flag can have one of three states, which indicate how that city name can be used for delivery of mail to the associated ZIP/postal code. The three states are:

• P - This is the preferred city name for this ZIP/postal code
• A - This city name is approved (but NOT preferred) for this ZIP/postal code
• N - The city name is NOT approved for mail delivery to this ZIP/postal code

The one preferred name record has the preferred field set to "P", while all alias name records have the preferred field set to "A" or "N". Note that in some cases a particular name may be preferred for some ZIP codes but an alias name for other ZIP codes. This frequently occurs when the exact political boundary between adjacent cities is obscure, leading people to use the two city names interchangeably within the boundary area.

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 included in this database.

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.

The County Name field (USA only) 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 latitude and longitude fields contain the geographic coordinates in degrees to four decimal places, providing a general level of accuracy of under 100 feet. 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 MSA field (USA only) contains the Metropolitan Statistical Area code, if any, in which the ZIP code lies. The MSA is assigned by the US Government.

The PMSA field (USA only) contains the Primary Metropolitan Statistical Area code, if any, in which the ZIP code lies. The PMSA is assigned by the US Government.

The City Name Abbreviation field (USA only) contains the US Postal Service "official" abbreviation for the city name in those cases where the city name exceeds 13 characters. For those cities where the name is 13 or fewer characters this field is blank.

The Market Area field (USA only) contains the three-digit Market Area code in which the ZIP code lies. For more information about market area click here.

The CBSA field (USA only) contains Core Based Statistical Area code, if any, in which the ZIP code lies.

The Division field (USA only) contains the CBSA division code, if any, in which the ZIP code lies.

The Population field (USA only) contains the Census 2000 population for the ZIP code.

Sample Records

City Name
Aurora
Denver
Austin
Sandy
Aspen
Chester

ST Code
CO
CO
TX
UT
NS
NS

ZIP Code
80010
80203
78701
84070
B0H 1E0
B0J 1J0

US Can
U
U
U
U
C
C

ZIP Type

Pref Code
P
P
P
P
P
P

Area Code
303
303
512
801
902
902

Cnty FIPS
08005
08031
48453
49035

County Name
Arapahoe
Denver
Travis
Salt Lake

Time Zone
MST
MST
CST
MST
EST+1
EST+1

DST Flag
Y
Y
Y
Y
Y
Y

Latitude Degrees
39.7403
39.7318
30.2721
40.5769
45.2993
44.5508

Longitude Degrees
-104.8598
-104.9825
-97.7424
-111.8884
-62.0509
-64.2504

MSA Code
0640
7160

PMSA Code
2080
2080

City Abbrev

Market Area
034
034
064
716

CBSA Code
19740
19740
12420
41620

Division Code

ZIP Code Population
43236
17357
3855
23134

Click here to download a self-extracting file containing sample records in Access 97 format (about 36 KB).

Click here to download a self-extracting file containing sample records in comma-delimited ASCII format (about 30 KB).

Available File Formats

Format		Compression		Download Size
Comma-delimited ASCII		self-extracting		3.5 MB
Microsoft Access 2000		self-extracting		4.9 MB
Microsoft Access 97		self-extracting		4.2 MB
Paradox 9		self-extracting		4.0 MB
dBase 3/4		self-extracting		3.1 MB
Comma-delimited ASCII		PKZip		3.5 MB
Comma-delimited ASCII (CDROM only)		uncompressed		75.6 MB

Licenses
We offer these licenses for ZIPList Can-USA Max:

• 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:	$139.00	$319.00	$799.00
Enterprise License:	$299.00	$539.00	$1,349.00

*Quarterly updates: Pay this fee one time. You'll receive the latest ZIPList Can-USA Max 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 Max data every month for a full year (a total of 12 versions), starting with the August 2008 version.
Prices subject to change without notice.

Delivery

Internet:	Download ZIPList Can-USA Max 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:	We'll process and ship your order within one business day. The following shipping and handling charges apply to delivery on CDROM:
	Surface (USA, First Class) $8.00 Overnight (USA except AK/HI) $20.00 2nd Day Air (USA except AK/HI) $15.00 (Alaska/Hawaii) $25.00 (Canada) $40.00 International (Air Mail) $20.00

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 8.25% on the total amount of the order, including shipping and handling, if any. A sales tax of 8.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 Max with our 30-Day Money-Back Guarantee. If you are not satisfied with ZIPList Can-USA Max 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