Road Traffic Noise Levels in the Year 2007 by Region in Helsinki, Finland

This dataset collection, sourced from the web site of Helsingin kaupunkiympariston toimiala in Finland, contains one or more tables related to the 'avoindatameluselvitys_2007_alue_02_tieliikenne_l_aeq_yo' dataset collection.

Tables

Road Traffic Noise Survey 2007 Area 02 - Level Above Equivalent Night Value (Laeq,Yo)TSV
This table contains data from the 'Helsinki City Environment Sector' website. It represents 'avoindatameluselvitys_2007_alue_02_tieliikenne_l_aeq_yo__meluselvitys_2007_alue_02_tieliikenne_l_aeq_yopolygon' dataset. The data is sourced from the country with ISO country code 'fi', which stands for Finland. The table includes various columns such as _extract_date, _row_number, tietopalve, db_lo, db_hi, datanomist, paivitetty, geom_geojson, geom_geotext, geom_type, geom_centroid, geom_center_x, geom_center_y, and geom. These columns provide valuable information for data analytics in different fields. For example, _extract_date can be used to analyze the timing of data extraction or updates. db_lo and db_hi could be utilized to calculate the range of decibels. The geometrical columns such as...
Version History of Road Traffic Noise Survey - Year 2007 - Area 02 - Level Laeq Night - PolygonTSV
This table contains the version history of the rows extracted from the dataset 'Helsingin kaupunkiympariston toimiala'. The dataset provides information about 'avoindatameluselvitys_2007_alue_02_tieliikenne_l_aeq_yo__meluselvitys_2007_alue_02_tieliikenne_l_aeq_yopolygon' in the country with ISO country code 'fi'. Each row in this table represents a version of a specific row from the base table. The '_start_date' column indicates the date when the row version was extracted, and the '_end_date' column indicates the date when a new version of the row was extracted. If the '_end_date' column value is null, it means that the row version is the most recent. The table provides valuable data for various data analytics tasks, such as trend analysis, time-based comparisons, and identification of...

Column Descriptions

Road Traffic Noise Survey 2007 Area 02 - Level Above Equivalent Night Value (Laeq,Yo)

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The row number of the data entry.
tietopalve	int	The name of the data service.
db_lo	int	The low value of the database range.
db_hi	int	The high value of the database range.
datanomist	string	The name of the data owner.
paivitetty	string	The date when the data was last updated.
geom_geojson	string	The geometry of the data entry in GeoJSON format.
geom_geotext	string	The geometry of the data entry in Geotext format.
geom_type	string	The type of the geometry of the data entry.
geom_centroid	string	The centroid of the geometry of the data entry.
geom_center_x	double	The X-coordinate of the center of the geometry of the data entry.
geom_center_y	double	The Y-coordinate of the center of the geometry of the data entry.
geom	binary	The geometry of the data entry.

Version History of Road Traffic Noise Survey - Year 2007 - Area 02 - Level Laeq Night - Polygon

Column	Type	Comment
_start_date	date	The start date of the validity period of the row version.
_end_date	date	The end date of the validity period of the row version.
_row_number	long	A unique identifier for each row version in the table.
tietopalve	int	The data service associated with the row version.
db_lo	int	The lower range value of the row version's database identifier.
db_hi	int	The upper range value of the row version's database identifier.
datanomist	string	The data custodian responsible for the row version.
paivitetty	string	The date and time when the row version was last updated.
geom_geojson	string	The geometry of the row version represented in GeoJSON format.
geom_geotext	string	The geometry of the row version represented 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 raw geometry data of the row version.

Additional Info

Last Updated	September 13, 2024
Created	April 23, 2024