get_captures error for 2022 sparwood centennial square PM data

[DonnaHaga]

envair 0.4.0.600
R version 4.3.1

Trying to use get_captures on a dataframe retrieved from an importBC_data call:

data<-envair::importBC_data(parameter_or_station = c("pm25",
                                                     "pm10"),
                            years=2022,
                            use_openairformat = FALSE) %>%
  dplyr::filter(STATION_NAME=="Sparwood Centennial Square" &
                  lubridate::year(DATE_PST)==2022)
  

captures<-envair::get_captures(param=data,
                               years = 2022)

Produces this error:

[ZoeGao218]

envair version: 0.4.0.800

Hi Donna, get_captures() has been superseded by the function get_data_completeness().

Try the following codes:
capture <- envair :: get_data_completeness(param = 'PM2.5', years = 2022)

names(capture)
[1] "annual_hour" "annual_days" "quarter_days" "quarter_q2+q3"

There are four tables under "capture", you can choose one and filter it by station_name.

capture$annual_hour %>% dplyr :: filter(station_name == "Sparwood Centennial Square")

[ZoeGao218]

Note: get_captures() is now working in the latest version envair v. 0.4.0.900. It allows to retrieve data captures based on parameter and year, then filter by station. E.g.
capture_Sparwood_2022 <- envair :: get_captures('PM2.5', 2022)
%>% dplyr::filter(station_name == "Sparwood Centennial Square")

[DonnaHaga]

Thanks @ZoeGao218. I tried the above and got the same error as for #24. envair 0.4.2.100

[GailR]

get_captures() seems to work on v. 0.4.2.422 except for parameter = "pm10"

pm10_capture_2024 <- envair::get_captures(parameter = "pm10", year = 2024)
pm10_capture_2025 <- envair::get_captures(parameter = "pm10", year = 2025)

The error indicates the instrument column is missing but is required for joining purposes. I am able to upload the PM10 dataset and the instrument column is present.

ftp_url <- "ftp://ftp.env.gov.bc.ca/pub/outgoing/AIR/AnnualSummary/2024/binary/PM10.parquet"
temp_file <- tempfile(fileext = ".parquet")
curl::curl_download(ftp_url, temp_file)
pm10_parquet <- arrow::read_parquet(temp_file)

So it must be dropped somewhere during processing. I had a quick look at the code (I'm unfamiliar) and was unable to easily identify the issue but happy to have a closer look if you can point me to the files that are likely to be suspect.

sessionInfo()
R version 4.4.3 (2025-02-28 ucrt)
Platform: x86_64-w64-mingw32/x64
Running under: Windows 10 x64 (build 19045)

Matrix products: default


locale:
[1] LC_COLLATE=English_Canada.utf8  LC_CTYPE=English_Canada.utf8   
[3] LC_MONETARY=English_Canada.utf8 LC_NUMERIC=C                   
[5] LC_TIME=English_Canada.utf8    

time zone: America/Vancouver
tzcode source: internal

attached base packages:
[1] parallel  stats     graphics  grDevices utils     datasets  methods   base     

other attached packages:
[1] stringr_1.5.1   arrow_20.0.0.2  tibble_3.3.0    lubridate_1.9.4 janitor_2.2.1  
[6] tidyr_1.3.1     dplyr_1.1.4    

loaded via a namespace (and not attached):
 [1] vctrs_0.6.5       cli_3.6.5         rlang_1.1.6       stringi_1.8.7    
 [5] purrr_1.1.0       generics_0.1.4    assertthat_0.2.1  glue_1.8.0       
 [9] bit_4.6.0         RCurl_1.98-1.17   readxl_1.4.5      cellranger_1.1.0 
[13] snakecase_0.11.1  bitops_1.0-9      tzdb_0.5.0        lifecycle_1.0.4  
[17] compiler_4.4.3    timechange_0.3.0  pkgconfig_2.0.3   rstudioapi_0.17.1
[21] R6_2.6.1          tidyselect_1.2.1  pillar_1.11.0     curl_6.2.3       
[25] magrittr_2.0.3    withr_3.0.2       tools_4.4.3       bit64_4.6.0-1    
[29] envair_0.4.2.422