Building Areas Polygon
Click here for a data sample
This table contains data from the 'Helsinki City Environment Sector' website, which originates from Finland. The table 'avoindatarakennusala__rakennusalapolygon' stores information related to building areas. It includes various columns such as '_extract_date', '_row_number', 'gid', 'rakennusal', 'tyyppi', 'maanalaine', 'kaavamerki', 'km2', 'lisakm2', 'lisakm2riv', 'kellari', 'kerrosluku', 'ullakko', 'varisavy', 'sitova', 'pintaala', 'lisatietoj', 'lisakm2kuv', 'yhtluontip', 'yhtmuokkau', 'yhtdatanom', 'asemakaava', 'ra_tyyppi', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', 'geom'. This data can be utilized in different data analytics scenarios, such as calculating the total area of different building types, analyzing the distribution of building features like 'kellari' (basement) and 'ullakko' (attic), exploring the relationship between building characteristics and 'asemakaava' (zoning plan), or visualizing the geographic distribution of building areas using the provided 'geom_geojson' and 'geom_geotext' columns.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | The date when the data was extracted. |
|---|
| _row_number | long | The sequential number of each row. |
|---|
| gid | int | The unique identifier of each row. |
|---|
| rakennusal | string | The building identifier. |
|---|
| tyyppi | string | The type of the building. |
|---|
| maanalaine | boolean | Indicates whether the building is underground or not. |
|---|
| kaavamerki | string | The zoning symbol of the area. |
|---|
| km2 | int | The area of the building in square kilometers. |
|---|
| lisakm2 | string | Additional area of the building in square kilometers. |
|---|
| lisakm2riv | boolean | Additional area of the building per row in square kilometers. |
|---|
| kellari | string | Indicates whether the building has a basement or not. |
|---|
| kerrosluku | int | The number of floors in the building. |
|---|
| ullakko | string | Indicates whether the building has an attic or not. |
|---|
| varisavy | int | The color tone of the building. |
|---|
| sitova | string | Indicates whether the building has a binding agreement or not. |
|---|
| pintaala | float | The surface area of the building. |
|---|
| lisatietoj | string | Additional information about the building. |
|---|
| lisakm2kuv | string | Additional area of the building in square kilometers according to an image. |
|---|
| yhtluontip | string | The creation date of the building data. |
|---|
| yhtmuokkau | string | The modification date of the building data. |
|---|
| yhtdatanom | string | The data submitter of the building data. |
|---|
| asemakaava | string | The zoning plan of the area. |
|---|
| ra_tyyppi | string | The type of the area. |
|---|
| geom_geojson | string | The geometry of the building in GeoJSON format. |
|---|
| geom_geotext | string | The geometry of the building in Geotext format. |
|---|
| geom_type | string | The type of the geometry of the building. |
|---|
| geom_centroid | string | The centroid point of the geometry of the building. |
|---|
| geom_center_x | double | The x-coordinate of the center point of the geometry of the building. |
|---|
| geom_center_y | double | The y-coordinate of the center point of the geometry of the building. |
|---|
| geom | binary | The geometry data of the building. |
|---|
