[fdo-internals] RE: FDO Function SpatialExtents

[Dan Stoica]

The column in question is USER_SDO_INDEX_METADATA.SDO_ROOT_MBR

Note for geodetic this value is not accurate and brute force calculation should be used.

Dan.

From: fdo-internals-bounces at lists.osgeo.org [mailto:fdo-internals-bounces at lists.osgeo.org] On Behalf Of Orest Halustchak
Sent: Monday, November 17, 2008 5:45 PM
To: 'fdo-internals at lists.osgeo.org'
Subject: Re: [fdo-internals] RE: FDO Function SpatialExtents


Oracle saves the root mbr in one of the metadata tables. I don't have access at the moment to check.

Orest.

--------------------------
Sent from my BlackBerry Wireless Handheld

________________________________
From: fdo-internals-bounces at lists.osgeo.org
To: FDO Internals Mail List
Sent: Mon Nov 17 14:54:09 2008
Subject: RE: [fdo-internals] RE: FDO Function SpatialExtents
Can you help me little more, how to get it from R-TREE ?
I know of SDO_TUNE.Extent_OF which is faster for some types of data.

BTW, so far I tested , Map calls it twice, once together with Count, second time only SpatialExtents.

Thanks,
Haris

From: fdo-internals-bounces at lists.osgeo.org [mailto:fdo-internals-bounces at lists.osgeo.org] On Behalf Of Orest Halustchak
Sent: Monday, November 17, 2008 11:22 PM
To: FDO Internals Mail List
Subject: [fdo-internals] RE: FDO Function SpatialExtents

Hi Haris,

Map3D asks for the spatial extents first before fetching any of the geometry. The spatial extents will define the extents of the window. The spatial extents function needs to be very quick in this case. For Oracle, you could get it from the r-tree.

Thanks,
Orest.

From: fdo-internals-bounces at lists.osgeo.org [mailto:fdo-internals-bounces at lists.osgeo.org] On Behalf Of Haris Kurtagic
Sent: Monday, November 17, 2008 5:36 PM
To: FDO Internals Mail List
Subject: [fdo-internals] FDO Function SpatialExtents

Hi,

I have implemented support for SelectAggregates in King.Oracle.
I am testing SpatialExtent function and I need help in understanding how clients, MAP 3D , is using it. I am not sure if I understand how is it supposed to be used.

I have implemented function using Oracle SDO_AGGR_MBR. That is rather slow process .
What I noticed is that MAP 3D 2009 is calling FDO command SelectAggregates with SpatialExtents function.
That makes rendering of layers very slow in MAP 3D.

I know I am asking about non-open source client like MAP 3D but from what I see makes me wonder if I understand SpatialExtents function correctly.

Thank you,
Haris
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/fdo-internals/attachments/20081117/6e8fce60/attachment-0001.html