# Kibana Map Visualization with Lat Long fields

**URL:** https://discuss.elastic.co/t/kibana-map-visualization-with-lat-long-fields/106762
**Category:** Logstash
**Created:** [November 7, 2017, 10:34pm UTC](https://discuss.elastic.co/t/kibana-map-visualization-with-lat-long-fields/106762 "2017-11-07T22:34:07Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![shashwat](https://avatars.discourse-cdn.com/v4/letter/s/bbe5ce/32.png) [@shashwat](https://discuss.elastic.co/u/shashwat)
#### Post date: [November 7, 2017, 10:34pm UTC](https://discuss.elastic.co/t/kibana-map-visualization-with-lat-long-fields/106762/1 "2017-11-07T22:34:07Z")

</div>

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](https://us1.discourse-cdn.com/elastic/original/3X/7/8/78d0347448dc7f106aed787d82abff2939bba4ee.png)

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

Thanks,

---

<div class="post-metadata">

### Author: ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [November 7, 2017, 11:22pm UTC](https://discuss.elastic.co/t/kibana-map-visualization-with-lat-long-fields/106762/2 "2017-11-07T23:22:53Z")

</div>

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](https://www.elastic.co/blog/geoip-in-the-elastic-stack) has some info on that.

---

<div class="post-metadata">

### Author: ![shashwat](https://avatars.discourse-cdn.com/v4/letter/s/bbe5ce/32.png) [@shashwat](https://discuss.elastic.co/u/shashwat)
#### Post date: [November 7, 2017, 11:36pm UTC](https://discuss.elastic.co/t/kibana-map-visualization-with-lat-long-fields/106762/3 "2017-11-07T23:36:51Z")

</div>

Hi Mark,

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

Thanks,

---

<div class="post-metadata">

### Author: ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [November 7, 2017, 11:47pm UTC](https://discuss.elastic.co/t/kibana-map-visualization-with-lat-long-fields/106762/4 "2017-11-07T23:47:40Z")

</div>

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

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [December 5, 2017, 11:48pm UTC](https://discuss.elastic.co/t/kibana-map-visualization-with-lat-long-fields/106762/5 "2017-12-05T23:48:00Z")

</div>

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