Version History of Opev Ooa Ylaaste Suomi - Opev Ooa Ylaaste Suomipolygon for Helsingin kaupunkiympariston toimiala, Finland
Click here for a data sample
This table is a historical version of the 'avoindataopev_ooa_ylaaste_suomi__opev_ooa_ylaaste_suomipolygon' table, sourced from the website of Helsingin kaupunkiympariston toimiala in Finland. It contains the version history of its base table rows, with two 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 '_end_date' is null, it means that the row is the most recent version. This table can be used for data analytics, such as tracking changes over time, analyzing trends, and performing historical comparisons of the data.
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 row number of the version in the table. |
|---|
| id | int | The unique identifier of the row. |
|---|
| aluejako | string | The division of the area. |
|---|
| kunta | int | The municipality associated with 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 location of the row. |
|---|
| yhtluontip | string | The creation type of the row. |
|---|
| yhtdatanom | string | The data authority of the row. |
|---|
| paivitetty | string | The date of the row update. |
|---|
| geom_geojson | string | The geometry of the row in GeoJSON format. |
|---|
| geom_geotext | string | The geometry of the row in geotext 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 geometry center. |
|---|
| geom_center_y | double | The y-coordinate of the geometry center. |
|---|
| geom | binary | The geometry of the row. |
|---|
