Road Traffic Noise Level Survey 2017 - Area 02

The dataset collection 'avoindatameluselvitys_2017_alue_02_tieliikenne_l_aeq_yo' consists of one or more dataset tables sourced from the website of the 'Helsinki City Environment Sector' in Finland.

Tables

Road Traffic Noise Survey 2017 Area 02 - Noise Study for Road Traffic L-Aeq Night-Time LevelsTSV
This table contains data from the 'Helsinki Urban Environment Division' website for the country Finland (ISO country code 'fi'). It provides information related to noise surveys conducted in 2017 for road traffic in certain areas. The table includes columns such as the extraction date, row number, unique identifier, noise levels in decibels (low and high values), data custodian, last updated date, geographic information in both GeoJSON and GeoText formats, geometry type, centroid coordinates, and the complete geometry information. This data can be utilized for various data analytics purposes such as analyzing noise pollution levels in different areas, identifying areas with high noise levels, and studying the impact of road traffic on noise pollution.
Version History of Road Traffic Noise Survey for Area 02 in Helsinki, FinlandTSV
This table represents the version history of the 'avoindatameluselvitys_2017_alue_02_tieliikenne_l_aeq_yo__meluselvitys_2017_alue_02_tieliikenne_l_aeq_yopolygon' table sourced from the website of 'Helsinki City Environment Sector'. The data in this table originates from Finland (FI). It contains historical versions of the base table rows, with each row having '_start_date' and '_end_date' columns indicating the extraction dates from the data source. The table also includes other columns such as 'id', 'db_lo', 'db_hi', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', and 'geom'. These columns provide useful information for data analytics and can be utilized for various purposes such as analyzing the changes in the...

Column Descriptions

Road Traffic Noise Survey 2017 Area 02 - Noise Study for Road Traffic L-Aeq Night-Time Levels

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The row number of the data.
id	int	The unique identifier of the entry.
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 analyst.
paivitetty	string	The timestamp when the data was last updated.
geom_geojson	string	The geometry in GeoJSON format.
geom_geotext	string	The geometry 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 complete geometry.

Version History of Road Traffic Noise Survey for Area 02 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 of the row version.
id	int	The unique identifier of the row.
db_lo	int	The lower part of a double precision value.
db_hi	int	The higher part of a double precision value.
datanomist	string	The name of the data analyst.
paivitetty	string	The date and time when the row version was updated.
geom_geojson	string	The geometry in GeoJSON format.
geom_geotext	string	The geometry in Geotext format.
geom_type	string	The type of the geometry.
geom_centroid	string	The centroid point of the geometry.
geom_center_x	double	The x-coordinate of the center point of the geometry.
geom_center_y	double	The y-coordinate of the center point of the geometry.
geom	binary	The geometry in a spatial format.

Additional Info

Last Updated	September 13, 2024
Created	October 21, 2018