ArcSDEQuerier

Performs queries on an ArcSDE spatial database. The queries can have both a spatial and a nonspatial component.

One query is issued to the ArcSDE database for each feature that enters the transformer.  The results of the query are then output to the output port that matches the table name, if it exists; otherwise, results are output to the OTHER port.

If the Mode parameter is set to Delete, the results of the query are deleted from ArcSDE before they are output from the transformer. If the Mode parameter is set to Update, the features in ArcSDE matching the query feature will be updated with that feature's complete set of attributes.

The query feature defines the geometry which will be used to define the spatial component of the query, unless the search method is SDE_NONE.  In that case, only an attribute query as defined by the WHERE clause will be executed.

An attribute named _table_name will be added to each result feature, specifying which table the result feature came from.

An attribute named _matched_records will be added to each query feature, specifying how many database rows the query matched.

Parameters

ArcSDE Connection

ArcSDE Spatial Query Operators

The complete set of ArcSDE spatial query operators is supported, and each is described below:

Editing Transformer Parameters

Using a set of menu options, transformer parameters can be assigned by referencing other elements in the workspace. More advanced functions, such as an advanced editor and an arithmetic editor, are also available in some transformers. To access a menu of these options, click beside the applicable parameter. For more information, see Transformer Parameter Menu Options.

Transformer Categories

Workflows

FME Licensing Level

FME Professional Edition and above

Search FME Community

Search for samples and information about this transformer on the FME Community.

Technical History

Associated FME function or factory: SDE30QueryFactory