Version History of Geological Survey Fault Structures in Finland
Click here for a data sample
This table contains the version history of the rows in the 'Geologian tutkimuskeskus' dataset for 'kalliopera_wfsfinstruct_siirrosrakenteet__finstruct_siirrosrakenteet', sourced from Finland (ISO country code 'fi'). Each row in this table represents a specific version of a row in the base table. The version history is tracked using the '_start_date' and '_end_date' columns, which indicate when each row version was extracted from the data source. If the '_end_date' value is null, it means that the row is the most recent version. The table also includes additional columns such as 'gml_id', 'objectid', 'fault_type', 'fault_type_c3', 'shear_zone', 'shear_zone_c5', 'basis', 'basis_c7', 'shape_len', 'cgi_fault_type', 'cgi_fault_type_c10', 'cgi_fault_movement_sense', 'cgi_fault_movement_sense_c12', 'cgi_fault_movement_type', 'cgi_fault_movement_type_c14', 'fault', 'fault_c16', 'fault_zone', 'fault_zone_c18', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y' that provide additional information about the respective row versions. This historical data can be utilized in various data analytics tasks such as trend analysis, change detection, and version comparison of the geological features described by the dataset.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The start date of the validity period of the row version. |
|---|
| _end_date | date | The end date of the validity period of the row version. |
|---|
| _row_number | long | The number assigned to each row in the table. |
|---|
| gml_id | string | The GML identifier of the row. |
|---|
| objectid | int | The identifier of the row. |
|---|
| fault_type | int | The type of the fault. |
|---|
| fault_type_c3 | string | The fault type with C3 classification. |
|---|
| shear_zone | int | The shear zone of the fault. |
|---|
| shear_zone_c5 | string | The shear zone with C5 classification. |
|---|
| basis | int | The basis of the fault. |
|---|
| basis_c7 | string | The fault basis with C7 classification. |
|---|
| shape_len | int | The length of the shape of the fault. |
|---|
| cgi_fault_type | int | The fault type according to CGI classification. |
|---|
| cgi_fault_type_c10 | string | The fault type with C10 classification in CGI. |
|---|
| cgi_fault_movement_sense | int | The movement sense of the fault according to CGI classification. |
|---|
| cgi_fault_movement_sense_c12 | string | The movement sense with C12 classification in CGI. |
|---|
| cgi_fault_movement_type | int | The movement type of the fault according to CGI classification. |
|---|
| cgi_fault_movement_type_c14 | string | The movement type with C14 classification in CGI. |
|---|
| fault | int | The description of the fault. |
|---|
| fault_c16 | string | The fault with C16 classification. |
|---|
| fault_zone | int | The fault zone of the fault. |
|---|
| fault_zone_c18 | string | The fault zone with C18 classification. |
|---|
| geom_geojson | string | The geometry in GeoJSON format. |
|---|
| geom_geotext | string | The geometry in geotext format. |
|---|
| geom_type | string | The type of the geometry. |
|---|
| geom_centroid | string | The centroid of the geometry. |
|---|
| geom_center_x | double | The X-coordinate of the center of the geometry. |
|---|
| geom_center_y | double | The Y-coordinate of the center of the geometry. |
|---|
| geom | binary | The geometry of the fault. |
|---|
