Download our USA + Canada ZIP/ Postal Code Database with geographical Coordinates (lat/lon) to calculate distances between ZIP Codes or to determine all ZIP Codes within a given radius.
Canadian Postal Codes OM database. Over 870,000 postal code records. For multiple cities per Postal Code try our Canada Plus version (1.2 million records). Latitude & longitude, area codes, time zones. Mexico Postal Database. Our Mexican Postal Code database has over 140,000 records with what we believe to be the most accurate latitude. Do you include Postal Code OM s for all of Canada? Postal Code OM data is provided for all Canadian provinces and territories. How often do you update the database? Our Canadian Postal Code OM Database is updated every month. How current is the data?
Details (Last update: 1. March 2020)
The USA + Canadian ZIP Code Database contains all US ZIP Codes and all Canadian Postal Codesand the city for each ZIP /postal code, state / province, and manually verified latitude & longitude coordinates.
Datatable Structure
| Fieldname | Datatype |
|---|---|
| countrycode | varchar(2) |
| zipcode/postalcode | varchar(7) |
| city | varchar(64) |
| state/province | varchar(48) |
| statecode/provincecode | varchar(2) |
| timezone | varchar(10) |
| daylightsaving | varchar(1) |
| latitude | decimal(13, 9) |
| longitude | decimal(13, 9) |
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. The Postal Code database that corresponds Postal Codes to geographic locations denoted by a Longitude and Latitude or Street Address range. Government of Canada. (2013, May 18). Need to know if the Postal Codes are available for download for general use.
Database Content USA
| Data | Amount |
|---|---|
| States | 50 (+ 12 Army / Overseas) |
| Cities | 29,743 |
| Unique ZIP Codes | 42,037 |
| Geocoded locations | 100 % (except: Armed Forces in Overseas) |
| Number of records | 42,122 83,102 (City Aliases counted) |
Database Content Canada
| Data | Amount |
|---|---|
| Provinces | 13 |
| Cities | 7,292 |
| Unique Postal Codes | 851,425 |
| Geocoded locations | 100 % |
| Number of records | 852,149 |
ZIP Codes and 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/postal 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.
Working examples
Sample Data
US;94301;Palo Alto;Palo Alto;SANTA CLARA;085;California;CA;06;GMT -08:00;Y;37.44300418;-122.151342
US;94302;Palo Alto;Palo Alto;SANTA CLARA;085;California;CA;06;GMT -08:00;Y;37.44184901;-122.142186
US;94303;Palo Alto;East Palo Alto/Palo Alto/E Palo Alto;SANTA CLARA;085;California;CA;06;GMT -08:00;Y;37.45809827;-122.123543
US;94304;Palo Alto;Palo Alto;SANTA CLARA;085;California;CA;06;GMT -08:00;Y;37.40446424;-122.167761
US;94305;Stanford;Stanford/Palo Alto;SANTA CLARA;085;California;CA;06;GMT -08:00;Y;37.42403628;-122.167743
US;94306;Palo Alto;Palo Alto;SANTA CLARA;085;California;CA;06;GMT -08:00;Y;37.41185385;-122.129525
US;94309;Palo Alto;Palo Alto/Stanford;SANTA CLARA;085;California;CA;06;GMT -08:00;Y;37.44172883;-122.141794
US;94401;San Mateo;San Mateo;SAN MATEO;081;California;CA;06;GMT -08:00;Y;37.57431309;-122.319760
US;94402;San Mateo;San Mateo;SAN MATEO;081;California;CA;06;GMT -08:00;Y;37.54005540;-122.330554
US;94403;San Mateo;San Mateo;SAN MATEO;081;California;CA;06;GMT -08:00;Y;37.54076023;-122.304490
US;94404;San Mateo;San Mateo/Foster City;SAN MATEO;081;California;CA;06;GMT -08:00;Y;37.55468039;-122.269424
US;94497;San Mateo;San Mateo/Postal Data Center;SAN MATEO;081;California;CA;06;GMT -08:00;Y;37.56333681;-122.324719
US;94501;Alameda;Alameda Pt/Alameda;ALAMEDA;001;California;CA;06;GMT -08:00;Y;37.77358919;-122.278630
US;94502;Alameda;Alameda;ALAMEDA;001;California;CA;06;GMT -08:00;Y;37.73443455;-122.244457
US;94503;American Canyon;American Cyn/Vallejo/American Canyon;NAPA;055;California;CA;06;GMT -08:00;Y;38.20397306;-122.233153
US;94505;Discovery Bay;Byron/Discovery Bay;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;37.88902420;-121.602884
US;94506;Danville;Blackhawk/Danville;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;37.81024114;-121.911398
US;94507;Alamo;Alamo;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;37.85322261;-121.991061
US;94508;Angwin;Angwin;NAPA;055;California;CA;06;GMT -08:00;Y;38.58514151;-122.441484
US;94509;Antioch;Antioch;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;37.99013887;-121.808322
US;94510;Benicia;Benicia;SOLANO;095;California;CA;06;GMT -08:00;Y;38.09537842;-122.126919
US;94511;Bethel Island;Bethel Island;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;38.05373416;-121.628572
US;94512;Birds Landing;Birds Landing;SOLANO;095;California;CA;06;GMT -08:00;Y;38.12754463;-121.839100
US;94513;Brentwood;Brentwood;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;37.90000170;-121.735850
US;94514;Byron;Byron/Discovery Bay;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;37.81948219;-121.642957
US;94515;Calistoga;Calistoga;NAPA;055;California;CA;06;GMT -08:00;Y;38.61859880;-122.586085
US;94516;Canyon;Canyon;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;37.83292913;-122.189194
US;94517;Clayton;Clayton;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;37.89476070;-121.872360
US;94518;Concord;Concord;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;37.95367031;-122.022334
US;94519;Concord;Concord;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;37.99041933;-122.002070
US;94520;Concord;Clyde/Concord;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;38.00493565;-122.036583
US;94521;Concord;Concord;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;37.96557417;-121.953044
US;94522;Concord;Concord;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;37.97849304;-122.030498
US;94523;Pleasant Hill;Concord/Pleasant Hill;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;37.95394152;-122.078409
US;94524;Concord;Concord;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;37.97877750;-122.031412
US;94525;Crockett;Crockett;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;38.04861495;-122.229860
US;94526;Danville;Danville;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;37.81399980;-121.998889
US;94527;Concord;Concord;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;37.97852760;-122.030610
US;94528;Diablo;Diablo;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;37.84140708;-121.962956
US;94529;Concord;Chevron/Chevron Usa Inc/Concord;CONTRA COSTA;013;California;CA;06;GMT -08:00;Y;37.97845772;-122.030385
CA;M4J 4Z9;Toronto;Ontario;ON;GMT -05:00;Y;43.67661346;-79.3280197
CA;M4J 5A1;Toronto;Ontario;ON;GMT -05:00;Y;43.67593793;-79.3286134
CA;M4J 5A2;Toronto;Ontario;ON;GMT -05:00;Y;43.67623031;-79.3291471
CA;M4J 5A3;Toronto;Ontario;ON;GMT -05:00;Y;43.67567894;-79.3294478
CA;M4J 5A4;Toronto;Ontario;ON;GMT -05:00;Y;43.67618048;-79.3297304
CA;M4J 5A5;Toronto;Ontario;ON;GMT -05:00;Y;43.67657460;-79.3303585
CA;M4J 5A6;Toronto;Ontario;ON;GMT -05:00;Y;43.67733607;-79.3305363
CA;M4J 5A7;Toronto;Ontario;ON;GMT -05:00;Y;43.67747250;-79.3303820
CA;M4J 5A9;Toronto;Ontario;ON;GMT -05:00;Y;43.67770673;-79.3305091
CA;M4J 5B1;East York;Ontario;ON;GMT -05:00;Y;43.68977228;-79.3416175
CA;M4J 5B2;Toronto;Ontario;ON;GMT -05:00;Y;43.67711312;-79.3299036
CA;M4J 5B3;Toronto;Ontario;ON;GMT -05:00;Y;43.68134897;-79.3379472
CA;M4J 5B5;Toronto;Ontario;ON;GMT -05:00;Y;43.68189053;-79.3314979
CA;M4J 5B6;Toronto;Ontario;ON;GMT -05:00;Y;43.68221689;-79.3317368
CA;M4J 5B7;Toronto;Ontario;ON;GMT -05:00;Y;43.67825982;-79.3352564
CA;M4J 5B8;Toronto;Ontario;ON;GMT -05:00;Y;43.67905960;-79.3355132
CA;M4J 5B9;Toronto;Ontario;ON;GMT -05:00;Y;43.67919750;-79.3447097
CA;M4J 5C2;East York;Ontario;ON;GMT -05:00;Y;43.69067085;-79.3280439
CA;M4J 5C3;Toronto;Ontario;ON;GMT -05:00;Y;43.68352865;-79.3253955
CA;M4J 5C4;Toronto;Ontario;ON;GMT -05:00;Y;43.68315106;-79.3239657
CA;M4J 5C6;East York;Ontario;ON;GMT -05:00;Y;43.69551609;-79.3448094
CA;M4J 5C7;East York;Ontario;ON;GMT -05:00;Y;43.69629607;-79.3453371
CA;M4K 1A1;Toronto;Ontario;ON;GMT -05:00;Y;43.66622205;-79.3527685
CA;M4K 1A2;Toronto;Ontario;ON;GMT -05:00;Y;43.66643034;-79.3531440
CA;M4K 1A3;Toronto;Ontario;ON;GMT -05:00;Y;43.66766848;-79.3475204
CA;M4K 1A4;Toronto;Ontario;ON;GMT -05:00;Y;43.66778944;-79.3477422
CA;M4K 1A5;Toronto;Ontario;ON;GMT -05:00;Y;43.66821201;-79.3459004
CA;M4K 1A6;Toronto;Ontario;ON;GMT -05:00;Y;43.66812817;-79.3455120
CA;M4K 1A7;Toronto;Ontario;ON;GMT -05:00;Y;43.66734918;-79.3537498
CA;M4K 1A8;Toronto;Ontario;ON;GMT -05:00;Y;43.66860324;-79.3485686
CA;M4K 1A9;Toronto;Ontario;ON;GMT -05:00;Y;43.66861746;-79.3481962
Shopping cart
Other Products
Free Tools
ZIP Codes in a Radius
Distance between ZIP Codes
Download our Canadian Postal Code Database with geographical Coordinates (lat/lon) to calculate distances between Postal Codes or to determine all Postal Codes within a given radius.
Details (Last update: 1. March 2020)
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 |
|---|---|
| countrycode | varchar(2) |
| postalcode | varchar(7) |
| city | varchar(64) |
| province | varchar(48) |
| provincecode | varchar(2) |
| timezone | varchar(10) |
| daylightsaving | varchar(1) |
| 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 | 871,178 |
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.
Working examples
Sample Data
CA;M4J 4Z9;Toronto;Ontario;ON;GMT -05:00;Y;43.67661346;-79.3280197
CA;M4J 5A1;Toronto;Ontario;ON;GMT -05:00;Y;43.67593793;-79.3286134
CA;M4J 5A2;Toronto;Ontario;ON;GMT -05:00;Y;43.67623031;-79.3291471
CA;M4J 5A3;Toronto;Ontario;ON;GMT -05:00;Y;43.67567894;-79.3294478
CA;M4J 5A4;Toronto;Ontario;ON;GMT -05:00;Y;43.67618048;-79.3297304
CA;M4J 5A5;Toronto;Ontario;ON;GMT -05:00;Y;43.67657460;-79.3303585
CA;M4J 5A6;Toronto;Ontario;ON;GMT -05:00;Y;43.67733607;-79.3305363
CA;M4J 5A7;Toronto;Ontario;ON;GMT -05:00;Y;43.67747250;-79.3303820
CA;M4J 5A9;Toronto;Ontario;ON;GMT -05:00;Y;43.67770673;-79.3305091
CA;M4J 5B1;East York;Ontario;ON;GMT -05:00;Y;43.68977228;-79.3416175
CA;M4J 5B2;Toronto;Ontario;ON;GMT -05:00;Y;43.67711312;-79.3299036
CA;M4J 5B3;Toronto;Ontario;ON;GMT -05:00;Y;43.68134897;-79.3379472
CA;M4J 5B5;Toronto;Ontario;ON;GMT -05:00;Y;43.68189053;-79.3314979
CA;M4J 5B6;Toronto;Ontario;ON;GMT -05:00;Y;43.68221689;-79.3317368
CA;M4J 5B7;Toronto;Ontario;ON;GMT -05:00;Y;43.67825982;-79.3352564
CA;M4J 5B8;Toronto;Ontario;ON;GMT -05:00;Y;43.67905960;-79.3355132
CA;M4J 5B9;Toronto;Ontario;ON;GMT -05:00;Y;43.67919750;-79.3447097
CA;M4J 5C2;East York;Ontario;ON;GMT -05:00;Y;43.69067085;-79.3280439
CA;M4J 5C3;Toronto;Ontario;ON;GMT -05:00;Y;43.68352865;-79.3253955
CA;M4J 5C4;Toronto;Ontario;ON;GMT -05:00;Y;43.68315106;-79.3239657
CA;M4J 5C6;East York;Ontario;ON;GMT -05:00;Y;43.69551609;-79.3448094
CA;M4J 5C7;East York;Ontario;ON;GMT -05:00;Y;43.69629607;-79.3453371
CA;M4K 1A1;Toronto;Ontario;ON;GMT -05:00;Y;43.66622205;-79.3527685
CA;M4K 1A2;Toronto;Ontario;ON;GMT -05:00;Y;43.66643034;-79.3531440
CA;M4K 1A3;Toronto;Ontario;ON;GMT -05:00;Y;43.66766848;-79.3475204
CA;M4K 1A4;Toronto;Ontario;ON;GMT -05:00;Y;43.66778944;-79.3477422
CA;M4K 1A5;Toronto;Ontario;ON;GMT -05:00;Y;43.66821201;-79.3459004
CA;M4K 1A6;Toronto;Ontario;ON;GMT -05:00;Y;43.66812817;-79.3455120
CA;M4K 1A7;Toronto;Ontario;ON;GMT -05:00;Y;43.66734918;-79.3537498
CA;M4K 1A8;Toronto;Ontario;ON;GMT -05:00;Y;43.66860324;-79.3485686
CA;M4K 1A9;Toronto;Ontario;ON;GMT -05:00;Y;43.66861746;-79.3481962