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!

Announcing Scheduled Export GA for Dashboard Studio

We're excited to announce the general availability of Scheduled Export for Dashboard Studio. Starting in ...

Extending Observability Content to Splunk Cloud

Watch Now!   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to leverage ...

More Control Over Your Monitoring Costs with Archived Metrics GA in US-AWS!

What if there was a way you could keep all the metrics data you need while saving on storage costs?This is now ...