Residential Areas in Helsinki, Finland

This dataset collection contains one or more dataset tables sourced from the website of Helsingin kaupunkiympariston toimiala in Finland.

Tables

Residential Area Polygon History from Helsinki City Environment Department, FinlandTSV
This table contains the version history of rows from the base table 'seutukarttaasuinalueet__asuinalueetpolygon'. The rows in this table represent different versions of the data extracted from the website of the 'City of Helsinki Environment Sector' in Finland. Each row in the table is identified by the columns '_start_date', '_end_date', and '_row_number'. The '_start_date' column contains the date when the row was extracted from the data source, while the '_end_date' column indicates the date when a new version of the row was extracted. If the value of the '_end_date' column is null, it means that the row is the most recent version. The table includes additional columns such as 'maankay', 'mtryhm', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and...
Residential Areas Polygon MapTSV
This table contains residential area polygons extracted from the dataset provided by Helsingin kaupunkiympariston toimiala, the urban environment department of the city of Helsinki, Finland. It includes information such as the extraction date, row number, land use category, land use group, spatial data in both GeoJSON and Geotext formats, geometry type, centroid coordinates, and the original geometry of the residential area. The data in this table can be utilized in various data analytics scenarios, such as analyzing the distribution of residential areas across the city, calculating the size and shape of each residential area, identifying the most common land use categories within residential areas, and studying the spatial relationships between different residential areas.

Column Descriptions

Residential Areas Polygon Map

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The number assigned to each row in the table.
maankay	string	The assigned ID number for a specific location.
mtryhm	int	The category or group that a location belongs to.
geom_geojson	string	The geometry of a location in GeoJSON format.
geom_geotext	string	The geometry of a location in text format.
geom_type	string	The type of geometry for a location.
geom_centroid	string	The centroid of the geometry for a location.
geom_center_x	double	The x-coordinate of the center point of the geometry for a location.
geom_center_y	double	The y-coordinate of the center point of the geometry for a location.
geom	binary	The full geometry object for a location.

Residential Area Polygon History from Helsinki City Environment Department, Finland

Column	Type	Comment
_start_date	date	Indicates the start date of the validity period for the row version.
_end_date	date	Indicates the end date of the validity period for the row version.
_row_number	long	A unique identifier for each row version in the table.
maankay	string	Unknown.
mtryhm	int	Unknown.
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 stored in the row.
geom_centroid	string	The centroid of the geometry in the row.
geom_center_x	double	The X-coordinate of the center of the geometry in the row.
geom_center_y	double	The Y-coordinate of the center of the geometry in the row.
geom	binary	The geometry of the row.

Additional Info

Last Updated	April 24, 2024
Created	October 21, 2018