ZIP Code Database USA + Canada
$119.00 – $1,699.00
Download our USA + Canada ZIP/ Postal Code Database with geographical Coordinates (lat/long) to calculate distances between ZIP Codes or to determine all ZIP Codes within a given radius.
Description
Details (Last update: November 2024)
The USA + Canadian ZIP Code Database contains all US ZIP Codes and all Canadian Postal Codes and the city for each ZIP /postal code, state / province, and manually verified latitude & longitude coordinates.
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 USA
|
DATA
|
AMOUNT
|
|---|---|
|
States
|
50 (+ 12 Army / Overseas)
|
|
Cities
|
29,743
|
|
Unique ZIP Codes
|
42,037
|
|
Geocoded locations
|
100 %
|
|
Number of records
|
42,415
|
Database Content Canada
|
DATA
|
AMOUNT
|
|---|---|
|
Provinces
|
13
|
|
Cities
|
7,507
|
|
Unique Postal Codes
|
869,130
|
|
Geocoded locations
|
100 %
|
|
Number of records
|
881,637
|
USA + Canada ZIP Code Database is Provided in CSV Format to be easily imported into
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.
Sample Data
id;country;zipcode;city;region;regioncode;latitude;longitude
38208;US;90209;Beverly Hills;California;CA;34.07398229;-118.400033
38209;US;90210;Beverly Hills;California;CA;34.10342394;-118.417270
38210;US;90211;Beverly Hills;California;CA;34.06487652;-118.382371
38211;US;90212;Beverly Hills;California;CA;34.06123434;-118.402653
38212;US;90213;Beverly Hills;California;CA;34.07396491;-118.399973
38213;US;90220;Compton;California;CA;33.87530329;-118.241787
38214;US;90221;Compton;California;CA;33.88025901;-118.201928
38215;US;90222;Compton;California;CA;33.91405746;-118.236613
38216;US;90223;Compton;California;CA;33.89590881;-118.219230
38217;US;90224;Compton;California;CA;33.89617489;-118.220158
38218;US;90230;Culver City;California;CA;33.99553866;-118.400226
38219;US;90231;Culver City;California;CA;34.02137112;-118.396195
38220;US;90232;Culver City;California;CA;34.01954040;-118.394254
38221;US;90233;Culver City;California;CA;34.02121939;-118.395667
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
Additional information
| License | Single, Enterprise, Redistribution |
|---|---|
| Subscription | 1 Year, 2 Years, 3 Years, Lifetime |
Reviews
There are no reviews yet.