Green Areas in Districts (Seutukartta)

This dataset collection, sourced from the website of Helsingin kaupunkiympariston toimiala [Helsinki City Environment Sector], consists of one or more dataset tables. The tables provide information about green areas in the city of Helsinki, Finland.

Tables

Green Areas (Polygons) in Helsinki, FinlandTSV
This table contains data about green areas in the region of Helsinki, Finland. The data is sourced from the website of Helsingin kaupunkiympariston toimiala, which is the Environmental Department of the City of Helsinki. The table consists of various columns including the extraction date of the data, row number, land use category, area type category, geographic JSON representation, geographic text representation, geographic type, centroid of the geographic area, center x coordinate of the area, center y coordinate of the area, and the overall geographic representation. The data in this table can be utilized for various data analytics purposes, such as analyzing the distribution of green areas across different land use categories, studying the relationship between area types and...
Version History of Green Areas PolygonsTSV
This table contains the version history of the 'seutukarttaviheralueetviheralueetpolygon' table, sourced from the website of 'Helsinki City Environment Sector'. The data originates from Finland (ISO country code 'fi'). The table includes additional columns compared to its base table, namely '_start_date' and '_end_date', which represent the extraction dates of each row. This version history table can be used for data analytics purposes, such as tracking changes over time, analyzing trends, or comparing different versions of the 'seutukarttaviheralueetviheralueetpolygon' rows.

Column Descriptions

Green Areas (Polygons) in Helsinki, Finland

Column	Type	Comment
_extract_date	date	The date when this row was extracted.
_row_number	long	The unique number assigned to each row.
maankay	string	The identifier for a specific maankay.
mtryhm	int	The group to which the maankay belongs.
geom_geojson	string	The geometry of the maankay in GeoJSON format.
geom_geotext	string	The geometry of the maankay in Geotext format.
geom_type	string	The type of the maankay's geometry.
geom_centroid	string	The centroid of the maankay's geometry.
geom_center_x	double	The x-coordinate of the center point of the maankay's geometry.
geom_center_y	double	The y-coordinate of the center point of the maankay's geometry.
geom	binary	The original geometry of the maankay.

Version History of Green Areas Polygons

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 or identifier of the version.
maankay	string	The value of the 'maankay' attribute.
mtryhm	int	The value of the 'mtryhm' attribute.
geom_geojson	string	The GeoJSON representation of the geometry.
geom_geotext	string	The geotext representation of the geometry.
geom_type	string	The type of geometry, e.g., Point, LineString, Polygon.
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 geometry itself.

Additional Info

Last Updated	September 13, 2024
Created	October 21, 2018