ws_rpt_inp_arc
| Column name | Data type | Description | Example |
|---|---|---|---|
| id | serial4 | Id | |
| result_id | varchar(30) | Id result | |
| arc_id | varchar(16) | Id of arc | |
| node_1 | varchar(16) | Id of arc's initial node | |
| node_2 | varchar(16) | Id of arc's final node | |
| arc_type | varchar(30) | Id of arc type | |
| arccat_id | varchar(30) | Id of arc catalog, defined on cat_arc | |
| epa_type | varchar(16) | Arc type related to EPA classification, defined on sys_feature_epa_type | |
| sector_id | int4 | Id of a hydraulic sector, defined on sector | |
| state | int2 | Main state of element, defined on value_state | |
| state_type | int2 | Substate of element, defined on value_state_type | |
| annotation | varchar(254) | Description | |
| diameter | numeric(12, 3) | Diameter of a pipe | |
| roughness | numeric(12, 6) | Roughness value | |
| length | numeric(12, 3) | Length of the pipe | |
| status | varchar(18) | Status of pipe, defined on inp_typevalue as inp_value_status_pipe | |
| the_geom | (linestring, 25831) | Line geometry of element | |
| expl_id | int4 | Id of an exploitation, defined on exploitation | |
| flw_code | text | ||
| minorloss | numeric(12, 6) | Value of minorloss | |
| addparam | text | Additional parameters | |
| arcparent | varchar(16) | ||
| dma_id | int4 | Id of a district metering area, defined on dma | |
| presszone_id | text | Id of a pressure zone, defined on presszone | |
| dqa_id | int4 | Id of a quality sector, defined on dqa | |
| minsector_id | int4 | Id of a minimum sector | |
| age | int4 | Age of a pipe | |
| culvert | character varying(10) |
