Integrating Postgresql and R: Open-Source Tools For Processing and Reporting Monitoring Data

Fig. 1.

Fig. 2.

Fig. 3.

Fig. 4.

Fig. 5.

Fig. 6.

Fig. 1.

Fig. 2.

Fig. 3.

Fig. 4.

Fig. 5.

Fig. 6.

Summary of thematic indicators for hydrological data with formulas according to Bajkiewicz-Grabowska et al_ (1993) and Ozga-Zielinska, Brzezinski (1997)_

Parameters	Description	Formula
Q	Discharge in cubic meters per second
P	Precipitation in millimetres
NQ, SQ, WQ	Minimum (NQ), mean (SQ) and maximum (WQ) values calculated based on daily discharge (Q)	SQ=∑i=1nQin$SQ = {{\mathop \sum \limits_{i = 1}^n {Q_i}} \over n}$
AQ	Relative amplitude of discharge	AF=(WQ−NQ)SQ$AF = {{\left( {WQ - NQ} \right)} \over {SQ}}$
Long-term discharge characteristics
WNQ, WSQ, WWQ	Maximum extreme discharges are the highest values calculated using annual NQ, SQ and WQ values.
NNQ, NSQ, NWQ	Minimum extreme discharges are the lowest values calculated, respectively, using annual NQ, SQ and WQ values.
SNQ, SSQ, SWQ	Mean discharge is the mean value calculated using annual NQ, SQ and WQ values.	SNQ=∑i=1nNQin$SNQ = {{{{\sum\nolimits_{i = 1}^n {NQ} }_i}} \over n}$SSQ=∑i=1nSQin$SSQ = {{{{\sum\nolimits_{i = 1}^n {SQ} }_i}} \over n}$SWQ=∑i=1nWQin$SWQ = {{{{\sum\nolimits_{i = 1}^n {WQ} }_i}} \over n}$
Hydrological parameters
q	Specific discharge is a discharge of water per unit area of a drainage basin expressed in litre per second per square kilometres.	q=1000·QA$q = {{1000.Q} \over A}$A – catchment area
O	Runoff depth is calculated as the runoff volume from a drainage basin divided by its area in a specific time, and is expressed in millimetres.	O=Q·t·10−3A$O = {{Q.t.{{10}^{ - 3}}} \over A}$A – catchment area
a	Runoff coefficient is the ratio of runoff depth to precipitation depth.	a=OP$a = {O \over P}$
k	Monthly discharge coefficient, k > 1 indicates months with the mean discharge (SQ) above the annual mean discharge calculated for the multi-year period, whereas k < 1 shows the months with mean discharge (SQ) below the annual mean discharge calculated for the multi-year period.	k=SQmonth SQyear $k = {{S{Q_{month{\rm{\;}}}}} \over {S{Q_{year{\rm{\;}}}}}}$
Flow level categories
HH	High above normal	Q ≥ SWQ
HM	Above normal	SWQ ≥ Q ≥ NWQ
NF	Normal flow
LM	Below normal	SNQ ≤ Q ≤ 0.5 · (NSQ + WNQ)
LL	Low below normal	Q ≤ SNQ