|
Download Canadian Postal Code Database Products Professional Edition
* Payment will be required for 1-year of updates Description
The PostalCodeDepot™ CAN, Professional Edition is designed for the needs of majority Canadian Postal code users. The database fields include
postal code, city name, city type, province code, province name, area code, latitude, longitude, and time zone.
Currently it contains 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 - 114 MB
- Comma-separated Version - 59 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"
"M1B 1A1", "Scarborough", "P", "ON", "Ontario", "416", "43.8129", "79.2090", "EST"
"H1A 1J2", "Montreal", "P", "QC", "Quebec", "514", "45.6764", "73.5022", "EST"
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 |
|
|