# Help needed in loading map using lat and lon value

**URL:** https://discuss.elastic.co/t/help-needed-in-loading-map-using-lat-and-lon-value/106070
**Category:** Kibana
**Created:** [November 1, 2017, 5:22pm UTC](https://discuss.elastic.co/t/help-needed-in-loading-map-using-lat-and-lon-value/106070 "2017-11-01T17:22:44Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![arun\_s](https://avatars.discourse-cdn.com/v4/letter/a/e9a140/32.png) [@arun\_s](https://discuss.elastic.co/u/arun_s)
#### Post date: [November 1, 2017, 5:22pm UTC](https://discuss.elastic.co/t/help-needed-in-loading-map-using-lat-and-lon-value/106070/1 "2017-11-01T17:22:45Z")

</div>

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](http://localhost:9200)"  
index =\> 'geo4-point'

```
}
stdout{}

```

}

can someone help me to load this coordinates in map

---

<div class="post-metadata">

### Author: ![rashmi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rashmi/32/16391_2.png) [@rashmi](https://discuss.elastic.co/u/rashmi)
#### Post date: [November 1, 2017, 7:25pm UTC](https://discuss.elastic.co/t/help-needed-in-loading-map-using-lat-and-lon-value/106070/2 "2017-11-01T19:25:28Z")

</div>

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 :

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

```

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

thanks  
Rashmi

---

<div class="post-metadata">

### Author: ![arun\_s](https://avatars.discourse-cdn.com/v4/letter/a/e9a140/32.png) [@arun\_s](https://discuss.elastic.co/u/arun_s)
#### Post date: [November 2, 2017, 3:28am UTC](https://discuss.elastic.co/t/help-needed-in-loading-map-using-lat-and-lon-value/106070/3 "2017-11-02T03:28:02Z")

</div>

Thanks rashmi will post in logstash forum

---

<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: [November 30, 2017, 3:28am UTC](https://discuss.elastic.co/t/help-needed-in-loading-map-using-lat-and-lon-value/106070/4 "2017-11-30T03:28:14Z")

</div>

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