# How to modified configure logstash add geo\_point and load data with logstash to elasticsearch
**URL:** https://discuss.elastic.co/t/how-to-modified-configure-logstash-add-geo-point-and-load-data-with-logstash-to-elasticsearch/271984
**Category:** Logstash
**Created:** [May 3, 2021, 1:05pm UTC](https://discuss.elastic.co/t/how-to-modified-configure-logstash-add-geo-point-and-load-data-with-logstash-to-elasticsearch/271984 "2021-05-03T13:05:19Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@Rizky\_Hudha](https://discuss.elastic.co/u/Rizky_Hudha)
#### Post date: [May 3, 2021, 1:05pm UTC](https://discuss.elastic.co/t/how-to-modified-configure-logstash-add-geo-point-and-load-data-with-logstash-to-elasticsearch/271984/1 "2021-05-03T13:05:19Z")
I have a column device.latlong where the longtitude and latitude values become one column, how to add a geo\_point file to the logstash configuration, and display it in the kibana visualization
and this my configure api.conf
> input {
> file {
> path =\> "/home/mynameis/Documents/project/device.csv"
> start\_position =\> "beginning"
> sincedb\_path =\> "/dev/null"
> }
> }
> filter {
> csv {
> separator =\> ","
> skip\_header =\> "true"
> columns =\> ["response.\_passed","response.timestamp","response.verbose","response.verbose.gestureSetBin",
> "response.verbose.gestureSetNames.Stage\_0", "response.verbose.gestureSetNames.Stage\_1",
> "response.verbose.gestureSetResults.stage\_0","response.verbose.gestureSetResults.stage\_1",
> "response.verbose.landmarkCoordinates","response.verbose.left\_eye\_ar\_array","response.verbose.mouth\_arr\_array",
> "response.verbose.right\_eye\_ar\_array","device.apiLevel","device.name","device.brand","device.buildNumber","device.carrier",
> "device.deviceCountry","device.deviceId","device.manufacturer","device.phoneNumber","device.serialNumber","device.uniqueId",
> "device.osBuildId","device.userAgent","device.macAddress.\_55","device.model","device.systemName","device.systemVersion",
> "device.totalDiskCapacity","device.totalMemory","device.version","device.hasNotch","device.deviceType","device.timezone",
> "device.locale","device.readableVersion","device.lastUpdateTime","device.freeDiskStorage","device.fontScale",
> "device.latlong","device.imei","device.ipaddress","device.macaddress"]
> }
> mutate{
> convert =\> {"device.latlong" =\> "float"}
> add\_field =\> ["location", "%{device.latlong}"]
> }
> }
> output {
> elasticsearch {
> hosts =\> "[http://localhost:9200](http://localhost:9200)"
> index =\> "api\_response\_and\_device\_information"
> }
> stdout {}
---
### Author:  [@Badger](https://discuss.elastic.co/u/Badger)
#### Post date: [May 3, 2021, 3:10pm UTC](https://discuss.elastic.co/t/how-to-modified-configure-logstash-add-geo-point-and-load-data-with-logstash-to-elasticsearch/271984/2 "2021-05-03T15:10:03Z")
You need a [template](https://www.elastic.co/guide/en/elasticsearch/reference/current/index-templates.html) to tell elasticsearch that a fields is a geo\_point. The [default](https://github.com/logstash-plugins/logstash-output-elasticsearch/blob/master/lib/logstash/outputs/elasticsearch/templates/ecs-disabled/elasticsearch-7x.json) template includes an example of how to do so.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [May 31, 2021, 3:10pm UTC](https://discuss.elastic.co/t/how-to-modified-configure-logstash-add-geo-point-and-load-data-with-logstash-to-elasticsearch/271984/3 "2021-05-31T15:10:08Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.