Geological Survey of Finland - Rock Operations WFS Reef Type PGE - Reef Type PGE History
Click here for a data sample
This table contains the version history of the rows extracted from the 'Geological Survey of Finland' website for the base table 'rajapinnat_gtk_kalliopera_wfsreef_tyypin_pge__reeftyypin_pge'. The table includes additional columns '_start_date' and '_end_date', representing the extraction dates of the respective row versions. The data in this table can be used for various data analytics purposes. For example, it can be utilized to analyze the changes and evolution of the 'tracttype', 'tractname', 'number_dep_10_percent_prob', 'number_dep_50_percent_prob', 'number_dep_90_percent_prob', 'expected_number_of_dep', 'au_estim_10_percent_prob', 'au_estim_50_percent_prob', 'au_estim_90_percent_prob', 'au_mean_estimate', 'cu_estim_10_percent_prob', 'cu_estim_50_percent_prob', 'cu_estim_90_percent_prob', 'cu_mean_estimate', 'ni_estim_10_percent_prob', 'ni_estim_50_percent_prob', 'ni_estim_90_percent_prob', 'ni_mean_estimate', 'pd_estim_10_percent_prob', 'pd_estim_50_percent_prob', 'pd_estim_90_percent_prob', 'pd_mean_estimate', 'pt_estim_10_percent_prob', 'pt_estim_50_percent_prob', 'pt_estim_90_percent_prob', 'pt_mean_estimate', 'shape_area', and 'shape_len' attributes over time. The 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y' columns contain geographic spatial information for further geospatial data analysis. The 'geom' column stores the full geometry information of each row. The data source for this table is the 'Geological Survey of Finland' website, which originates from Finland (ISO country code: 'fi').
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 assigned to the row. |
|---|
| gml_id | string | The Global Markup Language (GML) identifier for the row. |
|---|
| objectid | int | The unique identifier for the row. |
|---|
| tracttype | string | The type of tract. |
|---|
| tractname | string | The name of the tract. |
|---|
| number_dep_10_percent_prob | int | The number of deposits with a 10 percent probability. |
|---|
| number_dep_50_percent_prob | int | The number of deposits with a 50 percent probability. |
|---|
| number_dep_90_percent_prob | int | The number of deposits with a 90 percent probability. |
|---|
| expected_number_of_dep | int | The expected number of deposits. |
|---|
| au_estim_10_percent_prob | int | The estimated gold (Au) amount with a 10 percent probability. |
|---|
| au_estim_50_percent_prob | int | The estimated gold (Au) amount with a 50 percent probability. |
|---|
| au_estim_90_percent_prob | int | The estimated gold (Au) amount with a 90 percent probability. |
|---|
| au_mean_estimate | int | The mean estimated gold (Au) amount. |
|---|
| cu_estim_10_percent_prob | int | The estimated copper (Cu) amount with a 10 percent probability. |
|---|
| cu_estim_50_percent_prob | int | The estimated copper (Cu) amount with a 50 percent probability. |
|---|
| cu_estim_90_percent_prob | int | The estimated copper (Cu) amount with a 90 percent probability. |
|---|
| cu_mean_estimate | int | The mean estimated copper (Cu) amount. |
|---|
| ni_estim_10_percent_prob | int | The estimated nickel (Ni) amount with a 10 percent probability. |
|---|
| ni_estim_50_percent_prob | int | The estimated nickel (Ni) amount with a 50 percent probability. |
|---|
| ni_estim_90_percent_prob | int | The estimated nickel (Ni) amount with a 90 percent probability. |
|---|
| ni_mean_estimate | int | The mean estimated nickel (Ni) amount. |
|---|
| pd_estim_10_percent_prob | int | The estimated palladium (Pd) amount with a 10 percent probability. |
|---|
| pd_estim_50_percent_prob | int | The estimated palladium (Pd) amount with a 50 percent probability. |
|---|
| pd_estim_90_percent_prob | int | The estimated palladium (Pd) amount with a 90 percent probability. |
|---|
| pd_mean_estimate | int | The mean estimated palladium (Pd) amount. |
|---|
| pt_estim_10_percent_prob | int | The estimated platinum (Pt) amount with a 10 percent probability. |
|---|
| pt_estim_50_percent_prob | int | The estimated platinum (Pt) amount with a 50 percent probability. |
|---|
| pt_estim_90_percent_prob | int | The estimated platinum (Pt) amount with a 90 percent probability. |
|---|
| pt_mean_estimate | int | The mean estimated platinum (Pt) amount. |
|---|
| shape_area | int | The area of the shape. |
|---|
| shape_len | int | The length of the shape. |
|---|
| geom_geojson | string | The geometry of the shape in GeoJSON format. |
|---|
| geom_geotext | string | The geometry of the shape in GeoText format. |
|---|
| geom_type | string | The type of geometry of the shape. |
|---|
| geom_centroid | string | The centroid of the shape geometry. |
|---|
| geom_center_x | double | The X-coordinate of the center of the shape. |
|---|
| geom_center_y | double | The Y-coordinate of the center of the shape. |
|---|
| geom | binary | The geometry of the shape. |
|---|
