To download the data set, please sign up or log in

Public Transport Map: Traffic, Metro and Rail in Helsinki, Finland

This dataset collection consists of one or more dataset tables sourced from the website of Helsingin kaupunkiympariston toimiala (City of Helsinki Environment Sector) in Finland.

Tables

  • Map of Metropolitan Rail Lines - Helsinki Metropolitan AreaTSV

    This table contains metro rail line data sourced from the website of Helsingin kaupunkiympäristön toimiala, located in Finland. It provides information on various attributes related to metro rail lines such as the extract date, row number, metro rail line, metro rail group, geographic JSON representation, geographic text representation, geometric type, centroid, center x-coordinate, center y-coordinate, geometric details, and data service information. The data in this table can be utilized for various data analytics purposes such as spatial analysis, route optimization, geographic visualization, and statistical analysis.

  • Metro Rail Line History - Traffic and Transport Map - Helsinki Metropolitan Area - Version HistoryTSV

    This table contains the version history of rows from the 'avoindataseutukartta_liikenne_metro_rata__seutukartta_liikenne_metro_rataline' table. It includes information about the start and end dates of each row, as well as additional columns such as 'metrorata', 'mtryhm', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', 'geom', and 'tietopalve'. The data in this table, which is sourced from the website of 'Helsinki City Planning Department', can be utilized in various data analytics scenarios. For example, it can be used to analyze changes in the metro rail network over time, study the characteristics of different metro lines, examine the spatial distribution of metro route geometry, and perform geospatial analysis by utilizing the centroid...

Column Descriptions

Map of Metropolitan Rail Lines - Helsinki Metropolitan Area

Column Type Comment
_extract_date date The date when the data was extracted.
_row_number long The row number of the record in the database table.
metrorata string The metropolitan area where the data is related to.
mtryhm int The municipality or city where the data is related to.
geom_geojson string The geometry data in GeoJSON format.
geom_geotext string The geometry data in geotext format.
geom_type string The type of geometry data.
geom_centroid string The centroid point of the geometry.
geom_center_x double The x-coordinate of the center point of the geometry.
geom_center_y double The y-coordinate of the center point of the geometry.
geom binary The geometry data.
tietopalve int The information service related to the data.

Metro Rail Line History - Traffic and Transport Map - Helsinki Metropolitan Area - Version History

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 A unique identifier assigned to each row version.
metrorata string Unknown description
mtryhm int Unknown description
geom_geojson string Unknown description
geom_geotext string Unknown description
geom_type string Unknown description
geom_centroid string Unknown description
geom_center_x double Unknown description
geom_center_y double Unknown description
geom binary Unknown description
tietopalve int Unknown description

Additional Info

Last Updated September 13, 2024
Created May 6, 2018