polygon - Giswater/giswater_dbmodel GitHub Wiki


Description:

Fields:

Column name Data type Description Example
pol_id varchar(16) Id of polygon with which element is related (second geometry)
sys_type varchar(30) To be related with sys_feature_cat values
text text Optional field for any polygon annotations
the_geom public.geometry(multipolygon, 25831) Multi polygon geometry of element
undelete bool If true, zone can't be deleted TRUE
tstamp Timestamp without time zone Date and time of data insert 2021-02-22 14:03:49.032874
featurecat_id varchar(50) List of featurecats to which value is related, defined on cat_feature {CIRC_MANHOLE, VALVE}
feature_id varchar(16) Id of feature
state int2 Main state of element