Feature Representation

Features written to a TDE table consist of a series of attribute values. Features written to the TDE file have the output TDE file base name as their feature type, and attributes as defined on the feature type properties.

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

TDE Attribute Type Mapping

TDE Attribute Type	FME Attribute Type
integer	fme_int32
integer	fme_uint32
integer	fme_int64
integer	fme_int16
integer	fme_uint16
boolean	fme_boolean
integer	fme_int8
integer	fme_uint8
string	fme_buffer
string	fme_xml
string	fme_json
string	fme_binarybuffer
string	fme_varbinary(width)
string	fme_binary(width)
datetime	fme_datetime
date	fme_date
string	fme_time
double	fme_real64
double	fme_real32
charstring	fme_varchar(width)
charstring-	fme_char(width)
string	fme_uint64
double-	fme_decimal(width, decimal)

TDE Attributes

Field Type	Contents
tde_type	The type of geometric entity stored within the feature. The valid values are: tde_none tde_point tde_line tde_polygon

Geometry

tde_type	Description
tde_none	FME feature with no geometry
tde_point	2D point feature
tde_line	2D linear feature
tde_polygon	2D simple polygon or donut feature, 2D feature with multiple polygon geometries

tde_none

Features with no geometry are tagged with this value.

tde_point

Points will be drawn normally.

tde_line

Lines will be drawn normally. Arcs generated from key points and/or radius will be stroked to produce reasonable vertices.

tde_polygon

Polygons with all vertices specified will be drawn normally. Circles and ellipses generated from radius and position parameters will be stroked to produce reasonable vertices. Donuts with concentric boundaries should be drawn normally, but donuts with multiple boundaries/holes on the same level (such as an “8” shape) will likely not render properly due to how Tableau interprets sequences of vertices. Homogeneous collections of polygons will be split into their components to prevent unpredictable rendering, but this does not improve the rendering of donuts.

Geometry Attributes

Attribute Name	Contents
spatial_geometry_id	An integer identifying which feature is being drawn. All vertices with the same feature ID will be connected.
spatial_geometry_order	An integer identifying the drawing order of the geometry. Consecutive vertices with the same ID will be connected. When using the Polygon mark type, lines will be closed between their first and last vertex and filled. Points will not appear when using the Polygon mark type.
spatial_latitude	The latitude of the vertex in decimal format.
spatial_longitude	The longitude of the vertex in decimal format.