# Mapping

**URL:** <https://discuss.elastic.co/t/mapping/46927>\
**Category:** Kibana\
**Created:** [April 11, 2016, 12:38am UTC](https://discuss.elastic.co/t/mapping/46927 "2016-04-11T00:38:28Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lucky](https://avatars.discourse-cdn.com/v4/letter/l/e9c0ed/32.png) [@Lucky](https://discuss.elastic.co/u/Lucky)\
**Post date:** [April 11, 2016, 12:38am UTC](https://discuss.elastic.co/t/mapping/46927/1 "2016-04-11T00:38:28Z")

</div>

My logstash file,  
filter {  
csv {  
columns =\> [  
"status",  
"country",  
"state",  
"city"  
]  
separator =\> ","  
}

}  
And I am mapping by using geo\_point data field,

"mappings" : {  
"_default_" : {  
"properties" : {  
"geohashlocation": {  
"geohash": true,  
"type": "geo\_point",  
"geohash\_prefix": true },  
"status" : {"type": "string", "index" : "not\_analyzed" },  
"country" : {"type": "geo\_point"},  
"state" : {"type": "geo\_point"},  
"city" : {"type": "geo\_point"}

---

<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:** [April 11, 2016, 12:44am UTC](https://discuss.elastic.co/t/mapping/46927/2 "2016-04-11T00:44:36Z")

</div>

That is a terrible subject, please update it to something more descriptive.  
Also that screenshot is also very hard to read, it'd be better if you pasted the text instead.

And please provide a sample of the data so we can see what you are trying to parse.

---

<div class="post-metadata">

**Author:** ![Lucky](https://avatars.discourse-cdn.com/v4/letter/l/e9c0ed/32.png) [@Lucky](https://discuss.elastic.co/u/Lucky)\
**Post date:** [April 11, 2016, 12:56am UTC](https://discuss.elastic.co/t/mapping/46927/3 "2016-04-11T00:56:46Z")

</div>

I am Sorry.

Actually i am trying to load a csv file which have fields country, state, city. so i created a logstash config file which is,  
filter {  
csv {  
columns =\> [  
"status",  
"country",  
"state",  
"city"  
]  
separator =\> ","  
}  
And i created my index by mapping these fields by geo\_point data type my mapping looks like,  
"mappings" : {  
"default" : {  
"properties" : {  
"geohashlocation": {  
"geohash": true,  
"type": "geo\_point",  
"geohash\_prefix": true },  
"status" : {"type": "string", "index" : "not\_analyzed" },  
"country" : {"type": "geo\_point"},  
"state" : {"type": "geo\_point"},  
"city" : {"type": "geo\_point"}

When I run my conf file i am getting the error "reason failed to parse"

---

<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:** [April 11, 2016, 1:57am UTC](https://discuss.elastic.co/t/mapping/46927/4 "2016-04-11T01:57:37Z")

</div>

I got that, you need to provide a sample of the data so we can see what is happening.

---

<div class="post-metadata">

**Author:** ![Lucky](https://avatars.discourse-cdn.com/v4/letter/l/e9c0ed/32.png) [@Lucky](https://discuss.elastic.co/u/Lucky)\
**Post date:** [April 11, 2016, 2:32am UTC](https://discuss.elastic.co/t/mapping/46927/5 "2016-04-11T02:32:56Z")

</div>

My data looks like,

status,country,state,city  
Ongoing,US,WA,Vancouver  
Ongoing,US,NC,Raleigh  
Ongoing,US,MO,Saint Louis

---

<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:** [April 11, 2016, 2:54am UTC](https://discuss.elastic.co/t/mapping/46927/6 "2016-04-11T02:54:27Z")

</div>

That's not a valid data set to be putting into a geo\_point, it expects a literal latitude and longitude numerical data.

---

<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:** [July 6, 2017, 1:56pm UTC](https://discuss.elastic.co/t/mapping/46927/7 "2017-07-06T13:56:27Z")

</div>

Closed on July 6, 2017, 1:56pm UTC