Geological Survey of Finland - Rock Material Data Collection
Tables
-
Geological Survey of Finland - Rock Periphery - Rock Periphery DataTSV
This table contains data from the 'Geological Survey of Finland' website. It includes information about rock operations in the country with ISO country code 'fi'. The table contains various columns such as the extraction date, row number, GML ID, object ID, data origin, map sheet, map scale, author, publishing year, organization, modified date, shape area, shape length, modifier, remarks, low altitude flight year, hyperlink, and geometry information. The table can be utilized for data analytics purposes, such as analyzing the distribution of rock operations across different map sheets, exploring the relationship between rock operations and publishing years, and conducting spatial analysis using the geometry information.
-
Version History of Rock Composition Starting Data - Finland Geological SurveyTSV
This table contains the version history of the rows from the base table 'kallioperan_lahtoaineisto'. Each row in this table represents a specific version of a row in the base table, with additional columns '_start_date' and '_end_date' indicating the extraction dates of the row versions. The data in this table is sourced from the website of Geologian tutkimuskeskus, which is the Geological Survey of Finland. The table provides valuable information for data analytics, such as tracking modifications and updates made to the base table rows over time. By analyzing the '_start_date' and '_end_date' columns, it is possible to identify the timeline of changes and observe patterns in the modifications made to the data. This can be particularly useful in studying the evolution of geological data...
Column Descriptions
Geological Survey of Finland - Rock Periphery - Rock Periphery 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 (Geography Markup Language) identifier. |
| objectid | int | The identifier for the object. |
| data_origin | int | The origin of the data. |
| data_origin_c3 | string | An additional origin information. |
| map_sheet | int | The sheet of the map. |
| map_scale | int | The scale of the map. |
| map_scale_c6 | string | An additional scale information. |
| author | string | The author of the data. |
| publishing_year | int | The year the data was published. |
| organisation | string | The organization that published the data. |
| modified | int | The date when the data was last modified. |
| modified_c11 | boolean | An additional modification information. |
| shape_area | int | The area of the shape. |
| shape_len | int | The length of the shape. |
| modifier | string | The modifier of the data. |
| remarks | string | Additional remarks about the data. |
| low_alt_flight_year | int | The year of low altitude flight. |
| hyperlink | string | The hyperlink for additional information. |
| geom_geojson | string | The geometry of the object in GeoJSON format. |
| geom_geotext | string | The geometry of the object in Geotext 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 object. |
Version History of Rock Composition Starting Data - Finland Geological Survey
| Column | Type | Comment |
|---|---|---|
| _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 row number of the version. |
| gml_id | string | The GML ID of the row version. |
| objectid | int | The unique identifier for the row version. |
| data_origin | int | The data origin for the row version. |
| data_origin_c3 | string | The C3 data origin for the row version. |
| map_sheet | int | The map sheet for the row version. |
| map_scale | int | The map scale for the row version. |
| map_scale_c6 | string | The C6 map scale for the row version. |
| author | string | The author of the row version. |
| publishing_year | int | The publishing year of the row version. |
| organisation | string | The organization of the row version. |
| modified | int | The modification date of the row version. |
| modified_c11 | boolean | The C11 modification date of the row version. |
| shape_area | int | The area of the row version shape. |
| shape_len | int | The length of the row version shape. |
| modifier | string | The modifier of the row version. |
| remarks | string | The remarks for the row version. |
| low_alt_flight_year | int | The low altitude flight year of the row version. |
| hyperlink | string | The hyperlink of the row version. |
| geom_geojson | string | The geometry in GeoJSON format of the row version. |
| geom_geotext | string | The geotext of the row version geometry. |
| geom_type | string | The geometry type of the row version. |
| geom_centroid | string | The centroid of the row version geometry. |
| geom_center_x | double | The x-coordinate of the center point of the row version geometry. |
| geom_center_y | double | The y-coordinate of the center point of the row version geometry. |
| geom | binary | The geometry of the row version. |
Additional Info
| Last Updated | April 22, 2024 |
|---|---|
| Created | April 22, 2024 |