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
Get Updates on the Splunk Community!

Detecting Brute Force Account Takeover Fraud with Splunk

This article is the second in a three-part series exploring advanced fraud detection techniques using Splunk. ...

Buttercup Games: Further Dashboarding Techniques (Part 9)

This series of blogs assumes you have already completed the Splunk Enterprise Search Tutorial as it uses the ...

Buttercup Games: Further Dashboarding Techniques (Part 8)

This series of blogs assumes you have already completed the Splunk Enterprise Search Tutorial as it uses the ...