> Objective

• This section shows how to work with attribute data. 

• The students will learn about how to manage attribute tables.  

> Index / Table of Contents

• Introduction  

• Tutorial(s)  

  • Basics 

  • Attribute join  

  • Attribute selection  

  • Column edition in attribute tables 

  • Form widgets 

• QGIS installation  

> Summary and Highlights

Introduction 

The following tutorials address attribute data. First, some tutorials on basic functions are listed. Then, the section refers to tutorials on how to join, select and edit attribute tables. The last part covers the creation of forms that help to manage attributes.     

Tutorial(s) 

Basics 

The following links present some general information about QGIS attributes. 

• Basics of viewing attribute data and create attributes   TOI-pedia: “Working with attribute data”  Language(s): English  Chapters: introduction, procedure (identify results, opening the attribute table, selecting features, creating a new attribute)  http://wiki.bk.tudelft.nl/toi-pedia/Working_with_attribute_data  

• Learn about the structure of vector data and explore the attribute data of an object   QGIS Training manual: “3.1. Vector Attribute Data”  Language(s): English  Chapters: follow along: viewing layer attributes, try yourself exploring vector data attributes, in conclusion, what’s next   https://docs.qgis.org/3.10/en/docs/training_manual/vector_classification/attribute_data.html 

• Query and find a subset of capital cities in the world and save it as a GeoJSON file   Ujaval Gandhi: “Working with Attributes (QGIS3)”/”Werken met attributen (QGIS3)”  Language(s): English, Dutch   Chapters: get the data, procedure   EN: https://www.qgistutorials.com/en/docs/3/working_with_attributes.html   NL: https://www.qgistutorials.com/nl/docs/3/working_with_attributes.html

• Geoprocessing   Erik Meerburg (3D geoinformation research group): “Urbanism GIS Course 9: Geoprocessing”  Language(s): English 

Attribute join  

The following tutorials show how to join attributes. 

• Join an Excel file without geometry to a layer with a geometry   Mariëlle Geers-Plasmans (Geojuffie): “Tabellen koppelen QGIS op basis van kolomnaam”  Language(s): Dutch  Time: 6min 53s  https://www.youtube.com/watch?v=kJw4YP8ANgY  

• Create a population density map by performing table joins   Ujaval Gandhi: “Performing Table Joins (QGIS3)”/”Samenvoegen van tabellen uitvoeren (QGIS3)”  Language(s): English, Dutch   Chapters: overview of the task, get the data, procedure   EN: https://www.qgistutorials.com/en/docs/3/performing_table_joins.html   NL: https://www.qgistutorials.com/nl/docs/3/performing_table_joins.html  

• How to join attribute tables   Hans van der Kwast: “Join attribute tables in QGIS”  Language(s): English  Time: 1m 25s  https://www.youtube.com/watch?v=aTEHmZqpqC0  

• Create filters to temporarily exclude certain features from computation   Ujaval Gandhi: “Performing Spatial Joins (QGIS3)”/”Ruimtelijke samenvoegingen uitvoeren (QGIS3)”  Language(s): English, Dutch   Chapters: overview of the task, get the data, procedure  EN: https://www.qgistutorials.com/en/docs/3/performing_spatial_joins.html   NL: https://www.qgistutorials.com/nl/docs/3/performing_spatial_joins.html  

• Join attributes of outlets to the derived polygons of the subcatchments   Hans van der Kwast: “Join attributes of outlets to subcatchment polygons in QGIS”  Language(s): English  Time: 10m 4s  Chapters: introduction to the challenges (start-1:20), dissolve subcatchment polygons in batch (1:20-2:50), merge dissolved subcatchment polygons (2:50-4:14), snap outlets to the subcatchment boundaries (4:14-5:18), join attributes by location with the “touches” parameter (5:18-6:28), check results of the join (6:28-7:40), split subcatchment polygons into separate layers (7:40-8:55), check the final result (8:55-end)  https://www.youtube.com/watch?v=MLduwROzbuM  

• Join attributes   Erik Meerburg (Geogoeroe): “Een simpele Join in QGIS...”  Language(s): Dutch  Time: 7min 03s  https://www.youtube.com/watch?v=BxU9p5fQFv0  

Attribute selection   

The following tutorials show how to select attributes. 

• Select objects manually   Mariëlle Geers-Plasmans (Geojuffie): “A01 Handmatig selecteren”  Language(s): Dutch  Time: 6m 32s  https://www.youtube.com/watch?v=k0f8NB0n75M  

• Selections  Erik Meerburg (3D geoinformation research group): “Urbanism GIS Course 8: Selections”  Language(s): English  Time: 10m 44s  https://www.youtube.com/watch?v=H2NSABvrPiw  

Column edition in attribute tables  

The following tutorials show how to edit attributes. 

• Add and delete columns in attribute tables  Mariëlle Geers-Plasmans (Geojuffie): “A02 Kolommen toevoegen/verwijderen”  Language(s): Dutch  Time: 6m 30s  https://www.youtube.com/watch?v=_1fTeUf4Sks  

• Edit columns in attribute tables  Mariëlle Geers-Plasmans (Geojuffie): “A03 Kolommen editen”  Language(s): Dutch  Time: 12m 53s   https://www.youtube.com/watch?v=Hi9COIaxJtw  

• Data preparation for a specific purpose: create a building function map and combine data from buildings and functions   Erik Meerburg (3D geoinformation research group): “Creating a building function”  Language(s): English  Time: 22m 25s  Chapters: intro (start-2:00), example (2:00-4:15), addresses (4:15-5:25), combining functions (5:25-7:20), joining functions (7:20-10:45), dissolve functions (10:45-15:20), data set (15:20-15:55), user friendly (15:55-16:55), field calculator (16:55-19:00), sum of functions (19:00-20:23), graduated map (20:23-end)  https://www.youtube.com/watch?v=0D_xVsaogp0  

Form widgets  

The following tutorial explains how to create a form and edit its fields. 

• Edit form widgets   Mariëlle Geers-Plasmans (Geojuffie): “A04 Formulier attributen/Form widgets”  Language(s): Dutch  Time: 25m 37s  https://www.youtube.com/watch?v=vw11cRSZFQc 

• Create a form for a layer  QGIS Training manual: “5.3. Forms”  Language(s): English  Chapters: follow along: using QGIS form design functionality, try yourself using the form to edit values, follow along: setting form field types, try yourself, try yourself creating test data, follow along: creating a new form, follow along: associating the form with your layer, in conclusion, further reading, what’s next   https://docs.qgis.org/3.10/en/docs/training_manual/create_vector_data/forms.html 

> QGIS Installation

Do you still need to install QGIS? The QGIS installation and update section explains how to install QGIS on Windows and macOS.  

Useful Links

QGIS Training Manual

QGIS User Guide

GIS OpenCourseWare

TOI-pedia 

Ujaval Gandhi (QGIS Tutorials and Tips website)

Erik Meerburg (3D geoinformation research group) YouTube channel

Mariëlle Geers-Plasmans (Geojuffie) YouTube channel

Hans van der Kwast YouTube channel

Erik Meerburg (Geogoeroe) YouTube channel

#QGIS, #Attributes, #Attribute tables, #Form widgets