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

[Gavin Cramer]

Hi, Nick.  You should be able to do this now via the FDO ODBC Provider.  It maps X and Y ordinate columns to a property named 'Geometry'.  It natively does this for columns named 'X', 'Y', 'x' or 'y' (and optionally 'Z'/'z').  I believe that both Map3D and MapGuide also add their own logic to sense columns with names like 'LATITUDE' and 'LONGITUDE' as well as having schema menus where you can map any other numeric columns to be the ordinates.

Does this help?

Gavin


-----Original Message-----
From: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of Nick Adams
Sent: Wednesday, April 23, 2008 4:32 AM
To: fdo-users at lists.osgeo.org
Subject: RE: [fdo-users] Can you execute an FDO Spatial filter on x,y data in oledb datasource?



So returning to my question. Given that Mapguide Studio can accept x,y data
through odbc and successfully use it as a feature source, is there any way I
can programmatically attach to x,y data through an FDO odbc provider so that
I can perform spatial queries on it, such as:

ENVELOPEINTERSECTS GeomFromText('POLYGON ((1 2, 3 2, 3 4, 1 4, 1 2))')

Any help greatly 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--tp16807717p16833351.html
Sent from the FDO Users mailing list archive at Nabble.com.

_______________________________________________
fdo-users mailing list
fdo-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/fdo-users