Select Distance

2 messages Options
Embed this post
Permalink
Tolga Tarhan

Select Distance

Reply Threaded More More options
Print post
Permalink
Some javascript/style in this post has been disabled (why?)

All,

 

We’re using Oracle and performing queries using Hibernate Spatial which take advantage of OracleSpatialRestrictions. SDOWithinDistance(). The one thing we can’t figure out is – is there a way to have Hibernate Spatial select SDO_DISTANCE() in the column list so that we can not only filter results to a certain distance, but also know what the distance was? The same is true with OracleSpatialRestrictions. SDONN() and selecting SDO_NN_DISTANCE().

 

If this isn’t currently supported, could someone be kind enough to point me in the right direction for how this could be implemented if we decided to take-on this feature enhancement?

 

Thanks,

Tolga


_______________________________________________
hibernatespatial-users mailing list
[hidden email]
http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users
Karel Maesen

Re: Select Distance

Reply Threaded More More options
Print post
Permalink
Hi Tolga,

The SDO_DISTANCE and SDO_NN_DISTANCE is currently not supported. You  
need to add static factory methods to the OracleSpatialProjections  
class which get their SQL-fragment from the OracleSpatialDialect  
(function getSpatialAggregateSQL). Unfortunately, currently only  
grouping projections are supported in the internal API. This would  
need to be extended or generalized to all kinds of projections  
(something on my todo list).

If you decide to implement this, consider submitting your work as a  
patch so it is available to the whole community.

Regards,

Karel Maesen

On 07 Feb 2008, at 08:19, Tolga Tarhan wrote:

> All,
>
>
>
> We’re using Oracle and performing queries using Hibernate Spatial  
> which take advantage of OracleSpatialRestrictions. SDOWithinDistance
> (). The one thing we can’t figure out is – is there a way to have  
> Hibernate Spatial select SDO_DISTANCE() in the column list so that  
> we can not only filter results to a certain distance, but also know  
> what the distance was? The same is true with  
> OracleSpatialRestrictions. SDONN() and selecting SDO_NN_DISTANCE().
>
>
>
> If this isn’t currently supported, could someone be kind enough to  
> point me in the right direction for how this could be implemented  
> if we decided to take-on this feature enhancement?
>
>
>
> Thanks,
>
> Tolga
>
> _______________________________________________
> hibernatespatial-users mailing list
> [hidden email]
> http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/ 
> hibernatespatial-users

_______________________________________________
hibernatespatial-users mailing list
[hidden email]
http://www.hibernatespatial.org/cgi-bin/mailman/listinfo/hibernatespatial-users