MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




Creating Canadian territories using FSA

This is a discussion on Creating Canadian territories using FSA within the MapPoint 2006/2009 Discussion forums, part of the Map Forums category; I'm trying to create Canadian territories using only the first letter of the Forward Sortation area. Any suggestions? Thanks...


Go Back   MapPoint Forums > Map Forums > MapPoint 2006/2009 Discussion

Creating Canadian territories using FSA Creating Canadian territories using FSA

Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read

Notices

Notice: Now taking orders for MapPoint 2009!


Click here to register

Reply

 

LinkBack (5) Thread Tools Display Modes
  5 links from elsewhere to this Post. Click to view. #1 (permalink)  
Old 11-15-2007
Junior Member
White Belt
  
Join Date: Nov 2007
Posts: 3
Question Creating Canadian territories using FSA
I'm trying to create Canadian territories using only the first letter of the Forward Sortation area. Any suggestions?

Thanks
Last edited by gotegra; 11-15-2007 at 12:14 PM.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #2 (permalink)  
Old 11-15-2007
Eric Frost's Avatar
Administrator
Black Belt
  
Join Date: Jul 1992
Posts: 2,210
Blog Entries: 1
Re: Creating Canadian territories using FSA
I don't think that's possible unless the First letter happens to be in sync with the Provinces.. ? then use province.

Eric
__________________
Order MapPoint 2006 | Read Programming MapPoint in .NET | Start Using the Pushpin Tool - Free Trial Download - click here.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #3 (permalink)  
Old 11-15-2007
Junior Member
White Belt
  
Join Date: Nov 2007
Posts: 3
Re: Creating Canadian territories using FSA
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #4 (permalink)  
Old 11-17-2007
Senior Member
Green Belt
  
Join Date: Sep 2005
Location: Marshall, Michigan
Posts: 113
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)
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #5 (permalink)  
Old 11-19-2007
Junior Member
White Belt
  
Join Date: Nov 2007
Posts: 3
Re: Creating Canadian territories using FSA
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #6 (permalink)  
Old 11-19-2007
Junior Member
White Belt
  
Join Date: Nov 2007
Posts: 3
Re: Creating Canadian territories using FSA
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #7 (permalink)  
Old 11-20-2007
Senior Member
Green Belt
  
Join Date: Sep 2005
Location: Marshall, Michigan
Posts: 113
Post Re: Creating Canadian territories using FSA
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

« totally lost and can't figure it | NYC Street addresses »

LinkBacks (?)
LinkBack to this Thread: http://www.mapforums.com/creating-canadian-territories-using-fsa-6756.html
Posted By For Type Date
Programming MapPoint in .NET - MP2K Magazine This thread Refback 11-21-2007 03:13 PM
Programming with MapPoint 2004 using the .NET Framework - MapPoint Articles - MP2K Magazine This thread Refback 11-20-2007 04:39 AM
Excel User-Defined Functions and MapPoint - MapPoint Articles - MP2K Magazine This thread Refback 11-20-2007 04:39 AM
The Magazine for MapPoint - MP2K Magazine This thread Refback 11-16-2007 02:53 PM
Apple Blog » Blog Archive » Creating Canadian territories using FSA This thread Pingback 11-15-2007 12:08 PM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
Mappoint 2004 and territories based on Canadian postal codes Penka MapPoint 2006/2009 Discussion 2 05-04-2006 09:16 AM
Mappoint 2004 and territories based on Canadian postal codes Penka MapPoint 2006/2009 Discussion 5 02-28-2006 02:21 PM
Territories creating city territories cableghost MapPoint 2006/2009 Discussion 8 08-30-2005 03:47 PM
Creating Territories jdebruin MapPoint 2006/2009 Discussion 0 03-04-2004 08:15 AM
Programmatically creating Territories? jlaretto MapPoint 2006/2009 Discussion 1 01-29-2004 02:01 AM


All times are GMT -5. The time now is 11:20 PM.

Marketing Strategy - VSAT - Used Cars - Book a Hotel - Moving Services - Archive - Top

Powered by vBulletin® Version 3.7.1
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0 RC5
MP2K Magazine
Visitor Map

Ski Holidays French Alps
Ski holidays in the French Alps are a unique and exciting experience. There are a great range of resorts which are great value when you book with Holiday Hypermarket online.

Cruise Travel Agent
Book your cruise with Travel Counsellors. We are an award winning travel agent and can help plan your perfect cruise.

Jamaica Holiday
Fancy a Jamaica Holiday? Then visit dealchecker.co.uk and find out what the big deal is. Book a bargain when you book online.

Holidays to St Lucia
Holidays to St Lucia will leave you smiling. The spectacular scenery and the warmth of the locals make holidays to St Lucia unforgettable.

Tunisia
Tunisia enjoys excellent weather, golden beaches and a beautiful blue sea. Moving away from the beach you will find a country that has a rich and varied past. Discover the secrets of history yourself by exploring all the ruins.

Bargain Holidays
To plan your holidays at bargain prices, use Travel.co.uk to explore all the possibilities.

Portugal Holidays
We specialise in Portugal holidays. Visit our On The Beach website for more information.


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47