<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=idOWAReplyText52300>
<DIV><FONT face="Times New Roman" color=#000000 size=3>Hello,</FONT></DIV>
<DIV>I have checked and there is a problem when you export to PostGIS a layer which is being reprojected on the fly: for example, if the view is in EPSG:4326 and you add a shapefile in EPSG:32737 and export it to PostGIS, the geometries are ok (EPSG:4326) but the geometry_columns table says they are in EPSG:32737. I never found a "-1" as in your example.</DIV>
<DIV> </DIV>
<DIV>Are you reprojecting on the fly and exporting at the same time? If so, try to do it in two steps:</DIV>
<DIV> </DIV>
<DIV>- create view in EPSG:4326</DIV>
<DIV>- add shapefile in EPSG:32737 (called for example "file_32737.shp")</DIV>
<DIV>- export to a new shapefile (called for example "file_4326.shp") and add it to the view (must overlap exactly the previous layer)</DIV>
<DIV>- export the new layer to PostGIS</DIV>
<DIV> </DIV>
<DIV>The problem still happens in that case?</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=idSignature3157>
<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> mar 06/09/2011 7:03<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>I was just reviewing my post from January this year<BR><BR><A href="http://osgeo-org.1803224.n2.nabble.com/gvSIG-1-10-not-working-properly-with-PostgreSQL-PostGIS-td5921449.html">http://osgeo-org.1803224.n2.nabble.com/gvSIG-1-10-not-working-properly-with-PostgreSQL-PostGIS-td5921449.html</A><BR><BR>and recognized that is pretty much the same issues, promised to be fixed in<BR>gvSIG version 1.12.<BR><BR>When can we expect 1.12 to come...?<BR><BR>BTW - a workaround for the "\" issue is to use the regular slash "/"<BR>instead. Nowadays windows accepts the slash for path entries as well, so one<BR>can refer to pictures in gvSIG that way either.<BR><BR>Thanks and best regards<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-tp6761113p6762703.html">http://osgeo-org.1803224.n2.nabble.com/gvSIG-1-11-export-layer-to-PostgreSQL-PostGIS-tp6761113p6762703.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>