topic Re: Does the GoogleMap apps only work if Lat and Long has IP Information? in Splunk Search

Does the GoogleMap apps only work if Lat and Long has IP Information?

chienly — Wed, 23 Feb 2011 01:44:31 GMT

Hi,

Just wondering if anyone here knows if the GoogleMap apps can take in longitude and latitude data without any IP Addresses and still map them?

I just want to know if it can map a location directly with just the longitude and Latitude coordinates taken from a csv file?

Thanks,

-Chien

Re: Does the GoogleMap apps only work if Lat and Long has IP Information?

ziegfried — Wed, 23 Feb 2011 01:56:42 GMT

Plotting events on a map does not depend on an IP address. The current version of the module need the fields _lat (latitude) and _lng (longitude) to available in the final results.

The content of the fields has to be the degrees of latitude/longitude as a floating point number: eg 47.11

Other notations (eg. degrees°,minutes',...) are not supported.

The geonormalize command helps when the location information is not present in the _lat and _lng fields as it detects different patterns of field names where the information could be found and populates the _lat/_lng fields. When using the maps view (the default view of the app) or any other view where the module setting autoPostProcess is turned on, the geonormalize command is automatically added to the search.

Note: In the upcomming 1.1 release of the app, the module will use a single field called _geo containing the combined latitude and longitude information instead of the 2 fields (_lat and _lng). The values have to separated by a comma. So for example a _geo field value of 47.11,8.15 would be valid.

Re: Does the GoogleMap apps only work if Lat and Long has IP Information?

chienly — Fri, 25 Feb 2011 01:38:46 GMT

Thanks for the followup Ziegfried!

I have following data indexed in a csv file with the _lat and _lng field but it still did not seem to pick up coordinates to plot on the graph?

Here's a sample:

store_number _lat _lng
8001 -71.385908 42.29663
9999 37.784132 -122.395913
47 42.307 -71.3989
50 42.4988879 -71.1211728

Does the number contain too many digits after the decimal or does the leading negative sign cause any issue?

Thanks again,
Chien

Re: Does the GoogleMap apps only work if Lat and Long has IP Information?

ziegfried — Fri, 25 Feb 2011 16:47:02 GMT

Can you add the csv data and the search your're using to map it to your question?