SoilWise Geopackage

Unit Of Measure

Definition

The uom attribute contains the unit of measurement and is an object that must contain either a code attribute with the UCUM code of the unit, or a href attribute with a URI pointing to a unit definition. It may also contain the label and symbol attributes that can be displayed in user interfaces. The unitOfMeasure is part of the SWE-Common structure description found in resultType. 1

SensorThings API 2.0 (23-019) (DRAFT),
version 23-019.
https://hylkevds.github.io/23-019/23-019.html

 

TABELLA SOILSITE EXP


 

Table: unitofmeasure

Columns

Name Type Constraints Description
id INTEGER PRIMARY KEY A unique, read-only attribute that serves as an identifier for the entity.
code TEXT   The Unified Code for Units of Measure is a code system intended to include all units of measures being contemporarily used in international science, engineering, and business.
label TEXT   A word or phrase used to name or describe something, often to identify or classify it.
symbol TEXT   Standardized, unambiguous string used to represent a unit of measure. Symbols are designed for machine-to-machine communication and ensure consistent interpretation of units across systems and applications.
qudt_unit TEXT   QUDT code, unit expressed using QUDT (Quantities, Units, Dimensions, and Data Types). https://qudt.org/vocab/unit/
base_qudt_unit TEXT   Base QUDT unit to define conversionmultiplier & conversionoffset. Generally SI (International System of Units) apart from pH; m/m; mm/m; a. Conversion offset and multiplier are referred as conversion factors from the UCUM unit to the Base QUDT.
base_qudt_label TEXT   QUDT label of the Base QUDT unit to define conversionmultiplier & conversionoffset. Generally SI (International System of Units) apart from pH; m/m; mm/m; a. Conversion offset and multiplier are referred as conversion factors from the UCUM unit to the Base QUDT unit.
conversionoffset REAL   Is the value added after applying the multiplier, used for units that do not start at zero relative to the reference unit.
conversionmultiplier REAL   Is the scaling factor used to convert a value from one unit to its reference unit (typically the SI base unit for that dimension).

Relationships (as child)

  • None

Referenced by (as parent)

  • datastream.code_unitofmeasure → unitofmeasure.code (ON UPDATE CASCADE, ON DELETE CASCADE)

Indexes

  • None

Triggers

  • None

  1. Hylke van der Schaaf — Open Geospatial Consortium (OGC), ↩