Oracle Spatial Writer功能类型参数
To access feature type parameters, click the gear iconon a feature type in the workspace to open theFeature Type Parameter Editor。要始终在WorkBench中显示编辑器,可以选择“查看”>“Windows”>“参数编辑器”。
All feature types share similar General Parameters. This includes Name and Writer Name. From here, you can also controlDynamic Properties。
These parameters apply only to a selected feature type, not to the entire writer.
Tip:如果此处列出的功能类型参数与Writer-Level参数冲突,则将忽略Writer参数,并将使用此功能类型参数。
Table Settings: General
![关闭](http://www.baooytra.com/docs/fme/2017.0/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:Append rows onto the destination table using attributes on features.
- 更新:更新existing table columns using attributes on features. A selection method must be specified in the Row Selection group.
- 删除:删除existing table rows. A selection method must be specified in the Row Selection group.
- fme_db_operation:功能操作将由属性确定fme_db_operation.on each input feature. A selection method must be specified in the Row Selection group. The value offme_db_operation.will be processed as follows:
- If the value is null, empty, or missing, it will be treated as Insert.
- The value will next be matched to Insert, Update, and Delete, case insensitively.
- 如果没有匹配,则将拒绝该功能。
- 如果存在匹配,则将在该功能上执行匹配的功能操作。
Tip:Unlike in previous versions of FME, thefme_db_operation.attribute will now cause feature rejection when Feature Operation is set toInsert,更新, or删除。此行为与以前版本的FME不同。
More information on功能操作。
![关闭](http://www.baooytra.com/docs/fme/2017.0/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:If destination table/list does not exist, the translation will fail.
- Create If Needed:Create destination table/list if it does not exist.
- Drop and Create:Drop destination table/list if it exists, and then create it.
- Truncate Existing:(This option is not available for all formats.) If destination table/list does not exist, the translation will fail. Otherwise, delete all rows from existing table or list.
![关闭](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
当更新功能,用户可以选择乌利希期刊指南ate, 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:不会更新空间列。
Row Selection
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:
![关闭](http://www.baooytra.com/docs/fme/2017.0/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, the feature will be rejected.
![关闭](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
This parameter opens aWHERE子句生成器。You can also type a WHERE clause inline, without launching the Builder. It is optional to start the clause with the wordWHERE。
The WHERE Clause Builder makes it easy for users to reference feature attribute values, destination table columns, and invoke FME functions. The WHERE clause is first evaluated as an FME expression, before being passed onto the destination database.
If the WHERE clause is incorrect or if its evaluation results in failure, 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.
Tip:You can set the WHERE Clause to an attribute. This supports workspace migration and existing workflows involvingfme_where。(直接支持fme_wherehas been deprecated.) To advanced users who are accustomed to usingfme_where如果要设置要更新,删除或fme_db_operation., anfme_where与匹配列属性冲突or WHERE Clause will result in feature rejection.
表创建参数
![关闭](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
指定要附加到用于创建输出表的Oracle创建表查询的其他参数(例如,表分配特征)。例如,要指定表空间,存储子句和表的注释,可以附加以下子句:
TABLESPACE myTableSpace
存储(初始50k);
COMMENT ON TABLE myTable IS ‘My new table’;
![关闭](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
指定该图层的尺寸,目前可能为2或3。
![关闭](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
Directs the writer to write measures to the destination table. When this parameter is set to yes and the incoming feature does not have any measures, then null values are written. This parameter applies when writing to new tables.
默认值为。
Extents and Tolerances
![关闭](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
Minimum X/Y/Z Oordinate and Measure Value
最小x,y,z和数据集中预期的值。如果存在少于此值的任何X / Y / Z /测量值,则仍将写入数据。但是,查询其范围之外的空间索引将产生未定义的结果。有关最佳的空间搜索性能,此值应尽可能接近真实最小X / Y / Z /测量值。
最大X / Y / Z oords和测量值
The maximum x, y, z, and measures values expected in the dataset. If any x/y/z/measures values are present which are greater than this value, the data will still be written. However, querying the spatial index will produce undefined results. For best spatial search performance, this value should be as close to the true maximum x/y/z/measures value as possible.
X / Y / Z o等品和措施的比较耐受性
This specifies the comparison tolerance for the x, y, z, and measures values. Values in x/y/z/measures that are closer than this value are considered equal.
表设置:空间
![关闭](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
When writing to the object model, the Oracle Spatial Object writer will create a column to hold the geometry. This column is typically calledGEOM,但可以使用此参数更改为任何其他名称。
Note that this parameter merely specifies a default value for the geometry column. If the table already exists in the Oracle database, then the geometry column will be chosen from those defined on the existing table.
![关闭](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
Specifies the spatial referencing information for the geometry in the table. It is specified as an integer, and corresponds to the spatial reference identifier (SRID) column in the global tablemdsys.cs_srs.。
All geometry within a given table must have the same spatial referencing. If the target table exists in the database and the value specified for Spatial SRID does not match the value contained inUSER_SDO_GEOM_METADATA, the metadata's SRID will be used in place of the specified SRID.
如果未指定SRID,则将使用SRID字段的空值创建表。
Spatial Index
![关闭](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
Indicates whether or not spatial indexes are to be created as part of the data load. The valid choices for the object model are yes and no.
![关闭](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
指定是否删除表的现有空间索引。
- 是:将删除表的现有空间索引。然后将创建一个新的空间索引。
- No: The table being written already contains an index, so no spatial index will be created.
![关闭](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
指定将在表上创建的空间索引的名称。如果未指定此参数,将基于数据库序列和正在写入的表的名称创建空间索引名称。
![关闭](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
Specifies the tessellation level used to create the spatial index for the layer. The larger the number, the longer spatial index creation will take by the finer the granularity of the index.
The range is any integer between 1 and 64. The default is 0 is given, so that no levels will be specified when the index is created. Depending on the version of the Oracle Spatial database being written to, this may force it to use RTree indexing instead of fixed or hybrid indexing.
If using fixed or hybrid indexing, a positive integral value must be specified.
![关闭](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
This specifies the number of variable-sized tiles used (per geometry) when creating a hybrid spatial index within the object model. The range is any positive integer.
If this parameter is not specified at the time when a spatial index is created, and Quadtree Levelsoracle_levelsis specified, fixed spatial indexing will be used in the created index.
Table Settings: Advanced
![关闭](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
表示哪个列的值来自序列。此参数值的语法是表单:
第1列:SEQNAME1;第2列:SEQNAME2
Where "columnN" is the name of the column whose value is provided by the sequence, and "seqnameN" is the name of the sequence in the Oracle database.
作为具体示例,此参数的值可能是:
id:mySchema.test_sequence
Where id is also specified under the User Attributes tab. mySchema.test_sequence refers to a sequence named test_sequence in the schema mySchema.
如果未给出“:seqnamen”,则列的值将由具有与列相同的名称的序列提供。序列名称区分大小写。如果尚不存在,则将创建序列,在这种情况下,将写入日志文件。
![关闭](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
指定要进程功能的自定义SQL查询。此参数通常用于需要自定义SQL逻辑的插入,更新和删除操作,例如异常处理。查询中的值可以通过嵌入来绑定:attrName在查询中,在哪里attrNameis the name of the FME feature’s attribute. For example:
插入“test_table”(“ID”,“geom”)值(:键,:myGeom)
In this example, the attribute namedKEY将从写入表列的每个功能中获取“ID”。The geometry on the feature will be written into the spatial column named “GEOM”. The attributes bound in the query, including the spatial "attribute" named "MYGEOM", must be listed in the User Attributes tab. The User Attribute types should align with the column types in the table schema, although for the spatial "attribute", any User Attribute type may be specified. Further, the spatial "attribute" named "MYGEOM" must be specified in the format parameterSpatial Column。(Note thatSpatial Columnused to have the label Target Geometry Column Name in older FME versions.)
As another example, consider thisUPDATEquery:
UPDATE "TEST_TABLE" SET "GEOM"=:MYGEOM WHERE "ID"=:MYID
In this example, the attribute named我的身份from each feature is matched against the column “ID”. Matching rows will have their“GEOM”column updated. The spatial column“GEOM”gets its value from the feature’s geometry. Once again,MYGEOMneeds to be specified both in the User Attributes tab and in the format parameterSpatial Column。
Tip:作为使用“最佳实践”工作流亚搏在线的一部分,您应该确保绑定语句中的用户属性名称及其相应的属性名称是相同的,包含字母案例。空间“属性”必须是真的。对于非空间属性,如果对字母案例除了配对相同,则使用该名称的属性不存在该特征上的属性;在这种情况下,绑定属性名称将以其为准。如果在该功能上也不存在绑定属性名称,则非存在属性的值应该默认为NULL。
Because of this override behavior, when there are multiple attributes on the feature with identical names except for letter case and you want to bind an attribute whose name is not all uppercase, you may need to uncheck theUppercase Column Namesparameter in the writer parameter box when you add the writer.
Note:没有必要(或推荐)在引号中缠绕绑定属性名称:在测试中,:myIDbehaved the same as the quoted:”myID”。If you do wrap bound attribute names in quotes, then you must do this for every bound attribute name.