msm_HParRDII
tables.auto_generated.msm_HParRDII
Classes
| Name | Description |
|---|---|
| msm_HParRDIITable | Table for msm_HParRDII (Parameters RDI). |
| msm_HParRDIITableColumns | Column names for msm_HParRDII (Parameters RDI). |
msm_HParRDIITable
tables.auto_generated.msm_HParRDII.msm_HParRDIITable(net_table)Table for msm_HParRDII (Parameters RDI).
Attributes
| Name | Description |
|---|---|
| columns | Get the columns for the table. |
| description | Get the table description. |
| display_name | Get the display name for the table. |
| name | Get the table name. |
Methods
| Name | Description |
|---|---|
| delete | Create a DELETE query for this table. |
| get_muids | Get a list of MUIDs for the table. |
| insert | Insert a row with the given values. |
| select | Create a SELECT query for this table. |
| update | Create an UPDATE query for this table. |
delete
tables.auto_generated.msm_HParRDII.msm_HParRDIITable.delete()Create a DELETE query for this table.
Returns
| Name | Type | Description |
|---|---|---|
| DeleteQuery | A new DeleteQuery object |
get_muids
tables.auto_generated.msm_HParRDII.msm_HParRDIITable.get_muids(
order_by=None,
descending=False,
)Get a list of MUIDs for the table.
Parameters
| Name | Type | Description | Default |
|---|---|---|---|
| order_by | str or None | Column to order the MUIDs by | None |
| descending | bool | Whether to order in descending order | False |
Returns
| Name | Type | Description |
|---|---|---|
| list of str | A list of MUIDs |
insert
tables.auto_generated.msm_HParRDII.msm_HParRDIITable.insert(
values,
execute=True,
)Insert a row with the given values.
Parameters
| Name | Type | Description | Default |
|---|---|---|---|
| values | dict of str to Any | Column-value pairs to insert | required |
| execute | bool | Whether to execute the query immediately (default: True) | True |
Returns
| Name | Type | Description |
|---|---|---|
| str or InsertQuery | If execute is True, returns the ID of the newly inserted row (MUID) If execute is False, returns an InsertQuery instance |
select
tables.auto_generated.msm_HParRDII.msm_HParRDIITable.select(columns=[])Create a SELECT query for this table.
Parameters
| Name | Type | Description | Default |
|---|---|---|---|
| columns | list of str | The columns to select | [] |
Returns
| Name | Type | Description |
|---|---|---|
| SelectQuery | A new SelectQuery object |
update
tables.auto_generated.msm_HParRDII.msm_HParRDIITable.update(values)Create an UPDATE query for this table.
Parameters
| Name | Type | Description | Default |
|---|---|---|---|
| values | dict of str to Any | Column-value pairs to set in the UPDATE | required |
Returns
| Name | Type | Description |
|---|---|---|
| UpdateQuery | A new UpdateQuery object |
msm_HParRDIITableColumns
tables.auto_generated.msm_HParRDII.msm_HParRDIITableColumns(table)Column names for msm_HParRDII (Parameters RDI).
Attributes
| Name | Description |
|---|---|
| AbstractionSourceTypeNo | Pumped depth defined as |
| AbstractionTypeNo | Use abstraction |
| CKLow | TC for routing lower baseflow (CKLow) [h] |
| CQLow | Recharge to groundwater (CQLow) [%] |
| Chainage | Chainage [m] |
| Ck | TC for routing overland flow (CK1,2)/(CK) [h] |
| Ck2 | TC2 overland flow value (CK2) [h] |
| Ck2TypeNo | TC2 for routing overland flow (CK2) |
| Ckbf | TC for baseflow (CKBF) [h] |
| Ckif | TC for interflow (CKIF) [h] |
| CorrectDryTempCorrection | Dry temperature correction [deg C/100m] |
| CorrectDryTempNo | Correct temperature in dry condition |
| CorrectPrecCorrection | Precipitation correction [%/100m] |
| CorrectPrecNo | Correct precipitation rate |
| CorrectWetTempCorrection | Wet temperature correction [deg C/100m] |
| CorrectWetTempNo | Correct temperature in wet condition |
| Cqof | Overland runoff coefficient (CQOF) [()] |
| ElevZonesNo | Delineate catchment into elevation zones for snow modelling |
| GWLBFMin | Min. GW depth for seasonal variation (GWLBF_min) [m] |
| GWLbf0 | Max. groundwater depth causing baseflow (GWLbf0) [m] |
| GWLfl1 | Groundwater depth for unit capillary flux (GWLfl1) [m] |
| GWSeasonTypeNo | Seasonal variation of groundwater depth causing baseflow |
| GwCarea | Groundwater/catchment area ratio (Carea) [()] |
| GwLmin | Min. groundwater depth below surface (GWLmin) [m] |
| GwSy | Specific yield of groundwater reservoir (Sy) [()] |
| IncludeIrrigationNo | Include Irrigation |
| IncludeSeasonalVarNo | Include seasonal variation of crop coefficients and operational losses |
| InitBF | Baseflow (BF) [m^3/s] |
| InitBFLow | Lower baseflow (BF-low) [m^3/s] |
| InitGwl | Groundwater depth (GWL) [m] |
| InitIf | Interflow (QIF) [mm/h] |
| InitL | Root zone storage (L) [mm] |
| InitOf | Overland flow (QOF) [mm/h] |
| InitU | Surface storage (U) [mm] |
| K0inf | Infiltration rate at field capacity (K0inf) [mm/h] |
| Lmax | Max. content in root zone storage (Lmax) [mm] |
| LowerBFTypeNo | Use lower baseflow |
| MUID | ID |
| ObjFuncInitDaysExcluded | Initial number of days excluded |
| ObjFuncLowflow | Low flow [m^3/s] |
| ObjFuncLowflowNo | Low flow RMSE |
| ObjFuncMaxEvaluation | Maximum number of evaluations |
| ObjFuncPeakflow | Peak flow [m^3/s] |
| ObjFuncPeakflowNo | Peak flow RMSE |
| ObjFuncRmsErrorNo | Overall root mean square error |
| ObjFuncWaterBalanceNo | Overall water balance |
| PCexr | External river (PCexr) [%] |
| PClgw | Local groundwater (PClgw) [%] |
| PClr | Local river (PClr) [%] |
| PrecStationElev | Reference elevation for precipitation station [m] |
| RadiationCoef | Radiation coefficient [()] |
| RadiationTypeNo | Use solar radiation |
| RainfallCoef | Rainfall degree-day coefficient (Crain) [/deg C/d] |
| RainfallCoefTypeNo | Use rainfall heat transfer |
| RiverID | River ID |
| SnowStorage | Snow storage [mm] |
| SnowmeltC | Degree-day coefficient (Csnow) [mm/deg C/d] |
| SnowmeltCTypeNo | Degree-day coefficient type |
| SnowmeltNo | Include snowmelt |
| T0 | Base temperature (T0) [deg C] |
| TempStationElev | Reference elevation for temperature station [m] |
| Tg | Root zone fraction for groundwater recharge (TG) [()] |
| Tif | Root zone fraction for interflow (TIF) [()] |
| Tof | Root zone fraction for overland flow (TOF) [()] |
| Umax | Max. content in surface storage (Umax) [mm] |