Physical Model

SIOSE AR Physical Model

It is the database organisation of its conceptual data model, which describes the objects, attributes, relationships, consistency rules, structure and philosophy of geographic data on SIOSE AR land occupation.

This physical model is based on the organisation in fields and tables of the database. The information is stored in different geometric and alphanumeric tables related to each other by common key fields.

The basic structure of SIOSE High Resolution is organised in the following tables:

• T_POLYGONS: geometry of polygons with homogeneous land cover information within the same cadastral reference, resulting from the cross-referencing of the different reference sources used.
• T_USES: geometry of cadastral parcels with land use information and its corresponding category in INSPIRE (HILUCS).
• T_COMBINED: geometry of polygons of land occupation by majority or most representative land cover and use, combining both previous tables.

An alphanumeric table is included:

• T_VALUES: detailed thematic information for each land cover with its percentage value and area of cover within each polygon.
• T_MULTIPLE_USES_GROUPED: detailed thematic information of each type of land use with its percentage value and area of cover within each cadastral parcel.
• FLAT TABLE: represents all land covers, uses and attributes; with their combinations. In such a way that for each label only the corresponding cover fields are filled in with their percentage of cover, leaving the rest of the fields with a value of "0". It allows for simple queries, but this form of storage entails a loss of information.

The relationships between tables are:

• T_POLYGONS is related one to many (1...*) with T_VALUES by means of the common polygon identifier field ("ID_POLYGON").
• T_USES is related one-to-many (1...*) to T_USES_MULTIPLE_GROUPED via the common parcel identifier field ("PARCEL_ID").
• T_USES is related one-to-many (1...*) to T_POLYGONS via the common parcel identifier field ("PARCEL_ID").

In addition, the informative tables are included:

• LIST_COVERS: identifiers, labels and description of the SIOSE AR covers.
• LIST_ATTRIBUTES: identifiers, labels and description of the SIOSE AR attributes.
• LIST_USES: identifiers, labels and description of the SIOSE AR uses with their correspondence with the HILUCS class.

SIOSE Physical Model

It is mainly structured in two main tables (versions 2005-2014):

• [T_POLYGONS] stores the geometry of the polygon representing homogeneous land occupation environments.
• [T_VALUES] stores the cover and use information of the previous polygons.
• [FLAT TABLE] represents all the covers, uses, their combinations, and any other with their attributes, in such a way that for each SIOSE label only the corresponding cover fields are filled in with their percentage of occupation, leaving the rest of the fields with a value of "0". It allows for simple queries, but this form of storage entails a loss of information.

[T_POLYGONS] and [T_VALUES] are related through the field common to both tables POLYGON_ID, which is the unique identifier of the polygon in the database.

In addition there are four descriptive tables for land cover [TC_SIOSE_COVERTURES], attributes [TC_SIOSE_ATRIBUTES], CODIIGE information [TC_SIOSE_CODIIGE], and HILUCS information [TC_SIOSE_HILUCS].

The structure of the SIOSE database is described in detail in the technical documentation of the project, under "Documentation" .