| 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) |
|
|