Version History of Electromagnetic Features - Sourced from Geological Survey of Finland (GTK) - Country: Finland
Click here for a data sample
This table contains the version history of the 'rajapinnat_gtk_kalliopera_wfselektromagneettiset__elektromagneettiset' table sourced from the website of the Geological Survey of Finland (Geologian tutkimuskeskus). The table records the various versions of the base table, indicating the start and end dates of each version. Each row in the table represents a specific version of a row from the base table, with additional columns providing information such as the row number, GML ID, object ID, lineament ID, data source, certainty, scale, operator, date column, remarks, shape length, geometric data in GeoJSON and GeoText formats, geometry type, centroid coordinates, and the original geometry. The data in this table can be utilized for various data analytics purposes, such as tracking changes over time, analyzing data quality and reliability, identifying patterns or trends, and conducting spatial analysis. It provides valuable historical information about the base table, allowing users to explore the evolution of the underlying data. The data source 'Geologian tutkimuskeskus' originates from Finland (ISO country code: 'fi').
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 | The unique number assigned to each row version in the table. |
gml_id | string | The unique identifier in the Geography Markup Language (GML) format. |
objectid | int | The unique identifier for each row in the table. |
lineament_id | string | The identifier of the lineament. |
data_source | string | The source of the data for the row version. |
certainty | string | The level of certainty or confidence in the data. |
scale | string | The scale at which the data is represented or captured. |
operator | string | The operator or person responsible for capturing or updating the data. |
date_col | timestamp | The date associated with the row version. |
remarks | string | Additional remarks or comments about the row version. |
shape_len | int | The length of the shape or geometry. |
geom_geojson | string | The geometry in GeoJSON format. |
geom_geotext | string | The geometry in geotext format. |
geom_type | string | The type of geometry. |
geom_centroid | string | The centroid of the geometry. |
geom_center_x | double | The x-coordinate of the center point of the geometry. |
geom_center_y | double | The y-coordinate of the center point of the geometry. |
geom | binary | The spatial representation of the row version. |