Skip to main content
  • EN
Hi All,

 

I have 2 feature classes namely,

 

Pipe bAttributes : Pipe_Id, Diameter] and                          

 

Valve  Attributes :Valve_Id, Valve_Size_Num].

 

 

Using "Spatial Filter" transformer, i am able to get the multiple pipes intersecting with a single valve feature. Now out of those multiple pipes intersecting a single valve feature, how to get the pipe feature which has lesser Diameter value.

 

 

Thanks,

 

Srini

Hi,

 

How about using a Tester. 

 

Left Value: pipe feature

 

Operator: '<' (Less Than)

 

Right Value: Any number (I guess Valve_Size_Num in your case).

Parashari.

I am struggling to read two geometry columns from this database. If I set Handle Multiple Spatial Columns to "No", it only gives me one of the two columns. If I set it to "Yes", then I get the above error.

 

What does it mean to have a "Custom SQL SELECT statement"?

Mine is nothing fancy:

select building_id, floor_id, space_id, agency_code, space_type, space_category,usable_sq_ft,
 
obj.objgeom,
 
SDO_UTIL.interior_point (OBJ.objgeom)
 
from esm.esmobject obj join esm.att_space ats
 
on obj.IDOBJECT = ats.IDOBJECT
 
where building_id = 'BD0303'
 
and floor_id = '01'

 

It was also difficult to retrieve data tables. I had to type in each one. Luckily there were only two. If I let FME search for tables, it errors:

Oracle1My connection seems fine. I am able to access all tables and do more complicated queries in SQL Developer.

 

Any info is appreciated.

 

Thanks,

 

Loren

 

 

Or, use the SpatialRelator. This should be able to give you a list of pipes associated with the valve. Then you could use the ListSorter to order teh list by diameter.

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.