[gdal-dev] Is using geometry in SQL inside VRT supported?

[Jukka Rahkonen]

Hi,

This works with ogrinfo
ogrinfo -ro cities.shp  -dialect SQLITE -sql "select GEOMETRY from cities"

I tried to make a VRT file which would do the same 

<OGRVRTDataSource>
<OGRVRTLayer name="cities">
<SrcDataSource>cities.shp</SrcDataSource>
<LayerSRS>WGS84</LayerSRS>
<SrcSQL>SELECT GEOMETRY from cities</SrcSQL>
</OGRVRTLayer>
</OGRVRTDataSource>

Now ogrinfo does not find geometries

ogrinfo cities.vrt
INFO: Open of `cities.vrt'
      using driver `VRT' successful.
1: citiesERROR 1: SQL Expression Parsing Error: syntax error
ERROR 1: SQL statement failed, or returned no layer result:
"SELECT GEOMETRY from cities"

This exact use case is not at all interesting but there would be quite nice
possibilities if Spatialite SQL queries could be fired from the VRT and all
this would be supported for on-the-fly conversions
http://www.gaia-gis.it/gaia-sins/spatialite-sql-4.0.0.html



-Jukka Rahkonen-