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!

Detecting Remote Code Executions With the Splunk Threat Research Team

REGISTER NOWRemote code execution (RCE) vulnerabilities pose a significant risk to organizations. If ...

Observability | Use Synthetic Monitoring for Website Metadata Verification

If you are on Splunk Observability Cloud, you may already have Synthetic Monitoringin your observability ...

More Ways To Control Your Costs With Archived Metrics | Register for Tech Talk

Tuesday, May 14, 2024  |  11AM PT / 2PM ET Register to Attend Join us for this Tech Talk and learn how to ...