Underwater Pollution in Helsinki, Finland

This dataset collection consists of one or more tables sourced from the web site of Helsingin kaupunkiympariston toimiala in Finland.

Tables

Underwater Pollution - Water - Helsinki City Environment Department, FinlandTSV
This table contains data on underwater pollution in open waters. It is sourced from the website of Helsingin kaupunkiympariston toimiala, a department in the City of Helsinki, Finland. The data is related to environmental monitoring and includes information such as the extraction date, row number, identification code, class identification, class name, name, description, notes, digital date, date of edit, surface area, target text, metadata, geometry in GeoJSON format, geometry in Geotext format, geometry type, centroid of geometry, x-coordinate of centroid, y-coordinate of centroid, and the raw geometry data.
Water Subaquatic Contamination - Water Subaquatic Contamination Point - Version HistoryTSV
This table contains the version history of rows from the ltj_avoinvesi_vedenalainen_roskaantuminen__vesi_vedenalainen_roskaantuminenpoint base table. The rows in this table represent different versions of the data extracted from the web site of Helsingin kaupunkiympariston toimiala, which is the environmental sector of the city of Helsinki in Finland. Each row in the table has a start date (_start_date) indicating when the particular version of the row was extracted, and an end date (_end_date) indicating the date when a new version of the row was extracted. If a row has a null value in the _end_date column, it means that it is the most recent version of the row. The table contains several columns storing information about the data, including unique identifiers (id), codes (tunnus,...

Column Descriptions

Underwater Pollution - Water - Helsinki City Environment Department, Finland

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The unique identifier for each row.
id	int	The unique identifier for each record.
tunnus	int	The code associated with the record.
luokkatunn	string	The class code of the record.
luokan_nim	string	The name of the class.
nimi	string	The name of the record.
kuvaus	string	The description of the record.
huom	string	Any additional remarks or comments regarding the record.
digipvm	string	The digital date associated with the record.
pvm_editoi	string	The date when the record was edited.
pinta_ala	int	The area of the record in square units.
kohdetekst	string	The text associated with the record.
metadata	string	Any additional metadata related to the record.
geom_geojson	string	The geometry of the record in GeoJSON format.
geom_geotext	string	The geometry of the record in geotext format.
geom_type	string	The type of the geometry.
geom_centroid	string	The centroid of the geometry of the record.
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 full geometry of the record.

Water Subaquatic Contamination - Water Subaquatic Contamination Point - Version History

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 row number of the version in the table.
id	int	The unique identifier for each row version.
tunnus	int	The unique identifier for the row in the base table.
luokkatunn	string	The identifier for the class of the row.
luokan_nim	string	The name of the class of the row.
nimi	string	The name of the row.
kuvaus	string	The description of the row.
huom	string	Additional notes or comments about the row.
digipvm	string	The digital date of the row.
pvm_editoi	string	The date when the row was edited.
pinta_ala	int	The surface area of the row.
kohdetekst	string	The target text of the row.
metadata	string	Metadata related to the row.
geom_geojson	string	The geometry of the row in GeoJSON format.
geom_geotext	string	The geometry of the row in Geotext format.
geom_type	string	The type of geometry for the row.
geom_centroid	string	The centroid of the geometry of the row.
geom_center_x	double	The x-coordinate of the center of the geometry of the row.
geom_center_y	double	The y-coordinate of the center of the geometry of the row.
geom	binary	The geometry of the row.

Additional Info

Last Updated	April 24, 2024
Created	October 22, 2018