City of Helsinki Environmental Services Sector Dataset Collection

This dataset collection contains one or more dataset tables sourced from the website of Helsingin kaupunkiympariston toimiala in Finland.

Tables

Noise Survey Data for Area 14 Road Network at Night - 2017TSV
This table contains data from 'Helsinki City Environment Sector' which is sourced from Finland. It represents the data related to noise surveys conducted in 2017 for road segments in area 14. The table provides information such as the extraction date, row number, unique identifier, lower and upper decibel values, data owner, date of update, geographical data in GeoJSON and GeoText format, type of geometry, centroid of the geometry, center coordinates of the geometry, and the geometry itself. This data can be used for various data analytics purposes such as studying noise pollution patterns, analyzing noise levels in different road segments, identifying areas with higher noise levels, and conducting spatial analysis related to noise pollution.
Version History of Meluselvitys 2017 Alue 14 Maantiet L Yo PolygonTSV
This table contains the version history of the rows in the 'avoindatameluselvitys_2017_alue_14_maantiet_l_yo__meluselvitys_2017_alue_14_maantiet_l_yopolygon' table. The rows in this table represent different versions of the base table rows, each extracted from the data source on a specific date. The columns of this table include '_start_date' which indicates the date when the row was extracted, and '_end_date' which indicates the date when a new version of the row was extracted. If the value of '_end_date' is null, it means that the row is the most recent version. The remaining columns in this table contain various attributes related to the data, such as 'id', 'db_lo', 'db_hi', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and...

Column Descriptions

Noise Survey Data for Area 14 Road Network at Night - 2017

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

Version History of Meluselvitys 2017 Alue 14 Maantiet L Yo Polygon

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

Additional Info

Last Updated	September 13, 2024
Created	October 21, 2018