water-temp-bc

The goal of water-temp-bc is to document and serve out water temperature data.

[1] 0

tab <- DBI::dbGetQuery(con, "
  SELECT *
  FROM 's3://water-temp-bc/data/realtime_raw.parquet'
  WHERE STATION_NUMBER IN ('07EA004')
    AND Code = 'TW' 
    LIMIT 10
")

Example of output generated by querying parquet file stored on AWS s3. NOTE: To view all columns in the table - please click on one of the sort arrows within column headers before scrolling to the right.

Here we grab the information about the stations (including locations and date range available).

tab <- DBI::dbGetQuery(
  con, 
  "SELECT *
  FROM 's3://water-temp-bc/data/stations_realtime.parquet'"
)

Realtime station information stored on AWS s3. NOTE: To view all columns in the table - please click on one of the sort arrows within column headers before scrolling to the right.