Climate Risk Database Tools

Basic statistics for fields is probably the most useful tool to quickly get an overview of the features and statistics of vector datasets’ fields. With this tool, the fields’ basic statistics as well as number of empty cells and number of unique values can quickly be printed. Note: see also tool “Show statistical summary”.

Software: QGIS
Tool: Basic Statistics for Fields, QGIS

List unique values -tool gives the opportunity to examine all possible values stored in one attribute. With this tool, it is easy to check whether an attribute has all categories given in attribute metadata, or if there are categories with multiple different ways of writing (e.g. “Pine” and “pine”)

Software: QGIS
Tool: List Unique Values, QGIS

 In context of quality control, raster values needs to be sampled when calculating the error rate of positional accuracy of cell values. Usage of this tool requires preparing, which is instructed in the document as well.  

Software: QGIS

 DB Manager is popular tool for table managing and when working with SQL queries. Thus, it is useful to know basic skills of using DB Manager in QGIS. In the instructions, preparations for using DB Manager are explained, and links to other useful instructions are attached. 

Software: QGIS

DB Manager is a handy table management tool. In context of vector quality control, DB Manager can be used to check attribute table fields for duplicate values. Using DB Manager requires preparations, which are explained in the instructive document.

Software: QGIS
Tool: DB Manager – duplicate values in vector layers, QGIS

Group stats is a tool to quickly calculate statistics for classes or groups of vector dataset’s attributes. The tool provides basic statistics of, for example, minimum and maximum, sum, average or count of values in groups.

Software: QGIS, plugin

Random selection is a tool for vector datasets. With this tool, one can randomly select a fixed number or percentage of the vector objects. In the context of quality control, this tool helps the process of evaluating for example the positional accuracy of objects. In a large dataset, manually checking all objects is not reasonable, and through random selection the rate of error can more easily and especially reliably be evaluated.

Software: QGIS
Tool: Random selection, QGIS

 This tool quickly calculates the number of “No Data” pixels in a raster layer. This tool is useful in the process of checking raster layers for “No Data” values and should be used together with visual examination. See also tool “Symbology and Transparency”

Software: QGIS

Topology checker is a handy tool to check connectivity of vector layer’s topology. The tool checks, for example, whether vector lines are connected to each other or if polygons overlap each other. Different rules can be chosen according to the case, and a number of errors are given as a result. A good-quality vector dataset has a complete topology.

Software: QGIS