Open Data Urban Areas 2017 - Helsinki Metropolitan Area - Noise Level 4m

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

Tables

Noise Areas Metropolitan Helsinki Region 2017TSV
This table contains data from 'Helsinki City Environment Sector', which originates from Finland. It provides information on noise areas in the city. The data includes various attributes such as the extraction date, row number, identifier, noise level ranges, data source, update date, geometric data, and more. The table can be utilized in data analytics to analyze and visualize the distribution of noise levels in different areas of the city, identify areas with high noise levels, assess the impact of noise pollution on the population, and evaluate the effectiveness of noise reduction measures.
Version History of Avoindatamelualueet Metro Lden4m Melualueet Polygon 2017-17 MVYOH 3.1 from Helsingin kaupunkiympariston toimiala in FinlandTSV
This table contains the version history of the rows from the 'avoindatamelualueet_2017_17_mvyoh_3_1_metro_lden4mmelualueet_2017_17_mvyoh_3_1_metro_lden4mpolygon' table. The rows in this table are extracted from the data source provided by 'Helsinki City Environment Sector'. The data originates from Finland (ISO country code 'fi'). Each row in this history table represents a specific version of a row from the base table. The '_start_date' column stores the date when the version of the row was extracted, while the '_end_date' column stores the date of the next version extraction. If the '_end_date' value is null, it means that the row is the most recent version. The table can be used for various data analytics purposes, such as tracking changes in the base table over time, analyzing...

Column Descriptions

Noise Areas Metropolitan Helsinki Region 2017

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The index of the row in the table.
id	int	The unique identifier for each record in the table.
db_lo	float	The lower bound value of a range.
db_hi	float	The upper bound value of a range.
datanomist	string	The name of the data owner.
paivitetty	date	The date of the last update.
geom_geojson	string	The geometry data in GeoJSON format.
geom_geotext	string	The geometry data 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-coordinate of the center of the geometry.
geom_center_y	double	The Y-coordinate of the center of the geometry.
geom	binary	The detailed geometry information.

Version History of Avoindatamelualueet Metro Lden4m Melualueet Polygon 2017-17 MVYOH 3.1 from Helsingin kaupunkiympariston toimiala in Finland

Column	Type	Comment
_start_date	date	Column indicating the start date of the validity period for the row version.
_end_date	date	Column indicating the end date of the validity period for the row version.
_row_number	long	Column representing the sequential number assigned to each row version.
id	int	Unique identifier for each row version.
db_lo	float	Lower bound value for the database reference of the row version.
db_hi	float	Higher bound value for the database reference of the row version.
datanomist	string	Name or identifier of the data analyst who made changes to the row version.
paivitetty	date	Timestamp indicating the date and time when the row version was last updated.
geom_geojson	string	Geometry attribute stored in GeoJSON format.
geom_geotext	string	Geometry attribute stored in Geotext format.
geom_type	string	Type of geometry representing the shape of the spatial object.
geom_centroid	string	Coordinates of the centroid point for the spatial object.
geom_center_x	double	X-coordinate of the center point for the spatial object.
geom_center_y	double	Y-coordinate of the center point for the spatial object.
geom	binary	Spatial representation of the object's geometry.

Additional Info

Last Updated	April 23, 2024
Created	July 8, 2018