OracleQuerier
From fmepedia
OracleQuerier is a Workbench Transformer.
| Table of contents |
Description
Performs spatial queries against an Oracle Spatial database. The queries can have both a spatial as well as nonspatial component to them.
One query is issued to the Oracle database for each feature that enters the transformer. The results of the query are then output.
The query feature defines the geometry which will be used to define the spatial component of the query, unless the search method is NONE. In that case, only an attribute query as defined by the where clause will be executed.
Spatial Query Operators
The complete set of Oracle spatial query operators is supported and each is described below:
DISJOINT: Features output have no common boundary or interior points with the query feature's bounding box.
EQUAL: Features output share every point of their boundaries and interior, including any hole, with the query feature's bounding box.
INSIDE: Features output have their geometry entirely contained in the query feature's bounding box.
OVERLAPBDYDISJOINT: Features output overlap but their boundaries do not interact with the query feature's bounding box.
OVERLAPBDYINTERSECT: Features output overlap and their boundaries intersect in one or more places with the query feature's bounding box.
TOUCH: Features output share a common boundary with the query feature's bounding box.
ANYINTERACTION: Features output interact with the query feature's bounding box in any of the above ways.
Example
The QuerierExample.zip shows an example use of the OracleQuerier transformer for non-spatial data.
In this example we use the listBuilder and listConcatenator to create a comma separated list of values and a single query feature. This lets us send a single query (single query feature) by using the where clause SCOTT.JOINTABLE.MYID in (&ATTRLIST)
Keep in mind that to query non-spatial data the query feature should not have any geometry.
