Version History of Finnish 'Helsinki Urban Environment Department' Polygon Data
Click here for a data sample
This table contains the version history of the rows from the avoindataopev_ooa_ylaaste_ruotsi__opev_ooa_ylaaste_ruotsipolygon table. The rows in this table represent different versions of the base table rows, with additional columns _start_date and _end_date indicating the extraction dates. The data in this table is sourced from the website of the Helsinki City environment sector, which originates from Finland (ISO country code: 'fi'). The table provides valuable data for data analytics, allowing analysis of the historical changes over time in the 'aluejako', 'kunta', 'tunnus', 'nimi_fi', 'nimi_se', 'toimipiste', 'yhtluontip', 'yhtdatanom', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', and 'geom' columns. By analyzing this historical data, it is possible to understand the evolution and updates made to the geographic information contained in the base table, enabling various analytics tasks such as spatial analysis, trend analysis, and performance evaluation.
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. |
|---|
| id | int | The unique identifier of the row. |
|---|
| aluejako | string | The partitioning of the area. |
|---|
| kunta | int | The municipality of the row. |
|---|
| tunnus | int | The identifier of the row. |
|---|
| nimi_fi | string | The name of the row in Finnish. |
|---|
| nimi_se | string | The name of the row in Swedish. |
|---|
| toimipiste | int | The office location. |
|---|
| yhtluontip | string | The co-creation type. |
|---|
| yhtdatanom | string | The data nominator. |
|---|
| paivitetty | string | The date of the update. |
|---|
| geom_geojson | string | The geometry in GeoJSON format. |
|---|
| geom_geotext | string | The geometry in Well-Known Text (WKT) format. |
|---|
| geom_type | string | The type of the geometry. |
|---|
| geom_centroid | string | The centroid of the geometry. |
|---|
| geom_center_x | double | The X coordinate of the center of the geometry. |
|---|
| geom_center_y | double | The Y coordinate of the center of the geometry. |
|---|
| geom | binary | The spatial representation of the feature. |
|---|
