Query Buoy Data from Database

Flexible querying of buoy data with various filtering options. Uses dplyr verbs translated to SQL for efficient DuckDB execution.

Usage

query_buoy_data(
  con,
  stations = NULL,
  start_date = NULL,
  end_date = NULL,
  variables = NULL,
  qc_filter = TRUE
)

Arguments

con

DBI connection object

stations

Character vector of station IDs (default: all)

start_date

Start date for query

end_date

End date for query

variables

Character vector of variables to return

qc_filter

Logical, filter for good quality data only (default: TRUE)

Value

Data frame with query results

Examples

if (FALSE) { # \dontrun{
con <- connect_duckdb()
# Get recent M3 wave data
waves <- query_buoy_data(
  con,
  stations = "M3",
  variables = c("time", "wave_height", "wave_period"),
  start_date = Sys.Date() - 7
)
} # }