[fdo-internals] RE: FDO Function SpatialExtents

[Jason Birch]

Doh, I spoke too soon.  USER_SDO_INDEX_METADATA..SDO_ROOT_MBR does actually contain values on my setup, it’s just that my window was cutting it off after the dimensionality info.

 

Jason

 

From: fdo-internals-bounces at lists.osgeo.org [mailto:fdo-internals-bounces at lists.osgeo.org] On Behalf Of Jason Birch
Sent: Monday, November 17, 2008 15:03
To: FDO Internals Mail List
Subject: RE: [fdo-internals] RE: FDO Function SpatialExtents

 

SDO_DIMINFO in the SDO_GEOM_METADATA_TABLE (which has a bunch of user, etc aliases) stores the extents of each layer.  However, this isn’t guaranteed to be the  data extents in real-world situations.

 

SDO_INDEX_METADATA_TABLE appears to store information about the MBR, but I’m not sure how to decode it.  None of the entries in my database contain usable values in SDO_*_EXTENTS fields or in the SDO_ROOT_MBR field (that I can tell).  Do you have to read the value of the SDO_NL_INDEX_TABLE, and then pull the value from that?

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/fdo-internals/attachments/20081117/ca6146e8/attachment.html