Public Transport Noise Levels in Helsinki, Finland

This dataset collection consists of tables sourced from the website of Helsingin kaupunkiympäristön toimiala in Finland. It contains data related to the avoindatameluselvitys_2017_alue_05_raitioliikenne_l_aeq_paiva dataset collection.

Tables

Noise study 2017 - Tram traffic L_Aeq daily sound level in area 5 - HelsinkiTSV
This table contains data from the dataset 'Helsinki City Environment Department' available on their website. The data originates from Finland, which has the ISO country code 'FI'. The table 'avoindatameluselvitys_2017_alue_05_raitioliikenne_l_aeq_paiva__meluselvitys_2017_alue_05_raitioliikenne_l_aeq_paivapolygon' includes information regarding noise surveys conducted in 2017 for areas related to tram traffic. The table consists of various columns such as '_extract_date', '_row_number', 'id', 'db_lo', 'db_hi', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. The data in this table could be utilized in data analytics to study the noise levels in different tram traffic areas, analyze the impact of noise on the...
Version History of Noise Study - Raitiolinja L AEQ Daily Sound Assessment for Area 05 - FinlandTSV
This table contains the version history of the base table rows sourced from the web site of Helsingin kaupunkiympariston toimiala in Finland. The data in this table is related to 'avoindatameluselvitys_2017_alue_05_raitioliikenne_l_aeq_paiva__meluselvitys_2017_alue_05_raitioliikenne_l_aeq_paivapolygon' table. The table includes information such as the start date and end date of each row version, the row number, unique identifier 'id', 'db_lo', 'db_hi', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. These columns can be utilized for various data analytics purposes, such as analyzing the temporal changes in the data, identifying the data owner and the last update date, examining the geographical information...

Column Descriptions

Noise study 2017 - Tram traffic L_Aeq daily sound level in area 5 - Helsinki

Column	Type	Comment
_extract_date	date	The date and time when the data was extracted.
_row_number	long	The unique identifier for each row in the table.
id	int	The unique identifier for each record in the table.
db_lo	int	The lower bound value of the primary key.
db_hi	int	The upper bound value of the primary key.
datanomist	string	The name of the person or organization who provided the data.
paivitetty	string	The date and time when the record was last updated.
geom_geojson	string	The geometry of the record in GeoJSON format.
geom_geotext	string	The geometry of the record in textual format.
geom_type	string	The type of 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 of the record.

Version History of Noise Study - Raitiolinja L AEQ Daily Sound Assessment for Area 05 - Finland

Column	Type	Comment
_start_date	date	The date and time when the row version starts being valid.
_end_date	date	The date and time when the row version stops being valid.
_row_number	long	The number assigned to each row version.
id	int	The unique identifier of each row version.
db_lo	int	The lower part of the database identifier.
db_hi	int	The higher part of the database identifier.
datanomist	string	The name of the data analyst who modified the row version.
paivitetty	string	The date and time 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 of the geometry in the row version.
geom_center_x	double	The x-coordinate of the center of the geometry in the row version.
geom_center_y	double	The y-coordinate of the center of the geometry in the row version.
geom	binary	The geometry of the row version.

Additional Info

Last Updated	April 23, 2024
Created	November 22, 2018