Canada Postal Code - population, dwelling, elevation, longitude, latitude, timezone, postal code, area code

Overview - PostalCodeWorld™ Canadian Gold Edition

PostalCodeWorld™ Canadian Postal Code Gold Edition

Product Summary: PostalCodeWorld™ Canadian Gold Edition - The database includes postal code, 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 780,000 unique postal code records with individual latitude and longitude. PostalCodeWorld™ is licensed distributor of postal code database from Canada Post Corporation.

Sample database and full database are available to download instantly. Order your PostalCodeWorld™ 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.

Subscription Period One Month One Year

List Price ~~$399.95~~ ~~$699.95~~

Sale Price $249.95 $499.95

Order Now

Latest Edition December 2009

Free Demo [ Postal Code Lookup ]

View Sample Database [ View ] Comma-delimited ASCII

Download Sample Database [ Download ] ASCII Text, Microsoft® Excel, Microsoft® Access and dBASE Samples in a ZIP file

Database Specification [ Download ] Postal Codes Database Columns Definition

Database Comparison [ View ]

You can request for a comprehensive sample database for evaluation purpose. Please fill up the form below to receive the sample via email.

Email:

Name:

Order

PostalCodeWorld™ Package	Price (US$)	Order Now (Credit Card)
PostalCodeWorld™ CANADA Gold Edition - 1-Month Subscription	$249.95
PostalCodeWorld™ CANADA Gold Edition - 1-Year Subscription w/ Monthly Update	$499.95

Download (Subscription)

Format	Extension	Download Size	Download (Complete)	Download (Sample)
Microsoft® Access	MDB	11.7 MB	[ Download ]	[ Download ]
Microsoft® Excel	XLS	22.1 MB	[ Download ]
dBASE IV	DBF	12.0 MB	[ Download ]
Comma-delimited ASCII	CSV	2.4 MB	[ Download ]

Product Features & Benefits

Low Price - Get More Value, Pay Less
Unique Latitude and Longitude - Precise Coordinates for Street Level Postal Codes
30-Day Money Back Guarantee - No Risk, Satisfaction Guarantee
Monthly Update - 100% Accurate Postal codes and ZIP codes Data
Free Customer Service - Good After Sales Service
Single Download and Subscription Available - Pay Only What You Need
Corporate Site License - Free Distribution Within An Organization
Available in Different Formats - Save Conversion Time
Thousands of Happy Customers - 3M Company, Apple Computer, AT&T, BASF, Deloitte & Touche, Department of Justice, FedEx, IBM, Microsoft, Nortel Networks, Procter & Gamble, Samsung, Walmart, Well Fargo and many more.

Technical Specification

i. Database Fields

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.