span8
span4
span8
span4
How do I populate the GDOSYS schema used by GeoMedia when loading data into Oracle Spatial (Locator) with FME.GeoMedia doesn't see the feature class after loading it into Oracle Spatial with FME.这是怎么呢
FME doesn't create or update with GeoMedia metadata (GDOSYS) when loading data into the Oracle Spatial Data Model.There is no option on the Oracle Spatial writer to populate GeoMedia Metadata.
However an FME workspace can be enhanced to create this metadata by using SQLExecutors and an Oracle PL/SQL package from Intergraph.
As a working example we've attached a workspace that will take a GeoMedia Access Warehouse (USSampleData for GeoMedia users) and push it to an Oracle Spatial database.
Opening the workspace in FME you'll see a bookmark called GDOSYS Metadata.Please review the "SQL Statement" setting for the SQLExecutor transformer.
The SQLExecutor passes some information to the Oracle Database that calls a GOOM package to insert GDOSYS metadata.You'll need to have access to GOOM Package which is available from Intergraph Support - "GOOM - Managing Spatial Data for GeoMedia",free for GeoMedia customers.Chuck Woodbury maintains this utility package.
GeoMedia customers can download the GOOM tools from Intergraph Support at:
https://support.hexagon亚搏在线safetyinfrastructure.com/infocenter/index?page=forums⊤ic=507202530697815b5014e6475c838007c9d⊤icsel=new
or contact Chuck via email atchuck.woodbury@intergraph.com.
With this package installed in the Oracle database you can easily load your data into the Oracle Spatial Database with FME and at the same time populate the GDOSYS metadata automatically using the SQLExecutor transformer to call the GOOM package.
NOTE: The attached workspace doesn't allow you to set the Coordinate system without knowing the GUID stored in the existing GDOSYS.GCOORDSYSTEM table of your database - it is hard coded value in the example.This could be queried by FME and auto populated using the GCoordsystem Name but this has not been done in this simple example.
A big thank you goes out to Chuck for providing the GOOM tools to 亚搏在线Safe Software for demonstration purposes.
Performing spatial queries on database tables using the FeatureReader
Writing to Database Tables that contain Multiple Geometry Columns
Handling Data that contains Multiple Geometry columns
Let the Database Do the Work: Reading
Using Data Inspector to view GeoMedia Text Features in an Oracle database
How to read Geomedia Access .accdb Warehouse
Convert Geodatabase Coded Domains To Geomedia Picklists
© 2019 亚搏在线Safe Software Inc |法律