[fdo-users] Problem with querying on spatial filter

[Anthony F]

I've got an ArcSDE server (9.2) and FDO 3.3.0 (inside Map 2009). I'm
providing a spatial filter to the select query:

selectQuery.SetFilter(@"SHAPE INTERSECTS GEOMFROMTEXT ('POLYGON XY
((780364.844122 26690990.746872,783001.072122
26691077.022872,782977.900122002 26693719.998872,782957.512122002
26696363.242872,780302.484122001 26696391.326872,777655.300122
26696306.478872,777692.320122 26693615.966872,777728.300122
26690906.366872,780364.844122 26690990.746872))')");

The problem is that some objects, specifically objects along the east side,
that are located within the boundary described above are not part of the
results set when I use FDO. If I take those same coordinates and use the
SDO_RELATE function from a standard SQL query (because our SDE layers are
stored using SDO geometry and not ESRI binary) it will return the otherwise
missing features. Also, if I run the query inside ArcGIS, the application
will select those objects that are not being selected through FDO.

An example would be a feature located at 782824.599,26694503.082.

If I create a small polygon around the specific set of objects that are not
coming in, the FDO query will result in the missing objects in question to
be returned.

Other relavent info:
Coordinate system: NAD_1983_StatePlane_Nevada_East_FIPS_2701_Feet 
-- 
View this message in context: http://www.nabble.com/Problem-with-querying-on-spatial-filter-tp16941503p16941503.html
Sent from the FDO Users mailing list archive at Nabble.com.