History of Building Restriction Area Identification for Creating Zone Plans
Click here for a data sample
This table contains the version history of the rows from the 'avoindatarakennuskieltoalue_tunnus_asemakaavan_laatimiseksi__rakennuskieltoalue_tunnus_asemakaavan_laatimiseksipolygon' table. The rows in this table represent different versions of the base table rows and include two additional columns: '_start_date' and '_end_date'. The '_start_date' column stores the date when the row was extracted from the data source, while the '_end_date' column stores the date when a new version of the row was extracted from the data source. If the value in the '_end_date' column is null, it indicates that the row is the most recent version. The data in this table is sourced from the website of 'Helsinki Urban Environment Division' in Finland (ISO country code: 'FI'). This table provides a historical view of the changes made to the base table rows and can be utilized in various data analytics tasks, such as tracking changes over time, analyzing trends, and identifying patterns in the data.
Field Descriptions
| Name |
Data type |
Description |
| _start_date | date | The start date indicating the beginning of validity period for the row version. |
|---|
| _end_date | date | The end date indicating the end of validity period for the row version. |
|---|
| _row_number | long | The row number representing the position of the row version within the table. |
|---|
| id | int | The unique identifier of the row version. |
|---|
| tyyppi | string | The type of the row version. |
|---|
| rakennuski | int | The building type. |
|---|
| paattymisp | string | The expiration date of the row version. |
|---|
| tekstifont | string | The font used for text in the row version. |
|---|
| tekstikoko | float | The size of the text in the row version. |
|---|
| tekstisuun | int | The orientation of the text in the row version. |
|---|
| luontipvm | string | The creation date of the row version. |
|---|
| muokkauspv | string | The modification date of the row version. |
|---|
| datanomist | string | The data owner of the row version. |
|---|
| paivitetty | string | The date of the last update on the row version. |
|---|
| 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 of the geometry data. |
|---|
| geom_center_x | double | The x-coordinate of the center of the geometry data. |
|---|
| geom_center_y | double | The y-coordinate of the center of the geometry data. |
|---|
| geom | binary | The geometry data. |
|---|
