Skip to main content
Question

Joiner not picking up geometries (from Supplier)

  • June 24, 2015
  • 1 reply
  • 47 views
F
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)
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

takashi
Celebrity
  • takashiCelebrity
  • June 25, 2015
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
Why not inspect features with Visual/Data Preview and Feature/Record Information before writing them into a destination dataset?

Community Stats

32,448
Posts
123,298
Replies
40,601
Members
Terms & ConditionsCookie settingsAccessibility statement
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.