SpatialWare Table Representation

The SpatialWare writer requires that every SpatialWare table to which a feature is written be defined within the FME workspace. When reading from SpatialWare, it is not necessary that the source tables be defined. The SpatialWare writer uses the workspace information to automatically create RDBMS tables and indexes, if desired.

SpatialWare tables are specified in the workspace using feature type parameters. All SpatialWare tables also require a column named sw_member, which does not need to be specified. This column will be created on every SpatialWare table automatically. Also, while SpatialWare may have more than one column store geometries, the column named sw_geometry is reserved, and it is the only spatial column where geometries are used in any spatial processing and queries.