Train Rail Network History

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

Click here for a data sample

This table contains the version history of the rows from 'avoindataseutukartta_liikenne_juna_rata__seutukartta_liikenne_juna_rataline' table. Each row in this table represents a specific version of the base table row, with additional columns '_start_date' and '_end_date' indicating the extraction dates. The data in this table is sourced from the website of 'Helsinki Urban Environment Division' in Finland (ISO country code: 'fi'). The table provides valuable information for data analytics, such as analyzing changes in 'rataosuus' (rail portion), 'mtryhm' (track group), 'geom_geojson' (geographical data in GeoJSON format), 'geom_geotext' (geographical data in geotext format), 'geom_type' (type of geometry), 'geom_centroid' (centroid of the geometry), 'geom_center_x' (x-coordinate of the geometry's center), 'geom_center_y' (y-coordinate of the geometry's center), 'geom' (geometry), and 'tietopalve' (data service). Data analysts can utilize this historical data to track changes, identify trends, and perform various analytical tasks to gain insights into the transportation system.

Field Descriptions

Name Data type Description
_start_datedateThe start date of the validity period of the row version.
_end_datedateThe end date of the validity period of the row version.
_row_numberlongThe number assigned to each row version.
rataosuusstringThe rail section.
mtryhmintThe group of measurements.
geom_geojsonstringThe geometrical representation of the feature in GeoJSON format.
geom_geotextstringThe geometrical representation of the feature in GeoText format.
geom_typestringThe type of geometry of the feature.
geom_centroidstringThe centroid point of the feature geometry.
geom_center_xdoubleThe X-coordinate of the center point of the feature geometry.
geom_center_ydoubleThe Y-coordinate of the center point of the feature geometry.
geombinaryThe representation of the feature geometry.
tietopalveintThe data service associated with the row version.

No sample for this dataset

Additional Information

Last updated April 23, 2024
Created April 23, 2024
License No License Provided
Geographic coverage
Geographic granularity
Temporal coverage from
Temporal coverage to
Temporal coverage to
Adapterdelta
Countryfi
Databasefi_helsingin_kaupunkiympariston_toimiala
Id3574dac1-89e4-4176-812d-6c912c9d16ea
Package ida280f08a-094c-42b9-a664-595dd8f3535e
Position1
Revision idd5dac502-b8b5-4ce7-8951-c1ddedb661d6
Stateactive
Tableavoindataseutukartta_liikenne_juna_rata__seutukartta_liikenne_juna_rataline__history