Hi Andrea
I had gone through the Oracle connector codes and fine to do changes to
that. In meantime did some manual testing for earlier sql statement with
SDO_GEOM.RELATE. It worked without any issues.
SELECT count(*) AS gt_result_ FROM (SELECT * FROM (SELECT * FROM (SELECT
b.GROUP_ID as GRP_ID, SDO_AGGR_UNION(SDOAGGRTYPE(a.LOCATION, 0.005)) as
GRP_LOCATION FROM GIS.PART_TABLE a, GIS.GROUP_TABLE b WHERE
a.PART_ID=b.PART_ID Group by b.GRP_ID ) *VTABLE WHERE
SDO_GEOM.RELATE*(GRP_LOCATION,
'anyinteract',
MDSYS.SDO_GEOMETRY(2003,2193,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(-154768.4241380731,4257259.84132448,3240947.544118471,6614572.798694815)),
0.005 ) = 'TRUE' ) WHERE ROWNUM <= 1000000) gt_limited_;
For above command used following format of SDO_GEOM.RELATE:
SDO_GEOM.RELATE(
geom1 IN MDSYS.SDO_GEOMETRY,
mask IN VARCHAR2,
geom2 IN MDSYS.SDO_GEOMETRY,
tolerance IN NUMBER
) RETURN VARCHAR2;
To implement this change as patch to Oracle connector, i wish to get the
advice on that. Can we consider another configuration for SDO_GEOM.RELATE
such currently used loose box field for SDO_FILTER or any other suggestions?
Regards
Senthil
On Fri, Jul 16, 2010 at 9:10 PM, Andrea Aime <[email protected]> wrote:
> Senthil ha scritto:
>
> Hi Andrea & Miles,
>>
>> Thanks for the emails.. Today i was checking on application schema codes
>> on how complex feature works... I'm thinking about check SDO_FILTER part
>> during weekend..
>>
>> Any thought on this JIRA issue http://jira.codehaus.org/browse/GEOT-2062
>>
>
> Ah, got no feedback from the user. Time to close it, the old oracle store
> is gone the way of the Dodo.
>
>
> It looks based on earlier code base and not related to OracleNG.. but,
>> interestingly seen SDO_RELATE was used earlier. nut not SDO_GEOM.RELATE.
>>
>
> Afaik SDO_RELATE also needs a spatial index.
>
>
> Cheers
> Andrea
>
>
> --
> Andrea Aime
> OpenGeo - http://opengeo.org
> Expert service straight from the developers.
>
------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
Geoserver-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
