Open Metropolitan Map Traffic Road

The dataset collection consists of one or more dataset tables sourced from the website of Helsingin kaupunkiympäristön toimiala in Finland.

Road Network - Version HistoryTSV
This table contains the version history of the base table rows from the web site of the 'Helsinki City Environment Sector' in Finland. The data source for this table is from the country with the ISO country code 'FI'. The table records changes in the 'avoindataseutukartta_liikenne_tiesto__seutukartta_liikenne_tiestoline' table over time, with each row having additional columns '_start_date' and '_end_date'. The '_start_date' column contains the date when the row was extracted from the data source, while the '_end_date' column contains the date when a new version of the row was extracted. If the '_end_date' column value is null, it indicates that the row represents the most recent version of the data. The table also includes other columns such as 'tieluokka', 'nimi', 'tieluokka0',...
Traffic Road Network on Open Metropolitan Map - Helsinki, FinlandTSV
This table contains data related to traffic roads in the Helsinki metropolitan area. The data is sourced from the website of Helsingin kaupunkiympariston toimiala, which originates from the country Finland (ISO country code 'fi'). The table includes information such as the extraction date, row number, road class, road name, road class category, maintenance group, road geometry in geojson format, road geometry in geotext format, road geometry type, centroid of road geometry, x-coordinate of centroid, y-coordinate of centroid, road geometry, and road service.

Column	Type	Comment
_extract_date	date	The date when the data was extracted.
_row_number	long	The row number of the entry in the table.
tieluokka	string	The classification of the road.
nimi	string	The name of the road.
tieluokka0	int	The initial classification of the road.
mtryhm	int	The maintenance group of the road.
geom_geojson	string	The geometry of the road in GeoJSON format.
geom_geotext	string	The geotext representation of the road geometry.
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 raw geometry data of the road.
tietopalve	int	The service information about the road.

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 unique identifier assigned to each row version.
tieluokka	string	The road class associated with the row version.
nimi	string	The name or label associated with the row version.
tieluokka0	int	An additional road class field associated with the row version.
mtryhm	int	The maintenance group associated with the row version.
geom_geojson	string	The geographic data in GeoJSON format associated with the row version.
geom_geotext	string	The geographic data in Geotext format associated with the row version.
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 geometry data associated with the row version.
tietopalve	int	The data service associated with the row version.

Last Updated	September 13, 2024
Created	June 15, 2018