Dataset Collection: Avoindatamelualueet_2017_16_mvyoh_1_2_raitio_lyo4m

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

Noise Areas in Helsinki - 2017TSV
The table 'avoindatamelualueet_2017_16_mvyoh_1_2_raitio_lyo4m__melualueet_2017_16_mvyoh_1_2_raitio_lyo4mpolygon' contains data sourced from the website of 'Helsinki City Environment Department' in Finland. It provides information about noise areas with various attributes. The table can be utilized in data analytics to analyze the distribution and extent of noise pollution in Helsinki, study the impact of noise on different areas, identify areas with high noise levels, and assess the effectiveness of noise reduction measures implemented in the city.
Version History of Noise Areas in Helsinki City AreaTSV
The avoindatamelualueet_2017_16_mvyoh_1_2_raitio_lyo4mmelualueet_2017_16_mvyoh_1_2_raitio_lyo4mpolygonhistory table contains the version history of the avoindatamelualueet_2017_16_mvyoh_1_2_raitio_lyo4m__melualueet_2017_16_mvyoh_1_2_raitio_lyo4mpolygon base table. It includes additional columns '_start_date' and '_end_date' which represent the extraction dates of each row. This table has various columns such as 'id', 'db_lo', 'db_hi', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. Instead of describing individual columns, let's explore some potential data analytics use cases. For example, analysts could use this table to track changes in the noise area polygons over time, identify when and where updates...

Column	Type	Comment
_extract_date	date	The date when the data was extracted
_row_number	long	The row number of the data entry
id	int	The unique identifier of the data entry
db_lo	float	The lower bound of a range value in the database
db_hi	float	The higher bound of a range value in the database
datanomist	string	The name of the data analyst who processed the data
paivitetty	date	The date when the data entry was last updated
geom_geojson	string	The geometry of the data entry in GeoJSON format
geom_geotext	string	The geometry of the data entry in text format
geom_type	string	The type of geometry used in the data entry
geom_centroid	string	The centroid of the geometry in the data entry
geom_center_x	double	The X-coordinate of the centroid of the geometry
geom_center_y	double	The Y-coordinate of the centroid of the geometry
geom	binary	The full geometry data of the entry

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 version history table.
id	int	The unique identifier of the row.
db_lo	float	The lower part of the database reference.
db_hi	float	The higher part of the database reference.
datanomist	string	The name of the data analyst.
paivitetty	date	The date the row was last updated.
geom_geojson	string	The geometry of the row in GeoJSON format.
geom_geotext	string	The geotext representation of the row's geometry.
geom_type	string	The type of geometry for the row.
geom_centroid	string	The centroid of the row's geometry.
geom_center_x	double	The x-coordinate of the center of the row's geometry.
geom_center_y	double	The y-coordinate of the center of the row's geometry.
geom	binary	The full geometry representation of the row.

Last Updated	September 13, 2024
Created	July 8, 2018