Physical model

 

The SIOSE (2005-2014) data model is organized into two main tables, which store geometric and thematic information, and a flat table designed for easy querying.

  • [T_POLIGONOS]: Contains the geometry of the polygons, representing homogeneous land use units.
  • [T_VALORES]: Stores thematic information on the land cover and uses of the polygons defined in [T_POLIGONOS].
  • [FLAT TABLE]: Contains all possible combinations of land cover and uses, along with their attributes. For each SIOSE label, only the land cover fields are filled in with their land use percentage, while fields without information are filled in with the value "0". Its simplified structure facilitates quick queries, although it entails a loss of structural information compared to the relational model.

The [T_POLIGONOS] and [T_VALORES] tables are related by the common field "ID_POLYGON", which acts as the unique identifier of the polygon in the database.

Physical structure of the SIOSE data model

Physical structure of the SIOSE data model

Tables T_POLIGONOS and T_VALORES

Fields of the tables T_POLIGONOS and T_VALORES