Hi,
I have some csv files which contains the Latitude and Longitude column. I am trying to put these coordinates on Kibana map but not able to do so. Following is my logstash conf:
input {
file {
path => [ "/var/opt/data/report/reportingdata*.csv" ]
start_position => "beginning"
sincedb_path=> "dev/null"
}
}
filter {
csv {
separator => ","
columns => ["NAME","PHONE","LAT","LONG"]
}
mutate {
convert => { "LAT" => "float" }
convert => { "LONG" => "float" }
}
mutate {
rename => {
"LAT" => "[location][lon]"
"LONG" => "[location][lat]"
}
}
mutate {
add_field => [ "[location][coordinates]", "%{[location][lon]}" ]
add_field => [ "[location][coordinates]", "%{[location][lat]}" ]
}
}
Following values I can see in Kibana:
Is there any thing else needs to be done. When I create visualization , it just show map no coordinates on it. Kindly guide.
Thanks,