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, OriginalLongitude, OriginalLatitude, ParameterUnits) %>%
  summarize(
    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	OriginalLongitude	OriginalLatitude	ParameterUnits	slope	n_values	mean	min	max	coefficient.of.variation	significant_slope	pvalue
North Biscayne Bay Discrete Water Quality Program	BB14	-80.15860	25.83003	m	-0.152400000	24	28.7693000	0.6096	670.5600	4.7516253	NA	3.710934e-01
North Biscayne Bay Discrete Water Quality Program	DM08	-80.17035	25.83983	m	-0.045750000	17	0.5216882	0.3658	0.7010	0.2072712	NA	2.962699e-01
North Biscayne Bay Discrete Water Quality Program	DM28	-80.17753	25.83788	m	-0.304100000	21	1.0291143	0.5500	1.4020	0.2102996	NA	1.000000e+00
North Biscayne Bay Discrete Water Quality Program	JFK03	-80.16974	25.86282	m	-0.061000000	24	1.0108292	0.6096	1.4000	0.2175904	NA	4.327676e-01
North Biscayne Bay Discrete Water Quality Program	JT29	-80.14168	25.83980	m	0.245000000	26	2.3259077	1.3600	3.4000	0.2794883	NA	1.000000e+00
North Biscayne Bay Discrete Water Quality Program	JT61	-80.17817	25.81688	m	-0.276400000	29	1.5720103	1.2192	1.9812	0.1500962	-0.27640000	1.931275e-02
North Biscayne Bay Discrete Water Quality Program	JT66	-80.14700	25.81647	m	-0.213300000	29	1.1084069	0.8500	1.5545	0.1657806	NA	1.374852e-01
North Biscayne Bay Discrete Water Quality Program	JT71	-80.15125	25.82173	m	-0.243800000	26	0.9924038	0.6096	1.4326	0.1959010	-0.24380000	2.334220e-02
North Biscayne Bay Discrete Water Quality Program	LR03	-80.18286	25.84684	m	-0.090000000	31	1.5786903	0.9000	2.8194	0.2744386	NA	8.316721e-01
North Biscayne Bay Discrete Water Quality Program	LR05	-80.23104	25.87149	m	NA	2	1.3000000	1.3000	1.3000	0.0000000	NA	NA
North Biscayne Bay Discrete Water Quality Program	LR06	-80.19291	25.85352	m	NA	2	1.4000000	1.4000	1.4000	0.0000000	NA	NA
North Biscayne Bay Discrete Water Quality Program	LRSC	-80.18833	25.84952	m	NA	2	1.2000000	1.2000	1.2000	0.0000000	NA	NA
North Biscayne Bay Discrete Water Quality Program	TOW1	-80.18077	25.83276	m	NA	1	0.1524000	0.1524	0.1524	NA	NA	NA
North Biscayne Bay Discrete Water Quality Program	TOW2	-80.17939	25.82698	m	NA	1	1.2000000	1.2000	1.2000	NA	NA	NA
North Biscayne Bay Discrete Water Quality Program	TOW3	-80.18041	25.83506	m	NA	1	0.0762000	0.0762	0.0762	NA	NA	NA
North Biscayne Bay Discrete Water Quality Program	VR01	-80.15256	25.80568	m	-0.121900000	29	1.2169655	0.9500	1.4630	0.1146264	NA	7.664327e-01
North Biscayne Bay Discrete Water Quality Program	VR11	-80.17940	25.80472	m	-0.091400000	29	1.6402069	1.3500	1.9812	0.0886472	NA	4.017356e-01
North Biscayne Bay Discrete Water Quality Program	WQ01	-80.17162	25.84901	m	0.280000000	29	1.8879310	0.8000	2.6900	0.2459508	NA	1.937079e-01
North Biscayne Bay Discrete Water Quality Program	WQ02	-80.14550	25.85331	m	-0.520000000	29	2.5558552	1.4000	3.3528	0.2126805	NA	1.374852e-01
North Biscayne Bay Discrete Water Quality Program	WQ03	-80.13209	25.84950	m	0.312000000	26	1.9487692	1.0000	2.6500	0.2664276	NA	1.336144e-01
North Biscayne Bay Discrete Water Quality Program	WQ04	-80.13408	25.82600	m	0.030000000	29	2.2004138	1.3000	2.8956	0.2557377	NA	7.664327e-01
North Biscayne Bay Discrete Water Quality Program	WQ05	-80.14081	25.80814	m	0.585000000	26	2.5213231	1.0000	3.5000	0.2410503	NA	1.336144e-01
North Biscayne Bay Discrete Water Quality Program	WQ05a	-80.13521	25.80939	m	NA	3	1.8133333	1.5500	2.3400	0.2515294	NA	NA
Southeast Florida Water Quality Assessment Survey	BAK020	-80.11971	25.90000	m	0.183333333	87	4.6603448	1.7500	21.0000	0.7313978	NA	5.781665e-02
Southeast Florida Water Quality Assessment Survey	BAK021	-80.11971	25.90451	m	0.000000000	92	5.6281870	2.0000	16.0000	0.6529236	NA	4.866958e-01
Southeast Florida Water Quality Assessment Survey	BAK022	-80.11971	25.89549	m	0.080800000	93	5.9503742	2.0000	18.0000	0.6410797	0.08080000	1.657260e-02
Southeast Florida Water Quality Assessment Survey	BAK023	-80.11472	25.90000	m	0.166666667	93	5.5402796	2.0000	22.0000	0.6499411	0.16666667	2.977244e-02
Southeast Florida Water Quality Assessment Survey	BAK024	-80.10450	25.87298	m	0.040685714	93	9.2908731	3.5000	26.0000	0.6689308	NA	4.286714e-01
Southeast Florida Water Quality Assessment Survey	BAK025	-80.11218	25.88526	m	0.000000000	93	8.2841032	2.5000	24.0000	0.6884151	NA	3.123686e-01
Southeast Florida Water Quality Assessment Survey	BAK026	-80.10497	25.87570	m	0.041371429	93	9.6779355	3.0000	34.0000	0.7243455	NA	2.212343e-01
Southeast Florida Water Quality Assessment Survey	BAK027	-80.10401	25.86261	m	0.098733333	92	9.1952783	3.0000	31.0000	0.6943092	NA	2.830523e-01
Southeast Florida Water Quality Assessment Survey	BAK028	-80.10287	25.95145	m	0.000000000	92	9.1532174	3.0000	26.0000	0.6413578	NA	8.459936e-01
Southeast Florida Water Quality Assessment Survey	BAK029	-80.10250	25.93450	m	-0.000560000	92	9.1832957	3.5000	35.0000	0.6959445	NA	4.414183e-01
Southeast Florida Water Quality Assessment Survey	BAK030	-80.08608	25.92075	m	NA	8	8.4687500	3.2500	15.0000	0.4530702	NA	NA
Southeast Florida Water Quality Assessment Survey	BAK031	-80.08608	25.92525	m	0.166666667	78	10.3750000	3.2500	20.0000	0.3051131	NA	3.595298e-01
Southeast Florida Water Quality Assessment Survey	BAK032	-80.08608	25.91490	m	0.285714286	74	10.2560811	3.2500	20.0000	0.3267067	NA	1.585311e-01
Southeast Florida Water Quality Assessment Survey	BAK033	-80.08108	25.92075	m	0.000000000	69	10.9855072	4.0000	19.0000	0.3222119	NA	8.220579e-01
Southeast Florida Water Quality Assessment Survey	BOC070	-80.06939	26.33576	m	-0.058800000	91	3.4101890	1.0000	11.0000	0.6717568	NA	3.940646e-01
Southeast Florida Water Quality Assessment Survey	BOC071	-80.06939	26.34027	m	-0.095942857	94	3.1252596	1.2000	10.0000	0.6414666	-0.09594286	5.830242e-03
Southeast Florida Water Quality Assessment Survey	BOC072	-80.06939	26.33125	m	-0.134800000	94	5.7604936	2.0000	40.0000	0.8926259	-0.13480000	9.307843e-03
Southeast Florida Water Quality Assessment Survey	BOC073	-80.06438	26.33576	m	0.500000000	92	9.1838174	2.0000	44.0000	0.7519135	0.50000000	2.421342e-02
Southeast Florida Water Quality Assessment Survey	BOC074	-80.07222	26.32565	m	-0.100000000	93	3.6422280	1.8000	12.0000	0.6789789	-0.10000000	6.307745e-04
Southeast Florida Water Quality Assessment Survey	BOC075	-80.07468	26.29860	m	-0.300000000	94	5.7973702	2.1000	19.0000	0.6976439	-0.30000000	6.432742e-05
Southeast Florida Water Quality Assessment Survey	BOC076	-80.06468	26.33692	m	0.480000000	93	8.5921806	2.0000	44.0000	0.6743291	0.48000000	2.692325e-04
Southeast Florida Water Quality Assessment Survey	BOC077	-80.07405	26.30943	m	-0.239400000	93	4.4325075	1.8000	20.0000	0.7451793	-0.23940000	3.100725e-07
Southeast Florida Water Quality Assessment Survey	BOC078	-80.07425	26.30772	m	-0.200000000	93	4.2877075	1.8000	12.0000	0.6547736	-0.20000000	4.603158e-06
Southeast Florida Water Quality Assessment Survey	BOC079	-80.07383	26.31207	m	-0.200000000	93	4.0598796	1.5000	25.2984	0.8157005	-0.20000000	7.085675e-06
Southeast Florida Water Quality Assessment Survey	BOC080	-80.05444	26.35000	m	2.066666667	10	11.2500000	4.0000	18.0000	0.4360944	NA	6.434288e-01
Southeast Florida Water Quality Assessment Survey	BOC081	-80.04943	26.35000	m	0.000000000	76	11.7565789	4.0000	21.0000	0.2956730	NA	9.233123e-01
Southeast Florida Water Quality Assessment Survey	BOC082	-80.05444	26.35451	m	0.000000000	81	11.1790123	3.0000	19.0000	0.3050205	NA	8.237552e-01
Southeast Florida Water Quality Assessment Survey	BOC083	-80.05444	26.34549	m	0.000000000	79	10.9556962	4.0000	18.0000	0.2995552	NA	5.748471e-01
Southeast Florida Water Quality Assessment Survey	BOY090	-80.04057	26.54417	m	0.000000000	93	2.8768774	0.5000	15.0000	0.8870444	NA	2.820589e-01
Southeast Florida Water Quality Assessment Survey	BOY091	-80.03560	26.54502	m	0.333333333	93	8.3944516	1.0000	35.0000	0.5818192	0.33333333	8.944019e-03
Southeast Florida Water Quality Assessment Survey	BOY092	-80.04058	26.54954	m	0.133333333	93	3.6009118	0.9144	10.0000	0.4987918	0.13333333	2.532629e-02
Southeast Florida Water Quality Assessment Survey	BOY093	-80.04058	26.54051	m	-0.300000000	93	4.7641634	1.0000	14.0000	0.7816080	-0.30000000	4.632906e-08
Southeast Florida Water Quality Assessment Survey	BOY094	-80.02833	26.56462	m	0.000000000	80	13.3991800	5.0000	49.0000	0.6339791	NA	9.241257e-01
Southeast Florida Water Quality Assessment Survey	BOY095	-80.03825	26.48942	m	0.000000000	78	14.5150872	5.0000	50.0000	0.6052031	NA	9.244665e-01
Southeast Florida Water Quality Assessment Survey	BOY096	-80.02467	26.58862	m	0.050000000	80	14.5406100	5.0000	50.0000	0.6293461	NA	4.068802e-01
Southeast Florida Water Quality Assessment Survey	BOY097	-80.03367	26.50847	m	-0.174800000	83	16.0637108	5.8000	50.0000	0.6447366	NA	1.159118e-01
Southeast Florida Water Quality Assessment Survey	BOY098	-80.05043	26.42242	m	0.200000000	74	12.4236432	6.0000	18.8976	0.2482799	NA	2.842941e-01
Southeast Florida Water Quality Assessment Survey	BOY099	-80.04742	26.44222	m	0.000000000	85	15.4369506	6.0000	49.0000	0.7026897	NA	7.026950e-01
Southeast Florida Water Quality Assessment Survey	BOY100	-80.02317	26.60867	m	0.300000000	74	13.4938595	5.0000	50.0000	0.5166966	NA	8.850151e-02
Southeast Florida Water Quality Assessment Survey	BOY101	-80.03083	26.55160	m	0.000000000	83	11.4225157	5.0000	50.0000	0.4910021	NA	1.000000e+00
Southeast Florida Water Quality Assessment Survey	BOYPB4	-80.03908	26.48780	m	NA	9	11.8444444	7.0000	16.2000	0.2787111	NA	NA
Southeast Florida Water Quality Assessment Survey	GOC001	-80.12842	25.75649	m	0.000000000	77	7.3935065	2.0000	22.0000	0.6763308	NA	2.441606e-01
Southeast Florida Water Quality Assessment Survey	GOC002	-80.12842	25.76100	m	0.166666667	77	5.4610390	1.5000	11.0000	0.3597787	NA	8.313114e-02
Southeast Florida Water Quality Assessment Survey	GOC003	-80.12362	25.76026	m	0.183333333	77	5.5844156	1.5000	11.0000	0.3481037	NA	1.613386e-01
Southeast Florida Water Quality Assessment Survey	GOC004	-80.12842	25.76551	m	-0.300000000	77	6.4142857	1.5000	18.0000	0.6726775	-0.30000000	1.709855e-07
Southeast Florida Water Quality Assessment Survey	GOC005	-80.10415	25.84455	m	-0.237500000	77	7.9090909	3.0000	20.0000	0.6369248	-0.23750000	2.666682e-03
Southeast Florida Water Quality Assessment Survey	GOC006	-80.10024	25.73414	m	-0.300000000	77	7.4857143	4.0000	22.0000	0.6716715	-0.30000000	1.071553e-07
Southeast Florida Water Quality Assessment Survey	GOC007	-80.10323	25.84637	m	-0.116666667	76	9.2342105	3.0000	29.0000	0.6592057	NA	6.932533e-02
Southeast Florida Water Quality Assessment Survey	GOC008	-80.10928	25.83518	m	0.000000000	77	7.8129870	3.0000	20.0000	0.6358964	NA	1.980954e-01
Southeast Florida Water Quality Assessment Survey	GOC009	-80.09874	25.66822	m	-0.300000000	77	12.4285714	3.0000	30.0000	0.6492726	-0.30000000	8.315139e-05
Southeast Florida Water Quality Assessment Survey	GOC010	-80.09482	25.65916	m	-0.175000000	77	13.7961039	4.0000	33.0000	0.6567111	-0.17500000	8.476927e-03
Southeast Florida Water Quality Assessment Survey	GOC011	-80.10008	25.71883	m	-0.387500000	77	10.2376623	4.0000	27.0000	0.6622665	-0.38750000	2.755541e-03
Southeast Florida Water Quality Assessment Survey	GOC012	-80.08611	25.73743	m	0.000000000	62	11.4193548	5.0000	20.0000	0.2721365	NA	9.450714e-01
Southeast Florida Water Quality Assessment Survey	GOC013	-80.08113	25.74194	m	0.000000000	55	11.9545455	6.0000	19.0000	0.2698925	NA	7.540496e-01
Southeast Florida Water Quality Assessment Survey	GOC014	-80.08611	25.74194	m	NA	2	14.0000000	10.0000	18.0000	0.4040610	NA	NA
Southeast Florida Water Quality Assessment Survey	GOC015	-80.08611	25.74646	m	0.000000000	64	10.6093750	3.0000	16.0000	0.2707264	NA	6.999194e-01
Southeast Florida Water Quality Assessment Survey	GOCDC1	-80.10403	25.84217	m	-0.150000000	20	5.3100000	2.2000	7.0000	0.1942664	NA	1.000000e+00
Southeast Florida Water Quality Assessment Survey	HIL050	-80.08020	26.25659	m	-0.175000000	90	4.2656000	0.5000	16.0000	0.6833164	-0.17500000	4.248751e-02
Southeast Florida Water Quality Assessment Survey	HIL051	-80.08020	26.26111	m	0.232500000	93	4.6610753	0.9000	12.0000	0.4826302	0.23250000	1.208145e-02
Southeast Florida Water Quality Assessment Survey	HIL052	-80.08020	26.25208	m	0.000000000	93	4.5341505	2.0000	15.0000	0.6522637	NA	5.201252e-01
Southeast Florida Water Quality Assessment Survey	HIL053	-80.07519	26.25659	m	0.250000000	89	9.1661483	1.5000	38.0000	0.4367986	NA	5.758703e-02
Southeast Florida Water Quality Assessment Survey	HIL054	-80.07512	26.28915	m	0.000000000	93	6.6309333	1.8000	18.0000	0.6443786	NA	9.397573e-01
Southeast Florida Water Quality Assessment Survey	HIL055	-80.08620	26.21693	m	0.000000000	93	5.9273548	2.0000	16.0000	0.6218397	NA	9.695440e-01
Southeast Florida Water Quality Assessment Survey	HIL056	-80.08382	26.22868	m	-0.035933333	93	4.6430194	2.0000	14.0000	0.6638573	-0.03593333	4.129832e-02
Southeast Florida Water Quality Assessment Survey	HIL057	-80.07822	26.24787	m	0.086285714	92	7.6586348	3.0000	28.0000	0.6877679	NA	1.003115e-01
Southeast Florida Water Quality Assessment Survey	HIL058	-80.09100	26.19612	m	0.000000000	92	6.5992870	1.5000	18.0000	0.6514352	NA	1.000000e+00
Southeast Florida Water Quality Assessment Survey	HIL059	-80.07692	26.25617	m	0.100000000	92	9.2125478	3.0000	30.0000	0.6441184	NA	2.216839e-01
Southeast Florida Water Quality Assessment Survey	HIL060	-80.06210	26.25400	m	NA	8	11.4375000	6.0000	16.0000	0.2699254	NA	NA
Southeast Florida Water Quality Assessment Survey	HIL061	-80.06210	26.25851	m	0.250000000	76	11.7631579	5.0000	20.0000	0.2845419	NA	3.515683e-01
Southeast Florida Water Quality Assessment Survey	HIL062	-80.06210	26.24949	m	0.000000000	76	11.8289474	4.0000	20.0000	0.2883038	NA	4.034338e-01
Southeast Florida Water Quality Assessment Survey	HIL063	-80.05710	26.25400	m	0.000000000	67	11.7611940	6.0000	20.0000	0.2870366	NA	7.754830e-01
Southeast Florida Water Quality Assessment Survey	ILW110	-80.03038	26.77245	m	0.000000000	89	7.0069213	0.5000	36.0000	0.5755702	NA	4.143458e-01
Southeast Florida Water Quality Assessment Survey	ILW111	-80.03038	26.77696	m	-0.010200000	92	3.9674739	0.5000	16.0000	0.7245128	NA	1.664833e-01
Southeast Florida Water Quality Assessment Survey	ILW112	-80.03038	26.76794	m	-0.100000000	92	9.4787913	0.5000	27.0000	0.6689970	-0.10000000	6.885745e-03
Southeast Florida Water Quality Assessment Survey	ILW113	-80.02535	26.77245	m	0.000000000	87	8.9987586	0.5000	40.0000	0.5467799	NA	6.799657e-01
Southeast Florida Water Quality Assessment Survey	ILW114	-80.03040	26.69742	m	-0.051520000	91	4.3109670	1.7500	14.0000	0.6374146	NA	5.888886e-02
Southeast Florida Water Quality Assessment Survey	ILW115	-80.03025	26.70405	m	-0.064200000	92	3.9507739	1.5000	18.0000	0.6943245	NA	7.838389e-02
Southeast Florida Water Quality Assessment Survey	ILW116	-80.03150	26.72168	m	0.000000000	92	5.0715609	1.2500	36.5760	0.9632545	NA	2.761214e-01
Southeast Florida Water Quality Assessment Survey	ILW117	-80.01652	26.69870	m	0.500000000	69	13.3542377	4.5000	50.0000	0.4389503	0.50000000	3.504304e-02
Southeast Florida Water Quality Assessment Survey	ILW118	-80.03033	26.69683	m	0.000000000	92	4.1257217	2.0000	12.0000	0.6394727	NA	4.103569e-01
Southeast Florida Water Quality Assessment Survey	ILW119	-80.03013	26.69947	m	-0.075000000	91	4.3629319	1.7500	13.0000	0.6307153	-0.07500000	1.661698e-02
Southeast Florida Water Quality Assessment Survey	JUP120	-80.06911	26.94380	m	0.000000000	89	2.4231281	0.5000	18.0000	0.7724028	NA	9.321001e-01
Southeast Florida Water Quality Assessment Survey	JUP121	-80.06911	26.94831	m	-0.100000000	93	4.3863441	0.7500	14.0000	0.7197150	-0.10000000	2.291559e-02
Southeast Florida Water Quality Assessment Survey	JUP122	-80.06911	26.93929	m	-0.066666667	93	3.2677333	0.5000	12.0000	0.7052995	-0.06666667	4.393004e-02
Southeast Florida Water Quality Assessment Survey	JUP123	-80.06407	26.94380	m	0.000000000	92	3.2221522	0.5000	17.0000	0.5693792	NA	7.194910e-01
Southeast Florida Water Quality Assessment Survey	JUP124	-80.06685	26.99485	m	0.000000000	92	10.1034348	1.0000	43.0000	0.5704224	NA	9.080047e-01
Southeast Florida Water Quality Assessment Survey	JUP125	-80.06595	27.00192	m	0.000000000	91	10.9182549	1.2500	48.0000	0.6722973	NA	6.401754e-01
Southeast Florida Water Quality Assessment Survey	JUP126	-80.06780	27.01158	m	0.000000000	92	10.8413043	1.0000	49.0000	0.6707305	NA	8.778207e-01
Southeast Florida Water Quality Assessment Survey	JUP127	-80.07292	27.01775	m	0.000000000	90	10.2411111	1.0000	40.0000	0.6731734	NA	1.000000e+00
Southeast Florida Water Quality Assessment Survey	JUP128	-80.06655	27.02357	m	0.000000000	89	10.0359551	1.0000	38.0000	0.4554759	NA	1.000000e+00
Southeast Florida Water Quality Assessment Survey	JUP129	-80.06595	27.01597	m	0.000000000	87	9.9224138	1.2500	16.2000	0.3511762	NA	8.371825e-01
Southeast Florida Water Quality Assessment Survey	PEV040	-80.09733	26.09301	m	0.250000000	90	5.9922222	2.0000	14.3000	0.4521698	0.25000000	2.074401e-02
Southeast Florida Water Quality Assessment Survey	PEV041	-80.09733	26.09752	m	0.000000000	93	5.9641032	2.0000	21.0000	0.6610415	NA	9.398715e-01
Southeast Florida Water Quality Assessment Survey	PEV042	-80.09733	26.08849	m	0.000000000	93	7.8289032	2.5000	29.0000	0.6521172	NA	4.244731e-01
Southeast Florida Water Quality Assessment Survey	PEV043	-80.09234	26.09301	m	0.285714286	93	7.0274194	2.0000	14.9000	0.4110855	0.28571429	3.672799e-02
Southeast Florida Water Quality Assessment Survey	PEV044	-80.09028	26.15998	m	-0.044533333	93	5.8160860	2.4384	40.0000	0.9244150	NA	7.809268e-02
Southeast Florida Water Quality Assessment Survey	PEV045	-80.09883	26.11207	m	0.000000000	93	8.0077935	2.0000	25.0000	0.6638161	NA	6.223462e-01
Southeast Florida Water Quality Assessment Survey	PEV046	-80.11190	26.02060	m	0.007000000	93	6.0108129	2.0000	18.0000	0.6643483	NA	3.270151e-01
Southeast Florida Water Quality Assessment Survey	PEV047	-80.09520	26.14840	m	0.083333333	93	8.6733849	3.0000	30.0000	0.6321949	NA	2.428860e-01
Southeast Florida Water Quality Assessment Survey	PEV048	-80.10980	25.97240	m	0.000000000	93	7.8313548	2.0000	21.0000	0.6678220	NA	8.193657e-01
Southeast Florida Water Quality Assessment Survey	PEV049	-80.10117	25.95423	m	-0.006285714	93	10.7480645	3.0000	33.0000	0.7018723	NA	4.965991e-01
Southeast Florida Water Quality Assessment Survey	PEV050	-80.08700	26.01630	m	NA	6	16.5960000	6.0000	32.0000	0.5424534	NA	NA
Southeast Florida Water Quality Assessment Survey	PEV051	-80.08700	26.02081	m	0.000000000	87	11.4561195	5.5000	34.0000	0.3484981	NA	9.348711e-01
Southeast Florida Water Quality Assessment Survey	PEV052	-80.08700	26.01179	m	0.000000000	85	11.8703059	5.0000	34.0000	0.3596281	NA	7.011554e-01
Southeast Florida Water Quality Assessment Survey	PEV053	-80.08200	26.01630	m	-0.125000000	81	12.1790123	5.0000	34.0000	0.4006370	NA	4.166031e-01
Southeast Florida Water Quality Assessment Survey	PEVBC1	-80.09597	26.14787	m	0.500000000	20	6.3550000	2.0000	9.1000	0.2876462	NA	1.000000e+00
Southeast Florida Water Quality Assessment Survey	STL161	-80.16313	27.16531	m	0.000000000	77	1.6922078	0.5000	3.0000	0.3142762	NA	6.591252e-02
Southeast Florida Water Quality Assessment Survey	STL162	-80.14866	27.16252	m	0.000000000	76	2.7052632	0.5000	14.0000	0.7283482	NA	8.741357e-01
Southeast Florida Water Quality Assessment Survey	STL163	-80.14412	27.16703	m	0.000000000	77	3.4402597	0.5000	7.9000	0.4736146	NA	5.456471e-01
Southeast Florida Water Quality Assessment Survey	STL164	-80.15104	27.17116	m	-0.150000000	78	3.2423077	0.5000	12.0000	0.7181124	-0.15000000	3.998187e-02
Southeast Florida Water Quality Assessment Survey	STL165	-80.14978	27.17298	m	-0.183333333	76	4.6868421	0.5000	20.0000	0.7940886	NA	1.017248e-01
Southeast Florida Water Quality Assessment Survey	STL166	-80.14328	27.16066	m	0.000000000	77	3.3090909	0.5000	7.0000	0.4430597	NA	2.039869e-01
Southeast Florida Water Quality Assessment Survey	STL167	-80.12447	27.09932	m	0.000000000	77	5.9766234	0.5000	26.0000	0.7811800	NA	7.633143e-01
Southeast Florida Water Quality Assessment Survey	STL168	-80.12798	27.12218	m	0.000000000	77	6.9766234	0.5000	29.0000	0.8209155	NA	9.207709e-01
Southeast Florida Water Quality Assessment Survey	STL169	-80.14882	27.15402	m	0.000000000	77	2.3961039	0.5000	10.0000	0.6669073	NA	6.020030e-01
Southeast Florida Water Quality Assessment Survey	STL170	-80.13192	27.13447	m	0.000000000	77	6.6363636	0.5000	28.0000	0.8076617	NA	8.017768e-01
Southeast Florida Water Quality Assessment Survey	STL171	-80.14485	27.15983	m	0.000000000	77	2.7454545	0.5000	12.0000	0.4960356	NA	4.557584e-01
Southeast Florida Water Quality Assessment Survey	STL172	-80.12983	27.12525	m	-0.025000000	77	5.1376623	0.5000	17.0000	0.6763531	NA	4.258238e-01
Southeast Florida Water Quality Assessment Survey	STLMC1	-80.13403	27.13167	m	-0.650000000	20	3.1950000	1.0000	4.3000	0.2513110	NA	1.305700e-01