Version History of Traffic Main Road - Regional Map
Click here for a data sample
This table contains the version history of the rows from 'avoindataseutukartta_liikenne_paatiet__seutukartta_liikenne_paatietline' table. The data in this table is sourced from the website of 'Helsinki City Environment Sector' from the country 'Finland' (ISO country code: 'fi'). It includes information about the start and end dates for each row, along with other attributes. The table can be utilized in data analytics to track changes in road classifications, road names, road groups, geometry information, and service information over time. By analyzing the start and end dates, trends, patterns, and historical data insights can be derived to understand how the transportation network in Helsinki has evolved.
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 row number of the version in the version history table. |
|---|
| tieluokka | string | The classification of the road. |
|---|
| nimi | string | The name of the road. |
|---|
| tieluokka0 | int | An additional classification for the road. |
|---|
| mtryhm | int | The maintenance group for the road. |
|---|
| geom_geojson | string | The geometry of the road in GeoJSON format. |
|---|
| geom_geotext | string | The text representation of the road's geometry. |
|---|
| geom_type | string | The type of the road's geometry. |
|---|
| geom_centroid | string | The centroid of the road's geometry. |
|---|
| geom_center_x | double | The x-coordinate of the center point of the road's geometry. |
|---|
| geom_center_y | double | The y-coordinate of the center point of the road's geometry. |
|---|
| geom | binary | The full geometry of the road. |
|---|
| tietopalve | int | The information service related to the road. |
|---|
