<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=idOWAReplyText2245>
<DIV><FONT face="Times New Roman" color=#000000 size=3>Hello,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>You are in dealing with coordinates in Tanzania, is that correct?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>The coordinates of the town of Same (Tanzania) in geographic WGS84 (also known as EPSG:4326) are approx.:</FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>(37.727332, -4.081323)</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>The coordinates of the town of Same (Tanzania) in EPSG:32737 (WGS84, UTM projection, zone 37S) are approx.:</FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>(360000, 9550000)</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>There is another strange thing in your data. The geometries in the table "st" have an absurd value:</FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>(500000 2035.0569780916)</FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3></FONT> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>That seems to be the result of a bad reprojection (for example trying to reproject from EPSG:32737 to EPSG:4326 something that was already in EPSG:4326, and then reprojected again to EPSG:32737, or something like that)</FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3></FONT> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>I think you are not using correctly the coordinate systems.</FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3></FONT> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>Considering that you are very close to the Equator and you are using GPS, perhaps it's better to use always EPSG:4326 in your gvSIG views.</FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3></FONT> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>Can you send an example of the data you get from the GPS? Does your GPS create shapefiles?</FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3></FONT> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>The data you get from your GPS is probably in EPSG:4326, although maybe that device talks about 37S because the GPS shows you in its screen the map in EPSG:32737.</FONT></DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3></FONT> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3></FONT> </DIV>
<DIV><FONT face="Times New Roman" color=#000000 size=3>Regards,</FONT></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=idSignature63001>
<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 13:45<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>Juan,<BR><BR>/"POINT(37.765666 -4.091814)" so that's not EPSG:32737"/<BR><BR>that is WGS 84, EPSG:32737 (37 S)<BR><BR>at least everything else works for this projection. It's what my view is set<BR>to, it's what my shapefiles say, it's what my GPS says...<BR><BR>Best regards<BR>Klaus<BR><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-tp6761113p6763569.html">http://osgeo-org.1803224.n2.nabble.com/gvSIG-1-11-export-layer-to-PostgreSQL-PostGIS-tp6761113p6763569.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>