topic Re: shapefile to postgis in Talend Studio

shapefile to postgis

Anonymous — Sat, 16 Nov 2024 10:15:04 GMT

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
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

Re: shapefile to postgis

Anonymous — Thu, 17 Nov 2016 07:58:10 GMT

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

Re: shapefile to postgis

Anonymous — Fri, 25 Nov 2016 11:44:15 GMT

Thanks François
regards
fred