Nitrate (NO3) 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 Nitrate (NO3)"

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
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	200	-80.10000	25.59000	mg/L	-4.303500e-06	176	0.0024954388	0.00001167	0.01432200	0.93149748	NA	0.7722243275
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	201	-80.16500	25.51000	mg/L	-1.321158e-05	180	0.0024402183	0.00006019	0.03749127	1.84142645	NA	0.3691853809
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	202	-80.15010	25.49380	mg/L	-2.944875e-05	110	0.0026347335	0.00003502	0.02227065	1.60345469	NA	0.3269259395
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	203	-80.11768	25.48053	mg/L	-6.605026e-06	133	0.0026358069	0.00000000	0.03242551	1.29587860	NA	0.7951040174
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	204	-80.19553	25.43082	mg/L	-7.375764e-06	187	0.0025515655	0.00014007	0.03326591	1.43700189	NA	0.4939320548
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	205	-80.18200	25.42798	mg/L	-3.114905e-05	108	0.0024256769	0.00001583	0.02563226	1.58132967	NA	0.1421871500
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	206	-80.14300	25.41497	mg/L	-2.479667e-05	174	0.0022155987	0.00000583	0.02315062	1.42671434	-2.479667e-05	0.0350493857
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	207	-80.21508	25.36443	mg/L	-7.333425e-05	96	0.0032564164	0.00010920	0.04685800	1.76829133	-7.333425e-05	0.0155342816
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	208	-80.20052	25.35918	mg/L	-9.111419e-05	119	0.0025174945	0.00005147	0.01924031	1.48594793	-9.111419e-05	0.0035775134
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	209	-81.72272	24.58570	mg/L	-4.618812e-05	101	0.0071819150	0.00021010	0.02951912	0.91918992	NA	0.3770525965
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	210	-80.16360	25.32500	mg/L	-1.985706e-05	171	0.0023679795	0.00003502	0.02629303	1.40777077	NA	0.1421195815
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	211	-80.26165	25.30788	mg/L	-2.443858e-05	196	0.0045370569	0.00003502	0.08267105	1.97473205	NA	0.1700568455
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	212	-80.24542	25.29452	mg/L	-3.913857e-05	170	0.0022989233	0.00000230	0.03315218	1.90694279	-3.913857e-05	0.0009261955
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	213	-80.18773	25.26312	mg/L	-3.610500e-05	191	0.0027330030	0.00007003	0.02643922	1.13221004	NA	0.0520405059
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	214	-80.29918	25.24620	mg/L	-4.986476e-05	134	0.0033260386	0.00016380	0.05828888	1.67333106	-4.986476e-05	0.0323324252
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	215	-80.28897	25.23667	mg/L	-1.846212e-06	126	0.0025539636	0.00006790	0.04602251	2.00283436	NA	0.8562586969
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	216	-80.21700	25.22000	mg/L	-4.666667e-06	127	0.0029655472	0.00012242	0.01369855	0.89573232	NA	0.9073529981
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	216i	-80.24425	25.20450	mg/L	2.556225e-03	9	0.0019298111	0.00007003	0.00441211	0.78031823	NA	0.5402913746
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	217	-80.33985	25.17332	mg/L	-3.886839e-05	131	0.0023872421	0.00004802	0.04697147	1.94183182	NA	0.1304967382
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	218	-80.29455	25.15897	mg/L	9.153333e-06	126	0.0022420413	0.00003502	0.02399838	1.45894172	NA	0.5794447681
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	219	-80.25800	25.14200	mg/L	3.536161e-05	169	0.0031464940	0.00002800	0.01547040	0.81625607	NA	0.1538524971
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	219i	-80.26477	25.12587	mg/L	1.015483e-03	14	0.0023544586	0.00007003	0.00609291	0.80138817	NA	0.4113137918
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	220	-80.37342	25.11355	mg/L	1.750875e-05	176	0.0022382393	0.00000000	0.02983400	1.55853673	NA	0.2037461747
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	221	-80.36088	25.11025	mg/L	-7.074872e-06	110	0.0020027490	0.00003502	0.01846783	1.58701603	NA	0.4368828335
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	222	-80.31277	25.07237	mg/L	-1.753333e-07	182	0.0034935337	0.00005043	0.09252600	2.10104912	NA	1.0000000000
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	223	-80.42312	25.06018	mg/L	5.380625e-06	121	0.0018998936	0.00001057	0.02363981	1.69827815	NA	0.5629894303
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	224	-80.39527	25.03082	mg/L	-4.550333e-05	122	0.0018349752	0.00002715	0.02769900	1.64364105	-4.550333e-05	0.0009635801
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	225	-80.36740	25.01700	mg/L	-1.188769e-05	163	0.0026863196	0.00003502	0.01611938	0.83822269	NA	0.6400773779
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	225i	-80.37000	25.00667	mg/L	1.208075e-03	14	0.0018408800	0.00003502	0.00717843	1.18155742	NA	0.4532547048
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	226	-80.50148	25.00840	mg/L	-1.726333e-05	133	0.0022461341	0.00001092	0.02321611	1.21603121	NA	0.4275168806
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	227	-80.47490	25.00167	mg/L	-2.871300e-05	172	0.0015907299	0.00003502	0.00990635	1.12105446	-2.871300e-05	0.0061300309
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	228	-80.45000	24.97667	mg/L	-5.977778e-07	173	0.0021356925	0.00002800	0.01236200	0.91573779	NA	0.9334475942
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	229	-80.56218	24.95012	mg/L	-1.932012e-05	99	0.0025922088	0.00008400	0.01257204	0.99793332	NA	0.3674414883
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	230	-80.55162	24.93965	mg/L	-2.651250e-06	192	0.0016990604	0.00003782	0.00987000	1.11425321	NA	0.7893439009
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	231	-80.50300	24.92500	mg/L	1.126250e-05	171	0.0024213674	0.00005599	0.01686160	0.99628386	NA	0.7246576783
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	231i	-80.51533	24.91750	mg/L	3.589250e-04	15	0.0012582687	0.00014007	0.00500740	1.22392321	3.589250e-04	0.0215562668
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	232	-80.59852	24.92703	mg/L	-2.757667e-05	128	0.0024730343	0.00004200	0.00980469	0.94335885	NA	0.3247221032
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	233	-80.58238	24.90185	mg/L	-2.858200e-05	102	0.0014724397	0.00006884	0.00987472	1.34509436	NA	0.1502311204
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	234	-80.56697	24.86277	mg/L	-4.232100e-05	102	0.0052745477	0.00002815	0.16922305	3.74847550	NA	0.3233608139
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	235	-80.66865	24.87123	mg/L	-1.431400e-05	135	0.0028819596	0.00005017	0.01810060	1.04756283	NA	0.6076932070
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	236	-80.66240	24.85970	mg/L	-4.965714e-05	98	0.0015742198	0.00001308	0.00910435	1.13925768	NA	0.1609129541
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	237	-80.64907	24.83265	mg/L	1.835833e-05	159	0.0019312855	0.00005740	0.01189636	1.14685226	NA	0.2002767470
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	238	-80.74683	24.83442	mg/L	-1.997081e-04	104	0.0048596162	0.00010505	0.02370634	0.93714154	-1.997081e-04	0.0016479651
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	239	-80.71620	24.80223	mg/L	-6.925417e-06	159	0.0020426877	0.00003502	0.03261020	1.90332517	NA	0.6523175451
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	240	-80.70570	24.78453	mg/L	-9.286667e-06	102	0.0019582266	0.00005390	0.01404834	1.25626838	NA	0.7281382998
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	241	-80.80890	24.80247	mg/L	-2.599719e-05	95	0.0022534848	0.00003458	0.01272784	1.07836630	NA	0.2323151414
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	242	-80.81225	24.79150	mg/L	-1.432546e-05	181	0.0028760423	0.00010505	0.02381666	1.21936360	NA	0.5029745787
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	243	-80.78333	24.74500	mg/L	2.138412e-05	162	0.0022807553	0.00003080	0.01855107	1.38366331	NA	0.1530494512
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	243i	-80.79348	24.72935	mg/L	NA	9	0.0007120056	0.00014007	0.00189090	0.71311439	NA	NA
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	244	-80.86333	24.79333	mg/L	-2.620156e-05	183	0.0036448262	0.00020014	0.01385506	0.84742978	NA	0.3770280251
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	244i	-80.89945	24.77095	mg/L	NA	7	0.0025812357	0.00028013	0.00486733	0.77193444	NA	NA
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	245	-80.86167	24.76167	mg/L	-2.218583e-04	102	0.0029347344	0.00003502	0.01435687	1.01153920	-2.218583e-04	0.0029420786
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	246	-80.85813	24.71317	mg/L	-5.854286e-06	171	0.0020502156	0.00000817	0.03294244	1.54687622	NA	0.6671958294
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	247	-81.01115	24.71318	mg/L	-3.270583e-05	130	0.0052373385	0.00007794	0.03291400	1.25738622	NA	0.4936089408
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	248	-80.96667	24.69167	mg/L	-2.340833e-05	150	0.0017649883	0.00001400	0.03423777	2.00196606	NA	0.0602829785
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	248i	-80.98310	24.68392	mg/L	-3.502000e-05	10	0.0007213460	0.00010505	0.00213602	0.95213681	NA	0.7054569861
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	249	-80.95830	24.67500	mg/L	-6.594444e-06	152	0.0015623401	0.00007003	0.01135564	1.19492570	NA	0.5195549945
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	249i	-80.97762	24.66560	mg/L	-1.243095e-03	11	0.0018909036	0.00007003	0.00514746	0.76533335	NA	0.6985353583
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	250	-81.18245	24.69193	mg/L	-5.547458e-05	130	0.0034937095	0.00002380	0.01473705	0.81624009	NA	0.0998819248
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	251	-81.16508	24.64502	mg/L	-7.124733e-05	108	0.0027050880	0.00003502	0.01356315	1.14123922	NA	0.0593848509
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	252	-81.15442	24.60693	mg/L	-8.549917e-06	172	0.0039904677	0.00003502	0.09562261	2.36839578	NA	0.7229285999
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	253	-81.30723	24.64537	mg/L	-1.167500e-05	101	0.0053057890	0.00003152	0.02158800	0.89398045	NA	0.8623576802
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	254	-81.26502	24.65792	mg/L	-3.844000e-06	95	0.0033099568	0.00006984	0.01777145	0.92577845	NA	1.0000000000
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	255	-81.24308	24.62168	mg/L	-1.812737e-05	158	0.0024564314	0.00000280	0.01696813	1.22205495	NA	0.2998094837
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	256	-81.23408	24.58497	mg/L	-5.153153e-06	162	0.0031248425	0.00005050	0.02056614	1.26429289	NA	0.8594240661
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	257	-81.33732	24.63333	mg/L	-6.895597e-05	63	0.0049462590	0.00070033	0.01801845	0.91435439	NA	0.3537053791
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	258	-81.32422	24.59323	mg/L	-4.021250e-06	112	0.0021655566	0.00000827	0.01119498	1.15963691	NA	0.8058402916
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	259	-81.32167	24.57037	mg/L	-1.602133e-05	169	0.0025858020	0.00008551	0.02452212	1.15916894	NA	0.4757550709
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	260	-81.41662	24.62550	mg/L	-5.421143e-05	100	0.0055280134	0.00022400	0.04073300	1.24460899	NA	0.1430736467
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	261	-81.50000	24.58333	mg/L	-2.570357e-05	110	0.0027877625	0.00003271	0.03960394	1.99512088	NA	0.4236754241
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	261i	-81.41487	24.60065	mg/L	NA	4	0.0034841650	0.00189090	0.00605790	0.51928556	NA	NA
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	262	-81.41887	24.58618	mg/L	-6.050571e-05	113	0.0021793479	0.00001871	0.01271335	1.10384330	-6.050571e-05	0.0323920582
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	263	-81.39742	24.54843	mg/L	-5.140000e-06	158	0.0021283552	0.00001400	0.01387442	1.07848622	NA	0.6525637364
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	264	-80.45947	24.94677	mg/L	1.309185e-05	170	0.0023687272	0.00001181	0.03089660	1.21455228	NA	0.5192690581
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	265	-81.08333	24.81667	mg/L	2.009024e-05	60	0.0021126357	0.00006506	0.01638434	1.49023292	NA	0.3570233333
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	266	-81.50527	24.61105	mg/L	-6.089186e-05	95	0.0040382282	0.00010505	0.02269990	0.98617184	NA	0.1540408566
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	267	-81.48730	24.53008	mg/L	-6.816042e-06	168	0.0028586216	0.00003750	0.01517824	1.01645574	NA	0.7765231077
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	268	-81.57698	24.58782	mg/L	-4.556406e-05	135	0.0045436501	0.00003502	0.02314200	0.88896619	NA	0.1189552546
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	269	-81.55955	24.55943	mg/L	4.695000e-06	172	0.0025874413	0.00003292	0.01509222	1.10472470	NA	0.8031259056
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	270	-81.56432	24.52162	mg/L	-4.366667e-07	173	0.0025306971	0.00000508	0.01868727	1.15484089	NA	1.0000000000
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	271	-81.66667	24.55667	mg/L	2.971114e-05	197	0.0035258832	0.00014007	0.01708817	0.85134122	NA	0.2162745664
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	272	-81.65433	24.50548	mg/L	-1.987500e-07	167	0.0027174106	0.00002871	0.01932000	1.18845850	NA	1.0000000000
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	273	-81.65710	24.49290	mg/L	-2.340333e-05	164	0.0034028941	0.00010505	0.01877060	1.04616728	NA	0.4082532436
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	273i	-81.65048	24.49103	mg/L	-1.304372e-03	10	0.0024476700	0.00031515	0.00539258	0.74001051	NA	0.2452781168
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	274	-81.75000	24.54167	mg/L	-8.778417e-05	116	0.0041834787	0.00027634	0.01407323	0.76184489	NA	0.0749455333
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	275	-81.74422	24.52143	mg/L	-1.543900e-05	173	0.0029372930	0.00000000	0.01593942	1.14033673	NA	0.4217829214
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	276	-81.73742	24.47538	mg/L	-3.272750e-05	169	0.0028754316	0.00003613	0.03208800	1.19942295	NA	0.1026088227
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	277	-81.82110	24.51762	mg/L	-1.063067e-04	115	0.0036075600	0.00028013	0.01537235	0.91199637	-1.063067e-04	0.0163975516
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	278	-81.81895	24.49862	mg/L	-5.040769e-06	176	0.0027331787	0.00001366	0.02002958	1.30685970	NA	0.7133134531
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	279	-81.81297	24.45803	mg/L	-8.817143e-05	100	0.0026663792	0.00002990	0.01823205	1.17254447	NA	0.0822617937
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	280	-81.84365	24.45363	mg/L	2.268778e-05	175	0.0031709999	0.00004200	0.01909580	1.12311473	NA	0.4109480267
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	281	-81.89167	24.49500	mg/L	2.287000e-05	173	0.0028040732	0.00007003	0.02466800	1.17235992	NA	0.3352367475
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	282	-80.88500	24.86667	mg/L	-3.500000e-05	90	0.0019642366	0.00002183	0.01043190	1.04027603	NA	0.0776130267
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	283	-81.00000	24.90000	mg/L	4.203942e-06	52	0.0015800946	0.00003502	0.00775020	1.02580496	NA	0.9509245838
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	284	-80.95833	24.87667	mg/L	-6.610000e-06	84	0.0019545296	0.00000093	0.01078000	1.23243492	NA	0.9434513259
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	285	-80.92028	24.80998	mg/L	-1.109412e-05	96	0.0036534977	0.00010494	0.02510701	1.13654308	NA	0.7416489507
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	286	-80.92395	24.78333	mg/L	-1.358650e-04	62	0.0047190406	0.00028019	0.02269085	0.86729171	NA	0.1290725461
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	287	-81.00833	24.84667	mg/L	-2.871429e-07	94	0.0014569807	0.00007003	0.00664962	1.05092709	NA	0.9509786443
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	288	-81.08333	24.88333	mg/L	2.221133e-05	82	0.0020019816	0.00003646	0.02973600	1.84948646	NA	0.2164732688
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	289	-81.03300	24.77775	mg/L	-3.614500e-05	98	0.0047542453	0.00021000	0.02986200	1.16298885	NA	0.4491802507
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	290	-81.21623	24.86267	mg/L	-1.540000e-05	82	0.0017031623	0.00005411	0.01390536	1.27336274	NA	0.5409820767
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	291	-81.14678	24.81682	mg/L	-5.941875e-06	83	0.0015810500	0.00001400	0.00953623	1.01253926	NA	0.7014541403
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	292	-81.11248	24.76312	mg/L	-1.580000e-06	94	0.0035869248	0.00010505	0.02027470	1.10867604	NA	1.0000000000
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	293	-81.10930	24.73753	mg/L	-4.023667e-05	62	0.0048262637	0.00007003	0.04117970	1.22019477	NA	0.6797886914
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	294	-81.17218	24.75550	mg/L	1.691250e-05	99	0.0022838382	0.00014007	0.01137932	0.99873178	NA	0.4167797499
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	295	-81.35123	24.85163	mg/L	-2.317567e-05	87	0.0018930662	0.00000057	0.01244600	1.21972467	NA	0.3198861868
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	296	-81.28908	24.79152	mg/L	-8.076471e-07	86	0.0022113903	0.00002800	0.01103358	0.97672027	NA	1.0000000000
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	297	-81.21118	24.74077	mg/L	3.476333e-05	63	0.0030390051	0.00000155	0.01442679	1.04663256	NA	0.6346283865
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	298	-81.43112	24.84085	mg/L	1.158375e-05	56	0.0022513493	0.00007844	0.01817369	1.45836475	NA	0.7288260099
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	299	-81.34182	24.68737	mg/L	-1.864085e-04	64	0.0056907433	0.00034518	0.02409152	0.90225438	NA	0.0592975599
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	300	-81.30923	24.70882	mg/L	-2.678500e-05	60	0.0030941832	0.00003502	0.01236792	0.73381332	NA	0.3415529664
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	301	-81.39665	24.77258	mg/L	-1.713026e-05	88	0.0020426675	0.00012356	0.00890735	0.86282423	NA	0.5052688745
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	302	-81.48227	24.80128	mg/L	3.898968e-05	88	0.0020233769	0.00012820	0.01451794	0.97170950	NA	0.0823013004
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	303	-81.39198	24.69242	mg/L	-1.325255e-04	63	0.0088531456	0.00048879	0.04293054	0.77051883	NA	0.2284224171
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	304	-81.45157	24.71220	mg/L	-2.278962e-04	63	0.0064723668	0.00033043	0.03529688	1.02549993	-2.278962e-04	0.0159887469
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	305	-81.55500	24.76852	mg/L	1.904083e-05	86	0.0024523581	0.00000041	0.01091320	0.96886430	NA	0.5193268870
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	306	-81.59247	24.73770	mg/L	-3.915375e-05	59	0.0026423359	0.00003502	0.01895340	1.12747211	NA	0.4911830504
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	307	-81.52052	24.72503	mg/L	-9.034286e-06	88	0.0029955430	0.00010406	0.02539648	1.22165004	NA	0.6353063153
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	308	-81.48820	24.69430	mg/L	-8.956889e-05	61	0.0035657493	0.00019845	0.02210958	0.99403030	NA	0.1398194534
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	309	-81.68318	24.69772	mg/L	-2.275615e-05	89	0.0022333220	0.00001167	0.01393667	1.03778267	NA	0.3039554226
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	310	-81.63265	24.65752	mg/L	-1.099578e-04	96	0.0054647669	0.00001400	0.04252811	1.35079593	-1.099578e-04	0.0138274792
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	311	-81.65008	24.61762	mg/L	-6.614593e-04	63	0.0112331841	0.00056027	0.06187460	1.06858059	-6.614593e-04	0.0006339563
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	312	-81.76343	24.65978	mg/L	-2.606429e-06	92	0.0023916311	0.00007003	0.01299472	1.04861119	NA	0.9495457714
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	313	-81.73210	24.64157	mg/L	-4.495843e-05	59	0.0022452514	0.00003502	0.02705628	1.89794779	NA	0.4218922702
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	314	-81.43578	24.75043	mg/L	-3.939200e-05	96	0.0026314566	0.00000000	0.01429120	1.10305558	-3.939200e-05	0.0374840040
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	315	-81.82827	24.63325	mg/L	1.324444e-05	89	0.0024194710	0.00005732	0.02262549	1.40575570	NA	0.6607373241
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	316	-81.80240	24.58577	mg/L	-1.627818e-05	102	0.0048470471	0.00004542	0.02558557	0.81335567	NA	0.7422150481
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	317	-81.78833	24.57500	mg/L	-4.174000e-06	99	0.0050511877	0.00006884	0.02708896	0.89808188	NA	0.9539660788
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	318	-81.90467	24.65083	mg/L	-1.721363e-05	151	0.0024759784	0.00003502	0.02034200	1.40565477	NA	0.2727291635
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	319	-82.07133	24.62900	mg/L	5.950114e-06	165	0.0030230884	0.00003502	0.02597000	1.58641120	NA	0.6930850907
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	320	-82.96667	24.65167	mg/L	-3.564265e-05	98	0.0029830393	0.00000834	0.03066300	1.81285296	NA	0.4825235903
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	320i	-82.06033	24.58600	mg/L	NA	2	0.0011205350	0.00098047	0.00126060	0.17677433	NA	NA
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	321	-82.94000	24.64167	mg/L	5.806477e-06	108	0.0035009393	0.00007634	0.03219440	1.35992615	NA	0.9027856176
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	321i	-82.02833	24.55000	mg/L	NA	4	0.0032915750	0.00301144	0.00371178	0.10017363	NA	NA
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	322	-81.98167	24.45833	mg/L	1.719833e-05	177	0.0030642517	0.00003502	0.03181855	1.36696934	NA	0.4239287645
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	323	-82.17000	24.70500	mg/L	-9.458929e-05	100	0.0030073605	0.00004079	0.02955414	1.45758715	-9.458929e-05	0.0025470131
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	324	-82.15833	24.65333	mg/L	3.519375e-06	186	0.0035893969	0.00003502	0.02799134	1.39561803	NA	0.8707850182
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	325	-82.10000	24.54167	mg/L	-6.826984e-07	181	0.0025774617	0.00008171	0.02081162	1.31856998	NA	0.9582162924
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	326	-82.25000	24.70833	mg/L	1.340500e-05	100	0.0020975877	0.00005115	0.02037975	1.55917311	NA	0.3656116686
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	327	-82.22333	24.61667	mg/L	-1.835250e-05	113	0.0026155625	0.00005379	0.02078209	1.43925169	NA	0.2378239191
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	328	-82.22400	24.45400	mg/L	7.900000e-07	173	0.0021953765	0.00007235	0.01439188	1.06549817	NA	1.0000000000
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	329	-82.54167	24.71667	mg/L	-9.342500e-06	93	0.0017118545	0.00003024	0.01337640	1.39984160	NA	0.4727849934
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	329i	-82.33667	24.69667	mg/L	NA	2	0.0002626250	0.00010505	0.00042020	0.84852814	NA	NA
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	330	-82.37400	24.66533	mg/L	-1.833857e-06	181	0.0025972029	0.00003502	0.01781932	1.28516844	NA	0.9303742273
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	331	-82.28767	24.50683	mg/L	-3.312283e-05	107	0.0016052570	0.00003502	0.01708817	1.65704682	NA	0.1752567743
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	332	-82.36733	24.53550	mg/L	4.136111e-07	175	0.0018563607	0.00002656	0.02640120	1.61997744	NA	0.9826139499
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	333	-82.49133	24.57717	mg/L	-1.486333e-05	163	0.0013636867	0.00002064	0.01926341	1.65983517	NA	0.1392638657
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	334	-82.45033	24.51217	mg/L	-5.952800e-05	110	0.0013423232	0.00002801	0.01236511	1.44532272	-5.952800e-05	0.0002466044
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	335	-82.38317	24.46083	mg/L	-1.977849e-05	162	0.0013784673	0.00004201	0.01218515	1.15542822	NA	0.1656428874
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	336	-82.64633	24.65483	mg/L	-7.697857e-06	97	0.0012926943	0.00003030	0.00820092	1.15863469	NA	0.7120365527
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	337	-82.58783	24.59133	mg/L	-3.206333e-05	175	0.0020847528	0.00000391	0.01670719	1.14909741	NA	0.1096849577
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	338	-82.87700	24.63680	mg/L	-4.241067e-05	104	0.0015784619	0.00003502	0.01024590	0.97982147	NA	0.2185236160
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	338i	-82.54517	24.56683	mg/L	NA	2	0.0010329950	0.00042020	0.00164579	0.83894211	NA	NA
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	339	-82.51083	24.42833	mg/L	8.869470e-06	109	0.0012623176	0.00003502	0.01203829	1.12974994	NA	0.5201464363
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	340	-82.65333	24.48500	mg/L	-3.766400e-05	98	0.0013312453	0.00000197	0.01110451	1.23779471	NA	0.1843811233
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	341	-82.88333	24.69833	mg/L	-3.391444e-05	111	0.0023631750	0.00008203	0.01383842	0.99012801	NA	0.3261387602
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	342	-82.74567	24.70600	mg/L	-7.213000e-06	103	0.0014359094	0.00001206	0.01095277	1.35115461	NA	0.6657021170
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	343	-82.85500	24.75500	mg/L	1.324200e-05	100	0.0019311105	0.00000685	0.01351741	1.37035323	NA	0.5583060786
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	344	-82.80500	24.56333	mg/L	-4.906875e-05	89	0.0015972158	0.00001604	0.01498717	1.65663146	-4.906875e-05	0.0440119594
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	345	-82.70467	24.37900	mg/L	-3.719191e-05	97	0.0041158001	0.00000118	0.05729985	2.33689405	NA	0.1633803391
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	346	-83.08333	24.66667	mg/L	-6.461111e-06	98	0.0018773940	0.00000207	0.01398756	1.00794655	NA	0.7772438010
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	347	-82.99667	24.65400	mg/L	-3.065333e-05	91	0.0016986467	0.00014770	0.00649597	0.79201982	NA	0.3134028525
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	348	-82.85500	24.64167	mg/L	-1.289423e-06	108	0.0014803634	0.00002260	0.00581278	0.87105649	NA	0.9588411099
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	348i	-82.85333	24.52833	mg/L	NA	4	0.0015057200	0.00003502	0.00528753	1.68000855	NA	NA
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	349	-82.93113	24.63795	mg/L	2.386350e-05	114	0.0022168566	0.00015772	0.00677971	0.69957959	NA	0.5079639293
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	349i	-83.00000	24.55000	mg/L	NA	2	0.0015407400	0.00024512	0.00283636	1.18922295	NA	NA
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	350	-82.86667	24.45000	mg/L	-4.973909e-05	99	0.0013800873	0.00001254	0.01881100	1.63572643	-4.973909e-05	0.0389370854
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	351	-81.79167	24.69167	mg/L	1.099778e-05	48	0.0023220721	0.00002668	0.01998389	1.75163714	NA	0.8519989106
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	352	-81.78300	24.77583	mg/L	-9.937727e-06	51	0.0015798463	0.00003502	0.01109891	1.37137717	NA	0.7760179605
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	353	-81.77667	24.85833	mg/L	-1.586055e-05	49	0.0015388996	0.00002925	0.00740954	1.10000691	NA	0.7013276329
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	354	-81.76867	24.94133	mg/L	-4.430133e-05	43	0.0016646240	0.00010505	0.00863561	1.21251754	NA	0.5153419587
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	355	-81.76250	25.02467	mg/L	-6.962167e-05	43	0.0017040107	0.00000348	0.01011844	1.30037503	NA	0.1926714553
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	356	-81.75383	25.10767	mg/L	-3.097500e-05	45	0.0022390500	0.00000280	0.01446052	1.35035701	NA	0.4755504913
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	357	-81.74533	25.19117	mg/L	-6.738000e-05	47	0.0020634932	0.00003502	0.01246456	1.28662108	NA	0.1333467351
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	358	-81.73817	25.27467	mg/L	-2.334667e-05	45	0.0022070493	0.00003502	0.01558245	1.48853087	NA	0.5449664437
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	359	-81.73000	25.35833	mg/L	-3.478900e-05	47	0.0023773915	0.00003502	0.01889504	1.50449182	NA	0.3514790069
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	360	-81.72100	25.44117	mg/L	1.023333e-06	46	0.0023659098	0.00003502	0.01868494	1.68812532	NA	1.0000000000
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	361	-81.71500	25.52467	mg/L	1.060000e-05	46	0.0015330280	0.00007003	0.01425042	1.48648374	NA	0.5378840602
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	362	-81.70667	25.60867	mg/L	-1.511725e-05	46	0.0016478000	0.00002101	0.01418038	1.32538739	NA	0.7491753396
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	363	-81.69833	25.69200	mg/L	-8.010611e-05	50	0.0021892996	0.00010257	0.01358510	1.26191892	NA	0.0839065498
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	364	-81.53333	25.69167	mg/L	7.168333e-06	49	0.0020142386	0.00003502	0.01278111	1.08260992	NA	1.0000000000
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	365	-81.53933	25.60850	mg/L	-2.860975e-05	50	0.0020137568	0.00003502	0.01603627	1.44161638	NA	0.5980410863
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	366	-81.54883	25.52600	mg/L	-3.209833e-05	48	0.0021780825	0.00009740	0.01600125	1.60057312	NA	0.5993096653
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	367	-81.55500	25.44250	mg/L	-6.599048e-05	45	0.0023052064	0.00005953	0.01635142	1.39984824	NA	0.3550150505
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	368	-81.56333	25.35850	mg/L	1.247019e-06	49	0.0018814549	0.00007003	0.01337500	1.31396222	NA	0.8525265034
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	369	-81.57200	25.27550	mg/L	-2.824333e-05	49	0.0021547794	0.00003246	0.01453195	1.47510981	NA	0.7387875457
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	370	-81.57917	25.19183	mg/L	-9.687500e-05	47	0.0025757721	0.00001695	0.01894406	1.68887751	NA	0.0735584478
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	371	-81.58683	25.10833	mg/L	-5.258600e-05	45	0.0019618842	0.00000035	0.02328614	2.14229797	NA	0.2671053916
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	372	-81.59533	25.02500	mg/L	-1.366312e-05	50	0.0018606480	0.00003502	0.01568610	1.70021721	NA	0.7028646206
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	373	-81.60300	24.94217	mg/L	-9.803333e-06	45	0.0018541764	0.00003502	0.01397168	1.58788259	NA	0.8320298806
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	374	-81.61083	24.85883	mg/L	2.688350e-05	51	0.0022193720	0.00003370	0.01523229	1.46723462	NA	0.3834938497
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	375	-81.61783	24.77567	mg/L	-9.000000e-07	53	0.0024141070	0.00007389	0.01782213	1.36596766	NA	1.0000000000
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	376	-81.43833	24.84333	mg/L	-1.658100e-05	51	0.0018336378	0.00003596	0.01432045	1.41644561	NA	0.5335598907
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	377	-81.43167	24.93500	mg/L	-5.218250e-05	46	0.0019501365	0.00007811	0.01720303	1.79707879	NA	0.1168322182
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	378	-81.41583	25.01667	mg/L	-2.131300e-05	54	0.0020147296	0.00009163	0.02240021	1.77624019	NA	0.4999537191
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	379	-81.40883	25.10000	mg/L	3.043111e-05	53	0.0016877602	0.00002836	0.00795931	1.02738924	NA	0.3320191220
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	380	-81.40000	25.18333	mg/L	5.411000e-05	55	0.0019364069	0.00003502	0.01252849	1.30707763	NA	0.0834495330
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	381	-81.39500	25.26667	mg/L	-5.881667e-06	54	0.0019804533	0.00007003	0.00924442	1.05736737	NA	0.8275211209
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	382	-81.38667	25.35000	mg/L	2.095650e-05	54	0.0024740615	0.00007003	0.01789356	1.36519570	NA	0.7310052085
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	383	-81.37783	25.43250	mg/L	-6.959286e-06	51	0.0023958749	0.00010505	0.01368595	1.22585752	NA	0.8789391313
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	384	-81.37000	25.51550	mg/L	1.179535e-05	48	0.0015001392	0.00002451	0.00561248	0.89123194	NA	0.7782645842
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	385	-81.36317	25.60017	mg/L	-6.099625e-05	51	0.0024722837	0.00015057	0.01575754	1.21050050	NA	0.3096750731
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	386	-81.34050	25.55550	mg/L	-2.763250e-05	52	0.0018123900	0.00003502	0.00686048	0.96936442	NA	0.4688397117
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	387	-81.31683	25.50883	mg/L	-3.628000e-05	54	0.0025093520	0.00001304	0.01792858	1.33868854	NA	0.7388282816
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	388	-81.29700	25.42500	mg/L	-1.683933e-04	53	0.0019656642	0.00003502	0.00919820	0.91995686	-1.683933e-04	0.0043571197
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	389	-81.27700	25.34167	mg/L	-6.482250e-05	50	0.0022734248	0.00003502	0.01326575	1.28734891	NA	0.2060649373
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	390	-81.26017	25.26000	mg/L	-1.087592e-04	53	0.0038340151	0.00017508	0.02202554	1.26001208	NA	0.3367575543
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	391	-81.23867	25.17500	mg/L	-6.173000e-05	55	0.0029855715	0.00014007	0.02302640	1.37196487	NA	0.1197509763
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	392	-81.24833	25.09167	mg/L	-1.366540e-05	52	0.0021632681	0.00002381	0.01968922	1.50512083	NA	0.8338274106
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	393	-81.25333	25.00833	mg/L	-1.005567e-04	49	0.0029809447	0.00003502	0.03173600	1.96826952	NA	0.1403099857
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	394	-81.26000	24.92500	mg/L	-6.066400e-05	49	0.0020731439	0.00004916	0.02383520	1.73580504	NA	0.1237435561
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	395	-81.19167	24.87833	mg/L	-1.123410e-04	51	0.0025179171	0.00011556	0.01629259	1.35869100	NA	0.0652565801
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	396	-81.12833	24.83333	mg/L	-2.116727e-05	48	0.0017256715	0.00007905	0.00930885	1.10733490	NA	0.6257438233
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	397	-81.11833	24.91667	mg/L	-6.871429e-05	48	0.0025423406	0.00007003	0.02471412	1.59049626	NA	0.3077430736
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	398	-81.11000	25.00000	mg/L	-1.855179e-04	51	0.0042792773	0.00009683	0.07809716	2.57836025	-1.855179e-04	0.0019044132
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	399	-81.09933	25.08333	mg/L	-1.983000e-04	51	0.0054936955	0.00006075	0.07161906	1.96160025	-1.983000e-04	0.0407130330
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	400	-80.30640	25.10730	mg/L	-3.370643e-05	169	0.0027198762	0.00004120	0.05516560	1.69310948	NA	0.1691748477
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	401	-80.62200	24.85300	mg/L	-3.071368e-05	149	0.0020608389	0.00002334	0.02943920	1.68490465	NA	0.1584725456
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	402	-81.11200	24.63000	mg/L	-2.236714e-05	154	0.0020321546	0.00001400	0.01775443	1.18808801	NA	0.1502907612
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	403	-81.70000	24.48300	mg/L	2.102189e-05	165	0.0024243142	0.00007003	0.01388721	0.94828415	NA	0.4862204908
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	404	-82.89500	24.64133	mg/L	9.976750e-05	28	0.0011828375	0.00022932	0.00414584	0.90207646	NA	0.3835241856
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	500	-80.43346	25.08535	mg/L	2.830400e-04	37	0.0053859773	0.00015400	0.03420200	1.35108681	NA	0.4198098542
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	501	-80.43421	25.11052	mg/L	-4.080900e-04	37	0.0081445881	0.00040880	0.03648400	1.00807606	NA	0.1913087696
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	502	-80.62067	24.92650	mg/L	5.623900e-04	35	0.0049557586	0.00028000	0.01654035	0.79732306	NA	0.1639707296
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	503	-80.63477	24.92050	mg/L	2.315250e-04	36	0.0050699675	0.00055510	0.01752800	0.88098328	NA	0.4084616014
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	504	-81.04337	24.72254	mg/L	9.538050e-04	35	0.0084588306	0.00072800	0.02668400	0.83274726	9.538050e-04	0.0268884541
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	505	-81.10071	24.71207	mg/L	-1.329750e-04	35	0.0056709280	0.00037350	0.01550722	0.75812841	NA	0.5883243364
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	506	-81.38327	24.65941	mg/L	-8.839129e-04	36	0.0129600292	0.00070000	0.03639300	0.79761125	NA	0.1363329953
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	507	-81.35463	24.69309	mg/L	-2.279930e-04	33	0.0033874403	0.00011267	0.01306844	0.94213972	NA	0.2632234316
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	508	-81.76014	24.57375	mg/L	3.508833e-05	37	0.0077198100	0.00098637	0.03129000	0.77387327	NA	0.9329643442
Florida Keys National Marine Sanctuary Water Quality Monitoring Project	509	-81.74941	24.55229	mg/L	-6.840042e-05	35	0.0046467337	0.00029050	0.04089400	1.60081729	NA	0.9192642066
Miami-Dade County DERM Benthic Habitat Monitoring Program	BD17	-80.43947	25.72832	mg/L	NA	1	0.0100000000	0.01000000	0.01000000	NA	NA	NA
Miami-Dade County DERM Benthic Habitat Monitoring Program	BL03	-80.34814	25.54905	mg/L	NA	2	0.0332375000	0.01000000	0.05647500	0.98872622	NA	NA
Miami-Dade County DERM Benthic Habitat Monitoring Program	BL12	-80.43061	25.66102	mg/L	NA	1	0.0100000000	0.01000000	0.01000000	NA	NA	NA
Miami-Dade County DERM Benthic Habitat Monitoring Program	CD02	-80.30987	25.61118	mg/L	NA	2	0.0129065000	0.01000000	0.01581300	0.31847609	NA	NA
Miami-Dade County DERM Benthic Habitat Monitoring Program	CD08	-80.34485	25.64456	mg/L	NA	1	0.0022590000	0.00225900	0.00225900	NA	NA	NA
Miami-Dade County DERM Benthic Habitat Monitoring Program	CD09	-80.40868	25.66588	mg/L	NA	2	0.0129065000	0.01000000	0.01581300	0.31847609	NA	NA
Miami-Dade County DERM Benthic Habitat Monitoring Program	CG05	-80.28680	25.73869	mg/L	NA	2	0.0196835000	0.01000000	0.02936700	0.69573689	NA	NA
Miami-Dade County DERM Benthic Habitat Monitoring Program	CG07	-80.31067	25.74108	mg/L	NA	2	0.0185540000	0.01000000	0.02710800	0.65199864	NA	NA
Miami-Dade County DERM Benthic Habitat Monitoring Program	LN01	-80.49788	25.76165	mg/L	NA	2	0.0072590000	0.00451800	0.01000000	0.53400735	NA	NA
Miami-Dade County DERM Benthic Habitat Monitoring Program	LN04	-80.54395	25.56453	mg/L	NA	1	0.0100000000	0.01000000	0.01000000	NA	NA	NA
Miami-Dade County DERM Benthic Habitat Monitoring Program	LN06	-80.56294	25.48411	mg/L	NA	2	0.0072590000	0.00451800	0.01000000	0.53400735	NA	NA
Miami-Dade County DERM Benthic Habitat Monitoring Program	LR09	-80.31450	25.86961	mg/L	NA	2	0.0185540000	0.01000000	0.02710800	0.65199864	NA	NA
Miami-Dade County DERM Benthic Habitat Monitoring Program	LR10	-80.33872	25.86956	mg/L	NA	1	0.0100000000	0.01000000	0.01000000	NA	NA	NA
Miami-Dade County DERM Benthic Habitat Monitoring Program	LS06	-80.55873	25.42067	mg/L	NA	2	0.0117770000	0.01000000	0.01355400	0.21338690	NA	NA
Miami-Dade County DERM Benthic Habitat Monitoring Program	MR09	-80.26220	25.80875	mg/L	NA	2	0.0490505000	0.01000000	0.08810100	1.12589569	NA	NA
Miami-Dade County DERM Benthic Habitat Monitoring Program	MR10	-80.28972	25.81855	mg/L	NA	2	0.0377555000	0.01000000	0.06551100	1.03964203	NA	NA
Miami-Dade County DERM Benthic Habitat Monitoring Program	MR15	-80.37943	25.89598	mg/L	NA	1	0.0100000000	0.01000000	0.01000000	NA	NA	NA
Miami-Dade County DERM Benthic Habitat Monitoring Program	MR16	-80.44006	25.94211	mg/L	NA	2	0.0083885000	0.00677700	0.01000000	0.27168208	NA	NA
Miami-Dade County DERM Benthic Habitat Monitoring Program	MW13	-80.54258	25.51749	mg/L	NA	1	0.0100000000	0.01000000	0.01000000	NA	NA	NA
Miami-Dade County DERM Benthic Habitat Monitoring Program	OL03	-80.15020	25.96371	mg/L	NA	2	0.0083885000	0.00677700	0.01000000	0.27168208	NA	NA
Miami-Dade County DERM Benthic Habitat Monitoring Program	PR09	-80.52724	25.58702	mg/L	NA	1	0.0100000000	0.01000000	0.01000000	NA	NA	NA
Miami-Dade County DERM Benthic Habitat Monitoring Program	SK07	-80.26231	25.96187	mg/L	NA	2	0.0129065000	0.01000000	0.01581300	0.31847609	NA	NA
Miami-Dade County DERM Benthic Habitat Monitoring Program	SK09	-80.31109	25.96423	mg/L	NA	3	0.0108633333	0.01000000	0.01129500	0.06882497	NA	NA
Miami-Dade County DERM Benthic Habitat Monitoring Program	SP03	-80.28492	25.68907	mg/L	NA	2	0.0196835000	0.01000000	0.02936700	0.69573689	NA	NA
Miami-Dade County DERM Benthic Habitat Monitoring Program	SP08	-80.38297	25.71548	mg/L	NA	2	0.0117770000	0.01000000	0.01355400	0.21338690	NA	NA
Miami-Dade County DERM Benthic Habitat Monitoring Program	SP15	-80.38626	25.82692	mg/L	NA	1	0.0100000000	0.01000000	0.01000000	NA	NA	NA
Palm Beach County Water Quality Program	10	-80.05743	26.84365	mg/L	NA	1	0.0280000000	0.02800000	0.02800000	NA	NA	NA
Palm Beach County Water Quality Program	11	-80.06013	26.83159	mg/L	1.227418e-03	62	0.4903208758	0.00050000	27.00000000	6.98054201	NA	0.1529888383
Palm Beach County Water Quality Program	12	-80.08183	26.81728	mg/L	NA	4	0.0635908500	0.02846340	0.08132400	0.37542980	NA	NA
Palm Beach County Water Quality Program	12A	-80.08820	26.75872	mg/L	7.408829e-03	51	0.1114318194	0.00250749	0.83500000	1.22490502	7.408829e-03	0.0195923380
Palm Beach County Water Quality Program	13	-80.05627	26.80851	mg/L	1.142857e-03	64	0.5372882547	0.00050000	27.00000000	6.26479956	NA	0.2361169087
Palm Beach County Water Quality Program	13	-80.05596	26.80851	mg/L	NA	1	0.1200000000	0.12000000	0.12000000	NA	NA	NA
Palm Beach County Water Quality Program	14	-80.04497	26.78333	mg/L	NA	3	0.0014307000	0.00067770	0.00293670	0.91160569	NA	NA
Palm Beach County Water Quality Program	15	-80.15617	26.81272	mg/L	0.000000e+00	43	0.0535487070	0.00158130	0.67600000	2.08596392	NA	1.0000000000
Palm Beach County Water Quality Program	16	-80.24548	26.87235	mg/L	1.955100e-03	43	0.0703687558	0.00451800	0.68700000	1.60890956	NA	0.1419908467
Palm Beach County Water Quality Program	18A	-80.04681	26.67545	mg/L	NA	2	0.0092619000	0.00067770	0.01784610	1.31073452	NA	NA
Palm Beach County Water Quality Program	18C	-80.04361	26.63972	mg/L	0.000000e+00	61	0.6883918033	0.00050000	34.00000000	6.31061752	NA	0.9489977715
Palm Beach County Water Quality Program	18D	-80.04583	26.62917	mg/L	3.880000e-03	52	0.6370807692	0.00050000	27.00000000	5.86510440	NA	0.2442988931
Palm Beach County Water Quality Program	20	-80.05641	26.64473	mg/L	NA	3	0.0430716000	0.03162600	0.04969800	0.23108688	NA	NA
Palm Beach County Water Quality Program	22	-80.07722	26.60778	mg/L	-3.000000e-03	33	0.1174909091	0.00000000	0.72000000	1.45751262	NA	0.6443731500
Palm Beach County Water Quality Program	24	-80.07831	26.58779	mg/L	-9.972318e-04	37	0.0656942459	0.00300000	0.51800000	1.69340571	NA	0.7260578130
Palm Beach County Water Quality Program	27A	-80.12300	26.53891	mg/L	-4.750000e-05	44	0.0951079977	0.00225900	0.84900000	1.56496453	NA	1.0000000000
Palm Beach County Water Quality Program	27B	-80.20509	26.53859	mg/L	8.750000e-04	41	0.1474067195	0.00158130	0.75400000	1.09841235	NA	0.8197501375
Palm Beach County Water Quality Program	28	-80.05733	26.53911	mg/L	7.742744e-03	8	0.0973952375	0.02500000	0.28000000	0.97406132	NA	1.0000000000
Palm Beach County Water Quality Program	28A	-80.05376	26.52703	mg/L	NA	2	0.0114079500	0.00067770	0.02213820	1.33020088	NA	NA
Palm Beach County Water Quality Program	31B	-80.07376	26.42219	mg/L	NA	7	0.0766424286	0.02500000	0.27000000	1.17298962	NA	NA
Palm Beach County Water Quality Program	31C	-80.12212	26.42434	mg/L	-2.500000e-03	46	0.0969772391	0.00560000	0.80500000	1.42071064	NA	0.2488611998
Palm Beach County Water Quality Program	31D	-80.06521	26.43961	mg/L	NA	2	0.0232677000	0.00090360	0.04563180	1.35929265	NA	NA
Palm Beach County Water Quality Program	31E	-80.20377	26.42385	mg/L	-1.858078e-03	46	0.1258171630	0.00203310	1.34000000	1.82945628	NA	0.5105691712
Palm Beach County Water Quality Program	37B	-80.20255	26.67991	mg/L	4.333333e-03	48	0.2102226833	0.00700000	0.92300000	0.91713554	NA	0.6282566917
Palm Beach County Water Quality Program	38B	-80.35131	26.68430	mg/L	8.149636e-03	52	0.2341433096	0.00560000	1.39000000	1.22674851	NA	0.1599869530
Palm Beach County Water Quality Program	52	-80.07083	26.67694	mg/L	1.096429e-02	39	0.0759076923	0.00000000	0.35000000	1.27653087	NA	0.2355274030
Palm Beach County Water Quality Program	57	-80.07139	26.69028	mg/L	1.077500e-02	39	0.0925461538	0.00000000	0.33800000	0.92204562	NA	0.1704940065
Palm Beach County Water Quality Program	61	-80.07500	26.63250	mg/L	1.760000e-02	38	0.1611500000	0.00000000	0.96300000	1.15809925	NA	0.6034765878
Palm Beach County Water Quality Program	62	-80.07194	26.65389	mg/L	2.500000e-03	39	0.1517769231	0.00000000	0.45000000	0.83718106	NA	0.9216354185
Palm Beach County Water Quality Program	63	-80.08389	26.47694	mg/L	1.533333e-02	39	0.0771717949	0.00000000	0.71100000	1.54360936	1.533333e-02	0.0241122746
Palm Beach County Water Quality Program	64	-80.07667	26.48944	mg/L	8.800000e-03	40	0.0652175000	0.00000000	0.22000000	1.05078562	NA	0.0932478423
Palm Beach County Water Quality Program	65	-80.07472	26.58000	mg/L	1.600000e-02	40	0.0773275000	0.00000000	0.43000000	1.23236545	NA	0.0777141829
Palm Beach County Water Quality Program	66	-80.07472	26.60139	mg/L	4.000000e-04	39	0.1210282051	0.00000000	0.72700000	1.29815783	NA	0.6272203523
Palm Beach County Water Quality Program	67	-80.08056	26.60361	mg/L	NA	1	0.0500000000	0.05000000	0.05000000	NA	NA	NA
Palm Beach County Water Quality Program	68	-80.07278	26.61361	mg/L	1.200000e-02	40	0.1221025000	0.00000000	0.75400000	1.28867129	NA	0.0751556886
Palm Beach County Water Quality Program	69	-80.07361	26.64944	mg/L	0.000000e+00	39	0.1329000000	0.00000000	0.44000000	0.96016109	NA	1.0000000000
Palm Beach County Water Quality Program	7	-80.14173	26.93418	mg/L	NA	5	0.0159813000	0.00790650	0.01800000	0.28245202	NA	NA
Palm Beach County Water Quality Program	70	-80.07222	26.68167	mg/L	0.000000e+00	37	0.0668459459	0.00000000	0.70000000	1.88761863	NA	0.9124210043
Palm Beach County Water Quality Program	G92	-80.17592	26.91014	mg/L	NA	9	0.0274694111	0.00745470	0.06777000	0.76807845	NA	NA