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

[Norman Barker]

Jan, Sandeep

 

This email just came into my inbox, but I notice you didn't say anything in it.  I am not sure if this hql code got added to postgis subversion but the link is here

 

http://article.gmane.org/gmane.comp.gis.postgis/12282/match=spatial+object+queries+postgis

 

 

Norman

 

________________________________

From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Jan Syryn
Sent: 09 February 2007 15:04
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 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/20070212/a0844f27/attachment.html>