bcgov / bcgov/canwqdata

Missing station Thompson River at Cooks Landing Rd (BC08LF0080)

Open
#10 1 comment 1 reaction 0 assignees View on GitHub
Dominant language
R
Stars
13
Forks
2
PR merge metrics
No merged PRs in 30d

Description

I'm trying to query data for this station, which I see [exists on the website](https://aquatic.pyr.ec.gc.ca/webdataonlinenational/en/Samples/Index/BC08LF0080), but it does not show up in the sites object for canwqdata:

```
library(reprex)
library(canwqdata)
library(dplyr)
#> Warning: package 'dplyr' was built under R version 4.5.3
#>
#> Attaching package: 'dplyr'
#> The following objects are masked from 'package:stats':
#>
#> filter, lag
#> The following objects are masked from 'package:base':
#>
#> intersect, setdiff, setequal, union

# Federal WQ monitoring locations that we are interested in
relv_fed_ids <- c(
# Nicola River at the Mouth
'BC08LG0001',
# Thompson river at Spences Bridge (this was the historical station name,
# between 1984-2014, communication JOanne Quarmby Aug 13 2026)
'BC08LF0001',
# Thompson river at Spences Bridge North Bank (this was the historical station name,
# between 2015-2024, communication Joanne Quarmby Aug 13 2026)
'BC08LF0078',
# Thompson River at Cooks Landing Rd - the latest station name (Communication
# Joanne Quarmby Aug 13 2026)
'BC08LF0080'
)

# Getting metadata about sites
sites <- canwqdata::wq_sites() |>
filter(SITE_NO %in% relv_fed_ids)

# Reviewing which ones were detected. Cooks Landing Rd site is missing
sites
#> # A tibble: 3 × 19
#> SITE_NO SITE_NAME SITE_NOM_FR SITE_TYPE SITE_DESC SITE_DESC_FR LATITUDE
#>
#> 1 BC08LF0001 THOMPSON RIV… RIVIÈRE TH… RIVER OR… AT HIGHW… AU PONT DE … 50.4
#> 2 BC08LF0078 THOMPSON RIV… RIVIÈRE TH… RIVER OR… ACCESS T… 50.4
#> 3 BC08LG0001 NICOLA RIVER… RIVIÈRE NI… RIVER OR… SAMPLED … PRÈS DU SIT… 50.4
#> # ℹ 12 more variables: LONGITUDE , DATUM , PROV_TERR ,
#> # PROV_TERR_FR , PEARSEDA , PEARSEDA_FR , OCEANDA ,
#> # OCEANDA_FR , DATA_URL , DATA_URL_FR , OPEN_DATA_URL ,
#> # csv_path
sites$SITE_NAME |> table()
#>
#> NICOLA RIVER AT THE MOUTH
#> 1
#> THOMPSON RIVER AT SPENCES BRIDGE
#> 1
#> THOMPSON RIVER AT SPENCES BRIDGE - NORTH BANK
#> 1
```

Contributor guide

Open the contributing guide

Research direction

Start with canwqdata::wq_sites() and trace how its site metadata is obtained and filtered. Compare the package result with the upstream station entry for BC08LF0080, then verify that wq_sites() includes the station with its expected metadata.

Written by the indexing model from the issue text.

Assessment

Tech stack
r
Domain
data
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Active
Clarity
Mostly clear
Newbie friendliness
65/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.