ZIPList Canada Geocode TM (September 2021)

Canadian Postal Code^OM data file with latitude, longitude, city, province, area code, time zone and daylight saving time information for all of Canada!

Download Canadian postal code, latitude, longitude, city, province, area code, time zone and daylight saving time information immediately!

Description
This data file lists every active Postal Code^OM for all of Canada. Includes city and province, as well as latitude, longitude, area code, time zone and daylight saving time. Use this data file with popular commercial database programs such as MS Access, dBase, Paradox, FoxPro, etc. Available for immediate download in native MS Access, dBase, and Paradox formats as well as comma-delimited ASCII (CSV) format. You can incorporate this data into your own dealer/store locator applications to find all stores within a radius or to find the closest store. (We include the distance calculation equations.)

Approximately 821,000 records
Covers all thirteen provinces and territories, including Nunavut
Updated monthly

We update every record in ZIPList Canada Geocode monthly, so you always receive the latest and most up-to-date data. You can't get more accurate and timely Postal Code^OM data from any other source! We include the most recent area code changes in every update. Our Postal Code^OM data comes directly from Canada Post Corporation. We collect and cross-check all the other data continuously from a variety of sources, including NANPA, the telephone companies, and maps.

Note: Canadian Postal Code^OMs and US ZIP codes are also available in one combined file, ZIPList Can-USA Geocode.

Record Layout

Field	Type	Length
City Name	Variable length	30 maximum
Province Code	Fixed length	2
Postal Code^OM	Fixed length	6 alphanumeric characters, plus embedded space
Preferred?	Fixed length	1 ("P", or "A")
Area Code	Fixed length	3 numeric characters
Time zone	Fixed length	5 ("NST", "EST", "EST+1", "CST", "MST", "PST")
DST	Fixed length	1 ("Y" or "N")
Latitude	Fixed length	7 characters: nn.nnnn
Longitude	Variable length	7 or 8 characters: nnn.nnnn

The City Name field identifies the city associated with that Postal Code^OM. There may be several different city names associated with a particular Postal Code^OM. If so, the same Postal Code^OM will appear in several different records, each with a different city name. You can use the Preferred? field to find the best city name to use with the Postal Code^OM in this case. City names include special French characters where appropriate.

The Postal Code^OM field contains only valid 6-character Canadian Postal Code^OMs currently defined by Canada Post Corporation (CPC). Obsolete Postal Code^OMs which have been "retired" from service by CPC are not included in this database. A particular Postal Code^OM may appear in more than one record if the Postal Code^OM crosses the boundary between two cities.

The Preferred? flag can have one of two states, which indicate whether or not the Postal Code^OM exists in more than one city (very few do), and which of those city names is the best to use with this Postal Code^OM. The two states are:

P - This record contains the primary city name for this Postal Code^OM
A - This record contains an alternate city name for this Postal Code^OM

The area code is the "most prevalent" area code for that one Postal Code^OM. If multiple area codes apply to that one Postal Code^OM, only the primary area code is listed. Overlay area codes are not listed.

The time zone field always contains the standard time zone designation for a particular Postal Code^OM. If that Postal Code^OM falls within a political entity which participates in daylight saving time (DST) during the summer months, the DST field is set to "Y". Otherwise the DST field is set to "N".

The latitude and longitude fields contain the geographic coordinates in degrees to four decimal places, providing a general level of accuracy of under 100 feet. For larger Canadian cities, we resolve the latitude and longitude based on the first three characters of the Postal Code^OM (known as the "Forward Sortation Area", or FSA), which corresponds to the 5-digit ZIP code level in the US. The larger Canadian cities often have more than 50 FSAs. This keeps the cost of the product within reason, yet provides a level of resolution perfect for dealer locator and store locator applications.

For rural areas, in most cases, the database contains the latitude and longitude of the center of the city or town. For villages and very small towns in close proximity the database contains the latitude and longitude of the general geographic area. In general, the latitude and longitude values relate to the geographic centroid of the area, not the population centroid.

The latitude/longitude resolution of ZIPList Canada Geocode is equivalent to that of our sister product ZIPList5 Geocode. The two products can readily be combined, since they provide equivalent levels of resolution.

Sample Records

City Name
Aspen
Chester
Beaupré
Cap-Santé
Château-Richer
Saint-Jean-d'Orléans

Province Code
NS
NS
QC
QC
QC
QC

Postal Code^OM
B0H 1E0
B0J 1J0
G0A 1E0
G0A 1L0
G0A 1N0
G0A 3W0

Pref Code
P
P
P
P
P
P

Area Code
902
902
418
418
418
418

Time Zone
EST+1
EST+1
EST
EST
EST
EST

DST Flag
Y
Y
Y
Y
Y
Y

Latitude Degrees
45.2993
44.5508
47.0507
46.6666
46.9667
46.9168

Longitude Degrees
-62.0509
-64.2504
-70.9006
-71.7836
-71.0166
-70.8991

Click here to download sample records in comma-delimited ASCII (CSV) format.

Click here to download sample records in comma-delimited ASCII (CSV) format, compressed with WinZip.

Available File Formats (selected at time of download)

Comma-delimited ASCII (CSV)

Microsoft Excel 2007, 2010, 2013

Microsoft Access 2007, 2010, 2013

Microsoft Access 2003

Paradox 9.0

dBase IV, Visual FoxPro

Licenses
We offer these licenses for ZIPList Canada Geocode:

Workstation License - single-user, single workstation
Enterprise License - unlimited users on unlimited sites within one company

Please read our License Overview to determine which license you need.

Prices

	September 2021 data
Workstation License:	$39.95
Enterprise License:	$99.95

Prices subject to change without notice.

Delivery

Internet:

Download ZIPList Canada Geocode immediately after you place your order online via our secure server. After we check your credit card (which usually takes only a few seconds) we'll return an order confirmation page to your browser containing the information you need to download the data from our server. We'll also include an invoice which states what you ordered and paid. Please print out a copy of this invoice for your records!

If you place your order via phone or mail we will process your order usually within 1 business day. After we process your order we will send you an email message with the download information. We'll include an invoice which states what you ordered and paid.

No shipping and handling charges for Internet delivery.

CDROM:

We'll process and ship your order within one business day. The following shipping and handling charges apply to delivery on CDROM:

Surface	(USA, First Class)	$8.00
International	(Air Mail)	$20.00

Payment
All orders must be prepaid. We do not accept Purchase Orders. We accept Visa, MasterCard, Discover Card and American Express for online or telephone orders.

We also accept checks and money orders in US funds drawn on a US bank. The payment must include shipping and handling charges, if applicable. Orders which do not include appropriate shipping and handling charges will be delayed. If you need an invoice to submit to your accounting department to have a check cut please contact us at 866-256-2042 or 281-292-3270 to place your order. We will prepare a pro forma invoice and send it to you via email or snail mail. However, your order will not be shipped until we receive payment in full.

Attention Texas residents: Orders for delivery to a Texas address, whether downloaded via the Internet or delivered on CDROM, must include sales tax of 8.25% on the total amount of the order, including shipping and handling, if any. A sales tax of 8.25% of the order total will automatically be added to all Texas orders processed through our online ordering system. Tax exempt organizations in Texas must send a tax exemption certificate to sales@zipinfo.com and should contact us at 866-256-2042 to place their orders. Orders which do not include appropriate sales tax or a valid tax exemption certificate will be delayed.

30-Day Money-Back Guarantee
We back ZIPList Canada Geocode with our 30-Day Money-Back Guarantee. If you are not satisfied with ZIPList Canada Geocode we will cheerfully refund the purchase price of the product.

What our Customers say about our Database Products and about us

Postal code database with latitude, longitude, city, province, area code, time zone and daylight saving time information for all of Canada

ZIP code databases - Postal Codes databases - ZIP/Postal Code databases - About Us - Contact Us - Home

Postal code database with latitude, longitude, city, province, area code, time zone and daylight saving time information for all of Canada

Postal Code^OM is an official mark of Canada Post Corporation.

ZIPList Canada Geocode TM (September 2021)

Canadian Postal CodeOM data file with latitude, longitude, city, province, area code, time zone and daylight saving time information for all of Canada!

Canadian Postal Code^OM data file with latitude, longitude, city, province, area code, time zone and daylight saving time information for all of Canada!