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

exporting data

This is a discussion on exporting data within the MapPoint Desktop Discussion forums, part of the Map Forums category; Is there a way for me to draw a boundary around push pins and export the data for those pins ...

  1. #1
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137

    exporting data

    Is there a way for me to draw a boundary around push pins and export the data for those pins

    I really need to be a able to create custom territories and export the data for those territories

    Any help is appreciated

  2. #2
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60
    Yes if you want to do some programming. But this will give you a shape object for your territory. Note that this isn't quite the same as the territories that MapPoint knows about, and data export from that shape would be limited. Eg. you could export all enclosed pushpins, but I think there would be problems getting at aggregate demographics. Perhaps you could find all zipcodes or census districts in the shape, and then get the demographic data for thar.

    The basic algorithm to find an enclosing shape is known as "Finding the Convex Hull".

    I have the algorithm in some books, so I could give the basics here, or I (along with others on this board) could be oontracted to code it up.
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

  3. #3
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    i only need basic data like name & address exported

    I am not familiar with any aspects of programming for MapPoint although if it is fairly basic I could probably handle it

    Otherwise, I would be interested in finding the cost for you or someone else to supply the programming

  4. #4
    Winwaed's Avatar
    Winwaed is offline Mapping-Tools.com Black Belt
    Join Date
    Feb 2004
    Location
    Irving,Texas
    Posts
    1,859
    Blog Entries
    60
    Exporting data from the pushpins would be easy enough to do.
    I've just looked up the Convex Hull algorithm. "Algorithms" by Sedgwick has a whole chapter on the subject and includes three different approaches. If you've done some geometric programming before, then it doesn't look too complex. (finding angles, sorting coordinates, etc)

    I think you need to think about how the user will select the pins to form the new 'territory'. Eg. will they be all the pins ina pushpin set? Or will they be all the pins in a set with a particular pin symbol? Or will the user perform an "add to territory" function for each pin?

    The process will then be something like:

    - User selects pins to make territory
    - Code is run that creates a shape object surrounding these pins.
    - User selects shape and then selects the "Export To Excel" option to output the pushpin data to an Excel spreadsheet.

    You could try this manually to see how this would work.
    Draw the shape by hand, around the required pins. You may even find that this is satisfactory for your needs.

    If you'd like me to quote on the convex hull stuff (automatic shape generation around a group of pins), send me an email.


    Richard
    Winwaed Software Technology LLC
    http://www.winwaed.com
    See http://www.mapping-tools.com for MapPoint Tools

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Exporting Data From Territories
    By halc in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 09-22-2005, 12:31 PM
  2. Exporting Data
    By kdulaney in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 05-17-2005, 03:37 PM
  3. Exporting Data from MapPoint
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 12-16-2004, 12:23 PM
  4. Exporting Data from Map Point
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 03-01-2004, 08:11 PM
  5. Exporting data to Excel
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 08-28-2002, 03:57 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