Shop

HomeDatabasePostal Code Database Canada

Postal Code Database Canada

$79.00$1,399.00

Download our Canadian Postal Code Database with geographical Coordinates (lat/long) to calculate distances between Postal Codes or to determine all Postal Codes within a given radius.

Clear
SKU:GZ-CA Category:
Description

Details (Last update: February 2023)

The Canadian Postal Code Database contains all Canadian Postal Codes in the format A0A 0A0, the city for each postal code, province, and manually verified latitude & longitude coordinates. All ‘Forward sortation areas’ (FSA) and all ‘Local delivery units’ (LDU) are included.

Datatable Structure

FIELDNAME
DATATYPE
id
integer
countrycode
varchar(2)
zipcode
varchar(7)
city
varchar(64)
region
varchar(64)
regioncode
varchar(2)
latitude
decimal(13, 9)
longitude
decimal(13, 9)

Database Content

DATA
AMOUNT
Provinces
13
Cities
7,507
Unique Postal Codes
869,130
Geocoded locations
100 %
Number of records
881,637

USA ZIP Code Database is Provided in CSV Format to be easily imported into

Postal Codes within a Radius

Having a database of localities with their latitudes and longitudes enables you to locate the closest cities to a set point (or within a radius of X).

To help you implement a ZIP code radius or distance search, we offer free access to example codes in many scripting and programming languages like ASP (VBScript), ASP.NET (C#), PHP, Coldfusion and more.

Since we stand behind the accuracy of our product, the formulas in our example scripts take the earth’s curvature into consideration. With this in play, the accuracy of our product is pinpoint.

Sample Data

id;country;zipcode;city;region;regioncode;latitude;longitude

496962;CA;M3C 0C1;Toronto;Ontario;ON;43.72193489;-79.3507477

496963;CA;M3C 0C2;Toronto;Ontario;ON;43.72197424;-79.3508191

496964;CA;M3C 0C3;Toronto;Ontario;ON;43.72205251;-79.3509612

496965;CA;M3C 0C4;North York;Ontario;ON;43.72614762;-79.3413728

496966;CA;M3C 0C5;North York;Ontario;ON;43.72597796;-79.341065

496967;CA;M3C 0C6;North York;Ontario;ON;43.72671525;-79.3289224

496968;CA;M3C 0C7;North York;Ontario;ON;43.72592374;-79.3409666

496969;CA;M3C 0C8;North York;Ontario;ON;43.7260007;-79.3411062

496970;CA;M3C 0E1;North York;Ontario;ON;43.72632733;-79.3416989

496971;CA;M3C 0E3;Toronto;Ontario;ON;43.65789182;-79.385062

496972;CA;M3C 0E4;Toronto;Ontario;ON;43.72012359;-79.3502239

496973;CA;M3C 0E5;North York;Ontario;ON;43.73679386;-79.3454287

496974;CA;M3C 0E6;North York;Ontario;ON;43.72619791;-79.3414641

496975;CA;M3C 0E7;North York;Ontario;ON;43.73480968;-79.344491

496976;CA;M3C 0E8;North York;Ontario;ON;43.73547534;-79.3452698

496977;CA;M3C 0E9;North York;Ontario;ON;43.73463512;-79.3448999

496978;CA;M3C 0G1;North York;Ontario;ON;43.73407614;-79.3471223

496979;CA;M3C 0G2;North York;Ontario;ON;43.74624816;-79.299229

496980;CA;M3C 0G3;North York;Ontario;ON;43.72630897;-79.3416656

496981;CA;M3C 0G4;North York;Ontario;ON;43.73428845;-79.3437672

496982;CA;M3C 0G5;North York;Ontario;ON;43.72618348;-79.3414379

496983;CA;M3C 0G6;North York;Ontario;ON;43.73495081;-79.3464523

496984;CA;M3C 0G7;North York;Ontario;ON;43.73511895;-79.3457398

496985;CA;M3C 0G8;North York;Ontario;ON;43.72609821;-79.3412832

Additional information
License

Single, Enterprise, Redistribution

Subscription

1 Year, 2 Years, 3 Years, Lifetime

Reviews

There are no reviews yet.

Be the first to review “Postal Code Database Canada”

Your email address will not be published.