ud_review_gully - Giswater/giswater_dbmodel GitHub Wiki


Description:

Gully fields:

Column name Data type Description
gully_id character varying(16) Id (automatically assigned on insert)
top_elev numeric(12,4) Top elevation at which the element is located
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
gully_type varchar(30) Gully type, defined on cat_feature_gully
matcat_id varchar(30) Id of material, used in case when material is not specified on gully catalog, defined on cat_mat_gully
gratecat_id varchar(30) Id of grate catalog, defined on cat_grate
sandbox numeric(12,4) Elevation of sediment box
units int2 Number of grates
groove bool If true, element has groove
siphon bool If true, element has siphon
connec_arccat_id varchar(18) Id of connec catalog, used in order to determine connection type, defined on cat_connec
annotation text Description
observ text Description
review_obs text Description
expl_id text Id of an exploitation, defined on exploitation
the_geom public.geometry(point, 25831) Point geometry of element
field_checked bool
is_validated int4 Whether this position has been validated or not
field_date timestamp