Tableau Data Extract (TDE) 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 in the feature type dialog.

In addition to the generic FME feature attributes that FME Workbench adds to all features (see About Feature Type 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.