# PostGIS Spatial Data import in ElasticSearch

**URL:** <https://discuss.elastic.co/t/postgis-spatial-data-import-in-elasticsearch/162741>\
**Category:** Logstash\
**Created:** [January 3, 2019, 5:14am UTC](https://discuss.elastic.co/t/postgis-spatial-data-import-in-elasticsearch/162741 "2019-01-03T05:14:14Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rahul\_Tandon](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rahul_tandon/32/39380_2.png) [@Rahul\_Tandon](https://discuss.elastic.co/u/Rahul_Tandon)\
**Post date:** [January 3, 2019, 5:14am UTC](https://discuss.elastic.co/t/postgis-spatial-data-import-in-elasticsearch/162741/1 "2019-01-03T05:14:14Z")

</div>

I am trying to import spatial data from postgres(POSTGIS extension) but facing issue while imporing spatial data.

I am able to import non spatial data from postgres to elasticsearch using logstash.

elastic search 6.5.4  
os-windows 10 64 bit  
postgres9.4  
postgis2.3.2

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [January 3, 2019, 5:14am UTC](https://discuss.elastic.co/t/postgis-spatial-data-import-in-elasticsearch/162741/2 "2019-01-03T05:14:59Z")

</div>

> [@Rahul\_Tandon](#):
>
> facing issue while imporing spatial data.

Unless you share what the issues are, it's going to be hard to help 😉

---

<div class="post-metadata">

**Author:** ![Rahul\_Tandon](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rahul_tandon/32/39380_2.png) [@Rahul\_Tandon](https://discuss.elastic.co/u/Rahul_Tandon)\
**Post date:** [January 3, 2019, 5:32am UTC](https://discuss.elastic.co/t/postgis-spatial-data-import-in-elasticsearch/162741/3 "2019-01-03T05:32:20Z")

</div>

I am getting this exception:

Exception when executing JDBC query {:exception=\>#\<Sequel::DatabaseError: Java::OrgLogstash::MissingConverterException: Missing Converter handling for full class name=org.postgresql.util.PGobject, simple name=PGobject\>}

---

<div class="post-metadata">

**Author:** ![balumurari1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/balumurari1/32/39203_2.png) [@balumurari1](https://discuss.elastic.co/u/balumurari1)\
**Post date:** [January 3, 2019, 7:11am UTC](https://discuss.elastic.co/t/postgis-spatial-data-import-in-elasticsearch/162741/4 "2019-01-03T07:11:17Z")

</div>

> [@Rahul\_Tandon](#):
>
> Exception when executing JDBC query

try to execute the query in your database and check whether data is obtained or not.

if you could provide input code, it will benefit you to get solution as soon as possible.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [January 31, 2019, 7:11am UTC](https://discuss.elastic.co/t/postgis-spatial-data-import-in-elasticsearch/162741/5 "2019-01-31T07:11:23Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.