Geospatial Data Collection for Helsinki Urban Environment Sector in Finland

The dataset collection consists of one or more dataset tables sourced from 'Helsingin kaupunkiympariston toimiala' website in Finland.

Tables

2017 Noise Survey Area 03 Road L_eq Daily (with Polygon)TSV
This table contains data from the website of 'Helsinki City Environment Sector' in Finland. It provides information related to environmental noise levels for different areas in the year 2017. The data includes various attributes such as the extract date, row number, unique identifier, noise levels in decibels (low and high), data source, last updated date, geographical representation in GeoJSON and Geotext formats, the type of geometry, centroid coordinates, and the complete geometric representation. This table can be utilized in data analytics to analyze trends and patterns in noise pollution across different areas in Helsinki, perform spatial analysis to identify areas with high noise levels, assess the impact of noise pollution on the environment, and derive insights for urban...
Version History of Meluselvitys 2017 Alue 03 Maantiet L Aeq Paiva PolygonTSV
This table contains the version history of the rows extracted from the data source 'Helsingin kaupunkiympariston toimiala', which originates from the country Finland (FI). The table is a historical record of the base table 'avoindatameluselvitys_2017_alue_03_maantiet_l_aeq_paiva__meluselvitys_2017_alue_03_maantiet_l_aeq_paivapolygon'. It includes additional columns '_start_date' and '_end_date' which indicate the extraction dates of each row. The table provides insights into the data changes over time. The data in this table can be utilized for data analytics purposes, such as studying the evolution of noise survey areas, tracking updates made by the data custodian, or analyzing the geographic characteristics of the surveyed regions. Please refer to the specific column descriptions for...

Column Descriptions

2017 Noise Survey Area 03 Road L_eq Daily (with Polygon)

Column	Type	Comment
_extract_date	date	The date the row was extracted.
_row_number	long	The row number in the table.
id	int	The unique identifier of the row.
db_lo	int	The lower bound value of the database.
db_hi	int	The upper bound value of the database.
datanomist	string	The name of the data analyst.
paivitetty	string	The date the row was last updated.
geom_geojson	string	The geometry information in GeoJSON format.
geom_geotext	string	The geometry information in geotext format.
geom_type	string	The type of geometry used.
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 information.

Version History of Meluselvitys 2017 Alue 03 Maantiet L Aeq Paiva Polygon

Column	Type	Comment
_start_date	date	The start date indicating the validity period of the row version.
_end_date	date	The end date indicating the validity period of the row version.
_row_number	long	The row number of the version history.
id	int	The identifier of the row version.
db_lo	int	The lower part of the database index.
db_hi	int	The higher part of the database index.
datanomist	string	The data analyst responsible for the row version.
paivitetty	string	The date and time of the version update.
geom_geojson	string	The geometry of the row version in GeoJSON format.
geom_geotext	string	The geometry of the row version in Geotext format.
geom_type	string	The type of geometry of the row version.
geom_centroid	string	The centroid of the geometry of the row version.
geom_center_x	double	The x-coordinate of the center point of the geometry of the row version.
geom_center_y	double	The y-coordinate of the center point of the geometry of the row version.
geom	binary	The full geometry of the row version.

Additional Info

Last Updated	September 13, 2024
Created	October 21, 2018