Jukka, Agreed! The SrcSQL directive in the VRT should accept a dialect option. I'll try to do that this afternoon as we are "sprinting" here at FOSS4G NA and this would be a nice sized feature to add.
Best regards, Frank On Fri, May 24, 2013 at 8:39 AM, Jukka Rahkonen <[email protected]>wrote: > 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 > [email protected] > http://lists.osgeo.org/mailman/listinfo/gdal-dev > -- ---------------------------------------+-------------------------------------- I set the clouds in motion - turn up | Frank Warmerdam, [email protected] light and sound - activate the windows | http://pobox.com/~warmerdam and watch the world go round - Rush | Geospatial Software Developer
_______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
