Dataset Collection of Geological Survey of Finland Rock Samples

The dataset collection consists of one or more dataset tables sourced from the website of Geologian tutkimuskeskus (Geological Survey of Finland) in Finland.

Tables

Publicly Shared Geological Samples in FinlandTSV
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...
Version History of Sample Data from Geologian tutkimuskeskus in FinlandTSV
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...

Column Descriptions

Publicly Shared Geological Samples in Finland

Column	Type	Comment
_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.

Version History of Sample Data from Geologian tutkimuskeskus in Finland

Column	Type	Comment
_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.

Additional Info

Last Updated	April 22, 2024
Created	April 22, 2024