History of Road Network in Finland from Helsingin kaupunkiympariston toimiala
Click here for a data sample
The 'helliikennevaylatliikennevaylathistory' table contains the version history of the 'helliikennevaylat__liikennevaylat' base table rows. It includes additional columns '_start_date' and '_end_date' which represent the extraction dates from the data source. This table originates from the country Finland (ISO country code 'fi') and is sourced from the website of 'Helsinki City Environment Sector'. The table provides valuable data for conducting data analytics and insights. For example, it can be utilized to analyze changes in road types, level numbers, driving dates, geometries, and geographic centroids over time. Data analysts can examine trends, patterns, and correlations to gain insights into traffic infrastructure and make informed decisions based on the historical evolution of the road network.
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 unique identifier of the row version. |
|---|
| vaylatyypp | string | The type of the road. |
|---|
| dgntasonro | int | The number of the road. |
|---|
| dgntasonim | string | The name of the road. |
|---|
| ajo_pvm | timestamp | The date of the road update. |
|---|
| geom_geojson | string | The geometry of the road in GeoJSON format. |
|---|
| geom_geotext | string | The geometry of the road in Geotext format. |
|---|
| geom_type | string | The type of the road geometry. |
|---|
| geom_centroid | string | The centroid of the road geometry. |
|---|
| geom_center_x | double | The x-coordinate of the center of the road geometry. |
|---|
| geom_center_y | double | The y-coordinate of the center of the road geometry. |
|---|
| geom | binary | The road geometry. |
|---|
