...
In order to import buildings, it is mandatory to provide the location details or building name and a unique id for each building. The location details can be given in as coordinates, national building id, or address details. For further details, see Overview. In addition, further details of a building can be imported by optional headers. To calculate renovations you need to provide building floor area, year, prototype, floors and location details.
Mandatory Headers
In addition to a unique building id, a full address, a national building id, coordinates or coordinates building name are mandatory to import a building.
Column title | Description | Allowed values |
|---|---|---|
Building id AND | An organization level unique building id. | Unique string |
Latitude and longitude OR | Make a column for latitude and a column for longitude. The coordinates are to be inside the building. | Numeric |
National building id OR | Specifies the unit in a building. The full address of the building is required when using the Unit specifier without Unit id. Unit specifier value can be anything which is unique within the given address. | Any string |
Country code, postcode, street address and city OR | Make a column for each of the four titles. Country code can take values FI, CA, CH, PL, SE, PT, UK, US. | String |
Building name | Name of the property building. If you have provided any other mandatory fields, it will be created automatically for you. | Any String |
Optional headers
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 nameprototype | Name Usage type of the property building. If this is not given, it'll be created automatically for you. | Any string | Building prototype | Usage type of the property building. | building year will be empty, building prototype will be ignored. |
|
Electricity energy type | grid electricity | |||||
Heating energy type | electric heating, district heating, oil boiler, gas boiler, ground-source heat pump, wooden pellet burner, solar hot water collector, gas condensing boiler, water source heat pump, eluppvärmining, fjärrvärmning, olja, and bergvärmepump | |||||
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 |
...