|
Download USA-Canadian ZIP Postal Codes Database Products Bundle Professional Edition
* Payment will be required for 1-year of updates Description
The USA&CAN ZIPPostalBundle™, Professional Edition is designed for the needs of majority USA ZIP code & Canadian Postal code users. The database fields include
ZIP/postal code, ZIP code type(USA only), city name, city name abbreviation (USA only), city type, state/province code, state/province name, country, area code, latitude, longitude, and time zone.
Currently it contains over 850,000 records, and available in MS Access, industry-standard quote-delimited, comma-separated ASCII format, and any other format as you request!
What We Offer
- Download as you pay, no waiting time
- Unlimited download times
- Lowest price (for details, please see our Lowest Price Guarantee)
- 30-day Money-back Guarantee!
- Monthly update available for subscription
- Different license for different needs
- Half-yearly, quarterly and monthly subscription available
- Over 850,000 ZIP/Postal Code Records
- Free database creation script when you buy our product
- Guaranteed customer satisfied service!
File Size
Uncompressed Disk space
- Microsoft Access Version - 132 MB
- Comma-separated Version - 73 MB
Sample ZIP Code Data for DownloadNote: all files are in zip format, please use WinZip or other unzip tool to uncompress it. Each file contains 50 sample records.
Sample Records for Your Reference
"V0N 1B1", "", "C", "Whistler", "P", "BC", "British Columbia", "604", "50.1303", "122.9739", "PST"
"M1B 1A1", "","C", "Scarborough", "P", "ON", "Ontario", "416", "43.8129", "79.2090", "EST"
"H1A 1J2", "","C", "Montreal", "P", "QC", "Quebec", "514", "45.6764", "73.5022", "EST"
"59001", "", "U", "Absarokee", "", "P", "MT", "Montana", "406", "45.5102", "109.6167", "MST"
"89502", "", "U", "Reno", "", "P", "NV", "Nevada", "775", "39.4944", "119.7469", "PST"
"76539", "", "U", "Rumley", "", "N", "TX", "Texas", "512", "31.0791", "98.0007", "CST"
Database Fields
| Field Name | Data Type | Field Description |
| ZIPCode | char(7) | 6-digit postal code (and 1 space) |
| ZIPType | char(1) | The type of ZIP Code, defined as below (USA only):
- "" - Standard ZIP Code
- P - Used for PO Boxes
- U - Used for companies
- M - Used for militaries
|
| City | varchar(30) | The corresponding name of the city |
| CityAbbrev | varchar(13) | City Name Abbreviation (USA only) |
| CityType | char(1) | Tells if the city name is recommended by the USPS.
- P - Default City Name - recommended by the USPS
- A - Alternate City Name, also used by the USPS, but not the preferred name of that ZIP Code.
- N - Not approved for mail delivery, not accepted by the USPS.
|
| StateCode | char(2) | The two-letter abbreviation of the state name |
| State | varchar(25) | The full name of the state (or territory) |
| Country | char(1) | Country: U for USA, C for Canada |
| AreaCode | char(3) | Corresponding area code for that zip code |
| Latitude | numeric (double) | The Latitude of the geographic center of the ZIP Code. For military ZIP Codes the Latitude will be 0.0 |
| Longitude | numeric (double) | The Longitude of the geographic center of the ZIP Code. For military ZIP Codes the Longitude will be 0.0 |
| TimeZone | varchar(5) | The standard time zone designation for the particular postal code |
|
|