Help needed in loading map using lat and lon value

Elastic Stack Kibana
1

Hi
I am using kibana 5.6.3 and i am facing problem while creating coordinate map after loading index. I am getting error as

No Compatible Fields: The "geo4-*" index pattern does not contain any of the following field types: geo_point

i am having csv file with city, lat , long values
city lat lon
London 51.5073509 -0.1277583

and i created logstash.conf as below

input {
file {
path => "D:\Projects\Level3-kibana\DataSet\Test.csv"
start_position => "beginning"
sincedb_path => "/dev/null"
}
}

filter {
csv {
separator => ","
columns => ["city","lat","lon"]

}

 mutate {
  convert => { "lat" => "float" }
  convert => { "lon" => "float" }
  add_field => {
        "[geoip][location]" => [ "%{lon}", "%{lat}" ]
        "[geoip][latitude]" => "%{lat}"
        "[geoip][longitude]" => "%{lon}"
  }
}

mutate {convert =>["city","string"]} 

mutate {
 remove_field => [ "message", "host", "@timestamp", "@version" ]
}

}

output {
elasticsearch {
hosts => "http://localhost:9200"
index => 'geo4-point'

}
stdout{}

}

can someone help me to load this coordinates in map

2

If your mapping doesn't have geo_point field then you cannot use the maps. However I think that there is something wrong with your logstash.conf. I would recommend you to post your question on Logstash discuss channel to get more help there. I think also its a mapping issue. Your config needs to look something like this :

 "geo": {
            "properties": {
              "location": {
                "type": "geo_point"
              }

For more reference: https://www.elastic.co/guide/en/elasticsearch/reference/current/geo-point.html

thanks
Rashmi

3

Thanks rashmi will post in logstash forum

4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.