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- _______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev