De-aggregate composite geometries
Wednesday, September 8, 2010
Diagram For X Wing Star Wars Pinewood Derby Car
from a composite geometry (multi-polygon, several elements, optionally also contains sub-elements / rings) can use the function EXTRACT individual elements are extracted. This function for 2D vector data, as well as analog EXTRACT3D for 3D vector data, is in PL / SQL package SDO_UTIL available. The latter function, however, it is only since the DB version 11.1 in the package. The format is briefly described as follows: sdo_util.extract ( . - Extraction of Element 1, Ring 1 SQL> select sdo_util.extract (geometry, 1, 1) from where m_admin_area2 feature_name = 'Brandenburg'; - Result of the outer ring of Brandenburg - Result of the inner ring of Brandenburg, while the administrative border of the State of Berlin - result here is a small enclave in Brandenburg Saxony-Anhalt
element geometry IN SDO_GEOMETRY,
IN NUMBER,
ring IN NUMBER default 0
) return SDO_GEOMETRY; - 2D
And how are specifically ? Where is the Multipolgyon "Brandenburg" (SDO_GTYPE = 2007) from the World Sample NAVTEQ Data Bundle
- Extraction of Element 1, Ring 2
SQL> select sdo_util.extract (geometry, 1, 2) from where m_admin_area2 feature_name = 'Brandenburg';
- Extraction of Element 2, Ring 2
SQL> select sdo_util.extract (geometry, 2, 1) from where m_admin_area2 feature_name = 'Brandenburg';
More information can be found naturally in the online documentation on OTN ( http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14255/sdo_util.htm # sthref1955
).
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment