Helsinki Metropolitan Area Seaside Map - Data Collection

The dataset collection consists of one or more dataset tables sourced from the website of Helsingin kaupunkiympäristön toimiala in Finland.

Tables

Regional Map of Coastal Shoreline in Open Data Area - Helsinki City Environment Sector - FinlandTSV
This table contains data from 'Helsinki City Environment Sector' website. It provides information about the land use, line classification, geometry, and other attributes related to the coastline in Helsinki area. The data is sourced from Finland (ISO country code: 'fi'). This table can be utilized in various data analytics tasks such as analyzing the distribution of land use categories along the coastline, examining the spatial patterns of coastline geometry, identifying clusters of specific line classifications, and exploring the relationship between land use and geographical features.
Version History of Sea Shorelines in Open Data Regional Map of Helsinki, FinlandTSV
This table contains the version history of rows from the base table 'avoindataseutukartta_meren_rantaviivaseutukartta_meren_rantaviivaline'. The table includes additional columns '_start_date' and '_end_date' which represent the extraction dates for each row. The data in this table is sourced from the website of Helsingin kaupunkiympariston toimiala, which originates from Finland (ISO country code 'fi'). The table can be utilized in data analytics to analyze historical changes and updates to the 'avoindataseutukartta_meren_rantaviivaseutukartta_meren_rantaviivaline' data. It provides insights into temporal patterns, trends, and updates related to 'maankaytto', 'mtryhm', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', 'geom', and...

Column Descriptions

Regional Map of Coastal Shoreline in Open Data Area - Helsinki City Environment Sector - Finland

Column	Type	Comment
_extract_date	date	The date when data was extracted from the source.
_row_number	long	A unique identifier for each row in the table.
maankaytto	string	The land use category of a geographic area.
mtryhm	int	The land use group of a geographic area.
geom_geojson	string	The geometry of a geographic area in GeoJSON format.
geom_geotext	string	The geometry of a geographic area in Geotext format.
geom_type	string	The type of geometry of a geographic area.
geom_centroid	string	The centroid of the geometry of a geographic area.
geom_center_x	double	The x-coordinate of the center of the geometry of a geographic area.
geom_center_y	double	The y-coordinate of the center of the geometry of a geographic area.
geom	binary	The geometry of a geographic area in a specific format.
tietopalve	int	An indicator for the data collection service used.

Version History of Sea Shorelines in Open Data Regional Map of Helsinki, 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 identifier for each row version.
maankaytto	string	The land use attribute for the row version.
mtryhm	int	The municipality group attribute for the row version.
geom_geojson	string	The geometry data in GeoJSON format for the row version.
geom_geotext	string	The geometry data in Geotext format for the row version.
geom_type	string	The type of the 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 point of the geometry for the row version.
geom_center_y	double	The y-coordinate of the center point of the geometry for the row version.
geom	binary	The geometry data for the row version.
tietopalve	int	The data service attribute for the row version.

Additional Info

Last Updated	September 13, 2024
Created	May 6, 2018