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.


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.

Defining Values

There are several ways to define a value for use in a Transformer. The simplest is to simply type in a value or string, which can include functions of various types such as attribute references, math and string functions, and workspace parameters. There are a number of tools and shortcuts that can assist in constructing values, generally available from the drop-down context menu adjacent to the value field.

Dialog Options - Tables

Transformers with table-style parameters have additional tools for populating and manipulating values.

FME Licensing Level

FME Professional Edition and above

FME Community

The FME Community is the place for demos, how-tos, articles, FAQs, and more. Get answers to your questions, learn from other users, and suggest, vote, and comment on new features.

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