ud_inp_flwreg_orifice - Giswater/giswater_dbmodel GitHub Wiki
Description:
Identifies each orifice of the drainage system, which acts as flow regulator.
Fields:
| Column name | Data type | Description | Domain values |
|---|---|---|---|
| id | serial | Id | |
| node_id | character varying(16) | Id of node | |
| to_arc | character varying(16) | Id of arc that indicates flow direction | |
| order_id | smallint | Id of flow regulator | |
| flwreg_length | double precision | Length of flow regulator | |
| ori_type | character varying(18) | Type of orifice, defined on inp_typevalue as inp_typevalue_orifice | [BOTTOM, SIDE] |
| offsetval | numeric(12,4) | Amount that a Side Orifice’s bottom or the position of a Bottom Orifice is offset above the invert of inlet node | |
| cd | numeric(12,4) | Discharge coefficient | |
| orate | numeric(12,4) | Time in decimal hours to open a fully closed orifice | |
| flap | character varying(3) | YES if flap gate present to prevent reverse flow, NO if not | [YES, NO] |
| shape | character varying(18) | Shape of orifice, defined on inp_typevalue as inp_value_orifice | [CIRCULAR, RECT-CLOSED] |
| geom1 | numeric(12,4) | Geometry of orifice | |
| geom2 | numeric(12,4) | Geometry of orifice | |
| geom3 | numeric(12,4) | Geometry of orifice | |
| geom4 | numeric(12,4) | Geometry of orifice | |
| close_time | integer | The time it takes to open a closed (or close an open) gated orifice in | |
| nodarc_id | varchar(20) | Id of nodarc |