How to map objects using LAT/Long
How to map objects using LAT/Long
(OP)
Hi I want to be able to map where my objects are using their LATS/LONGS on Crystal 11.
My data is set so that these coordinates are dynamic, and may constantly change every 15 minutes or so depending on whether or not they are moving or not.
Secondly they are presented in this format: #######(Direction)
i.e. 0330304N
0811434W
I have been able to successfully use Google maps to map building, using Format Editor -> Picture -> Graphic Location
and this formula that I found online!
//Image URL
WhilePrintingRecords;
StringVar Markers;
"http://maps.google.com/maps/api/staticmap" &
"?center=" & {@Address CityState} &
"&size=512x512" &
"&visual_refresh=true" &
"&maptype=satellite" & Markers &
"&sensor=false"
But the building's locations are presented as an address!
Please advise!
My data is set so that these coordinates are dynamic, and may constantly change every 15 minutes or so depending on whether or not they are moving or not.
Secondly they are presented in this format: #######(Direction)
i.e. 0330304N
0811434W
I have been able to successfully use Google maps to map building, using Format Editor -> Picture -> Graphic Location
and this formula that I found online!
//Image URL
WhilePrintingRecords;
StringVar Markers;
"http://maps.google.com/maps/api/staticmap" &
"?center=" & {@Address CityState} &
"&size=512x512" &
"&visual_refresh=true" &
"&maptype=satellite" & Markers &
"&sensor=false"
But the building's locations are presented as an address!
Please advise!
Talk To Other Members