You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2016-11-16 18:20:31

fmarin156
Member
54 posts

fmarin156 said:

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

Offline

#2 2016-11-17 08:58:10

Fxp
Member
193 posts

Fxp said:

Re: shapefile to postgis

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

Offline

#3 2016-11-25 12:44:15

fmarin156
Member
54 posts

fmarin156 said:

Re: shapefile to postgis

Thanks François

regards
fred

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy