topic Re: How to load LINESTRING to postgresql using Talend in Talend Studio

How to load LINESTRING to postgresql using Talend

Udhayavardhane — Fri, 15 Nov 2024 23:58:34 GMT

Hi All,

We have a txt file with geometry data like LINESTRING(-71.160281 42.258729,-71.160837 42.259113,-71.161144 42.25932)

Our requirement is, we want to load this data into postgresql database, with geometry column

How can we do this ? Please help!

Thanks & Regards,

Udhaya vardhane N.P

Re: How to load LINESTRING to postgresql using Talend

Anonymous — Mon, 12 Jul 2021 09:45:15 GMT

Are you using Postgis or are you Postgres without Postgis?

http://postgis.net/workshops/postgis-intro/geometries.html talks about this.

Have you tried to load this data with a Talend job already? If so, where are you struggling with this?

Since I do not have Postgres (or Postgis) configured, I cannot try out all of the scenarios that your question could relate to. I'll need more information.

Re: How to load LINESTRING to postgresql using Talend

Udhayavardhane — Mon, 12 Jul 2021 11:09:07 GMT

hi,

We have postgres with Postgis enabled.

Till now we were using .shp file with dGeometryToPostgisObject component. Where both input and output we could set as Geometry. That works fine & perfect.

But now our input file is a plain text file with string value like LINESTRING(-71.160281 42.258729,-71.160837 42.259113,-71.161144 42.25932). So when we are trying to build the metadata , the datatype of the field is string. But posgresql table has the datatype as geometry.

So we are not able to use dGeometryToPostgisObject & dproject.

Basically we need an idea , how to load the string from flat file to postgres-postgis geometry column using Talend.

Thanks