Skip to content

ud_cat_node

Edgar Fuste edited this page Nov 2, 2021 · 1 revision

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
Clone this wiki locally