Public Transport Map: Traffic, Metro and Rail in Helsinki, 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 |