View Cart
Download our "ZIP code database USA" and enhance your website / software with a ZIP code radius search capability.
All of our databases contain longitude and latitude for each location + free source code for PHP/ MySQL and ASP / MS SQL-Server and many more...
"...since we established a "Dealer locator" on our website we increased the "Sales per Visitor" conversion rate by 40%. Thanks to your support staff for the extensive help..."
Alan Smith
"...Thanks for your great product and the support while implementing. We used your data for our real estate portal to let visitors narrow down the search to an area around their zip code. What a great extra for our website visitors..."
John Willstrop
"...Works great for our dating community. It allows our members find other members in their area. It was that easy!!! Never experienced such a fast and competent Live Chat Support before. Special thanks to Peter..."
Marta Healy
Write your testimonial and get a link to your website
|
Single License
|
Details (Last update: May 2012)
The USA ZIP Code Database contains all 5 digit US ZIP Codes, the default city for each ZIP Code, State, and manually verified latitude & longitude coordinates.
Database content
| States | 50 + 12 (Army + Overseas) |
| Cities | 59,662 |
| Unique ZIP Codes | 42,078 |
| Geocoded locations | 100 % |
| Number of records | 80,254 |
Available formats:
Comma Separated Values (CSV) ~1.5 MB ZIP-compressed
MySQL dump (SQL) ~1.5 MB ZIP-compressed
MS SQL Server dump (SQL) ~1.5 MB ZIP-compressed
Oracle dump (SQL) ~1.5 MB ZIP-compressed
Postgre SQL Dump (SQL) ~1.5 MB ZIP-compressed
Sybase SQL Dump (SQL) ~1.5 MB ZIP-compressed
Miscroft Excel (XLS) ~2.5 MB ZIP-compressed
Microsoft Access (MDB) ~2.5 MB ZIP-compressed
Easy to import into all major Database Systems.
Datatable structure
| countrycode | varchar(2) |
| zipcode | varchar(5) |
| city | varchar(64) |
| state | varchar(64) |
| statecode | varchar(2) |
| latitude | decimal(13, 9) |
| longitude | decimal(13, 9) |
Programming
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 to implement a ZIP code radius / distance search we offer free access to example codes in many scripting languages and programming languages like ASP, PHP, Coldfusion...
To achieve the highest accuracy the formulas in our example scripts take the earth's curvature into consideration.
Check out a working example.
Delivery
Internet Download
Sample Data
US;94301;Palo Alto;California;CA;37.44068554;-122.154147
US;94302;Palo Alto;California;CA;37.44909041;-122.162618
US;94303;E Palo Alto;California;CA;37.4512437;-122.131402
US;94303;East Palo Alto;California;CA;37.45278661;-122.136434
US;94303;Palo Alto;California;CA;37.45189532;-122.133527
US;94304;Palo Alto;California;CA;37.41152291;-122.169742
US;94305;Palo Alto;California;CA;37.42241319;-122.173616
US;94305;Stanford;California;CA;37.42021293;-122.166433
US;94306;Palo Alto;California;CA;37.41945801;-122.139695
US;94309;Palo Alto;California;CA;37.41930861;-122.175291
US;94309;Stanford;California;CA;37.41751261;-122.169427
US;94401;San Mateo;California;CA;37.5758525;-122.329304
US;94402;San Mateo;California;CA;37.54851726;-122.337248
US;94403;San Mateo;California;CA;37.54111512;-122.307791
US;94404;Foster City;California;CA;37.55073483;-122.278443
US;94404;San Mateo;California;CA;37.54976609;-122.275288
US;94497;Postal Data Center;California;CA;37.56509422;-122.333097
US;94497;San Mateo;California;CA;37.56370817;-122.328583
US;94501;Alameda;California;CA;37.762024;-122.265069
US;94501;Alameda Pt;California;CA;37.76399133;-122.271439
US;94502;Alameda;California;CA;37.74264587;-122.253144
US;94503;American Canyon;California;CA;38.1177457;-122.236792
US;94503;American Cyn;California;CA;38.11710153;-122.234726
US;94503;Vallejo;California;CA;38.11835556;-122.238747
US;94505;Byron;California;CA;37.90600324;-121.610969
US;94505;Discovery Bay;California;CA;37.90473348;-121.606895
US;94506;Blackhawk;California;CA;37.81073696;-121.913154
US;94506;Danville;California;CA;37.81105835;-121.91419
US;94507;Alamo;California;CA;37.85495399;-122.026896
US;94508;Angwin;California;CA;38.57659731;-122.452938
US;94509;Antioch;California;CA;37.99530958;-121.804403
US;94510;Benicia;California;CA;38.07265306;-122.175446
US;94511;Bethel Island;California;CA;38.0238413;-121.654779
US;94512;Birds Landing;California;CA;38.12982898;-121.837871
US;94512;Suisun City;California;CA;38.12768248;-121.831012
US;94513;Brentwood;California;CA;37.94093694;-121.705505
US;94514;Byron;California;CA;37.87557511;-121.62512
US;94514;Discovery Bay;California;CA;37.87385951;-121.619611
US;94515;Calistoga;California;CA;38.58650235;-122.574924
US;94516;Canyon;California;CA;37.83817149;-122.199355
US;94517;Clayton;California;CA;37.93422459;-121.929953
US;94518;Concord;California;CA;37.95083245;-122.023273
US;94519;Concord;California;CA;37.98122302;-122.008966
US;94520;Clyde;California;CA;37.98617897;-122.037107
US;94520;Concord;California;CA;37.98875059;-122.045369
US;94521;Concord;California;CA;37.96640562;-121.974432
US;94522;Concord;California;CA;38.01593163;-122.02518
US;94523;Concord;California;CA;37.95414056;-122.081034
US;94523;Pleasant Hill;California;CA;37.95211392;-122.074516
US;94524;Concord;California;CA;37.97711374;-122.068969
US;94525;Crockett;California;CA;38.05357632;-122.222613
US;94526;Danville;California;CA;37.81892396;-121.970707
US;94527;Concord;California;CA;37.97798156;-122.060766
US;94528;Diablo;California;CA;37.83866516;-121.955032
US;94529;Chevron;California;CA;37.87544466;-122.049904
US;94529;Chevron USA Inc;California;CA;37.8777285;-122.057264
US;94529;Concord;California;CA;37.87791787;-122.057874
US;94530;El Cerrito;California;CA;37.92154071;-122.30526
US;94531;Antioch;California;CA;37.99793329;-121.811784
US;94533;Fairfield;California;CA;38.28798056;-122.01682
US;94534;Fairfield;California;CA;38.28886322;-122.018515
US;94534;Suisun City;California;CA;38.28998885;-122.022102
US;94535;Fairfield;California;CA;38.25172366;-122.046162
US;94535;Travis AFB;California;CA;38.25245423;-122.048493
US;94536;Fremont;California;CA;37.56418067;-122.003065
US;94537;Fremont;California;CA;37.55763938;-122.023656
US;94538;Fremont;California;CA;37.5270479;-121.966334
US;94539;Fremont;California;CA;37.51748657;-121.930238
US;94540;Hayward;California;CA;37.66063768;-122.100957
US;94541;Hayward;California;CA;37.67479168;-122.085756
US;94542;Hayward;California;CA;37.65987313;-122.049653
US;94543;Hayward;California;CA;37.67509882;-122.088243
US;94544;Hayward;California;CA;37.63700982;-122.072107
US;94545;Hayward;California;CA;37.63519684;-122.106847
US;94546;Castro Valley;California;CA;37.72817379;-122.087155
US;94546;Hayward;California;CA;37.72661571;-122.082113
US;94547;Hercules;California;CA;38.0120384;-122.265149
US;94547;Rodeo;California;CA;38.01388955;-122.271103
US;94548;Knightsen;California;CA;37.97629683;-121.666077
US;94549;Lafayette;California;CA;37.90124064;-122.124475
US;94550;Livermore;California;CA;37.68455979;-121.763145
US;94551;Livermore;California;CA;37.73118322;-121.693424
US;94552;Castro Valley;California;CA;37.69736115;-122.029346
US;94552;Hayward;California;CA;37.69430793;-122.019462
US;94553;Briones;California;CA;37.99154213;-122.165162
US;94553;Martinez;California;CA;37.99425091;-122.173873
US;94553;Pacheco;California;CA;37.99251471;-122.16829
US;94555;Fremont;California;CA;37.57514198;-122.048042
US;94556;Moraga;California;CA;37.84593977;-122.135093
US;94557;Hayward;California;CA;37.63237086;-122.11112
US;94557;Mount Eden;California;CA;37.62992115;-122.103171
US;94558;Napa;California;CA;38.34665049;-122.314998
US;94558;Spanish Flat;California;CA;38.34377856;-122.305837
US;94559;Napa;California;CA;38.29562604;-122.296879
US;94560;Newark;California;CA;37.53941881;-122.042763
US;94561;Oakley;California;CA;37.99487582;-121.721081
US;94562;Oakville;California;CA;38.43033357;-122.411033
US;94563;Orinda;California;CA;37.87938;-122.178842
US;94564;Pinole;California;CA;37.99893059;-122.287731
US;94565;Bay Point;California;CA;38.01889321;-121.915477
US;94565;Pittsburg;California;CA;38.01839139;-121.913868
US;94565;Port Chicago;California;CA;38.01960793;-121.917769
US;94565;West Pittsburg;California;CA;38.01874494;-121.915001
US;94566;Pleasanton;California;CA;37.67537147;-121.892486
US;94567;Pope Valley;California;CA;38.67815474;-122.411709
US;94568;Dublin;California;CA;37.71601788;-121.936584
US;94568;Pleasanton;California;CA;37.71444519;-121.931499
US;94569;Port Costa;California;CA;38.04487981;-122.188427
US;94570;Moraga;California;CA;38.11783914;-122.147208
US;94571;Rio Vista;California;CA;38.17207092;-121.724786
US;94572;Rodeo;California;CA;38.03406261;-122.273101
US;94573;Rutherford;California;CA;38.4608851;-122.422804
US;94574;Saint Helena;California;CA;38.51008297;-122.451769
US;94575;Moraga;California;CA;37.84858573;-122.133474
US;94576;Angwin;California;CA;38.53123287;-122.474534
US;94576;Deer Park;California;CA;38.5319996;-122.476971
US;94577;San Leandro;California;CA;37.72188571;-122.168741
US;94578;San Leandro;California;CA;37.70437095;-122.128675
US;94579;San Leandro;California;CA;37.68965259;-122.154489
US;94580;San Lorenzo;California;CA;37.68368315;-122.140382
US;94581;Napa;California;CA;38.30045184;-122.2978
US;94582;San Ramon;California;CA;37.67326749;-121.891713
US;94583;San Ramon;California;CA;37.75200173;-121.954176
US;94585;Birds Lndg;California;CA;38.24751773;-122.026391
US;94585;Suisun City;California;CA;38.24656158;-122.023341
US;94586;Sunol;California;CA;37.60462546;-121.896815
US;94587;Union City;California;CA;37.59777938;-122.058863
US;94588;Pleasanton;California;CA;37.68754234;-121.895485
US;94589;American Canyon;California;CA;38.16483963;-122.257407
US;94589;American Cyn;California;CA;38.16493122;-122.2577
US;94589;Vallejo;California;CA;38.16294678;-122.251343
US;94590;Vallejo;California;CA;38.10487418;-122.244469
US;94591;Vallejo;California;CA;38.1032963;-122.216534
US;94592;Mare Island;California;CA;38.10387657;-122.279708
US;94592;Vallejo;California;CA;38.10501965;-122.283377
US;94595;Walnut Creek;California;CA;37.87198201;-122.077651
US;94596;Lafayette;California;CA;37.90720692;-122.061697
US;94596;Walnut Creek;California;CA;37.90594469;-122.057633
US;94597;Walnut Creek;California;CA;37.90237776;-122.063969
US;94598;Walnut Creek;California;CA;37.91952167;-122.035465
US;94599;Yountville;California;CA;38.40760784;-122.357047
US;94302;Palo Alto;California;CA;37.44909041;-122.162618
US;94303;E Palo Alto;California;CA;37.4512437;-122.131402
US;94303;East Palo Alto;California;CA;37.45278661;-122.136434
US;94303;Palo Alto;California;CA;37.45189532;-122.133527
US;94304;Palo Alto;California;CA;37.41152291;-122.169742
US;94305;Palo Alto;California;CA;37.42241319;-122.173616
US;94305;Stanford;California;CA;37.42021293;-122.166433
US;94306;Palo Alto;California;CA;37.41945801;-122.139695
US;94309;Palo Alto;California;CA;37.41930861;-122.175291
US;94309;Stanford;California;CA;37.41751261;-122.169427
US;94401;San Mateo;California;CA;37.5758525;-122.329304
US;94402;San Mateo;California;CA;37.54851726;-122.337248
US;94403;San Mateo;California;CA;37.54111512;-122.307791
US;94404;Foster City;California;CA;37.55073483;-122.278443
US;94404;San Mateo;California;CA;37.54976609;-122.275288
US;94497;Postal Data Center;California;CA;37.56509422;-122.333097
US;94497;San Mateo;California;CA;37.56370817;-122.328583
US;94501;Alameda;California;CA;37.762024;-122.265069
US;94501;Alameda Pt;California;CA;37.76399133;-122.271439
US;94502;Alameda;California;CA;37.74264587;-122.253144
US;94503;American Canyon;California;CA;38.1177457;-122.236792
US;94503;American Cyn;California;CA;38.11710153;-122.234726
US;94503;Vallejo;California;CA;38.11835556;-122.238747
US;94505;Byron;California;CA;37.90600324;-121.610969
US;94505;Discovery Bay;California;CA;37.90473348;-121.606895
US;94506;Blackhawk;California;CA;37.81073696;-121.913154
US;94506;Danville;California;CA;37.81105835;-121.91419
US;94507;Alamo;California;CA;37.85495399;-122.026896
US;94508;Angwin;California;CA;38.57659731;-122.452938
US;94509;Antioch;California;CA;37.99530958;-121.804403
US;94510;Benicia;California;CA;38.07265306;-122.175446
US;94511;Bethel Island;California;CA;38.0238413;-121.654779
US;94512;Birds Landing;California;CA;38.12982898;-121.837871
US;94512;Suisun City;California;CA;38.12768248;-121.831012
US;94513;Brentwood;California;CA;37.94093694;-121.705505
US;94514;Byron;California;CA;37.87557511;-121.62512
US;94514;Discovery Bay;California;CA;37.87385951;-121.619611
US;94515;Calistoga;California;CA;38.58650235;-122.574924
US;94516;Canyon;California;CA;37.83817149;-122.199355
US;94517;Clayton;California;CA;37.93422459;-121.929953
US;94518;Concord;California;CA;37.95083245;-122.023273
US;94519;Concord;California;CA;37.98122302;-122.008966
US;94520;Clyde;California;CA;37.98617897;-122.037107
US;94520;Concord;California;CA;37.98875059;-122.045369
US;94521;Concord;California;CA;37.96640562;-121.974432
US;94522;Concord;California;CA;38.01593163;-122.02518
US;94523;Concord;California;CA;37.95414056;-122.081034
US;94523;Pleasant Hill;California;CA;37.95211392;-122.074516
US;94524;Concord;California;CA;37.97711374;-122.068969
US;94525;Crockett;California;CA;38.05357632;-122.222613
US;94526;Danville;California;CA;37.81892396;-121.970707
US;94527;Concord;California;CA;37.97798156;-122.060766
US;94528;Diablo;California;CA;37.83866516;-121.955032
US;94529;Chevron;California;CA;37.87544466;-122.049904
US;94529;Chevron USA Inc;California;CA;37.8777285;-122.057264
US;94529;Concord;California;CA;37.87791787;-122.057874
US;94530;El Cerrito;California;CA;37.92154071;-122.30526
US;94531;Antioch;California;CA;37.99793329;-121.811784
US;94533;Fairfield;California;CA;38.28798056;-122.01682
US;94534;Fairfield;California;CA;38.28886322;-122.018515
US;94534;Suisun City;California;CA;38.28998885;-122.022102
US;94535;Fairfield;California;CA;38.25172366;-122.046162
US;94535;Travis AFB;California;CA;38.25245423;-122.048493
US;94536;Fremont;California;CA;37.56418067;-122.003065
US;94537;Fremont;California;CA;37.55763938;-122.023656
US;94538;Fremont;California;CA;37.5270479;-121.966334
US;94539;Fremont;California;CA;37.51748657;-121.930238
US;94540;Hayward;California;CA;37.66063768;-122.100957
US;94541;Hayward;California;CA;37.67479168;-122.085756
US;94542;Hayward;California;CA;37.65987313;-122.049653
US;94543;Hayward;California;CA;37.67509882;-122.088243
US;94544;Hayward;California;CA;37.63700982;-122.072107
US;94545;Hayward;California;CA;37.63519684;-122.106847
US;94546;Castro Valley;California;CA;37.72817379;-122.087155
US;94546;Hayward;California;CA;37.72661571;-122.082113
US;94547;Hercules;California;CA;38.0120384;-122.265149
US;94547;Rodeo;California;CA;38.01388955;-122.271103
US;94548;Knightsen;California;CA;37.97629683;-121.666077
US;94549;Lafayette;California;CA;37.90124064;-122.124475
US;94550;Livermore;California;CA;37.68455979;-121.763145
US;94551;Livermore;California;CA;37.73118322;-121.693424
US;94552;Castro Valley;California;CA;37.69736115;-122.029346
US;94552;Hayward;California;CA;37.69430793;-122.019462
US;94553;Briones;California;CA;37.99154213;-122.165162
US;94553;Martinez;California;CA;37.99425091;-122.173873
US;94553;Pacheco;California;CA;37.99251471;-122.16829
US;94555;Fremont;California;CA;37.57514198;-122.048042
US;94556;Moraga;California;CA;37.84593977;-122.135093
US;94557;Hayward;California;CA;37.63237086;-122.11112
US;94557;Mount Eden;California;CA;37.62992115;-122.103171
US;94558;Napa;California;CA;38.34665049;-122.314998
US;94558;Spanish Flat;California;CA;38.34377856;-122.305837
US;94559;Napa;California;CA;38.29562604;-122.296879
US;94560;Newark;California;CA;37.53941881;-122.042763
US;94561;Oakley;California;CA;37.99487582;-121.721081
US;94562;Oakville;California;CA;38.43033357;-122.411033
US;94563;Orinda;California;CA;37.87938;-122.178842
US;94564;Pinole;California;CA;37.99893059;-122.287731
US;94565;Bay Point;California;CA;38.01889321;-121.915477
US;94565;Pittsburg;California;CA;38.01839139;-121.913868
US;94565;Port Chicago;California;CA;38.01960793;-121.917769
US;94565;West Pittsburg;California;CA;38.01874494;-121.915001
US;94566;Pleasanton;California;CA;37.67537147;-121.892486
US;94567;Pope Valley;California;CA;38.67815474;-122.411709
US;94568;Dublin;California;CA;37.71601788;-121.936584
US;94568;Pleasanton;California;CA;37.71444519;-121.931499
US;94569;Port Costa;California;CA;38.04487981;-122.188427
US;94570;Moraga;California;CA;38.11783914;-122.147208
US;94571;Rio Vista;California;CA;38.17207092;-121.724786
US;94572;Rodeo;California;CA;38.03406261;-122.273101
US;94573;Rutherford;California;CA;38.4608851;-122.422804
US;94574;Saint Helena;California;CA;38.51008297;-122.451769
US;94575;Moraga;California;CA;37.84858573;-122.133474
US;94576;Angwin;California;CA;38.53123287;-122.474534
US;94576;Deer Park;California;CA;38.5319996;-122.476971
US;94577;San Leandro;California;CA;37.72188571;-122.168741
US;94578;San Leandro;California;CA;37.70437095;-122.128675
US;94579;San Leandro;California;CA;37.68965259;-122.154489
US;94580;San Lorenzo;California;CA;37.68368315;-122.140382
US;94581;Napa;California;CA;38.30045184;-122.2978
US;94582;San Ramon;California;CA;37.67326749;-121.891713
US;94583;San Ramon;California;CA;37.75200173;-121.954176
US;94585;Birds Lndg;California;CA;38.24751773;-122.026391
US;94585;Suisun City;California;CA;38.24656158;-122.023341
US;94586;Sunol;California;CA;37.60462546;-121.896815
US;94587;Union City;California;CA;37.59777938;-122.058863
US;94588;Pleasanton;California;CA;37.68754234;-121.895485
US;94589;American Canyon;California;CA;38.16483963;-122.257407
US;94589;American Cyn;California;CA;38.16493122;-122.2577
US;94589;Vallejo;California;CA;38.16294678;-122.251343
US;94590;Vallejo;California;CA;38.10487418;-122.244469
US;94591;Vallejo;California;CA;38.1032963;-122.216534
US;94592;Mare Island;California;CA;38.10387657;-122.279708
US;94592;Vallejo;California;CA;38.10501965;-122.283377
US;94595;Walnut Creek;California;CA;37.87198201;-122.077651
US;94596;Lafayette;California;CA;37.90720692;-122.061697
US;94596;Walnut Creek;California;CA;37.90594469;-122.057633
US;94597;Walnut Creek;California;CA;37.90237776;-122.063969
US;94598;Walnut Creek;California;CA;37.91952167;-122.035465
US;94599;Yountville;California;CA;38.40760784;-122.357047
Other products
|
|
|
| From 79 US$ | From 99 US$ | Free |