Teradata Spatial and Non-Spatial Feature Representation

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

The feature type of each feature is as defined in its Feature Type Parameters. The geometry object model in Teradata Spatial follows the OGC Simple Features Specification 1.1. For more information, see http://www.opengeospatial.org/.

Features written to the database have the destination table as their feature type, and attributes as defined in the feature type parameters.

In addition to the generic FME feature attributes that FME Workbench adds to all features (see About Feature Type Attributes), this format also adds format-specific attributes (Format Attributes).

Attribute Name

Contents

teradata_type

The type of geometric entity stored within the feature. The valid values for the object model are listed below:

  • teradata_point
  • teradata_multipoint
  • teradata_linestring
  • teradata_multilinestring
  • teradata_polygon
  • teradata_multipolygon
  • teradata_collection
  • teradata_none

Features read from, or written to, Teradata 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-insensitive.

No Coordinates

teradata_type: teradata_none

Features with no coordinates are tagged with this value when reading from Teradata Spatial. Note that when reading or writing attribute-only data tables, the Teradata Non-Spatial reader/writer should be used instead. Note also that this is not a valid OGC type.

Point

teradata_type: teradata_point

Features tagged with this value consist of a single point.

MultiPoint

teradata_type: teradata_multipoint

Features tagged with this value consist of a collection of points.

LineString

teradata_type: teradata_linestring

Features tagged with this value consist of a single line.

MultiLineString

teradata_type: teradata_multilinestring

Features tagged with this value consist of a collection of lines.

Polygon

teradata_type: teradata_polygon

Features tagged with this value consist of a linear polygon or donut.

MultiPolygon

teradata_type: teradata_multipolygon

Features tagged with this value consist of a collection of linear polygons and/or donuts.

GeometryCollection

teradata_type: teradata_geometrycollection

Features tagged with this value consist of a possibly heterogeneous aggregate.

When writing to teradata Spatial, the teradata_type can be manually set to teradata_geometrycollection.

Geometry

teradata_type: teradata_geometry

Although not a valid geometry type on an individual feature, this type may be set for the destination geometry column type to indicate that any geometry is allowable in that column. If the writer directive GENERIC_GEOMETRY is specified at generation time, all destination feature types will have geometry columns of this type. Alternatively, although it will not happen by default, this type can be specified on any one or more destination feature types manually to create generic geometry columns on those specific tables.

Note that although the geometry column is explicitly determined by the user when writing, the reader will attempt to determine the geometry column name and type using the Teradata Spatial metadata tables.