Version History of Quality Classification of Geological Survey Data from Geologian tutkimuskeskus (Finland)
Click here for a data sample
This table contains the version history of the rows of a base table named 'aineiston_laatuluokitus'. The table 'rajapinnat_gtk_kalliopera_wfsaineiston_laatuluokitusaineiston_laatuluokitushistory' is sourced from the website of the Geological Survey of Finland (Geologian tutkimuskeskus), which originates from the country with the ISO country code 'fi' (Finland). It includes columns such as '_start_date' which indicates the date when the row was extracted, and '_end_date' which signifies the date when a new version of the row was extracted. By analyzing this version history, data analysts can track changes made over time to the quality class, geophysics, remarks, and geometry attributes of the data. This can help in identifying trends and patterns in quality class assignments, geophysical measurements, and any remarks provided. Additionally, the table provides information about the shape area, shape length, and centroids of the geographical features represented by the rows. Data analysts can leverage this information for spatial analysis, such as calculating area and length measurements, and determining the central coordinates for each feature. The 'geom_geojson' and 'geom_geotext' columns store the geometry of the features in both GeoJSON and geotext formats, respectively, allowing for compatibility with various GIS software and systems. Overall, this table serves as a valuable resource for studying the historical development of the 'aineiston_laatuluokitus' dataset and conducting data analytics in the context of geological surveys and analysis in 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 | The GML identifier for the row version. |
objectid | int | The identifier for the row version in the base table. |
quality_class | int | The quality class of the row version. |
quality_class_c3 | string | The quality class of the row version with C3 classification. |
geophysics | int | The geophysics of the row version. |
geophysics_c5 | string | The geophysics of the row version with C5 classification. |
remarks | string | Any additional remarks or comments for the row version. |
shape_area | int | The area of the shape for the row version. |
shape_len | int | The length of the shape for 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 for the row version. |
geom_centroid | string | The centroid of the geometry for the row version. |
geom_center_x | double | The x-coordinate of the center of the geometry for the row version. |
geom_center_y | double | The y-coordinate of the center of the geometry for the row version. |
geom | binary | The geometry for the row version. |