Helsingin kaupunkiympariston toimiala - Road Traffic at Night in Finland (2007)

This dataset collection, sourced from the website of Helsingin kaupunkiympäristön toimiala (Department of Urban Environment of Helsinki), consists of one or more dataset tables. The tables provide information on road traffic during the night in the year 2007. The dataset collection is named 'avoindatameluselvitys_2007_alue_04_tieliikenne_l_yo'. The data is specific to the country Finland.

Tables

Road Traffic Noise Study 2007 Area 04 (Night) - Road Traffic Noise Study 2007 Area 04 (Night) PolygonTSV
This table contains data sourced from the website of Helsingin kaupunkiympäristön toimiala, originating from Finland (ISO country code 'fi'). It provides information on tieliikenne (road traffic) noise measurements. 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'. The data in this table can be utilized for various data analytics purposes, such as analyzing noise levels in different areas, identifying noise hotspots, studying noise patterns over time, and investigating the relationship between noise and other variables like data source updating frequency or noise measurements taken at different...
Version History of Road Traffic Noise Survey 2007 Area 04 Night-Time - Polygon (Web Source: Helsinki Urban Environment Sector, Country: Finland)TSV
This table contains the version history of the rows in the 'avoindatameluselvitys_2007_alue_04_tieliikenne_l_yo__meluselvitys_2007_alue_04_tieliikenne_l_yopolygon' table. The rows in this table are extracted from the data source provided by 'Helsingin kaupunkiympariston toimiala', which originates from Finland. It has additional columns compared to its base table, including '_start_date' and '_end_date', which represent the extraction dates of the rows. The table provides useful data for data analytics purposes, allowing analysts to track changes and historical versions of the rows. Analysts could utilize this data to perform trend analysis, identify patterns, or gain insights into the evolution of the rows over time.

Column Descriptions

Road Traffic Noise Study 2007 Area 04 (Night) - Road Traffic Noise Study 2007 Area 04 (Night) Polygon

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 service.
db_lo	int	The lower bound value of a database parameter.
db_hi	int	The upper bound value of a database parameter.
datanomist	string	The name of the data owner.
paivitetty	string	The date when the data was updated.
geom_geojson	string	The geometrical representation of the data in GeoJSON format.
geom_geotext	string	The geometrical representation of the data in Geotext format.
geom_type	string	The type of the geometric object.
geom_centroid	string	The centroid point of the geometric object.
geom_center_x	double	The x-coordinate of the center point of the geometric object.
geom_center_y	double	The y-coordinate of the center point of the geometric object.
geom	binary	The geometry field storing the shape of the object.

Version History of Road Traffic Noise Survey 2007 Area 04 Night-Time - Polygon (Web Source: Helsinki Urban Environment Sector, Country: Finland)

Column	Type	Comment
_start_date	date	This column indicates the start date of the validity period of the row version.
_end_date	date	This column indicates the end date of the validity period of the row version.
_row_number	long	This column represents the row number of the version in the table.
tietopalve	int	This column stores the data related to the service.
db_lo	int	This column stores the low value of the database.
db_hi	int	This column stores the high value of the database.
datanomist	string	This column contains the data custodian information.
paivitetty	string	This column represents the date when the data was updated.
geom_geojson	string	This column stores the geometry data in the geojson format.
geom_geotext	string	This column stores the geometry data in the WKT (well-known text) format.
geom_type	string	This column indicates the type of geometry data.
geom_centroid	string	This column stores the centroid point of the geometry.
geom_center_x	double	This column stores the x-coordinate of the center point of the geometry.
geom_center_y	double	This column stores the y-coordinate of the center point of the geometry.
geom	binary	This column stores the geometry data in a specific format.

Additional Info

Last Updated	September 13, 2024
Created	April 23, 2024