lukeseal_islets - Islet Data Collection from Metsantutkimuslaitos in Finland

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

Tables

Seal Islets Data from Metsantutkimuslaitos (Finland)TSV
This table contains data from the 'Metsantutkimuslaitos' website, originating from Finland. It includes information related to seal islets. The table provides various attributes such as the extraction date, row number, unique identifier, geographic data in GeoJSON and GeoText formats, geometry type, centroid coordinates, center x and y coordinates, and the geometry itself. The data in this table can be utilized for various data analytics purposes, such as studying the spatial distribution of seal islets, analyzing the changes in islet characteristics over time, calculating the distance between islets, and performing geospatial analysis to understand the relationship between islet features and other environmental factors.
Seal Islets HistoryTSV
The 'lukeseal_isletsseal_isletshistory' table contains the version history of the 'lukeseal_islets__seal_islets' table. It tracks changes to the rows of the base table by including two additional columns: '_start_date' and '_end_date'. The '_start_date' column represents the date when a specific version of a row was extracted from the data source, while the '_end_date' column contains the date when a new version of the row was extracted. If the value in the '_end_date' column is null, it indicates that the row is the most recent version. This table can be utilized in data analytics to analyze the evolution of seal islets over time, track changes in their geographic locations, or study trends in their characteristics. The data in this table is sourced from the website of...

Column Descriptions

Seal Islets Data from Metsantutkimuslaitos (Finland)

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The row number of the data entry.
id	int	The unique identifier of the record.
geom_geojson	string	The geometry of the record in GeoJSON format.
geom_geotext	string	The geometry of the record in well-known text (WKT) format.
geom_type	string	The type of geometry of the record.
geom_centroid	string	The centroid of the geometry of the record.
geom_center_x	double	The x-coordinate of the center of the geometry of the record.
geom_center_y	double	The y-coordinate of the center of the geometry of the record.
geom	binary	The full geometry object of the record.

Seal Islets History

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 sequential number assigned to each row version.
id	int	The unique identifier of 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 stored in the row version.
geom_centroid	string	The centroid of the geometry in the row version.
geom_center_x	double	The X-coordinate of the center of the geometry in the row version.
geom_center_y	double	The Y-coordinate of the center of the geometry in the row version.
geom	binary	The geometry in the row version.

Additional Info

Last Updated	April 23, 2024
Created	September 10, 2018