Publicly Shared Geological Samples in Finland
Click here for a data sample
This table contains information about public rock samples collected by the Geological Survey of Finland (GTK). The data has been sourced from the website of the Geological Survey of Finland. The table consists of various columns including the extract date, row number, GML ID, object ID, coordinates (northing and easting), original coordinates, sample number, sample ID, sample type, sample type C9, observation place, site, lithology, fluorescent presence, radioactive presence, municipality, map sheet details (100 and 20), organization, remarks, geographic data in GeoJSON and Geotext formats, geometry type, centroid coordinates, and the geometry itself. The data in this table could be utilized in various data analytics scenarios like studying the distribution of different lithologies across municipalities, analyzing the presence of certain elements in different rock samples, identifying patterns in the geographic coordinates of the samples, and exploring the relationship between lithology and fluorescence or radioactivity. The source of this data is the Geological Survey of Finland. The data originates from Finland (ISO country code: FI).
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | The date when the data was extracted. |
|---|
| _row_number | long | The row number of the data entry. |
|---|
| gml_id | string | The GML ID of the entry. |
|---|
| objectid | int | The ID of the object. |
|---|
| northing | int | The northing coordinate of the object. |
|---|
| easting | int | The easting coordinate of the object. |
|---|
| northing_original | int | The original northing coordinate of the object. |
|---|
| easting_original | int | The original easting coordinate of the object. |
|---|
| sample_no | int | The sample number. |
|---|
| sample_id | int | The ID 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. |
|---|
| site | string | The site of observation. |
|---|
| lithology | string | The lithology of the object. |
|---|
| fluorescent | string | Indicates if the object is fluorescent. |
|---|
| radioactive | string | Indicates if the object is radioactive. |
|---|
| municipality | string | The municipality where the object is located. |
|---|
| map_sheet_100 | int | The map sheet number. |
|---|
| map_sheet_20 | int | The 20 map sheet number. |
|---|
| organization | string | The organization associated with the object. |
|---|
| remarks | string | Any additional remarks about the object. |
|---|
| geom_geojson | string | The geometry of the object in GeoJSON format. |
|---|
| geom_geotext | string | The geo text of the object. |
|---|
| 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. |
|---|
