Geological Survey of Finland - Soil and Aerial Photographs

This dataset collection consists of one or more dataset tables sourced from the Geologian tutkimuskeskus website in Finland.

Tables

Photographs of Geological Survey of Finland Soil Material - Web Feature ServiceTSV
This table contains data from the 'Geological Survey of Finland' website for the country Finland (ISO country code 'FI'). The table provides information on various attributes related to photographs taken at specific locations. The data includes attributes such as the extraction date, row number, GML ID, object ID, latitude and longitude coordinates, observation and photograph IDs, photograph capture time, link to the photograph, distance from the object in meters, photograph direction, any additional remarks, geographic data in GeoJSON and Geotext formats, type of geometry, centroid coordinates, and the original geometry. This table can be utilized in various data analytics tasks such as spatial analysis, identifying trends in photograph capture time, analyzing the relationship between...
Version History of Valokuva Table from Geologian tutkimuskeskus in FinlandTSV
This table contains the version history of the rows in the 'Geological Survey of Finland (GTK) Photo Service - Aerial Photos' base table. It provides information about the historical versions of each row, including the '_start_date' and '_end_date' which indicate when the row was extracted from the data source. The table includes various columns such as 'gml_id', 'objectid', 'pohjoiskoordinaatti', 'itakoordinaatti', 'havaintotunnus', 'valokuvatunnus', 'kuvausaika', 'valokuva_linkki', 'etaisyys_kohteesta_metria', 'kuvaussuunta', 'huomautukset', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. These columns contain valuable data that can be utilized in data analytics. For example, the 'valokuva_linkki' column provides links to the actual...

Column Descriptions

Photographs of Geological Survey of Finland Soil Material - Web Feature Service

Column	Type	Comment
_extract_date	date	The date the data was extracted.
_row_number	long	The row number of the record.
gml_id	string	The ID of the record in GML format.
objectid	int	The unique identifier of the record.
pohjoiskoordinaatti	int	The northern coordinate of the location.
itakoordinaatti	int	The eastern coordinate of the location.
havaintotunnus	string	The observation code.
valokuvatunnus	string	The photo code.
kuvausaika	int	The time when the photo was taken.
valokuva_linkki	string	The link to the photo.
etaisyys_kohteesta_metria	int	The distance from the object in meters.
kuvaussuunta	int	The direction of the photo.
huomautukset	string	Any additional comments or notes.
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 full geometry of the record.

Version History of Valokuva Table from Geologian tutkimuskeskus in 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 row number of the version history.
gml_id	string	The GML identifier of the row.
objectid	int	The identifier of the object.
pohjoiskoordinaatti	int	The Northern coordinate of the location.
itakoordinaatti	int	The Eastern coordinate of the location.
havaintotunnus	string	The observation code.
valokuvatunnus	string	The photograph code.
kuvausaika	int	The time of the photograph.
valokuva_linkki	string	The link to the photograph.
etaisyys_kohteesta_metria	int	The distance from the object in meters.
kuvaussuunta	int	The direction of the photograph.
huomautukset	string	Any additional remarks or comments.
geom_geojson	string	The geometry of the row in GeoJSON format.
geom_geotext	string	The geometry of the row 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 point of the geometry.
geom_center_y	double	The Y-coordinate of the center point of the geometry.
geom	binary	The geometry of the row.

Additional Info

Last Updated	April 22, 2024
Created	April 22, 2024