rems 0.8.1

The updates in this release were mainly due to changes in duckdb package version 0.8.1 that created errors in downloading and connecting to the historic database issue #79, big thanks to @ateucher!
Other changes:

• Additional options were added for updating all dataset versions (#67, #68, #69) - @ateucher, @aylapear
• Removed capability to register/convert some units due to a bug in the C library underlying the units package (r-quantities/units#301). (#70) - @ateucher
• Added temporary warning message to connect_historic_db() to inform users of outstanding issue #79. Message will be removed in the next duckdb release.

rems 0.8.0

Updates in this release speed up database creation (due to a switch from a sqlite backend to a new database called duckdb) and fix the error users were getting due to the vroom package. The new db system works better with the daily updates of the historic data on DataBC.

rems 0.7.0

• Added new helper function standardize_mdl_units() to detect when MDL_UNIT and UNIT are different, and convert METHOD_DETECTION_LIMIT to the same unit as RESULT (and update the MDL_UNIT column accordingly). (bcgov/wqbc#158, #57)
• Added new helper function lt_lake_req() that returns the requisition IDs of lakes in the B.C. long-term lakes monitoring program. To compliment this, filter_ems_data() now has a req_id argument that takes a vector of requisition ids (which can be supplied by lt_lake_req()). #60, @KarHarker
• lt_lake_sites() now only returns EMS IDs for active sites in the B.C. long-term lakes monitoring program. #60, @KarHarker
• Fixed a bug where the entire data cache was deleted when the historic data were updated. #62, #63

rems v0.6.1

rems 0.6.1

Bug fixes

• Fixed a bug where read_historic_data() was looking for the date of the latest historic data on GitHub (#56)

rems 0.6.0

Historic data are now being updated daily in the BC Data Catalogue. This release allows the daily
update of the sqlite historic dataset in rems, but it means that it must be recreated each time from the csv, which takes a while.

Breaking changes:

• When using attach_historic_data(), it is now necessary to call connect_historic_db() first, and finish with disconnect_historic_db(). For example:

con <- connect_historic_db()
hist_tbl <- attach_historic_data(con)

hist_tbl %>%
  select(EMS_ID, PARAMETER, COLLECTION_START, RESULT) %>%
  filter(EMS_ID == "0121580", PARAMETER == "Aluminum Total") %>%
  collect() %>%
  mutate(COLLECTION_START = ems_posix_numeric(COLLECTION_START))

disconnect_historic_db(con)

Miscellaneous fixes

• Fix issue downloading 2yr and 4yr data when both zip files and uncompressed csv files are available (e.g., bcgov/shinyrems#122).

rems v0.5.2

rems 0.5.2

• removed internal use of filter_ to avoid dplyr deprecation warnings. (#48)

rems v0.5.1

• Fixed bug where currency of the historic sqlite database was checked against the wrong date
• filter_ems_data can now take many more forms of date-like inputs for from_date and to_date (Date, POSIXct, POSIXlt, character, numeric; #42)
• Added some (mainly internal) functionality to support development of the shinyrems package (#43).

rems v0.5.0

rems 0.5.0

• The historic sqlite database is now available as a direct download from a rems
  release on GitHub, which should be much faster and more reliable for the user.
• User can now specify/customize the location of the sqlite database via an
  option rems.historic.path. This is best set in your .Rprofile file as
  options(rems.historic.path = "path_to_file")

rems v0.4.2

• Added new MDL_UNIT column to denote the units of the minimum detection limit.

rems v0.4.1

• Added data dictionaries (lookup tables for parameters, sample classes, units, etc)
• Added dont_update argument to get_ems_data() and download_historic_data() to
  bypass the check to update data (#21).
• Added lt_lake_sites() function to get the EMS_IDs of all of the long-term lake monitoring sites (ac34dbd)
• Added check_only argument (default FALSE) to get_ems_data() to allow just checking the currency
  of a rems dataset (#35 @sebdalgarno)
• Added check_db argument (default TRUE) to read_historic_data() so that
  a user can skip checking the currency of the historic dataset (#35 @sebdalgarno)