[fdo-users] Can you execute an FDO Spatial filter on x,y data in oledb datasource?

[Nick Adams]

Hi,

I can successfully apply a polygon defined as a spatial filter in FDO to an
SDP file to return points within its boundary.

What I would like to do is to apply this same polygon to a database of
points where rather than being a geometry type they are stored as x,y pairs
in separate columns. 

I have my spatial filter geometry defined for my spatial filter.
I then need to set up an identifier,

       OSGeo.FDO.Expression.Identifier idSpatial;
       idSpatial = new OSGeo.FDO.Expression.Identifier(_ifmGeometry);

For a geometry field this is straightforward, one would just use 'Geometry'
or whatever its name is.
The problem I guess is how to set up the identifier when you have x,y pairs,
ie I would like to create a filter that could allow me to do something like:

POINT(X Y) ENVELOPEINTERSECTS GeomFromText('POLYGON ((1 2, 3 2, 3 4, 1 4, 1
2))')

Mapguide studio can work with this same x,y data as a feature source. Is
there a way to do it in FDO?
Any ideas appreciated.

Nick
-- 
View this message in context: http://www.nabble.com/Can-you-execute-an-FDO-Spatial-filter-on-x%2Cy-data-in-oledb-datasource--tp16807717s18162p16807717.html
Sent from the fdo-users mailing list archive at Nabble.com.