# Need help in importing location data to ES **URL:** \ **Category:** Elasticsearch\ **Created:** [February 24, 2018, 5:03pm UTC](https://discuss.elastic.co/t/need-help-in-importing-location-data-to-es/121342 "2018-02-24T17:03:36Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Prakash\_Punj](https://avatars.discourse-cdn.com/v4/letter/p/4bbf92/32.png) [@Prakash\_Punj](https://discuss.elastic.co/u/Prakash_Punj)\ **Post date:** [February 24, 2018, 5:03pm UTC](https://discuss.elastic.co/t/need-help-in-importing-location-data-to-es/121342/1 "2018-02-24T17:03:36Z")
Folks, I am quite new to this and trying to understand fundamentals of importing location data to ES using logstash. Below are the specification: a.) I have a CSV file with bunch of columns, one of which is location which has latitude and longitude (lat, -log) format. b.) As I understand by default ES ingest the data using string but you can use "convert" to convert that to integer, float BUT you can simple cannot use convert to geo\_point, right After reading multiple posts I think I need to do a 4 step process: a.) create an index in Kibana (dev tools), PUT b.) Create a mapping field say location of type geo\_point c.) use logstash to ingest the data d.) Data is in CSV format. When I ingest using logstash and define other columns, are they going to be mapped to the same index. I tried that but not successful. Is there a simple step by step instruction with samle data set, logstash configuration etc. That would really be helpful. Want an expert to write an article with the complete things.. Thanks ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [February 24, 2018, 6:41pm UTC](https://discuss.elastic.co/t/need-help-in-importing-location-data-to-es/121342/2 "2018-02-24T18:41:55Z")
Some ideas. With logstash - [http://david.pilato.fr/blog/2015/04/28/exploring-capitaine-train-dataset/](http://david.pilato.fr/blog/2015/04/28/exploring-capitaine-train-dataset/) Without logstash: - [http://david.pilato.fr/blog/2017/01/09/4-years-at-elastic/](http://david.pilato.fr/blog/2017/01/09/4-years-at-elastic/) - [http://david.pilato.fr/blog/2018/01/10/5-years-what-a-milestone/](http://david.pilato.fr/blog/2018/01/10/5-years-what-a-milestone/) HTH ---
**Author:** ![Prakash\_Punj](https://avatars.discourse-cdn.com/v4/letter/p/4bbf92/32.png) [@Prakash\_Punj](https://discuss.elastic.co/u/Prakash_Punj)\ **Post date:** [March 9, 2018, 1:54am UTC](https://discuss.elastic.co/t/need-help-in-importing-location-data-to-es/121342/3 "2018-03-09T01:54:20Z")
Thank you so much @dadoonet. I followed your step with logstash and manage to upload data to elastic search and I also see that field location got created with data type "Geo-point" but when I try to create visualization it says no field with geo-point found. I also don't see the location field when try to get the field information from Kibana (Get /index) ``` { "chicago_crime-1": { "aliases": {}, "mappings": { "doc": { "properties": { "@timestamp": { "type": "date" }, "@version": { "type": "text", "fields": { "keyword": { "type": "keyword", "ignore_above": 256 } } }, "arrest": { "type": "text", "fields": { "keyword": { "type": "keyword", "ignore_above": 256 } } }, "block": { "type": "text", "fields": { "keyword": { "type": "keyword", "ignore_above": 256 } } }, "case number": { "type": "text", "fields": { "keyword": { "type": "keyword", "ignore_above": 256 } } }, "community area": { "type": "text", "fields": { "keyword": { "type": "keyword", "ignore_above": 256 } } }, "date": { "type": "date" }, "description": { "type": "text", "fields": { "keyword": { "type": "keyword", "ignore_above": 256 } } }, "district": { "type": "text", "fields": { "keyword": { "type": "keyword", "ignore_above": 256 } } }, "domestic": { "type": "text", "fields": { "keyword": { "type": "keyword", "ignore_above": 256 } } }, "host": { "type": "text", "fields": { "keyword": { "type": "keyword", "ignore_above": 256 } } }, "id": { "type": "text", "fields": { "keyword": { "type": "keyword", "ignore_above": 256 } } }, "iucr": { "type": "text", "fields": { "keyword": { "type": "keyword", "ignore_above": 256 } } }, "location": { "properties": { "lat": { "type": "float" }, "lon": { "type": "float" } } }, "location-description": { "type": "text", "fields": { "keyword": { "type": "keyword", "ignore_above": 256 } } }, "message": { "type": "text", "fields": { "keyword": { "type": "keyword", "ignore_above": 256 } } }, "path": { "type": "text", "fields": { "keyword": { "type": "keyword", "ignore_above": 256 } } }, "primary type": { "type": "text", "fields": { "keyword": { "type": "keyword", "ignore_above": 256 } } }, "ward": { "type": "text", "fields": { "keyword": { "type": "keyword", "ignore_above": 256 } } }, "year": { "type": "text", "fields": { "keyword": { "type": "keyword", "ignore_above": 256 } } } } } }, "settings": { "index": { "creation_date": "1520548053306", "number_of_shards": "5", "number_of_replicas": "1", "uuid": "47wanPrwTP-2yKkcOLwKQA", "version": { "created": "6010199" }, "provided_name": "chicago_crime-1" } } } } ``` CONF FILE: ``` input { file { path => "/home/ppunj/chicago-crime.csv" start_position => 'beginning' sincedb_path => '/dev/null' } } filter { csv { separator => "," columns => ["id","case number","date","block","iucr","primary type","description","location-description","arrest","domestic","district","ward","community area","year","latitude","longitude"] } date { match => ["date", "MM/dd/yyyy HH:mm"] target => "date" locale => "en" } mutate { convert => ["latitude", "float"] convert => ["longitude", "float"] } mutate { rename => { "latitude" => "[location][lat]" "longitude" => "[location][lon]" } } } output { elasticsearch { hosts => "http://localhost:9200" index => "chicago_crime-1" } stdout {} } ``` ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [March 9, 2018, 2:42am UTC](https://discuss.elastic.co/t/need-help-in-importing-location-data-to-es/121342/4 "2018-03-09T02:42:50Z")
You need to change the mapping for location to become a geo\_point type. And reindex ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [April 6, 2018, 2:43am UTC](https://discuss.elastic.co/t/need-help-in-importing-location-data-to-es/121342/5 "2018-04-06T02:43:18Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.