Lifetime updates. Come back once in a while to stay updated of new versions of this database.

764,852 Canadian Postal Codes (6,578 Cities / Towns / Places)

Database Description:

This database contains 764,852 unique postal codes of Canada across 13 provinces and territories. Each postal code record consists of the city / town name, province / territory (name and abbreviation code), city type, latitude and longitude.

List of Canada provinces and territories in this database: Alberta, British Columbia, Manitoba, New Brunswick, Newfoundland, Nova Scotia, Northwest Territories, Nunavut, Ontario, Prince Edward Island, Quebec, Saskatchewan and Yukon Territory.

Database Meta:

  • Size: 77.3 MB
  • Last updated: June 19th, 2011
  • Formats Included: MySQL dump .sql text file, CSV, MS Excel
  • Tables: 2

Buy Now & Download: $69.00 (USD)


phpMyAdmin Screenshots:

MySQL Database: 764,852 Canadian Postal Codes (6,578 Cities / Towns / Places) for Sale

Table Details (Data Structure / Schema):

  • place
    Records:765,344

    The table containing all the postal codes for all Canada cities with latitude and longitude.

    Data fields

    1. id: int(11)
    2. postal_code: char(7)
    3. city: varchar(40)
    4. province_code: varchar(255)
    5. city_type: varchar(255)
    6. latitude: varchar(255)
    7. longitude: varchar(255)
  • province
    Records:13

    All provinces and territories of Canada.

    Data fields

    1. id: int(11)
    2. title: varchar(255)
    3. code: varchar(255)

Buy Now & Download: $69.00 (USD)



Download link will be sent to your PayPal email. Please check spam folder in case you didn't see it in your inbox. Do contact us if you didn't receive it 10 minutes after payment. We will manually send you the download details in 24 hours. Our support staff work in the time zone of GMT+8.

Instant download upon payment success, just press return button on PayPal website after finishing payment.

Potential Applications / Usage:

  • Canada postal information site
  • City-related guides of Canada
  • City postal code lookup / search engine
  • National / local information site for Canada
  • Place names lists / post code drop-downs for HTML forms

Other Available Formats:

Some of these formats are available on extra charge, depending on the database.

  • Plain CSV
  • CSV for Microsoft Excel
  • Microsoft Excel .XLS file (2008, 2007, 2003, 2000)
  • Microsoft Word .DOC file (2008, 2007, 2003, 2000)
  • LaTeX
  • Open Document Spreadsheet
  • Open Document Text
  • PDF
  • XML
  • YAML
  • WordPress Category / Post Database
  • Single Table Format

As we frequently enhance our databases for sale, make sure you revisit once in a while to stay updated of the databases you have purchased. Simply by clicking through the same URL we sent to you, you can download updated versions.