Cultural Data on Helsinki City Environment - 2017

The dataset collection consists of one or more dataset tables sourced from the web site of Helsingin kaupunkiympäristön toimiala in Finland.

Tables

History of Helsinki Noise AreasTSV
This table contains the version history of the base table rows extracted from the 'Helsingin kaupunkiympariston toimiala' data source. The table, named 'avoindatamelualueet_2017_14_maant_hki_lyomelualueet_2017_14_maant_hki_lyopolygonhistory', stores the historical versions of the rows and includes two additional columns: '_start_date' and '_end_date'. The '_start_date' column signifies the date when a particular row was extracted from the data source, while the '_end_date' column represents the date when a new version of the row was extracted. If the value in the '_end_date' column is null, it indicates that the row is the most recent version. The table consists of several other columns including 'id', 'db_lo', 'db_hi', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext',...
Noise Areas in Helsinki (2017)TSV
This table contains data on noise areas in Helsinki, Finland. The data is sourced from 'Helsinki Urban Environment Division' through the website. The table includes various attributes such as the extraction date, row number, ID, lower and upper decibel values, data owner, last updated date, geometry in GeoJSON and Geotext formats, geometry type, centroid coordinates, and the complete geometry. The table can be utilized in various data analytics applications, such as analyzing noise pollution levels in different areas, studying the impact of noise on urban environments, identifying high noise areas for urban planning, and assessing the effectiveness of noise reduction measures.

Column Descriptions

Noise Areas in Helsinki (2017)

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	Unique identifier for each entry.
db_lo	float	The lower bound of the database.
db_hi	float	The upper bound of the database.
datanomist	string	The name of the data scientist.
paivitetty	date	Date and time of the last update.
geom_geojson	string	The geometry of the data in GeoJSON format.
geom_geotext	string	The geometry of the data in Geotext format.
geom_type	string	The type of geometry data.
geom_centroid	string	The centroid of the geometry data.
geom_center_x	double	The X-coordinate of the center of the geometry data.
geom_center_y	double	The Y-coordinate of the center of the geometry data.
geom	binary	The raw geometry data.

History of Helsinki Noise Areas

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

Additional Info

Last Updated	April 23, 2024
Created	July 8, 2018