Geographical Areas of Helsinki, Finland

This dataset collection contains one or more dataset tables sourced from the website of Helsingin kaupunkiympäristön toimiala in Finland.

Tables

Helsinki Environmental Department's Noise Areas Data for 2017TSV
This table contains data from the 'Helsinki City Environment' department in Finland. It provides information about noise areas in Helsinki in the year 2017. The data includes various fields such as the extraction date, row number, unique identifier, database low value, database high value, data source, last updated date, geographic polygons in both GeoJSON and Geotext formats, geographic type, centroid coordinates, and full geographic representation. This table can be utilized in data analytics to perform analysis on noise levels in different areas of Helsinki, identify patterns in noise distribution, compare noise levels between different parts of the city, and analyze the impact of noise on various factors such as property values or human well-being.
Version History of Area Noise Areas in Helsinki - Data Source: Helsinki City Environment Sector (Finland)TSV
This table contains the version history of rows from the 'avoindatamelualueet_2017_13_maant_hki_lden__melualueet_2017_13_maant_hki_ldenpolygon' base table. It has additional columns '_start_date' and '_end_date' representing the extraction dates of the row versions. The data in this table is sourced from the website of Helsingin kaupunkiympäristön toimiala, which originates from the country Finland (ISO country code 'fi'). The table provides valuable data that can be utilized for various data analytics purposes, such as studying the noise areas in Helsinki based on different time periods, analyzing changes in noise levels over time, identifying areas with significant noise variations, and exploring spatial patterns of noise pollution in the city.

Column Descriptions

Helsinki Environmental Department's Noise Areas Data for 2017

Column	Type	Comment
_extract_date	date	The date when the data was extracted
_row_number	long	The number of the row in the table
id	int	The unique identifier of the record
db_lo	float	The lower bound of the database range
db_hi	float	The upper bound of the database range
datanomist	string	The name of the data analyst who processed the data
paivitetty	date	The date when the record was last updated
geom_geojson	string	The geographic information in GeoJSON format
geom_geotext	string	The textual representation of the geographic information
geom_type	string	The type of the geographic information
geom_centroid	string	The centroid of the geographic information
geom_center_x	double	The x-coordinate of the center of the geographic information
geom_center_y	double	The y-coordinate of the center of the geographic information
geom	binary	The geometry of the geographic information

Version History of Area Noise Areas in Helsinki - Data Source: Helsinki City Environment Sector (Finland)

Column	Type	Comment
_start_date	date	The start date of the validity period for the row version in the table.
_end_date	date	The end date of the validity period for the row version in the table.
_row_number	long	The number assigned to each row version in the table.
id	int	The unique identifier for each row in the table.
db_lo	float	A lower bound value for the range of values for a given row.
db_hi	float	An upper bound value for the range of values for a given row.
datanomist	string	The name of the data custodian for the row version.
paivitetty	date	The date and time when the row version was last updated.
geom_geojson	string	The geometry of the row version in GeoJSON format.
geom_geotext	string	The geometry of the row version in text format.
geom_type	string	The type of geometry for the row version.
geom_centroid	string	The centroid of the geometry for the row version.
geom_center_x	double	The x-coordinate of the center point of the geometry for the row version.
geom_center_y	double	The y-coordinate of the center point of the geometry for the row version.
geom	binary	The geometry of the row version.

Additional Info

Last Updated	September 13, 2024
Created	July 8, 2018