Geological Survey of Finland - Rock Surface and LiDAR Data
Tables
-
Geological Survey of Finland - Rock Formations with Lidar DataTSV
This table contains data from the 'Geological Survey of Finland' (GTK) regarding the 'Lineament' features extracted from the lidar data. The table provides information related to the lineament features such as their ID, data source, certainty, scale, operator, date, remarks, shape length, geometry, and other attributes. It includes both the geometric representation and other relevant properties of the lineaments. The table can be utilized for various data analytics purposes, such as analyzing the distribution and characteristics of lineament features, examining their relationship with other geological factors, identifying patterns and trends in lineament occurrences, and conducting spatial analysis. The data in this table can provide valuable insights into the geological composition and...
-
Version History of Lidar Data in Finland from the Geological Survey of FinlandTSV
This table contains the version history of the base table rows from the 'Geological Survey of Finland - GTK' website. The table 'lidar_history' is an extension of the base table 'lidar' and includes two additional columns '_start_date' and '_end_date'. The '_start_date' column represents the date when the row was extracted from the data source, while the '_end_date' column represents the date when a new version of the row was extracted. If the value of the '_end_date' column is null, it signifies that the row is the most recent version. The table includes various columns such as 'gml_id', 'objectid', 'lineament_id', 'data_source', 'certainty', 'scale', 'operator', 'date_col', 'remarks', 'shape_len', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and...
Column Descriptions
Geological Survey of Finland - Rock Formations with Lidar Data
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | The date when the data was extracted. |
| _row_number | long | The row number of the record. |
| gml_id | string | The GML ID of the record. |
| objectid | int | The unique identifier of the object. |
| lineament_id | string | The identifier of the lineament. |
| data_source | string | The source of the data. |
| certainty | string | The level of certainty of the data. |
| scale | string | The scale of the data. |
| operator | string | The operator who collected the data. |
| date_col | timestamp | The date when the data was collected. |
| remarks | string | Additional remarks about the data. |
| shape_len | int | The length of the shape. |
| geom_geojson | string | The geometry of the record in GeoJSON format. |
| geom_geotext | string | The geometry of the record in Geotext (text-based) format. |
| geom_type | string | The type of the geometry. |
| geom_centroid | string | The centroid of the geometry. |
| geom_center_x | double | The x-coordinate of the center of the geometry. |
| geom_center_y | double | The y-coordinate of the center of the geometry. |
| geom | binary | The geometry of the record. |
Version History of Lidar Data in Finland from the Geological Survey of Finland
| Column | Type | Comment |
|---|---|---|
| _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 unique identifier of each row in the table |
| gml_id | string | The Global Markup Language (GML) identifier of the row |
| objectid | int | The unique identifier of the row |
| lineament_id | string | The identifier of the lineament |
| data_source | string | The source of the data for the row |
| certainty | string | The level of certainty associated with the data |
| scale | string | The scale at which the data is represented |
| operator | string | The operator who created or last modified the row |
| date_col | timestamp | The date when the row was created or last modified |
| remarks | string | Any additional remarks or comments about the row |
| shape_len | int | The length of the geographical shape represented by 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 represented by the row |
| geom_centroid | string | The centroid of the geometry represented by the row |
| geom_center_x | double | The X-coordinate of the center point of the geometry represented by the row |
| geom_center_y | double | The Y-coordinate of the center point of the geometry represented by the row |
| geom | binary | The geometry of the row |
Additional Info
| Last Updated | April 22, 2024 |
|---|---|
| Created | April 22, 2024 |