ud_arc - Giswater/giswater_dbmodel GitHub Wiki
Description:
Data of all arc features of inventory is stored on two main tables - arc and it's corresponing man table (listed below), which depends on feature's definition on cat_feature_node. Fields of arc table are common for all types of arcs. In man table the specific information, related with the most common characteristics of the equipment is stored. Inserting, updating and deleting data using views (parent view - ve_arc or child views defined on cat_feature) automatically performs data procedures on the correct tables and captures default values.
Arc fields:
| Column name | Data type | Description |
|---|---|---|
| arc_id | character varying(16) | Id (automatically assigned on insert) |
| code | text | Element code from previous system |
| node_1 | character varying(16) | Id of arc's initial node |
| node_2 | character varying(16) | Id of arc's final node |
| y1 | numeric(12,3) | Depth of the pipe exit from initial node |
| y2 | numeric(12,3) | Depth of the pipe enter into final node |
| elev1 | numeric(12,3) | Elevation of the pipe exit from initial node |
| elev2 | numeric(12,3) | Elevation of the pipe enter into final node |
| custom_y1 | numeric(12,3) | Personalized depth of the pipe exit from initial node. Prevails in the calculation over value of y1 |
| custom_y2 | numeric(12,3) | Personalized depth of the pipe enter into final node. Prevails in the calculation over value of y2 |
| custom_elev1 | numeric(12,3) | Personalized elevation of the pipe exit from initial node. Prevails in the calculation over value of elev1 |
| custom_elev2 | numeric(12,3) | Personalized elevation of the pipe enter into final node. Prevails in the calculation over value of elev2 |
| sys_elev1 | numeric(12,3) | System elevation of the pipe exit from initial node. Calculated automatically as (top_elev - y1) |
| sys_elev2 | numeric(12,3) | System elevation of the pipe enter into final node. Calculated automatically as (top_elev - y2) |
| arc_type | character varying(18) | Arc type, defined on cat_feature_arc |
| arccat_id | character varying(30) | Id of arccatalog, defined on cat_arc |
| matcat_id | character varying(30) | Id of material, used in case when material is not specified on arc catalog, defined on cat_mat_node |
| epa_type | character varying(16) | Arc type related to EPA classification, defined on sys_feature_epa_type |
| 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 |
| sys_slope | numeric(12,4) | System slope of arc. Calculated automatically |
| inverted_slope | boolean | If true, arc has an inverted slope |
| custom_length | numeric(12,2) | Custom length of an arc |
| dma_id | integer | Id of a district management area, defined on dma |
| soilcat_id | character varying(16) | 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) |
| the_geom | geometry(LineString,SRID) | Line 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 |
| 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 |
| workcat_id_plan | character varying(255) | Description |
| asset_id | character varying(50) | Id of a financial asset |
| pavcat_id | character varying(30) | Pavement catalog |
| drainzone_id | integer | Id of drainzone |
| nodetype_1 | character varying(30) | Node type 1 |
| node_sys_top_elev_1 | numeric(12,3) | Value of the terrain elevation of node 1 |
| node_sys_elev_1 | numeric(12,3) | Value of the water level of node 1 |
| nodetype_2 | character varying(30) | Node type 2 |
| node_sys_top_elev_2 | numeric(12,3) | Value of the terrain elevation of node 2 |
| node_sys_elev_2 | numeric(12,3) | Value of the water level of node 2 |
| expl_id2 | integer | Id of a second exploitation, defined on exploitation |
| adate | text | Description |
| adescript | text | Description |
| visitability | integer | Description |
| label_quadrant | character varying(12) | Description |
| minsector_id | integer | Description |
| macrominsector_id | integer | Description |