I'm trying to create Canadian territories using only the first letter of the Forward Sortation area. Any suggestions?

Thanks

I don't think that's possible unless the First letter happens to be in sync with the Provinces.. ? then use province.

Eric

Unfortunately they don't. I did find a workaround though by loading in all possible FSAs and having it ignore the invalid ones. Tedious, but it got the job done.

It can be done using one of my support files, and then aggregating FSAs by their first character.

http://www.box.net/shared/lpmrkrgu2r

The SQL for the aggregation would be

Code:

select distinct left(fsaldu,1) as Territory, left(fsaldu,3) as FSA 
from FsaLduLatLng
order by 2

Save the results to a text file and then import it to create your territories.

In the event you don't have a query tool, I'm attaching the resulting text file "FSA_Terr.txt"

HTH
-Paul

Thanks Paul! That file will be a huge help. Do you have a link to other support files like this one? I'm just beginning to use MapPoint and it sounds like you have some tools that would make my life a whole lot easier.

I am having the same problem. I need to create Canadian sales territories using the first 3 digits of the postal code. I couldn't find a way to do this, so I created the territories manually - which does not give me 100% accuracy.

Could somebody kindly give me a step-by-step solution to this please? I have only started using MapPoint recently and have no experience with SQL.

Your help is much appreciated!


Kind Regards,
Liza Palafox

I do have any other support files, however they may not be useful to you as one who is just starting out in MapPoint.

http://www.box.net/shared/5beu6q54z2

DemoUdidUSA.zip (relates MapPoint's internal USA demographic UDID field to actual data)
FsaLduLatLng6.zip (list of all valid FSALDUs in Canada, with Latitude/Longitude)
PostalDistricts.zip (list of all valid Postal Districts in Europe)
UDIDEur2K6.zip (relates MapPoint's internal EUR demographic UDID field to actual data)
ZipCountyStateData.zip (relates zipcode to county/state/FIPS)

-Paul