Oracle Spatial Georaster Reader参数
数据库连接 |
---|
Connections store authentication information. For general information about sharing database connections, please seeUsing Database Connections. 请注意,在不同的上下文中可用数据库连接参数的不同子集。 ![]() Select an existing connection, orAdd Database Connection定义新连接。 新连接只能可见于当前用户,或者可以在多个用户之间共享。 |
![关闭](http://www.baooytra.com/docs/fme/2017.1/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
如果设置此参数,将分配每个输出功能,坐标系。源数据中的任何坐标系信息将被忽略。特别是,没有进行重新注入。
If this parameter is unset, FME will attempt to determine the coordinate system of each feature from the source data. If this is unsuccessful (for example, because the source data is not georeferenced), then features will be read without a coordinate system. When a feature does not have a coordinate system, its coordinate system is shown as""in the Logger andUnknownin the Data Inspector.
![关闭](http://www.baooytra.com/docs/fme/2017.1/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
指定要连接的Oracle数据库。这可能是定义的网络服务名称tnsnames.ora或一个简单的连接标识符。可以以用户名和密码信息为前缀的任何形式的连接标识符。
[<用户名> [/
[
![关闭](http://www.baooytra.com/docs/fme/2017.1/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
The username and password.
![关闭](http://www.baooytra.com/docs/fme/2017.1/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
的名称Oracle Workspace Manager.读者将使用的工作区。将使用相同的工作区读取所有表。如果省略此参数或留空,则将使用默认的实时工作空间。
![关闭](http://www.baooytra.com/docs/fme/2017.1/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
If this parameter is selected (default), the Oracle database connection remains open for other requestors. A persistent connection is useful for workspaces that are long-running, or published using FME Server.
如果取消选择此参数,则在数据处理完成后尽快关闭与Oracle数据库的连接。
约束
![关闭](http://www.baooytra.com/docs/fme/2017.1/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
指定是否保留表格限定符。数据库中的表的全名是格式:
<前缀>。
根据数据库格式,prefix可
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.
When this parameter is selected during workspace generation, the source feature types will be the table names without any prefix; otherwise, they will contain the owner name as a prefix. It is recommended that you do not change this parameter after generating the workspace, because it is possible for no features to be successfully passed onto the writer (since the writer is expecting feature types with different names).
Note:Even when this parameter is selected, if the table is owned by a user other than the current user, the prefix will not be dropped. This is to ensure that the reader will find the correct table.
![关闭](http://www.baooytra.com/docs/fme/2017.1/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
After you have specified the database connection, click the Browse button to select tables for import. A connection window appears while the system compiles a table from the database.
出现表列表后,您可以选择一个或多个表,然后单击“确定”以解雇窗口。表名称将显示在参数框中的表列表字段中。
![关闭](http://www.baooytra.com/docs/fme/2017.1/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
可以将SQL ADS子句应用于所选表,以限制在表列表中选择的表中的行选择(例如,NUMLANES = 2)。
架构属性
使用搜索信封
使用最小和最大X和Y参数,定义将用于过滤输入功能的边界框。只返回与边界框交叉的功能。
If all four coordinates of the search envelope are specified as 0, the search envelope will be disabled.
![关闭](http://www.baooytra.com/docs/fme/2017.1/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
选择后,此参数删除在搜索信封外部读取的导入功能的任何部分。
下面的示例说明了搜索信封的结果Clip to Search Envelopeis not selected (set to No) and when it is selected (set to Yes).
- No: Any features that cross the search envelope boundary will be read, including the portion that lies outside of the boundary.
- 是:跨越搜索信封边界的任何功能将在边界处剪切,只会读取边界内部的部分。潜在的功能Clip to Search Envelope功能是一个十字路口;但是,当Clip to Search Envelopeis selected, a clipping operation is also performed in addition to the intersection.
![关闭](http://www.baooytra.com/docs/fme/2017.1/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
Specifies the coordinate system of the search envelope if it is different than the coordinate system of the data. The coordinate system associated with the data to be read must always be set if this parameter is set.
如果设置此参数,则在应用信封之前将搜索信封的最小和最大点从搜索包络坐标系重新恢复到读者的坐标系。
Advanced
![关闭](http://www.baooytra.com/docs/fme/2017.1/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
Rows are read from the Oracle database using a bulk reading technique to maximize performance. This parameter allows you to tune the performance of the reader by specifying how many rows are read from the database at a time.
The default is 200.
![关闭](http://www.baooytra.com/docs/fme/2017.1/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
This parameter allows for the execution of SQL statements before opening a table for reading. For example, it may be necessary to create a temporary view before attempting to read from it.
Multiple SQL commands can be delimited by a character specified using thefme_sql_delimiter.
指令,嵌入在SQL块的开头。此指令后的单个字符将用于将SQL块拆分为SQL语句,然后将发送到数据库以进行执行。Note:Include a space before the character.
例如:
fme_sql_delimiter;从教师删除;从LastName ='Doe'和FirstName ='John'的人那里删除
Multiple delimiters are not allowed and the delimiter character will be stripped before being sent to the database.
在执行这些SQL语句期间发生的任何错误通常会终止读取器或写入器(取决于SQL语句的执行情况而错误。如果指定的语句先于连字符(“ - ”),则忽略此类错误。
![关闭](http://www.baooytra.com/docs/fme/2017.1/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
This parameter allows for the execution of SQL statements after a set of tables has been read. For example, it may be necessary to clean up a temporary view after creating it.
Multiple SQL commands can be delimited by a character specified using thefme_sql_delimiter.
指令,嵌入在SQL块的开头。此指令后的单个字符将用于将SQL块拆分为SQL语句,然后将发送到数据库以进行执行。Note:Include a space before the character.
例如:
fme_sql_delimiter;从教师删除;从LastName ='Doe'和FirstName ='John'的人那里删除
Multiple delimiters are not allowed and the delimiter character will be stripped before being sent to the database.
在执行这些SQL语句期间发生的任何错误通常会终止读取器或写入器(取决于SQL语句的执行情况而错误。如果指定的语句先于连字符(“ - ”),则忽略此类错误。
![关闭](http://www.baooytra.com/docs/fme/2017.1/html/FME_Desktop_Documentation/FME_ReadersWriters/Skins/Default/Stylesheets/Images/transparent.gif)
This parameter specifies the pyramid level to read from.
金字塔等级0表示原始光栅数据。大于0的值表示图像分辨率的越来越减少。
每个金字塔级别具有前一级的一半行数和列。