[Gvsig_english] gvSIG 1.11 export layer to PostgreSQL/PostGIS

[Klaus Schaefer]

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 the layer property info: 

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 
------------------------------------------------- 

When I use the PostGIS shapefile loader everything looks fine in gvSIG:

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-tp6761113p6761113.html
Sent from the gvSIG users mailing list archive at Nabble.com.