Comprehensive dataset collection from Helsingin kaupunkiympariston toimiala in Finland

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

Tables

Helsinki Metropolitan Basic Map - Basic PolygonsTSV
This table contains data from 'City of Helsinki Environment Sector' website. It represents the basic polygons of the Helsinki Metropolitan Area. The table contains various attributes such as '_extract_date' which represents the date of extraction, '_row_number' which represents the row number, 'kokotun' representing the total area, 'kunta' representing the municipality, 'suur' representing the region, 'perus' representing the basic, 'nimi' representing the name, 'nimi_iso' representing the ISO name, 'mtryhm' representing the measurement group, 'geom_geojson' representing the geometry in GeoJSON format, 'geom_geotext' representing the geometry in geotext format, 'geom_type' representing the type of geometry, 'geom_centroid' representing the centroid of the geometry, 'geom_center_x'...
History of Basic Map Polygons in Helsinki City RegionTSV
The table provides the version history of rows from the 'avoindataseutukartta_hel_perus__seutukartta_hel_peruspolygon' base table sourced from the web site of 'Helsinki City Planning Department' in Finland ('FI'). It contains information about various attributes like 'kokotun', 'kunta', 'suur', 'perus', 'nimi', 'nimi_iso', 'mtryhm', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', 'geom', and 'tietopalve'. The table includes additional columns '_start_date' and '_end_date', representing the extraction dates of the row versions. Utilizing this data, various data analytics tasks can be performed, such as analyzing the changes in attributes over time, identifying trends or patterns, comparing versions, and predicting future changes in the...

Column Descriptions

Helsinki Metropolitan Basic Map - Basic Polygons

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The unique identifier of each row.
kokotun	int	The name of the town.
kunta	int	The name of the municipality.
suur	int	The size of the object.
perus	int	The basic property of the object.
nimi	string	The name of the object.
nimi_iso	string	The ISO code of the object's name.
mtryhm	int	The group of the object.
geom_geojson	string	The geometry data of the object in GeoJSON format.
geom_geotext	string	The text representation of the geometry data.
geom_type	string	The type of the geometry data.
geom_centroid	string	The centroid of the geometry data.
geom_center_x	double	The x-coordinate of the center of the geometry data.
geom_center_y	double	The y-coordinate of the center of the geometry data.
geom	binary	The full geometry data.
tietopalve	int	The service information of the data.

History of Basic Map Polygons in Helsinki City Region

Column	Type	Comment
_start_date	date	The date when the row version starts to be valid.
_end_date	date	The date when the row version stops being valid.
_row_number	long	The unique number assigned to each row version.
kokotun	int	The value representing the 'kokotun' attribute of the row.
kunta	int	The value representing the 'kunta' attribute of the row.
suur	int	The value representing the 'suur' attribute of the row.
perus	int	The value representing the 'perus' attribute of the row.
nimi	string	The value representing the 'nimi' attribute of the row.
nimi_iso	string	The ISO representation of the 'nimi' attribute of the row.
mtryhm	int	The value representing the 'mtryhm' attribute of the row.
geom_geojson	string	The geographic JSON representation of the geometry.
geom_geotext	string	The geotext representation of the geometry.
geom_type	string	The type of the geometry.
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 spatial representation of the geometry.
tietopalve	int	The value representing the 'tietopalve' attribute of the row.

Additional Info

Last Updated	September 13, 2024
Created	May 6, 2018