ud_cat_node - Giswater/giswater_dbmodel GitHub Wiki
Description:
Catalog of nodes, which defines its basic characteristics.
Fields:
| Column name | Data type | Description | Example |
|---|---|---|---|
| id | character varying(30) | Id of node definition | C_MANHOLE_80 |
| matcat_id | character varying(16) | Id of material defined on cat_mat_node | FD |
| shape | character varying(50) | Shape of node, defined on [cat_node_shape](https://github.com/Giswater/giswater_dbmodel/wiki/cat_node_shape | CIRCULAR |
| geom1 | numeric(12,4) | Internal vertical dimension of the element, expressed in meters. In case of circular nodes- value of the interior diameter. | |
| geom2 | numeric(12,4) | Internal horizontal dimension of the element, expressed in meters | |
| geom3 | numeric(12,4) | Internal dimension of the element, expressed in meters | |
| value | numeric(12,2) | ||
| descript | character varying(255) | Description | Air valve 50mm |
| link | character varying(30) | Link | c:\users\users\catalog.pdf |
| brand | character varying(30) | Brand defined on cat_brand | |
| model | character varying(30) | Model defined on cat_brand_model | |
| svg | character varying(50) | Svg visualized on QGIS | junction.svg |
| estimated_y | numeric(12,2) | Estimated depth used for budget calculation if depth data is missing (m) | 1.00 |
| cost_unit | character varying(3) | Measurement units | u |
| cost | character varying(30) | Price of the node, related with price defined on plan_price | N_C_MANHOLE_80 |
| active boolean | If true, catalog value is being used | TRUE |
|
| label | character varying(255) | Label visualized on QGIS | |
| node_type | text | Node type related to the catalog value, defined on cat_feature cat_feature and cat_feature_node | CIRC_MANHOLE |
| acoeff | double precision | Coefficient for calculating the replacement value |