The database includes Postal Code, city name, province name, phone area code, timezone, day light saving, latitude and longitude in Canada. The complete database contains over 800,000 unique Postal Code records with individual latitude and longitude.
By buying this product you can collect up to 19 reward points as a voucher of $3.80.
Your reward points.
Our products are available for download only, which allows us to keep our prices low and pass the savings on to you. The data will be available in your account for 30 days after your purchase. It can be downloaded on any computer with internet access.Available for Immediate Download
Product Features & Benefits
Technical Specification
Field#
Field Name
Data Type
Field Description
1
POSTAL_CODE
nchar(7)
The Postal Code of the city.
2
CITY
varchar(45)
The name of the city of the Postal Code
3
PROVINCE
varchar(45)
The name of the province to that Postal Code.
4
PROVINCE_ABBR
char(2)
The two-letter abbreviation for the province to that Postal Code.
5
AREA_CODE
nchar(3)
The telephone area code belonging to the particular Postal Code is located.
6
CITY_FLAG
char(1)
The flag to determine the Postal Code is in a City area.
7
TIME_ZONE
numerical
The time zone number represents by the hours past the Greenwich Time Zone.
8
DAY_LIGHT_SAVING
char(1)
This flag indicates whether the city observe day light saving.
9
LATITUDE
numerical
The geographic coordinate of a point measured in degrees north or south of the equator.
10
LONGITUDE
numerical
The geographic coordinate of a point measured in degrees east or west of the Greenwich meridian.
11
ELEVATION
numerical
The average elevation of Postal CodeOM in meter.
12
POPULATION
numerical
The population for Forward Sortation Area as reported by Census 2006.
13
DWELLING
numerical
The total private dwellings for Forward Sortation Area as reported by Census 2006.
14
AREA_NAME
VARCHAR(45)
The major community or greater municipality grouping that contains the street address or its delivery installation recognized by Canada Post.
15
STREET_NAME
VARCHAR(45)
The official civic name of a roadway or artery recognized by Canada Post.
16
STREET_TYPE_CODE
CHAR(6)
The official description used to identify the type of artery or roadway.
17
STREET_DIR_CODE
CHAR(2)
The street direction component of an official street name.
18
STREET_SEQ_CODE
CHAR(1)
This code identifies the sequence associated with the range of street numbers.
19
STREET_FROM_NO
NCHAR(6)
The lowest street number in a range of municipal street addresses.
20
STREET_FROM_SUFFIX
CHAR(1)
The address suffix associated with the street address from number.
21
STREET_TO_NO
NCHAR(6)
The highest street number in a range of municipal street addresses.
22
STREET_TO_SUFFIX
CHAR(1)
The address suffix associated with the street address to number.
No customer comments for the moment.
Only registered user can post a new comment.
No products
Shipping
$0.00
Total
$0.00
