Dataset Collection of 'avoindatamelualueet_2017_04_maant_hki_laeq22_7_yo_npm' from Helsingin kaupunkiympariston toimiala in Finland

This dataset collection consists of one or more dataset tables sourced from the website of 'Helsingin kaupunkiympariston toimiala' in Finland. The tables in this collection provide valuable information about Helsinki's municipal areas and their corresponding noise levels recorded in April 2017. The recordings were measured using the equivalent sound level (LAeq) metric with a threshold of 22.7 dB(A) during the day and evening time. The dataset tables encompass various aspects of the municipal areas, including their names, geographical coordinates, noise levels, and nighttime noise pollution measurements (NPM). These tables offer great insights into the noise levels and environmental conditions in different parts of Helsinki. Explore this dataset collection to analyze the noise pollution patterns and make informed decisions related to urban planning, infrastructure development, and environmental conservation.

Tables

Noise Areas in Helsinki, Finland (April 2017)TSV
This table contains data from the 'Helsinki City Environment Department' in Finland. The table provides information about noise areas in Helsinki, specifically the average sound pressure level (in Decibels) in different regions. The table includes various attributes such as the extraction date, row number, unique identifier, data bounds, data source, last updated date, geometric coordinates in different formats, geometric type, centroid coordinates, and the complete geometry. The data in this table can be utilized in various data analytics tasks, such as analyzing the noise pollution levels at different locations, identifying areas with high or low noise levels, comparing sound pressure levels over time, and investigating the relationship between noise and other factors like population...
Version History of Noise Areas for Helsinki, FinlandTSV
This table contains the version history of the rows in the 'avoindatamelualueet_2017_04_maant_hki_laeq22_7_yo_npm__melualueet_2017_04_maant_hki_laeq227_yo_npmpolygon' table. It is sourced from the website of 'Helsinki City Environment Sector', which originates from Finland (ISO country code: 'fi'). The '_start_date' column indicates the date when a row was extracted from the data source, while the '_end_date' column indicates the date when a new version of the row was extracted. If the '_end_date' value is null, it means that the row is the most recent version. The table includes additional columns such as 'id', 'db_lo', 'db_hi', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y', which provide various pieces of...

Column Descriptions

Noise Areas in Helsinki, Finland (April 2017)

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The row number of the data point.
id	int	The unique identifier of the entry.
db_lo	float	The lower bound value of the data range.
db_hi	float	The upper bound value of the data range.
datanomist	string	The name of the data analyst.
paivitetty	date	The date when the entry was last updated.
geom_geojson	string	The geometry of the entry in GeoJSON format.
geom_geotext	string	The geometry of the entry in Geotext format.
geom_type	string	The type of geometry for the entry.
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 of the entry.

Version History of Noise Areas for Helsinki, Finland

Column	Type	Comment
_start_date	date	A column indicating the starting date of the validity period for the row version.
_end_date	date	A column indicating the ending date of the validity period for the row version.
_row_number	long	A column containing the row number of the version history.
id	int	The unique identifier for each row in the table.
db_lo	float	A low-level database identifier.
db_hi	float	A high-level database identifier.
datanomist	string	The data owner for the row.
paivitetty	date	A timestamp indicating when the row was last updated.
geom_geojson	string	The geometry of the row in a GeoJSON format.
geom_geotext	string	The geometry of the row in a geotext format.
geom_type	string	The type of geometry for the row.
geom_centroid	string	The centroid of the geometry for the row.
geom_center_x	double	The x-coordinate of the center point of the geometry for the row.
geom_center_y	double	The y-coordinate of the center point of the geometry for the row.
geom	binary	The full geometry data for the row.

Additional Info

Last Updated	September 13, 2024
Created	April 23, 2024