View Single Post

  #5 (permalink)  
Old 02-28-2006
Penka Penka is offline
Junior Member
White Belt
 
Join Date: Feb 2006
Posts: 4
Re: May I suggest ? -->Mappoint 2004 and territories base

Thank for the suggestion, Sonicman!

I probably will consider buying Canadian Postal Codes database.

Can you please help me a little bit further?

I understood your idea but I don know how I will be able after I manualy draw the territories by their longitude/latitude (it won't be easy because I have 226 territories) to present different metrics as "Service Revenue" or "Service Cost" by territory?!

Mappoint won't accept to import those metrics (revenue etc.) by postal code or by territories, that were created by me, because it won't consider them as a valid options to import data to.

Perhaps I have missed something of your idea.

I would be very glad if you can help me further!!! I have to find a decision as soon as possible.

Penka

--------------------------------------------------------------------------------------
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