Traffic Noise Level Data for Helsingin kaupunkiympariston toimiala in Finland

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

Tables

Road Traffic Noise Survey 2007 - Area 01: Road Traffic Noise Level (LAeq, day)TSV
The table contains data related to environmental noise assessment in the road traffic domain. It is sourced from the website of Helsingin kaupunkiympäristön toimiala, which is the urban environment sector of the City of Helsinki, in Finland. The table provides information such as the extract date, row number, data service, lower and upper decibel levels, data analyst, update date, geographic data in both GeoJSON and Geotext formats, geometry type, centroid coordinates, and the geometry itself. The data in this table can be utilized for various data analytics purposes such as studying noise levels in different areas, identifying noise hotspots, analyzing noise patterns over time, and evaluating the impact of noise on the environment.
Version history of road traffic noise survey areas for day-time average sound level in Helsinki, FinlandTSV
This table contains the version history of rows from the 'avoindatameluselvitys_2007_alue_01_tieliikenne_l_aeq_paiva__meluselvitys_2007_alue_01_tieliikenne_l_aeq_paivapolygon' table, sourced from the website of Helsingin kaupunkiympariston toimiala. The data originates from Finland (ISO country code 'fi'). It includes the start date and end date of each row, along with other columns such as 'tietopalve', 'db_lo', 'db_hi', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. The 'geom' column represents the geometry of the polygon. The table can be utilized in data analytics to track the historical changes in the data, analyze trends over time, and compare different versions of the rows.

Column Descriptions

Road Traffic Noise Survey 2007 - Area 01: Road Traffic Noise Level (LAeq, day)

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The unique identifier for each row in the table.
tietopalve	int	The name of the information service.
db_lo	int	The lower bound of the database.
db_hi	int	The upper bound of the database.
datanomist	string	The name of the data provider.
paivitetty	string	The date and time when the data was last updated.
geom_geojson	string	The geometry column in GeoJSON format.
geom_geotext	string	The text description of the geometry.
geom_type	string	The type of the geometry (e.g., point, line, polygon).
geom_centroid	string	The centroid point 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 spatial data column.

Version history of road traffic noise survey areas for day-time average sound level in Helsinki, Finland

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 number assigned to the row version.
tietopalve	int	The type of data service provided by the table.
db_lo	int	The lower boundary value for the database.
db_hi	int	The upper boundary value for the database.
datanomist	string	The person responsible for the data.
paivitetty	string	The date the data was last updated.
geom_geojson	string	The geometry of the row version in GeoJSON format.
geom_geotext	string	The geometry of the row version in Geotext 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 of the geometry for the row version.
geom_center_y	double	The y-coordinate of the center of the geometry for the row version.
geom	binary	The geometry for the row version.

Additional Info

Last Updated	September 13, 2024
Created	April 23, 2024