Displays information about feature geometry in the common feature storage. Any spatial representation can be queried, including obsolete versions. See also FEATURE_GEOMETRY_TEXT_VW and FEATURE_GEOMETRY_IMAGE_VW for more information about text and image features.
Output
Column | Type | Description |
|---|---|---|
rep_id | NUMBER | The spatial representation id. This represents the geometry. |
spa_type | VARCHAR2 | The spatial type: • S = sounding • P = point • A = area • T = text • I = image • L = line • NULL = collections |
text_type | VARCHAR2 | The type of text: • J = point-justified text • B = block text • C = curved text • I = irregular text • NULL = not text |
object_type | VARCHAR2 | The spatial type as a string: • Sounding • Point • Area • Text • Image • Line • Collection Although this is convenient for display, it is more efficient to query by spa_type. |
LLDG_geom | GEOMETRY | The geometry of the spatial representation in the source database LLDG coordinate system. This geometry is not spatially indexed. Limitations: PCE data created before HPD 4.0 may return NULL. |
branch_geom | GEOMETRY | The geometry of the spatial representation in the product coordinate system. NULL if the product is stored in the source database LLDG coordinate system. This geometry is not spatially indexed. Limitation 1: This field is currently always NULL for images. Limitation 2: PCE line/area features created before HPD 4.0 may return NULL. The p_feature_api.getBranchGeometry function can be used to build this geometry. |
Example
select sv.usage_name, g.object_type, g.lldg_geom, g.branch_geom from source_feature_vw sv, feature_geometry_vw g where sv.rep_id = g.rep_id and sv.foid = FoidStringToNumber('1C 0000000001 00001'); |