[fdo-users] SQL queries through FDO involving geometries

Traian Stanev traian.stanev at autodesk.com
Thu Oct 11 10:07:13 PDT 2012

Hi Jackie,

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.


-----Original Message-----
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

Hi All,

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:


(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.

- Jackie

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 mailing list