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 postal 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 Code Database USA, Product Details
Canada Postal Code Database
Single License Single License agreement

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

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

Details (Last update: May 2012)


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

Database content


  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


  countrycodevarchar(2)
  postalcodevarchar(5)
  cityvarchar(48)
  provincevarchar(48)
  provincecodevarchar(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 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


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 USA / Canada ZIP / Postal Code Database ASP / PHP radius calculation
From 29 US$ From 99 US$ Free