Oracle Spatial Object Feature Representation

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

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

Attribute/Trait Name

Contents

oracle_type

This attribute stores the type of geometric entity stored within the feature. The valid values are:

oracle_nil
oracle_point
oracle_line
oracle_area
oracle_arc
oracle_rectangle
oracle_circle
oracle_solid
oracle_surface
oracle_multipoint
oracle_multiline
oracle_multipoly
oracle_multisolid
oracle_multisurface
oracle_collection

oracle_srid

For the Oracle Spatial Object reader, this attribute is set to the SRID value of the geometry being read. If the SRID value is null, oracle_srid is not set on the feature. The SRID value on the first feature read is used to look up a coordinate system in FME, which is then set on all the subsequent features read, even if their SRID values conflict with the first SRID value.

For the Oracle Spatial Object writer, oracle_srid specifies the SRID of the geometry being written on a per-feature-type (table) basis. It overrides the coordinate system set on the writer.

This attribute is not used by the Oracle Spatial Object writer when writing vector geometry.

CoordSys

This trait stores the FME coordinate system name that corresponds to the Oracle SRID. This is only present when Handle Multiple Spatial Columns is enabled.

Features read from, or written to, Oracle Spatial also have an attribute for each column in the database table. The feature attribute name will be the same as the source or destination column name. The attribute and column names are case-sensitive.