topic Re: How to get physical address given latitude and longitude coordinates and show it in a table? in Splunk Search

How to get physical address given latitude and longitude coordinates and show it in a table?

rongruspe — Tue, 07 Jul 2015 05:26:14 GMT

Given that I have my latitude an longitude in an RDBMS and I can access it using Splunk DB Connect. I want to show the Physical address based on the latitude and longitude cordinates

Re: How to get physical address given latitude and longitude coordinates and show it in a table?

martin_mueller — Tue, 07 Jul 2015 08:35:44 GMT

You'll need an external service (Google Maps, etc.) to provide that lookup for you. Once you have that you can call such an API from a scripted lookup, pass the lat/lon to the lookup and return the physical address into your search results. Displaying that in a table is the easiest part.

Re: How to get physical address given latitude and longitude coordinates and show it in a table?

MuS — Tue, 07 Jul 2015 09:52:19 GMT

And here you can find such an external service https://developers.google.com/maps/documentation/geocoding/?hl=de
uupppss copy/paste error - the first link was the wrong one 🙂

Re: How to get physical address given latitude and longitude coordinates and show it in a table?

rongruspe — Wed, 08 Jul 2015 03:00:17 GMT

Thanks! Very helpful. Do you have an example on how to create a scripted lookup that calls an API? And where can I get that API?

Re: How to get physical address given latitude and longitude coordinates and show it in a table?

martin_mueller — Wed, 08 Jul 2015 07:25:05 GMT

Look at the link posted by @MuS for a start.

Re: How to get physical address given latitude and longitude coordinates and show it in a table?

Imjusttesting — Sun, 11 Oct 2015 07:19:27 GMT

@Mus & Martin_mueller,

So far what is displayed on the table are the Lon & Lat but i need the Physical address but I'm planning to use OpenStreetMap instead of GoogleMap.
https://drive.google.com/file/d/0B1nXkGdlsvvPcjBndldfcWlRQjA/view?usp=sharing

How can i do it?
Are the logic to display the Physical address on the table works the same on both Google Map & OpenstreetMap?

Apologise Rongruspe for "hijacking' ur post but I'm also facing similar issues.

Re: How to get physical address given latitude and longitude coordinates and show it in a table?

MuS — Sun, 11 Oct 2015 07:32:39 GMT

Yes, the logic is the same. You can easily switch between Google Maps and Openstreetmap or any other Map tile server in Splunk; see the docs http://docs.splunk.com/Documentation/Splunk/6.3.0/Viz/Editdashboardpanelvisualizations Topic Map Tiles

PS: You can even create your own map tiles and use them in Splunk 😉

Re: How to get physical address given latitude and longitude coordinates and show it in a table?

Imjusttesting — Sun, 11 Oct 2015 07:37:04 GMT

Thanks MuS for the fast respond 🙂

I've no issues displaying the coordinate on the various Maps but i need to display the Physical address instead of Lat & Lon on the Table.
Are you able to view the Pic on the link i provided?

Do you have any suggestion how this can be done?

Thanks & appreciate a lot

Re: How to get physical address given latitude and longitude coordinates and show it in a table?

martin_mueller — Sun, 11 Oct 2015 10:50:10 GMT

The answer is the same as well - use a geolocation web service, such as Google's API linked to above. I'm sure there are services besides Google too.