The spatial portion of the query is fine, it works well. I had tried the method you describe, but I get an error saying that the ID value from the Oracle database (ORACLE_ID in your example) is undefined. The two values that should match are five letter codes, the Oracle database defines the field as varchar2(5) and SDE defines it as Text with a length of 255, could this be the reason? Is there some kind of syntax I'm not aware of?
________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of mark2atsafe Sent: January 4, 2007 7:32 PM To: [email protected] Subject: [fme] Re: Sql IN clause 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] <mailto:support%40safe.com> http://www.safe.com <http://www.safe.com> Solutions for Spatial Data Translation, Distribution and Access --- In [email protected] <mailto:fme%40yahoogroups.com> , "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 >
