[fdo-users] SQL queries through FDO involving geometries

[Traian Stanev]

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.

Traian


-----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:

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.

- 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
http://lists.osgeo.org/mailman/listinfo/fdo-users