Physical model

 

The SIOSE High Resolution (SIOSE AR) physical data model is the structured database representation of its conceptual data model, describing the organization of objects, attributes, relationships, and philosophy of geographic land cover data.

This model is based on a relational structure, where information is stored in geometric and alphanumeric tables interconnected by common key fields.

The High Resolution SIOSE organizes the information into the following main tables:

Geometric tables

  • T_POLIGONOS: Contains polygon geometry with homogeneous land cover information within the same cadastral reference. It is generated by cross-referencing various reference sources.
  • T_USOS: Contains cadastral parcel geometry with land use information and its correspondence with the INSPIRE HILUCS category.
  • T_COMBINADA: Generates land use polygon geometry by combining the T_POLIGONOS and T_USOS tables to represent land cover and the majority or most representative land use.

Alphanumeric tables

  • T_VALORES: Contains detailed thematic information for each land cover, including its occupancy percentage and the area occupied within each polygon.
  • T_USOS_MULTIPLE_AGRUPADOS: Stores detailed thematic information for each land use with its percentage value and area occupied within each cadastral parcel.
  • BLAT TABLE: Represents all possible combinations of land covers, uses, and attributes, with their respective occupancy percentages. For each label, only the fields corresponding to land covers with values other than 0 are filled in, allowing for simple queries but with a loss of structured information compared to the relational model.

Relationships between Tables

  • T_POLYGONS is related one to many (1...*) to T_VALUES using the "ID_POLYGON" field.
  • T_USES is related one to many (1...*) to T_USES_MULTIPLE_GROUPED using the "ID_PARCELA" field.
  • T_USES is related one to many (1...*) to T_POLYGONS using the "ID_PARCELA" field, ensuring a correspondence between the use and the geometry of the plot.

Informative Tables

In addition, reference tables are included for the identification and description of the model elements:

  • LIST_COVERAGES: Contains the identifiers, labels, and descriptions of the SIOSE AR land cover classes.
  • LIST_ATTRIBUTES: Collects the identifiers, labels, and descriptions of the attributes associated with land covers and land uses.
  • LIST_USES: Stores the identifiers, labels, and descriptions of the land use classes, establishing their correspondence with the INSPIRE HILUCS classification.
Physical structure of the SIOSE AR data model

Physical structure of the SIOSE AR data model