database views

A number of predefined views exist in the database, most of them are presented here.

This page is not yet updated according to latest database design!!

Spatial views loaded as default layers

• obs_p_w_qual_field - all obs_points with data in table w_qual_field
• obs_p_w_qual_lab - all obs_points with data in table w_qual_lab
• obs_p_w_strat - all obs_points with data in table stratigraphy
• obs_p_w_lvl - all obs_points with data in table w_levels
• w_lvls_last_geom - all the latest measurements in table w_levels

Spatial views, not loaded as default layers

These can be plotted in the qgis map window and, by a sql where clause on the qgis layer, you may map different parameters, at different date_time intervals. Appropriate for use in combination with the Time Manager plugin and/or gridding and creating isolines.

• w_qual_field_geom- the whole table w_qual_field with the corresponding geometry from obs_points added
• w_qual_lab_geom - a spatial view containing the whole table w_qual_lab with the corresponding geometry from obs_points added
• w_levels_geom - a spatial view containing the whole table w_levels with the corresponding geometry from obs_points added

Non-spatial views, not loaded as default layers

A few non-spatial views considering water flow will be predefined in a midvatten database, this is to make the water flow easilt plotted as time series plots:

• w_flow_aveflow - subset of table w_flow where flowtype = Aveflow;
• w_flow_momflow - subset of table w_flow where flowtype = Momflow;
• w_flow_accvol - subset of table w_flow where flowtype = Accvol;

The information below is only for historical reasons

Before plugin version 1.1, there were also a set of predefined non-spatial views related to water quality

w_qual_field_temp - subset of table w_qual_lab, where parameter='Temperatur'
w_qual_lab_hco3 - subset of table w_qual_lab, where parameter='Alkalinitet, HCO3'
w_qual_lab_kond - subset of table w_qual_lab, where parameter='Konduktivitet'
w_qual_lab_dh - subset of table w_qual_lab, where parameter='Hårdhet tyska grader';
w_qual_lab_ph - subset of table w_qual_lab, where parameter='pH';

These predefined non-spatial views were removed (although the user may of course define as many views he or she wants) since the introduction of the "custom plots" feature reduced the need for such views.