Geological Survey of Finland - Coordinate-based Rock Operations

The dataset collection consists of one or more dataset tables sourced from the website of 'Geological Survey of Finland' in Finland.

Tables

Coordinate-based Sandstone Data from Geological Survey of FinlandTSV
This table contains data from the 'Geological Survey of Finland' website. It consists of various fields such as '_extract_date', '_row_number', 'gml_id', 'objectid', 'arkistonumero_arkistotunnus', 'tunnus_tarra', 'originaali_havaintonro_naytenr', 'hietyyppi', 'vuosiluku', 'havaintonumero', 'karttalehti_100k_kkj', 'karttalehti_20k_kkj', 'karttalehti_50k_utm', 'pohjoiskoordinaatti_epsg3067', 'itakoordinaatti_epsg3067', 'pohjoiskoordinaatti_kkj', 'itakoordinaatti_kkj', 'hieen_sailytyspaikka', 'alkuperainen_omistaja', 'kivilaji', 'kivilaji_alkuperainen', 'hiesyvyys_metri', 'paikka', 'kairareikatunnus', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. This table provides valuable data for data analytics purposes such as geological research,...
Historical Version History of Coordination-based Sand Table - Geologian tutkimuskeskus (Finland)TSV
This table contains the version history of the base table rows from the 'Geological Survey of Finland' website. It includes the '_start_date' column, which indicates the date when the row was extracted, and the '_end_date' column, which shows the date when a new version of the row was extracted. If the '_end_date' value is null, it means that the row is the most recent version. The table includes various columns such as 'gml_id', 'objectid', 'arkistonumero_arkistotunnus', 'tunnus_tarra', 'originaali_havaintonro_naytenr', 'hietyyppi', 'vuosiluku', 'havaintonumero', 'karttalehti_100k_kkj', 'karttalehti_20k_kkj', 'karttalehti_50k_utm', 'pohjoiskoordinaatti_epsg3067', 'itakoordinaatti_epsg3067', 'pohjoiskoordinaatti_kkj', 'itakoordinaatti_kkj', 'hieen_sailytyspaikka',...

Column Descriptions

Coordinate-based Sandstone Data from Geological Survey of Finland

Column	Type	Comment
_extract_date	date	The date when the data was extracted
_row_number	long	The row number of the record
gml_id	string	The ID in GML format
objectid	int	The unique object ID
arkistonumero_arkistotunnus	string	The archive number
tunnus_tarra	string	The label number
originaali_havaintonro_naytenr	float	The original observation number
hietyyppi	string	The type of sand
vuosiluku	int	The year
havaintonumero	float	The observation number
karttalehti_100k_kkj	int	The map sheet index in KKJ 100k
karttalehti_20k_kkj	int	The map sheet index in KKJ 20k
karttalehti_50k_utm	string	The map sheet index in UTM 50k
pohjoiskoordinaatti_epsg3067	int	The northern coordinate in EPSG 3067
itakoordinaatti_epsg3067	int	The eastern coordinate in EPSG 3067
pohjoiskoordinaatti_kkj	int	The northern coordinate in KKJ
itakoordinaatti_kkj	int	The eastern coordinate in KKJ
hieen_sailytyspaikka	string	The place of sand storage
alkuperainen_omistaja	string	The original owner
kivilaji	string	The rock type
kivilaji_alkuperainen	string	The original rock type
hiesyvyys_metri	float	The depth of sand in meters
paikka	string	The location
kairareikatunnus	int	The drillhole identifier
geom_geojson	string	The geometry in GeoJSON format
geom_geotext	string	The geometry 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 geometry center
geom_center_y	double	The Y-coordinate of the geometry center
geom	binary	The geometry

Historical Version History of Coordination-based Sand Table - 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 sequential number of the row version in the table.
gml_id	string	The ID associated with the row version in GML format.
objectid	int	The unique identifier for the row version.
arkistonumero_arkistotunnus	string	The archive number of the row version.
tunnus_tarra	string	The label identifier for the row version.
originaali_havaintonro_naytenr	float	The original observation number or sample number for the row version.
hietyyppi	string	The type of sand for the row version.
vuosiluku	int	The year associated with the row version.
havaintonumero	float	The observation number for the row version.
karttalehti_100k_kkj	int	The 100k KKJ map sheet associated with the row version.
karttalehti_20k_kkj	int	The 20k KKJ map sheet associated with the row version.
karttalehti_50k_utm	string	The 50k UTM map sheet associated with the row version.
pohjoiskoordinaatti_epsg3067	int	The north coordinate in EPSG 3067 for the row version.
itakoordinaatti_epsg3067	int	The east coordinate in EPSG 3067 for the row version.
pohjoiskoordinaatti_kkj	int	The north coordinate in KKJ for the row version.
itakoordinaatti_kkj	int	The east coordinate in KKJ for the row version.
hieen_sailytyspaikka	string	The storage location of the sand for the row version.
alkuperainen_omistaja	string	The original owner of the row version.
kivilaji	string	The type of rock for the row version.
kivilaji_alkuperainen	string	The original type of rock for the row version.
hiesyvyys_metri	float	The depth of the sand in meters for the row version.
paikka	string	The location of the row version.
kairareikatunnus	int	The drill hole identifier for the row version.
geom_geojson	string	The geometry of the row version in GeoJSON format.
geom_geotext	string	The geometry of the row version in Geotext format.
geom_type	string	The type of geometry for the row version.
geom_centroid	string	The centroid of the geometry for the row version.
geom_center_x	double	The x-coordinate of the center of the geometry for the row version.
geom_center_y	double	The y-coordinate of the center of the geometry for the row version.
geom	binary	The geometry for the row version.

Additional Info

Last Updated	April 22, 2024
Created	April 22, 2024