Building Information for Open Data in Helsinki City, Finland
Click here for a data sample
This table contains information about building data in the city of Helsinki. It is sourced from the website of Helsinki City Environment Sector. The data originates from Finland (ISO country code: FI). The table includes various columns such as 'id', 'kg_krakenn', 'i_pyraknro', 'c_vtj_prt', 'c_kiinteis', 'i_nkoord', 'i_ekoord', 'c_valmpvm', 'c_julkisiv', 'i_kokala', 'i_kerrlkm', 'i_kerrosal', 'i_kellaral', 'd_ashuoala', 'c_kayttark', 'c_lammtapa', 'c_poltaine', 'c_rakeaine', 'i_raktilav', 'c_hissi', 'c_viemlii', 'c_vesilii', 'c_sahkolii', 'i_huoneist', 'katunimi_s', 'katunimi_r', 'osoitenume', 'postinumer', 'datanomist', 'paivitetty', 'geom_geojson', 'geom_geotext', 'geom_type', 'geom_centroid', 'geom_center_x', 'geom_center_y', 'geom'. This data can be utilized in various data analytics tasks such as analyzing building characteristics, identifying energy consumption patterns, determining building materials used, and spatial analysis to understand the distribution of buildings in Helsinki.
Field Descriptions
| Name |
Data type |
Description |
| _extract_date | date | The date when the data was extracted. |
|---|
| _row_number | long | The row number of the data entry. |
|---|
| id | int | The unique identifier for each entry. |
|---|
| kg_krakenn | int | The code for the building's construction type. |
|---|
| i_pyraknro | int | The number of staircases in the building. |
|---|
| c_vtj_prt | int | The official name of the building. |
|---|
| c_kiinteis | string | The name of the property. |
|---|
| i_nkoord | int | The northern coordinate of the building's location. |
|---|
| i_ekoord | int | The eastern coordinate of the building's location. |
|---|
| c_valmpvm | string | The date of the property's value assessment. |
|---|
| c_julkisiv | int | The type of façade of the building. |
|---|
| i_kokala | int | The total area of the building in square meters. |
|---|
| i_kerrlkm | int | The number of floors in the building. |
|---|
| i_kerrosal | int | The number of rooms on the main floor of the building. |
|---|
| i_kellaral | int | The number of rooms in the basement of the building. |
|---|
| d_ashuoala | int | The total area of the attic space in square meters. |
|---|
| c_kayttark | int | The primary use of the building. |
|---|
| c_lammtapa | int | The type of heating system in the building. |
|---|
| c_poltaine | int | The fuel type used for heating the building. |
|---|
| c_rakeaine | int | The material used for the building's frame. |
|---|
| i_raktilav | int | The volume of the building's frame in cubic meters. |
|---|
| c_hissi | string | Indicates whether the building has an elevator or not. |
|---|
| c_viemlii | string | The type of sewage system in the building. |
|---|
| c_vesilii | string | The type of water supply in the building. |
|---|
| c_sahkolii | string | The type of electricity supply in the building. |
|---|
| i_huoneist | int | The number of apartments in the building. |
|---|
| katunimi_s | string | The street name in Swedish. |
|---|
| katunimi_r | string | The street name in Finnish. |
|---|
| osoitenume | int | The house number. |
|---|
| postinumer | int | The postal code. |
|---|
| datanomist | string | The name of the data owner. |
|---|
| paivitetty | string | The date when the data was last updated. |
|---|
| geom_geojson | string | The geometry of the building in GeoJSON format. |
|---|
| geom_geotext | string | The geometry of the building in Well-Known Text (WKT) format. |
|---|
| geom_type | string | The type of geometry of the building. |
|---|
| geom_centroid | string | The centroid of the building's geometry. |
|---|
| geom_center_x | double | The X coordinate of the centroid. |
|---|
| geom_center_y | double | The Y coordinate of the centroid. |
|---|
| geom | binary | The complete geometry information of the building. |
|---|
