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!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...