Road Traffic Data Collection in Helsinki, Finland

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

Tables

Noise Survey 2017 - Road Traffic at Night, Area 12TSV
This table contains data from the 'Helsinki City Environment Sector' website. The data originates from Finland, which has the ISO country code 'fi'. 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'. The table provides valuable data that can be used for data analytics in various ways. For example, the 'db_lo' and 'db_hi' columns can be used to calculate the noise level range, while the 'paivitetty' column can be utilized to analyze the frequency of data updates. The 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y' columns can be used for spatial analysis...
Version history of Road Traffic Night Noise Survey 2017 Area 12 - Noise Survey 2017 - Road Traffic Night Noise Polygon - FinlandTSV
This table contains the version history of the rows from the 'avoindatameluselvitys_2017_alue_12_tieliikenne_l_yo__meluselvitys_2017_alue_12_tieliikenne_l_yopolygon' base table. The rows in this table represent different versions of the data extracted from the web site of 'City Planning Department of Helsinki', which originates from Finland. Each row in the table has information about the start and end date of its version. If the '_end_date' column value is null, it means that the row represents the most recent version. The table may be utilized in data analytics to analyze changes and trends over time in the dataset, such as studying the evolution of noise levels in different areas of Helsinki during nighttime.

Column Descriptions

Noise Survey 2017 - Road Traffic at Night, Area 12

Column	Type	Comment
_extract_date	date	The date on which the data was extracted.
_row_number	long	The unique identifier of the row in the table.
id	int	The identifier of the record.
db_lo	int	The lower bound of the database.
db_hi	int	The upper bound of the database.
datanomist	string	The name of the data analyst.
paivitetty	string	The date of the last update.
geom_geojson	string	The geometric data in GeoJSON format.
geom_geotext	string	The geometric data in Geotext format.
geom_type	string	The type of the 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 2017 Area 12 - Noise Survey 2017 - Road Traffic Night Noise Polygon - Finland

Column	Type	Comment
_start_date	date	The starting date of the validity period for the row version
_end_date	date	The ending date of the validity period for the row version
_row_number	long	The sequential number of the row version
id	int	The identifier of the row
db_lo	int	The lower part of the database identifier of the row
db_hi	int	The higher part of the database identifier of the row
datanomist	string	The name of the person who updated the row
paivitetty	string	The date and time when the row was last updated
geom_geojson	string	The geometry of the row in GeoJSON format
geom_geotext	string	The geometry of the row in Geotext format
geom_type	string	The type of geometry of the row
geom_centroid	string	The centroid of the geometry of the row
geom_center_x	double	The x-coordinate of the center of the geometry of the row
geom_center_y	double	The y-coordinate of the center of the geometry of the row
geom	binary	The geometry of the row

Additional Info

Last Updated	September 13, 2024
Created	October 21, 2018