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

[Jan Syryn]

  _____  

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Norman
Barker
Sent: vendredi 1 décembre 2006 10:08
To: PostGIS Users Discussion
Subject: RE: [postgis-users] Spatial Queries on Postgis Java Geometry
classes



 

 

  _____  

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Sandeep
Kumar Jakkaraju
Sent: 01 December 2006 00:09
To: PostGIS Users Discussion
Subject: [postgis-users] Spatial Queries on Postgis Java Geometry classes

 

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



Sandeep,

This would be useful as an object query, so EJB-QL, or HQL.  I ran a demo
project from Jan earlier this week with the hibernate postgis driver (so
dropping all my EJB3 code) and it works fine in a hibernate/spring
environment as well as JBoss.  I notice that the query parser for hibernate
3 is different to 2.1, I think this may be a major piece of work – let me
know if I can help.

It would be good to document any object query extensions if you have time.

Thanks,

Norman





-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20070209/1316bf47/attachment.html>