-
Notifications
You must be signed in to change notification settings - Fork 10
ud_rpt_inp_arc
advase edited this page Oct 27, 2022
·
10 revisions
Column name | Data type | Description | Example |
---|---|---|---|
id | serial4 | Id | |
result_id | varchar(30) | Id result | |
arc_id | varchar(16) | Arc Id | |
node_1 | varchar(16) | Id of arc's initial node | |
node_2 | varchar(16) | Id of arc's final node | |
elevmax1 | numeric(12, 3) | ||
elevmax2 | numeric(12, 3) | ||
arc_type | varchar(30) | Type of arc | |
arccat_id | varchar(30) | Id of arc catalog | |
epa_type | varchar(16) | Node type related to EPA classification, defined on sys_feature_epa_type | |
sector_id | int4 | Id of a hydraulic sector | |
state | int2 | Main state of element | |
state_type | int2 | Substate of element, defined on value_state_type | |
annotation | varchar(254) | Description | |
length | numeric(12, 3) | Length of arc | |
n | numeric(12, 3) | ||
the_geom | public.geometry(linestring, 25831) | Line geometry of element | |
expl_id | int4 | Id of an exploitation | |
addparam | text | Additional parameters | |
arcparent | varchar(16) | ||
q0 | float8 | Flow in conduit at start of simulation | |
qmax | float8 | Maximum flow allowed in the arc | |
barrels | int4 | Number of barrels associated with an arc | |
slope | float8 | ||
culvert | varchar(10) | Code number for the arc’s inlet geometry if it is an arc subject to possible inlet flow control | |
kentry | numeric(12, 4) | Entrance minor head loss coefficient | |
kexit | numeric(12, 4) | Exit minor head loss coefficient | |
kavg | numeric(12, 4) | Average minor head loss coefficient across length of the arc | |
flap | varchar(3) | YES if arc has a flap valve that prevents back flow, NO otherwise. | [YES, NO] |
seepage | numeric(12, 4) | Seepage losses for arcs | |
age | int4 | ||
flw_code | isUtils | ||
dma_id | integer | Id of DMA |