Traffic Main Road Open Data Collection for Helsinki Metropolitan Area

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

Tables

Traffic Main Roads in City Area - Helsinki, FinlandTSV
This table contains data from the 'Helsinki City Environment Sector' website in Finland. It provides information about main roads in the Helsinki metropolitan area, including their classification, name, road group, and geographic coordinates. The table also includes the date when the data was extracted, the row number of each record, and additional geometric information such as the geojson representation, geotext representation, type, centroid, center coordinates, and the original geometry. The 'tietopalve' column indicates data related to road services. This data is valuable for various data analytics tasks, such as studying traffic patterns, analyzing road characteristics, identifying road networks, and measuring distances between locations.
Version History of Traffic Main Road - Regional MapTSV
This table contains the version history of the rows from 'avoindataseutukartta_liikenne_paatiet__seutukartta_liikenne_paatietline' table. The data in this table is sourced from the website of 'Helsinki City Environment Sector' from the country 'Finland' (ISO country code: 'fi'). It includes information about the start and end dates for each row, along with other attributes. The table can be utilized in data analytics to track changes in road classifications, road names, road groups, geometry information, and service information over time. By analyzing the start and end dates, trends, patterns, and historical data insights can be derived to understand how the transportation network in Helsinki has evolved.

Column Descriptions

Traffic Main Roads in City Area - Helsinki, Finland

Column	Type	Comment
_extract_date	date	The date when the data was extracted
_row_number	long	The unique row number of the data entry
tieluokka	string	The classification code for the road
nimi	string	The name of the road
tieluokka0	int	The detailed classification code for the road
mtryhm	int	The maintenance group responsible for the road
geom_geojson	string	The road's geometry in GeoJSON format
geom_geotext	string	The road's geometry in Well-known Text (WKT) format
geom_type	string	The type of the road's geometry
geom_centroid	string	The centroid point of the road's geometry
geom_center_x	double	The x-coordinate of the center point of the road's geometry
geom_center_y	double	The y-coordinate of the center point of the road's geometry
geom	binary	The raw geometry data of the road
tietopalve	int	The information service availability status for the road

Version History of Traffic Main Road - Regional Map

Column	Type	Comment
_start_date	date	The start date of the validity period for the row version.
_end_date	date	The end date of the validity period for the row version.
_row_number	long	The row number of the version in the version history table.
tieluokka	string	The classification of the road.
nimi	string	The name of the road.
tieluokka0	int	An additional classification for the road.
mtryhm	int	The maintenance group for the road.
geom_geojson	string	The geometry of the road in GeoJSON format.
geom_geotext	string	The text representation of the road's geometry.
geom_type	string	The type of the road's geometry.
geom_centroid	string	The centroid of the road's geometry.
geom_center_x	double	The x-coordinate of the center point of the road's geometry.
geom_center_y	double	The y-coordinate of the center point of the road's geometry.
geom	binary	The full geometry of the road.
tietopalve	int	The information service related to the road.

Additional Info

Last Updated	September 13, 2024
Created	June 15, 2018