Map Usage in Helsinki, Finland

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

Tables

Land Use Polygon History from Helsingin kaupunkiympariston toimiala in FinlandTSV
This table contains the version history of the 'seutukarttamaankaytto__maankayttopolygon' table. The data in this table is sourced from the website of 'Helsinki City Environment Services' and originates from Finland (ISO country code: FI). The '_start_date' column represents the date when a row was extracted from the data source, while the '_end_date' column represents the date when a new version of the row was extracted. If the value in the '_end_date' column is null, it indicates that the corresponding row is the most recent version. The table contains various columns that store information related to land use polygons, their groups, geometry, and centroids. This historical data can be used for data analytics to analyze changes in land use patterns, track the evolution of different...
Land Use Polygons in Helsinki, FinlandTSV
This table contains geospatial data related to land use polygons in an area. The data is sourced from the website of the 'City Environment Sector' of Helsinki, Finland (ISO country code: FI). The table provides information on various attributes such as the extraction date, row number, land use category, land use group, the polygon's geometry in GeoJSON and geotext formats, the type of geometry, the centroid of the polygon, the X and Y coordinates of the polygon's center, and the full geometry. The table can be utilized in data analytics to analyze and study land use patterns, perform spatial queries, calculate spatial statistics, conduct clustering analysis, and visualize land use distributions.

Column Descriptions

Land Use Polygons in Helsinki, Finland

Column	Type	Comment
_extract_date	date	The date on which the data was extracted.
_row_number	long	An identifier for each row in the table.
maankay	string	The unique identifier for each object in the dataset.
mtryhm	int	The group to which the object belongs.
geom_geojson	string	The geometry of the object in GeoJSON format.
geom_geotext	string	The geometry of the object in Well-Known-Text (WKT) format.
geom_type	string	The type of geometry of the object (e.g., Point, LineString, Polygon).
geom_centroid	string	The centroid of the object's geometry.
geom_center_x	double	The x-coordinate of the center point of the object's geometry.
geom_center_y	double	The y-coordinate of the center point of the object's geometry.
geom	binary	The geometry of the object.

Land Use Polygon History from Helsingin kaupunkiympariston toimiala in Finland

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 of the row version.
maankay	string	Unknown description for column 'maankay'.
mtryhm	int	Unknown description for column 'mtryhm'.
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 of the geometry for the row version.
geom_center_y	double	The y-coordinate of the center of the geometry for the row version.
geom	binary	Unknown description for column 'geom'.

Additional Info

Last Updated	April 23, 2024
Created	October 22, 2018