Open water sources in Helsinki, Finland

The dataset collection consists of one or more dataset tables sourced from the website of Helsingin kaupunkiympariston toimiala in Finland.

Tables

Version History of Open Water Sources (Polygon) in Helsinki, FinlandTSV
This table contains the version history of the 'ltj_avoinvesi_lahteet__vesi_lahteetpolygon' table rows. The rows in this table represent different versions of the data extracted from the web site of 'Helsinki Urban Environment Division'. The data originates from Finland (ISO country code 'fi'). The table includes columns '_start_date' and '_end_date' which indicate the extraction timestamps for each row version. The other columns of the table hold various attributes and metadata related to the water sources. The data in this table can be utilized in data analytics for various purposes such as analyzing the changes in water source characteristics over time, studying the distribution and classification of water sources, and examining the spatial properties of the water sources.
Water Sources - Helsinki City Environment Department, FinlandTSV
This table contains data about open water sources in Helsinki, Finland. The data is sourced from the website of Helsingin kaupunkiympariston toimiala. The table includes information such as the extract date, row number, ID, class code, class name, name, description, notes, digitalization date, editing date, area, target text, metadata, GeoJSON geometry, GeoText geometry, geometry type, centroid geometry, centroid x-coordinate, centroid y-coordinate, and raw geometry data. Examples of how the data in this table could be utilized in data analytics include analyzing the distribution of open water sources across Helsinki, calculating the average area of different classes of water sources, or finding the nearest water source to a given location.

Column Descriptions

Water Sources - Helsinki City Environment Department, Finland

Column	Type	Comment
_extract_date	date	The date the data was extracted
_row_number	long	The row number of the data
id	int	The identifier of the table row
tunnus	int	The tunnus value
luokkatunn	string	The luokkatunn value
luokan_nim	string	The name of the luokan
nimi	string	The name
kuvaus	string	The description
huom	string	The additional note
digipvm	string	The digipvm value
pvm_editoi	string	The pvm_editoi value
pinta_ala	float	The pinta_ala value
kohdetekst	string	The kohdetekst value
metadata	string	The metadata information
geom_geojson	string	The geometry in GeoJSON format
geom_geotext	string	The geotext for 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 geometry

Version History of Open Water Sources (Polygon) in Helsinki, Finland

Column	Type	Comment
_start_date	date	The start date of the validity period of the row version.
_end_date	date	The end date of the validity period of the row version.
_row_number	long	The row number of the version history.
id	int	The unique identifier of the row.
tunnus	int	The tunnus value of the row.
luokkatunn	string	The luokkatunn value of the row.
luokan_nim	string	The luokan_nim value of the row.
nimi	string	The nimi value of the row.
kuvaus	string	The kuvaus value of the row.
huom	string	The huom value of the row.
digipvm	string	The digital date of the row.
pvm_editoi	string	The date when the row was edited.
pinta_ala	float	The pinta_ala value of the row.
kohdetekst	string	The kohdetekst value of the row.
metadata	string	The metadata associated with the row.
geom_geojson	string	The row's geometry in GeoJSON format.
geom_geotext	string	The row's geometry in Geotext format.
geom_type	string	The type of the row's geometry.
geom_centroid	string	The centroid of the row's geometry.
geom_center_x	double	The x-coordinate of the center of the row's geometry.
geom_center_y	double	The y-coordinate of the center of the row's geometry.
geom	binary	The geometry of the row.

Additional Info

Last Updated	April 23, 2024
Created	October 22, 2018