Secchi Depth Rate of Change Analysis

A rate of change is calculated for each station using a seasonal Mann Kendall slope calculation.

get data for params$batch_value

source(here::here(glue::glue("{params$batch_name}/getData.R")))

df <- getData(params$batch_value)

[1] "getting data for Secchi Depth"

create station statistics dataframe

library(here)
library(lubridate)  # for mdy_hms()
library(pander)  # for display
library(dplyr)  # for %>%
library(tidyr)  # for unnest_wider
source(here("R/seasonalMannKendall.R"))

# add statistics for each station
sample_stats_df <- df %>%
  group_by(ProgramName, ProgramLocationID, ParameterUnits) %>%
  summarize(
    AverageLatitude  = mean(OriginalLatitude,  na.rm = TRUE),
    AverageLongitude = mean(OriginalLongitude, na.rm = TRUE),
    mk_results = list(seasonalMannKendall(SampleDate, ResultValue)),
    n_values = n(),
    mean = mean(ResultValue, na.rm = TRUE),
    min = as.numeric(min(ResultValue, na.rm = TRUE)),
    max = as.numeric(max(ResultValue, na.rm = TRUE)),
    coefficient.of.variation = sd(ResultValue, na.rm = TRUE) / mean(ResultValue, na.rm = TRUE),
    .groups = 'drop'
  )

# unnest the seasonal Mann Kendall results
sample_stats_df <- sample_stats_df %>%
  tidyr::unnest_wider(mk_results)

sample_stats_df <- sample_stats_df %>%
  mutate(
    # create column significant_slope
    significant_slope = ifelse(z <= 0.05, slope, NA_real_),
    pvalue = z
  ) %>%
  # drop unwanted columns added by seasonalMannKendall
  select(
    -z,
    -tau,
    -chi_square
  )

# print(head(sample_stats_df))
# # display sample_stats_df with pander
# pander(sample_stats_df)

save stats to csv

dataDir <- here("data", "exports", params$batch_name)

# create dir if does not exist
if (!dir.exists(dataDir)) {
  dir.create(dataDir)
}

# save file
sample_stats_df %>%
  write.csv(paste0(dataDir, "/", params$batch_value, ".csv"))

plot distribution of slopes

library(ggplot2)

ggplot(sample_stats_df, aes(x = slope)) +
  geom_density(fill = "steelblue", linewidth=0.4, alpha = 0.3, bw = 0.001) +
  geom_density(fill = "steelblue", linewidth=0.1, alpha = 0.1, bw = 0.01) +
  geom_density(fill = "steelblue", linewidth=0.1, alpha = 0.1, bw = 0.1) +
  geom_vline(xintercept = 0, linetype = "dashed", color = "gray")+
  scale_y_continuous(trans = "sqrt") +
  labs(title = "Density of Site Slopes",
       x = "Slope (rate of change)",
       y = "Density") +
  theme_minimal()

display with gt

library(gt)
library(scales)
library(tidyselect)  # for all_of()
library(RColorBrewer) # for brewer.pal()

# ── color_column() ─────────────────────────────────────────────────────────────
# gt_tbl   : a gt object that you’ve already created (e.g. `sample_stats_df %>% gt()`)
# df       : the original data.frame (must contain the column you want to color)
# column   : a string, e.g. "slope" or "n_values"
# palette  : a character vector of colours to feed to col_numeric()
#
color_column <- function(gt_tbl, df, column, 
                         palette = c("red", "orange", "yellow", "green", "blue", "violet"),
                         domain = NULL) {
  # 1) Pull out that column’s numeric values
  vals <- df[[column]]
  if (!is.numeric(vals)) {
    stop(sprintf("`%s` is not numeric; data_color() requires a numeric column.", column))
  }
  
  # 2) Compute its min and max (ignoring NA)
  min_val <- min(vals, na.rm = TRUE)
  max_val <- max(vals, na.rm = TRUE)
  if (is.null(domain)) {
    domain <- c(min_val, max_val)
  }
  
  # 3) Call data_color() on the gt table for that single column
  gt_tbl %>%
    data_color(
      columns = all_of(column),
      colors  = col_numeric(
        palette = palette,
        domain  = domain
      )
    )
}
library(dplyr)
library(gt)

# 1) First build your gt table as usual:
gt_tbl <- sample_stats_df %>% 
  gt()

# slope blue (-) to red (+) (0 centered)
tryCatch({
  min_slope <- min(sample_stats_df$slope,  na.rm = TRUE)
  max_slope <- max(sample_stats_df$slope,  na.rm = TRUE)
  max_abs_slope <- max(abs(min_slope), abs(max_slope))
  gt_tbl <- color_column(
    gt_tbl, 
    df     = sample_stats_df, 
    column = "slope",
    palette = rev(brewer.pal(11, "RdBu")),
    domain  = c(-max_abs_slope, max_abs_slope)
  )
}, error = function(e) {
  print("Error in slope color column")
  print(e)
})

# slope blue (-) to red (+) (0 centered)
tryCatch({
  min_slope <- min(sample_stats_df$significant_slope,  na.rm = TRUE)
  max_slope <- max(sample_stats_df$significant_slope,  na.rm = TRUE)
  max_abs_slope <- max(abs(min_slope), abs(max_slope))
  gt_tbl <- color_column(
    gt_tbl, 
    df     = sample_stats_df, 
    column = "significant_slope",
    palette = rev(brewer.pal(11, "RdBu")),
    domain  = c(-max_abs_slope, max_abs_slope)
  )
}, error = function(e) {
  print("Error in significant_slope color column")
  print(e)
})

tryCatch({
  # mean values blue to red (0 centered)
  min_mean <- min(sample_stats_df$mean,  na.rm = TRUE)
  max_mean <- max(sample_stats_df$mean,  na.rm = TRUE)
  max_abs_mean <- max(abs(min_mean), abs(max_mean))
  gt_tbl <- color_column(
    gt_tbl, 
    df     = sample_stats_df, 
    column = "mean",
    palette = rev(brewer.pal(11, "RdBu")),
    domain  = c(-max_abs_mean, max_abs_mean)
  )
}, error = function(e) {
  print("Error in mean color column")
  print(e)
})

tryCatch({
  # n values white to green
  gt_tbl <- color_column(
    gt_tbl, 
    df      = sample_stats_df, 
    column  = "n_values", 
    palette = scales::brewer_pal(palette = "Greens")(9)
  )
}, error = function(e) {
  print("Error in n_values color column")
  print(e)
})

tryCatch({
  # min
  gt_tbl <- color_column(
    gt_tbl, 
    df      = sample_stats_df, 
    column  = "min", 
    palette = scales::brewer_pal(palette = "Blues")(9)
  )
}, error = function(e) {
  print("Error in min color column")
  print(e)
})

tryCatch({
  # max
  gt_tbl <- color_column(
    gt_tbl, 
    df      = sample_stats_df, 
    column  = "max", 
    palette = scales::brewer_pal(palette = "Blues")(9)
  )
}, error = function(e) {
  print("Error in max color column")
  print(e)
})

tryCatch({
  # coefficient.of.variation
  gt_tbl <- color_column(
    gt_tbl, 
    df      = sample_stats_df, 
    column  = "coefficient.of.variation", 
    palette = scales::brewer_pal(palette = "Blues")(9)
  )
}, error = function(e) {
  print("Error in coefficient.of.variation color column")
  print(e)
})

# 4) Render/display:
gt_tbl

ProgramName	ProgramLocationID	ParameterUnits	AverageLatitude	AverageLongitude	slope	n_values	mean	min	max	coefficient.of.variation	significant_slope	pvalue
North Biscayne Bay Discrete Water Quality Program	BB14	m	25.83003	-80.15860	-0.152400000	24	28.7693000	0.6096	670.5600	4.7516253	NA	3.710934e-01
North Biscayne Bay Discrete Water Quality Program	DM08	m	25.83983	-80.17035	-0.045750000	17	0.5216882	0.3658	0.7010	0.2072712	NA	2.962699e-01
North Biscayne Bay Discrete Water Quality Program	DM28	m	25.83788	-80.17753	-0.304100000	21	1.0291143	0.5500	1.4020	0.2102996	NA	1.000000e+00
North Biscayne Bay Discrete Water Quality Program	JFK03	m	25.86282	-80.16974	-0.061000000	24	1.0108292	0.6096	1.4000	0.2175904	NA	4.327676e-01
North Biscayne Bay Discrete Water Quality Program	JT29	m	25.83980	-80.14168	0.245000000	26	2.3259077	1.3600	3.4000	0.2794883	NA	1.000000e+00
North Biscayne Bay Discrete Water Quality Program	JT61	m	25.81688	-80.17817	-0.276400000	29	1.5720103	1.2192	1.9812	0.1500962	-0.27640000	1.931275e-02
North Biscayne Bay Discrete Water Quality Program	JT66	m	25.81647	-80.14700	-0.213300000	29	1.1084069	0.8500	1.5545	0.1657806	NA	1.374852e-01
North Biscayne Bay Discrete Water Quality Program	JT71	m	25.82173	-80.15125	-0.243800000	26	0.9924038	0.6096	1.4326	0.1959010	-0.24380000	2.334220e-02
North Biscayne Bay Discrete Water Quality Program	LR03	m	25.84684	-80.18286	-0.090000000	31	1.5786903	0.9000	2.8194	0.2744386	NA	8.316721e-01
North Biscayne Bay Discrete Water Quality Program	LR05	m	25.87149	-80.23104	NA	2	1.3000000	1.3000	1.3000	0.0000000	NA	NA
North Biscayne Bay Discrete Water Quality Program	LR06	m	25.85352	-80.19291	NA	2	1.4000000	1.4000	1.4000	0.0000000	NA	NA
North Biscayne Bay Discrete Water Quality Program	LRSC	m	25.84952	-80.18833	NA	2	1.2000000	1.2000	1.2000	0.0000000	NA	NA
North Biscayne Bay Discrete Water Quality Program	TOW1	m	25.83276	-80.18077	NA	1	0.1524000	0.1524	0.1524	NA	NA	NA
North Biscayne Bay Discrete Water Quality Program	TOW2	m	25.82698	-80.17939	NA	1	1.2000000	1.2000	1.2000	NA	NA	NA
North Biscayne Bay Discrete Water Quality Program	TOW3	m	25.83506	-80.18041	NA	1	0.0762000	0.0762	0.0762	NA	NA	NA
North Biscayne Bay Discrete Water Quality Program	VR01	m	25.80568	-80.15256	-0.121900000	29	1.2169655	0.9500	1.4630	0.1146264	NA	7.664327e-01
North Biscayne Bay Discrete Water Quality Program	VR11	m	25.80472	-80.17940	-0.091400000	29	1.6402069	1.3500	1.9812	0.0886472	NA	4.017356e-01
North Biscayne Bay Discrete Water Quality Program	WQ01	m	25.84901	-80.17162	0.280000000	29	1.8879310	0.8000	2.6900	0.2459508	NA	1.937079e-01
North Biscayne Bay Discrete Water Quality Program	WQ02	m	25.85331	-80.14550	-0.520000000	29	2.5558552	1.4000	3.3528	0.2126805	NA	1.374852e-01
North Biscayne Bay Discrete Water Quality Program	WQ03	m	25.84950	-80.13209	0.312000000	26	1.9487692	1.0000	2.6500	0.2664276	NA	1.336144e-01
North Biscayne Bay Discrete Water Quality Program	WQ04	m	25.82600	-80.13408	0.030000000	29	2.2004138	1.3000	2.8956	0.2557377	NA	7.664327e-01
North Biscayne Bay Discrete Water Quality Program	WQ05	m	25.80814	-80.14081	0.585000000	26	2.5213231	1.0000	3.5000	0.2410503	NA	1.336144e-01
North Biscayne Bay Discrete Water Quality Program	WQ05a	m	25.80939	-80.13521	NA	3	1.8133333	1.5500	2.3400	0.2515294	NA	NA
Southeast Florida Water Quality Assessment Survey	BAK020	m	25.90000	-80.11971	0.166666667	90	4.6438889	1.7500	21.0000	0.7243501	NA	6.236789e-02
Southeast Florida Water Quality Assessment Survey	BAK021	m	25.90451	-80.11971	0.000000000	95	5.5757179	2.0000	16.0000	0.6510532	NA	6.331877e-01
Southeast Florida Water Quality Assessment Survey	BAK022	m	25.89549	-80.11971	0.071428571	96	5.9269250	2.0000	18.0000	0.6344397	0.07142857	2.523945e-02
Southeast Florida Water Quality Assessment Survey	BAK023	m	25.90000	-80.11472	0.166666667	96	5.5275625	2.0000	22.0000	0.6419778	0.16666667	2.083804e-02
Southeast Florida Water Quality Assessment Survey	BAK024	m	25.87298	-80.10450	0.000000000	96	9.2213667	3.5000	26.0000	0.6647619	NA	5.668008e-01
Southeast Florida Water Quality Assessment Survey	BAK025	m	25.88526	-80.11218	0.000000000	96	8.2512667	2.5000	24.0000	0.6813732	NA	1.863997e-01
Southeast Florida Water Quality Assessment Survey	BAK026	m	25.87570	-80.10497	0.040685714	96	9.5890417	3.0000	34.0000	0.7216970	NA	2.179642e-01
Southeast Florida Water Quality Assessment Survey	BAK027	m	25.86261	-80.10401	0.057066667	95	9.1480589	3.0000	31.0000	0.6872726	NA	3.263227e-01
Southeast Florida Water Quality Assessment Survey	BAK028	m	25.95145	-80.10287	0.000000000	95	9.0978526	3.0000	26.0000	0.6358263	NA	8.829147e-01
Southeast Florida Water Quality Assessment Survey	BAK029	m	25.93450	-80.10250	0.000000000	95	9.1154021	3.5000	35.0000	0.6916726	NA	6.359049e-01
Southeast Florida Water Quality Assessment Survey	BAK030	m	25.92075	-80.08608	NA	8	8.4687500	3.2500	15.0000	0.4530702	NA	NA
Southeast Florida Water Quality Assessment Survey	BAK031	m	25.92525	-80.08608	0.125000000	80	10.3906250	3.2500	20.0000	0.3009216	NA	4.021778e-01
Southeast Florida Water Quality Assessment Survey	BAK032	m	25.91490	-80.08608	0.257142857	76	10.2625000	3.2500	20.0000	0.3222406	NA	1.602887e-01
Southeast Florida Water Quality Assessment Survey	BAK033	m	25.92075	-80.08108	0.000000000	71	11.0000000	4.0000	19.0000	0.3173458	NA	7.471446e-01
Southeast Florida Water Quality Assessment Survey	BOC070	m	26.33576	-80.06939	-0.070560000	93	3.3744860	1.0000	11.0000	0.6753562	NA	2.437761e-01
Southeast Florida Water Quality Assessment Survey	BOC071	m	26.34027	-80.06939	-0.077700000	97	3.0997361	1.2000	10.0000	0.6384505	-0.07770000	7.775859e-03
Southeast Florida Water Quality Assessment Survey	BOC072	m	26.33125	-80.06939	-0.092200000	97	5.7029526	2.0000	40.0000	0.8892897	-0.09220000	8.017662e-03
Southeast Florida Water Quality Assessment Survey	BOC073	m	26.33576	-80.06438	0.500000000	94	9.1596936	2.0000	44.0000	0.7503283	0.50000000	2.415688e-02
Southeast Florida Water Quality Assessment Survey	BOC074	m	26.32565	-80.07222	-0.100000000	96	3.5971583	1.8000	12.0000	0.6802045	-0.10000000	9.890223e-05
Southeast Florida Water Quality Assessment Survey	BOC075	m	26.29860	-80.07468	-0.250000000	97	5.7221938	2.1000	19.0000	0.6996502	-0.25000000	1.486364e-05
Southeast Florida Water Quality Assessment Survey	BOC076	m	26.33692	-80.06468	0.400000000	96	8.5820083	2.0000	44.0000	0.6673658	0.40000000	2.468316e-04
Southeast Florida Water Quality Assessment Survey	BOC077	m	26.30943	-80.07405	-0.233333333	96	4.3752417	1.8000	20.0000	0.7465422	-0.23333333	2.187616e-08
Southeast Florida Water Quality Assessment Survey	BOC078	m	26.30772	-80.07425	-0.200000000	96	4.2318417	1.8000	12.0000	0.6570531	-0.20000000	4.452246e-07
Southeast Florida Water Quality Assessment Survey	BOC079	m	26.31207	-80.07383	-0.188617143	96	4.0153000	1.5000	25.2984	0.8143766	-0.18861714	8.433540e-06
Southeast Florida Water Quality Assessment Survey	BOC080	m	26.35000	-80.05444	1.300000000	11	10.6818182	4.0000	18.0000	0.4700809	NA	1.000000e+00
Southeast Florida Water Quality Assessment Survey	BOC081	m	26.35000	-80.04943	0.000000000	77	11.6428571	3.0000	21.0000	0.3087263	NA	8.517863e-01
Southeast Florida Water Quality Assessment Survey	BOC082	m	26.35451	-80.05444	0.000000000	83	11.0903614	3.0000	19.0000	0.3144204	NA	8.982732e-01
Southeast Florida Water Quality Assessment Survey	BOC083	m	26.34549	-80.05444	0.000000000	80	10.8812500	4.0000	18.0000	0.3058736	NA	7.501806e-01
Southeast Florida Water Quality Assessment Survey	BOY090	m	26.54417	-80.04057	0.000000000	96	2.8536417	0.5000	15.0000	0.8833424	NA	5.226927e-01
Southeast Florida Water Quality Assessment Survey	BOY091	m	26.54502	-80.03560	0.250000000	96	8.2467083	1.0000	35.0000	0.5925125	NA	7.832127e-02
Southeast Florida Water Quality Assessment Survey	BOY092	m	26.54954	-80.04058	0.100000000	96	3.5842167	0.9144	10.0000	0.4949274	0.10000000	4.389950e-02
Southeast Florida Water Quality Assessment Survey	BOY093	m	26.54051	-80.04058	-0.289066667	96	4.7163250	1.0000	14.0000	0.7815961	-0.28906667	6.759357e-08
Southeast Florida Water Quality Assessment Survey	BOY094	m	26.56462	-80.02833	0.000000000	83	13.2160771	5.0000	49.0000	0.6351346	NA	7.214914e-01
Southeast Florida Water Quality Assessment Survey	BOY095	m	26.48942	-80.03825	0.000000000	81	14.3873679	5.0000	50.0000	0.6021340	NA	7.539253e-01
Southeast Florida Water Quality Assessment Survey	BOY096	m	26.58862	-80.02467	0.000000000	83	14.3042024	5.0000	50.0000	0.6338731	NA	8.612396e-01
Southeast Florida Water Quality Assessment Survey	BOY097	m	26.50847	-80.03367	-0.216533333	86	15.8824186	5.8000	50.0000	0.6440834	NA	5.259305e-02
Southeast Florida Water Quality Assessment Survey	BOY098	m	26.42242	-80.05043	0.040000000	77	12.3162286	6.0000	18.8976	0.2501052	NA	5.680016e-01
Southeast Florida Water Quality Assessment Survey	BOY099	m	26.44222	-80.04742	0.000000000	88	15.2402364	6.0000	49.0000	0.7028091	NA	9.365070e-01
Southeast Florida Water Quality Assessment Survey	BOY100	m	26.60867	-80.02317	0.166666667	77	13.2538390	5.0000	50.0000	0.5235024	NA	3.066560e-01
Southeast Florida Water Quality Assessment Survey	BOY101	m	26.55160	-80.03083	0.000000000	86	11.2449860	5.0000	50.0000	0.4970056	NA	5.281264e-01
Southeast Florida Water Quality Assessment Survey	BOYPB4	m	26.48780	-80.03908	0.000000000	12	11.7916667	7.0000	16.2000	0.2623737	NA	1.000000e+00
Southeast Florida Water Quality Assessment Survey	GOC001	m	25.75649	-80.12842	0.000000000	80	7.3412500	2.0000	22.0000	0.6693349	NA	2.717757e-01
Southeast Florida Water Quality Assessment Survey	GOC002	m	25.76100	-80.12842	0.050000000	79	5.4493671	1.5000	11.0000	0.3573583	NA	1.039936e-01
Southeast Florida Water Quality Assessment Survey	GOC003	m	25.76026	-80.12362	0.183333333	79	5.5696203	1.5000	11.0000	0.3449238	NA	1.340186e-01
Southeast Florida Water Quality Assessment Survey	GOC004	m	25.76551	-80.12842	-0.300000000	80	6.3225000	1.5000	18.0000	0.6737792	-0.30000000	2.683404e-08
Southeast Florida Water Quality Assessment Survey	GOC005	m	25.84455	-80.10415	-0.250000000	80	7.7962500	3.0000	20.0000	0.6380668	-0.25000000	2.248954e-04
Southeast Florida Water Quality Assessment Survey	GOC006	m	25.73414	-80.10024	-0.300000000	80	7.3737500	4.0000	22.0000	0.6733047	-0.30000000	1.515335e-08
Southeast Florida Water Quality Assessment Survey	GOC007	m	25.84637	-80.10323	-0.150000000	79	9.1101266	3.0000	29.0000	0.6588366	-0.15000000	1.893434e-02
Southeast Florida Water Quality Assessment Survey	GOC008	m	25.83518	-80.10928	-0.045000000	80	7.7112500	3.0000	20.0000	0.6358153	NA	6.507855e-02
Southeast Florida Water Quality Assessment Survey	GOC009	m	25.66822	-80.09874	-0.300000000	80	12.2137500	3.0000	30.0000	0.6549124	-0.30000000	2.184323e-05
Southeast Florida Water Quality Assessment Survey	GOC010	m	25.65916	-80.09482	-0.200000000	80	13.5775000	4.0000	33.0000	0.6603185	-0.20000000	4.768332e-03
Southeast Florida Water Quality Assessment Survey	GOC011	m	25.71883	-80.10008	-0.300000000	80	10.0975000	4.0000	27.0000	0.6624004	-0.30000000	3.362456e-03
Southeast Florida Water Quality Assessment Survey	GOC012	m	25.73743	-80.08611	0.000000000	63	11.3174603	5.0000	20.0000	0.2815821	NA	6.419688e-01
Southeast Florida Water Quality Assessment Survey	GOC013	m	25.74194	-80.08113	-0.187500000	57	11.8333333	6.0000	19.0000	0.2760758	NA	6.121936e-01
Southeast Florida Water Quality Assessment Survey	GOC014	m	25.74194	-80.08611	NA	2	14.0000000	10.0000	18.0000	0.4040610	NA	NA
Southeast Florida Water Quality Assessment Survey	GOC015	m	25.74646	-80.08611	0.000000000	65	10.5384615	3.0000	16.0000	0.2757988	NA	1.000000e+00
Southeast Florida Water Quality Assessment Survey	GOCDC1	m	25.84217	-80.10403	0.200000000	23	5.4391304	2.2000	7.9000	0.2029011	NA	7.841912e-01
Southeast Florida Water Quality Assessment Survey	HIL050	m	26.25659	-80.08020	-0.189066667	93	4.1968172	0.5000	16.0000	0.6890824	-0.18906667	9.232358e-03
Southeast Florida Water Quality Assessment Survey	HIL051	m	26.26111	-80.08020	0.240000000	96	4.6612500	0.9000	12.0000	0.4770513	0.24000000	1.049897e-02
Southeast Florida Water Quality Assessment Survey	HIL052	m	26.25208	-80.08020	0.000000000	96	4.4872500	2.0000	15.0000	0.6518845	NA	3.688623e-01
Southeast Florida Water Quality Assessment Survey	HIL053	m	26.25659	-80.07519	0.200000000	92	9.1281217	1.5000	38.0000	0.4358820	NA	8.516791e-02
Southeast Florida Water Quality Assessment Survey	HIL054	m	26.28915	-80.07512	0.000000000	96	6.5560083	1.8000	18.0000	0.6459797	NA	8.574928e-01
Southeast Florida Water Quality Assessment Survey	HIL055	m	26.21693	-80.08620	0.000000000	96	5.8650417	2.0000	16.0000	0.6227198	NA	9.422545e-01
Southeast Florida Water Quality Assessment Survey	HIL056	m	26.22868	-80.08382	-0.010800000	96	4.6062583	2.0000	14.0000	0.6601410	NA	5.190483e-02
Southeast Florida Water Quality Assessment Survey	HIL057	m	26.24787	-80.07822	0.080000000	95	7.5894147	3.0000	28.0000	0.6860149	NA	1.477667e-01
Southeast Florida Water Quality Assessment Survey	HIL058	m	26.19612	-80.09100	0.000000000	95	6.5287832	1.5000	18.0000	0.6512064	NA	1.000000e+00
Southeast Florida Water Quality Assessment Survey	HIL059	m	26.25617	-80.07692	0.066666667	95	9.1247832	3.0000	30.0000	0.6439295	NA	3.288664e-01
Southeast Florida Water Quality Assessment Survey	HIL060	m	26.25400	-80.06210	NA	8	11.4375000	6.0000	16.0000	0.2699254	NA	NA
Southeast Florida Water Quality Assessment Survey	HIL061	m	26.25851	-80.06210	0.000000000	78	11.6538462	4.0000	20.0000	0.2933889	NA	6.064676e-01
Southeast Florida Water Quality Assessment Survey	HIL062	m	26.24949	-80.06210	0.000000000	77	11.7402597	4.0000	20.0000	0.2960800	NA	6.316091e-01
Southeast Florida Water Quality Assessment Survey	HIL063	m	26.25400	-80.05710	0.000000000	68	11.6470588	4.0000	20.0000	0.2988123	NA	1.000000e+00
Southeast Florida Water Quality Assessment Survey	ILW110	m	26.77245	-80.03038	0.000000000	92	6.9230000	0.5000	36.0000	0.5768030	NA	8.775211e-01
Southeast Florida Water Quality Assessment Survey	ILW111	m	26.77696	-80.03038	-0.008800000	95	3.9379747	0.5000	16.0000	0.7195250	NA	1.764874e-01
Southeast Florida Water Quality Assessment Survey	ILW112	m	26.76794	-80.03038	-0.124480000	95	9.3205137	0.5000	27.0000	0.6773085	-0.12448000	1.699978e-03
Southeast Florida Water Quality Assessment Survey	ILW113	m	26.77245	-80.02535	0.000000000	90	8.9221333	0.5000	40.0000	0.5491463	NA	8.763625e-01
Southeast Florida Water Quality Assessment Survey	ILW114	m	26.69742	-80.03040	-0.037760000	94	4.2733830	1.7500	14.0000	0.6350421	-0.03776000	4.793520e-02
Southeast Florida Water Quality Assessment Survey	ILW115	m	26.70405	-80.03025	-0.087600000	95	3.8996968	1.5000	18.0000	0.6961577	-0.08760000	2.711926e-02
Southeast Florida Water Quality Assessment Survey	ILW116	m	26.72168	-80.03150	-0.012800000	95	4.9998274	1.2500	36.5760	0.9647218	NA	1.132922e-01
Southeast Florida Water Quality Assessment Survey	ILW117	m	26.69870	-80.01652	0.333333333	72	13.1311444	4.5000	50.0000	0.4450643	NA	1.766739e-01
Southeast Florida Water Quality Assessment Survey	ILW118	m	26.69683	-80.03033	0.000000000	95	4.1006989	2.0000	12.0000	0.6359717	NA	3.742811e-01
Southeast Florida Water Quality Assessment Survey	ILW119	m	26.69947	-80.03013	-0.070560000	94	4.3226255	1.7500	13.0000	0.6287081	-0.07056000	1.240469e-02
Southeast Florida Water Quality Assessment Survey	JUP120	m	26.94380	-80.06911	0.000000000	92	2.4180261	0.5000	18.0000	0.7702460	NA	9.679476e-01
Southeast Florida Water Quality Assessment Survey	JUP121	m	26.94831	-80.06911	-0.100000000	96	4.3294792	0.7500	14.0000	0.7228451	-0.10000000	1.449582e-02
Southeast Florida Water Quality Assessment Survey	JUP122	m	26.93929	-80.06911	-0.085800000	96	3.2083250	0.5000	12.0000	0.7154171	-0.08580000	1.432693e-02
Southeast Florida Water Quality Assessment Survey	JUP123	m	26.94380	-80.06407	0.000000000	95	3.2414526	0.5000	17.0000	0.5634379	NA	8.804210e-01
Southeast Florida Water Quality Assessment Survey	JUP124	m	26.99485	-80.06685	0.000000000	95	9.9685895	1.0000	43.0000	0.5766085	NA	8.548768e-01
Southeast Florida Water Quality Assessment Survey	JUP125	m	27.00192	-80.06595	-0.183333333	94	10.7612894	1.2500	48.0000	0.6776384	NA	3.956970e-01
Southeast Florida Water Quality Assessment Survey	JUP126	m	27.01158	-80.06780	0.000000000	95	10.7042105	1.0000	49.0000	0.6747699	NA	6.871405e-01
Southeast Florida Water Quality Assessment Survey	JUP127	m	27.01775	-80.07292	0.000000000	93	10.1043011	1.0000	40.0000	0.6772479	NA	7.628612e-01
Southeast Florida Water Quality Assessment Survey	JUP128	m	27.02357	-80.06655	0.000000000	92	9.9369565	1.0000	38.0000	0.4602632	NA	9.391766e-01
Southeast Florida Water Quality Assessment Survey	JUP129	m	27.01597	-80.06595	0.000000000	90	9.8361111	1.2500	16.2000	0.3584421	NA	7.263603e-01
Southeast Florida Water Quality Assessment Survey	PEV040	m	26.09301	-80.09733	0.250000000	92	5.9597826	2.0000	14.3000	0.4512751	0.25000000	4.010351e-02
Southeast Florida Water Quality Assessment Survey	PEV041	m	26.09752	-80.09733	0.000000000	96	5.9412667	2.0000	21.0000	0.6534861	NA	1.000000e+00
Southeast Florida Water Quality Assessment Survey	PEV042	m	26.08849	-80.09733	0.000000000	96	7.7769583	2.5000	29.0000	0.6492756	NA	4.495694e-01
Southeast Florida Water Quality Assessment Survey	PEV043	m	26.09301	-80.09234	0.285714286	95	6.9952632	2.0000	14.9000	0.4109637	0.28571429	4.028995e-02
Southeast Florida Water Quality Assessment Survey	PEV044	m	26.15998	-80.09028	-0.051520000	96	5.7437083	2.4384	40.0000	0.9238716	-0.05152000	4.208575e-02
Southeast Florida Water Quality Assessment Survey	PEV045	m	26.11207	-80.09883	0.000000000	95	7.9581558	2.0000	25.0000	0.6628846	NA	7.700468e-01
Southeast Florida Water Quality Assessment Survey	PEV046	m	26.02060	-80.11190	0.004666667	95	5.9716379	2.0000	18.0000	0.6630913	NA	3.822079e-01
Southeast Florida Water Quality Assessment Survey	PEV047	m	26.14840	-80.09520	0.083333333	95	8.6286821	3.0000	30.0000	0.6311497	NA	2.448052e-01
Southeast Florida Water Quality Assessment Survey	PEV048	m	25.97240	-80.10980	0.000000000	96	7.7626667	2.0000	21.0000	0.6649402	NA	9.424800e-01
Southeast Florida Water Quality Assessment Survey	PEV049	m	25.95423	-80.10117	-0.011000000	96	10.6569792	3.0000	33.0000	0.6985881	NA	3.515709e-01
Southeast Florida Water Quality Assessment Survey	PEV050	m	26.01630	-80.08700	-3.375000000	7	14.9394286	5.0000	32.0000	0.6234414	NA	2.962699e-01
Southeast Florida Water Quality Assessment Survey	PEV051	m	26.02081	-80.08700	0.000000000	90	11.4053600	4.0000	34.0000	0.3535519	NA	7.011528e-01
Southeast Florida Water Quality Assessment Survey	PEV052	m	26.01179	-80.08700	-0.100000000	87	11.7468506	4.0000	34.0000	0.3671458	NA	3.490808e-01
Southeast Florida Water Quality Assessment Survey	PEV053	m	26.01630	-80.08200	-0.200000000	82	12.0914634	5.0000	34.0000	0.4063635	NA	2.531457e-01
Southeast Florida Water Quality Assessment Survey	PEVBC1	m	26.14787	-80.09597	1.000000000	22	6.3227273	2.0000	9.1000	0.2797887	NA	5.581846e-01
Southeast Florida Water Quality Assessment Survey	STL161	m	27.16531	-80.16313	0.000000000	80	1.6662500	0.5000	3.0000	0.3229711	NA	3.768107e-01
Southeast Florida Water Quality Assessment Survey	STL162	m	27.16252	-80.14866	0.000000000	79	2.7037975	0.5000	14.0000	0.7233371	NA	7.285017e-01
Southeast Florida Water Quality Assessment Survey	STL163	m	27.16703	-80.14412	0.000000000	80	3.4175000	0.5000	7.9000	0.4782055	NA	6.683530e-01
Southeast Florida Water Quality Assessment Survey	STL164	m	27.17116	-80.15104	-0.150000000	81	3.1839506	0.5000	12.0000	0.7262621	-0.15000000	3.312357e-02
Southeast Florida Water Quality Assessment Survey	STL165	m	27.17298	-80.14978	-0.158333333	79	4.6088608	0.5000	20.0000	0.8001370	NA	1.012152e-01
Southeast Florida Water Quality Assessment Survey	STL166	m	27.16066	-80.14328	0.000000000	80	3.3100000	0.5000	7.0000	0.4509769	NA	2.483955e-01
Southeast Florida Water Quality Assessment Survey	STL167	m	27.09932	-80.12447	0.000000000	80	5.8775000	0.5000	26.0000	0.7858788	NA	8.124322e-01
Southeast Florida Water Quality Assessment Survey	STL168	m	27.12218	-80.12798	0.000000000	80	6.8525000	0.5000	29.0000	0.8267698	NA	1.000000e+00
Southeast Florida Water Quality Assessment Survey	STL169	m	27.15402	-80.14882	0.000000000	80	2.3575000	0.5000	10.0000	0.6722711	NA	3.773031e-01
Southeast Florida Water Quality Assessment Survey	STL170	m	27.13447	-80.13192	0.000000000	80	6.4875000	0.5000	28.0000	0.8196126	NA	1.000000e+00
Southeast Florida Water Quality Assessment Survey	STL171	m	27.15983	-80.14485	0.000000000	80	2.7325000	0.5000	12.0000	0.4957282	NA	4.227428e-01
Southeast Florida Water Quality Assessment Survey	STL172	m	27.12525	-80.12983	-0.037500000	80	5.0450000	0.5000	17.0000	0.6837292	NA	3.203999e-01
Southeast Florida Water Quality Assessment Survey	STLMC1	m	27.13167	-80.13403	-0.700000000	23	3.1043478	1.0000	4.3000	0.2914539	NA	1.709035e-01