database tables - jkall/qgis-midvatten-plugin GitHub Wiki
In each Midvatten database there is a metadata table named "about_db" which describes all the database tables with column names and descriptions.
A printout of the "about_db" metadata table is found below.
| tablename | columnname | description |
|---|---|---|
| * | * | This db was created by Midvatten plugin Version 1.3.21, running QGIS version 2.14.12-Essen on top of SpatiaLite version 4.1.1 |
| * | * | locale:sv_SE |
| about_db | * | A status log for the tables in the db |
| about_db | tablename | Name of a table in the db |
| about_db | columnname | Name of column |
| about_db | data_type | Data type of the column |
| about_db | not_null | 1 if NULL-values isn't allowed |
| about_db | default_value | The default value of the column |
| about_db | primary_key | 1 if column is a primary key |
| about_db | foreign_key | "foreign key table(foreign key column)" |
| about_db | description | Description for column or table |
| about_db | upd_date | Date for last update |
| about_db | upd_sign | Person responsible for update |
| comments | * | Comments connected to obsids |
| comments | obsid | Obsid linked to obs_points.obsid |
| comments | date_time | Date and Time for the comment |
| comments | comment | Comment |
| comments | staff | Staff who made the comment |
| comments | type | Can be used to distinguish different types of comments |
| meteo | * | meteorological observations |
| meteo | obsid | Obsid linked to obs_points.obsid |
| meteo | instrumentid | Instrument ID |
| meteo | parameter | The meteorological parameter |
| meteo | date_time | Date and Time for the observation |
| meteo | reading_num | Value (real number) reading for the parameter |
| meteo | reading_txt | Value as text (ex. can contain '>' and '<') |
| meteo | unit | Unit corresponding to the value reading |
| meteo | comment | Comment |
| obs_lines | * | One of the two main tables. This table holds all line observation objects. |
| obs_lines | obsid | ID for observation line |
| obs_lines | name | Ordinary name for the observation |
| obs_lines | place | Place for the observation |
| obs_lines | type | Type of observation |
| obs_lines | source | The origin for the observation |
| obs_lines | geometry | None |
| obs_points | * | One of the two main tables. This table holds all point observation objects. |
| obs_points | obsid | ID for the observation point |
| obs_points | name | Ordinary name for the observation |
| obs_points | place | Place for the observation. E.g. estate |
| obs_points | type | Type of observation |
| obs_points | length | Borehole length from ground surface to bottom (equals to depth if vertical) |
| obs_points | drillstop | Drill stop (ex "Driven to bedrock") |
| obs_points | diam | Inner diameter for casing or upper part of borehole |
| obs_points | material | Well material |
| obs_points | screen | Type of well screen |
| obs_points | capacity | Well capacity |
| obs_points | drilldate | Date when drilling was completed |
| obs_points | wmeas_yn | 1/0 if water level is to be measured for this point or not |
| obs_points | wlogg_yn | 1/0 if water level if borehole is equipped with a logger or not |
| obs_points | east | Eastern coordinate (in the corresponding CRS) |
| obs_points | north | Northern coordinate (in the corresponding CRS) |
| obs_points | ne_accur | Approximate inaccuracy for coordinates |
| obs_points | ne_source | Source for the given position |
| obs_points | h_toc | Elevation (masl) for the measuring point |
| obs_points | h_tocags | Distance from Measuring point to Ground Surface (m) |
| obs_points | h_gs | Ground Surface level (m). |
| obs_points | h_accur | Inaccuracy (m) for Measuring Point level |
| obs_points | h_syst | Reference system for elevation |
| obs_points | h_source | Source for the measuring point elevation (consultancy report or similar) |
| obs_points | source | The source for the observation point |
| obs_points | com_onerow | Onerow comment |
| obs_points | com_html | Multiline formatted comment in html format |
| obs_points | geometry | None |
| seismic_data | * | Interpreted data from seismic measurements |
| seismic_data | obsid | Obsid linked to obs_lines.obsid |
| seismic_data | length | Length along line |
| seismic_data | ground | Ground surface level |
| seismic_data | bedrock | Interpreted level for bedrock surface |
| seismic_data | gw_table | Interpreted level for limit between unsaturated/saturated conditions |
| seismic_data | comment | Additional info |
| stratigraphy | * | Stratigraphy information from drillings |
| stratigraphy | obsid | Obsid linked to obs_points.obsid |
| stratigraphy | stratid | Stratigraphy layer ID for the OBSID |
| stratigraphy | depthtop | Top of the layer in m from ground surface |
| stratigraphy | depthbot | Bottom of the layer in m from ground surface |
| stratigraphy | geology | Full description of geology |
| stratigraphy | geoshort | Short description of geology |
| stratigraphy | capacity | Well development at the layer |
| stratigraphy | development | Well development - Is the flushed water clear and free of suspended solids? |
| stratigraphy | comment | Comment |
| vlf_data | * | Raw data from VLF measurements |
| vlf_data | obsid | Obsid linked to obs_lines.obsid |
| vlf_data | length | Length along line |
| vlf_data | real_comp | Raw data real component (in-phase(%)) |
| vlf_data | imag_comp | Raw data imaginary component |
| vlf_data | comment | Additional info |
| w_flow | * | Water flow |
| w_flow | obsid | Obsid linked to obs_points.obsid |
| w_flow | instrumentid | Instrument Id |
| w_flow | flowtype | Flowtype must correspond to type in flowtypes |
| w_flow | date_time | Date and Time for the observation |
| w_flow | reading | Value (real number) reading for the flow rate |
| w_flow | unit | Unit corresponding to the value reading |
| w_flow | comment | Comment |
| w_levels | * | Manual water level measurements |
| w_levels | obsid | Obsid linked to obs_points.obsid |
| w_levels | date_time | Date and Time for the observation |
| w_levels | meas | Distance from measuring point to water level |
| w_levels | h_toc | Elevation (masl) for the measuring point at the particular date_time (measuring point elevation may vary by time) |
| w_levels | level_masl | Water level elevation (masl) calculated from measuring point and distance from measuring point to water level |
| w_levels | comment | Comment |
| w_levels_logger | * | Automatic water level readings |
| w_levels_logger | obsid | Obsid linked to obs_points.obsid |
| w_levels_logger | date_time | Date and Time for the observation |
| w_levels_logger | head_cm | Pressure (cm water column) on pressure transducer |
| w_levels_logger | temp_degc | Temperature degrees C |
| w_levels_logger | cond_mscm | Electrical conductivity mS/cm |
| w_levels_logger | level_masl | Corresponding Water level elevation (masl) |
| w_levels_logger | comment | Comment |
| w_levels_logger | source | The source of the measurement (used to keep series apart) |
| w_qual_field | * | Water quality from field measurements |
| w_qual_field | obsid | Obsid linked to obs_points.obsid |
| w_qual_field | staff | Field staff |
| w_qual_field | date_time | Date and Time for the observation |
| w_qual_field | instrument | Instrument ID |
| w_qual_field | parameter | Measured parameter |
| w_qual_field | reading_num | Value as real number |
| w_qual_field | reading_txt | Value as text (ex. can contain '>' and '<') |
| w_qual_field | unit | Unit |
| w_qual_field | depth | The depth at which the measurement was done |
| w_qual_field | comment | Comment |
| w_qual_lab | * | Water quality from laboratory analysis |
| w_qual_lab | obsid | Obsid linked to obs_points.obsid |
| w_qual_lab | depth | Depth (m below h_gs) from where sample is taken |
| w_qual_lab | report | Report no from laboratory |
| w_qual_lab | project | Project number |
| w_qual_lab | staff | Field staff |
| w_qual_lab | date_time | Date and Time for the observation |
| w_qual_lab | anameth | Analysis method |
| w_qual_lab | parameter | Measured parameter |
| w_qual_lab | reading_num | Value as real number |
| w_qual_lab | reading_txt | Value as text (ex. can contain '>' and '<') |
| w_qual_lab | unit | Unit |
| w_qual_lab | comment | Comment |
| zz_capacity | * | Data domain for capacity classes used by the plugin |
| zz_capacity | capacity | Water capacity (ex. in the range 1-6) |
| zz_capacity | explanation | Description of water capacity classes |
| zz_capacity_plots | * | Data domain for capacity plot colors used by the plugin |
| zz_capacity_plots | capacity | Water capacity (ex. in the range 1-6) |
| zz_capacity_plots | color_qt | Hatchcolor codes for Qt plots |
| zz_flowtype | * | Data domain for flowtypes in table w_flow |
| zz_flowtype | type | Allowed flowtypes |
| zz_flowtype | explanation | Explanation of the flowtypes |
| zz_meteoparam | * | Data domain for meteorological parameters in meteo |
| zz_meteoparam | parameter | Allowed meteorological parameters |
| zz_meteoparam | explanation | Explanation of the parameters |
| zz_staff | * | Data domain for field staff used when importing data |
| zz_staff | staff | Initials of the field staff |
| zz_staff | name | Name of the field staff |
| zz_strat | * | Data domain for stratigraphy classes |
| zz_strat | geoshort | Abbreviation for the strata (stratigraphy class) |
| zz_strat | strata | clay etc |
| zz_stratigraphy_plots | * | Data domain for stratigraphy plot colors and symbols used by the plugin |
| zz_stratigraphy_plots | strata | clay etc |
| zz_stratigraphy_plots | color_mplot | Color codes for matplotlib plots |
| zz_stratigraphy_plots | hatch_mplot | Hatch codes for matplotlib plots |
| zz_stratigraphy_plots | color_qt | Color codes for Qt plots |
| zz_stratigraphy_plots | brush_qt | Brush types for Qt plots |