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.

_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to