# Geo\_point in logstash **URL:** \ **Category:** Logstash\ **Created:** [September 21, 2017, 4:43pm UTC](https://discuss.elastic.co/t/geo-point-in-logstash/101373 "2017-09-21T16:43:30Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![DILIP\_SHARMA](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dilip_sharma/32/42672_2.png) [@DILIP\_SHARMA](https://discuss.elastic.co/u/DILIP_SHARMA)\ **Post date:** [September 21, 2017, 4:43pm UTC](https://discuss.elastic.co/t/geo-point-in-logstash/101373/1 "2017-09-21T16:43:30Z")
hello , currently to define any field as geo\_point i using following command in kibana dev tool - ``` PUT t5 { "mappings": { "dataa": { "properties": { "G": { "type": "geo_point" } } } } } ``` But i need to define this for every index . Now i am creating index for everyday . my sample .csv ``` A,B,C,D,E,F,G A1,2017/09/16 00:00:00,3U0604,2017/09/16 19:30:00,2017/09/16 19:30:00,1,"26,54" A2,2017/09/16 00:00:00,3U0604,2017/09/16 00:00:00,2017/09/16 19:30:00,2,"27,54" ``` and my config file - ``` input { file { path => "E:\Local_Elasticsearch\logstashv5\everydaylog/*.csv" start_position => "beginning" } } filter { csv { separator => "," columns => ["A","B","C","D","E","F","G"] } mutate {convert =>["F" , "integer"]} date { match => ["B", "ISO8601", "YYYY-MM-dd HH:mm:ss"] target => "B" locale => "en" } date { match => ["D", "ISO8601", "YYYY-MM-dd HH:mm:ss"] target => "D" locale => "en" } date { match => ["E", "ISO8601", "YYYY-MM-dd HH:mm:ss"] target => "E" locale => "en" } } output { elasticsearch { hosts => "localhost" index => "testindex-%{+YYYYMMdd}" } stdout{} } ``` in this case how can i define field "G" as geo\_point for every day data file automatically . thanks ---
**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:** [September 22, 2017, 12:33am UTC](https://discuss.elastic.co/t/geo-point-in-logstash/101373/2 "2017-09-22T00:33:44Z")
> [@DILIP\_SHARMA](#): > > But i need to define this for every index . > > Now i am creating index for everyday . > > in this case how can i define field "G" as geo\_point for every day data file automatically . Create a template 🙂 [GeoIP in the Elastic Stack - Elasticsearch, Logstash, Ingest API | Elastic Blog](https://www.elastic.co/blog/geoip-in-the-elastic-stack) has some guidance on this, in particular the _Custom Index Names_ section. But let us know if you get stuck! ---
**Author:** ![DILIP\_SHARMA](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dilip_sharma/32/42672_2.png) [@DILIP\_SHARMA](https://discuss.elastic.co/u/DILIP_SHARMA)\ **Post date:** [September 24, 2017, 1:18pm UTC](https://discuss.elastic.co/t/geo-point-in-logstash/101373/3 "2017-09-24T13:18:06Z")
hi i not able to make field data type as geo\_point from log stash config file , form one of thread i tried change elasticsearch json template also , i have 3 json file - elasticsearch-template-es2x elasticsearch-template-es5x elasticsearch-template-es6x this is updated template file part - ``` "properties" : { "@timestamp": { "type": "date", "include_in_all": false }, "@version": { "type": "keyword", "include_in_all": false }, "geoip" : { "dynamic": true, "properties" : { "ip": { "type": "ip" }, "location" : { "type" : "geo_point" }, "latitude" : { "type" : "half_float" }, "longitude" : { "type" : "half_float" } } }, "location" : { "latlong" : "geo_point" } } ``` but still value as string in kibana . my data file - ``` dilip,30,"34,3" d2,31,"35,3" d4,32,"44,3" d5,35,"34,23" ``` and config file - ``` input { file { path => "E:\Local_Elasticsearch\logstashv5\latllongtest/*.csv" start_position => "beginning" sincedb_path => "/dev/null" } } filter { csv { separator => "," columns => ["name","amount","latlong"] } mutate {convert =>[amount , "integer"]} } output { elasticsearch { hosts => "localhost" index => "lattest2" } stdout{} } ``` ---
**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\ **Post date:** [September 24, 2017, 8:49pm UTC](https://discuss.elastic.co/t/geo-point-in-logstash/101373/4 "2017-09-24T20:49:47Z")
What does your full template look like? Did you create a new index? What does an example document from that index look like? What do the actual mappings of that index look like? ---
**Author:** ![DILIP\_SHARMA](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dilip_sharma/32/42672_2.png) [@DILIP\_SHARMA](https://discuss.elastic.co/u/DILIP_SHARMA)\ **Post date:** [September 25, 2017, 4:35am UTC](https://discuss.elastic.co/t/geo-point-in-logstash/101373/5 "2017-09-25T04:35:45Z")
hi i able to do this - ``` PUT /_template/templlatlong { "order": 0, "template": "*", "settings": {}, "mappings": { "_default_": { "properties": { "latlong": { "type": "geo_point" } } } } } ``` this will create latlong column as geo point at time of index creation . thanks . ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [October 23, 2017, 4:37am UTC](https://discuss.elastic.co/t/geo-point-in-logstash/101373/6 "2017-10-23T04:37:09Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.