span8
span4
span8
span4
When data is extracted via SQL statements in the InlineQuerier the geometry and attributes of the original features are carried through the transformer on thefme_feature_contentattribute.If the SQL statement is retrieving this information explicitly - by including fme_feature_content in the SELECT statement or implicitly by using SELECT * then all attributes and geometry are available via the output port.
There are two ways that the geometry is handled and this is defined by setting theGeometrycolumn in theOutputssection of the dialog.
In this screenshot there are two source datasets.Neighborhoods is a polygon dataset,AddressData is a point dataset.
Setting Geometry toFirst Featuremeans that the geometry from first dataset mentioned in the SELECT statement will be output - in the example above each row that meets the requirements of the SELECT statement will be output with the polygon geometry of the Neighborhoods.By changing the order of the datasets in the SELECT statement you can change the resultant geometry from polygons to points.
SettingGeometry to Aggregateof all features means that the geometry from each feature will be aggregated and output on each feature.
The attached workspace can be used to test out these options.
Performing spatial queries on database tables using the FeatureReader
Using the InlineQuerier as a replacement for multiple FeatureMergers
Performing native spatial queries on database tables using the SQLExecutor
Using the SQLExecutor or SQLCreator to issue commands to a database
Read Oracle Sequence Nextval and use in Counter
Extracting Data within a Clipping Polygon using FeatureReader
Making use of Oracle Sequences when working with Oracle Tables
© 2019 亚搏在线Safe Software Inc |法律