Oracle Spatial Relational Feature Representation

Features read from Oracle Spatial Relational consist of a series of attribute values and geometry.

In addition to the generic FME feature attributes that FME Workbench adds to all features (see About Feature Attributes), the Oracle Spatial Relational module makes use of the following special attribute names:

Attribute Name

Contents

oracle_type

oracle_nil

oracle_point

oracle_line

oracle_area

No Coordinates

oracle_type: oracle_nil

Features with no coordinates are tagged with this value when reading or writing to or from Oracle Spatial Relational.

Points

oracle_type: oracle_point

Features tagged with this value consist of a single point or an aggregate of points. When the object model is being used, an aggregate or line geometry tagged as oracle_point will be written as a “point cluster” with several coordinates, rather than being written as a single coordinate, or coerced to being an oracle_line.

Lines

oracle_type: oracle_line

Linear features are tagged with this value when reading or writing to or from Oracle Spatial Relational. Both single part and aggregate linear features are supported.

When the object model is being used, aggregates are written out as “multiline” geometry containing several linear elements, just as if the feature had been tagged with oracle_multiline. Any non-linear elements contained in the aggregate are discarded.

Areas

oracle_type: oracle_area

Area features are tagged with this value when reading or writing to or from Oracle Spatial Relational. Both single part and aggregate area features are supported. An area feature may be either a polygon or a donut polygon. Note that checking is done to ensure that the area features adhere to the geometry rules of Oracle Spatial Relational as they are loaded.

When the object model is being used, aggregates are written out as “multipolygon” geometry containing several polygonal elements, just as if the feature had been tagged with oracle_multiline. Any non-polygonal elements contained in the aggregate are discarded.