QGIS Datasets and Databases
-
Intro
-
Useful Datasets
-
QGIS | Databases
-
Useful links
Information
| Primary software used | QGIS |
| Software version | 1.0 |
| Course | QGIS Datasets and Databases |
| Primary subject | 3D Modelling |
| Secondary subject | Geospatial and Geographic Information Systems |
| Level | Intermediate |
| Last updated | November 11, 2024 |
| Keywords |
Responsible
| Faculty |
QGIS Datasets and Databases 0/3
QGIS Datasets and Databases link copied
This section addresses how to use databases in QGIS
A database is a structured collection of data stored on and accessible through a computer system. This section contains information on how to work with spatial databases. You will learn how to use PostGIS and PostgreSQL in QGIS.
QGIS Datasets and Databases 1/3
Useful Datasets link copied
This page contains several useful links to datasets throughout the Netherlands. The links are divided by scale, namely: general, provinces, main municipalities (Randstad). Take into account that direct links to datasets are constantly changing and can be broken.
General Dutch Datasets
WFS connections:
| Feature | Data source | Layer name | Link |
| Building footprints | BAG | pand | Link |
| Building footprints (+ height) | 3D BAG | 3D BAG | Link |
| Road network | NWB | wegvakken | Link |
Please note: the links provided in the table above are not the WFS URLs. Since these datasets are regularly updated, the WFS URL linked to a specific dataset can change over time depending on the latest version. The latest WFS URL for each dataset can be found by clicking on the link provided and selecting the URL of the WFS web-service.
ArcGIS Feature Server connections:
| Feature | Data source | Layer name | Link |
| Water | BGT | waterdeel_v | Link |
| Vegetation | BGT | begroeidTerreindeel_v | Link |
| Trees | BGT | vegetatieObject_p | Link |
Data links:
Enexis dataset on electricity and gas (e.g. street lightning and gas infrastructure)
Provinces and main municipalities
Brabant
Source:
- Geo datasets province of Brabant
Amsterdam
Source:
- General datasets municipality of Amsterdam
- Specific datasets municipality of Amsterdam
Finding data
The following tutorial covers where and how to find data.
Erik Meerburg (3D geoinformation research group): “Urbanism GIS course 7: Finding data”
you can access this video using this link
Language(s): English
Time: 9min
QGIS Datasets and Databases 2/3
QGIS | Databases link copied
The following tutorials make use of PostgreSQL and PostGIS. PostgreSQL is an open source object-relational database system that uses the Structured Query Language (SQL) language to manage data. PostGIS is an extender for PostgreSQL and help to manage geographic objects. QGIS also supports SpatiaLite databases, which allow to store an entire database in a single file.
Spatial Database
A spatial database contains data related to objects defined in space.
How to work with spatial databases
- QGIS Training manual: “18. Module: Using Spatial Databases in QGIS”
you can access this manual using this link
Language(s): English
Chapters:- working with databases in the QGIS browser
- using DB Manager to work with spatial databases in QGIS
- working with SpatiaLite databases in QGIS
PostGIS
PostGIS is a spatial database extender for PostgreSQL object-relational database. It allows location queries to run in SQL.
Setup a spatial database, import data and make use of the geographic functions of PostGIS
- QGIS Training manual: “16. Module: Spatial Database Concepts with PostGIS”
you can access this manual using this link
Language(s): English
Chapters:- PostGIS setup
- simple feature model
- import and export
- spatial queries
- geometry construction
Create a database, add a PostGIS extension and load layers via the DB-manager
- Mariëlle Geers-Plasmans (Geojuffie): “Introductie PostGIS”
you can access this video using this link
Language(s): Dutch
Time: 14m 4s
Introduction to SQL queries
- Mariëlle Geers-Plasmans (Geojuffie): “SQL in PostGIS”
you can access this video using this link
Language(s): Dutch
Time: 7m 2s
Join tables in PostGIS
- Mariëlle Geers-Plasmans (Geojuffie): “Join in PostGIS”
you can access this video using this link
Language(s): Dutch
Time: 5m 34s
PostgreSQL
PostgreSQL is an object-relational database management system. It uses the SQL language, is free, open source and highly extensible.
Learn about databases and PostgreSQL
- QGIS Training manual: “15. Module: Database Concepts with PostgreSQL”
you can access this manual using this link
Language(s): English
Chapters:- introduction to databases
- implementing the data model
- adding data to the model
- queries, views
- rules