Esri Geodatabase (ArcSDE Geodb) Reader Parameters
数据库连接
![Closed](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/geodatabase/../Skins/Default/Stylesheets/Images/transparent.gif)
此参数标识要用于连接到企业地理数据库的连接文件的路径名。
A connection file provides the necessary information to connect to the SDE server, such as the server name or the username.
The connection file must be a* .sde.连接文件和适当的格式ile as defined by Esri. Connection files can be created in ArcCatalog.
![Closed](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/geodatabase/../Skins/Default/Stylesheets/Images/transparent.gif)
Check this option to override the User and Password from the connection file. Overriding credentials is required for Connection Files that do not have saved credentials.
笔记:如果连接文件使用OS身份验证,则忽略此参数。
![Closed](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/geodatabase/../Skins/Default/Stylesheets/Images/transparent.gif)
Enter the username and password to access the database, user account, or wherever authentication is required.
![Closed](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/geodatabase/../Skins/Default/Stylesheets/Images/transparent.gif)
Select this parameter to override the version provided in the connection file.
![Closed](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/geodatabase/../Skins/Default/Stylesheets/Images/transparent.gif)
The name of the SDE version to which FME connects. If not specified, FME connects to the versionsde.default., 或同等学历。此参数仅在处理版本化的表或图层时适用。
![Closed](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/geodatabase/../Skins/Default/Stylesheets/Images/transparent.gif)
要读取的数据集的历史标记名称(用于已启用归档的多版本中的数据库)。请注意,版本名称区分大小写,并且历史数据是只读的。
![Closed](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/geodatabase/../Skins/Default/Stylesheets/Images/transparent.gif)
要读取的已归档数据集的特定日期和时间(用于具有启用归档的多版本数据库)。请注意,历史数据是只读的。
约束
![Closed](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/geodatabase/../Skins/Default/Stylesheets/Images/transparent.gif)
指定是否保留表格限定符。数据库中的表的全名是格式:
<前缀>。
根据数据库格式,prefixcan be
Selecting this parameter indicates that the reader should return the table name without any prefixes. This is useful, for example, when creating a workspace that will be passed on to another organization using the same table names, or performing a translation to another database format but with a different user name.
在工作区生成期间选择此参数时,源特征类型将是没有任何前缀的表名;否则,它们将包含所有者名称作为前缀。建议您在生成工作区后不会更改此参数,因为没有将功能成功传递给Writer(因为编写器预期具有不同名称的特征类型)。
笔记:即使选择此参数,如果表由当前用户以外的用户拥有,则不会删除前缀。这是为了确保读者会找到正确的表格。
![Closed](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/geodatabase/../Skins/Default/Stylesheets/Images/transparent.gif)
指定数据库连接后,单击“浏览”按钮以选择导入的表。系统从数据库编译表格时出现一个连接窗口。
Once the table list appears, you can select one or more tables, and then click OK to dismiss the window. The table name(s) will appear in the Table List field in the parameter box.
![Closed](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/geodatabase/../Skins/Default/Stylesheets/Images/transparent.gif)
Enter any SQL where clause that constrains the attributes of the layers selected in the layer list (for example, NUMLANES=2).
![Closed](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/geodatabase/../Skins/Default/Stylesheets/Images/transparent.gif)
指定是否只转换包含某种几何图形的功能。
![Closed](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/geodatabase/../Skins/Default/Stylesheets/Images/transparent.gif)
Specifies whether or not to resolve the domain code found in feature classes and tables into the domain value.
This means that when an attribute of a feature has a coded value domain associated with it, another attribute will also be added that represents the textual description of the coded attribute. The new attribute will be
![Closed](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/geodatabase/../Skins/Default/Stylesheets/Images/transparent.gif)
Specifies whether or not to resolve the subtype field values found on feature classes and tables into the name of the actual subtype.
![Closed](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/geodatabase/../Skins/Default/Stylesheets/Images/transparent.gif)
Specifies whether to read the network portion of network features. When checked, junctions will be read as points (geodb_point) and edges will be read as lines (geodb_polyline). Additionally, none of the network related attribution will be supplied on the features. Checking this option speeds up reading of network features significantly.
![Closed](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/geodatabase/../Skins/Default/Stylesheets/Images/transparent.gif)
Determines whether to read relationship features present in a source dataset. When this parameter is checked, feature types containing simple relationships will be ignored, and feature types containing attributed relationships will be treated as non-spatial tables. When this parameter is unchecked, relationships will be read normally as either simple or attributed. The speed of reading features is vastly improved if relationships are ignored.
![Closed](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/geodatabase/../Skins/Default/Stylesheets/Images/transparent.gif)
确定是否应拆分复杂边缘功能。当拆分时,在元素级别而不是特征级别读取复杂边缘功能。元素级别表示几何网络的逻辑视图。结果,没有丢失网络连接信息。
笔记:有关每个FME功能存储此选项时的属性的信息,请参阅ESRI地理数据库读卡器/编写器> Reader概述> Reader关键字> Split_Complex_edges。
![Closed](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/geodatabase/../Skins/Default/Stylesheets/Images/transparent.gif)
Specifies whether or not to split multi-part annotations into separate features for each 'element' when reading. If checked, a single feature for each element (usually a word) in a multi-part annotation will be produced on reading, resulting in feature-specific attributes such as angle and text position being stored according to the location of each element. If the parameter is unchecked, multi-part annotations will be read normally, as a single feature storing a single set of attributes describing the positioning of the text.
![Closed](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/geodatabase/../Skins/Default/Stylesheets/Images/transparent.gif)
This parameter provides a mechanism for specifying an arbitrarily complex search feature. It works with the搜索方法定义空间约束的参数。
范围 |
内容 |
---|---|
[ |
定义查询功能几何的坐标列表。 笔记:值必须是空间分隔的。例如,除非您用空格替换逗号,否则以下坐标对将失败: -97.4055,30.1331 -97.2340,30.1555 -97.2161,29.9840 -97.3995,30.0943 |
![Closed](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/geodatabase/../Skins/Default/Stylesheets/Images/transparent.gif)
This parameter specifies the type of spatial relationship the query features must have with the搜索功能parameter orUse Search Envelopeparameter, whichever is used, in order to be returned.
- 什么时候搜索功能选中,没有默认值,因此必须指定此参数。
- 什么时候Use Search Envelope选中,默认值是金砖_ENVELOPE对于矢量工作区,geodb_area_intersect.用于向量FME对象应用程序,和金砖_ENVELOPE对于所有与栅格相关的翻译。
- 阅读栅格时,金砖_ENVELOPEis the only valid value and the搜索功能parameter is not supported.
价值
的价值搜索方法can be one of the following:
范围 |
内容 |
---|---|
金砖_ENVELOPE |
Features must be within the envelope of the feature. |
geodb_envelope_by_grid. |
功能必须位于功能的信封内,并以网格顺序返回。 |
geodb_common_point. |
功能必须具有查询功能的常见点。 |
geodb_line_cross. |
功能必须跨越查询功能。 |
金砖_COMMON_LINE |
功能必须具有带查询功能的公共线段。 |
金砖_CP_OR_LC |
功能必须具有共同点或线路交叉。 |
geodb_ai_or_et. |
Features must intersect or must share an edge. |
geodb_area_intersect. |
功能必须与查询功能相交。这可以检索包含在查询功能的区域或与之相交的区域,线性和点特征。 |
金砖_AI_NO_ET |
Features must intersect but must not have any edge touching with the query feature. |
geodb_contained_in. |
返回的功能包含查询功能。当它包装查询功能时,将返回一个候选功能。如果候选功能是一行,则如果其路径与查询功能重合,则返回它。如果查询功能是一个点,并且候选特征不是一个区域,则如果其顶点之一与查询特征相同,则将返回候选功能。 |
geodb_contains. |
The returned feature is contained by the query feature. If both the features are linear features, then the returned feature must lie on the search feature’s path. Point features that lie on a search feature vertex are also returned. |
SDE_CONTAINED_IN_NO_ET |
功能必须包含在查询功能中,而不是任何边缘触摸。 |
geodb_contains._NO_ET |
Features must contain the query feature but must not share any edge. |
geodb_point_in_poly. |
Returned feature must be an area feature that contains the first coordinate of the search feature. |
金砖 |
The returned feature must be spatially identical to the query feature. |
For more information on these search methods, see Esri technical documentationIspatialFilter接口。
![Closed](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/geodatabase/../Skins/Default/Stylesheets/Images/transparent.gif)
指定执行底层搜索的顺序:
- OPTIMIZE: Let SDE decide which to perform first
- spatial_first:首先执行空间查询
- ATTRIBUTE_FIRST: Perform tabular query first (when performing a WHERE clause search)
![Closed](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/geodatabase/../Skins/Default/Stylesheets/Images/transparent.gif)
笔记:此参数仅适用于支持版本控制的ArcSDE版本。它对矢量特征仅有效。
Specifies the name of a child version to create using the version specified by交易版本as the parent version. All tables will then be read from this (child) version rather than from the parent version.
指定此参数时读取的所有表必须是多版本的,并具有当前用户的读取,插入,更新和删除权限。这是因为此参数旨在在验证父版本中的数据副本时使用,以便打算修改子版本并可能与返回父版本。该版本将被创建为公共版本,并且给予版本的描述Safe Software Created Version。
如果儿童版本名称指定已存在的版本,将输出错误。子版本将由指定的用户拥有Username;因此,如果所有者被指定为此参数值的一部分,则所有者必须与其相同Username。如果翻译中止,则将删除创建的子版本。
默认情况下,此参数留空,因此不会创建子版本。
笔记:版本名称区分大小写,因此为此参数提供的值也区分大小写。
![Closed](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/geodatabase/../Skins/Default/Stylesheets/Images/transparent.gif)
选中后,将仅读取两个版本之间的差异而不是读取所有数据。差异被读为差异功能,以自基准版本自基准版本以来在连接版本上发生的插入,更新和删除。看看Difference Features sectionfor the structure of difference features.
为了读取交易版本差异,读取的表/要素类必须被注册为版本化并进行历史版本差异,这些表必须另外启用归档。
什么时候comparing two transactional versions, the baseline will actually be the common ancestor of both versions to avoid conflicts where the same record was changed in both versions.
基线版本
使用此参数选择要在阅读版本差异时比较的版本类型:
- 当连接版本是事务关系时,必须使用事务版本。
- 当连接版本历史时,应使用历史版本。
- 使用事务版本的历史版本进行比较将导致错误。
基线交易版本
Select a specific transactional version to serve as the baseline for difference reading.
基线历史记录
选择历史标记以作为差异读数的基线。
基线历史日期和时间
Select a specific date and time to serve as the baseline for difference reading.
Schema Attributes
![Closed](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/geodatabase/../Skins/Default/Stylesheets/Images/transparent.gif)
使用此参数在创建工作空间时会在Workbench中公开格式属性:
- In a dynamic scenario, it means these attributes can be passed to the output dataset at runtime.
- 在具有多个特征类型的非动态方案中,方便使用此参数公开其他属性。例如,如果您有十种特征类型并且希望在每个功能类型中公开相同的属性,则更容易定义一次,它比在工作区中单独设置每个要素类型。
![Closed](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/geodatabase/../Skins/Default/Stylesheets/Images/transparent.gif)
此参数控制地理数据库别名的方式。
- 没有任何:Aliases are ignored.
- 用别名替换属性名称:(Only applicable when adding a Reader.) Attributes on feature types will be named for their aliases rather than their official names. Ageodb_feature_class_aliasattribute will be included on each feature. Use this mode when the target format should create feature types using the aliases as attribute names.
- Expose Aliases as Metadata Attributes:对于每个属性读取,一秒
_alias attribute will be added that stores the alias for the attribute in question. Ageodb_feature_class_aliasattribute will also be included on each feature. Use this mode when the target format is Geodatabase and the aliases should be preserved during feature class and table creation.
![Closed](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/geodatabase/../Skins/Default/Stylesheets/Images/transparent.gif)
使用最小和最大X和Y参数,定义将用于过滤输入功能的边界框。只返回与边界框交叉的功能。
如果搜索信封的所有四个坐标指定为0,则将禁用搜索信封。
![Closed](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/geodatabase/../Skins/Default/Stylesheets/Images/transparent.gif)
选择后,此参数删除在搜索信封外部读取的导入功能的任何部分。
下面的示例说明了搜索信封的结果剪辑搜索信封未选择(设置为否),选择(设置为是)。
- No: Any features that cross the search envelope boundary will be read, including the portion that lies outside of the boundary.
- 是:跨越搜索信封边界的任何功能将在边界处剪切,只会读取边界内部的部分。潜在的功能剪辑搜索信封function is an intersection; however, when剪辑搜索信封is selected, a clipping operation is also performed in addition to the intersection.