marsWriteOvertoppingData: Write Overtopping Data to Database

In taywater/pwdgsi: Philadelphia Water Department Green Stormwater Infrastructure

Write Overtopping Data to Database

Description

Receive vector of overtopping data, calculated with marsOvertoppingCheck_bool, and write to MARS Analysis Database performance_overtopping table

Usage

marsWriteOvertoppingData(
  con,
  overtopping,
  observed_simulated_lookup_uid,
  ow_uid,
  radar_event_uid,
  snapshot_uid
)

Arguments

con	Formal class PostgreSQL, a connection to the MARS Analysis database
overtopping	vector, logical, TRUE if water level reaches max storage depth
observed_simulated_lookup_uid	vector, numeric, 1 if observed, 2 if simulated
ow_uid	vector, numeric observation well UID
radar_event_uid	vector, numeric event UIDs for rain events from radar data
snapshot_uid	vector, numeric

Value

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

See Also

marsWritePercentStorageData, marsWriteDraindownData

Examples

marsWriteOvertoppingData(con = mars, 
  overtopping = summary_250$overtop, 
  observed_simulated_lookup_uid = summary_250$observed_simulated_lookup_uid, 
  ow_uid = summary_250$ow_uid, 
  radar_event_uid = summary_250$rainfall_gage_event_uid,
  snapshot_uid = summary_250$snapshot_uid)

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