ZIPList5 Max TM (July 2008 data)

Each ZIPList5 Max record contains the following data:

• 5-digit ZIP code
• City name (and abbreviation, if over 13 characters)
• State abbreviation
• County name (for that ZIP code)
• County FIPS code
• Area code
• Time zone
• Daylight Saving Time flag
• Latitude and longitude in degrees
• MSA/PMSA code
• Market Area
• Preferred name or alias name flag (refers to city name)
• ZIP code type

Included with the ZIPList5 Max data file are these support files:

• MSA/PMSA codes: list of all valid MSA/PMSA/CMSA codes assigned by the US Government
• State FIPS codes: list of all state FIPS codes, including the territories
• Market area codes: list of active market area codes and the areas they cover

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

We update every record in ZIPList5 Max monthly, so you always receive the latest and most up-to-date data. You can't get more accurate and timely ZIP code data from any other source! We include the most recent area code changes in every update. We license our ZIP code data directly from the US Postal Service, and collect and cross-check all the other data continuously from a variety of sources, including the Census Bureau, the US Geological Survey, the Office of Management and Budget, NANPA, the telephone companies, and maps.

Please note: ZIPList5 Max is not a program; it is a data file. ZIPList5 Max does not include a program to search, sort, or print out the data. To make use of the data contained in ZIPList5 Max you must use it with your own database program. ZIPList5 Max works well with almost any commercial database program, including MS Access, dBase, FoxPro, Paradox, etc. In fact, we already have formatted ZIPList5 Max for use with MS Access, dBase/FoxPro, and Paradox at no extra charge.

• Almost 71,500 records (42,700 preferred records plus 28,800 alias records)
• Includes common local city names and city name abbreviations
• Updated monthly

"City Name","State Code","ZIP code","Area code","County FIPS code","County Name","Preferred flag","Time zone","DST?","Latitude","Longitude","MSA","PMSA","City abbreviation","Market area","ZIP Code Type"CRLF

The fields are defined as follows:

Field		Type		Length
City Name		Variable length ASCII		28 maximum, mixed case
State Code		Fixed length ASCII		2 alpha characters (CA, UT, etc.)
ZIP code		Fixed length ASCII		5 numeric characters
Area code		Fixed length ASCII		3 numeric characters
County FIPS		Fixed length ASCII		5 numeric characters
County Name		Variable length ASCII		25 maximum, mixed case
Preferred?		Fixed length ASCII		1 ("P","A", or "N")
Time zone		Variable length ASCII		5 maximum (EST, CST, MST, etc.)
DST?		Fixed length ASCII		1 ("Y" or "N")
Latitude		Fixed length ASCII		7 characters: nn.nnnn, in degrees
Longitude		Variable length ASCII		7 or 8 characters: nnn.nnnn, in degrees
MSA		Fixed length ASCII		4 numeric characters or blank
PMSA		Fixed length ASCII		4 numeric characters or blank
City Name Abbreviation		Variable length ASCII		13 maximum, mixed case or blank
Market Area		Fixed length ASCII		3 numeric characters or blank
ZIP code type		Fixed length ASCII		1 character (P, U, M, or blank)

The City Name field identifies a city name associated with the ZIP code by the USPS. There may be several different city names associated with a particular ZIP code. If so, the ZIP code will appear in several different records, each with a different city name.

The ZIP code field lists only valid 5-digit ZIP codes currently defined by the USPS. Obsolete ZIP codes which have been "retired" from service by the USPS are not included in this database. A particular ZIP code may appear in more than one record if the USPS has defined more than one city name for that ZIP code.

The area code is the "most prevalent" area code for that one ZIP code. If multiple area codes apply to that one ZIP code, only the primary area code is listed. Overlay area codes are not listed.

The County FIPS code 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 Preferred? flag can have one of three states, which indicate how that name can be used for delivery of mail to the associated ZIP code. The three states are:

• P - This is the preferred city name for this ZIP code
• A - This city name is approved (but NOT preferred) for this ZIP code
• N - The city name is NOT approved for mail delivery to this ZIP 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 time zone field always contains the standard time zone designation for a particular ZIP code. If that ZIP 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 decimal degrees of the "centroid" of the ZIP code area, measured north from the equator and west from the prime meridian. Depending upon the shape of the ZIP code area, the centroid may actually lie outside of the ZIP code's boundaries. Longitude for all US ZIP codes is presented as a positive number, although all values should be taken as negative (west of the prime meridian).

The MSA field 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 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 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 contains the three-digit Market Area code in which the ZIP code lies. For more information about market area click here.

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

County, ZIP code, area code boundaries
County boundaries, state boundaries, ZIP code boundaries, area code boundaries, and time zone boundaries are all administered by different federal, state, local government and private agencies. As you probably already know, cooperation between these various agencies is virtually nonexistent. As a result, these various boundaries do not necessarily align. This means that a given ZIP code area may actually cross one or more county, area code, and/or time zone boundaries. But each ZIP code record in ZIPList5 Max has only a single field each for county name, area code, or time zone. An attempt to add additional records to document all the variations which can occur would make the product too complex and difficult to use, and is beyond the scope of this inexpensive database.

We have attempted to provide the most accurate information for each ZIP code by selecting the most prevalent county, area code, and time zone for each ZIP code in the database. However, you should be aware that because of this boundary alignment problem, the county name and FIPS code, area code, and time zone provided for each ZIP code in the database may not apply to every address which lies within the boundaries of that ZIP code.

Sample Records
"Aurora","CO","80010","303","08005","Arapahoe","P","MST","Y","39.7373","104.8639",,"2080",,"034",
"Austin","TX","73301","512","48453","Travis","P","CST","Y","30.2669","97.7429","0640",,,"064",
"Denver","CO","80201","303","08031","Denver","P","MST","Y","39.7392","104.9844",,"2080",,"034",
"Salt Lake City","UT","84101","801","49035","Salt Lake","P","MST","Y","40.7565","111.8967","7160",,,"716",
"Sandy","UT","84093","801","49035","Salt Lake","P","MST","Y","40.5944","111.8317","7160",,,"716",
"Agoura Hills","CA","91376","818","06037","Los Angeles","A","PST","Y","34.1232","118.7700",,"4480",,"049","P"

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

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

Available File Formats

Format		Compression		Download Size
Comma-delimited ASCII		self-extracting		1.8 MB
Microsoft Access 2000		self-extracting		2.3 MB
Microsoft Access 97		self-extracting		2.1 MB
Paradox 9.0		self-extracting		1.8 MB
dBase		self-extracting		1.8 MB
Comma-delimited ASCII		PKZip		1.8 MB
Comma-delimited ASCII		uncompressed		6.9 MB

Licenses
We offer the following licenses for ZIPlist5 Max:

• Workstation License - single-user, single workstation
• Enterprise License - unlimited users on unlimited sites within one company
• Duplication Addendum - Addendum to Enterprise or Workstation License for redistributing the data of ZIPList5 Max outside your company.

Prices

	July 2008 data	Quarterly* Subscription save up to 62%	Monthly** Subscription save up to 68%
Workstation License:	$99.95	$199.95	$499.00
Enterprise License:	$199.95	$299.95	$749.00
Duplication Addendum: up to 100 copies unlimited copies	$399.00 $799.00	$599.00 $1,199.00	$1,499.00 $2,999.00

* Quarterly subscription: Annual fee. You'll receive the latest ZIPList5 Max data every three months for a full year, starting with July 2008.
** Monthly subscription: Annual fee. You'll receive the latest ZIPList5 Max data every month for a full year, starting with July 2008.
Prices subject to change without notice.

Delivery

Internet:	Download ZIPList5 Max immediately after you place your order online via our secure server. We'll include an invoice which states what you ordered and paid. 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:
	Surface (USA, First Class) $8.00 2nd Day Air (USA except AK/HI) $13.00 (Alaska/Hawaii) $20.00 (Canada) $35.00 Overnight (USA except AK/HI) $16.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 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 ZIPList5 Max with our 30-Day Money-Back Guarantee. If you are not satisfied with ZIPList5 Max we will cheerfully refund the purchase price of the product.

What our Customers say about our Database Products and about us

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