Lake Land Use in Helsinki, Finland

The dataset belongs to a collection of tables sourced from the website of Helsingin kaupunkiympariston toimiala in Finland.

Tables

Lakes Land Use in Helsinki Metropolitan Area MapTSV
This table contains information about lakes from the dataset 'avoindataseutukartta_maankaytto_jarvet__seutukartta_maankaytto_jarvetpolygon', sourced from the website of the 'Helsinki City Environment Sector' in the country Finland (ISO country code: FI). The table includes various columns such as '_extract_date', '_row_number', 'vesisto_ni', 'vesisto_n0', 'mtryhm', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', 'geom', and 'tietopalve'. The data in this table can be utilized for data analytics purposes, such as analyzing the spatial distribution of lakes, studying different lake characteristics, calculating centroid coordinates, and performing geospatial analysis.
Version history of the 'Helsinki City Environment Department's dataset on land use in lakes - Helsinki City Environment Department's dataset on land use in lakes polygon', sourced from FinlandTSV
This table contains the version history of the rows in the 'avoindataseutukartta_maankaytto_jarvet__seutukartta_maankaytto_jarvetpolygon' table. It has two additional columns compared to its base table: '_start_date' and '_end_date'. The column '_start_date' indicates the date when the row was extracted from the data source, while the column '_end_date' indicates the date when a new version of the row was extracted. If the value of the column '_end_date' is null, it means that the row is the most recent version of the row. The table is sourced from the website of 'Helsinki City Environment Sector' which originates from Finland (country code: 'fi').

Column Descriptions

Lakes Land Use in Helsinki Metropolitan Area Map

Column	Type	Comment
_extract_date	date	The date and time when the data was extracted from the source.
_row_number	long	A unique identifier for each row in the table.
vesisto_ni	string	The identifier of the water system.
vesisto_n0	string	The unique identifier of the water system.
mtryhm	int	The type of the water system.
geom_geojson	string	The geometry of the water system in GeoJSON format.
geom_geotext	string	The geometry of the water system in Well-Known Text (WKT) format.
geom_type	string	The type of the geometry of the water system.
geom_centroid	string	The centroid point of the geometry of the water system.
geom_center_x	double	The x-coordinate of the center point of the geometry of the water system.
geom_center_y	double	The y-coordinate of the center point of the geometry of the water system.
geom	binary	The geometry of the water system.
tietopalve	int	The service that provided the information.

Version history of the 'Helsinki City Environment Department's dataset on land use in lakes - Helsinki City Environment Department's dataset on land use in lakes polygon', sourced from Finland

Column	Type	Comment
_start_date	date	The start date of the validity period for the row version in the table.
_end_date	date	The end date of the validity period for the row version in the table.
_row_number	long	The unique identifier for each row version in the table.
vesisto_ni	string	Unknown meaning column.
vesisto_n0	string	Unknown meaning column.
mtryhm	int	Unknown meaning column.
geom_geojson	string	The geometries of the rows in the table stored in GeoJSON format.
geom_geotext	string	The geometries of the rows in the table stored in Geotext format.
geom_type	string	The type of geometry for each row in the table.
geom_centroid	string	The centroid coordinates of the geometry for each row in the table.
geom_center_x	double	The x-coordinate of the center point of the geometry for each row in the table.
geom_center_y	double	The y-coordinate of the center point of the geometry for each row in the table.
geom	binary	The geometries of the rows in the table.
tietopalve	int	Unknown meaning column.

Additional Info

Last Updated	September 13, 2024
Created	June 15, 2018