Skip to content

cat_grate

advase edited this page Aug 8, 2022 · 2 revisions

Description:

Catalog of grate, which defines its basic characteristics.

Fields:

Column name Data type Description Example
id character varying(30) Id of grate definition BGRT4
matcat_id character varying(16) Id of material defined on cat_mat_grate FD
length numeric(12,4) Length of the gully
width numeric(12,4) Width of the gully
total_area numeric(12,4) Total area of gully
effective_area numeric(12,4) Effective area of water collection
n_barr_l numeric(12,4) Number of vertical bars
n_barr_w numeric(12,4) Number of horizontal bars
n_barr_diag numeric(12,4) Number of diagonal bars
a_param numeric(12,4) Parameter characteristic of the grid and the circulating flow used to calculate the effectiveness of the grate
b_param numeric(12,4) Parameter characteristic of the grid and the circulating flow used to calculate the effectiveness of the grate
descript character varying(255) Description
link character varying(512) Link
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 gully.svg
cost_ut character varying(16) Cost unit
active boolean If true, catalog value is being used TRUE
label character varying(255) Label visualized on QGIS
gully_type text Gully type related to the catalog value, defined on cat_featureand cat_feature_gully
active boolean If true, catalog value is being used TRUE
Clone this wiki locally