Version History of Sample Data from Geologian tutkimuskeskus in Finland
Click here for a data sample
This table contains the version history of the base table rows from the website of Geological Survey of Finland (Geologian tutkimuskeskus). The data in this table is sourced from the country with ISO country code 'fi'. The table includes information about the various versions of the rows such as the start date and end date of each version. It also includes a row number, unique identifiers such as gml_id and objectid, geographical coordinates (northing, easting), original coordinates (northing_original, easting_original), sample information (sample_no, sample_id, sample_type, sample_type_c9), observation place, site, lithology, indicators for fluorescence and radioactivity, municipality, map sheets (map_sheet_100, map_sheet_20), organization, remarks, and various geometric properties (geom_geojson, geom_geotext, geom_type, geom_centroid, geom_center_x, geom_center_y, geom). The data in this table can be utilized in data analytics for various purposes such as studying geological samples, analyzing lithological data, examining the distribution of fluorescent or radioactive materials, conducting spatial analysis, and generating visualizations based on the geographic attributes.
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. |
|---|
| gml_id | string | The GML identifier of the row. |
|---|
| objectid | int | The identifier of the object. |
|---|
| northing | int | The northing coordinate of the location. |
|---|
| easting | int | The easting coordinate of the location. |
|---|
| northing_original | int | The original northing coordinate of the location. |
|---|
| easting_original | int | The original easting coordinate of the location. |
|---|
| sample_no | int | The number assigned to the sample. |
|---|
| sample_id | int | The identifier of the sample. |
|---|
| sample_type | string | The type of the sample. |
|---|
| sample_type_c9 | string | The C9 type of the sample. |
|---|
| observation_place | string | The place of observation for the sample. |
|---|
| site | string | The site where the sample was collected. |
|---|
| lithology | string | The type of lithology of the sample. |
|---|
| fluorescent | string | Indicates if the sample is fluorescent. |
|---|
| radioactive | string | Indicates if the sample is radioactive. |
|---|
| municipality | string | The municipality where the sample was collected. |
|---|
| map_sheet_100 | int | The 100-scale map sheet where the sample was collected. |
|---|
| map_sheet_20 | int | The 20-scale map sheet where the sample was collected. |
|---|
| organization | string | The organization responsible for collecting the sample. |
|---|
| remarks | string | Any additional remarks or notes about the sample. |
|---|
| geom_geojson | string | The geometry of the sample in GeoJSON format. |
|---|
| geom_geotext | string | The geometry of the sample in Geotext format. |
|---|
| geom_type | string | The type of geometry of the sample. |
|---|
| geom_centroid | string | The centroid geometry of the sample. |
|---|
| 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 sample. |
|---|
