View Single Post

  #4 (permalink)  
Old 02-27-2006
Sonicman_ Sonicman_ is offline
Junior Member
White Belt
 
Join Date: Feb 2006
Posts: 10
May I suggest ?

We've had the same problem here and my solution was to buy a "canadian postal code" database. This database featured ALL canadian postal (not just the forward sortation area) and also their Longitude/Latitude (there are over 800'000 records in this database!). The database is in access format.

What you *could* do is run a query of your territories table along with the postal code table and extract the longitude/latitude of the postal codes per territories. You could then import each territory's postal codes separately and draw a polygon around it?

If you're interested obtaining this database here's the link:
http://www.zipcodedownload.com/Produ...dard/Overview/

Hope this helps

Sonicman
Reply With Quote