|
|
PostalCodeOMWorld Canadian Gold Edition
|
|
|
|
|
|
|
|
|
 |
 |
Download |
Last Update: |
August 2008 |
Next Update: |
September 2008 |
|
|
|
|
| |
| Product Overview |
|
|
| |
PostalCodeOMWorld Canadian Gold Edition - The database
includes Postal CodeOM, city name, province name, phone area code,
timezone, daylight saving flag, latitude, longitude, population, total
dwellings, elevation and street name in Canada. The highest and lowest street
number can be used to validate the postal code for mailing addresses. The
complete database contains over 800,000 unique Postal CodeOM records
with individual latitude and longitude. PostalCodeOMWorld is
licensed distributor of Postal CodeOM database from Canada Post
Corporation. Postal Code is an official mark of Canada Post Corporation.
Sample database and full database are available to download instantly. Order
your PostalCodeOMWorld database now. Your computer-generated account
will be delivered to your email address immediately once the order has been
approved.
Redistribution license is also available for developers to redistribute
our database together with commercially-developed applications.
All products are available for the Internet download only. This allows us to
keep the lowest prices and pass the savings along to you.
All subscribers will receive notification via email that the new
update of database has been released. Subscribers can automate the monthly HTTP
download process by using the free open source application available
here.
The standard subscription allows you to download existing and
future database that has been updated in monthly basis. You can access to the
historical database since 2006 from archives by acquiring special
subscription.
|
 |
|
| |
| Pricing |
|
|
| |
|
Subscription Period |
Price |
|
|
| 1 Year
Subscription |
$599.95*
|
 |
|
| 1 Month
Subscription |
$249.95 |
|
|
|
| (*)
We recommend our customers to choose the one year subscription to get extra
savings while enjoying hassle-free unlimited access to the most up-to-date
database 24x7x365.
|
† All subscriptions are not recurring. No
auto-renew by end of subscription.
|
|
| |
| |
| Database Evaluation Request Form * Free * |
|
|
| |
| You can request for a comprehensive sample database
for evaluation purpose. Please fill up the form below to receive the sample via
email. |
| |
|
|
| |
| |
| Download (Subscription Required) |
|
|
| |
| Format |
Extension |
Download (Complete) |
Download (Sample) |
| Microsoft® Access |
MDB |
|
|
| Microsoft® Excel |
XLS |
|
| dBASE IV |
DBF
|
|
| Comma-delimited ASCII |
CSV |
|
|
|
| |
| |
| Technical Specification |
|
|
| |
| i. Database Fields |
| |
| Field# |
Field Name |
Data Type |
Field Description |
| 1 |
POSTAL_CODE |
nchar(7) |
The Postal CodeOM of the city. |
| 2 |
CITY |
varchar(45) |
The name of the city of the Postal CodeOM. |
| 3 |
PROVINCE |
varchar(45) |
The name of the province to that Postal CodeOM. |
| 4 |
PROVINCE_ABBR |
char(2) |
The two-letter abbreviation for the province to that Postal CodeOM. |
| 5 |
AREA_CODE |
nchar(3) |
The telephone area code belonging to the particular Postal CodeOM is
located. |
| 6 |
CITY_FLAG |
char(1) |
The flag to determine the Postal CodeOM 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. |
|
|
| |
|
ii. Required Disk Space
|
| |
| Format |
Size |
|
Microsoft® Access
|
80.1 MB
|
|
Microsoft® Excel
|
80.4MB
|
|
dBASE IV
|
173 MB
|
|
Comma-delimited ASCII
|
34.1 MB
|
|
|
|
 |
|
| |
| iii. References
|
| |
|
|
| |
| |
| Related Products
|
|
|
| |
|
|
| Customers Who Purchased This Also Purchased |
|
|
| |
 |
ZipCodeWorld
United States Gold Edition
|
-
Includes ZIP code, city name, alias city name, state code, phone area code,
city type, county name, country FIPS, time zone, day light saving flag,
latitude, longitude, county elevation MSA, PMSA, CBSA and Census 2000 data in
United States.
-
30-day Money Back Guarantee
|
| Sale Price: |
$149.95 |
| List Price: |
$719.40 |
|
 |
PostalCodeOMWorld
Mexico Gold Edition
|
-
Includes Postal CodeOM, city name, colony name, state
abbreviation, state name, latitude, longitude, area code, time zone and
daylight saving flag in Mexico.
-
30-day Money Back Guarantee
|
| Sale Price: |
$899.95 |
| List Price: |
$7199.40 |
|
 |
AreaCodeWorld
Gold Edition
|
-
Includes NPA, NXX, country, state, county, latitude, longitude, LATA, timezone,
day light saving, population, FIPS, MSA, PMSA, CBSA, ZIP code, Operating
Company Number, use type, rate center, COMMON LANGUAGE® identifier and V&H.
-
30-day Money Back Guarantee
|
| Sale Price: |
$599.95 |
| List Price: |
$3599.40 |
|
|
| |
| |
| |
|
