Shop

HomeDatabaseZIP Code Database USA + Canada

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.

Clear
SKU:GZ-UC Category:
Description

Details (Last update: February 2023)

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.

Be the first to review “ZIP Code Database USA + Canada”

Your email address will not be published.