ZIP Code List & Demographics Database Download: Digital ZIP Code Database & Maps

1-800-425-1169

 

FREE ZIP Code Finder
Enter ZIP Code:

*Find Info on any U.S. ZIP Code
Find ZIP of Address
Address(U.S.):
Town/City:
State:
 

*Find the ZIP Code, county, and +4 of any U.S. Address
Other FREE Lookups
Town/City:
State:
County:
Area Code:
 

*Lookup ZIP Code of any city, state, county or area code
FREE Radius Search
Find all ZIP Codes

Between
And
of ZIP Code:
 

Download the Radius Finder ApplicationDownload the FREE Radius Finder Application

FREE Distance Calc
Calculate the distance between two U.S. or Canadian ZIP codes.

Start ZIP:
End ZIP:
 

News & Specials
E-mail Address:
 

Sign up for news and specials. We value your privacy. Your address will not be sold, traded or given to any third parties.






Canadian Postal Code Database

Questions? 1-800-425-1169



What is a Postal Code Database?
A set of data put into row and column format for easy use and manipulation. With 22 unique fields of information, it virtually gives you an unlimited number of ways to analyze all the Canadian Postal Code information.
  • Unlimited users and downloads
  • 1 year of access with monthly updates
  • Immediate download upon purchase, no shipment required
  • Multiple data formats - Excel, Access, CSV (comma delimited)

$99.95
Standard
$199.95
Deluxe
$349.95
Business

$99.95

  This version includes:

  Also Includes:

$199.95

  This version includes:

  Also Includes:

$349.95

  This version includes:

  Also Includes:

Standard Database

1 YEAR SUBSCRIPTION
Download Sample Data

AVAILABLE FORMATS:
MICROSOFT® ACCESS
MICROSOFT® EXCEL
COMMA-DELIMITED (CSV)

IMMEDIATE DOWNLOAD

$99.95

Deluxe Database

1 YEAR SUBSCRIPTION
Download Sample Data

AVAILABLE FORMATS:
MICROSOFT® ACCESS
MICROSOFT® EXCEL
COMMA-DELIMITED (CSV)

IMMEDIATE DOWNLOAD

$199.95

Business Database

1 YEAR SUBSCRIPTION
Download Sample Data

AVAILABLE FORMATS:
MICROSOFT® ACCESS
MICROSOFT® EXCEL
COMMA-DELIMITED (CSV)

IMMEDIATE DOWNLOAD

$349.95

Purchase the Canadian Database

  • Immediate Download after purchase
  • 1 Year Subscription with Monthly Updates
  • All subscriptions are not automatically renewed.
  • Visa, Mastercard, American Express, or Mail In Check/Purchase Order accepted
  • Download all file formats if needed (Access, Excel, and Comma Delimited)

Standard Database

1 YEAR SUBSCRIPTION
Download Sample Data

AVAILABLE FORMATS:
MICROSOFT® ACCESS
MICROSOFT® EXCEL
COMMA-DELIMITED (CSV)

IMMEDIATE DOWNLOAD

$99.95

Deluxe Database

1 YEAR SUBSCRIPTION
Download Sample Data

AVAILABLE FORMATS:
MICROSOFT® ACCESS
MICROSOFT® EXCEL
COMMA-DELIMITED (CSV)

IMMEDIATE DOWNLOAD

$199.95

Business Database

1 YEAR SUBSCRIPTION
Download Sample Data

AVAILABLE FORMATS:
MICROSOFT® ACCESS
MICROSOFT® EXCEL
COMMA-DELIMITED (CSV)

IMMEDIATE DOWNLOAD

$349.95

Redistribution License

Currently Unavailable

Database Technical Specifications


Downloads


Show:

  • All Fields
  • Standard Database Fields Only
  • Deluxe Database Fields Only
  • Business Database Fields Only
Field Name Data Type Description
PostalCode Char(7) The Postal Code of the record in ANA NAN format.
City VarChar(45) The name of the city, town or village of the Postal Code.
Province Char(2) The two-letter abbreviation for the province to that Postal Code.
ProvinceName VarChar(45) The name of the province to that Postal Code.
AreaCode VarChar(3) The telephone area code for this Postal Code.
CityFlag Char(1) Yes/No flag indicating if the Postal Code is in a City.
TimeZone Integer The time Zone Number for which this Postal Code belongs to.
DST Char(1) Indicates whether they observe Day Light Savings Time.
Latitude Decimal(12, 8) Geographic coordinate measured in degrees north or south of the equater.
Longitude Decimal(12, 8) Geographic coordinate measured in degrees east or wets of the Greenwich Meridian.
Elevation Integer Average elevation of the Postal Code in meters.
Population Integer The population count for the Forward Sortation Area by Canadian Census 2006.
Dwellings Integer The total number of private dwellings count for the Forward Sortation Area by Canadian Census 2006.
AreaName VarChar(45) Major community name or greater municipality grouping that contains the street address or its delivery installation as recognized by the Canada Post.
StreetName VarChar(45) The official civic name of a roadway or artery as recognized by Canada Post.
StreetTypeCode Char(6) Official description used to identify the type of road or artery.
StreetDirCode Char(2) The street direction component of an official street name.
StreetSeqCode Char(1) Identifies the sequence associated with the range of street numbers.
StreetFromNo VarChar(6) Lowest street number in a range of municipal street addresses.
StreetFromSuffix Char(1) The address suffix associated with the street address from number.
StreetToNo VarChar(6) Highest street number in a range of municipal street addresses.
StreetToSuffic Char(1) The address suffix associated with the street address to number.

Canadian Postal Code Database FAQs

  1. What methods of payment do you accept?
  2. Do you accept purchase orders?
  3. What format does the database come in?
  4. How do I get the monthly database updates?
  5. Will a CD be mailed to me? How do I get the database?
  6. What happens after my 1 year subscription?
  7. How much does it cost to renew?
  8. Do you include Postal Codes for all of Canada?
  9. How often do you update the database?
  10. How current is the data?
  11. How accurate is the data?
  12. Do you have any other countries besides Canada?
  13. How long does it take to get the data?
  14. Can I automate the database delivery?

Q. What methods of payment do you accept?

A. We accept Visa, Mastercard, American Express, and PayPal for immediate download. You can also place your order choosing Mail In Check or Purchase Order but you will be unable to download the database until your payment is received.

Back to Top

Q. Do you accept purchase orders?

A. Yes, we can accept purchase orders. Simply go through the order process as normal. When you come to the payment screen, choose Purchase Order as the payment type and complete your order. You can then print out a purchase order and mail in the payment. Once payment is received, access to download the database will be turned on.

Back to Top

Q. What format does the database come in?

A. Our Canadian Postal Code Database is provided in three (3) formats: Microsoft® Access [MDB], Microsoft® Excel [XLS], and ASCII Comma Delimited [CSV].

Back to Top

Q. How do I get the monthly database updates?

A. When you purchase, you setup a username and password. Each month, we will notify you via email that an update database is available. Visit our site and login using your username and password. The updated databases will be available for download in any format we provide as well as a transactional log file with just the changes only.

Back to Top

Q. Will a CD be mailed to me? How do I get the database?

A. No, our Canadian Postal Code Database is not mailed to you on CD. Once your order is completed, you will be able to download immediately. All monthly updates are also provided for online download. This ensures fastest delivery as the databse is updated each month.

Back to Top

Q. What happens after my 1 year subscription?

A. When your Canadian Postal Code Database subscription is expiring, we will notify you by email 30, 10, and 1 day in advance. You can choose to renew at the current rate, or let your subscription expire. You can continue to use the database after your subscription has expired, but the data will become outdated very quickly.

Back to Top

Q. How much does it cost to renew?

A. Currently, renewal prices are the same as the original purchase price.

Back to Top

Q. Do you include Postal Codes for all of Canada?

A. Yes. Postal Code data is provided for all Canadian provinces and territories.

Back to Top

Q. How often do you update the database?

A. Our Canadian Postal Code Database is updated every month.

Back to Top

Q. How current is the data?

A. Our Canadian Postal Code Database is updated every month. the data is current as of November, 2009

Back to Top

Q. How accurate is the data?

A. Accurate data is critical to the success of your business and ours. Zip-Codes.com implements a very rigorous set of data integrity checks to ensure our database is as accurate as possible. In the unlikely event that a portion of data is confirmed as innaccurate, we will correct it within 2 business days.

Back to Top

Q. Do you have any other countries besides Canada?

A. Yes. We also have the U.S. ZIP Code Database.

Back to Top

Q. How long does it take to get the data?

A. Instantly. As soon as your order is confirmed and payment is received, you will get the database immediately after purchase.

Back to Top

Q. Can I automate the database delivery?

A. Yes! Please email us requesting an FTP Account be setup for you to use in automating your processes. Please include your username or order number for reference. We will have it up and running within 1 hour.

Back to Top

Postal Code Tools & Resources

Zip-Codes.com offers it's client several free applications, tools, and sample code to all of it's client's. It's our way of saying thank you and helping you make the most of what we offer.

 

Database Scripts

These scripts work on yourSQL Server or MySQL Server establishing the table, columns, and column definitions before importing the data. To use them, execute the full file contents in Enterprise Manager, SQL Server Management Studio, phpMyAdmin, or other SQL Command Interface.

SQL Server 2000 & 2005

• Standard Database [ Download ]
• Deluxe Database [ Download ]
• Business Database [ Download ]

MySQL

• Standard Database [ Download ]
• Deluxe Database [ Download ]
• Business Database [ Download ]

 

Sample Code

The sample code provided here is meant as an example of how some functions can be performed.

Distance Functions:

Calculate the distance between two latitude/longitude coordinates.

• VBScript [ View ]
• PHP [ View ]
• VB.Net [ View ]
• C# [ View ]
• Visual Basic (VB6) [ View ]
• Coldfusion [ View ]
• MS SQL Server [User defined scalar function] [ View ]

 

Radius Finder

The Radius Finder Application is free for our all of our Canadian Postal Code Database Customers and comes bundled with the Access Database. It features:

  • Unlimited Radius Searches
  • Unlimited Radius Distance
  • Works with U.S. & Canadian databases
  • Population, Demographics & Business Data returned in the results
  • Copy and Paste results into other applications
  • Run searches for Multiple ZIP Code Radius' at the same time
  • Export data to a CSV file
  • Works on your computer, not online

 

 

Why Choose Us?

  1. We offer more data fields than our competitors at a lower price
  2. Tools & Resources to help you achieve your goals more efficiently
  3. Unlimited number of users included in all prices
  4. Download to as many computers as you like
  5. 12 months of updates - we update our data each month
  6. Immediate download upon purchase
  7. We are a U.S. company
  8. Multiple data formats - Excel, Access, CSV (comma delimited)
  9. FREE radius finder application with every purchase