[Gvsig_english] gvSIG 1.11 export layer to PostgreSQL/PostGIS

[Juan Lucas Dominguez Rubio]

Hello,
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.
 
Are you reprojecting on the fly and exporting at the same time? If so, try to do it in two steps:
 
- create view in EPSG:4326
- add shapefile in EPSG:32737 (called for example "file_32737.shp")
- export to a new shapefile (called for example "file_4326.shp") and add it to the view (must overlap exactly the previous layer)
- export the new layer to PostGIS
 
The problem still happens in that case?
 
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: mar 06/09/2011 7:03
Para: gvsig_internacional at listserv.gva.es
Asunto: Re: [Gvsig_english] gvSIG 1.11 export layer to PostgreSQL/PostGIS



I was just reviewing my post from January this year

http://osgeo-org.1803224.n2.nabble.com/gvSIG-1-10-not-working-properly-with-PostgreSQL-PostGIS-td5921449.html

and recognized that is pretty much the same issues, promised to be fixed in
gvSIG version 1.12.

When can we expect 1.12 to come...?

BTW - a workaround for the "\" issue is to use the regular slash "/"
instead. Nowadays windows accepts the slash for path entries as well, so one
can refer to pictures in gvSIG that way either.

Thanks and best regards
Klaus

--
View this message in context: http://osgeo-org.1803224.n2.nabble.com/gvSIG-1-11-export-layer-to-PostgreSQL-PostGIS-tp6761113p6762703.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/20110906/be3eea98/attachment.htm