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

[Frank Warmerdam]

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
<jukka.rahkonen at mmmtike.fi>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
> gdal-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/gdal-dev
>



-- 
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up   | Frank Warmerdam,
warmerdam at pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush    | Geospatial Software Developer
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20130524/51424db7/attachment-0001.html>