geocodes and mapping addresses

[Mike Wilson]

http://www.ajaxvideotutorials.com/V1...Advanced_1.swf

The above link is to a video that shows the capabilities of marking airport locations on a Google map. I have this need to mark store addresses on a map, hundreds. I'm not sure if this is exclusively a web capability (which I have no experience with) or available as a desktop capability. I have the table of addresses and have the lat-long numbers for each address. I don't need bells and whistles, just mark each location for now. I need this ASAP. Anyone have experience with this, can help me as a complete newbe in this arena, have an app for me to see, buy, copy? Thanks.

[Ted Giles]

Re: geocodes and mapping addresses

Mike, I get a 404 for the link you gave.

I know how to show locations of single stores and people, but not multiples on the same map.
If that's any help I'll send you an example using XDialog.

tesco.JPG

[glenschild]

Re: geocodes and mapping addresses

http://www.ajaxvideotutorials.com/V1...Advanced_1.swf

The above link is to a video that shows the capabilities of marking airport locations on a Google map. I have this need to mark store addresses on a map, hundreds. I'm not sure if this is exclusively a web capability (which I have no experience with) or available as a desktop capability. I have the table of addresses and have the lat-long numbers for each address. I don't need bells and whistles, just mark each location for now. I need this ASAP. Anyone have experience with this, can help me as a complete newbe in this arena, have an app for me to see, buy, copy? Thanks.

On the web you can show an alternate view in a grid component that shows all markers on a page for the records shown on the grid. I am guessing (but have not tried) that you can use that grid component on the desktop and therefore should be able to achieve that.

[Ted Giles]

Re: geocodes and mapping addresses

Is this only in V11 Glen?
Is it an additional feature pack item?
Any luck getting the Total Field in Bold in a Grid.

[glenschild]

Re: geocodes and mapping addresses

I believe so and as for bold totals thanks for the reminder :-) will take another look...

[G Gabriel]

Re: geocodes and mapping addresses

Are you looking for static or dynamic maps?
Static:
I wrote a function that will do just that. Will test it in W7 and post it and you could donate $1,000 to charity (St Jude Children, cancer foundation)
Dynamic:
That's a long story. I wrote a function a while back that worked just fine in Windows XP, but since Microsoft has it for me, they removed the dll that made it possible and replaced it with a different one in W7 that I don't have the time nor the inclination to explore since I decided to do the coding in google itself and the heck with Microsoft. That won't help you since its all web-based. But, it is my understanding that v10 or maybe 11 (don't have neither) has geocoding abilities. Have you looked into that?

Here is a video clip
static_gc..zip
pending a little more testing.
P.S. Static is not entirely static, you could zoom in/out re size/change colors and few other things.

[Mike Wilson]

Re: geocodes and mapping addresses

G,
I have one like that too (code below). Works off Google. I have v11 and it does have geocode_address() which obtains the longitude-latitude for a given address. I also came up with a code written by Peter Wayne that derives the distance between two points using the longitude-latitude values. That's all good. But what you and I have presents a single location/single marker on the map. What I need is the map to present a marker for each of the locations in a table (see pic ) and link:

https://forum.alphasoftware.com/show...hlight=geocode

There are 181 locations. I need this to come up with a method of dividing up these locations between a group of installation teams, and then generate routings.

FUNCTION google_map AS C ( )

' started from Peter Wayne Alpha message board:
'https://forum.alphasoftware.com/showthread.php?94025-Embedded-Google-Maps..

'initial zoom parameters
	dim vc_zoom as C="8"
	dim vc_size as C="512"
	dim vc_size2 as C
	dim vaddr as C

' get the address information 
	dim vaddr1 as C="1600 Pensylvania Ave"
	dim vaddr2 as C=""
	dim vcity as C="Washington"
	dim vstate as C="DC"

'derive the address as string
	locale=stritran(vaddr1," ","+")+","+stritran(vaddr2," ","+")+","+vcity+","+vstate

'make variable for the dialog size presenting the map
	vc_size2=alltrim(vc_size)+"x"+alltrim(vc_size)

'make the url variable for the Google map
	url="http://maps.google.com/maps/api/staticmap?center="+locale+"&zoom="+alltrim(vc_zoom)+"&size="+vc_size2+"&maptype=roadmap"+\
"&markers=color:blue%7Clabel:W%7C"+locale+"&sensor=false"

' generate the map load instructions
	dim dlg2_title as C
	dlg2_title="Test"
	po=*url_object(url)
	ui_bitmap_png_load("tmp2",po.content)

'generate the resize dialog with the embedded Google map dialog
	dim dlg1_title as C="GOOGLE SIZE"
	ui_modeless_dlg_box(dlg1_title,<<%dlg%
	{position=2,2}{nocaption}{background=red}{font=arial,10}
	{lf};
	WINDOW SIZE | ZOOM ;
 	(vc_size:512)| (vc_zoom:8!evz_*);
  	    | (vc_zoom:10!evz_*);
 	(vc_size:1024)| (vc_zoom:12!evz_*);
  	    | (vc_zoom:13!evz_*);
   	    | (vc_zoom:14!evz_*);
       	| (vc_zoom:15!evz_*);
    	| (vc_zoom:16!evz_*);
	    | (vc_zoom:18!evz_*);
	{lf};
	{lf};
	{justify=center}   <Close>;
	%dlg%,<<%code%
	if a_dlg_button="evz_change" then
		vc_size2=alltrim(vc_size)+"x"+alltrim(vc_size)
		a_dlg_button=""
		ui_modeless_dlg_close(dlg2_title)
		vc_size2=alltrim(vc_size)+"x"+alltrim(vc_size)
		url="http://maps.google.com/maps/api/staticmap?center="+locale+"&zoom="+alltrim(vc_zoom)+"&size="+vc_size2+"&maptype=roadmap"+\
"&markers=color:blue%7Clabel:W%7C"+locale+"&sensor=false"
		po=*url_object(url)
		ui_bitmap_png_load("tmp2",po.content)
		ui_modeless_dlg_box(dlg2_title,<<%dlg%
		{position=4,.2}{nocaption}{font=arial,10,b}
		{text=60vaddr};
		{lf};
		{image=tmp2}
		%dlg%)
	  a_dlg_button=""
	end if

	if a_dlg_button="Close"
		ui_modeless_dlg_close(dlg2_title)
		ui_modeless_dlg_close(dlg1_title)
	end if
	%code%)

'generate first presentation of map with preset size and zoom
	ui_modeless_dlg_box(dlg2_title,<<%dlg%
	{position=4,.2}{nocaption}{font=arial,10,b}
	{text=60vaddr};
	{lf};
	{image=tmp2}
	%dlg%)

END FUNCTION
google_map()

[G Gabriel]

Re: geocodes and mapping addresses

Yes, mine could show more than one..don't know about 181 though !. That might require a wall map!
Are you looking for the best route?

[Ted Giles]

Re: geocodes and mapping addresses

Were the freebie routers of no use Mike?
You might need to optimise the 181 sites and use Zoning. If you don't the outer edges won't get a fair share of the teams, so some form of weighting migh help.
When I did this years ago (on paper), the total distance travelled in a Zone was the key determinant. Getting too and from the Zone was of less importance as that was a given.