Climate Risk Database Tools
Basic statistics for fields tool
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”.
Tool: Basic Statistics for Fields, QGIS
List unique values
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”)
Tool: List Unique Values, QGIS
Sample raster values
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.
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.
DB Manager tool
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.
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.
Tool: Random selection, QGIS
Raster layer unique values
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”
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.
Error matrix tool
In the context of quality control, error matrices are created when evaluating e.g. positional accuracy of vector objects by comparing the evaluated dataset to a reference data. As a result, error matrix gives an overall quality percentage of the accuracy.
Raster layer statistics
This tool quickly and easily computes the basic statistics for raster layers, including minimum and maximum values, range and standard deviation.
Symbology and Transparency
In context of checking “No Data” values in raster layers, the Transparency and Symbology tabs are a useful tool. In addition to absolute count of “No Data” pixels, Symbology and Transparency helps to visually examine of where the “No Data” pixels are located in the layer: are they around the area of interest as they should be if the area of interest is not a square, or can individual pixels be found from the middle of the study area?
Show statistical summary
This is a very quick tool to draw a few statistical parameters for vector dataset’s fields. This tool shows the count, number of missing and unique values, and minimum and maximum of a field, all without opening any separate tools. Note: see also tool “Basic statistics for fields”.
Tool: Show Statistical Summary, QGIS