oceo_table_process: Renaming functions

In smwoodman/amlrOceo: Analyze and visualize data from the AMLR_OCEO database

Description

Functions that rename columns in data frames extracted from data frames int eh AMLR_OCEO database

Usage

oceo_amlr_station_header(x)

oceo_net_station_header(x)

oceo_net(x)

oceo_tucker_header_data(x)

Arguments

x	data frame, a table from the AMLR_OCEO database

Details

The AMLR_OCEO database has a number of views, stored procedures, and other items that make it difficult to change the names of fields in the table. Thus, the purpose of these functions is to have a single place where the columns are renamed to something more consistent and R-friendly. These functions also make it so that only one place needs to be changed if the table column names do change.

Value

The data frame x, with columns processed as described below:

1. oceo_amlr_station_header. Output column names: amlr_station_header_id, cruise_station, cruise, station, leg, ship, area, bottom_depth, created_dt, ice, restrictedUse, gssmu

2. oce_net_station_header. time_local is converted to a factor, and date_tow is converted to a Date object. Output column names: tbd

Examples

## Not run: 
  tbl(con, "table_name") %>% 
    collect() %>%
    oceo_process_amlr_station_header()

## End(Not run)

smwoodman/amlrOceo documentation built on Dec. 23, 2021, 3:27 a.m.