Train Rail Network History
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_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 | The number assigned to each row version. |
rataosuus | string | The rail section. |
mtryhm | int | The group of measurements. |
geom_geojson | string | The geometrical representation of the feature in GeoJSON format. |
geom_geotext | string | The geometrical representation of the feature in GeoText format. |
geom_type | string | The type of geometry of the feature. |
geom_centroid | string | The centroid point of the feature geometry. |
geom_center_x | double | The X-coordinate of the center point of the feature geometry. |
geom_center_y | double | The Y-coordinate of the center point of the feature geometry. |
geom | binary | The representation of the feature geometry. |
tietopalve | int | The data service associated with the row version. |