PDA

View Full Version : Point selection and export to GPS



robertsnook
08-30-2011, 03:59 PM
I have been given the task of automating (or nearly so) the selection of points for our business and my supervisor has asked me to look into Map Point to see if it can be part of the solution.

What I need to be able to do is:

Bring in a list of points (A) from a GPS device. (I have this one)
Bring in a list of business locations (B). (I mostly have this)
Bring in the boundary file of a Census Urban Area (C). (I'm sure this can be done)
Select 5 points from B that are within 4 miles of a point from A AND within C and add them to a list (D). (This is what I need to know of Map Point can do)
Export C back to a GPS. (I'm sure this can be done)


I know it can be done in MapInfo Pro, as I've already run a test with it and it has run smoothly, but, that is with the free trial version before buying. My supervisor already has Map Point and would like to save costs and see if we can avoid buying MapInfo. Is this doable?

Eric Frost
08-30-2011, 04:16 PM
You could do it with MapPoint with a little custom macro development, it doesn't quite do it cleanly right out of the box like MapInfo Pro, but if you can get your hands dirty a little bit :alien2:, you can make MapPoint do it for you :-)


Select 5 points from B that are within 4 miles of a point from A

How do you know it's five points? Just the five that are closest to a the A points? You could either hand-draw radii around all the A points or use a simple loop in a program to calculate all the distances.


within C

You can use QueryFromPolygon do do this, the interface equivalent would be export to Excel.

Regarding the
AND part, you'd have to match up the lists yourself using the program, MapPoint doesn't let you write Spatial SQL statements like MapInfo Pro, but it's not hard to achieve the same results yourself.

hope this helps!
Eric

robertsnook
08-30-2011, 10:09 PM
Wow, thanks for the stellar turnaround.

Yeah, we need just the five closest points from B. I need to do this process to about 200 points for about 10-12 cities a month, so a loop prgram would be the way to go. As for the matching lists after filtering, I'm not sure how I'd manage that on the scale I need.

Thanks for the info!