Hello, as for the second issue, is it possible to indentify the row that is causing the problem and send us the stored PostGIS geometry, as you did in the previous message? Perhaps there is a linestring with less than two vertices (?)
SELECT ST_AsText(the_geom) FROM <schema>.<water_lines_table> Regards, Juan Lucas Domínguez Rubio --- Prodevelop SL, Valencia (España) Tlf.: 96.351.06.12 -- Fax: 96.351.09.68 http://www.prodevelop.es <http://www.prodevelop.es/> --- ________________________________ De: [email protected] en nombre de Klaus Schaefer Enviado el: jue 08/09/2011 11:29 Para: [email protected] Asunto: Re: [Gvsig_english] gvSIG 1.11 export layer to PostgreSQL/PostGIS Hello folks, yes, this issue is resolved by setting my view to EPSG:4326. I was using the wrong projection in my view! So far there is only little issues left: 1) The backslash ("\") can still not be used in gvSIG attribute data. When exporting to PostGIS this results in an error e.g. the character is replaced by something else. Notice that I have UTF-8 in both PostgreSQL and gvSIG DBF-encoding. However, as mentioned before, a workaround is to use the regular slash ("/") wich is accepted in Windows to set up a hyperlink reference as well. 2) I have a nice "line type" layer which represents my water scheme. I can "draw" and save as shape file and export it into PostGIS without complains, it gets store there as "MULTILINESTRING". However - when I try to add it from PostGIS as a gvSIG layer I receive the error message "Error al cargar la capa: ERROR: geometry requires more points". Any ideas on this...? Thanks again a lot for all your support and help!!! Klaus -- View this message in context: http://osgeo-org.1803224.n2.nabble.com/gvSIG-1-11-export-layer-to-PostgreSQL-PostGIS-tp6761113p6771070.html Sent from the gvSIG users mailing list archive at Nabble.com. _______________________________________________ Gvsig_internacional mailing list [email protected] http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
_______________________________________________ Gvsig_internacional mailing list [email protected] http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
