Metro Läeq Noise Level Data in Helsinki

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

Tables

2017 Noise Assessment for Metro Line Aeq in Area 07, Helsinki, FinlandTSV
This table contains information from the avoindatameluselvitys_2017_alue_07_metro_l_aeq_paiva__meluselvitys_2017_alue_07_metro_l_aeq_paivapolygon dataset sourced from the website of Helsingin kaupunkiympariston toimiala. The dataset originates from Finland (ISO country code: fi). The table consists of various columns that provide data for data analytics purposes. The data can be utilized to analyze the noise levels in different areas and their impact. It can be used to identify high noise areas and plan noise reduction measures accordingly. Furthermore, the data can also be used to analyze the distribution of noise levels across different regions and identify patterns or trends. This information can be valuable for urban planning and decision-making processes. The table contains...
Version History of Metro Noise Study (2017) - Area 07 - Daily Equivalent Sound LevelTSV
This table contains the version history of rows from the 'avoindatameluselvitys_2017_alue_07_metro_l_aeq_paiva__meluselvitys_2017_alue_07_metro_l_aeq_paivapolygon' table. The rows in this history table are extracted from the data source provided by the 'Helsinki City Environment Sector' from Finland. It provides information about various aspects such as the start and end dates of each version of the row, the unique identifier 'id', database constraints 'db_lo' and 'db_hi', data custodian 'datanomist', and the date of the latest update 'paivitetty'. Additionally, it includes spatial information in different formats such as 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. The 'geom' column contains the geometric representation of the row....

Column Descriptions

2017 Noise Assessment for Metro Line Aeq in Area 07, Helsinki, Finland

Column	Type	Comment
_extract_date	date
_row_number	long
id	int
db_lo	int
db_hi	int
datanomist	string
paivitetty	string
geom_geojson	string
geom_geotext	string
geom_type	string
geom_centroid	string
geom_center_x	double
geom_center_y	double
geom	binary

Version History of Metro Noise Study (2017) - Area 07 - Daily Equivalent Sound Level

Column	Type	Comment
_start_date	date	The start date indicating when the row version becomes valid.
_end_date	date	The end date indicating when the row version becomes invalid.
_row_number	long	The ordinal number of the row version.
id	int	The unique identifier of the row.
db_lo	int	The lower boundary of the row version.
db_hi	int	The upper boundary of the row version.
datanomist	string	The name of the data analyst who updated the row version.
paivitetty	string	The date when the row version 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 in the row version.
geom_centroid	string	The centroid coordinate of the geometry in the row version.
geom_center_x	double	The x-coordinate of the center point of the geometry in the row version.
geom_center_y	double	The y-coordinate of the center point of the geometry in the row version.
geom	binary	The geometry of the row version.

Additional Info

Last Updated	September 13, 2024
Created	October 21, 2018