Metro L Aeq Yo - 2017 Area 08 Public Data Collection

This dataset collection, sourced from the website of Helsingin kaupunkiympäristön toimiala, consists of one or more dataset tables. The tables contain data related to the Helsinki metropolitan area in Finland. The dataset collection name is avoindatameluselvitys_2017_alue_08_metro_l_aeq_yo.

Tables

Noise Survey 2017 - Metro Area L Aeq YoTSV
This table contains data from 'Helsinki City Environment Sector' website. The data is sourced from Finland (ISO country code 'fi'). The table provides information related to the noise survey conducted in the metro area of Helsinki in 2017. It includes details such as the extract date, row number, unique identifier, noise level ranges (low and high), data analyst, last updated date, geographic information in GeoJSON and Geotext formats, geometry type, centroid coordinates, and the geometry of the area. The data in this table can be utilized for various data analytics purposes, such as analyzing noise levels in different areas, identifying patterns or trends in noise pollution, studying the impact of noise on urban environments, and conducting spatial analysis on the metro area of Helsinki.
Version history of Metro Noise Study Polygon data in Helsinki, FinlandTSV
This table contains the version history of the rows from the 'avoindatameluselvitys_2017_alue_08_metro_l_aeq_yo__meluselvitys_2017_alue_08_metro_l_aeq_yopolygon' table. The rows in this table represent different versions of the base table rows, which were extracted from the data source. The '_start_date' column indicates the date when each row was extracted, while the '_end_date' column indicates the date when a new version of the row was extracted. If the '_end_date' is null, it means that the row is the most recent version. The table is sourced from the website of 'Helsinki Urban Environment Division', which originates from Finland (ISO country code 'fi'). The table contains various columns including 'id', 'db_lo', 'db_hi', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext',...

Column Descriptions

Noise Survey 2017 - Metro Area L Aeq Yo

Column	Type	Comment
_extract_date	date	The date when the record was extracted.
_row_number	long	The sequence number of the row.
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 data owner of the record.
paivitetty	string	The date when the record was last updated.
geom_geojson	string	The geographical information of the record in GeoJSON format.
geom_geotext	string	The geographical information of the record in Geotext format.
geom_type	string	The type of geometry of the record.
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 Metro Noise Study Polygon data in Helsinki, Finland

Column	Type	Comment
_start_date	date	This column indicates the start date of the validity period of the row version.
_end_date	date	This column indicates the end date of the validity period of the row version.
_row_number	long	This column represents the row number of the version history entry.
id	int	This column contains the unique identifier of the row version.
db_lo	int	This column stores the lower part of a double precision number.
db_hi	int	This column stores the higher part of a double precision number.
datanomist	string	This column contains information about the data analyst.
paivitetty	string	This column indicates the date of the last update.
geom_geojson	string	This column stores the geometry data in GeoJSON format.
geom_geotext	string	This column stores the geometry data in geotext format.
geom_type	string	This column indicates the type of the geometry data.
geom_centroid	string	This column stores the centroid of the geometry data.
geom_center_x	double	This column stores the x-coordinate of the center of the geometry data.
geom_center_y	double	This column stores the y-coordinate of the center of the geometry data.
geom	binary	This column stores the geometry data in a specific format.

Additional Info

Last Updated	September 13, 2024
Created	October 21, 2018