Version History of Geological Survey Data for Pb Isotope Composition in Fossilized Rock Samples in Finland
Click here for a data sample
This table contains the version history of the rows in the 'Geologian tutkimuskeskus' database table for 'rajapinnat_gtk_kalliopera_wfspb_pb_isotooppiaineisto__pb_pb_isotooppiaineisto'. The rows in this table are extracted from the data source website, which originates from Finland (ISO country code 'fi'). The table includes additional columns '_start_date' and '_end_date' to indicate the extraction dates of each row version. The data in this table can be utilized in various data analytics scenarios such as analyzing the changes in rock type or mineral material over time, studying the distribution of samples on map sheets, examining the isotopic composition of lead (pb206_pb204, pb207_pb204, pb208_pb204), and analyzing the spatial aspects of the samples using geometric data (geom_geojson, geom_geotext, geom_type, geom_centroid, geom_center_x, geom_center_y, geom). Please note that the specific details of each column are not included in this description.
Field Descriptions
| Name |
Data type |
Description |
| _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 row number of the version in the table. |
|---|
| gml_id | string | The GML identifier for the row version. |
|---|
| objectid | int | The identifier for the row version. |
|---|
| sample_id | string | The identifier for the sample. |
|---|
| map_sheet | int | The map sheet associated with the row version. |
|---|
| northing | int | The northing value of the row version. |
|---|
| easting | int | The easting value of the row version. |
|---|
| ykj_north_original | int | The original YKJ north value of the row version. |
|---|
| ykj_east_original | int | The original YKJ east value of the row version. |
|---|
| location | string | The location of the row version. |
|---|
| rock_type | string | The type of rock in the row version. |
|---|
| mineral_material | string | The mineral material in the row version. |
|---|
| pb206_pb204 | int | The Pb206/Pb204 ratio in the row version. |
|---|
| error_estimate_two_sigma | int | The error estimate (two sigma) in the row version. |
|---|
| pb207_pb204 | int | The Pb207/Pb204 ratio in the row version. |
|---|
| error_estimate_two_sigma2 | int | The second error estimate (two sigma) in the row version. |
|---|
| pb208_pb204 | int | The Pb208/Pb204 ratio in the row version. |
|---|
| error_estimate_two_sigma3 | int | The third error estimate (two sigma) in the row version. |
|---|
| group_col | string | The group column in the row version. |
|---|
| domain | string | The domain of the row version. |
|---|
| reference | string | The reference associated with the row version. |
|---|
| comments | string | Any comments related to the row version. |
|---|
| sample_field_code | string | The field code of the sample in the row version. |
|---|
| geom_geojson | string | The geometry in GeoJSON format for the row version. |
|---|
| geom_geotext | string | The geometry in Geotext format for the row version. |
|---|
| geom_type | string | The type of geometry in the row version. |
|---|
| geom_centroid | string | The centroid of the geometry in the row version. |
|---|
| geom_center_x | double | The center X coordinate of the geometry in the row version. |
|---|
| geom_center_y | double | The center Y coordinate of the geometry in the row version. |
|---|
| geom | binary | The geometry in the row version. |
|---|
