Kibana Map Visualization with Lat Long fields

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:

image

Is there any thing else needs to be done. When I create visualization , it just show map no coordinates on it. Kindly guide.

Thanks,

Did you setup a template or mapping to make sure the location.coordinates field is a geopoint?

https://www.elastic.co/blog/geoip-in-the-elastic-stack has some info on that.

Hi Mark,

No I did not setup any template for this. How can we setup that? I have shown my configuration above .

Thanks,

That blog post provides guidance, let us know if you have specific questions though!

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