ud_gully - Giswater/giswater_dbmodel GitHub Wiki
Description:
In case of urbain drainage, data of all gullies of inventory is stored on just one table - gully. Fields of gully table are common for all types of gullies. In case of gullies it's also recommended to use views for inserting, updating and deleting in order to capture default values or draw polygonal geometry of a feature(parent view - ve_gully or child views defined on cat_feature).
Gully fields:
| Column name | Data type | Description |
|---|---|---|
| gully_id | character varying(16) | Id (automatically assigned on insert) |
| code | character varying(30) | Element code from previous system |
| top_elev | numeric(12,4) | Top elevation at which the element is located |
| ymax | numeric(12,4) | Depth of the element |
| sandbox | numeric(12,4) | Elevation of sediment box |
| matcat_id | character varying(18) | Id of material, used in case when material is not specified on gully catalog, defined on cat_mat_gully |
| gully_type | character varying(30) | Gully type, defined on cat_feature_gully |
| gratecat_id | character varying(18) | Id of grate catalog, defined on cat_grate |
| units | smallint | Number of grates |
| groove | boolean | If true, element has groove |
| siphon | boolean | If true, element has siphon |
| connec_arccat_id | character varying(18) | Id of connec catalog, used in order to determine connection type, defined on cat_connec |
| connec_length | numeric(12,3) | Length of the connection with network |
| connec_depth | numeric(12,3) | Depth of the connection with network |
| arc_id | character varying(16) | Id of arc with which element is related |
| sector_id | integer | Id of a hydraulic sector, defined on sector |
| state | smallint | Main state of element, defined on value_state |
| state_type | smallint | Substate of element, defined on value_state_type |
| annotation | text | Description |
| observ | text | Description |
| comment | text | Description |
| dma_id | integer | Id of a district management area, defined on dma |
| soilcat_id | character varying(30) | Soil on which the element is located, defined on cat_soil |
| function_type | character varying(50) | Function of the element, defined on man_type_function |
| category_type | character varying(50) | Function of the element, defined on man_type_category |
| fluid_type | character varying(50) | Function of the element, defined on man_type_fluid |
| location_type | character varying(50) | Function of the element, defined on man_type_location |
| workcat_id | character varying(255) | Work code related to construction of the element, defined on cat_work |
| workcat_id_end | character varying(255) | Work code related to disassemble of the element, defined on cat_work |
| buildercat_id | character varying(30) | Constructor of element, defined on cat_builder |
| builtdate | date | Data of construction |
| enddate | date | Data of disassemble |
| ownercat_id | character varying(30) | Owner of the element, defined on cat_owner |
| muni_id | integer | Municipality in which element is located, defined on ext_municipality |
| postcode | character varying(16) | Postcode of element's location |
| streetaxis_id | character varying(16) | Street in which element is located, defined on ext_streetaxis |
| postnumber | integer | Post number of the element's location, defined on ext_address |
| postcomplement | character varying(100) | Additional number of the element's location |
| streetaxis2_id | character varying(16) | Street in which element is located, defined on ext_streetaxis (used in to define location as from street to street |
| postnumber2 | integer | Post number of the element's location, situated on the second street, defined on ext_address |
| postcomplement2 | character varying(100) | Additional number of the element's location, situated on the second street |
| descript | text | Description |
| link | character varying(512) | Link |
| verified | character varying(20) | Level of data verification, define edit_typevalue (value_verified) |
| rotation | numeric(6,3) | Rotation of element's symbol |
| the_geom | geometry(Point,SRID) | Point geometry of element |
| undelete | boolean | If true, element can't be deleted |
| label_x | character varying(30) | Coordinate x of label location |
| label_y | character varying(30) | Coordinate y of label location |
| label_rotation | numeric(6,3) | Rotation of element's label |
| publish | boolean | If true, element is being published |
| inventory | boolean | If true, element is a part of company's inventory |
| uncertain | boolean | If true, element has data with little reliability |
| expl_id | integer | Id of an exploitation, defined on exploitation |
| num_value | numeric(12,3) | Additional numeric field |
| feature_type | character varying(16) | Type of feature (automatically assigned on insert) |
| tstamp | timestamp without time zone | Date and time of data insert |
| pjoint_type | character varying(16) | Final feature type of element to which gully is related vía links |
| pjoint_id | character varying(16) | Final feature id of element to which gully is related vía links |
| lastupdate | timestamp without time zone | Date and time of last data update |
| lastupdate_user | character varying(50) | User that executed last update |
| insert_user | character varying(50) | User that inserted data |
| district_id | integer | District in which element is located, defined on ext_district |
| asset_id | character varying(50) | Id of a financial asset |
| connec_matcat_id | text | Material of pipe that connects gully with main network pipe |
| connec_y2 | numeric(12,3) | Depth of connection point with main network pipe |
| gratecat2_id | text | Second id of grate catalog, defined on cat_grate |
| epa_type | character varying(16) | Feature type used by the model, non-customizable, defined on sys_feature_epa_type |
| groove_height | double precision | Height of the groove |
| groove_length | double precision | Length of the groove |
| units_placement | character varying(16) | Location of the elements |
| drainzone_id | integer | Id of drainzone |
| expl_id2 | integer | Id of a second exploitation, defined on exploitation |