The ASRC NYS Atmospheric Chemistry Database
The ASRC NYS Atmospheric Chemistry Database is a PostgreSQL database containing atmospheric chemistry data from ASRC sites in New York State.
nysatmoschem R package provides utilities to reproduce the database, along with functions to generate various reports and processed datasets, and tools to visualize the data.
nysatmoschem builds on the
etl package and follows the
etl syntax and design structure. To reproduce the database, run
etl_create() with a
nysatmoschem dataset object. Users require a username and password to download the data, which can be obtained from the ASRC AQM Data Products page.
library(nysatmoschem) # Create a postgres database connection and nysatmoschem dataset object dbcon = src_postgres(dbname = 'nysacdb', user = 'user') nysac = etl('nysatmoschem', db = dbcon, dir = 'data') # Set up the database and add data from the ASRC's atmoschem server-- # this example collects the campbell datalogger files from the # Whiteface Mountain lodge site nysac %>% etl_create(user = 'user', password = 'pass', sites = 'WFML', data_sources = 'campbell', years = 2018) # Process the Whiteface Mountain lodge campbell data and add the # results to the database nysac %>% update_processing(site = 'WFML', data_source = 'campbell', start_time = '2018-01-01', end_time = '2019-01-01') # View the processing steps in a Shiny app view_processing(nysac)
nysatmoschem from R using the
nysatmoschem is released under the open source MIT license.