ud_inp_orifice - Giswater/giswater_dbmodel GitHub Wiki

Description:

Identifies each orifice of the drainage system.

Fields:

Column name Data type Description Example
arc_id character varying(16) Id of arc
ori_type character varying(18) Type of orifice, defined on inp_typevalue as inp_typevalue_orifice [BOTTOM, SIDE]
offsetval numeric(10,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(10,4) discharge coefficient
orate numeric(10,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(10,4) Geometry of orifice
geom2 numeric(10,4) Geometry of orifice
geom3 numeric(10,4) Geometry of orifice
geom4 numeric(10,4) Geometry of orifice
close_time integer The time it takes to open a closed (or close an open) gated orifice in decimal hours