Traffic Routes in Helsinki, Finland

This dataset collection is sourced from the web site of Helsingin kaupunkiympäristön toimiala in Finland. It consists of one or more dataset tables related to 'helliikennevaylat'. The tables in this collection provide information about traffic routes and roads in Helsinki, Finland. These tables contain data that can be used to analyze and understand the transportation system in the city, including details about road network, traffic volume, road conditions, and more. The dataset collection aims to provide valuable data for researchers, analysts, and policymakers to study and improve the transportation infrastructure in Helsinki, Finland.

Tables

History of Road Network in Finland from Helsingin kaupunkiympariston toimialaTSV
The 'helliikennevaylatliikennevaylathistory' table contains the version history of the 'helliikennevaylat__liikennevaylat' base table rows. It includes additional columns '_start_date' and '_end_date' which represent the extraction dates from the data source. This table originates from the country Finland (ISO country code 'fi') and is sourced from the website of 'Helsinki City Environment Sector'. The table provides valuable data for conducting data analytics and insights. For example, it can be utilized to analyze changes in road types, level numbers, driving dates, geometries, and geographic centroids over time. Data analysts can examine trends, patterns, and correlations to gain insights into traffic infrastructure and make informed decisions based on the historical evolution of the...
Traffic Routes - Helsingin kaupunkiympariston toimiala - FinlandTSV
This table contains data on traffic routes in the city of Helsinki. The data is sourced from the website of Helsingin kaupunkiympäristön toimiala, which originates from Finland (ISO country code 'fi'). The table records various details about the traffic routes, such as the extraction date, row number, route type, route number, route name, the date of traffic, the geographic coordinates of the route in both GeoJSON and GeoText format, the type of geometry, the centroid of the geometry, the x-coordinate of the center point, the y-coordinate of the center point, and the complete geometry of the route.

Column Descriptions

Traffic Routes - Helsingin kaupunkiympariston toimiala - Finland

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The sequential number of each row in the table.
vaylatyypp	string	The type of waterway.
dgntasonro	int	The level number of the waterway.
dgntasonim	string	The name of the waterway.
ajo_pvm	timestamp	The date when the measurement was taken.
geom_geojson	string	The geometric representation of the waterway in GeoJSON format.
geom_geotext	string	The geometric representation of the waterway in well-known text format.
geom_type	string	The type of geometric representation used for the waterway.
geom_centroid	string	The centroid point of the waterway.
geom_center_x	double	The x-coordinate of the center point of the waterway.
geom_center_y	double	The y-coordinate of the center point of the waterway.
geom	binary	The full geometric representation of the waterway.

History of Road Network in Finland from Helsingin kaupunkiympariston toimiala

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	The unique identifier of the row version.
vaylatyypp	string	The type of the road.
dgntasonro	int	The number of the road.
dgntasonim	string	The name of the road.
ajo_pvm	timestamp	The date of the road update.
geom_geojson	string	The geometry of the road in GeoJSON format.
geom_geotext	string	The geometry of the road in Geotext format.
geom_type	string	The type of the road geometry.
geom_centroid	string	The centroid of the road geometry.
geom_center_x	double	The x-coordinate of the center of the road geometry.
geom_center_y	double	The y-coordinate of the center of the road geometry.
geom	binary	The road geometry.

Additional Info

Last Updated	September 13, 2024
Created	October 22, 2018