Features read from DB2 Spatial consist of a series of attribute values and a single geometry.
Features written to the database have the destination table as their feature type, and attributes as defined in User Attributes.
In addition to the generic FME feature attributes that FME Workbench adds to all features (see About Feature Attributes), the DB2 Spatial module adds the format-specific attributes described below:
|
Attribute Name |
Contents |
|
db2_type |
The type of geometric entity stored within the feature. The valid values for the object model are listed below: db2_nil db2_point db2_linestring db2_polygon |
Features read from, or written to, DB2 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. Only uppercase column names are supported.
No Coordinates
db2_type: db2_nil
Features with no coordinates are tagged with this value when reading or writing to or from DB2 Spatial.
Points
db2_type: db2_point
All DB2 Spatial point and multipoint features are read with db2_type set to db2_point.
Lines
db2_type: db2_line
All DB2 Spatial linestring and Multilinestring features are read with db2_type set to db2_line.
Polygons
db2_type: db2_polygon
All DB2 Spatial polygon and multipolygon features are read with db2_type set to db2_polygon. Polygon features include donut polygons with one or more holes.
The following table summarizes all of the db2_type values that are possible with DB2 Spatial geometry, and provides a description of each representation.
|
db2_type |
DB2 Spatial type |
Representation |
|
db2_nil |
Not applicable |
No geometry |
|
db2_point |
POINT |
Single point geometry. fme_geometry = fme_point fme_type = fme_point |
|
MULTIPOINT |
Aggregate containing one or more points. fme_geometry = fme_aggregate fme_type = fme_point |
|
|
db2_line |
LINESTRING |
Single line geometry. fme_geometry = fme_line fme_type = fme_line |
|
MULTILINESTRING |
An aggregate of linestrings. fme_geometry = fme_aggregate fme_type = fme_line |
|
|
db2_polygon |
POLYGON |
A single polygon or donut geometry. fme_geometry = fme_polygon or fme_donut fme_type = fme_polygon |
|
|
MULTIPOLYGON |
An aggregate of simple polygons or donut polygons. fme_geometry = fme_aggregate fme_type = fme_polygon |