-
Notifications
You must be signed in to change notification settings - Fork 10
ud_audit_psector_gully_traceability
advase edited this page May 31, 2023
·
4 revisions
Column name | Data type | Description |
---|---|---|
id | character serial4 | Id |
psector_id | int4 | Id of planification sector |
psector_state | int2 | State of psector |
doable | bool | If true, feature value enters into calculation of psector budget |
psector_arc_id | varchar(16) | |
link_id | int4 | Id of link |
link_the_geom | int4 | |
audit_tstamp | timestamp | Date and time of audit data insert |
audit_user | text | |
action | varchar(16) | |
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] |
workcat_id_plan | int4 | |
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 |