...
Column title | Description | Allowed values |
|---|---|---|
Group id | Used to identify which group this property belongs to. If this is not given, it'll be created automatically. Should be unique within the organization. | Any string |
Group name | Name of the property group. If this is not given, it'll be created automatically for you. | Any string |
Building prototype | Usage type of the property building. If building year will be empty, building prototype will be ignored. |
|
Electricity energy type | electricity, solar pv | |
Heating energy type | electricity, undefined heating system, district heating, air to air heat pump, air to water heat pump, exhaust air heat pump, water source heat pump, ground source heat pump, gas boiler, gas condensing boiler, oil boiler, solid fossil fuel boiler, wood pellet boiler, wood chip boiler, fireplace, solar collector, fireplace, solar collector, | |
Building floor area | Gross floor area of the building in m2. (FI: Bruttoala) | Integer |
Building net internal area | Net indoor area of the building in m2. (FI: Huoneistoala) | Numeric |
Building gross internal area | Gross indoor area of the building in m2. (FI: Kerrosala) | Numeric |
Floors | Amount of levels in the building. Ground floors is counted as one. | Integer |
Floor height | (Average) floor height in the building in metres. | Integer |
Build year | Build year of the building. Mandatory field for building prototype. | Integer |
Building volume | The volume of a building in m3. | Integer |
Facade | The facade material of the building. | brick, concrete, metal, plaster, wood |
Roof | The roof material of the building | bitumen, metal, tile |
Car parking | Type of car parking | None, Parking space, Garage, Carport, Undercover parking |
Lot size in m2 | Lot size in m2 | Numeric |
Own lot | Own lot | Boolean |
Is waterside lot | Is waterside lot | Boolean |
End year of lot lease | End year of lot lease | Numeric |
Garden building(s) | Garden building(s) | Boolean |
Is housing company | Is housing company | Boolean |
Property image URL | Property image URL | Text |
Technical Value | Building technical value for given year | Numeric |
Repurchase Value | Repurchase value for given year | Numeric |
Building condition | Building condition (%), if Repurchase value is not set, this value will be used for Repurchase value calculation, otherwise a default one will be used | Numeric |
Condition Year | Condition year. Must be set if one of three values above are being imported | Integer |
Portfolio id | The id of the portfolio where the building should be imported. If the portfolio id is set Organization key header became mandatory otherwise row will be skipped. The portfolio id should exist within the organization used as organization key and user should be a part of the organization too otherwise row will be skipped. | Integer |
Organization key | The key of the organization where the building should be imported. If the Organization key is set Portfolio id header became mandatory otherwise row will be skipped. The Organization key should exist as parent/child organization and user should be a part of the organization too otherwise row will be skipped. | Text |
...