[fdo-users] Spatial Query with MySQL FDO provider
gmclean at gorge.net
Thu Feb 15 18:15:25 EST 2007
I am having trouble writing spatial queries against MySQL 5.0.18 using
the OSGeo.MySQL.3.2 provider
I pass the string 'geometry INTERSECTS GEOMFROMTEXT ('POINT XY (2536400
481800)')' to the SetFilter method of an MgFeatureQueryOptions object.
When I call selectFeatures from a feature service object, I get no errors.
When I use the filter string 'geometry INTERSECTS GEOMFROMTEXT
('LINESTRING XY (2536400 481800, 2536500 481900)')' I get the following
error on selection:
An exception occurred in FDO component. String does not represent a
As far as I can tell the query string is OK. I have the same problem
with using POLYGON as the geometry as well. Only POINT seems to work.
When I query the capabilities of the MySQL provider it appears to me
that LINESTRING and POLYGON are supported.
More information about the fdo-users