Open Data General Plan Area Directory Sub-Area Polygon History
Click here for a data sample
This table contains the version history of the base table 'avoindataosayleiskaavahakemisto_alue__osayleiskaavahakemisto_aluepolygon'. It includes additional columns '_start_date' and '_end_date' which indicate the extraction dates of each version. The data in this table is sourced from the website of 'Helsinki City Environment Sector' in Finland (ISO country code: FI). The table provides valuable information for data analytics tasks such as trend analysis, historical comparisons, and monitoring changes over time.
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. |
|---|
| id | int | The unique identifier of the row. |
|---|
| kohdenimi | string | The name of the target. |
|---|
| tunnus | int | The identifier of the target. |
|---|
| nimi | string | The name of the row. |
|---|
| olotila | int | The state of the row. |
|---|
| luontipvm | string | The creation date of the row. |
|---|
| muokkauspv | string | The modification date of the row. |
|---|
| datanomist | string | The owner of the data. |
|---|
| paivitetty | string | The date of the last 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 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 geometry of the row. |
|---|
