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.
Description
Details (Last update: April 2024)
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.