|
Download Canadian Postal Code Database Products Enterprise Edition
* Payment will be required for 1-year of updates Description
The PostalCodeDepot™ CAN, Enterprise Edition is designed for the needs of advanced Canadian postal code users. The database fields include
postal code, city name, city type, province code, province name, area code, latitude, longitude, time zone, GMT offset, and Daylight Saving Time flag.
The latest data has over 780,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
- Different license for different needs
- Half-yearly, quarterly and monthly subscription available
- Over 78,000 Postal Code Records
- Free database creation script when you buy our product
- Guaranteed customer satisfied service!
File Size
Uncompressed Disk space
- Microsoft Access Version - 123 MB
- Comma-separated Version - 66 MB
Sample Postal 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", "Whistler", "P", "BC", "British Columbia", "604", "50.1303", "122.9739", "PST", "-8", "Y"
"M1B 1A1", "Scarborough", "P", "ON", "Ontario", "416", "43.8129", "79.2090", "EST", "-5", "Y"
"H1A 1J2", "Montreal", "P", "QC", "Quebec", "514", "45.6764", "73.5022", "EST", "-5", "Y"
Database Fields
| Field Name | Data Type | Field Description |
| PostalCode | char(7) | 6-digit postal code (and 1 space) |
| City | varchar(30) | The corresponding name of the city |
| CityType | char(1) |
- P - Current city name is the primary one for this postal code
- A - Current city name is the alternate one for this postal code
|
| ProvinceCode | char(2) | The two-letter abbreviation of the province name |
| Province | varchar(25) | The full name of the province (or territory) |
| AreaCode | char(3) | Corresponding area code for this Postal code |
| Latitude | numeric (double) | The Latitude of the geographic center of the Postal code. |
| Longitude | numeric (double) | The Longitude of the geographic center of the Postal code. |
| TimeZone | varchar(5) | The standard time zone designation for the particular postal code |
| GMTOffset | int | The GMT offset indicates the difference in hours between GMT and the time zone for that particular postal code. |
| DST | char(1) | DST stands for "Day light saving time". DST fields is set to "Y" if the particular Postal code obeys the Daylight Savings change, otherwise it is set to "N". |
|
|
Shopping Cart
Login
Products
USA - Basic
Canada - Basic