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

Mappoint 2004 and territories based on Canadian postal codes

This is a discussion on Mappoint 2004 and territories based on Canadian postal codes within the MapPoint Desktop Discussion forums, part of the Map Forums category; Hi. Can somebody help me with the following problem. I work in Service and our department deals with service territories, ...

  1. #1
    Penka is offline Junior Member White Belt
    Join Date
    Feb 2006
    Posts
    4

    Mappoint 2004 and territories based on Canadian postal codes

    Hi.

    Can somebody help me with the following problem.

    I work in Service and our department deals with service territories, which are spreaded over all Canada. One territory consists of a group of postal codes.

    Per my undestanding (I have just started to use this tool) I cannot create territories based on Canadian Postal Codes (but I can do this with US Zip Codes).

    Can someone tells me if there is a add-ins or another decision that I can use in order to resolve my problem.

    Thank you in advance!

    Penka

  2. #2
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,094
    Blog Entries
    4
    I think you can do it.. you can make territories with Forward Sortation Areas (FSA)'s anyway.. take a look at the following screenshots around Toronto. You can see that the FSA's are fairly small, not that huge anyway.



    Click here for the full screenshot --
    http://www.mp2kmag.com/images/mappoint/canada_fsas.gif

    Hope this helps,
    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  3. #3
    Penka is offline Junior Member White Belt
    Join Date
    Feb 2006
    Posts
    4

    Mappoint 2004 and territories based on Canadian postal codes

    Thanks for the suggestion, Eric.

    It works at some point but at some doesn't.

    The problem arised from the circumstance that we have several different territories with the same FSA. These territories are unique from the psostal code point of view bust as fare as it is related to the FSA (the first three characters of the postal code) they are repeting. For example"

    ID Territory FSA
    488 13104T M5G
    622 13116T M5G
    3227 41931T M5G
    3346 77701T M5G

    Mappoint doesn't allow one geographic area(region) to be related to different territories. In this case no one of these territories has been ctreated on the map.

    Any idea how I can solve this problem?

    Thanks in advance!

    Penka

  4. #4
    Sonicman_ is offline Junior Member White Belt
    Join Date
    Feb 2006
    Posts
    10

    May I suggest ?

    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

  5. #5
    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

  6. #6
    Sonicman_ is offline Junior Member White Belt
    Join Date
    Feb 2006
    Posts
    10

    my reply:

    hmmm well you may indeed have too much territories to draw.

    My idea was to:
    a) import each territory's postalcodes in seperate dataset of different colors and have pushpins placed for each dataset (each postalcode have it's pushpin).
    b) once you have each dataset placed on the map, since they are in different colors my idea was to draw a polygon BY HAND around the pushpins....

    I don'T think there is a way to draw them by programming and lat/lon. It would just create a continuous line between EACH pushpin and this isn't what you want. You want to create a shape that connects the pushpins that are actually part of the territory "boundary", which would require Albert Einstein and some very complex calculations to determine!

    So I guess your solution is to do them by hand. Believe me, even if you have 226 of those, once the pushpins are in place it will be faster than programming this up.

    Unless someone else have another idea ?

    Sonicman

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, 10:16 AM
  2. Canadian Variables - MapPoint 2004
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 07-08-2004, 01:24 PM
  3. re: UK postal codes
    By Anonymous in forum Wish List
    Replies: 2
    Last Post: 05-21-2004, 08:24 AM
  4. MapPoint 2004-Create Territories Using Full Cdn Postal Code
    By wkcarreg in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 01-30-2004, 12:46 PM
  5. Canadian postal code updates
    By AM in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 09-10-2002, 01:50 PM

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