8. Data Domains (Dictionaries) - jkall/qgis-midvatten-plugin GitHub Wiki

There are a number of tables in the database beginning with "zz_" which are used as data domains for both the database and also for some plugin features.

The domains can be loaded into QGIS for inspection and editing by selecting "Midvatten - Utilities - Load data domains into QGIS"

Data domains as constraints for values in the database

For plugin version 1.4 this contains tables zz_flowtype, zz_meteoparam, zz_staff.

Some tables use zz-tables as foreign key tables. The purpose is to keep words meaning the same thing from diverting (ex: reduce risk of "Momflow" in table w_flow column flowtype diverting into "Momflow", "momflow", "momflow ").

In version 1.4 this constraint is only semi-implemented. When inserting/changing values manually while editing in QGis, the constraint will activate and the user have to update the corresponding zz-table first. But when using any of the import features in Midvatten plugin, the zz-tables will be updated automatically with required values.

Data domains as dictionaries for specific features in Midvatten plugin

Data domains as legends for stratigraphy and section plot

zz_capacity and zz_capacity_plots

The table zz_capacity_plots sets the color for each capacity value in zz_capacity which is used in stratigraphy plots.

The table zz_capacity contains capacity values and an explanation which should correspond to the capacity values in table stratigraphy.

zz_strat and zz_stratigraphy_plots

The table zz_stratigraphy_plots sets the colors and symbols for categorized strata values (soil type) which is used in section and stratigraphy plots.

The table zz_strat is used to categorize synonyms of soil types into a single soil type to use in zz_stratigraphy_plots. For example both "coarse gravel" and "cgr" could both be categorized as "coarce gravel" to be represented by the same symbology in zz_stratigraphy_plots.