# How can I generate lat long fields into geo point in elasticsearch
**URL:** https://discuss.elastic.co/t/how-can-i-generate-lat-long-fields-into-geo-point-in-elasticsearch/312329
**Category:** Elasticsearch
**Tags:** painless
**Created:** [August 18, 2022, 12:15am UTC](https://discuss.elastic.co/t/how-can-i-generate-lat-long-fields-into-geo-point-in-elasticsearch/312329 "2022-08-18T00:15:39Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@paris1](https://discuss.elastic.co/u/paris1)
#### Post date: [August 18, 2022, 12:15am UTC](https://discuss.elastic.co/t/how-can-i-generate-lat-long-fields-into-geo-point-in-elasticsearch/312329/1 "2022-08-18T00:15:39Z")
0
I've ingested CSV data via pgsync from postgres RDS to elasticsearch.my index contains "lat" and "lng"
```auto
"lat" : {
"type" : "float"
},
"lng" : {
"type" : "float"
```
How would I convert this into an acceptable geopoint format so that I can map it in Kibana?
I already add this mapping:
````auto
``` PUT /my-index/_mapping
{
"properties": {
"location": {
"type": "geo_point"
}
}
}```
````
but when I'm trying to generate new coordinate field via:
````auto
``` POST your_index/_update_by_query
{
"script": {
"inline": "ctx._source.location = ctx._source.lat, ctx._source.lon",
"lang": "painless"
},
"query": {
"match_all": {}
}
}```
I am unable and getting this error
'''
{
"error" : {
"root_cause" : [
{
"type" : "script_exception",
"reason" : "compile error",
"script_stack" : [
"... ocation = ctx._source.lat, ctx._source.lng",
" ^---- HERE"
],
"script" : "ctx._source.location = ctx._source.lat, ctx._source.lng",
"lang" : "painless",
"position" : {
"offset" : 38,
"start" : 13,
"end" : 55
}
}
'''
````
Is there any suggestion or correction for this?
---
### Author:  [@stephenb](https://discuss.elastic.co/u/stephenb)
#### Post date: [August 18, 2022, 1:32am UTC](https://discuss.elastic.co/t/how-can-i-generate-lat-long-fields-into-geo-point-in-elasticsearch/312329/2 "2022-08-18T01:32:32Z")
Careful with your `lat` and `lon` / `lng` and make sure you get the coordinates in the correct order see [here](https://www.elastic.co/guide/en/elasticsearch/reference/current/geo-point.html)
```auto
DELETE discuss-location-index
PUT discuss-location-index
{
"mappings": {
"properties": {
"lat": {
"type": "float"
},
"lon": {
"type": "float"
},
"location": {
"type": "geo_point"
}
}
}
}
POST discuss-location-index/_doc
{
"lat" : 10.0,
"lon" : 11.0
}
POST discuss-location-index/_update_by_query
{
"script": {
"source": "ctx._source.location = [ctx._source.lon, ctx._source.lat]",
"lang": "painless"
},
"query": {
"match_all": {}
}
}
# Search
GET discuss-location-index/_search
{
"fields": [
"*"
]
}
# Result
{
"took" : 0,
"timed_out" : false,
"_shards" : {
"total" : 1,
"successful" : 1,
"skipped" : 0,
"failed" : 0
},
"hits" : {
"total" : {
"value" : 1,
"relation" : "eq"
},
"max_score" : 1.0,
"hits" : [
{
"_index" : "discuss-location-index",
"_id" : "ypmVroIBJQ-PaY-rMcqk",
"_score" : 1.0,
"_source" : {
"lon" : 11.0,
"location" : [
11.0,
10.0
],
"lat" : 10.0
},
"fields" : {
"lon" : [
11.0
],
"location" : [
{
"coordinates" : [
11.0,
10.0
],
"type" : "Point"
}
],
"lat" : [
10.0
]
}
}
]
}
}
```
---
### Author:  [@paris1](https://discuss.elastic.co/u/paris1)
#### Post date: [August 18, 2022, 4:10am UTC](https://discuss.elastic.co/t/how-can-i-generate-lat-long-fields-into-geo-point-in-elasticsearch/312329/3 "2022-08-18T04:10:00Z")
Thank you Stephan,the problem is that I want to do bulk uploading from my DB to elasticsearch via pgsync.Do you have any suggestion for this?
---
### Author:  [@stephenb](https://discuss.elastic.co/u/stephenb)
#### Post date: [August 18, 2022, 4:17am UTC](https://discuss.elastic.co/t/how-can-i-generate-lat-long-fields-into-geo-point-in-elasticsearch/312329/4 "2022-08-18T04:17:42Z")
Yes I was thinking that.. but you asked about a painless script so that is the answer you got 🙂 That painless script will update all the documents...
Perhaps look at this thread... the last couple posts (It is a bit long... but the OP is loading Geo Data from Postgres using Logstash)
Last Couple Posts..
> [@Layer dot found result](https://discuss.elastic.co/t/layer-dot-found-result/312028/27):
>
> sorry @stephenb at the beginning I created my mapping as follows: PUT jeudi { "mappings": { "properties": { "id": { "type": "text", "fields": { "keyword": { "type": "keyword", "ignore\_above": 256 } } }, "location": { "type": "geo\_point" }, "nom": { "type": "text", "fields": { "keyword": { "type": "keyword", "ignore\_above": 256 …
I do not know `pgsync`... but in the end you just need to put the lat / lon in the right fields... I would think you would be able to do that... I just not familiar with the tool
Looks to me like you will need to use the transform node rename logic to [rename](https://pgsync.com/tutorial/transform-nodes/#rename) your source fields to the correct fields..
---
### Author:  [@paris1](https://discuss.elastic.co/u/paris1)
#### Post date: [August 19, 2022, 6:06pm UTC](https://discuss.elastic.co/t/how-can-i-generate-lat-long-fields-into-geo-point-in-elasticsearch/312329/5 "2022-08-19T18:06:56Z")
got it.Thanks a lot
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [September 16, 2022, 6:07pm UTC](https://discuss.elastic.co/t/how-can-i-generate-lat-long-fields-into-geo-point-in-elasticsearch/312329/6 "2022-09-16T18:07:29Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.