[Gvsig_english] gvSIG 1.11 export layer to PostgreSQL/PostGIS

[Juan Lucas Dominguez Rubio]

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: gvsig_internacional-bounces at listserv.gva.es en nombre de Klaus Schaefer
Enviado el: jue 08/09/2011 11:29
Para: gvsig_internacional at listserv.gva.es
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
Gvsig_internacional at listserv.gva.es
http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserv.gva.es/pipermail/gvsig_internacional/attachments/20110908/f1af166b/attachment.htm