Public Transport Noise Levels in Helsinki, Finland

This dataset collection contains one or more dataset tables sourced from the website of Helsingin kaupunkiympariston toimiala in Finland.

Tables

History of Open Data Noise Survey 2017 Area 06 Tram Traffic L LAeq YO MeluSurvey 2017 Area 06 Tram Traffic L LAeq YO PolygonTSV
This table contains the version history of the 'avoindatameluselvitys_2017_alue_06_raitioliikenne_l_aeq_yo__meluselvitys_2017_alue_06_raitioliikenne_l_aeq_yopolygon' base table rows. It has two additional columns compared to its base table: '_start_date' which indicates the date when the row was extracted from the data source, and '_end_date' which indicates the date when a new version of the row was extracted. If the value in the '_end_date' column is null, it means that the row is the most recent version. The data in this table can be utilized for various data analytics purposes. For example, it can be used to analyze the changes in 'db_lo' and 'db_hi' values over time, track the updates made by 'datanomist', and analyze the spatial data represented by 'geom_geojson' and 'geom'. This...
Noise survey 2017 - Rail Traffic (Night Time) - Area 06TSV
The table 'avoindatameluselvitys_2017_alue_06_raitioliikenne_l_aeq_yo__meluselvitys_2017_alue_06_raitioliikenne_l_aeq_yopolygon' contains data from Helsingin kaupunkiympariston toimiala, which is a web site in Finland. It provides information related to noise assessment for public transportation based on the ISO country code 'fi'. The table includes 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', 'geom_center_y', and 'geom'. The data in this table can be utilized for data analytics purposes such as analyzing noise levels for different transportation routes, identifying areas with high or low noise pollution, calculating average noise levels, and...

Column Descriptions

Noise survey 2017 - Rail Traffic (Night Time) - Area 06

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The row number of the record.
id	int	The unique identifier of the record.
db_lo	int	The lower bound of the database range.
db_hi	int	The upper bound of the database range.
datanomist	string	The name of the data analyst.
paivitetty	string	The date of the last update of 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.
geom_center_x	double	The X component of the geometry's center.
geom_center_y	double	The Y component of the geometry's center.
geom	binary	The full geometry of the record in a specified format.

History of Open Data Noise Survey 2017 Area 06 Tram Traffic L LAeq YO MeluSurvey 2017 Area 06 Tram Traffic L LAeq YO Polygon

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 of the row.
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 scientist who created 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 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 point of the geometry for the row version.
geom_center_y	double	The Y-coordinate of the center point of the geometry for the row version.
geom	binary	The full geometry of the row version.

Additional Info

Last Updated	September 13, 2024
Created	October 21, 2018