-
Notifications
You must be signed in to change notification settings - Fork 33
ws_rpt_inp_node
Daniel Marín edited this page Jul 8, 2026
·
2 revisions
| Column name | Data type | Description | Example |
|---|---|---|---|
| id | serial4 | Id | |
| result_id | varchar(30) | Id of the result | |
| node_id | varchar(16) | Id of node | |
| elevation | numeric(12, 3) | Elevation of the node | |
| elev | numeric(12, 3) | ||
| node_type | varchar(30) | Type of node | |
| nodecat_id | varchar(30) | Id of node catalog, defined on cat_node | |
| epa_type | varchar(16) | Node type related to EPA classification, defined on sys_feature_epa_type | |
| sector_id | int4 | Id of a hydraulic sector, defined on sector | |
| state | smallint | Main state of element, defined on value_state | |
| state_type | smallint | Substate of element, defined on value_state_type | |
| annotation | varchar(254) | Descript | |
| demand | float8 | Demand value assigned to node | |
| the_geom | geometry(Point,SRID) | Point geometry of element | |
| expl_id | integer | Id of an exploitation, defined on exploitation | |
| pattern_id | varchar(16) | Id of pattern assigned to the node | |
| addparam | text | Additional parameters | |
| nodeparent | varchar(16) | Id of nodearc created during model exportation | |
| arcposition | int2 | ||
| dma_id | int4 | Id of a district metering area, defined on dma | |
| presszone_id | text | Presszone id | |
| dqa_id | integer | Id of a quality sector, defined on dqa | |
| minsector_id | integer | Id of a minimum sector | |
| age | int4 | Age of a node |


