[Qgis-user] Maximum wfs layers in qgis?

Richard McDonnell richard.mcdonnell at opw.ie
Tue Aug 22 02:17:42 PDT 2017


Hi,
If you also switch off the Cache for the WFS on QGIS. You can do this 
when you add the Layer, just uncheck the *Cache Feature* box for the 
layer you are trying to load.
Hope this helps!

Regards,

Richard.

On 21/08/2017 19:55, Dan Meerschaert wrote:
> When I look in the cache/wfsprovider folder, there's another folder 
> with almost three times the layer number in other files: 
> wfs_cache_XX.sqlite, -shm, and -wal.
>
> I had to track down a public wfs with a small enough sample set to be 
> repeatable. This Python code gives the error in 2.18.7 and a 2.99 
> nightly I grabbed for testing:
>
> iface.addVectorLayer(' restrictToRequestBBOX=\'1\' 
> srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' 
> url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\ 
> <https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>' 
> version=\'auto\' table="" sql=',"example01","WFS")
>
> iface.addVectorLayer(' restrictToRequestBBOX=\'1\' 
> srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' 
> url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\ 
> <https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>' 
> version=\'auto\' table="" sql=',"example02","WFS")
>
> iface.addVectorLayer(' restrictToRequestBBOX=\'1\' 
> srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' 
> url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\ 
> <https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>' 
> version=\'auto\' table="" sql=',"example03","WFS")
>
> iface.addVectorLayer(' restrictToRequestBBOX=\'1\' 
> srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' 
> url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\ 
> <https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>' 
> version=\'auto\' table="" sql=',"example04","WFS")
>
> iface.addVectorLayer(' restrictToRequestBBOX=\'1\' 
> srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' 
> url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\ 
> <https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>' 
> version=\'auto\' table="" sql=',"example05","WFS")
>
> iface.addVectorLayer(' restrictToRequestBBOX=\'1\' 
> srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' 
> url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\ 
> <https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>' 
> version=\'auto\' table="" sql=',"example06","WFS")
>
> iface.addVectorLayer(' restrictToRequestBBOX=\'1\' 
> srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' 
> url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\ 
> <https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>' 
> version=\'auto\' table="" sql=',"example07","WFS")
>
> iface.addVectorLayer(' restrictToRequestBBOX=\'1\' 
> srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' 
> url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\ 
> <https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>' 
> version=\'auto\' table="" sql=',"example08","WFS")
>
> iface.addVectorLayer(' restrictToRequestBBOX=\'1\' 
> srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' 
> url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\ 
> <https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>' 
> version=\'auto\' table="" sql=',"example09","WFS")
>
> iface.addVectorLayer(' restrictToRequestBBOX=\'1\' 
> srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' 
> url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\ 
> <https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>' 
> version=\'auto\' table="" sql=',"example00","WFS")
>
> iface.addVectorLayer(' restrictToRequestBBOX=\'1\' 
> srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' 
> url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\ 
> <https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>' 
> version=\'auto\' table="" sql=',"example11","WFS")
>
> iface.addVectorLayer(' restrictToRequestBBOX=\'1\' 
> srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' 
> url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\ 
> <https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>' 
> version=\'auto\' table="" sql=',"example12","WFS")
>
> iface.addVectorLayer(' restrictToRequestBBOX=\'1\' 
> srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' 
> url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\ 
> <https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>' 
> version=\'auto\' table="" sql=',"example13","WFS")
>
> iface.addVectorLayer(' restrictToRequestBBOX=\'1\' 
> srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' 
> url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\ 
> <https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>' 
> version=\'auto\' table="" sql=',"example14","WFS")
>
> iface.addVectorLayer(' restrictToRequestBBOX=\'1\' 
> srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' 
> url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\ 
> <https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>' 
> version=\'auto\' table="" sql=',"example15","WFS")
>
> iface.addVectorLayer(' restrictToRequestBBOX=\'1\' 
> srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' 
> url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\ 
> <https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>' 
> version=\'auto\' table="" sql=',"example16","WFS")
>
> iface.addVectorLayer(' restrictToRequestBBOX=\'1\' 
> srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' 
> url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\ 
> <https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>' 
> version=\'auto\' table="" sql=',"example17","WFS")
>
> iface.addVectorLayer(' restrictToRequestBBOX=\'1\' 
> srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' 
> url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\ 
> <https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>' 
> version=\'auto\' table="" sql=',"example18","WFS")
>
> iface.addVectorLayer(' restrictToRequestBBOX=\'1\' 
> srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' 
> url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\ 
> <https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>' 
> version=\'auto\' table="" sql=',"example19","WFS")
>
> iface.addVectorLayer(' restrictToRequestBBOX=\'1\' 
> srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' 
> url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\ 
> <https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>' 
> version=\'auto\' table="" sql=',"example10","WFS")
>
> iface.addVectorLayer(' restrictToRequestBBOX=\'1\' 
> srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' 
> url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\ 
> <https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>' 
> version=\'auto\' table="" sql=',"example21","WFS")
>
> iface.addVectorLayer(' restrictToRequestBBOX=\'1\' 
> srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' 
> url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\ 
> <https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>' 
> version=\'auto\' table="" sql=',"example22","WFS")
>
> iface.addVectorLayer(' restrictToRequestBBOX=\'1\' 
> srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' 
> url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\ 
> <https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>' 
> version=\'auto\' table="" sql=',"example23","WFS")
>
> iface.addVectorLayer(' restrictToRequestBBOX=\'1\' 
> srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' 
> url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\ 
> <https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>' 
> version=\'auto\' table="" sql=',"example24","WFS")
>
> iface.addVectorLayer(' restrictToRequestBBOX=\'1\' 
> srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' 
> url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\ 
> <https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>' 
> version=\'auto\' table="" sql=',"example25","WFS")
>
> iface.addVectorLayer(' restrictToRequestBBOX=\'1\' 
> srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' 
> url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\ 
> <https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>' 
> version=\'auto\' table="" sql=',"example26","WFS")
>
> iface.addVectorLayer(' restrictToRequestBBOX=\'1\' 
> srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' 
> url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\ 
> <https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>' 
> version=\'auto\' table="" sql=',"example27","WFS")
>
> iface.addVectorLayer(' restrictToRequestBBOX=\'1\' 
> srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' 
> url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\ 
> <https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>' 
> version=\'auto\' table="" sql=',"example28","WFS")
>
> iface.addVectorLayer(' restrictToRequestBBOX=\'1\' 
> srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' 
> url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\ 
> <https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>' 
> version=\'auto\' table="" sql=',"example29","WFS")
>
> iface.addVectorLayer(' restrictToRequestBBOX=\'1\' 
> srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' 
> url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\ 
> <https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>' 
> version=\'auto\' table="" sql=',"example20","WFS")
>
> iface.addVectorLayer(' restrictToRequestBBOX=\'1\' 
> srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' 
> url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\ 
> <https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>' 
> version=\'auto\' table="" sql=',"example31","WFS")
>
> iface.addVectorLayer(' restrictToRequestBBOX=\'1\' 
> srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' 
> url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\ 
> <https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>' 
> version=\'auto\' table="" sql=',"example32","WFS")
>
> iface.addVectorLayer(' restrictToRequestBBOX=\'1\' 
> srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' 
> url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\ 
> <https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>' 
> version=\'auto\' table="" sql=',"example33","WFS")
>
> iface.addVectorLayer(' restrictToRequestBBOX=\'1\' 
> srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' 
> url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\ 
> <https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>' 
> version=\'auto\' table="" sql=',"example34","WFS")
>
> iface.addVectorLayer(' restrictToRequestBBOX=\'1\' 
> srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' 
> url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\ 
> <https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>' 
> version=\'auto\' table="" sql=',"example35","WFS")
>
> iface.addVectorLayer(' restrictToRequestBBOX=\'1\' 
> srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' 
> url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\ 
> <https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>' 
> version=\'auto\' table="" sql=',"example36","WFS")
>
> iface.addVectorLayer(' restrictToRequestBBOX=\'1\' 
> srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' 
> url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\ 
> <https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>' 
> version=\'auto\' table="" sql=',"example37","WFS")
>
> iface.addVectorLayer(' restrictToRequestBBOX=\'1\' 
> srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' 
> url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\ 
> <https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>' 
> version=\'auto\' table="" sql=',"example38","WFS")
>
> iface.addVectorLayer(' restrictToRequestBBOX=\'1\' 
> srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' 
> url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\ 
> <https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>' 
> version=\'auto\' table="" sql=',"example39","WFS")
>
> iface.addVectorLayer(' restrictToRequestBBOX=\'1\' 
> srsname=\'EPSG:4326\' typename=\'sdr:nyu_2451_34490\' 
> url=\'https://maps-public.geo.nyu.edu/geoserver/sdr/wfs\ 
> <https://maps-public.geo.nyu.edu/geoserver/sdr/wfs%5C>' 
> version=\'auto\' table="" sql=',"example30","WFS")
>
>
>
>
> On Aug 21, 2017 12:55 PM, "Jorge Gustavo Rocha" <jgr at di.uminho.pt 
> <mailto:jgr at di.uminho.pt>> wrote:
>
>     Hi Dan,
>
>     QGIS uses a local SpatiaLite database to store the features on the
>     client side. The cache should be in your .qgis2/cache/wfsprovider
>     folder. Can you check the contents of the folder?
>
>     If your WFS is a public server, can your share the service URL and the
>     layer/layers to reproduce the problem?
>
>     Regards,
>
>     J. Gustavo
>
>     On 21-08-2017 16 <tel:21-08-2017%2016>:42, Dan Meerschaert wrote:
>     > I'm working on a plugin for QGIS 2.18.7 on Windows that (as a
>     part of
>     > its other function) grabs many wfs layers at once.
>     >
>     > The problem is, after about 30-50 simultaneous connections, QGIS
>     throws
>     > up a "Cannot create temporary SpatiaLite cache" error in the WFS log
>     > panel and doesn't load all the data.
>     >
>     > I'm able to repeat this by picking any given wfs layer, and
>     duplicating
>     > it manually using iface.addVectorLayer (...) in the python console.
>     >
>     > Can anyone help me out?
>     >
>     > Respectfully,
>     > -Dan
>     >
>     >
>     > _______________________________________________
>     > Qgis-user mailing list
>     > Qgis-user at lists.osgeo.org <mailto:Qgis-user at lists.osgeo.org>
>     > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>     <https://lists.osgeo.org/mailman/listinfo/qgis-user>
>     > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>     <https://lists.osgeo.org/mailman/listinfo/qgis-user>
>     >
>
>     J. Gustavo
>     --
>     Jorge Gustavo Rocha
>     Departamento de Informática
>     Universidade do Minho
>     4710-057 Braga
>     Tel: +351 253604480 <tel:%2B351%20253604480>
>     Fax: +351 253604471 <tel:%2B351%20253604471>
>     Móvel: +351 910333888 <tel:%2B351%20910333888>
>     skype: nabocudnosor
>     _______________________________________________
>     Qgis-user mailing list
>     Qgis-user at lists.osgeo.org <mailto:Qgis-user at lists.osgeo.org>
>     List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>     <https://lists.osgeo.org/mailman/listinfo/qgis-user>
>     Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>     <https://lists.osgeo.org/mailman/listinfo/qgis-user>
>
>
>
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

-- 
*_Richard McDonnell_*
*GIS Specialist PgD GIS AssocSCSI*
*OPW FRM Data Management*
*52 Stephens Green, Dublin 2.*
TEL: 01 6476543

OPW - Ag féachaint don am atá le teacht - Ag caomhnú ón am atá thart
OPW - Looking to the future - Caring for the past

***********************************************************
Email Disclaimer: http://www.opw.ie/en/disclaimer/

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20170822/62398b33/attachment.html>


More information about the Qgis-user mailing list