shapefile to postgis

One Star

shapefile to postgis

hi,
i use Talend TOS 6.11 and i've installed spatial extension (TOS-spatial-36.0.1)
i have to load a shapefile to postgis, but my shapefile is encoded in utf8 (like in .cpg) and it seems sShapefileInput is working only with "latin1" encodage (it's the standard for shapefile encoding ...)
there is a solution ? i think to use some postgis utility like shp2pgsql, but it's not an ideal solution for me Smiley Happy
another question : some functions are deprecated for postgresql (like geomfromtext wihich is prefixed now in st_geomfromtext in postgis extension) ; for that, we have to install old legacy.sql in spatial database ... and i don't think it is a good thing : there is another solution ?
regards
fred
One Star Fxp
One Star

Re: shapefile to postgis

Hi Fred,
You're right about charset, I created an issue about that https://github.com/talend-spatial/talend-spatial/issues/69 but I've no resource to work on it. Another option would be to test what sOgrInput provides ?
HTH.
Francois
Highlighted
One Star

Re: shapefile to postgis

Thanks François
regards
fred

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch