Skip to main content
  • EN

Hello,

I am using the SQL Executor to read two tables from oracle using a join.

I would like to use Oracle Spatial Object as Format to have the geometry included.

This is my sql query:

select a.nm, a.fid, b.mlpst, b.feat
from t_csm a
join t_fl b
on a.clss=b.clss

Both table a and b have a geometry (GEOM). When I use SQL Executor - Oracle Spatial Object, how can I know the geometry of which table will be used ? I want it to be the geometry of table b but I don’t how to specify it. The geometries of these two tables are not the same and my next transformer is the neighborfinder so it makes a big different if I use the geometry of table a or table b.Thanks for your help.

Add the appropriate GEOM attribute to your query, so

select a.nm, a.fid, b.mlpst, b.feat, a.GEOM
from t_csm a
join t_fl b
on a.clss=b.clss

(or maybe replace a.GEOM with b.GEOM)

Reply


Community Stats

30,157
Posts
114,473
Replies
37,802
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.