Drainage basins and catchment areas of rivers and lakes in Helsinki, Finland

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

Tables

Version History of Water Drainage Areas - Source: Helsinki City Environment Department, FinlandTSV
This table contains the version history of the 'ltj_avoinvesi_purojen_ja_lampien_valuma_alueet__vesi_purojen_ja_lampien_valuma_alueetpolygon' table. It has additional columns '_start_date' and '_end_date', which indicate the start and end dates of each row's version. The data in this table is sourced from the website of 'Helsinki City Environment Sector', which originates from Finland (ISO country code 'fi'). The table provides information that can be used for various data analytics purposes, such as analyzing the changes in 'pinta_ala' (surface area) over time, understanding the spatial distribution of 'nimi' (name) across different versions, examining the 'kuvaus' (description) of each version, and exploring the geographic attributes like 'geom_type' and 'geom_centroid', which can be...
Water runoff areas - Streams and PondsTSV
This table contains data on open water areas, brooks, and flowing water areas. It includes information such as the date of extraction, row number, unique identifier, class code, class name, name, description, remarks, digital date, editing date, surface area, target text, metadata, geojson format geometry, geotext format geometry, geometry type, centroid of geometry, center x-coordinate of geometry, center y-coordinate of geometry, and geometry itself. The data in this table can be utilized for various data analytics purposes such as studying the distribution and characteristics of open water areas, brooks, and flowing water areas in Helsingin kaupunkiympariston toimiala, which is a data source available on the website of Helsinki City Environment Sector. This data source originates...

Column Descriptions

Water runoff areas - Streams and Ponds

Column	Type	Comment
_extract_date	date	The date on which the row was extracted.
_row_number	long	A unique identifier for each row in the table.
id	int	The unique identifier for each record in the table.
tunnus	string	A code or identifier for each record.
luokkatunn	string	A code or identifier for the class.
luokan_nim	string	The name of the class.
nimi	string	The name of the record or object.
kuvaus	string	A description or summary of the record or object.
huom	string	Additional notes or comments about the record or object.
digipvm	string	The date on which the record was created or digitized.
pvm_editoi	string	The date on which the record was last edited or modified.
pinta_ala	float	The surface area of the object in square units.
kohdetekst	string	Additional text or details about the object.
metadata	string	Metadata or additional information about the record or object.
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.
geom_centroid	string	The centroid of the geometry of the object.
geom_center_x	double	The x-coordinate of the center of the geometry of the object.
geom_center_y	double	The y-coordinate of the center of the geometry of the object.
geom	binary	The geometry of the object.

Version History of Water Drainage Areas - Source: Helsinki City Environment Department, Finland

Column	Type	Comment
_start_date	date	The start date indicating the validity period of the row version.
_end_date	date	The end date indicating the validity period of the row version.
_row_number	long	The row number indicating the version history order.
id	int	The unique identifier of the table row.
tunnus	string	The identifier of the table row.
luokkatunn	string	The class identifier of the table row.
luokan_nim	string	The name of the class of the table row.
nimi	string	The name of the table row.
kuvaus	string	The description of the table row.
huom	string	The additional information of the table row.
digipvm	string	The digital date of the table row.
pvm_editoi	string	The date when the table row was edited.
pinta_ala	float	The surface area of the table row.
kohdetekst	string	The target text of the table row.
metadata	string	The metadata of the table row.
geom_geojson	string	The geometry in GeoJSON format of the table row.
geom_geotext	string	The geometry in GeoText format of the table row.
geom_type	string	The type of the geometry of the table row.
geom_centroid	string	The centroid of the geometry of the table row.
geom_center_x	double	The X-coordinate of the center of the geometry of the table row.
geom_center_y	double	The Y-coordinate of the center of the geometry of the table row.
geom	binary	The geometry of the table row.

Additional Info

Last Updated	September 13, 2024
Created	October 22, 2018