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!

New in Observability Cloud - Explicit Bucket Histograms

Splunk introduces native support for histograms as a metric data type within Observability Cloud with Explicit ...

Updated Team Landing Page in Splunk Observability

We’re making some changes to the team landing page in Splunk Observability, based on your feedback. The ...

New! Splunk Observability Search Enhancements for Splunk APM Services/Traces and ...

Regardless of where you are in Splunk Observability, you can search for relevant APM targets including service ...