marsWriteInfiltrationData: Write Infiltration Performance Data to Database

In taywater/pwdgsi: Philadelphia Water Department Green Stormwater Infrastructure

Write Infiltration Performance Data to Database

Description

Receive vectors of infiltration rate and infiltration baseline data calculated with marsInfiltrationRate_inhr, gather data, and write to MARS Analysis Database performance_infiltration table. Replaces error codes with NAs and moves them to a separate column, error_lookup_uid.

Usage

marsWriteInfiltrationData(
  con,
  infiltration_rate_inhr,
  baseline_ft = NA,
  ow_uid,
  radar_event_uid,
  snapshot_uid,
  observed_simulated_lookup_uid
)

Arguments

con	Formal class PostgreSQL, a connection to the MARS Analysis database
infiltration_rate_inhr	vector, numeric, infiltration rate (in/hr)
baseline_ft	vector, numeric, point that water level returns to at the end of an event (default ??)
ow_uid	vector, numeric observation well UID
radar_event_uid	vector, numeric event UIDs for rain events from radar data
snapshot_uid	vector, numeric
observed_simulated_lookup_uid	vector, numeric, 1 if observed, 2 if simulated

Value

TRUE if the write is succesful, or an error message if unsuccessful

See Also

marsWriteOvertoppingData, marsWritePercentStorageData

Examples

marsWriteInfiltrationData(con = mars, 
  infiltration_rate_inhr = summary_250$infiltration_rate_inhr,
  ow_uid = summary_250$ow_uid,
  radar_event_uid = summary_250$rainfall_gage_event_uid,
  snapshot_uid = summary_250$snapshot_uid,
  observed_simulated_lookup_uid = summary_250$observed_simulated_lookup_uid)

taywater/pwdgsi documentation built on June 14, 2025, 9 p.m.