PDA

View Full Version : Drawing Circles Around a List of Lat/Lons



Eric Frost
09-28-2009, 10:01 AM
This is a tool prepared by request and is similar to the download at
http://www.mapforums.com/drawing-radii-circles-9991.html
but works off a list of lat/lon's instead of address.

Enjoy and let me know if you have any questions or other requests!

Eric

russarb
09-28-2009, 01:45 PM
I just tried the Radii with a list of Lat/Lons and it worked great!

russarb
09-28-2009, 03:06 PM
Adding the lat/long option to the drive times would be a great addition as well.

Eric Frost
09-28-2009, 03:53 PM
Done!

http://www.mapforums.com/drawing-drivetime-zones-around-list-lat-lons-11170.html

Eric

Reno24
12-08-2009, 06:34 AM
Hey Eric...

Iwe had a go with this new tool of ours, and I dosent work for me..
What Iwe found is that is might be what the cords I am using are based on the UTM32 EUREF89 system, where as urs is prob based on the GEO WGS84 system...

Can u rewrite it to be able to use the UTM32 system? Otherwise I have to look up 600+ adresses to finde their respective GEO WGS84 cords, and thats not my first option :)

Greetings
René.

Eric Frost
12-08-2009, 01:37 PM
You'll have to find some tool to convert UTM32 EUREF89 to lat/lon.

Search "UTM32 EUREF89" or just "UTM EUREF89". I wonder if the franson.com Coordtrans product can do it?

Eric

Reno24
12-10-2009, 06:25 AM
Hi Eric..

Iwe worked out the conversion probs, but it seems there still a prob with the "miles" conversion..

When I google how much 600m is in miles, it give me 0,372822715 miles, when I input that into Mappoint, it displays aorund 375 meters...??

Is it a bug in ur coding?

Best Regards
René

Eric Frost
12-10-2009, 07:27 AM
I noticed a change in behaviour with the latest version or versions of MapPoint.. I think the radius used to actually be the circumference or vice versa. I'm not sure in what version this changed. Is it off just by a factor of 2x?

Reno24
12-14-2009, 07:02 AM
Hi Eric...

I dont really know how much its off, but at input 1 mile, its displays 1 km.
According to verious google searches, it should be 1 mile = 1,609 km..

Iwe been trying to compare it to the ealier files u have uploaded, but I cant find any other changes whan this one:

In the new Lat/Lon file is says:
objMap.Shapes.AddShape geoShapeRadius, objLoc, fRadius * 2, fRadius * 2

Wheres the old files say:
objMap.Shapes.AddShape geoShapeRadius, objLoc, fRadius, fRadius

When deleting the *2 from the code, its displays 1 mile, as 500 meters.

Could that be the problem?

Eric Frost
12-14-2009, 04:54 PM
Oh - not sure how that got messed up. I think it might save your Units setting in the registry. You may be able to just go to Tools | Options and change the units and then run again.

To change the Units in code, see the Units property of the Application object in the Help File. Here's the sample code --


Sub ToggleUnits()
Dim objApp As MapPoint.Application

'Create the Application object
Set objApp = New MapPoint.Application

'Toggle the units
If objApp.Units = geoMiles Then
objApp.Units = geoKm
Else
objApp.Units = geoMiles
End If

End Sub

sshot1
04-27-2011, 08:43 AM
Hello, I am new to the sight and a very basic user. Is there an option to "Hide Size" for all of the radius circles created to remove the balloon showing the size of the radius. I have about 6K locations mapped and wanted to remove all at once. I am using MP 2010.

Thanks.

Eric Frost
04-27-2011, 10:17 AM
SShot1

Yes! It would require a little modification to the script, I will do that now.

Eric

Eric Frost
04-27-2011, 10:19 AM
Someone asked me some questions about this so I figured I post and answer here --


As a user of MapPoint 2011 I am intrigued by your solution and I'd like to try it. I do have a few questions:
* Does it draw multiple unique radii, such as 45 locations each with a radius of 9.33 miles, 20 locations with 6.33 miles, and 30 locations with 4.29 miles?
* Can it designate a color for the circle ahead of time, such as choosing a shade of red for the 9.33-mile-radius circles and a shade of blue for the 4.29-mile-radius circles?

1. Yes and 2. Yes!

It doesn't have a setting for the width, but that could be added easily as well.

Eric

Eric Frost
04-27-2011, 10:37 AM
For sshot1 --

Here's a new version with columns for controlling the "weight" or thickness of the line, and another column to control whether or not the Distance Radius shows up on the circle.

Hope this helps, have fun!

Eric

roxannebmiller
05-04-2011, 09:48 AM
AWESOME!!!! saved tons of time. Would like to add further information, name, address, etc. But I can always use a v-lookup:v4v::v4v:

Eric Frost
05-04-2011, 09:55 AM
Great! Glad to hear.

For the other information, you could either do a Pushpin Balloon or a label. Some info on how to draw labels programmatically is here --

What's New at MP2K Magazine (http://www.mp2kmag.com/update/mappoint.newsletter/2009-10-02/)

Eric

roxannebmiller
05-04-2011, 10:03 AM
I thought I saw Something where I can download another set of points and then get a list of the points in the original set that as the mile radius uploaded.

So 2 list uploaded
1- Radius upload as what was explained in this forum
1- List of additional points
But I need those points pulled out in the second list that fall into each one of the radius areas.
Then export those to an excel sheet? Is there something that you are familiar with that can assist?

Eric Frost
05-04-2011, 02:01 PM
Hi Roxanne,

You could do it with a little code of new code in the macro, it would not be terribly difficult, I think we'd just want to figure out how best to format the output for your needs, or you could just right click on each circle and perform an "export to Excel" operation.

Eric

Eric Frost
03-26-2014, 12:21 PM
Here's a new version which will first check to see if MapPoint is open and then add the circles to the open instance of MapPoint.

If it does not find an open instance of MapPoint, it will create a new map.

808

In earlier versions, it would always create a new map.

hope this helps someone!

Eric

guy_bertrand@wiband.com
07-14-2014, 05:03 PM
Sorry to be coming to the party so late but I JUST experienced this last week too and the resolution was quite simple in my case - On the Options page in the MapPoint application, set your parameter to kilometres (from miles). Hope it works (or is still relevant after all this time). GB



Hi Eric...

I dont really know how much its off, but at input 1 mile, its displays 1 km.
According to verious google searches, it should be 1 mile = 1,609 km..

Iwe been trying to compare it to the ealier files u have uploaded, but I cant find any other changes whan this one:

In the new Lat/Lon file is says:
objMap.Shapes.AddShape geoShapeRadius, objLoc, fRadius * 2, fRadius * 2

Wheres the old files say:
objMap.Shapes.AddShape geoShapeRadius, objLoc, fRadius, fRadius

When deleting the *2 from the code, its displays 1 mile, as 500 meters.

Could that be the problem?