[fdo-users] SQL queries through FDO involving geometries
traian.stanev at autodesk.com
Thu Oct 11 10:07:13 PDT 2012
With the SQLite provider at least, you can call GetGeometry on any column you want. Don't know about other providers. I am not sure what you gain from being able to call GetGeometry instead of GetBLOB or GetString though, because GetGeometry also returns just a blob.
From: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of Jackie Ng
Sent: Thursday, October 11, 2012 12:57 AM
To: fdo-users at lists.osgeo.org
Subject: [fdo-users] SQL queries through FDO involving geometries
Do FDO providers that support SQL commands properly detect and convert geometry columns/expressions to FDO geometry values?
For example, suppose I execute this SQL command through FDO:
SELECT ID, MY_GEOM FROM TABLE
(where MY_GEOM is a SQL Server geometry/geography column)
Will the FDO SQL reader let me access MY_GEOM as a FDO geometry (ie. Am I able to call reader.GetGeometry("MY_GEOM")) ?
I'm researching an idea for MapGuide whose feasibility somewhat hinges on whether this is actually possible or not.
View this message in context: http://osgeo-org.1560.n6.nabble.com/SQL-queries-through-FDO-involving-geometries-tp5007900.html
Sent from the FDO Users mailing list archive at Nabble.com.
fdo-users mailing list
fdo-users at lists.osgeo.org
More information about the fdo-users