{% extends "static/bootstrap_base.html" %} {% block content %}

General information

Current salinity (TDS in mg/L)

Each data point represents one salinity value per well. If a well has multiple data points in the calendar year, they are averaged. Any wells excluded through the data validation process is not included in this chart.

Summary descriptive statistics for all wells with annual mean salinities are below. The numbers in this table should match those shown on the chart above:

{{ anntds_summ.to_html(index=True, classes=["table", "table-sm", "table-hover"])|safe }}

The list of wells with current salinity values is shown here, ordered by salinity value:

{{ anntds.reset_index().to_html(classes=["table", "table-sm", "table-hover"])|safe }}

Long-term status (pct_diff: % difference to long-term mean)

{{ curr_pct_diff_summ.to_html(index=False, classes=["table", "table-sm", "table-hover"])|safe }} {{ curr_pct_diff_summ_1.to_html(index=True, classes=["table", "table-sm", "table-hover"])|safe }} {{ curr_pct_diff.sort_values("curr_tds_pct_diff").reset_index().round(2)[["well_id", "mean_tds", "curr_tds", "curr_tds_pct_diff", "curr_tds_pct_diff_indicator"]].to_html(index=True, classes=["table", "table-sm", "table-hover"])|safe }}

Long-term trend (tds_trend_pct: % change over period)

{{ trend_pct_summ.to_html(index=False, classes=["table", "table-sm", "table-hover"])|safe }} {{ trend_pct_summ_1.to_html(index=True, classes=["table", "table-sm", "table-hover"])|safe }} {{ trend_pct.sort_values("slope_pct_change_yr").reset_index().round(2)[["well_id", "mean_tds", "curr_tds", "slope_pct_change_yr", "slope_pct_change_trend_pd", "tds_trend_pct_change_indicator"]].to_html(index=True, classes=["table", "table-sm", "table-hover"])|safe }}

These results show triclass trends (i.e. classified by increasing/stable/decreasing):

... by mg/L/y

Summary statistics of mg/L/y broken down by "status_change":

{{ tdstrends_mgl_summ_1.to_html(index=True, classes=["table", "table-sm", "table-hover"])|safe }}

Summary statistics for mg/L/y for all wells with 5-year trend results:

{{ tdstrends_mgl_summ_2.to_html(index=True, classes=["table", "table-sm", "table-hover"])|safe }}

... by mg/L per 5 year period and by % change over 5 years

Summary statistics for five-year change in salinity in both mg/L and as % change -- broken down by "status_change":

{{ tdstrends_5yr_summ_1.to_html(index=True, classes=["table", "table-sm", "table-hover"])|safe }}

Summary statistics for five-year change in salinity in both mg/L and as % change -- for all wells:

{{ tdstrends_5yr_summ_2.to_html(index=True, classes=["table", "table-sm", "table-hover"])|safe }}

All wells with 5-year trend results, ordered by rate of change:

{{ tdstrends.sort_values("slope_yr").reset_index().to_html(index=False, classes=["table", "table-sm", "table-hover"])|safe }}

Long-term salinity changes

{{ tdschange.to_html(index=False, classes=["table", "table-sm", "table-hover"])|safe }}

{% endblock %}