Road Network - Version History
Click here for a data sample
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', 'mtryhm', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', 'geom', and 'tietopalve', which contain various information related to the road network. Examples of how the data in this table could be utilized in data analytics include analyzing changes in road classifications over time, calculating the geometric properties of road segments, and examining patterns in road name changes or maintenance activities.
Field Descriptions
| Name |
Data type |
Description |
| _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. |
|---|
