# I want to take Lat Long from MYSQL database and map as geopoint in elasticsearch index

**URL:** <https://discuss.elastic.co/t/i-want-to-take-lat-long-from-mysql-database-and-map-as-geopoint-in-elasticsearch-index/194060>\
**Category:** Logstash\
**Created:** [August 6, 2019, 4:34pm UTC](https://discuss.elastic.co/t/i-want-to-take-lat-long-from-mysql-database-and-map-as-geopoint-in-elasticsearch-index/194060 "2019-08-06T16:34:06Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\
**Post date:** [August 6, 2019, 4:47pm UTC](https://discuss.elastic.co/t/i-want-to-take-lat-long-from-mysql-database-and-map-as-geopoint-in-elasticsearch-index/194060/2 "2019-08-06T16:47:33Z")

</div>

> [@Sandeep\_Bind](#):
>
> concat(t4.latitude,',',t4.longitude) as location

So what do you end up with in the location field?

You are going to need a [mapping](https://www.elastic.co/guide/en/elasticsearch/reference/current/indices-put-mapping.html). [This](https://discuss.elastic.co/t/elk-and-mysql-geopoint/192888) thread might help but I have not tested what I suggested there.

---

_[View the full topic](https://discuss.elastic.co/t/i-want-to-take-lat-long-from-mysql-database-and-map-as-geopoint-in-elasticsearch-index/194060)._