Hi,
The following SQL works fine when using Spatialite as source
osm_data>ogrinfo osm.sqlite -dialect SQLITE -sql "select * from lines
where highway is not null limit 20"
With native OSM data it fails
OSM_data>ogrinfo -dialect SQLITE finland.osm.pbf -sql "select * from lines
limit 20"
Had to o
Selon Jukka Rahkonen :
> Hi,
>
> The following SQL works fine when using Spatialite as source
>
> osm_data>ogrinfo osm.sqlite -dialect SQLITE -sql "select * from lines
> where highway is not null limit 20"
Note that for a SQLite datasource, -dialect SQLite is useless since the SQL
engine of SQLit
Even Rouault wrote:
> Selon Jukka Rahkonen :
>> Hi,
>>
>> The following SQL works fine when using Spatialite as source
>>
>> osm_data>ogrinfo osm.sqlite -dialect SQLITE -sql "select * from lines
>> where highway is not null limit 20"
> Note that for a SQLite datasource, -dialect SQLite is useless
> I will do, I tend to use "limit 10" of something in making quick tests but
> OSM is so odd data that I was not surprised in seeing that it fails. Is
> this driver specific or related to OGR SQL engine generally?
This is specific to the OSM driver needing to be a bit clever about the SQL
statem
Jukka Rahkonen mmmtike.fi> writes:
>
> Hi,
>
> The following SQL works fine when using Spatialite as source
>
> osm_data>ogrinfo osm.sqlite -dialect SQLITE -sql "select * from lines
> where highway is not null limit 20"
>
> With native OSM data it fails
> OSM_data>ogrinfo -dialect SQLITE finl