All Apps and Add-ons

Geostats Mapping

leonards1
Explorer

I have a json array of movement data coming in with multiple lat and long values and am having difficulty plotting this movement on a map.

I am able to get these to plot as a single point when I have only one lat/long combination in the event, however when there are multiples as in the below example (in markers{}), I lose the visualization.

Incoming data example:

{   
     date_start:     1531698100.179007  
     date_update:    1531698291.081359  
     markers:   [
        {
         date:   1531698136.120904  
         latitude:   27.411273  
         longitude:  -82.505357     
        }   
        {
         date:   1531698140.102953  
         latitude:   27.411935  
         longitude:  -82.505325 
        }   
    ]   
     total_distance_in_meters:   2470   
     total_time_minutes:     2.5999695122241966 
    ]   
}

I am using the below. The mvexpand breaks the single event into 2 based on the date creates 2 separate events, which I believe is what I need to do however they just don't plot:

index="myindex" source="mysource.json" 
| mvexpand markers{}.date
| geostats latfield=markers{}.latitude longfield=markers{}.longitude count

Where am I going wrong here?

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Best Practices: Splunk auto adjust pipeline queue

When you enable autoAdjustQueue in Splunk, maxSize should be understood as the queue size Splunk starts with ...

Laser Bananas and Edge Hubs: Exploring Operational Technology (OT) Data Through a ...

  OT is a different environment to traditional IT and can have interesting challenges when interfacing the ...

Event Series: Mastering AI Tokenomics and Splunk Agent Observability

Beyond the Black Box: Correlating AI Performance and Tokenomics with Splunk Agent Observability   As ...