Version History of Magnetic Features Extracted from the Geological Survey of Finland (Geologian tutkimuskeskus) Data Source in Finland
Click here for a data sample
This table contains the version history of the rows from the 'Geologian tutkimuskeskus' data source, which originates from Finland. The table records changes made to the base table 'rajapinnat_gtk_kalliopera_wfsmagneettiset__magneettiset' over time. Each row in this table represents a specific version of a row from the base table and includes the following columns: '_start_date', which indicates the date when the row version was extracted; '_end_date', which indicates the date when a new version of the row was extracted (null if it is the most recent version); '_row_number', which represents the position of the row in the version history; 'gml_id', 'objectid', 'lineament_id', 'data_source', 'certainty', 'scale', 'operator', 'date_col', 'shape_len', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom'. This table can be utilized in various data analytics tasks, such as tracking changes made to the base table over time, identifying patterns or trends in the data source, and conducting historical data analysis.
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 number of the row version. |
gml_id | string | The GML (Geography Markup Language) ID of the row. |
objectid | int | The unique identifier for the row. |
lineament_id | string | The identifier for the lineament associated with the row. |
data_source | string | The source of the data for the row. |
certainty | string | The level of certainty or confidence for the row data. |
scale | string | The scale at which the data was collected. |
operator | string | The operator or person who entered or updated the row data. |
date_col | timestamp | The date associated with the row data. |
shape_len | int | The length of the geometric shape for the row. |
geom_geojson | string | The geometry of the row in GeoJSON format. |
geom_geotext | string | The geometry of the row in Geotext format. |
geom_type | string | The type of geometry for the row. |
geom_centroid | string | The centroid of the geometry for the row. |
geom_center_x | double | The X-coordinate of the center of the geometry for the row. |
geom_center_y | double | The Y-coordinate of the center of the geometry for the row. |
geom | binary | The complete representation of the geometry for the row. |