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 the country Finland.

Tables

Geological Survey of Finland Rock Properties Public Data - National SamplesTSV
This table contains data sourced from the website of the Geological Survey of Finland (Geologian tutkimuskeskus). The data relates to rock samples and their associated information. The table includes various attributes such as the extraction date, row number, GML ID, object ID, coordinates (northing and easting), original coordinates (northing and easting), sample number, map index, district, sample type, sample type C10, organization, geometry in GeoJSON format, geometry in Geotext format, geometry type, centroid of the geometry, centroid x-coordinate, centroid y-coordinate, and the complete geometry. The data in this table can be utilized in various data analytics tasks such as geographical analysis, spatial clustering, geological mapping, and sample classification.
Version History of Geological Survey Samples from Geologian tutkimuskeskus (Finland)TSV
This table contains the version history of the 'rajapinnat_gtk_kalliopera_wfsoku_kansannayteet__oku_kansannayteet' table sourced from the website of 'Geological Survey of Finland' in the country 'Finland'. It includes the extracted rows with additional columns such as '_start_date' and '_end_date'. Each row represents a specific version of the base table row, with '_start_date' indicating when the row was extracted, and '_end_date' showing the extraction date of the newer version. The table can be utilized for data analytics purposes, such as monitoring changes in the sampled points over time, analyzing spatial distribution, assessing sample types, and evaluating the organizations responsible for the samples.

Column Descriptions

Geological Survey of Finland Rock Properties Public Data - National Samples

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 unique identifier for the GML object.
objectid	int	The unique identifier for 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.
map_index	int	The index of the map.
district	string	The district where the location is located.
sample_type	string	The type of the sample.
sample_type_c10	string	The type of the sample with a length of maximum 10 characters.
organization	string	The organization responsible for the data.
geom_geojson	string	The geometry of the location in GeoJSON format.
geom_geotext	string	The geometry of the location in Geotext format.
geom_type	string	The type of 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 full geometry of the location.

Version History of Geological Survey Samples from Geologian tutkimuskeskus (Finland)

Column	Type	Comment
_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 unique row number identifier.
gml_id	string	The GML identifier of the row.
objectid	int	The identifier of the object.
northing	int	The northing coordinate value.
easting	int	The easting coordinate value.
northing_original	int	The original northing coordinate value.
easting_original	int	The original easting coordinate value.
sample_no	int	The sample number.
map_index	int	The index value of the map.
district	string	The district associated with the row.
sample_type	string	The type of the sample.
sample_type_c10	string	The type of the sample with a code 10 designation.
organization	string	The organization associated with the row.
geom_geojson	string	The geometry in GeoJSON format.
geom_geotext	string	The geometry in geotext format.
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.

Additional Info

Last Updated	April 22, 2024
Created	April 22, 2024