[fdo-internals] RE: FDO Function SpatialExtents
Jason.Birch at nanaimo.ca
Mon Nov 17 18:09:14 EST 2008
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.
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...
More information about the fdo-internals