Skip to content

ud_gully

advase edited this page Apr 25, 2023 · 7 revisions

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
Clone this wiki locally