Table of areas enclosing multiple continous landslide phenomenon. This table should be replaced by the local inventory of landslide phenomena of the geographical survey region.
| Indexes | Field Name | Data Type | Description |
|---|---|---|---|
| PK_UID | integer | Autoincremental integer value as Primary Key | |
| IDFRANA | integer | Landslide identification code | |
| TIPO_MOV | integer | Integer code to define the Landslide kinematic type | |
| Geometry | multipolygon | Geometry data type field | |
| Indexes | |||
| pk_IFFI_aree | ON PK_UID | ||
Table of Italian 'Deep-seated gravitational slope deformations? (DGPV: Italian acronym).
| Indexes | Field Name | Data Type | Description |
|---|---|---|---|
| PK_UID | integer | Autoincremental integer value as Primary Key | |
| IDFRANA | integer | Landslide identification code | |
| TIPO_MOV | integer | Integer code to define the Landslide kinematic type | |
| Geometry | multipolygon | Geometry data type field | |
| Indexes | |||
| pk_IFFI_dgpv | ON PK_UID | ||
Table of 'polygonal landslides'. These are landslides of polygonal geometry at the field survey scale as required by the Italian landslide inventory (IFFI). This table should be replaced by the local inventory of landslide phenomena of the geographical survey region.
| Indexes | Field Name | Data Type | Description |
|---|---|---|---|
| PK_UID | integer | Autoincremental integer value as Primary Key | |
| IDFRANA | integer | Landslide identification code | |
| TIPO_MOV | integer | Integer code to define the Landslide kinematic type | |
| TIPO_POL | integer | ||
| Geometry | multipolygon | Geometry data type field | |
| Indexes | |||
| pk_IFFI_frane | ON PK_UID | ||
Table of 'linear landslides'. These are landslides of linear geometry at the field survey scale as required by the Italian landslide inventory (IFFI). This table should be replaced by the local inventory of landslide phenomena of the geographical survey region.
| Indexes | Field Name | Data Type | Description |
|---|---|---|---|
| PK_UID | integer | Autoincremental integer value as Primary Key | |
| IDFRANA | integer | Landslide identification code | |
| Geometry | multilinestring | Geometry data type field | |
| Indexes | |||
| pk_IFFI_lineari | ON PK_UID | ||
Table of 'landslide event identification point' (PIFF: italian acronym). This table should be replaced by the local inventory of landslide phenomena of the geographical survey region.
| Indexes | Field Name | Data Type | Description |
|---|---|---|---|
| PK_UID | integer | Autoincremental integer value as Primary Key | |
| IDFRANA | integer | Landslide identification code | |
| PUNTI | integer | Boolean value defining if landslide is represented by point geometry according to the IFFI project field survey criteria | |
| LINEE | integer | Boolean value defining if landslide is represented by polyline geometry according to the IFFI project field survey criteria | |
| POLIGONI | integer | Boolean value defining if landslide is represented by polygon geometry according to the IFFI project field survey criteria | |
| REGIONE | text( 2000000000 ) | Name of italian Region where landslide occurred | |
| TIPOLOGIA | text( 2000000000 ) | Landslide kinematic type | |
| DESCRIZION | text( 2000000000 ) | Adjective defining the landslide state of activity | |
| COD_STATO | text( 2000000000 ) | ||
| FOTOINTERP | text( 2000000000 ) | ||
| RILEVAMENT | text( 2000000000 ) | ||
| MONITORAGG | text( 2000000000 ) | ||
| ARCHIVIO | text( 2000000000 ) | ||
| SEGNALAZIO | text( 2000000000 ) | ||
| METODO_FIN | text( 2000000000 ) | ||
| TIPO_MOV | integer | Integer code to define the Landslide kinematic type | |
| Geometry | point | Geometry data type field | |
| Indexes | |||
| pk_IFFI_piff | ON PK_UID | ||
Table of administrative boundaries of Italian municipalities provided by ISTAT (Italian National Institute of Statistics). This table should be replaced by the table of local administrative boundaries of the geographical survey region.
| Indexes | Field Name | Data Type | Description |
|---|---|---|---|
| PK_UID | integer | Autoincremental integer value as Primary Key | |
| COD_REG | integer | Unique code identifying the administrative italian Region. | |
| COD_CM | integer | Unique code identifying the administrative italian Municipality | |
| COD_PRO | integer | Unique code identifying the administrative italian Province. | |
| PRO_COM | integer | Province and Municipality unique codes. | |
| COMUNE | text( 2000000000 ) | Name of the Municipality | |
| NOME_TED | text( 2000000000 ) | ||
| FLAG_CM | integer | ||
| SHAPE_Leng | double( 2000000000, 10 ) | ||
| SHAPE_Area | double( 2000000000, 10 ) | ||
| Geometry | multipolygon | Geometry data type field | |
| Indexes | |||
| pk_comuni2016 | ON PK_UID | ||
'cover' table storing data about observed Quaternary cover deposits. Table records information on the outcrops geometric characteristics and deposits composition.
| Indexes | Field Name | Data Type | Description |
|---|---|---|---|
| * | pk_cover | integer | Autoincremental integer value as Primary Key |
| * | code | text( 2000000000 ) | cover observation point identification unique code |
| * | rDate | date DEFAULT CURRENT_DATE | database recording date |
| x_coord | real | UTM E coordinate | |
| y_coord | real | UTM N coordinate | |
| loc | text( 2000000000 ) | brief description of the location | |
| geol | text( 2000000000 ) | name of the geologist who collects the data | |
| h | real | cover outcrop height | |
| w | real | cover outcrop width | |
| vTh | real | outcrop visible thickness of the cover | |
| tTh | real | true thickness of the cover | |
| type | text( 2000000000 ) | description of the type of Quaternary cover deposit | |
| grain | text( 3 ) | grain size acronym taken from database table 6. Acronym is related to field identification criteria | |
| cem | text( 14 ) | cementation grade to be chosen between "loose" and "hardly cemented" | |
| note | text( 2000000000 ) | any relevant note about the observed cover | |
| Indexes | |||
| pk_cover | ON pk_cover | ||
Child 'disc' table storing data about rock mass discontinuity sets.
| Indexes | Field Name | Data Type | Description |
|---|---|---|---|
| * | pk_disc | integer | Autoincremental integer value as Primary Key |
| * | set | integer | progressive number of the discontinuity set occurring in the single rock mass |
| type | text( 2 ) | discontinuity acronym taken from database table 9. Acronym is related to a descriptive term | |
| dip | real | discontinuity dip angle | |
| dipDir | integer | discontinuity dip direction angle | |
| minSp | real | discontinuity sets spacing minimum value in meters | |
| maxSp | real | discontinuity sets spacing maximum value in meters | |
| meanSp | real | discontinuity sets spacing mean value in meters | |
| minP | real | discontinuity set persistence minimum value in meters | |
| maxP | real | discontinuity set persistence maximum value in meters | |
| meanP | real | discontinuity set persistence mean value in meters | |
| roug | text( 4 ) | number identifying the surface roughness according to the ISRM standards (ISRM, 1978) | |
| jWeatR | integer | Schmidt hammer rebound number on weathered joint surface as it appears in outcrop | |
| jClR | integer | Schmidt hammer rebound number on surface after cleaning with carborundum stone | |
| shP | text( 2 ) | Schmidt hammer position | |
| isrmT | text( 2 ) | grade provided by the "Manual index test" performed on the rock surface according to the ISRM standards (ISRM, 1978) | |
| weat | text( 2 ) | weathering stage described using qualifying terms according to the ISRM standards (ISRM, 1978) | |
| * | fk_rMass | integer | FK referencing the PK of 'rMass' table |
| Indexes | |||
| pk_disc | ON pk_disc | ||
| Foreign Keys | |||
| fk_disc_rMass | ( fk_rMass ) ref rMass (pk_rMass) | ||
'lslide' table storing data about landslides already registered in the IFFI inventory or newly observed. IFFI acronym stands for "Inventario Fenomeni Franosi Italiani" (Inventory of Landslide Phenomena in Italy), project carried out by ISPRA (Istituto Superiore per la Protezione e la Ricerca Ambientale) and the Italian Regions and Autonomous Provinces (ISPRA, 2008).
| Indexes | Field Name | Data Type | Description |
|---|---|---|---|
| * | pk_lSlide | integer | Autoincremental integer value as Primary Key |
| * | code | text( 2000000000 ) | landslide observation point identification unique code |
| * | rDate | date DEFAULT CURRENT_DATE | database recording date |
| x_coord | real | UTM E coordinate | |
| y_coord | real | UTM N coordinate | |
| loc | text( 2000000000 ) | brief description of the location | |
| geol | text( 2000000000 ) | name of the geologist who collects the data | |
| iffiId | integer | IFFI landslide identification unique code | |
| x_piff | real | PIFF point UTM E coordinate | |
| y_piff | real | PIFF point UTM N coordinate | |
| type | text( 60 ) | landslide cinematic type according to the IFFI classification | |
| mat | text( 7 ) | description of the landslide accumulation material | |
| grain | text( 3 ) | grain size acronym taken from database table 6, where the acronym is related to field identification criteria | |
| cem | text( 14 ) | cementation grade to be chosen between "loose" and "hardly cemented" | |
| sect | text( 2000000000 ) | link to the path of the landslide cross-section schematic draw | |
| dir | integer | landslide movement direction | |
| note | text( 2000000000 ) | any relevant note about the observed landslide | |
| Indexes | |||
| pk_frane | ON pk_lSlide | ||
| Pk_frane_pk_lSlide | ON pk_lSlide | ||
Child 'ph' table storing information related to the images of landslides ("lslide" parent table), rock masses ("rmass" parent table) and covers ("cover" parent table).
| Indexes | Field Name | Data Type | Description |
|---|---|---|---|
| * | pk_ph | integer | Autoincremental integer value as Primary Key |
| * | code | text( 2000000000 ) | image identification unique code related to the type of observed geographic feature |
| photo | text( 2000000000 ) | string of the path to directory and image file | |
| fk_lSlide | integer | FK referencing the PK of 'lSlide' table | |
| fk_rMass | integer | FK referencing the PK of 'rMass' table | |
| fk_cover | integer | FK referencing the PK of 'cover' table | |
| Indexes | |||
| pk_ph | ON pk_ph | ||
| Foreign Keys | |||
| fk_ph_rMass | ( fk_rMass ) ref rMass (pk_rMass) | ||
| fk_ph_cover | ( fk_cover ) ref cover (pk_cover) | ||
| fk_ph_lSlide | ( fk_lSlide ) ref lSlide (pk_lSlide) | ||
Parent 'rmass' geographic table storing data about rock masses observed at field points. Data concern typical parameters characterizing the rock mass.
| Indexes | Field Name | Data Type | Description |
|---|---|---|---|
| * | pk_rMass | integer | Autoincremental integer value as Primary Key |
| * | code | text( 2000000000 ) | rock mass observation point identification unique code |
| * | rDate | date DEFAULT CURRENT_DATE | database recording date |
| x_coord | real | UTM E coordinate | |
| y_coord | real | UTM N coordinate | |
| loc | text( 2000000000 ) | brief description of the location | |
| geol | text( 2000000000 ) | name of the geologist who collects the data | |
| h | real | rock mass outcrop height | |
| w | real | rock mass outcrop weigth | |
| dip | real | rock mass strata dip value to describe the outcrop orientation | |
| dipDir | integer | rockk mass strata dip direction value to describe the outcrop orientation | |
| lito | text( 2000000000 ) | lithologic description | |
| type | text( 11 ) | adjective to describe the rock masses according to the ISRM standards (ISRM, 1978) | |
| weat | text( 2 ) | number indicating the grade of weathering (or alteration) of the rock mass according to the ISRM standards (ISRM, 1978) | |
| image | text( 2000000000 ) | ||
| lv | real | vertical length along which the number of joint is counted | |
| ld | real | diagonal length along which the number of joint is counted | |
| lo | real | horizontal length along which the number of joint is counted | |
| lvJ | integer | number of joints counted along the "lv" vertical length | |
| ldJ | integer | number of joints counted along the "ld" diagonal length | |
| loJ | integer | number of joints counted along the "lo" horizontal length | |
| note | text( 2000000000 ) | any relevant note about the observed rock mass | |
| Indexes | |||
| pk_rMass | ON pk_rMass | ||
Reference table for selecting and storing the accumulation material type.
| Indexes | Field Name | Data Type | Description |
|---|---|---|---|
| PK_UID | integer | Autoincremental integer value as Primary Key | |
| id | integer | ||
| material | text( 2000000000 ) | The three basic terms to indicate the type of accumulation material | |
| Indexes | |||
| pk_t_10 | ON PK_UID | ||
Reference table for selecting and store the Schmidt hammer position (ISRM, 1978).
| Indexes | Field Name | Data Type | Description |
|---|---|---|---|
| PK_UID | integer | Autoincremental integer value as Primary Key | |
| label | text( 2000000000 ) | Synthetic label representing the Schmidt hammer orientation class | |
| description | text( 2000000000 ) | Five classes of Schmidt hammer orientation | |
| Indexes | |||
| pk_t_11 | ON PK_UID | ||
Grades of weathering or alteration. ISRM (1978)
| Indexes | Field Name | Data Type | Description |
|---|---|---|---|
| PK_UID | integer | Autoincremental integer value as Primary Key | |
| name | text( 2000000000 ) | Short description of the weathering grade of rock mass according to ISRM (1978) | |
| grade | text( 2000000000 ) | Grade defined according to ISRM (1978) | |
| Indexes | |||
| pk_t_2 | ON PK_UID | ||
Grades and types of roughness. ISRM (1978)
| Indexes | Field Name | Data Type | Description |
|---|---|---|---|
| PK_UID | integer | Autoincremental integer value as Primary Key | |
| grade | text( 2000000000 ) | The nine categories of profile: I - II - III - IV - V - VI - VII - VIII - IX | |
| surface | text( 2000000000 ) | Three degrees of surface roughness: stepped - undulating - planar | |
| profile | text( 2000000000 ) | The three descriptive terms of surface profile inside each of the surface roughness degrees defined by 'surface' attribute of this table: rough - smooth - slickensided | |
| Indexes | |||
| pk_t_3 | ON PK_UID | ||
Reference table for selecting the field identification criteria and storing the relative grade of the ISRM Manual index test.
| Indexes | Field Name | Data Type | Description |
|---|---|---|---|
| PK_UID | integer | Autoincremental integer value as Primary Key | |
| grade | text( 2000000000 ) | The 7 grades characterizing the rock discontinuity wall strength | |
| name | text( 2000000000 ) | Short description of the discontinuity wall strength resulting from the Manual index tests performed according to the field identification criteria | |
| identification_test | text( 2000000000 ) | Extended description of the field identification criteria of the six grades | |
| Indexes | |||
| pk_t_4 | ON PK_UID | ||
Reference table for the qualitative assessment of the "weathering grade of rock material".
| Indexes | Field Name | Data Type | Description |
|---|---|---|---|
| PK_UID | integer | Autoincremental integer value as Primary Key | |
| term | text( 20 ) | Adjectives defining the weathering grades of rock mass or rock material | |
| description | text( 200000 ) | Extended description of the characteristics defining the different weathering grades of rock mass or rock material | |
| Indexes | |||
| pk_t_5 | ON PK_UID | ||
Reference table for selecting and storing the label relative to the grain size class of the landslide deposit.
| Indexes | Field Name | Data Type | Description |
|---|---|---|---|
| PK_UID | integer | Autoincremental integer value as Primary Key | |
| label | char( 2 ) | Label of the grain size class | |
| criteria | text( 2000000000 ) | Criteria for the definition of the grain size class | |
| grain_size | text( 2000000000 ) | Synthetic name of the grain size class | |
| Indexes | |||
| pk_t_6 | ON PK_UID | ||
Reference table for selecting and storing the landslide kinematic type.
| Indexes | Field Name | Data Type | Description |
|---|---|---|---|
| PK_UID | integer | Autoincremental integer value as Primary Key | |
| code | integer | Integer number as uniquely identifier code of the landslide kinematic type | |
| type | text( 2000000000 ) | Landslide kinematic types | |
| Indexes | |||
| pk_t_7 | ON PK_UID | ||
Reference table for selecting and storing the cover deposit type.
| Indexes | Field Name | Data Type | Description |
|---|---|---|---|
| pk | integer | Autoincremental integer value as Primary Key | |
| code | text( 2000000000 ) | Labels representing the initials of terms defining the cover deposit type | |
| description | text( 2000000000 ) | The cover deposit types |
Reference table for selecting and storing the discontinuity type.
| Indexes | Field Name | Data Type | Description |
|---|---|---|---|
| PK_UID | integer | Autoincremental integer value as Primary Key | |
| label | text( 2000000000 ) | Label indicating the discontinuity type | |
| type | text( 2000000000 ) | Types of discontinuity | |
| Indexes | |||
| pk_t_9 | ON PK_UID | ||