topic Re: How to plot trasactions that has Latitude and Longitude already? in All Apps and Add-ons

How to plot trasactions that has Latitude and Longitude already?

DotTest37 — Wed, 27 Apr 2011 21:28:11 GMT

Our Web App already returns the lat and long on the Payload XML.
On the response you see something like this:
***-115.3751777777777836.542195555555555***

I successfully extracted fields with that and named them 'Latitude' and 'Longitude' but the Google Map app cannot see it (even though the fields populated with data on the left side of the screen)

Has anybody been successful plotting Lat and Long directly from the XML response?
Thanks!!

Re: How to plot trasactions that has Latitude and Longitude already?

sideview — Mon, 28 Sep 2020 09:30:15 GMT

Yep. I did this on an app I developed for one of my customers not long ago. We wanted to use the GoogleMaps module but we already had latitude and longitude in the events so we didnt need the lookup.

You may be tripped up by the same thing I was, which is that while the lookup outputs lots of fields, the only fields the GoogleMaps module looks for are "_lat" and "_lng".

(Note the underscores and also note especially the lack of "o" in "_lng". )

Feed this to the GoogleMaps module and it should work.

<your search> | eval _lat=Latitude | eval _lng=Longitude

Re: How to plot trasactions that has Latitude and Longitude already?

DotTest37 — Thu, 28 Apr 2011 04:50:48 GMT

Thanks for assisting me Nick!
Your suggestion worked perfect.

Re: How to plot trasactions that has Latitude and Longitude already?

ziegfried — Fri, 24 Jun 2011 11:05:59 GMT

Please note: In the new version you have to use the _geo field with the combined lat/lng value:

<your search> | eval _geo=Latitude+","+Longitude