[Gvsig_english] gvSIG 1.11 export layer to PostgreSQL/PostGIS

Klaus Schaefer klaus.schaefer4 at giz.de
Mon Sep 5 17:11:41 CEST 2011 

Hi folks,

I'm on Windows 7, 64bit, SP1, and PostGRES 9.04 32bit.

When I use the gvSIG layer export to PostGIS function the projection of the
view/layer is not stored properly.

Here's a logfile extract and layer property info:

DEBUG AWT-EventQueue-1 com.iver.andami.ui.mdiFrame.MDIFrame - Memory usage
97215 KB
DEBUG AWT-EventQueue-1 com.iver.core.mdiManager.NewSkin$FrameListener -
Returns focus toView : TEST-SAME-TOPOMAP
DEBUG AWT-EventQueue-1 com.iver.andami.ui.mdiFrame.MDIFrame - Memory usage
103490 KB
DEBUG AWT-EventQueue-1 com.iver.andami.ui.mdiFrame.MDIFrame - Memory usage
78452 KB
DEBUG AWT-EventQueue-1 com.iver.andami.ui.mdiFrame.MDIFrame - Memory usage
85501 KB
WARN AWT-EventQueue-1 com.iver.andami.PluginServices - Cannot find
translation for 
WARN AWT-EventQueue-1 com.iver.andami.PluginServices - Plugin com.iver.core
-- Cannot find translation for Layer properties
WARN AWT-EventQueue-1 com.iver.andami.PluginServices - Plugin com.iver.core
-- Cannot find translation for Activate the window
DEBUG AWT-EventQueue-1 com.iver.core.mdiManager.NewSkin - Activando Layer
properties
DEBUG AWT-EventQueue-1 com.iver.andami.ui.mdiFrame.MDIFrame - Memory usage
110694 KB
DEBUG AWT-EventQueue-1 com.iver.andami.ui.mdiFrame.MDIFrame - Memory usage
93449 KB
DEBUG AWT-EventQueue-1 com.iver.core.mdiManager.NewSkin$FrameListener -
Returns focus toView : TEST-SAME-TOPOMAP
DEBUG AWT-EventQueue-1 com.iver.andami.ui.mdiFrame.MDIFrame - Memory usage
98991 KB
DEBUG AWT-EventQueue-1 com.iver.andami.ui.mdiFrame.MDIFrame - Memory usage
83201 KB
DEBUG AWT-EventQueue-1 com.iver.andami.ui.mdiFrame.MDIFrame - Memory usage
87886 KB
DEBUG AWT-EventQueue-1 com.iver.andami.ui.mdiFrame.MDIFrame - Memory usage
94304 KB
DEBUG AWT-EventQueue-1 com.iver.andami.ui.mdiFrame.MDIFrame - Memory usage
101931 KB
WARN AWT-EventQueue-1 com.iver.andami.PluginServices - Cannot find
translation for writinng_project
DEBUG AWT-EventQueue-1 com.iver.andami.messages.NotificationManager -
writinng_project: Same-SAUWASA-GE-PostGIS.gvp
DEBUG AWT-EventQueue-1 com.iver.andami.messages.NotificationManager -
Project file saved: Same-SAUWASA-GE-PostGIS.gvp
INFO AWT-EventQueue-1 com.iver.cit.gvsig.ProjectExtension - Project saved.
296 miliseconds
INFO AWT-EventQueue-1
com.iver.cit.gvsig.fmap.drivers.db.utils.SingleVectorialDBConnectionManager
- Successfully closed all connections.

Extent EPSG:32737 (Proyección de la vista):
	Upper:	100.0
	Lower:	0.0
	Left:	0.0
	Right:	100.0
Datasource: 
PostGIS JDBC Driver
URL: jdbc:postgresql://localhost:5432/sauwasa
Table: st

Type: Point2D
-------------------------------------------------

If I used the PostGIS shapefile loader everything looks fine in gvSIG:

INFO AWT-EventQueue-1
com.iver.cit.gvsig.fmap.drivers.jdbc.postgis.PostGisDriver - Cadena
SQL:SELECT AsEWKB("the_geom", 'XDR'), gid, "no", latitude, longitude, name,
altitude, mapdate, donor, active, "volume m3", remark, photo FROM
"public"."storagetank"  ORDER BY gid
DEBUG AWT-EventQueue-1 com.iver.cit.gvsig.fmap.layers.FLayers - layer: ST
loaded

Extent EPSG:32737 (Proyección de la vista):
	Upper:	-4.036083
	Lower:	-4.091814
	Left:	37.707122
	Right:	37.765666
Datasource: 
PostGIS JDBC Driver
URL: jdbc:postgresql://localhost:5432/sauwasa
Table: storagetank

Type: Point2D
--------------------------------------------------------------------------

Here's also some corresponing data from pgAdmin, first the problem table,
then the correct one loaded with PostGIS shapefile loader:

Table "st":

1;"1";"-4.036083";"37.714799";"ST Kavambughu";"1039.8";"09-05-2009
14:27:47";"SAUWASA";"no";"90.0";"''";"D:/010
gvSIG-Data/spatial-data/images";"0101000020E17F00000000000080841E41000077583ACC9F40"
2;"2";"-4.057077";"37.759293";"ST Majevu";"993.6";"09-05-2009
15:37:51";"SAUWASA";"no";"90.0";"''";"D:/010
gvSIG-Data/spatial-data/images/P1000732";"0101000020E17F00000000000080841E41000077583ACC9F40"
3;"5";"-4.078024";"37.755715";"ST SAUWASA (Boostertank)";"852.8";"06-07-2010
10:49:58";"SAUWASA";"yes";"45.0";"''";"D:/010
gvSIG-Data/spatial-data/images/P1000538";"0101000020E17F00000000000080841E41000077583ACC9F40"
4;"6";"-4.084005";"37.730313";"ST Same Sec School";"894.9";"06-07-2010
14:12:49";"SAUWASA";"yes";"22.5";"''";"D:/010
gvSIG-Data/spatial-data/images/P1000658";"0101000020E17F00000000000080841E41000077583ACC9F40"
5;"7";"-4.076228";"37.707122";"ST Kitamuri 01";"875.9";"23-06-2010
11:58:32";"SAUWASA";"yes";"45.0";"''";"D:/010
gvSIG-Data/spatial-data/images/P1000605";"0101000020E17F00000000000080841E41000077583ACC9F40"
6;"8";"-4.081323";"37.727332";"ST Boma";"912.9";"06-07-2010
11:57:17";"SAUWASA";"yes";"225.0";"''";"D:/010
gvSIG-Data/spatial-data/images";"0101000020E17F00000000000080841E41000077583ACC9F40"
7;"11";"-4.055845";"37.729628";"ST Mahuu";"954.7";"09-07-2010
12:13:59";"SAUWASA";"yes";"135.0";"''";"D:/010
gvSIG-Data/spatial-data/images/P1000688";"0101000020E17F00000000000080841E41000077583ACC9F40"
8;"12";"-4.062317";"37.746372";"ST Hosp 2";"930.4";"09-07-2010
10:52:39";"SAUWASA";"yes";"22.5";"''";"D:/010
gvSIG-Data/spatial-data/images/P1000681";"0101000020E17F00000000000080841E41000077583ACC9F40"
9;"13";"-4.062444";"37.746434";"ST Hosp 3";"930.4";"09-07-2010
10:51:15";"SAUWASA";"yes";"90.0";"''";"D:/010
gvSIG-Data/spatial-data/images/P1000683";"0101000020E17F00000000000080841E41000077583ACC9F40"
10;"14";"-4.062111";"37.746444";"ST Hosp 1";"927.6";"09-07-2010
10:19:23";"SAUWASA";"yes";"225.0";"''";"D:/010
gvSIG-Data/spatial-data/images/P1000679";"0101000020E17F00000000000080841E41000077583ACC9F40"
11;"16";"-4.079957";"37.729085";"ST Boma Old";"848.0";"01-09-2010
07:28:40";"SAUWASA";"no";"45.0";"''";"D:/010
gvSIG-Data/spatial-data/images";"0101000020E17F00000000000080841E41000077583ACC9F40"
12;"17";"-4.091814";"37.765666";"ST Mjimpya";"910.0";"05-11-2010
11:09:23";"SAUWASA";"yes";"90.0";"''";"D:/010
gvSIG-Data/spatial-data/images/xxx";"0101000020E17F00000000000080841E41000077583ACC9F40"


Table "storagetank"

1;"1";"-4.036083";"37.714799";"ST Kavambughu";"1039.8";"09-05-2009
14:27:47";"SAUWASA";"no";"90.0";"Test";"D:/010
gvSIG-Data/spatial-data/images";"0101000000541B9C887EDB42402AC423F1F22410C0"
2;"2";"-4.057077";"37.759293";"ST Majevu";"993.6";"09-05-2009
15:37:51";"SAUWASA";"no";"90.0";"";"D:/010
gvSIG-Data/spatial-data/images/P1000732";"0101000000768A558330E14240486AA164723A10C0"
3;"5";"-4.078024";"37.755715";"ST SAUWASA (Boostertank)";"852.8";"06-07-2010
10:49:58";"SAUWASA";"yes";"45.0";"";"D:/010
gvSIG-Data/spatial-data/images/P1000538";"01010000005F0CE544BBE0424061360186E54F10C0"
4;"6";"-4.084005";"37.730313";"ST Same Sec School";"894.9";"06-07-2010
14:12:49";"SAUWASA";"yes";"22.5";"";"D:/010
gvSIG-Data/spatial-data/images/P1000658";"0101000000FD6B79E57ADD42404BCD1E68055610C0"
5;"7";"-4.076228";"37.707122";"ST Kitamuri 01";"875.9";"23-06-2010
11:58:32";"SAUWASA";"yes";"45.0";"";"D:/010
gvSIG-Data/spatial-data/images/P1000605";"01010000001C2444F982DA424070287CB60E4E10C0"
6;"8";"-4.081323";"37.727332";"ST Boma";"912.9";"06-07-2010
11:57:17";"SAUWASA";"yes";"225.0";"";"D:/010
gvSIG-Data/spatial-data/images";"0101000000C9AA083719DD424083A62556465310C0"
7;"11";"-4.055845";"37.729628";"ST Mahuu";"954.7";"09-07-2010
12:13:59";"SAUWASA";"yes";"135.0";"";"D:/010
gvSIG-Data/spatial-data/images/P1000688";"0101000000791F477364DD42409A94826E2F3910C0"
8;"12";"-4.062317";"37.746372";"ST Hosp 2";"930.4";"09-07-2010
10:52:39";"SAUWASA";"yes";"22.5";"";"D:/010
gvSIG-Data/spatial-data/images/P1000681";"01010000003753211E89DF424078F01307D03F10C0"
9;"13";"-4.062444";"37.746434";"ST Hosp 3";"930.4";"09-07-2010
10:51:15";"SAUWASA";"yes";"90.0";"";"D:/010
gvSIG-Data/spatial-data/images/P1000683";"0101000000AD4F39268BDF42406153E751F13F10C0"
10;"14";"-4.062111";"37.746444";"ST Hosp 1";"927.6";"09-07-2010
10:19:23";"SAUWASA";"yes";"225.0";"";"D:/010
gvSIG-Data/spatial-data/images/P1000679";"0101000000D0251C7A8BDF42402EE3A6069A3F10C0"
11;"16";"-4.079957";"37.729085";"ST Boma Old";"848.0";"01-09-2010
07:28:40";"SAUWASA";"no";"45.0";"";"D:/010
gvSIG-Data/spatial-data/images";"0101000000888043A852DD42405858703FE05110C0"
12;"17";"-4.091814";"37.765666";"ST Mjimpya";"910.0";"05-11-2010
11:09:23";"SAUWASA";"yes";"90.0";"";"D:/010
gvSIG-Data/spatial-data/images/xxx";"01010000005FD4EE5701E2424081423D7D045E10C0"



Table "geometry_columns":

18412;"''";"public";"st";"the_geom";2;32737;"POINT"
18380;"''";"public";"storagetank";"the_geom";2;-1;"POINT"

---------------------------------------------------------------------------------------------------

Any idea about this behavior? Am I missing something or can it be a bug in
the export to PostGIS function of gvSIG?


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-tp6761064p6761064.html
Sent from the gvSIG users mailing list archive at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserv.gva.es/pipermail/gvsig_internacional/attachments/20110905/155e7ca1/attachment.htm

More information about the Gvsig_internacional mailing list