[gdal-dev] VirtualOGR with Sqlite

[Martin Jensen]

I have been playing around with the virtualOGR table feature made available
in sqlite and I am absolutely thrilled about this feature.Thanks for the
great work!

I've come across two small issues that i'd like some help/comments on. I am
trying to connect to a WFS service which works fine in Sqlite.


1) connecting to all layers in an ogr (WFS) datasource

 I wanted to try to connect to all layers in the WFS datasource at once.
The sqlite driver page says it is possible with the function
"ogr_datasource_load_layers"  http://www.gdal.org/ogr/drv_sqlite.html, I
get the error:

no such function: ogr_datasource_load_layers

I am using Spatialite 4.0.0 and GDAL 1.10dev from trunk

Any ideas ?

2) Using sql with  "....limit 10;"

All works find using the "create table using virtualOGR()". I was then
hoping I could use sql syntax "limit 10" on the wfs datasource because it
is a huge dataset. But it seems that the virtual table has fecth the entire
dataset before retuning the 10 rows. I was thinking the "limit 10" was
translated to &maxfeatures=10 in the WFS drivers GetFeature request. Is
this expected behaviour or am I doing something wrong?


-- 
Med venlig hilsen

Martin Bjærge Jensen
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20130101/cfc7d02b/attachment.html>