[postgis-users] Spatial Queries on Postgis Java Geometry classes

Sandeep Kumar Jakkaraju sandeepkumar.jakkaraju at gmail.com
Thu Nov 30 16:08:49 PST 2006


Hi All

If i am correct !! all the spatial queries are done on the geometry objects
..in the table ..

For example:-
I have a table ..which has a geometry column which of type say POLYGON
...say bounds
I want to write a spatial query ..

select * from table where intersects (GEOMFROMTEXT('POINT(0 0)'),bounds);

but if some one is using Hibernate with Postgis ... I have to run this as a
native sql query ..
BUT has anyone worked on Postgis ..Geometry Java CLass ..so that ..i can run
a createria query
like

"from Tiles t where t.bounds.intersects('POINT(0 0)')";

if someone thinks it is worthwhile to work on .. i would like to work on it
..

thanx ...

sandeep
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20061201/33011ee4/attachment.html>


More information about the postgis-users mailing list