[postgis-users] psql and jdbc give different result

[temiz]

hello

String rs1ql4="select astext(wkb_geometry) from shey61_points where 
yuk_nokta=(select max(yuk_nokta) from shey61_points where heycat=?)";

by preparedStatement in jdbc

                               Geometry  g3 = 
wkbReader.read(WKBReader.hexToBytes(rs4.getString(1)));   ///   JTS
                               String coord3=g3.getCoordinate().toString();
                              
                               PGgeometry obj2 = 
(PGgeometry)rs4.getObject(1);                     ///    PostGIS
                               String str3=obj2.toString();
                              
                               //String str3=g3.toString();
                               System.out.println("  coord3"+ coord3);
                               System.out.println("  str3"+ str3);

  these two give:

  coord3(469550.8043909763, 4598000.450357108, NaN)
  str3SRID=32636;POINT(469550.8043909763 4598000.450357108)
 
but in psql, I get :

bzk2=> select astext(wkb_geometry) from shey61_points where 
yuk_nokta=(select max(yuk_nokta) from shey61_points where heycat=119);
                                      astext
---------------------------------------------------------------------
 POINT(458419.167485305 4598605.03718012)

Could  you tell me  the reason  why I don't get  same coordinat values  ?

regards
 
 

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.