X and Y coordinates to latitude and longitude

You need to create a geopoint object field with your lat and long.
Give a read on this short documentation, it will help you on building your config.
https://www.elastic.co/guide/en/elasticsearch/reference/current/geo-point.html

> {
>   "text": "Geo-point as an object",
>   "location": { 
>     "lat": 41.12,
>     "lon": -71.34
>   }
> }

I'd get the fields, extract the values without the strings, and put them together in a new geopoint field. Something like this:

mutate {
  add_field => [ "[geoip][location]", "%{longitude}" ]
  add_field => [ "[geoip][location]", "%{latitude}" ]
}

Your outcome must be a field with the two coordinates together so Kibana can pick it up and build the points on the map for you.

1 Like