span8
span4
span8
span4
readingmultiplegeometry-2016.fmw
A number of the major databases are capable of supporting data which has two or more geometry columns associated with each record.Smallworld,Oracle,SQL Server and Postgis are good examples of this.For Smallworld the geometry handling is done by the various Smallworld format reader/writers - seeWorking with Smallworldfor more details.FME has not yet implemented multiple geometry support for Postgis - seethis articlefor an example of how to write geometry to these kinds of tables in Postgis.
For Oracle and SQL Server handling multiple geometry columns has been implemented however FME cannot create tables which have multiple geometry columns.
Multiple geometry handling involves setting or retrieving the Geometry Name on each of the geometries involved and working with the features as Aggregates.It is also important to set the Reader/Writer parameter "Handle Multiple Spatial Columns" to "Yes".This parameter is available when you add a reader or writer - e.g.for Oracle
and also in the Navigator pane - e.g.for SQL Server
Each multiple geometry feature that FME reads is an aggregate.TheDeaggregatortransformer can be used to split up the record into individual geometries,and an attribute (_geometry_name) used to determine which geometry came from which column.
The attached workspace shows the following:
- Advanced reader parameter > Handle Multiple Spatial Columns set to "Yes"
- Deaggregator to split up aggregate features.Each feature will have an _geometry_name attribute holding the name of the geometry column.
- Inspector to view the data.
There are two multiple-geometry writing scenarios:
These scenarios are covered inWriting to Database Tables that contain Multiple Geometry Columns
Writing to Database Tables that contain Multiple Geometry Columns
Performing spatial queries on database tables using the FeatureReader
Loading Data to Oracle Spatial for GeoMedia Consumption
FME,SQL Server Spatial and GeoMedia
Updating SRID values in an Oracle geometry column
FME is loading features with invalid geometries into my Database
Let the Database Do the Work: Reading
Writing multiple geometry types to an existing PostGIS table
© 2019 亚搏在线Safe Software Inc |法律