+1I have 2 feature classes namely,
Pipe [Attributes : 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
+2Hi,
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.
+18I 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:
My connection seems fine. I am able to access all tables and do more complicated queries in SQL Developer.
Any info is appreciated.
Thanks,
Loren
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
