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

Using MapPoint to write to database

This is a discussion on Using MapPoint to write to database within the MapPoint Desktop Discussion forums, part of the Map Forums category; How do I use MapPoint to divide clients into zipcode regions and write that regional info back INTO my database? ...

  1. #1
    strattonn is offline Junior Member White Belt
    Join Date
    Nov 2003
    Posts
    3

    Using MapPoint to write to database

    How do I use MapPoint to divide clients into zipcode regions and write that regional info back INTO my database? I want to use MapPoint's visual ability to create regions but then save that information into my database so I can run reports based on those regions. Update Linked Data just refreshes the view MapPoint sees, it does not write to my database.

    Thanks in advance...

  2. #2
    Martel is offline Junior Member Yellow Belt
    Join Date
    Feb 2003
    Posts
    28
    If you want to do this through the standard MapPoint menus:
    If you have territories by postal codes and your imported data contains postal codes (plot client by street address or by postal code), you can export to Excel. One worksheet provides the territory name and zip code pairings. Another worksheet has the matched address and the other fields that were imported to MapPoint. Make sure that the data you import has some key, Client_ID for example, that you can use to match data back to your database. You can then run a query to match the territory name with the address using the postal code. The downside is that the export to Excel can take a while if you are dealing with large datasets.

  3. #3
    strattonn is offline Junior Member White Belt
    Join Date
    Nov 2003
    Posts
    3

    Using MapPoint to write to database

    Thank you for your prompt answer.

    Can you create subterritories in MapPoint?

  4. #4
    strattonn is offline Junior Member White Belt
    Join Date
    Nov 2003
    Posts
    3

    Using MapPoint to write to database

    Subterritories - No.

    I found a similar thread from just a few days ago that seems to say there is no way to do subterritories.

    Thanks...

  5. #5
    Martel is offline Junior Member Yellow Belt
    Join Date
    Feb 2003
    Posts
    28

    Sub-Territories

    Well, there is not an "easy" way of creating the sub-territories. If you are basing your territories off of postal codes you can simulate sub-territories by building the right queries. You will need to layer your data.

    Let's say you want to see a count of clients by sub-territory within a larger territory as well as see the client locations by address.

    First import your main territory (by zip/postal code). Then have a second query that groups ZIPs or postal codes into your sub-territories. Import this second query as a shaded area dataset. Plot the data by zip, not by territory. Your third query could plot client location by address. Plot this as a pushpin dataset and use a symbol like a large or small square. Build a fourth query that sums your client count by zipcode or assign one zip in each sub-territory as the "display" zip. Use a count of client id to get the total number of clients by zip or by your display zip. Import this query as a shaded circle dataset.

    Downside to all of this is the limitation on the unique values that can be imported at once. I have had to split this into multiple queries and datasets as well as add some text boxes and symbols of my own.

    Sometimes you just have to get creative with how you push your datasets around. Let me know if you want to see a small sample of how the output and datasets might look.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. I am trying to write code that centers the map on ....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 06-19-2002, 05:18 AM
  2. I write an application that similar to find functi....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 03-09-2002, 11:48 PM
  3. I am trying to write some code which mimicks the b....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 11-24-2001, 04:22 PM
  4. I'm trying to write a VB MapPoint app that assists....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 08-26-2001, 10:56 AM
  5. I am attempting to write a com addin for mappoint ....
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 03-14-2001, 10:44 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