View Single Post

  #4 (permalink)  
Old 11-17-2007
Paul Larson Paul Larson is offline
Senior Member
Green Belt
 
Join Date: Sep 2005
Location: Marshall, Michigan
Posts: 122
Wink Re: Creating Canadian territories using FSA

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
Attached Files
File Type: zip FSA_Terr.zip (2.1 KB, 7 views)
Reply With Quote