Road Traffic Data in Helsinki, Finland

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

Tables

Road Traffic Noise Study 2007, Area 03: Road Traffic Noise PolygonsTSV
This table contains data from the 'Helsinki City Environment Sector' website in Finland (ISO country code 'fi'). It provides information related to 'avoindatameluselvitys_2007_alue_03_tieliikenne_l_den__meluselvitys_2007_alue_03_tieliikenne_l_denpolygon' table. The table includes various fields such as '_extract_date', '_row_number', 'tietopalve', '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 utilized for various data analytics purposes, such as analyzing noise levels in specific areas, identifying data ownership, and studying the geometrical aspects of road traffic density polygons.
Version History of 2007 Area 03 Road Traffic Noise Survey (Polygon) Data Source - Helsingin kaupunkiympariston toimiala (Finland)TSV
This table contains the version history of the base table 'avoindatameluselvitys_2007_alue_03_tieliikenne_l_den__meluselvitys_2007_alue_03_tieliikenne_l_denpolygon'. It tracks the changes made to the rows over time, with each row having additional columns '_start_date', '_end_date', and '_row_number'. The table is sourced from the website of 'Helsinki City Environment Sector', which originates from Finland (ISO country code 'fi'). The data in this table can be utilized for various data analytics tasks, such as analyzing the changes in 'geom_geojson' or 'geom_type' over time, identifying patterns in 'paivitetty' (date updated), or examining the distribution of 'db_lo' and 'db_hi'.

Column Descriptions

Road Traffic Noise Study 2007, Area 03: Road Traffic Noise Polygons

Column	Type	Comment
_extract_date	date	The timestamp when the data was extracted.
_row_number	long	The row number of the record within the table.
tietopalve	int	The name of the information service that provided the data.
db_lo	int	The lower boundary of a database range.
db_hi	int	The upper boundary of a database range.
datanomist	string	The name of the data custodian.
paivitetty	string	The timestamp when the record was last updated.
geom_geojson	string	The geometry of the record in GeoJSON format.
geom_geotext	string	The geometry of the record in Geotext format.
geom_type	string	The type of geometry of the record.
geom_centroid	string	The centroid of the geometry.
geom_center_x	double	The x-coordinate of the center of the geometry.
geom_center_y	double	The y-coordinate of the center of the geometry.
geom	binary	The full geometry object.

Version History of 2007 Area 03 Road Traffic Noise Survey (Polygon) Data Source - Helsingin kaupunkiympariston toimiala (Finland)

Column	Type	Comment
_start_date	date	The timestamp indicating the start date of the validity period for the row version.
_end_date	date	The timestamp indicating the end date of the validity period for the row version.
_row_number	long	The unique identifier of each row version.
tietopalve	int	The information service associated with the row version.
db_lo	int	The lower bound value of the database range associated with the row version.
db_hi	int	The upper bound value of the database range associated with the row version.
datanomist	string	The data owner or custodian of the row version.
paivitetty	string	The timestamp indicating the last update or modification of the row version.
geom_geojson	string	The geometry representation of the row version in GeoJSON format.
geom_geotext	string	The geometry representation of the row version in Geotext format.
geom_type	string	The type of geometry associated with the row version.
geom_centroid	string	The centroid point of the geometry associated with the row version.
geom_center_x	double	The x-coordinate of the center point of the geometry associated with the row version.
geom_center_y	double	The y-coordinate of the center point of the geometry associated with the row version.
geom	binary	The spatial representation of the row version.

Additional Info

Last Updated	September 13, 2024
Created	April 23, 2024