Skip to main content
  • EN
Requestor: Features that have originated from a non-spatial Oracle table.

 

Supplier: Reader is set to Oracle Spatial Object and geometries are stored in a column "GEOMETRY" (Embeded connection)

 

 

"Fields to Add" contains all of the columns EXCEPT geometry. The output from the transformer has no geometry. Apart from this they are joining & the output of the attributes is correct.

 

 

Any thoughts?

 

 

FeatureMerger works fine, but is not performing well in this instance, as this part of the workbench is only used in certain circumstances but I'm having to read a large spatial table in whether those are met or not. Joiner would prevent this happening.

 

 

This is in FME 2015.0 (20150217 Build 15253 WIN64)
Hi,

 

 

I tested this with PostGIS database. Looks like the Joiner supports only attribute merging.

 

How about using the SQLCreator or the SQLExecutor with a SQL statement like this?

 

-----

 

select a.*, b.*

 

from <non-spatial data table> as a inner join <spatial data table> as b

 

on <join condition>

 

-----

 

Note: Set "Result Geometry Only" to the "Combine Geometry" parameter if you use the SQLExecutor.

 

 

Takashi

Reply


Community Stats

30,108
Posts
114,295
Replies
37,744
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.