Geological Survey of Finland - Soil WFS Area-based Stream Sediment Geochemistry Mineral Sample A61
Tables
-
Regional Stream Sediment Geochemistry - Mineral Samples A61 - FinlandTSV
This table contains data related to the geochemical analysis of sediment samples collected from various sites in Finland. The data is sourced from the website of the Geological Survey of Finland (Geologian tutkimuskeskus). The table provides information such as the extraction date of the data, row numbers, unique identifiers, geographical coordinates (easting and northing), map sheet information, material type, width of the sample, velocity, site name, catchment area, sampling date, and various chemical concentrations (co_a61_ppm, co_l, cr_a61_ppm, cr_l, cu_a61_ppm, cu_l, fe_a61_ppm, fe_l, mn_a61_ppm, mn_l, ni_a61_ppm, ni_l, pb_a61_ppm, pb_l, zn_a61_ppm, zn_l). The table also includes information about the fraction, geological geometry (geom_geojson, geom_geotext), geom type, centroid,...
-
Version History of Sediment Geochemistry Mineral Samples in Regional Stream EcosystemsTSV
This table contains the version history of rows from the 'Geological Survey of Finland' dataset related to regional stream sediment geochemistry and mineral samples. The table includes information such as the start and end dates of each row version, row number, unique identifiers, geographical coordinates, map sheet, material type, width, velocity, site and catchment details, date of sample collection, concentrations of various elements (e.g., cobalt, chromium, copper, iron, manganese, nickel, lead, zinc), fraction, and various geometrical attributes. The table is a historical log that tracks changes in the base table over time, with each row representing a specific version with its corresponding start and end dates. By analyzing the data in this table, researchers and analysts can gain...
Column Descriptions
Regional Stream Sediment Geochemistry - Mineral Samples A61 - Finland
| Column | Type | Comment |
|---|---|---|
| _extract_date | date | The date when the data was extracted from the source. |
| _row_number | long | The unique identifier for each row in the table. |
| gml_id | string | The GML identifier for the object. |
| objectid | int | The unique identifier for each object. |
| id | string | The unique identifier for each record in the table. |
| id_number | string | The identification number for the object. |
| easting | int | The easting coordinate of the object's location. |
| northing | int | The northing coordinate of the object's location. |
| mapsheet20 | int | The 20-digit map sheet number. |
| material | string | The material of the object. |
| width_m | int | The width of the object in meters. |
| velocity | string | The velocity of the object. |
| site | string | The site where the object is located. |
| catchment | int | The catchment area of the object. |
| date_a61 | int | The date related to property 'a61' of the object. |
| co_a61_ppm | int | The concentration of carbon monoxide (CO) in parts per million for property 'a61' of the object. |
| co_l | string | The total carbon monoxide (CO) level for property 'l' of the object. |
| cr_l | string | The total chromium (Cr) level for property 'l' of the object. |
| cu_a61_ppm | int | The concentration of copper (Cu) in parts per million for property 'a61' of the object. |
| cu_l | string | The total copper (Cu) level for property 'l' of the object. |
| fe_l | string | The total iron (Fe) level for property 'l' of the object. |
| mn_a61_ppm | int | The concentration of manganese (Mn) in parts per million for property 'a61' of the object. |
| mn_l | string | The total manganese (Mn) level for property 'l' of the object. |
| ni_a61_ppm | int | The concentration of nickel (Ni) in parts per million for property 'a61' of the object. |
| ni_l | string | The total nickel (Ni) level for property 'l' of the object. |
| pb_a61_ppm | int | The concentration of lead (Pb) in parts per million for property 'a61' of the object. |
| pb_l | string | The total lead (Pb) level for property 'l' of the object. |
| zn_a61_ppm | int | The concentration of zinc (Zn) in parts per million for property 'a61' of the object. |
| zn_l | string | The total zinc (Zn) level for property 'l' of the object. |
| cr_a61_ppm | int | The concentration of chromium (Cr) in parts per million for property 'a61' of the object. |
| fraction | string | The fraction of the object. |
| fe_a61_ppm | int | The concentration of iron (Fe) in parts per million for property 'a61' of the object. |
| geom_geojson | string | The object geometry in GeoJSON format. |
| geom_geotext | string | The object geometry in GeoText format. |
| geom_type | string | The type of the object geometry. |
| geom_centroid | string | The centroid point of the object's geometry. |
| geom_center_x | double | The X coordinate of the center point of the object's geometry. |
| geom_center_y | double | The Y coordinate of the center point of the object's geometry. |
| geom | binary | The full geometry of the object. |
Version History of Sediment Geochemistry Mineral Samples in Regional Stream Ecosystems
| Column | Type | Comment |
|---|---|---|
| _start_date | date | The start date of the row version indicating the validity period of the row. |
| _end_date | date | The end date of the row version indicating the validity period of the row. |
| _row_number | long | The row number of the version history table. |
| gml_id | string | The GML identifier of the base table row. |
| objectid | int | The unique identifier of the base table row. |
| id | string | The identifier of the row version. |
| id_number | string | The numerical identifier of the row version. |
| easting | int | The easting coordinate of the location. |
| northing | int | The northing coordinate of the location. |
| mapsheet20 | int | The 20-digit map sheet identifier. |
| material | string | The material attribute of the row version. |
| width_m | int | The width in meters of the row version. |
| velocity | string | The velocity attribute of the row version. |
| site | string | The site attribute of the row version. |
| catchment | int | The catchment attribute of the row version. |
| date_a61 | int | The date attribute of the row version. |
| co_a61_ppm | int | The cobalt attribute in parts per million (ppm) of the row version. |
| co_l | string | The cobalt attribute in liters of the row version. |
| cr_l | string | The chromium attribute in liters of the row version. |
| cu_a61_ppm | int | The copper attribute in parts per million (ppm) of the row version. |
| cu_l | string | The copper attribute in liters of the row version. |
| fe_l | string | The iron attribute in liters of the row version. |
| mn_a61_ppm | int | The manganese attribute in parts per million (ppm) of the row version. |
| mn_l | string | The manganese attribute in liters of the row version. |
| ni_a61_ppm | int | The nickel attribute in parts per million (ppm) of the row version. |
| ni_l | string | The nickel attribute in liters of the row version. |
| pb_a61_ppm | int | The lead attribute in parts per million (ppm) of the row version. |
| pb_l | string | The lead attribute in liters of the row version. |
| zn_a61_ppm | int | The zinc attribute in parts per million (ppm) of the row version. |
| zn_l | string | The zinc attribute in liters of the row version. |
| cr_a61_ppm | int | The chromium attribute in parts per million (ppm) of the row version. |
| fraction | string | The fraction attribute of the row version. |
| fe_a61_ppm | int | The iron attribute in parts per million (ppm) of the row version. |
| geom_geojson | string | The geometric representation of the row version in GeoJSON format. |
| geom_geotext | string | The geometric representation of the row version in GeoText format. |
| geom_type | string | The type of geometry of the row version. |
| geom_centroid | string | The centroid point 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 geometric representation of the row version. |
Additional Info
| Last Updated | April 22, 2024 |
|---|---|
| Created | April 22, 2024 |