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. _______________________________________________ Gvsig_internacional mailing list [email protected] http://listserv.gva.es/cgi-bin/mailman/listinfo/gvsig_internacional
