cat_element - Giswater/giswater_dbmodel GitHub Wiki


Description:

Fields:

Column name Data type Description Example
id character varying(30) Id of element definition COVER_FD60
elementtype_id character varying(30) Element type related to the catalog value, defined on element_type COVER
matcat_id character varying(30) Id of material defined on cat_mat_element FD
geometry character varying(30) Description of the elemnt's geometry 60 cm
descript character varying(512) Description Cover fd
link character varying(512) Link c:\\users\users\catalog.pdf
brand character varying(30) Brand defined on cat_brand
type character varying(30) Type of the element
model character varying(30) Model defined on cat_brand_model
svg character varying(50) Svg visualized on QGIS cover_fd.svg
active boolean If true, catalog value is being used TRUE
geom1 numeric(12,3) Numeric value of element's geometry
geom2 numeric(12,3) Numeric value of element's geometry
isdoublegeom boolean If true, polygon geometry is automatically generated FALSE