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. |