marsFetchLevelData: Fetch water level data for an SMP

In taywater/pwdgsi: Philadelphia Water Department Green Stormwater Infrastructure

Fetch water level data for an SMP

Description

Returns a data frame with requested SMP water level data

Usage

marsFetchLevelData(
  con,
  target_id,
  ow_suffix,
  start_date,
  end_date,
  sump_correct
)

Arguments

con	An ODBC connection to the MARS Analysis database returned by odbc::dbConnect
target_id	vector of chr, SMP ID, where the user has requested data
ow_suffix	vector of chr, SMP ID, where the user has requested data
start_date	string, format: "YYYY-MM-DD", start of data request range
end_date	string, format: "YYYY-MM-DD", end of data request range
sump_correct	logical, TRUE if water level should be corrected for to account for sump depth

Value

Output will be a dataframe with the following columns:

ow_leveldata_uid	int
dtime_est	POSIXct datetime
level_ft	num, recorded water level in feet
ow_uid	num, ow_uid derived from smp_id and ow_suffix

See Also

marsFetchRainfallData, marsFetchRainEventData, marsFetchMonitoringData

taywater/pwdgsi documentation built on April 19, 2024, 11:10 a.m.