Feature Representation (Spatial Only)

Features read from Netezza Spatial consist of a series of attribute values and geometry. The feature type of each feature is as defined on its DEF line.

Features written to the database have the destination table as their feature type, and attributes as defined by the DEF line.

In addition to the generic FME feature attributes that FME Workbench adds to all features, the Netezza Spatial reader module adds the format-specific attributes described below:

Attribute Name	Contents
netezza_type	The type of geometric entity stored within the feature. The valid values for the object model are listed below: netezza_none netezza_point netezza_linestring netezza_polygon netezza_geometry netezza_geometrycollection

Features read or written by Netezza Spatial modules 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-sensitive.

The following table summarizes netezza_type support in the Netezza Spatial reader and writer.

TABLE MOVED TO Writer Feature Type Properties: Format Parameters.

netezza_type	Database Type(s)	FME Representation
netezza_none	Not applicable	No geometry
netezza_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
netezza_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
netezza_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
netezza_geometry		Allows geometries of any of the specific types (points, multipoints, lines, etc.) to be written to the same table.
netezza_ geometrycollection	GEOMETRYCOLLECTION	An arbitrary collection of geometry.