esri geodatabase(个人geodb)编写器功能类型参数
To access feature type parameters,click the gear iconon a feature type in the workspace to open the要素类型参数编辑器.To always display the editor in Workbench,you can select View > Windows > Parameter Editor.
General
所有特征类型共享相似的通用参数,including the Feature Type Name,读写器名称,and Geometry.
在大多数编写器功能类型参数对话框中,您还可以控制动态模式定义。Some database formats accept a Table Qualifier prefix on the output table feature type.
See编辑编写器功能类型更多信息。
Table Settings: General
![Closed](http://www.baooytra.com/docs/fme/2017.1/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
This parameter lets the user specify how features will be written into the destination table.Supported feature operations are:
- Insert:使用功能上的属性将行附加到目标表上。
- Update:使用功能上的属性更新现有表列。A selection method must be specified in the Row Selection group.
- Delete:Delete existing table rows.A selection method must be specified in the Row Selection group.
- fme_db_operation:The feature operation will be determined by the attributefme_db_operationon each input feature.A selection method must be specified in the Row Selection group.The value offme_db_operation将按以下方式处理:
- If the value is null,empty,or missing,it will be treated as Insert.
- 接下来将匹配该值以插入,Update,and Delete,case insensitively.
- If there is no match,此功能将被拒绝。
- If there is a match,将对该功能执行匹配的功能操作。
提示:Thefme_db_operation当特性操作设置为时,特性现在将导致特性拒绝。Insert,更新,orDelete.This behavior differs from previous versions of FME.
More information on功能操作.
![Closed](http://www.baooytra.com/docs/fme/2017.1/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
Controls how the feature type handles destination tables or lists.These options are available:
- Use Existing:Write to an existing table or list.如果目标表/列表不存在,the translation will fail.
- Create If Needed:Create destination table/list if it does not exist.
- Drop and Create:删除目标表/列表(如果存在),然后创建它。The writer will drop and re-create the table before writing any features to it.Tables will be overwritten when the first input feature is processed.If no features are sent to a feature type,then the corresponding table will not be overwritten.
- Truncate Existing:(此选项不适用于所有格式。)如果目标表/列表不存在,the translation will fail.Otherwise,delete all rows from existing table or list.
![Closed](http://www.baooytra.com/docs/fme/2017.1/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
When updating features,users have a choice to update,or skip,their spatial column(s).Possible options are:
- Yes:The spatial column(s) specified by the user will be updated.IFMENulls will be written as null values and replace existing spatial values.
- No:No spatial columns will be updated.
行选择
When inserting into a table,Row Selection is ignored.When updating and deleting from a table,a condition needs to be specified for selecting which rows to operate on.This parameter group offers two methods to construct the selection condition:
![Closed](http://www.baooytra.com/docs/fme/2017.1/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
The columns specified in the corresponding column picker dialog will be used for matching destination rows.All matching rows will be selected for update or delete.If any feature attributes corresponding to the specified match columns contain null or missing values,此功能将被拒绝。
![Closed](http://www.baooytra.com/docs/fme/2017.1/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
This parameter opens aWHERE Clause Builder.You can also type a WHERE clause inline,without launching the Builder.It is optional to start the clause with the word哪里.
The WHERE Clause Builder makes it easy for users to reference feature attribute values,目标表列,并调用FME功能。The WHERE clause is first evaluated as an FME expression,before being passed onto the destination database.
如果WHERE条款不正确或其评估导致失败,the translation will fail.Otherwise,if the WHERE clause passes FME evaluation but it is SQL invalid,the feature will be rejected or the translation will fail.
For advanced users,conditional FME expressions created through the Conditional Value editor can be used to create WHERE clauses.
提示:You can set the WHERE Clause to an attribute.这支持工作区迁移和涉及亚搏在线fme_where.(Direct support forfme_wherehas been deprecated.) To advanced users who are accustomed to usingfme_where,if Feature Operation is set to Update,Delete,orfme_db_operation,anfme_whereattribute that conflicts with Match Columns or WHERE Clause will result in feature rejection.
Table Creation Parameters
![Closed](http://www.baooytra.com/docs/fme/2017.1/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
要素类所属的要素数据集的名称。
![Closed](http://www.baooytra.com/docs/fme/2017.1/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
This optional field determines whether or not the dataset contains z coordinates.Valid values are Yes,No,or Blank.The default is Blank which will take the value from the table parameter.
![Closed](http://www.baooytra.com/docs/fme/2017.1/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
此可选字段指定功能是否包含度量值。Valid values are Yes,No,or Blank.The default is Blank which will take the value from the table parameter.
原产地和规模
![Closed](http://www.baooytra.com/docs/fme/2017.1/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
The coordinates of the X false origins for all feature classes and all feature datasets.This is used as an offset so that coordinate data is stored as positive integers,which allows a range from 0 to 2147483647 (so if the X origin is set below 0,then the maximum value will also drop,and vice versa).By default,the values for the false origins are set to 0.This is only used when creating new feature classes.
![Closed](http://www.baooytra.com/docs/fme/2017.1/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
The coordinates of the Y false origins for all feature classes and all feature datasets.This is used as an offset so that coordinate data is stored as positive integers,which allows a range from 0 to 2147483647 (so if the Y origin is set below 0,then the maximum value will also drop,and vice versa).By default,the values for the false origins are set to 0.This is only used when creating new feature classes.
![Closed](http://www.baooytra.com/docs/fme/2017.1/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
Note:This parameter is only used when creating new feature classes.It is not used by the File-based Geodatabase writer,as default values are used for the domain and resolution.
所有要素类和所有要素数据集的从世界单位到整数系统单位的比例转换系数。用于指定存储xy坐标时要保持的精度级别,因为所有坐标都存储为整数。
The x,y scale is the inverse of the spatial reference's XY Resolution.The resolution is defined as the minimum unit in map units that separate unique x values and unique y values for feature coordinates.
![Closed](http://www.baooytra.com/docs/fme/2017.1/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
Note:Used only when creating new feature classes.
所有要素类和所有要素数据集的Z假原点坐标。This is used as an offset so that coordinate data is stored as positive integers,which allows a range from 0 to 2147483647 (so if the Z origin is set below 0,then the maximum value will also drop,and vice versa).
By default,the values for the false origins are set to 0.
![Closed](http://www.baooytra.com/docs/fme/2017.1/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
Note:Used only when creating new feature classes.
所有要素类和所有要素数据集的从世界单位到整数系统单位的比例转换系数。This parameter is used to specify the level of precision to keep when storing Z coordinates,因为所有坐标都存储为整数。
Depending on the scale,它会更改存储的坐标的精度。For example,if you have the coordinate (5.354,566.35) and you set the Z Scale to 100,then the coordinate stored will be (5.35,566.35).
The default value is 100.
![Closed](http://www.baooytra.com/docs/fme/2017.1/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
The minimum measures value possible.This is used as an offset because measure data is stored as positive integers (0 to 2147483647) relative to the measures origin.
![Closed](http://www.baooytra.com/docs/fme/2017.1/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
所有要素类从世界单位到整数系统单位的比例转换系数。
![Closed](http://www.baooytra.com/docs/fme/2017.1/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
Specifies which map units should be used when creating a new annotation feature class.
Advanced
![Closed](http://www.baooytra.com/docs/fme/2017.1/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
Specifies the name of the column containing object IDs for the current table or feature class.If the value conflicts with a user attribute,then the writer will change the value for this field (by appending a numeric suffix) and log a warning.
![Closed](http://www.baooytra.com/docs/fme/2017.1/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
Specifies the alias for the object IDs column for the current table or feature class.The alias is used in ArcMap (and possibly in other ArcGIS 亚搏在线娱乐平台products) when viewing data;the object ID column will be labeled by its alias.
![Closed](http://www.baooytra.com/docs/fme/2017.1/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
Specifies the name of the column containing the shape data for features in the current feature class.This applies only to feature classes.If the value conflicts with a user attribute,then the writer will change the value for this field (by appending a numeric suffix) and log a warning.
![Closed](http://www.baooytra.com/docs/fme/2017.1/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
Specifies the alias for the shape data column.This applies only to feature classes.When viewing data in ArcMap (and possibly in other ArcGIS 亚搏在线娱乐平台products),the shape data column will be labeled by its alias.The default value is SHAPE.
![Closed](http://www.baooytra.com/docs/fme/2017.1/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
Specifies the configuration keyword.有关更多详细信息,请参阅ARCGIS文档。
![Closed](http://www.baooytra.com/docs/fme/2017.1/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
为整个翻译设置全局网格1大小。For the Enterprise Geodatabase writer,the default is 1000.This directive is only used when creating new feature classes.