Canada Postal Codes Database Subscription with Mixed Case Uppercase City Names


	Home		View Cart		My Account

|

|

|

|

|

Affiliate Program

|

|

|

|

PostalCode^OMWorld Canadian Gold + Mixed Case Edition

PostalCodeWorld Canadian Gold + Mixed Case Edition

PostalCodeWorld Canadian Gold + Mixed Case Edition

Get Extra Savings with 1 Year Subscription!

The List Price is ~~$7199.40~~.
Get It $999.95 Now.


	ORDER NOW!
or 1 Month Subscription at $599.95

Last Update:

July 2008

Next Update:

August 2008

Product Overview

PostalCode^OMWorld Canadian Gold Mixed Case Edition - The database includes city name reference in uppercase and mixed-case, 6-character Postal Code^OM, 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^OM for mailing addresses. The complete database contains over 800,000 unique Postal Code^OM records with individual latitude and longitude. PostalCode^OMWorld is licensed distributor of Postal Code^OM 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. The 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.

PostalCodeWorld Canadian Gold + Mixed Case Edition

Pricing

Subscription Period	Price

1 Year Subscription	$999.95*

1 Month Subscription	$599.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	UPPERCASE_NAME	varchar(256)	City name in UPPERCASE.
2	MIXED_CASE_NAME	varchar(256)	City name in Mixed Case.

Field#	Field Name	Data Type	Field Description
1	ZIP_CODE	nchar(5)	The ZIP Code of the city designated by the USPS.
2	CITY	varchar(35)	The name of the city designated by the USPS.
3	STATE	char(2)	The two-letter abbreviation for the state to that particular ZIP code.
4	AREA_CODE	varchar(40)	The telephone area code belonging to the particular Postal Code^OM is located.
5	CITY_ALIAS_NAME	varchar(35)	The alias name for the ZIP Code. This may be a city name, postal entity, community or a municipality name.
6	CITY_ALIAS_ABBR	varchar(13)	This is a standard 13-character abbreviation for city alias name. This field is empty if names are less or equal to 13-character.
7	CITY_TYPE	char(1)	The field indicates the type of locale identified in the city alias name such as Post Office, station or branch.
8	COUNTY_NAME	varchar(25)	The name of the county or parish in which the 5-digit ZIP Code resides.
9	STATE_FIPS	nchar(2)	The FIPS code assigned to state.
10	COUNTY_FIPS	nchar(3)	The FIPS code assigned to given county or parish within a state.
11	TIME_ZONE	nchar(2)	The time zone number represents by the hours past the Greenwich Time Zone.
12	DAY_LIGHT_SAVING	char(1)	This flag indicates whether the city observe day light saving.
13	LATITUDE	numerical	The geographic coordinate of a point measured in degrees north or south of the equator.
14	LONGITUDE	numerical	The geographic coordinate of a point measured in degrees east or west of the Greenwich meridian.
15	ELEVATION	numerical	The counties average elevation.
16	MSA2000	nchar(4)	Metropolitan Statistical Area based on Census 2000
17	PMSA	nchar(4)	Primary Metropolitan Statistical Area
18	CBSA	nchar(5)	Core Based Statistical Area, Metropolitan Statistical Area and Micropolitan Statistical Area released by OMB in Year 2003
19	CBSA_DIV	nchar(5)	Metropolitan Division
20	CBSA_TITLE	varchar(128)	Full title description of CBSA and MSA
21	PERSONS_PER_HOUSEHOLD	numeric	The average amount of persons per Household based on Census 2000.
22	ZIPCODE_POPULATION	numeric	The population of the ZIP Code based on Census 2000.
23	COUNTIES_AREA	numeric	The counties square mileage based on Census 2000.
24	HOUSEHOLDS_PER_ZIPCODE	numeric	Total estimated amount of households per ZIP Code based on Census 2000.
25	WHITE_POPULATION	numeric	The estimate of Black population per ZIP code based on Census 2000.
26	BLACK_POPULATION	numeric	The estimate of Black population per ZIP code based on Census 2000.
27	HISPANIC_POPULATION	numeric	The estimate of Hispanic population per ZIP code based on Census 2000.
28	INCOME_PER_HOUSEHOLD	numeric	The average household income within county based on Census 2000.
29	AVERAGE_HOUSE_VALUE	numeric	The average house value within county based on Census 2000.

ii. Required Disk Space

Format	Size
Microsoft� Access	80.1 MB
Microsoft� Excel	80.4 MB
dBASE IV	173 MB
Comma-delimited ASCII	34.1 MB

satisfaction guaranteed

iii. References

	PostalCode^OMWorld Canadian Gold + Mixed Case Edition Data File Specifications
	License Agreement

Related Products

	PostalCode^OMWorld Canadian Basic Edition
	PostalCode^OMWorld Canadian Premium Edition
	PostalCode^OMWorld Cabadian Gold Edition
	ZIPCodeWorld Desktop

ZIP Code Data


	USA - Basic
	USA - Premium
	USA - Gold
	USA - Gold (Multi-County)
	USA - Gold (Congressional District)
	USA - Gold (3-Digit ZIP code)
	USA - Gold (Business Patterns)
	USA - Gold (Mixed Case)
	USA - Gold (PO Box)

Canada Postal Code


	Canada - Basic
	Canada - Premium
	Canada - Gold
	Canada - Gold (Mixed Case)

Mexico Postal Code


	Mexico - Basic
	Mexico - Premium
	Mexico - Gold

Area Code Data

Area Code Exchange


	NPA NXX - Basic
	NPA NXX - Premium
	NPA NXX - Gold
	NPA NXX - Platinum

Map Products

USA Digital Maps


	ZIP Code State Maps
	3 Digit ZIP Code Map

Canada Digital Maps


	3 Digit FSA Postal Code Map

Software Products

ZIPCodeWorld Desktop Application

ZIPCodeWorld Utility .NET Component

Web Store Locator

.NET XML Control

Custom Programming Services

Free Sample Codes

SOAP XML Web Services


	World Postal Code Resources


	Affiliates
	Customers
	Developers

"The street-level latitude and longitude in the PostalCodeWorld Premium Edition is so accurate. It has blown the competitors away."

- Jeff Gordon (Montreal, QC)

Who Are Our Customers?

Take a closer look in this
in-depth tour and learn more about ZIPCodeWorld™ products:

	Products overview (SWF:720K)

	Products overview (PDF:1.33M)

Over the last 12 months we've added 260 new USPS ZIP Codes and 7,438 new Canadian Postal Codes to our data.

Legal Disclaimer

Copyright © 2001-2008. ZIPCodeWorld.com. All Rights Reserved.

The United States Postal Service® has provided all ZIP Code™ information contained in the ZIPCodeWorld United States Gold Edition database.
ZIP Code™ is a trademark of the United States Postal Service.
Postal Code is an official mark of Canada Post Corporation.