cat_arc - Giswater/giswater_dbmodel GitHub Wiki
Description:
Catalog of arcs, which defines its basic characteristics.
Fields:
| Column name | Data type | Description | Example |
|---|---|---|---|
| id | character varying(30) | Id of arc definition | FC110-PN10 |
| arctype_id | character varying(30) | Arc type related to the catalog value, defined on cat_feature and cat_feature_arc | PIPE |
| matcat_id | character varying(30) | Id of material defined on cat_material | FC |
| pnom | character varying(16) | Nominal pressure | 10 |
| dnom | character varying(16) | Nominal diameter | 110 |
| dint | numeric(12,5) | Interior diameter | 99.00000 |
| dext | numeric(12,5) | Exterior diameter | 110.00000 |
| descript | character varying(512) | Description | FC pipe |
| link | character varying(512) | 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 | fc110_pn10.svg |
| z1 | numeric(12,2) | Material thickness, distance from hearth to the bottom of the conduit (m) | 0.10 |
| z2 | numeric(12,2) | Material thickness, distance from part upper duct to filling with material from the excavation (m) | 0.10 |
| width | numeric(12,2) | Total width. Width + bulk*2 (m) | 0.11 |
| area | numeric(12,4) | Area (m2) | 0.0095 |
| estimated_depth | numeric(12,2) | Estimated depth used for budget calculation if depth data is missing (m) | 0.96 |
| bulk | numeric(12,2) | Thickness of the conduit’s wall (UD (m) WS (mm)) | 5.50 |
| cost_unit | character varying(3) | Measurement units | m |
| cost | character varying(16) | Price of the arc, related with price defined on plan_price | A_FC110_PN10 |
| m2bottom_cost | character varying(16) | Price of the type of soil, related with price defined on plan_price | S_REP |
| m3protec_cost | timestamp(16) | Price of protection, related with price defined on plan_price | S_NULL |
| active | boolean | If true, catalog value is being used | TRUE |
| label | character varying(255) | Label visualized on QGIS | |
| shape | character varying(30) | Shape of arc, defined on cat_arc_shape | CIRCULAR |
| acoeff | double precision | Coefficient for calculating the replacement value | |
| connect_cost | text | Price of water connections on pipes, related with price defined on plan_price. Giswater will calculate how many relations a pipe has and add its cost to total price of pipe |