Version History of Area Underground Plan Applications' Areas (Pending) - Polygon
Click here for a data sample
This table contains the version history of the rows in the 'avoindatakaavahakemisto_alue_maanalainenkaava_vireilla__kaavahakemisto_alue_maanalainenkaava_vireillapolygon' table. It includes the columns '_start_date' and '_end_date', which indicate the start and end dates of each version of a row. The data in this table is sourced from the website of 'Helsinki City Environment Sector', which originates from Finland (ISO country code: 'fi'). The table provides historical information about various attributes such as 'id', 'tyyppi', 'kaavatunnu', 'luokka', 'alkuperain', 'pintaala', 'korkeusjar', 'sijaintial', 'hyvaksymis', 'lainvoimai', 'voimaantul', 'vahvistami', 'luontipvm', 'muokkauspv', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', and 'geom_center_y'. This historical data can be utilized in various data analytics tasks, such as tracking changes in attribute values over time, analyzing trends, and understanding the impact of updates on the geographical features represented by the 'geom' column.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The timestamp indicating the start of the validity period of the row version. |
|---|
| _end_date | date | The timestamp indicating the end of the validity period of the row version. |
|---|
| _row_number | long | The sequential number assigned to each row in the table. |
|---|
| id | int | The unique identifier for each row in the base table. |
|---|
| tyyppi | string | The type of the data. |
|---|
| kaavatunnu | string | The identifier code used in planning documents. |
|---|
| luokka | string | The classification of the data. |
|---|
| alkuperain | string | The original source of the data. |
|---|
| pintaala | float | The surface area value. |
|---|
| korkeusjar | string | The height or elevation information. |
|---|
| sijaintial | string | The location information. |
|---|
| hyvaksymis | string | The approval status of the data. |
|---|
| lainvoimai | date | The legal validity status of the data. |
|---|
| voimaantul | date | The date when the data becomes effective. |
|---|
| vahvistami | date | The person who verified the data. |
|---|
| luontipvm | date | The creation timestamp of the data. |
|---|
| muokkauspv | date | The last modification date of the data. |
|---|
| datanomist | string | The person responsible for the data. |
|---|
| paivitetty | date | The timestamp indicating when the data was last updated. |
|---|
| geom_geojson | string | The geometry data in GeoJSON format. |
|---|
| geom_geotext | string | The geometry data in GeoText format. |
|---|
| geom_type | string | The type of the geometry data. |
|---|
| geom_centroid | string | The centroid point 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 actual geometry data. |
|---|
