Road Traffic Noise Level Survey 2012 - Area 01, Finland

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

Tables

Road Traffic Noise Survey Data 2012 for Area 01 in Helsinki, FinlandTSV
This table contains data from the 'Helsinki Urban Environment Sector' website, which originates from the country Finland (ISO country code: FI). The table provides information related to noise measurements in road traffic areas. The dataset includes various attributes such as the extraction date, row number, unique identifier, noise levels (in decibels) recorded in low and high ranges, data owner, update date, geographic information in different formats (geoJSON, geotext), geometry type, centroid coordinates (X and Y), and the geometry itself. The data in this table can be utilized for various data analytics purposes, for example, studying noise pollution patterns in specific geographic areas, analyzing the impact of road traffic on noise levels, identifying areas with high noise...
Version History of Helsingin kaupunkiympariston toimiala Road Traffic Noise Survey 2012 Area 01 (L-Aeq_Paiva) Data - FinlandTSV
The table contains the version history of the base table rows sourced from the website of Helsingin kaupunkiympariston toimiala. The base table, avoindatameluselvitys_2012_alue_01_tieliikenne_l_aeq_paivameluselvitys_2012_alue_01_tieliikenne_l_aeq_paivapolygon, serves as the main table for this history table. The history table, avoindatameluselvitys_2012_alue_01_tieliikenne_l_aeq_paivameluselvitys_2012_alue_01_tieliikenne_l_aeq_paivapolygon__history, includes two additional columns compared to its base table: '_start_date' which contains the date when the row was extracted from the data source, and '_end_date' which contains the date when a new version of the row was extracted. If the value of the column '_end_date' is null, it indicates that the row is the most recent version of the...

Column Descriptions

Road Traffic Noise Survey Data 2012 for Area 01 in Helsinki, Finland

Column	Type	Comment
_extract_date	date	The date when the data was extracted from the source
_row_number	long	A 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 a database range
db_hi	int	The upper bound value of a database range
datanomist	string	The name of the data owner
paivitetty	string	The date 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 GeoText 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 full geometry object

Version History of Helsingin kaupunkiympariston toimiala Road Traffic Noise Survey 2012 Area 01 (L-Aeq_Paiva) Data - Finland

Column	Type	Comment
_start_date	date	The start date of the validity period of the row version.
_end_date	date	The end date of the validity period of the row version.
_row_number	long	The row number of the version in the table.
id	int	The unique identifier of the row version in the table.
db_lo	int	The low part of the database identifier of the row version.
db_hi	int	The high part of the database identifier of the row version.
datanomist	string	The name of the data scientist associated with the row version.
paivitetty	string	The timestamp indicating when the row version was last updated.
geom_geojson	string	The geometry of the row version in GeoJSON format.
geom_geotext	string	The text representation of the geometry of the row version.
geom_type	string	The type of the geometry of the row version.
geom_centroid	string	The centroid of the geometry of the row version.
geom_center_x	double	The X coordinate of the centroid of the geometry of the row version.
geom_center_y	double	The Y coordinate of the centroid of the geometry of the row version.
geom	binary	The complete geometry of the row version.

Additional Info

Last Updated	September 13, 2024
Created	April 23, 2024