<HTML><HEAD><TITLE>Re: [Gvsig_english] gvSIG 1.11 export layer to PostgreSQL/PostGIS</TITLE>
<META http-equiv=Content-Type content="text/html; charset=unicode">
<META content="MSHTML 6.00.6000.17102" name=GENERATOR></HEAD>
<BODY>
<DIV id=idOWAReplyText47571>
<DIV><FONT face="Times New Roman" color=#000000 size=3>Hello, as for the second issue, </FONT>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 (?)</DIV>
<DIV> </DIV>
<DIV>SELECT ST_AsText(the_geom) FROM <schema>.<water_lines_table></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Regards,</DIV>
<DIV><FONT face="Courier New" size=2><FONT face="Times New Roman" size=3>Juan Lucas Domínguez Rubio<BR></FONT>---</FONT></DIV></DIV>
<DIV id=idSignature30857>
<DIV><FONT face="Courier New" size=2><FONT face="Courier New" size=2><FONT face="Courier New" size=2>Prodevelop SL, Valencia (España)</FONT></DIV>
<DIV>
<DIV><FONT face="Courier New" size=2>Tlf.: 96.351.06.12 -- Fax: 96.351.09.68<BR></FONT><A href="http://www.prodevelop.es/"><FONT face="Courier New" size=2>http://www.prodevelop.es</FONT></A><BR><FONT face="Courier New" size=2>---</FONT></DIV></FONT></DIV></FONT></DIV>
<DIV><BR>
<HR>
<FONT face=Tahoma size=2><B>De:</B> gvsig_internacional-bounces@listserv.gva.es en nombre de Klaus Schaefer<BR><B>Enviado el:</B> jue 08/09/2011 11:29<BR><B>Para:</B> gvsig_internacional@listserv.gva.es<BR><B>Asunto:</B> Re: [Gvsig_english] gvSIG 1.11 export layer to PostgreSQL/PostGIS<BR></FONT><BR></DIV>
<DIV>
<P><FONT size=2>Hello folks,<BR><BR>yes, this issue is resolved by setting my view to EPSG:4326. I was using the<BR>wrong projection in my view!<BR><BR>So far there is only little issues left:<BR><BR>1) The backslash ("\") can still not be used in gvSIG attribute data. When<BR>exporting to PostGIS this results in an error e.g. the character is replaced<BR>by something else. Notice that I have UTF-8 in both PostgreSQL and gvSIG<BR>DBF-encoding. However, as mentioned before, a workaround is to use the<BR>regular slash ("/") wich is accepted in Windows to set up a hyperlink<BR>reference as well.<BR><BR>2) I have a nice "line type" layer which represents my water scheme. I can<BR>"draw" and save as shape file and export it into PostGIS without complains,<BR>it gets store there as "MULTILINESTRING". However - when I try to add it<BR>from PostGIS as a gvSIG layer I receive the error message "Error al cargar<BR>la capa: ERROR: geometry requires more points". Any ideas on this...?<BR><BR>Thanks again a lot for all your support and help!!!<BR><BR>Klaus<BR><BR>--<BR>View this message in context: <A href="http://osgeo-org.1803224.n2.nabble.com/gvSIG-1-11-export-layer-to-PostgreSQL-PostGIS-tp6761113p6771070.html">http://osgeo-org.1803224.n2.nabble.com/gvSIG-1-11-export-layer-to-PostgreSQL-PostGIS-tp6761113p6771070.html</A><BR>Sent from the gvSIG users mailing list archive at Nabble.com.<BR>_______________________________________________<BR>Gvsig_internacional mailing list<BR>Gvsig_internacional@listserv.gva.es<BR><A href="http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional">http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional</A><BR></FONT></P></DIV></BODY></HTML>