Some sample data for creating a maps visualisation in splunk
countries_lat_long_int_code.csv
code,name,country,latitude,longitude
61,Australia,AU,-25.274398,133.775136
86,China,CN,35.86166,104.195397
49,Germany,DE,51.165691,10.451526
33,France,FR,46.227638,2.213749
64,New Zealand,NZ,-40.900557,174.885971
685,Samoa,WS,-13.759029,-172.104629
41,Switzerland,CH,46.818188,8.227512
1,United States,US,37.09024,-95.712891
678,Vanuatu,VU,-15.376706,166.959158
If I add this to Lookups » Lookup table files in Splunk, I can generate a map visualisation.
Then if I put something like this in the search bar, it will generate a map visualization
| inputlookup countries_lat_long_int_code.csv | fields + latitude longitude | eval field1=100
the stats tab will look like this:
latitude longitude field1
-25.274398 133.775136 100
35.86166 104.195397 100
51.165691 10.451526 100
46.227638 2.213749 100
-40.900557 174.885971 100
-13.759029 -172.104629 100
46.818188 8.227512 100
37.09024 -95.712891 100
-15.376706 166.959158 100
What I would like to know is what parameters/format the data has to be in for a maps visualisation?
For example, it looks like latitude and longitude must be the first 2 columns, and possibly in that particular order.
Can anyone explain what other formats are accepted, or point me in the right direction? For example I am just playing around with something like this:
| inputlookup countries_lat_long_int_code.csv | fields + latitude longitude | eval field1=100 | eval field2=200 | eval field3="country name"
... View more