Avoin data: Land Use and Rivers Map in Helsinki, Finland

This dataset collection consists of one or more dataset tables sourced from the website of 'Helsingin kaupunkiympäristön toimiala' in Finland. It provides spatial data related to land use and rivers.

Tables

Land use rivers in the Helsinki Metropolitan AreaTSV
This table contains information about land use and rivers in the Helsinki metropolitan area. The data is sourced from the website of the Helsinki City Environment Sector, which originates from Finland (ISO country code: FI). The table includes fields such as extract date, row number, land use category, land use group, geometry in GeoJSON format, geometry in Geotext format, geometry type, centroid of the geometry, centroid x-coordinate, centroid y-coordinate, raw geometry data, and data service information. This data can be utilized for various data analytics purposes such as analyzing land use patterns, studying river distributions, calculating land area within different usage categories, and performing spatial analysis on the geometry data using geographic information system (GIS) tools.
Version History of River Land Use Polygons in Helsingin kaupunkiympariston toimiala, FinlandTSV
This table contains the version history of rows from the 'avoindataseutukartta_maankaytto_joet__seutukartta_maankaytto_joetpolygon' table. It includes additional columns '_start_date' and '_end_date' to indicate when each version of a row was extracted from the data source. The table has various columns such as 'maankaytto', 'mtryhm', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', 'geom', and 'tietopalve'. These columns contain different attributes related to the land use, geometry, and information services of the geographical features. The data in this table can be utilized in data analytics to analyze temporal changes in land use patterns, identify trends in different land use categories, perform spatial analysis on the geographic...

Column Descriptions

Land use rivers in the Helsinki Metropolitan Area

Column	Type	Comment
_extract_date	date	The date and time when the data was extracted.
_row_number	long	The unique identifier for each row in the table.
maankaytto	string	The land use category or designation for a particular area.
mtryhm	int	The land use group or category that the area belongs to.
geom_geojson	string	The geometry of the area in GeoJSON format.
geom_geotext	string	The text representation of the geometry of the area.
geom_type	string	The type of geometry for the area, such as point, line, or polygon.
geom_centroid	string	The centroid point of the area.
geom_center_x	double	The x-coordinate of the center point of the area.
geom_center_y	double	The y-coordinate of the center point of the area.
geom	binary	The native geometry type for the area.
tietopalve	int	The source or provider of the data.

Version History of River Land Use Polygons in Helsingin kaupunkiympariston toimiala, Finland

Column	Type	Comment
_start_date	date	The start date indicating the beginning of the validity period for the row version.
_end_date	date	The end date indicating the end of the validity period for the row version.
_row_number	long	A unique identifier for each 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 text 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	Additional information or data related to the row version.

Additional Info

Last Updated	September 13, 2024
Created	May 6, 2018