Item


QGIS Virtual Layers: mix them all data!

A new feature landed recently in QGIS : Virtual layers. Virtual Layers are database views over existing QGIS (vector) layers. These layers can be built by the use of the powerful SQL language and then allow for advanced uses in a consistent manner : joins between different layers, including spatial joins, subset selection, type conversion, on-the-fly attribute and geometry generation, etc. The following operations are now supported in QGIS : you can create a new virtual layer through the “New layer” menu; you can open a saved virtual layer through the “Add layer” menu; a virtual layer can be created out of a layer selection by right click in the context menu; If you want to filter a layer that has “joins”, it will propose to copy it to a virtual layer and In DBManager, there is a new entry “virtual layers” where you can use an SQL query to setup a virtual layer. This presentation will explain the concepts and show the current available features provided by this implementation

Universitat de Girona. Servei de Sistemes d’Informació Geogràfica i Teledetecció

Author: Blottiere, Paul
Date: 2016 May 26
Abstract: A new feature landed recently in QGIS : Virtual layers. Virtual Layers are database views over existing QGIS (vector) layers. These layers can be built by the use of the powerful SQL language and then allow for advanced uses in a consistent manner : joins between different layers, including spatial joins, subset selection, type conversion, on-the-fly attribute and geometry generation, etc. The following operations are now supported in QGIS : you can create a new virtual layer through the “New layer” menu; you can open a saved virtual layer through the “Add layer” menu; a virtual layer can be created out of a layer selection by right click in the context menu; If you want to filter a layer that has “joins”, it will propose to copy it to a virtual layer and In DBManager, there is a new entry “virtual layers” where you can use an SQL query to setup a virtual layer. This presentation will explain the concepts and show the current available features provided by this implementation
Format: audio/mp3
video/mp4
Document access: http://hdl.handle.net/10256.1/4304
Language: eng
Publisher: Universitat de Girona. Servei de Sistemes d’Informació Geogràfica i Teledetecció
Collection: 2nd International QGIS User and Developer Conference;
Rights: Attribution-NonCommercial-ShareAlike 3.0 Spain
Rights URI: http://creativecommons.org/licenses/by-nc-sa/3.0/es/
Subject: Sistemes d’informació geogràfica -- Congressos
Geographic information systems -- Congresses
Informació -- Sistemes d’emmagatzematge i recuperació -- Geografia -- Congressos
Information storage and retrieval systems -- Geography -- Congresses
Programari lliure -- Congressos
Open source software -- Congresses
Title: QGIS Virtual Layers: mix them all data!
Type: info:eu-repo/semantics/lecture
Repository: DUGiMedia

Subjects

Authors