Version History of Ooa Ylaaste Suomi Tuleva Polygon - Helsingin Kaupunkiympariston Toimiala (Finland)
Click here for a data sample
This table contains the version history of the base table 'avoindataopev_ooa_ylaaste_suomi_tuleva__opev_ooa_ylaaste_suomi_tulevapolygon'. It is sourced from the website of 'Helsinki City Environment Sector' from the country of Finland. The table consists of rows with additional columns '_start_date' and '_end_date' indicating the extraction dates. The data in this table can be utilized for various data analytics purposes, such as studying the changes in 'aluejako' (area division), analyzing trends in 'kunta' (municipality), examining 'nimi_fi' (name in Finnish) and 'nimi_se' (name in Swedish) variations, understanding the distribution of 'toimipiste' (office), and tracking updates in 'paivitetty' (last updated) field. Additionally, one can leverage the geographic data stored in the table, including 'geom_geojson' (geometry in GeoJSON format), 'geom_geotext' (geometry in GeoText format), 'geom_type' (geometry type), 'geom_centroid' (centroid of the geometry), 'geom_center_x' (X-coordinate of the geometry center), 'geom_center_y' (Y-coordinate of the geometry center), and 'geom' (raw geometry data).
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 indicating the order of the row version. |
|---|
| id | int | The unique identifier of the row version. |
|---|
| aluejako | string | The division of the area. |
|---|
| kunta | int | The municipality. |
|---|
| tunnus | int | The identification code. |
|---|
| nimi_fi | string | The name in Finnish. |
|---|
| nimi_se | string | The name in Swedish. |
|---|
| toimipiste | int | The office location. |
|---|
| yhtluontip | string | The date of the joint creation. |
|---|
| yhtdatanom | string | The date of the joint data nomination. |
|---|
| paivitetty | string | The date of the last update. |
|---|
| geom_geojson | string | The geometry in GeoJSON format. |
|---|
| geom_geotext | string | The geometry in plain text format. |
|---|
| geom_type | string | The type of geometry. |
|---|
| geom_centroid | string | The centroid point of the geometry. |
|---|
| geom_center_x | double | The x-coordinate of the geometry center. |
|---|
| geom_center_y | double | The y-coordinate of the geometry center. |
|---|
| geom | binary | The geometry in raw format. |
|---|
