Close

Customer Login


This is the customer's only area. You'll automatically receive username & password after your purchase.

Username


Password


Remember Me



I don't remember my password...
Products
Testimonials
"...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
ZIP / Postal Code Database USA & Canada, Product Details
USA Canada ZIP / Postal Code Database
Single License Single License agreement

Buy Now...   99 US$ One time download of May 2012 data
Buy Now...   179 US$ 12 Month Subscription (Monthly Updates)
Enterprise License Single License agreement

Buy Now...   119 US$ One time download of May 2012 data
Buy Now...   229 US$ 12 Month Subscription (Monthly Updates)

Details (Last update: May 2012)


The USA ZIP Code Database contains all 5 digit US ZIP Codes, the default city for each ZIP Code, County & County code, Area code, Time zone, Daylight Savings flags, and manually verified latitude & longitude coordinates.

The Canada Postal Code Database contains all 6 digit Postal Codes, City, Province, Time zone, and manually verified latitude & longitude coordinates.

Database content


USA

  States0
  Counties0
  Cities59,662
  Unique ZIP Codes42,078
  Geocoded locations100 %
  Number of records        80,254

Canada

  Provinces13
  Cities6,314
  Unique Postal Codes765,344
  Geocoded locations100 %
  Number of records        765,344

Available formats:


  CSV Format  Comma Separated Values (CSV) ~40 MB ZIP-compressed
  MySQL Format  MySQL dump (SQL) ~40 MB ZIP-compressed
  SQL Server Format  MS SQL Server dump (SQL) ~40 MB ZIP-compressed
  Oracle Format  Oracle dump (SQL) ~40 MB ZIP-compressed
  Postgre Format  Postgre SQL Dump (SQL) ~40 MB ZIP-compressed
  Sybase Format  Sybase SQL Dump (SQL) ~10 MB ZIP-compressed
  Access Format  Microsoft Access (MDB) ~40 MB ZIP-compressed

Easy to import into all major Database Systems.

Datatable structure


USA

  countrycodevarchar(2)
  zipcodevarchar(5)
  cityvarchar(48)
  countyvarchar(48)
  countycodevarchar(5)
  statevarchar(48)
  statecodevarchar(2)
  areacodevarchar(16)
  utcdecimal(3,1)
  daylightsaving        varchar(1)
  timezonevarchar(16)
  latitudedecimal(13, 9)
  longitudedecimal(13, 9)

Canada

  countrycodevarchar(2)
  postalcodevarchar(5)
  cityvarchar(48)
  provincevarchar(48)
  provincecode        varchar(5)
  latitudedecimal(13, 9)
  longitudedecimal(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 / Postal 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

countrycode;postalcode;city;province;provincecode;latitude;longitude
CA;A0E 2Z0;Monkstown;Newfoundland;NL;47.58515193;-54.4256526
CA;A0E 3A0;Petit Forte;Newfoundland;NL;47.39510510;-54.6711300
CA;A0E 3B0;South East Bight;Newfoundland;NL;47.33505479;-54.5819542
CA;A0H 2J0;McCallum;Newfoundland;NL;47.62291569;-56.2079910
CA;A0N 2G0;Black Duck Siding;Newfoundland;NL;48.50386173;-58.4354881
CA;A0N 2H0;Burgeo;Newfoundland;NL;47.61345223;-57.6105384
CA;A0N 2J0;Ramea;Newfoundland;NL;47.52048343;-57.3942069
CA;A0N 2K0;Francois;Newfoundland;NL;47.58052791;-56.7347389
CA;A0N 2L0;Grey River;Newfoundland;NL;47.58521251;-57.1104358
CA;A1A 5T4;St. John's;Newfoundland;NL;47.61528618;-52.7060411
CA;A1A 5T5;St. John's;Newfoundland;NL;47.61544128;-52.7065795
CA;A1A 5T6;St. John's;Newfoundland;NL;47.60996932;-52.7521630
CA;A1L 2T8;Paradise;Newfoundland;NL;47.53123904;-52.8545734
CA;A1L 2T9;Paradise;Newfoundland;NL;47.53190179;-52.8545326
CA;A1L 2X1;Paradise;Newfoundland;NL;47.53687140;-52.8276537
CA;A1L 2X5;Paradise;Newfoundland;NL;47.53678552;-52.8278902
CA;A1L 2X8;Paradise;Newfoundland;NL;47.53641321;-52.8343080
CA;A1L 2Y3;Paradise;Newfoundland;NL;47.54022673;-52.8302979
CA;A1L 3A1;Paradise;Newfoundland;NL;47.54021012;-52.8312770
CA;A1L 3C1;Paradise;Newfoundland;NL;47.54075950;-52.8865969
CA;A1L 3C4;Paradise;Newfoundland;NL;47.54077576;-52.8866150
CA;A1L 3C5;Paradise;Newfoundland;NL;47.54033764;-52.8862422
CA;A1L 3E7;Paradise;Newfoundland;NL;47.54018424;-52.8861011
CA;A1M 3S5;Portugal Cove-St Philips;Newfoundland;NL;47.63912497;-52.8143399
CA;A1N 5J6;Mount Pearl;Newfoundland;NL;47.53026853;-52.8013792
CA;A1V 2V5;Gander;Newfoundland;NL;48.95155317;-54.6013111
CA;A1W 2A1;Conception Bay South;Newfoundland;NL;47.53416461;-52.9264357
CA;A1W 2A2;Conception Bay South;Newfoundland;NL;47.53061908;-52.9274448
CA;A1W 2A3;Conception Bay South;Newfoundland;NL;47.53850692;-52.9323290
CA;A1W 2A4;Conception Bay South;Newfoundland;NL;47.53747777;-52.9321742
CA;A1W 2A5;Conception Bay South;Newfoundland;NL;47.53664126;-52.9318846
CA;A1W 2A6;Conception Bay South;Newfoundland;NL;47.53452817;-52.9300122
CA;A1W 2A7;Conception Bay South;Newfoundland;NL;47.53320159;-52.9294288
CA;A1W 2A8;Conception Bay South;Newfoundland;NL;47.53172127;-52.9282247
CA;A1W 2A9;Conception Bay South;Newfoundland;NL;47.52875957;-52.9245021
CA;A1W 2B1;Conception Bay South;Newfoundland;NL;47.53767502;-52.9318945
CA;A1W 2B2;Conception Bay South;Newfoundland;NL;47.53546140;-52.9303630
CA;A1W 2B3;Conception Bay South;Newfoundland;NL;47.53326290;-52.9291667
CA;A1W 2B4;Conception Bay South;Newfoundland;NL;47.53120121;-52.9271018
CA;A1W 2B5;Conception Bay South;Newfoundland;NL;47.53109426;-52.9273123
CA;A1W 2B6;Conception Bay South;Newfoundland;NL;47.53821951;-52.9292793
CA;A1W 2B7;Conception Bay South;Newfoundland;NL;47.53788927;-52.9288088
CA;A1W 2B8;Conception Bay South;Newfoundland;NL;47.53030718;-52.9228294
CA;A1W 2B9;Conception Bay South;Newfoundland;NL;47.53316163;-52.9240256
CA;A1W 2C1;Conception Bay South;Newfoundland;NL;47.53915441;-52.9336384
CA;A1W 2C2;Conception Bay South;Newfoundland;NL;47.53474029;-52.9278417
CA;A1W 2C3;Conception Bay South;Newfoundland;NL;47.53417613;-52.9292772
CA;A1W 2C4;Conception Bay South;Newfoundland;NL;47.53436701;-52.9282023
CA;A1W 2C6;Conception Bay South;Newfoundland;NL;47.53619104;-52.9306805
CA;A1W 2C7;Conception Bay South;Newfoundland;NL;47.53567937;-52.9315331
CA;A1W 2C8;Conception Bay South;Newfoundland;NL;47.53233578;-52.9293638
CA;A1W 2E5;Conception Bay South;Newfoundland;NL;47.53689080;-52.9255777
CA;A1W 2E6;Conception Bay South;Newfoundland;NL;47.53674279;-52.9293497
CA;A1W 2E7;Conception Bay South;Newfoundland;NL;47.53494124;-52.9287486
CA;A1W 2G1;Conception Bay South;Newfoundland;NL;47.53713101;-52.9313610
CA;A1W 2G2;Conception Bay South;Newfoundland;NL;47.53762110;-52.9265166
CA;A1W 2G3;Conception Bay South;Newfoundland;NL;47.53658417;-52.9260602
CA;A1W 2G4;Conception Bay South;Newfoundland;NL;47.53821350;-52.9270518
CA;A1W 2G7;Conception Bay South;Newfoundland;NL;47.53925406;-52.9266133
CA;A1W 2G8;Conception Bay South;Newfoundland;NL;47.53959981;-52.9282976
CA;A1W 2G9;Conception Bay South;Newfoundland;NL;47.53941097;-52.9310916
CA;A1W 2H2;Conception Bay South;Newfoundland;NL;47.53984828;-52.9285935
CA;A1W 2H3;Conception Bay South;Newfoundland;NL;47.53407309;-52.9248203
CA;A1W 2H4;Conception Bay South;Newfoundland;NL;47.53704952;-52.9280156
CA;A1W 2H5;Conception Bay South;Newfoundland;NL;47.53475248;-52.9263552
CA;A1W 2H9;Conception Bay South;Newfoundland;NL;47.53782341;-52.9325782
CA;A1W 2J1;Conception Bay South;Newfoundland;NL;47.53687492;-52.9326780
CA;A1W 2J3;Conception Bay South;Newfoundland;NL;47.53154792;-52.9238413
CA;A1W 2J4;Conception Bay South;Newfoundland;NL;47.53113828;-52.9212634
CA;A1W 2J5;Conception Bay South;Newfoundland;NL;47.53405772;-52.9266529
CA;A1W 2J6;Conception Bay South;Newfoundland;NL;47.53130315;-52.9213112
CA;A1W 2J7;Conception Bay South;Newfoundland;NL;47.53154251;-52.9234259
CA;A1W 2J9;Topsail;Newfoundland;NL;47.54054518;-52.9277570
CA;A1W 2K1;Topsail;Newfoundland;NL;47.54056334;-52.9277772

Other products


USA ZIP Code Database Canada Postal Code Database ASP / PHP radius calculation
From 29 US$ From 79 US$ Free