Hi, Use the ArcSDEQuerier transformer. The input will be all the Oracle records you've just read. It will return features from the SDE database that match a test you set up (which in this case would be where SDE_ID = ORACLE_ID)
For the pointinpolygon overlay you could even use a second ArcSDEQuerier since I believe it permits spatial queries to be carried out (ie input points, output polygons) Think this should work. Hope it helps, Mark Mark Ireland, Senior Product Specialist Safe Software Inc. Surrey, BC, CANADA [EMAIL PROTECTED] http://www.safe.com Solutions for Spatial Data Translation, Distribution and Access --- In [email protected], "twee0001" <[EMAIL PROTECTED]> wrote: > > I have a question about a process. I want to extract features from > an SDE database using features from a separate Oracle database using > something similar to a SQL IN clause. > > Step 1: > I want to query the Oracle database, bring back a list of ID values. > > Step 2: > Feed that list into a separate SDE database and query a point later > using that list. > > Step 3: > Where there are matches I want to use those returned points to > perform a point-in-polygon operation on the same SDE database in > another layer. > > I'm having trouble finding a transformer that enables me to use the > list of returned values like an IN clause would be used in SQL, or a > WHERE table1 = table2 evaluation. > > Thanks in advance, > st > For insights into what's up at Safe Software and what's on the development horizon, visit Safe's blog at spatial-etl.blogspot.com. Safe Software has also made slides available that outline enhancements planned for FME 2007. The slides are from the "Road Ahead" presentation given on Day 2 of the FME Worldwide Users Conference. To view these slides, visit www.safe.com/2006uc. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/fme/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/fme/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
