Queries

 

Queries can be made on geometries (SIOSE or SIOSE AR polygons) or on the roofs and uses of interest (from alphanumeric tables), with the selection subsequently transmitting the polygons that meet the criteria of the queries made.

  • Queries on polygons [T_POLIGONOS], [T_USOS] or [T_COMBINADA]: In a Geographic Information System (GIS), the polygons that interest us (by surface, location, fields, etc.) are selected in the attribute table [T_POLIGONOS], [T_USOS] or [T_COMBINADA]. SIOSE AR has the possibility of selecting by majority fields of covers and uses within each polygon. To know auxiliary information corresponding to the covers [T_POLIGONOS], their corresponding records are searched in the cover table [T_VALORES] using the common field ID_POLYGON. To do this, both tables must be previously related with a 1:N relationship, because for each SIOSE polygon there is more than one record in the [T_VALORES] table that describes its content. In SIOSE or SIOSE AR, unions/joins are not usually performed between the two tables in order not to lose information, since as a result of this operation only one record of [T_VALUES] would be obtained for each record of [T_POLYGONS], type 1:1.
  • Detailed queries on roofs or uses: Queries are made on the roof table [T_VALORES] using a GIS or database management software (Access, Oracle, etc.), the result of the query being a selection from [T_VALORES] or a new table. To view the result of the query of the SIOSE polygons in a GIS, the result of the query on [T_VALORES] must first be related to [T_POLIGONOS] using the common field ID_POLYGON. For uses, the same procedure would be followed, but working with the alphanumeric table [T_USOS_MULTIPLE_AGRUPADOS] and the geometric table of [T_USOS].
  • Statistical queries: By selecting the different coverages in the [T_VALORES] or [T_USOS_MULTIPLE_AGRUPADOS] table, you can obtain statistical calculations relating them to the T_POLIGONOS or T_USOS table. Some examples are shown below.
Woody crops and meadows Percentage of trees Type of building Crop irrigation

Additionally, to facilitate user queries of SIOSE tables, a plugin for QGIS software called SIOSE Tools has been developed. Learn more here.