Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

Subscribe to receive our newsletter.
Subscribe Unsubscribe
Results 1 to 7 of 7

Creating Canadian territories using FSA

This is a discussion on Creating Canadian territories using FSA within the MapPoint Desktop 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...

  1. #1
    gotegra is offline Junior Member White Belt
    Join Date
    Nov 2007
    Posts
    4

    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.

  2. #2
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4

    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 MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  3. #3
    gotegra is offline Junior Member White Belt
    Join Date
    Nov 2007
    Posts
    4

    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.

  4. #4
    Paul Larson is offline Senior Member Green Belt
    Join Date
    Sep 2005
    Location
    Battle Creek, Michigan
    Posts
    136

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

  5. #5
    gotegra is offline Junior Member White Belt
    Join Date
    Nov 2007
    Posts
    4

    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.

  6. #6
    liza_palafox is offline 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

  7. #7
    Paul Larson is offline Senior Member Green Belt
    Join Date
    Sep 2005
    Location
    Battle Creek, Michigan
    Posts
    136

    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

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Mappoint 2004 and territories based on Canadian postal codes
    By Penka in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 05-04-2006, 09:16 AM
  2. Mappoint 2004 and territories based on Canadian postal codes
    By Penka in forum MapPoint Desktop Discussion
    Replies: 5
    Last Post: 02-28-2006, 02:21 PM
  3. Territories creating city territories
    By cableghost in forum MapPoint Desktop Discussion
    Replies: 8
    Last Post: 08-30-2005, 03:47 PM
  4. Creating Territories
    By jdebruin in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 03-04-2004, 08:15 AM
  5. Programmatically creating Territories?
    By jlaretto in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 01-29-2004, 02:01 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


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 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94