Skip to main content
Hi,

 

 

I want to insert data in a feature having multiple geometry columns.

 

I have tried the steps given in demos http://fmepedia.safe.com/articles/Samples_and_Demos/Oracle-Spatial-Object#heading_toc_j_6 , but this is not working. The writer is inserting null in both the geometry columns.

 

I have also ensured proper entries in metadata.

 

I am using fme desktop 2013. Please Help.

 

 

Thanks,

 

Nikit Bakiwala
Hello,

 

 

Cant say I have tried it myself, so I was wondering if you created seperate aggregates (step 2) or one?

 

 

Itay

 

 


Hey all,

 

 

I too am trying to populate multiple geometry columns but in PostGIS. hopefully someone can provide insight into possible methods applicable to any dbms that supports multiple spatial fields. I am building out a spatial ETL using the ArcGIS Interoperability ext. Source is a MSSQL Spatial table with two point geometry columns, target PostGIS table same schema as source. I found this thread in the deprecated FME Talk group on GGL https://groups.google.com/forum/#!topic/fmetalk/PVf6yIGASrk here some other folks provided possible ways to update/insert views of the table that contains mulitple spatial columns. One option would be to use the standard spatial writer for your dbms for one column and OGCWKT to populate geometries for the second column. I am trying to do this fully within workbench. Still unsure of how to execute the OGC method in workbench using sql. Some folks are under the impression that working with multiple spatial columns is rare but it's not that's why the major dbms vendors prop & opensource support this architecture.
Sorry here is the url I provided above https://groups.google.com/forum/#!topic/fmetalk/PVf6yIGASrk

Reply