Version History of Structural Provinces in Geological Survey of Finland - Rakenneprovinssit History
Click here for a data sample
This table contains the version history of the 'Geological Survey of Finland Rock Engineering Web Feature Service Construction Provinces' table. It provides a historical record of the various versions of the rows in the base table. The table includes additional columns '_start_date' and '_end_date' which indicate the extraction date of each row version from the data source. The rows in this version history table are associated with their corresponding base table rows through a common 'gml_id'. The table also includes other columns that store information such as the row number, object ID, structural province, structural province code level 3, structural subprovince, structural subprovince code level 5, shape area, shape length, GeoJSON geometry, Geotext geometry, geometry type, centroid of the geometry, centroid x-coordinate, centroid y-coordinate, and the original geometry. The data in this table can be utilized for various data analytics purposes such as tracking changes over time, identifying trends in the geological features of construction provinces, comparing different versions of the data, and analyzing the spatial distribution of the provinces. The table is sourced from the website of the Geological Survey of Finland, which originates from the country with the ISO country code 'fi', representing Finland.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The start date of the validity period for the row version. |
|---|
| _end_date | date | The end date of the validity period for the row version. |
|---|
| _row_number | long | A unique identifier for each row version. |
|---|
| gml_id | string | An identifier used for GML (Geography Markup Language) representation of the row. |
|---|
| objectid | int | A unique identifier for the row. |
|---|
| structural_province | int | The province of the structure. |
|---|
| structural_province_c3 | string | The C3 code for the province of the structure. |
|---|
| structural_subprovince | int | The subprovince of the structure. |
|---|
| structural_subprovince_c5 | string | The C5 code for the subprovince of the structure. |
|---|
| shape_area | int | The area of the shape represented by the row. |
|---|
| shape_len | int | The length of the shape represented by the row. |
|---|
| geom_geojson | string | The geometric representation of the row in GeoJSON format. |
|---|
| geom_geotext | string | The geometric representation of the row in Geotext format. |
|---|
| geom_type | string | The type of the geometric shape. |
|---|
| geom_centroid | string | The centroid of the geometric shape. |
|---|
| geom_center_x | double | The x-coordinate of the center point of the geometric shape. |
|---|
| geom_center_y | double | The y-coordinate of the center point of the geometric shape. |
|---|
| geom | binary | The complete geometric representation of the row. |
|---|
