FeatureMerger

将一组特征的属性和/或几何合并到另一组特征上,基于匹配key attribute values and expressions.

Jump to Configuration

Typical Uses

  • Combining attributes and/or geometry from two different streams of features, based on a common key attribute value or expression.

它是如何工作的?

的FeatureMergerreceives two streams of features via its input ports.

请求者:Requestorsare the features that will receive new attributes and/or geometry.

供应商:供应商sprovide attributes and/or geometry to be merged onto the Requestors.

匹配Requestorand供应商are identified according to theJoin Onconfiguration in the parameters dialog. The Join conditions can be simple or complex, using attribute values, constants, functions, or a combination of any of these in expression form. Multiple join conditions can be defined (features must meet all conditions to match).

When aRequestorfinds a matching供应商,属性和/或几何来自供应商are merged onto theRequestor

  • 如果the Requestor already has an attribute that the Supplier also has, the Requestor's original value for that attribute can be preserved or overridden.
  • A single Supplier may be used by many Requestors.
  • 许多供应商可以合并到单个请求者上。
  • 当属性名称冲突时,你可以选择磨her Requestor or Supplier attribute values are maintained by using the解决冲突parameter, and whether null values follow the same behavior by using the忽略nulls.parameter.

Requestorfeatures match供应商每对键(支持表达式)时的功能Join Ontable has the same value for both theRequestorand供应商features.

例子s

Usage Notes

  • For simple joins, theFeatureJoinermay provide better performance than the FeatureMerger. However, the FeatureJoiner only accepts attribute values as keys and not constructed expressions, and does not support list attributes. Additionally, the FeatureMerger is able to (optionally) restrict output to one feature in the case of multiple matching Suppliers, whereas the FeatureJoiner will create multiple features for all matches.
  • For complex joins using SQL syntax, or more than two input feature streams, consider using theInlineQuerier
  • 需要多种特派虫的情况下,考虑使用InlineQuerierinstead.
  • 如果要查询的所有数据已经​​存在于能够的SQL的数据源中,则使用始终更有效SQLCreatororSQLExecutor, which allows the queries and filtering of the data to be executed directly by the database before it enters the FME environment.
  • To perform a join between features already in the workspace and data residing in an external database, consider theDatabaseJoiner
  • To perform a join where the Requestor key is alist attribute, consider using theListBasedFeatureMerger
  • To join features onmatching geometry,考虑一下Matcher。的FeatureMergerdoes not accept geometry as a key.

Choosing a Feature Joining Method

Many transformers can perform data joining based on matching attributes, expressions and/or geometry. When choosing one for a specific joining task, considerations include the complexity of the join, data format, indexing, conflict handling, and desired results. Some transformers use SQL syntax, and some access external databases directly. They may or may not supportlist attributereading and creation.

通常,选择最专用于您需要完成的任务的那个将提供最佳性能结果。如果有多种方式来做(通常是这种情况),则在性能测试备用方法上花费的时间可能是值得的。性能可能会因读取外部表而存在的密钥索引(而不是在工作区中的功能)时变化。

Configuration

Input Ports

输出端口

Parameters

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, seeTransformer 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.

Reference

Processing Behavior

Group-Based

Feature Holding

Yes

Dependencies None
Aliases
History

FME Community

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

Search forall results about the FeatureMergeron the FME Community.

例子s may contain information licensed under the Open Government Licence – Vancouver and/or the Open Government Licence – Canada.