5

Can anyone provide a list of the spatial functions available in the QGIS DB Manager plugin when using shapefiles as Virtual Layers?

I've been trying to use things like ST_DWithin and even ST_Buffer but the queries fail - though ST_Intersects and other functions work just fine.

2

ST_Buffer works for me.

The virtual layer documentation states:

The underlying engine uses SQLite and Spatialite to operate. It means you can use all of the SQL your local installation of SQLite understands. Functions from SQLite and spatial functions from Spatialite can also be used in a virtual layer query.

enter image description here

The airports layer in this example is as Shapefile from the QGIS sample data.

  • ST_Buffer doesn't work on shapfiles... if you can verify, that would be great... otherwise, yes... can't find a reference either! Is that all part of the plugin itself? – DPSSpatial Dec 9 '16 at 18:38
  • The airports layer in my screenshot example is a Shapefile. DB Manager is a core plugin. You can also create Virtual layers from the menu Layer | Add Layer – underdark Dec 9 '16 at 18:42
  • I don't understand what's going on then... I can't buffer or transform geometry from a shapefile but I can intersect... – DPSSpatial Dec 9 '16 at 18:47
  • Maybe there is an issue on your platform. Which operating system are you using? – underdark Dec 10 '16 at 13:37
  • Tried at home on Linux Mint to no avail either... tried different data, can't get it to work... – DPSSpatial Dec 10 '16 at 18:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.