ArcSDEQuerier

类别

Workflows

在ArcSDE Spatial数据库上执行查询。查询可以具有空间和非私人组件。

为ArcSDE数据库发出一个查询，以查找进入变压器的每个功能。然后，查询的结果将输出到与表名匹配的输出端口，如果存在，则存在;否则，结果将输出到其他端口。

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服务器名称。

The instance to which FME is to connect. The instance can also be of the form port:, which is usually port:5151 (you may have to confirm this with your System Administrator).

This field identifies the SDE database from which features are retrieved. In SDE, the dataset is referred to as the Database. This field is required regardless of the underlying RDBMS of the SDE. Some RDBMSes, such as Oracle, do not require a value, whereas others, such SQLServer, do. For databases that do not require the value, the field will be ignored.

访问数据库的用户名和密码。这会覆盖ODBC DSN设置。

FME连接的SDE版本。版本必须已存在，当前用户必须设置权限，以便它可以访问该版本。如果未使用version_name指令，则fme尝试连接到sde.default。如果没有SDE架构，则FME然后尝试连接到DBO.Default。如果名称未被版本的所有者前缀，则假设所有者是当前用户。此设置仅适用于处理版本化表时。

If the Remove Table Qualifier parameter is set to Yes, then user names will not be included in table names when they are not required.

如果属性的表名parameter is blank, the set of tables to query is defined by the Tables parameter, which is set in the "Select Tables" panel. Alternatively, if the Table Name in Attribute parameter is not blank, the tables to query are read from the specified attribute in the input features. In this case, the tables to query should be specified as a colon-separated list.

ArcSDE空间查询运算符

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

No spatial filtering is done. Any features matching the Where Clause parameter are output, and if no where clause was specified, then all features from each target table are output.

The envelope of the output feature overlaps or touches the envelope of the search feature.

The search feature shares at least one common point with the output feature.

搜索功能和输出功能具有相交的线段段。

搜索功能和输出功能共享一个或多个公共线段。

搜索功能和输出功能具有相交或具有共同点的线段。

The search feature and the output area feature edge touch (ET) or their areas intersect (AI).

The search feature and the output feature's area intersect.

The output feature and search feature have intersecting areas with no edge touching. One feature is therefore contained in the other.

搜索功能包含在输出的壮举ure. For area features, this is clear. If search feature is a line, then a linear feature will be output when the search feature path is included in output feature. If search feature is a point, then the search feature will be one of the output features vertices.

输出功能由搜索功能包含。如果两个功能都是线性功能，则输出功能必须位于搜索功能的路径上。还输出位于搜索功能顶点上的点功能。

返回的功能必须是不触摸或与搜索功能共享顶点的区域功能。返回的功能包含搜索功能。

The returned feature is contained within the search feature. The returned features cannot touch the edge of, or share a vertex with, the search feature.

The returned feature contains the first point of the search feature.

The returned feature has the same feature type and geometry. This is used to find duplicate data.

搜索顺序参数控制执行搜索的方式。如果指定了优化，则SDE引擎会决定如何执行搜索。如果首先指定属性，则首先执行搜索的属性部分，然后在由属性集产生的集合上执行空间分量。如果指定了空间，则首先执行空间搜索，然后对结果集执行属性搜索。如果优化设置做出错误的选择，这很有用，并且您希望强制搜索以不同的顺序执行。

  • Result Attributes Only: result feature attributes are based solely on the query results.
  • 如果冲突：结果要素属性，请保持查询属性是查询结果和查询功能的属性的组合。如果存在冲突，则从查询功能中取出属性值。
  • Keep Result Attributes if Conflict: result feature attributes are a combination of both the query results and query feature's attributes. If there is a conflict, attribute values are taken from the query results.
  • Result Geometry Only: result feature geometry is taken from the query results.
  • Query Geometry Only: result feature geometry is taken from the query feature.
  • 聚合查询和结果几何：结果功能几何是来自查询功能的几何图形的聚合，后跟查询结果的几何图形。

Specifies whether or not duplicate features will be output from the transformer. If the Mode parameter is set to Update, this parameter also specifies whether duplicate updates will be performed.

指定是否应计算查询和结果几何形状之间的关系。参考SDE30QueryFactory factory documentation想要查询更多的信息。

Specifies whether a connection to SDE will remain open until the process running FME finishes. Open connections are shared by SDE Readers, SDE Writers and ArcSDEQuerier transformers when they have the same connection parameters. A non-persistent connection will be closed as soon as possible after all clients have finished with it.

A persistent connection is useful for workspaces that are published using FME Server.

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, clickbeside the applicable parameter. For more information, see变换器参数菜单选项。

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.

Using the Text Editor

文本编辑器提供了一种方便的方法来构建来自各种数据源的文本字符串（包括正则表达式），例如属性，参数和常量，其中结果直接在参数内使用。

Text Editor

Using the Arithmetic Editor

算术编辑器提供了一种方便的方法来构建来自各种数据源的数学表达式，例如属性，参数和特征函数，其中结果直接在参数内使用。

Arithmetic Editor

条件值

Set values depending on one or more test conditions that either pass or fail.

Parameter Condition Definition Dialog

Content

表达式和字符串可以包括许多函数，字符，参数等。

When setting values - whether entered directly in a parameter or constructed using one of the editors - strings and expressions containing String, Math, Date/Time or FME Feature Functions will have those functions evaluated. Therefore, the names of these functions (in the form @<function_name>）不应用作文字字符串值。

String Functions

 这些功能操纵和格式化字符串。

特殊的角色

 文本编辑器中提供了一组控制字符。

Math Functions

 Math functions are available in both editors.
Date/Time Functions 文本编辑器中提供日期和时间函数。

数学运营商

 这些运算符可在算术编辑器中使用。

FME Feature Functions

 These return primarily feature-specific values.

FME Parameters

 FME and workspace-specific parameters may be used.
Creating and Modifying User Parameters Create your own editable parameters.

Dialog Options - Tables

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

行重新排序

启用后，单击行项目后。选择包括：

  • Add a row
  • Remove a row
  • 移动当前排一个
  • 将当前行移动一个
  • Move current row to top
  • Move current row to bottom

Cut, Copy, and Paste

启用后，单击行项目后。选择包括：

  • 剪裁 - 删除并复制到剪贴板
  • 将行复制到剪贴板
  • Paste a row from the clipboard

切割，复制和粘贴可以在变压器或变压器之间使用。

Filter

 Start typing a string, and the matrix will only display rows matching those characters. Searches all columns. This only affects the display of attributes within the transformer - it does not alter which attributes are output.

进口

 导入使用从数据集读取的一组新属性填充表。特定应用在变压器之间变化。

Reset/Refresh

通常将表重置为其初始状态，并且可以提供其他选项以删除无效条目。行为在变压器之间变化。

笔记：并非所有变压器都提供所有工具。

FME Community

FME社区是演示亚搏国际在线官网，TOS，文章，常见问题和更多的地方。获取您的问题的答案，从其他用户学习，并建议，投票和评论新功能。

Search for samples and information about this transformer on theFME Community。