cat_soil - Giswater/giswater_dbmodel GitHub Wiki
Description:
Catalog of soils. Important to calculate price of network elements.
Fields:
| Column name | Data type | Description | Example |
|---|---|---|---|
| id | character varying(30) | Id | soil1 |
| descript | character varying(512) | Description | soil 1 |
| link | character varying(512) | Link | |
| y_param | numeric(5,2) | Inclination of the slope of the trench | 7.00 |
| b | numeric(5,2) | Distance between the Conduit and the trench limit (m) | 0.25 |
| trenchlining | numeric(3,2) | Percentage of intivation of the soil type (%) | 0.60 |
| m3exc_cost | character varying(16) | Excavation price, related with price defined on plan_price | S_EXC |
| m3fill_cost | character varying(16) | Filling price, related with price defined on plan_price | S_REB |
| m3excess_cost | character varying(16) | Excess transportation price, related with price defined on plan_price | S_TRANS |
| m2trenchl_cost | character varying(16) | Intivation price, related with price defined on plan_price | S_TRENCH |
| active | boolean | If true, catalog value is being used |