# Geo code in logstash
**URL:** https://discuss.elastic.co/t/geo-code-in-logstash/92609
**Category:** Logstash
**Created:** [July 11, 2017, 9:01am UTC](https://discuss.elastic.co/t/geo-code-in-logstash/92609 "2017-07-11T09:01:59Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@DILIP\_SHARMA](https://discuss.elastic.co/u/DILIP_SHARMA)
#### Post date: [July 11, 2017, 9:01am UTC](https://discuss.elastic.co/t/geo-code-in-logstash/92609/1 "2017-07-11T09:01:59Z")
Hi i am trying to load geo data to elasticsearch using logstash ,
my .csv file look like this -
```
"col1","col2","col3","col4","col5"
"dilip","2017-05-28","45.5","12.56789,72.23456","43"
```
my .config file look like this -
```
input {
file {
path => "/home/dilip/Downloads/data/try1.csv"
start_position => "beginning"
sincedb_path => "/dev/null"
}
}
filter {
csv {
separator => ","
columns => ["col1","col2","col3","col4","col5"]
}
mutate {convert =>["col3" , "float"]}
mutate {convert =>["col5" , "integer"]}
mutate {convert =>["col4" , "geo_point"]}
date { match => ["col2", "[yyyy-mm-dd HH:mm:ss:SSS]"]}
}
output {
elasticsearch {
hosts => "localhost"
index => "try_index3"
document_type => "trydata2"
}
stdout{}
}
```
but logstash creating pipeline and closing it . any suggestion how can i define geo code data .
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [July 11, 2017, 9:12am UTC](https://discuss.elastic.co/t/geo-code-in-logstash/92609/2 "2017-07-11T09:12:26Z")
> [@DILIP\_SHARMA](#):
>
> mutate {convert =\>["col4" , "geo\_point"]}
That is not valid.
You need to join the lat and lon fields into a single one.
> [@DILIP\_SHARMA](#):
>
> columns =\> ["col1","col2","col3","col4","col5"]
It'd be easier to give them human readable names 🙂
---
### Author:  [@DILIP\_SHARMA](https://discuss.elastic.co/u/DILIP_SHARMA)
#### Post date: [July 11, 2017, 9:15am UTC](https://discuss.elastic.co/t/geo-code-in-logstash/92609/3 "2017-07-11T09:15:15Z")
i just created test file thats why given name like this .
i already joined both in col4 column if you look my data "12.56789,72.23456"
is there anything else i need to do ?
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [July 11, 2017, 9:15am UTC](https://discuss.elastic.co/t/geo-code-in-logstash/92609/4 "2017-07-11T09:15:43Z")
Make sure you have a template/mapping that sets the field to a `geo_point` in Elasticsearch.
---
### Author:  [@DILIP\_SHARMA](https://discuss.elastic.co/u/DILIP_SHARMA)
#### Post date: [July 11, 2017, 9:28am UTC](https://discuss.elastic.co/t/geo-code-in-logstash/92609/5 "2017-07-11T09:28:47Z")
sorry not sure , you are talking about this ??
{
"mappings": {
"my\_type": {
"properties": {
"location": {
"type": "geo\_point"
}
}
}
}
}
where i need to set this ?
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [July 11, 2017, 9:39am UTC](https://discuss.elastic.co/t/geo-code-in-logstash/92609/6 "2017-07-11T09:39:12Z")
Yes, that needs to live in Elasticsearch against the index.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [August 8, 2017, 9:39am UTC](https://discuss.elastic.co/t/geo-code-in-logstash/92609/7 "2017-08-08T09:39:38Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.