Tectonic Province History from 'Geological Survey of Finland' in Finland
Click here for a data sample
This table contains the version history of the rows extracted from the 'Geological Survey of Finland - Tectonic Provinces' dataset. The table provides information about the tectonic provinces and subprovinces within Finland. It includes the start and end dates, row numbers, unique identifiers, tectonic province names, tectonic province codes, area and length measurements, tectonic subprovince names, tectonic subprovince codes, geographic information in GeoJSON and geotext formats, geometric type, centroid coordinates, and the geometric representation. The data in this table can be utilized in various data analytics scenarios, such as analyzing the changes in tectonic province boundaries over time, identifying the most recent versions of the provinces, calculating the area and length of each province, and conducting spatial analysis based on the geometric attributes. The table is sourced from the official website of the Geological Survey of Finland, which is the national geological research center of Finland.
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 internal row number of the versioned row. |
|---|
| gml_id | string | The unique identifier of the row version in GML format. |
|---|
| objectid | int | The unique identifier of the row version. |
|---|
| tectonic_province | int | The tectonic province associated with the row. |
|---|
| tectonic_province_c3 | string | The code representing the tectonic province associated with the row. |
|---|
| shape_area | int | The area of the row geometry shape. |
|---|
| shape_len | int | The length of the row geometry shape. |
|---|
| tectonic_subprovince | int | The tectonic subprovince associated with the row. |
|---|
| tectonic_subprovince_c7 | string | The code representing the tectonic subprovince associated with the row. |
|---|
| geom_geojson | string | The geometry of the row in GeoJSON format. |
|---|
| geom_geotext | string | The text representation of the geometry of the row. |
|---|
| geom_type | string | The type of the row geometry. |
|---|
| geom_centroid | string | The centroid of the row geometry. |
|---|
| geom_center_x | double | The x-coordinate of the center point of the row geometry. |
|---|
| geom_center_y | double | The y-coordinate of the center point of the row geometry. |
|---|
| geom | binary | The full geometry representation of the row. |
|---|
