Splunk Search

How to stop the rounding of latitude and longitude

marcus933
New Member

I have these set of codes,

Mapping Test
Mapping

<map>
  <title>Map</title>
  <search>
    <query>
      source="Total population by location(test).csv"
      |geostats latfield=lat longfield=lon count
    </query>
  </search>
  <option name="mapping.tileLayer.url">http://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png</option>
                     <option name="mapping.tileLayer.subdomains">[a,b,c]</option>
                     <option name="mapping.tileLayer.maxZoom">24</option>
             <option name="link.visible">TRUE</option>
             <option name="link.exportResults.visible">TRUE</option>
             <option name="link.inspectSearch.visible">TRUE</option>
             <option name="link.openSearch.ViewTarget">TRUE</option>
             <option name="mapping.map.zoom">9</option>
             <option name="mapping.markerLayer.markerMaxSize">50</option>
             <option name="mapping.map.center">(1.3667,103.8)</option>
             <option name="link.openSearch.text">Open in New Search</option>
             <option name="link.openSearch.search">source="Total population by location(test).csv"| geostats latfield=lat longfield=lon</option>
             <option name="link.openSearch.searchEarliestTime">-30d</option>
             <option name="link.openSearch.searchLatestTime">now</option>
</map>
  </row>

Basically i want the stop splunk from rounding my values of lat and lon so that they do not have duplicates.
Thanks in advance

Tags (1)
0 Karma

jkat54
SplunkTrust
SplunkTrust
0 Karma

jkat54
SplunkTrust
SplunkTrust

Are they rounded coming out of the root search or out of the geostats command?

Try putting those fields in a table before geostats to see if they are rounded coming out of the root search or not.

0 Karma

marcus933
New Member

I have put the fields into a table and it seems that the rounding is coming from the geostats command and not the root search

0 Karma
Get Updates on the Splunk Community!

Enter the Splunk Community Dashboard Challenge for Your Chance to Win!

The Splunk Community Dashboard Challenge is underway! This is your chance to showcase your skills in creating ...

.conf24 | Session Scheduler is Live!!

.conf24 is happening June 11 - 14 in Las Vegas, and we are thrilled to announce that the conference catalog ...

Introducing the Splunk Community Dashboard Challenge!

Welcome to Splunk Community Dashboard Challenge! This is your chance to showcase your skills in creating ...