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:

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)

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