Road Traffic Volume in Helsinki, Finland

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

Tables

Road Traffic Noise Study 2017 Area 11 - Road Traffic Noise Study 2017 Area 11 - Road Traffic Noise PolygonsTSV
The table 'avoindatameluselvitys_2017_alue_11_tieliikenne_l_den__meluselvitys_2017_alue_11_tieliikenne_l_denpolygon' contains data from 'Helsinki City Environment Department' in Finland. The table includes various columns such as '_extract_date', '_row_number', 'id', 'db_lo', 'db_hi', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', and 'geom'. These columns store information that can be utilized for data analytics purposes, such as analyzing noise levels in road traffic and its relation to geographical locations. Additionally, the table provides data about the data source, including the date of extraction, the data owner, and the date of update. The geographic information such as centroid coordinates and...
Version History of Traffic Noise Study 2017 Area 11 Road Traffic Sound Level in FinlandTSV
This table contains the version history of rows extracted from the 'Helsingin kaupunkiympariston toimiala' website in the country 'Finland' (ISO country code 'fi'). The table records the changes made to the base table rows identified by the 'id' column. Each version of a row is identified by a unique '_row_number' value. The '_start_date' column indicates the extraction date of a row, while the '_end_date' column indicates the extraction date of the next version of the row. If a row is the most recent version, its '_end_date' value will be null. The table also includes other columns such as 'db_lo', 'db_hi', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom', which contain various data related to the extracted rows. This...

Column Descriptions

Road Traffic Noise Study 2017 Area 11 - Road Traffic Noise Study 2017 Area 11 - Road Traffic Noise Polygons

Column	Type	Comment
_extract_date	date	The date when the row was extracted.
_row_number	long	The unique identifier for each row.
id	int	The unique identifier for each record.
db_lo	int	The lower bound value of the database range.
db_hi	int	The higher bound value of the database range.
datanomist	string	The name of the data analyst responsible for the record.
paivitetty	string	The date when the record was last updated.
geom_geojson	string	The geometry data in GeoJSON format.
geom_geotext	string	The geometry data in Geotext format.
geom_type	string	The type of the geometry data.
geom_centroid	string	The centroid point of the geometry data.
geom_center_x	double	The X-coordinate of the center point of the geometry.
geom_center_y	double	The Y-coordinate of the center point of the geometry.
geom	binary	The geometry data.

Version History of Traffic Noise Study 2017 Area 11 Road Traffic Sound Level in 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 sequential number of the row version.
id	int	The unique identifier of the row version.
db_lo	int	A low part of the double-precision floating-point number representing a database value.
db_hi	int	A high part of the double-precision floating-point number representing a database value.
datanomist	string	The name of the data analyst.
paivitetty	string	The date of the last update of the row version.
geom_geojson	string	The geometry data in GeoJSON format.
geom_geotext	string	The geometry data in geotext format.
geom_type	string	The type of the 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 geometry data.

Additional Info

Last Updated	September 13, 2024
Created	October 21, 2018