Version History of Tektonic Provinces of Rock Operations in Finland
Click here for a data sample
This table stores the version history of the base table 'Kalliopera 1m tektoniset provinssit'. It contains rows with information about the geological provinces in Finland. The data is sourced from 'Geological Survey of Finland' which is the national geological survey organization of Finland. The table tracks changes made to the base table rows over time, indicating when a new version was extracted from the data source. Each row in this table has additional columns '_start_date' and '_end_date' indicating the dates when the row was extracted and when a new version was extracted respectively. The table can be utilized in data analytics to analyze the evolution of geological provinces over time, identify changes in shape length and shape area of provinces, and analyze the distribution of different types of geological provinces in Finland. The 'geom' column contains the geometric data of the provinces in various formats such as GeoJSON and Geotext. Analyzing this column can provide insights into the spatial distribution and characteristics of the geological provinces.
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 sequence number assigned to each row version. |
|---|
| gml_id | string | The ID of the row version in GML format. |
|---|
| objectid | int | The unique identifier of the row version. |
|---|
| province_name | string | The name of the province associated with the row version. |
|---|
| shape_length | int | The length of the shape geometry of the row version. |
|---|
| shape_area | int | The area of the shape geometry of the row version. |
|---|
| geom_geojson | string | The geometry of the row version in GeoJSON format. |
|---|
| geom_geotext | string | The geometry of the row version in geotext format. |
|---|
| geom_type | string | The type of geometry (point, line, polygon) of the row version. |
|---|
| geom_centroid | string | The centroid point of the geometry of the row version. |
|---|
| geom_center_x | double | The x-coordinate of the center point of the geometry of the row version. |
|---|
| geom_center_y | double | The y-coordinate of the center point of the geometry of the row version. |
|---|
| geom | binary | The geometry of the row version. |
|---|
