# How to create geo point from separate lat, lon fields in csv

**URL:** <https://community.siren.io/t/how-to-create-geo-point-from-separate-lat-lon-fields-in-csv/377>\
**Category:** Siren Platform/Investigate Tech Support Community\
**Created:** [April 21, 2021, 6:08pm UTC](https://community.siren.io/t/how-to-create-geo-point-from-separate-lat-lon-fields-in-csv/377 "2021-04-21T18:08:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![dmwpepper](https://avatars.discourse-cdn.com/v4/letter/d/ce73a5/32.png) [@dmwpepper](https://community.siren.io/u/dmwpepper)\
**Post date:** [April 21, 2021, 6:08pm UTC](https://community.siren.io/t/how-to-create-geo-point-from-separate-lat-lon-fields-in-csv/377/1 "2021-04-21T18:08:00Z")

</div>

Hello,  
I have a csv file that has two separate fields for lat and lon fields. How do I specify when imported that the lat and lon fields should together be treated as a geopoint? Or do I have to create a mapping first and use that as an index template, or something like that?  
Thanks

---

<div class="post-metadata">

**Author:** ![Manu\_Agarwal](https://yyz2.discourse-cdn.com/flex032/user_avatar/community.siren.io/manu_agarwal/32/120_2.png) [@Manu\_Agarwal](https://community.siren.io/u/Manu_Agarwal)\
**Post date:** [April 21, 2021, 7:26pm UTC](https://community.siren.io/t/how-to-create-geo-point-from-separate-lat-lon-fields-in-csv/377/2 "2021-04-21T19:26:59Z")

</div>

Hello Dave,

You need to merge two field to create a geo\_point.

Merge two fields providing ‘latitude’ and ‘longitude’ to create a single Elasticsearch **geo\_point** field using the pipeline processor at the time of importing a csv:

```
{
 "description": "Create geo point field",
 "processors": [
     {
      "drop": {
        "if": "ctx.latitude_field == null || ctx.longitude_field == null"
      }
    },
   {
     "set": {
       "field": "geo_location",
       "value": {
           "lat": "{{latitude_field}}",
           "lon": "{{longitude_field}}"
       }
     }
   }
 ]
}

```

The documentation is [available here](https://docs.siren.io/siren-platform-user-guide/11.1/siren-investigate/data-import.html).

Regards  
Manu