Showing bubbles on a map

[Daz]

I have a project to produce a “live” map. Essentially create an excel database which produces a distance from a building. I then want to show this distance on a map. In the form of a bubble.
When someone updates the excel database the bubble could change size. Looking at possibly 150 bubbles on a map.

can anyone advise me on how to proceed?

thanks

 

[Steven G]

can anyone advise me on how to proceed?

Somewhere here can help you with your project by giving you suggestions but you need to tell us exactly what type of help you need. Can you tell us what you have done so far?

 

[Daz]

Somewhere here can help you with your project by giving you suggestions but you need to tell us exactly what type of help you need. Can you tell us what you have done so far?

Hi mate,

currently I have the map made, the database made with distances produced. I just need a way of showing the generated bubbles onto the map to scale.

thank you for the fast reply!

daz

 

[Cubist]

Bubbles like this can be made using "ImageMagick" (free software)...




But you'd need to write a script that uses the info in your database to generate, and run, a command of this form...

convert.exe source_map.png -fill white -strokewidth 0
\( -size 80x80 xc:black -draw 'circle 40,40 40,10' -write mpr:c -blur 0x10 -shade 120x45 -normalize mpr:c -alpha Off -compose CopyOpacity -composite -geometry +125+49 \) -alpha on -compose hardlight -composite
\( -size 100x100 xc:black -draw 'circle 50,50 50,10' -write mpr:c -blur 0x10 -shade 120x45 -normalize mpr:c -alpha Off -compose CopyOpacity -composite -geometry +25+49 \) -alpha on -compose hardlight -composite
\( -size 100x100 xc:black -draw 'circle 50,50 50,10' -write mpr:c -blur 0x10 -shade 120x45 -normalize mpr:c -alpha Off -compose CopyOpacity -composite -geometry +225+29 \) -alpha on -compose hardlight -composite
\( -size 150x150 xc:black -draw 'circle 75,75 75,10' -write mpr:c -blur 0x10 -shade 120x45 -normalize mpr:c -alpha Off -compose CopyOpacity -composite -geometry +280-29 \) -alpha on -compose hardlight -composite
output_map.png

NOTE: The above is one continuous command. I just split it up into lines for some clarity. The bold parts define the size and location of a bubble - one bubble per line. The first bubble has radius r=40 centre x=165, y=89 which maps to the numbers in the command:- 2r; 2r; r; r; r; x-r; y-r. The backslash \ characters might not be necessary on windows.

 

[Cubist]

I made a mistake on the radius. The first bubble actually has radius r_actual=30 (pixels) centre x=165, y=89 and for the command you need the following numbers:- 2r; 2r; r; r; r; x-r; y-r where r=r_actual+10

 

[Daz]

I made a mistake on the radius. The first bubble actually has radius r_actual=30 (pixels) centre x=165, y=89 and for the command you need the following numbers:- 2r; 2r; r; r; r; x-r; y-r where r=r_actual+10

Thank you for this! I’m going to have a steep learning curve! Haha. I’m good with maths but coding is new to me.

I really appreciate your help and direction!