| 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 Code
in meter. |
| 12 |
POPULATION |
numerical |
The population for Forward Sortation
Area as reported by Census 2001. |
| 13 |
DWELLING |
numerical |
The total private dwellings for Forward
Sortation Area as reported by Census
2001. |
| 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. |
