Land Use and Built-up Areas Dataset Collection

The dataset collection consists of one or more dataset tables sourced from the website of Helsingin kaupunkiympäristön toimiala (City of Helsinki Urban Environment Division) in Finland.

Tables

Urban Area Land Use and Built-up Areas Polygon Map DatasetTSV
This table contains data on land use and built-up areas in the Helsinki metropolitan region. The data is sourced from the website of Helsingin kaupunkiympäristön toimiala, which is the Department of Urban Environment of the city of Helsinki in Finland (ISO country code: FI). The table includes information such as the extraction date and row number, land use category, land use group, and various geometric properties of the land areas. This data can be utilized for various data analytics purposes, such as analyzing the distribution of land use categories, studying the relationship between land use and other variables, or mapping and visualizing land use patterns in the Helsinki metropolitan region.
Version History of Land Use Built-up Areas in Helsinki Metropolitan AreaTSV
The table contains the version history of the base table rows of 'avoindataseutukartta_maankaytto_rakennetut_alueet__seutukartta_maankaytto_rakennetut_alueetpolygon'. It has two additional columns, '_start_date' and '_end_date', denoting the extraction dates of the rows from the data source. The table is sourced from the website of 'Helsinki City Environment Sector' in Finland.

Column Descriptions

Urban Area Land Use and Built-up Areas Polygon Map Dataset

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The row number of the data entry.
maankaytto	string	The land use of the location.
mtryhm	int	The group category of the location.
geom_geojson	string	The geographic information of the location in GeoJSON format.
geom_geotext	string	The geographic information of the location in Geotext format.
geom_type	string	The type of the geographic shape of the location.
geom_centroid	string	The centroid coordinates of the geographic shape of the location.
geom_center_x	double	The x-coordinate of the center of the location.
geom_center_y	double	The y-coordinate of the center of the location.
geom	binary	The complete geographic information of the location.
tietopalve	int	The information service of the location.

Version History of Land Use Built-up Areas in Helsinki Metropolitan Area

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 number identifying the row version in the table.
maankaytto	string	The land use associated with the row version.
mtryhm	int	The land use group associated with the row version.
geom_geojson	string	The geometry of the row version in GeoJSON format.
geom_geotext	string	The geometry of the row version in Geotext format.
geom_type	string	The type of 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 of the row version.
tietopalve	int	The data source for the row version.

Additional Info

Last Updated	September 13, 2024
Created	May 6, 2018