cat_grate - Giswater/giswater_dbmodel GitHub Wiki
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 |