Road Traffic at Night in Helsinki, Finland (2012)

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

Tables

Road Traffic Noise Survey 2012 Area 08 Night-TimeTSV
This table contains data from 'Helsinki City Environment Department', sourced from the country Finland (FI). It provides information related to noise study areas for road traffic during night time. The data includes various attributes such as the extraction date, row number, unique identifier, noise decibels (low and high), data custodian, last updated date, geographical representation in both GeoJSON and Geotext formats, geometry type, centroid coordinates, center point coordinates, and the geometry itself. This table can be utilized for data analytics purposes, such as analyzing noise pollution patterns, determining noise exposure levels, and assessing the impact of road traffic noise on the surrounding environment.
Version History of Road Traffic Night Noise Survey (2012) in Area 08, FinlandTSV
This table contains the version history of rows from the 'avoindatameluselvitys_2012_alue_08_tieliikenne_l_yo__meluselvitys_2012_alue_08_tieliikenne_l_yopolygon' base table. It has additional columns '_start_date' and '_end_date' which represent the extraction dates of the rows. The data in this table is sourced from the website of 'Helsinki City Environment Sector' which originates from the country Finland (ISO country code: 'fi'). The table contains various columns related to the extracted data, such as 'id', 'db_lo', 'db_hi', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. The data in this table can be used for various data analytics purposes, such as analyzing the change in noise levels over time,...

Column Descriptions

Road Traffic Noise Survey 2012 Area 08 Night-Time

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

Version History of Road Traffic Night Noise Survey (2012) in Area 08, Finland

Column	Type	Comment
_start_date	date	The start date indicating the beginning of the validity period of the row version.
_end_date	date	The end date indicating the end of the validity period of the row version.
_row_number	long	The number assigned to each row in the version history table.
id	int	The unique identifier of each row in the base table.
db_lo	int	The low-order bits of the DB_ID of the versioned object.
db_hi	int	The high-order bits of the DB_ID of the versioned object.
datanomist	string	The name of the data analyst responsible for the version.
paivitetty	string	The date and time when the version was last updated.
geom_geojson	string	The geometry of the object in the GeoJSON format.
geom_geotext	string	The geometry of the object in the GeoText format.
geom_type	string	The type of geometry of the object.
geom_centroid	string	The centroid of the geometry of the object.
geom_center_x	double	The X-coordinate of the center of the geometry of the object.
geom_center_y	double	The Y-coordinate of the center of the geometry of the object.
geom	binary	The full geometry object of the row version.

Additional Info

Last Updated	September 13, 2024
Created	April 23, 2024