How do I sync the geospatial data from kafka topic to postgres?

Asked Aug 23 '19 at 13:06

Active May 16 '20 at 12:51

Viewed 341 times

I have been trying to sync the geospatial data from kafka topic to postgres db with postgis enabled. So the geospatial data is in form of array [lat, lng] at the moment in kafka topic. I want to sync this field as (Point(lat,lng), SRID) in postgres in location column instead of two different columns of lat and lng. I am using jdbcConnector and KSQL server at the moment.

Is it possible to sync geospatial data from kafka topic to postres? What options are there to sync geospatial data to postgres?

I looked into Single Message Transform but that didn't do the trick. I also found Geomesa which looks like it does the thing but I want to use Postgres.

How could I solve this issue? Thanks in advance.

edited May 16 '20 at 12:51

Avocado

asked Aug 23 '19 at 13:06

py_trainee

Hey mate, have you got any solution to this? I am facing the same problem as yours now. – Scorpioooooon21 Jun 02 '21 at 00:37
Sorry mate. The project didn't move forward and I never bothered to look for solution. I hope you find the solution to it. – py_trainee Jun 09 '21 at 05:59

How do I sync the geospatial data from kafka topic to postgres?

0 Answers0