Jukka, I do see it mentioned there in the SrcSQL docs.
Best regards, Frank On Fri, May 24, 2013 at 10:46 AM, Rahkonen Jukka <[email protected]>wrote: > Hi Frank, > > Great, and I guess that this syntax example about how to select the > dialect will be added to the driver manual page > http://www.gdal.org/ogr/drv_vrt.html in your documentation sprint of > FOSS4G NA. > > -Jukka- > > ________________________________ > Frank Warmerdam wrote: > > > Jukka, > > It turns out you can already assign a dialect. I think it is roughly like: > > <SrcSQL dialect="sqlite">SELECT ...</SrcSQL> > > It seems to be touched on it the docs for the OGR VRT driver as well. > > Best regards, > Frank > > > > On Fri, May 24, 2013 at 9:46 AM, Frank Warmerdam <[email protected] > <mailto:[email protected]>> wrote: > 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] > <mailto:[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]<mailto:[email protected]> > http://lists.osgeo.org/mailman/listinfo/gdal-dev > > > > -- > > ---------------------------------------+-------------------------------------- > I set the clouds in motion - turn up | Frank Warmerdam, > [email protected]<mailto:[email protected]> > light and sound - activate the windows | http://pobox.com/~warmerdam > and watch the world go round - Rush | Geospatial Software Developer > > > > -- > > ---------------------------------------+-------------------------------------- > I set the clouds in motion - turn up | Frank Warmerdam, > [email protected]<mailto:[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 > -- ---------------------------------------+-------------------------------------- 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
