# Unable to load lat and lon values in map view
**URL:** https://discuss.elastic.co/t/unable-to-load-lat-and-lon-values-in-map-view/106117
**Category:** Logstash
**Created:** [November 2, 2017, 3:58am UTC](https://discuss.elastic.co/t/unable-to-load-lat-and-lon-values-in-map-view/106117 "2017-11-02T03:58:09Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@arun\_s](https://discuss.elastic.co/u/arun_s)
#### Post date: [November 2, 2017, 3:58am UTC](https://discuss.elastic.co/t/unable-to-load-lat-and-lon-values-in-map-view/106117/1 "2017-11-02T03:58:10Z")
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 columns and values as below
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
---
### Author:  [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)
#### Post date: [November 2, 2017, 8:28am UTC](https://discuss.elastic.co/t/unable-to-load-lat-and-lon-values-in-map-view/106117/2 "2017-11-02T08:28:10Z")
In Logstash's default index template the `[geoip][location]` field is mapped a geo\_point field, but because you're naming your index geo4-point instead of something that matches logstash-\* you won't get that mapping. Either change your index name or upload an index template that matches the indexes you're going to have.
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [November 2, 2017, 8:29am UTC](https://discuss.elastic.co/t/unable-to-load-lat-and-lon-values-in-map-view/106117/3 "2017-11-02T08:29:39Z")
[https://www.elastic.co/blog/geoip-in-the-elastic-stack](https://www.elastic.co/blog/geoip-in-the-elastic-stack) has more on this problemn.
---
### Author:  [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)
#### Post date: [November 2, 2017, 8:33am UTC](https://discuss.elastic.co/t/unable-to-load-lat-and-lon-values-in-map-view/106117/4 "2017-11-02T08:33:10Z")
Ah, that was the blog post I was looking for.
---
### Author:  [@arun\_s](https://discuss.elastic.co/u/arun_s)
#### Post date: [November 2, 2017, 10:52am UTC](https://discuss.elastic.co/t/unable-to-load-lat-and-lon-values-in-map-view/106117/5 "2017-11-02T10:52:01Z")
Thanks magnusbaeck
i tried changing like this
output {
elasticsearch {
hosts =\> "[http://localhost:9200](http://localhost:9200)"
index =\> 'testcormap-index'
```
}
stdout{}
```
}
but even facing the same error
No Compatible Fields: The "testcormap-\*" index pattern does not contain any of the following field types: geo\_point
---
### Author:  [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)
#### Post date: [November 2, 2017, 11:14am UTC](https://discuss.elastic.co/t/unable-to-load-lat-and-lon-values-in-map-view/106117/6 "2017-11-02T11:14:38Z")
testcormap-index also doesn't match the logstash-\* pattern.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [November 30, 2017, 11:14am UTC](https://discuss.elastic.co/t/unable-to-load-lat-and-lon-values-in-map-view/106117/7 "2017-11-30T11:14:52Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.