Building Subarea Polygon Version History
Click here for a data sample
This table contains the version history of rows from the 'avoindatarakennusala__rakennusalapolygon' table. It provides information about various attributes related to building polygons such as their type, size, location, and additional details. The '_start_date' column indicates the date when a particular version of the row was extracted from the data source, while the '_end_date' column represents the date when a new version of the row became available. If the '_end_date' value is null, it means that the row is the most recent version. The data in this table can be used for data analytics purposes, such as analyzing the changes in building types over time, identifying patterns in building sizes, or studying the distribution of underground structures. The table is sourced from the website of 'Helsinki City Environment Division', which originates from Finland (ISO country code 'fi').
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 of the version in the table. |
|---|
| gid | int | The unique identifier for the row. |
|---|
| rakennusal | string | The building area. |
|---|
| tyyppi | string | The type of building. |
|---|
| maanalaine | boolean | Indicates if the building is underground. |
|---|
| kaavamerki | string | The code for the area. |
|---|
| km2 | int | The area in square kilometers. |
|---|
| lisakm2 | string | Additional area in square kilometers. |
|---|
| lisakm2riv | boolean | Additional area in square kilometers for the row. |
|---|
| kellari | string | Indicates if the building has a cellar. |
|---|
| kerrosluku | int | The number of floors in the building. |
|---|
| ullakko | string | Indicates if the building has an attic. |
|---|
| varisavy | int | The color scheme of the building. |
|---|
| sitova | string | Indicates if the building is binding. |
|---|
| pintaala | float | The surface area of the building. |
|---|
| lisatietoj | string | Additional information about the building. |
|---|
| lisakm2kuv | string | Additional area in square kilometers for the image. |
|---|
| yhtluontip | string | The creation date for the row. |
|---|
| yhtmuokkau | string | The modification date for the row. |
|---|
| yhtdatanom | string | The date of the data change for the row. |
|---|
| asemakaava | string | The urban plan for the area. |
|---|
| ra_tyyppi | string | The type of the area. |
|---|
| geom_geojson | string | The geometry in GeoJSON format. |
|---|
| geom_geotext | string | The geometry 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 center of the geometry. |
|---|
| geom_center_y | double | The Y-coordinate of the center of the geometry. |
|---|
| geom | binary | The geometry of the area. |
|---|
