Building stock in Helsinki: Difference between revisions

Latest revision as of 08:47, 18 December 2018

This page is a knowledge crystal of subtype variable. The page identifier is Op_en7115
Moderator:Jouni (see all)

Upload data {{#opasnet_base_link:Op_en7115}}

During Decision analysis and risk management 2015 course, this page was used to collect student contributions. To see them, look at an archived version. The page has since been updated for its main use. Data in the archived tables was moved: Table 2. Energy parametres of buildings, Table 4. Energy sinks, Table 5. Changes in energy efficiency, Table 6. Important energy parametres. Tables 3, 7, and 8 did not contain data and were removed.

Question

What is the building stock in Helsinki and its projected future?

Answer

Current building stock in Helsinki by heating type.
Projected building stock based on 2015 data and urban plans.

+ Show code - Hide code

## This code is Op_en7115/ on page [[Building stock in Helsinki]].

library(OpasnetUtils)
library(ggplot2)

objects.latest("Op_en7115", code_name = "stockBuildings")

stockBuildings <- EvalOutput(stockBuildings)

ggplot(stockBuildings@output, aes(x = Time, weight = stockBuildingsResult, fill = Heating)) + 
	geom_bar(binwidth = 5) + theme_gray(base_size = 24) + 
	labs(
		title = "Current building stock (floor area) by heating type \n and year of construction", 
		x = "Construction year",
		y = expression("Floor area ( "*m^2*" )"))

ggplot(stockBuildings@output, aes(x = Time, weight = stockBuildingsResult, fill = Building)) + 
	geom_bar(binwidth = 5) + theme_gray(base_size = 24) + 
	labs(
		title = "Current building stock (floor area) by building type \n and year of construction", 
		x = "Construction year",
		y = expression("Floor area ( "*m^2*" )"))

Rationale

This part contains the data needed for calculations about the building stock in Helsinki. It shows the different building and heating types in Helsinki, and how much and what kind of renovations are done for the existing building stock in a year, including how much and how old building stock is demolished. This data is used in further calculations in the model.

There is also some other important data that wasn't used in the model's calculations. These include more accurate renovation statistics for residential buildings, U-value changes for renovations and thermal transmittance of different parts of residential buildings. This data is found under Data not used.

Carbon neutral Helsinki 2035

+ Show code - Hide code

# This is code Op_en/7115 on page [[Building stock in Helsinki]]
library(OpasnetUtils)
library(plotly)

objects.latest("Op_en6007", code_name = "miscellaneous") # [[OpasnetUtils/Drafts]] truncateIndex
objects.latest("Op_en6007", code_name = "hnh2035") # [[OpasnetUtils/Drafts]] pushIndicatorGraph
objects.latest("Op_en7237", code_name = "intermediates") # [[Helsinki energy decision 2015]] buildings etc.

buildings <- EvalOutput(buildings)

tmp <- truncateIndex(buildings,"Building",6)
colnames(tmp@output)[colnames(tmp@output)=="EnergySavingPolicy"] <- "Scenario"

#> unique(tmp$Scenario)
#[1] BAU                    Energy saving moderate Energy saving total   
#[4] WWF energy saving     
levels(tmp$Scenario) <- c("BAU","NA","tavoite","NA")
tmp <- tmp[tmp$Scenario!="NA",]


p_buildings_b <- plot_ly(
  oapply(tmp[tmp$Scenario=="BAU",], c("Building","Time"),sum)@output,
  x = ~Time, y = ~buildingsResult, color = ~Building,
  type = 'scatter', mode = 'lines') %>%
layout(
  title="Rakennusala talotyypeittäin",
  xaxis=list(title="Vuosi"),
  yaxis=list(title="Rakennusala (m2)")
)

p_buildings_h <- plot_ly(
  oapply(tmp[tmp$Scenario=="BAU",], c("Heating","Time"),sum)@output,
  x = ~Time, y = ~buildingsResult, color = ~Heating,
  type = 'scatter', mode = 'lines') %>%
  layout(
    title="Rakennusala lämmitysmuodoittain",
    xaxis=list(title="Vuosi"),
    yaxis=list(title="Rakennusala (m2)")
  )

pushIndicatorGraph(p_buildings_b, "https://hnh.teamy.fi/v1/indicator/12/")
pushIndicatorGraph(p_buildings_h, "https://hnh.teamy.fi/v1/indicator/13/")

Building stock

These tables are based on FACTA database classifications and their interpretation for assessments. This data is used for modelling. The data is large and can be seen from the Opasnet Base. Technical parts on this page are hidden for readability. Building types should match Energy use of buildings#Baseline energy consumption.

Show details

Building types(-)
Obs	Building types in Facta	Building	Number of the class
1	Yhden asunnon talot	Detached and semi-detached houses	11
2	Kahden asunnon talot	Detached and semi-detached houses	12
3	Muut erilliset pientalot	Detached and semi-detached houses	13
4	Rivitalot	Attached houses	21
5	Ketjutalot	Attached houses	22
6	Luhtitalot	Blocks of flats	32
7	Muut asuinkerrostalot	Blocks of flats	39
8	Vapaa-ajan asuinrakennukset	Free-time residential buildings	41
9	Myymälähallit	Commercial	111
10	Liike- ja tavaratalot, kauppakeskukset	Commercial	112
11	Myymälärakennukset	Commercial	119
12	Hotellit, motellit, matkustajakodit, kylpylähotellit	Commercial	121
13	Loma-, lepo- ja virkistyskodit	Commercial	123
14	Vuokrattavat lomamökit ja osakkeet (liiketoiminnallisesti)	Commercial	124
15	Muut majoitusliikerakennukset	Commercial	129
16	Asuntolat, vanhusten palvelutalot, asuntolahotellit	Commercial	131
17	Muut asuntolarakennukset	Commercial	139
18	Ravintolat, ruokalat ja baarit	Commercial	141
19	Toimistorakennukset	Offices	15
20	Toimistorakennukset	Offices	151
21	Rautatie- ja linja-autoasemat, lento- ja satamaterminaalit	Transport and communications buildings	161
22	Kulkuneuvojen suoja- ja huoltorakennukset	Transport and communications buildings	162
23	Pysäköintitalot	Transport and communications buildings	163
24	Tietoliikenteen rakennukset	Transport and communications buildings	164
25	Muut liikenteen rakennukset	Transport and communications buildings	169
26	Keskussairaalat	Buildings for institutional care	211
27	Muut sairaalat	Buildings for institutional care	213
28	Terveyskeskukset	Buildings for institutional care	214
29	Terveydenhuollon erityislaitokset	Buildings for institutional care	215
30	Muut terveydenhuoltorakennukset	Buildings for institutional care	219
31	Vanhainkodit	Buildings for institutional care	221
32	Lasten- ja koulukodit	Buildings for institutional care	222
33	Kehitysvammaisten hoitolaitokset	Buildings for institutional care	223
34	Muut huoltolaitosrakennukset	Buildings for institutional care	229
35	Lasten päiväkodit	Buildings for institutional care	231
36	Muualla luokittelemattomat sosiaalitoimen rakennukset	Buildings for institutional care	239
37	Vankilat	Buildings for institutional care	241
38	Teatterit, konsertti- ja kongressitalot, oopperat	Assembly buildings	311
39	Elokuvateatterit	Assembly buildings	312
40	Kirjastot ja arkistot	Assembly buildings	322
41	Museot ja taidegalleriat	Assembly buildings	323
42	Näyttelyhallit	Assembly buildings	324
43	Seurain-, nuoriso- yms. talot	Assembly buildings	331
44	Kirkot, kappelit, luostarit, rukoushuoneet	Assembly buildings	341
45	Seurakuntatalot	Assembly buildings	342
46	Muut uskonnollisten yhteisöjen rakennukset	Assembly buildings	349
47	Jäähallit	Assembly buildings	351
48	Uimahallit	Assembly buildings	352
49	Tennis-, squash- ja sulkapallohallit	Assembly buildings	353
50	Monitoimihallit ja muut urheiluhallit	Assembly buildings	354
51	Muut urheilu- ja kuntoilurakennukset	Assembly buildings	359
52	Muut kokoontumisrakennukset	Assembly buildings	369
53	Peruskoulut, lukiot ja muut	Educational buildings	511
54	Ammatillisten oppilaitosten rakennukset	Educational buildings	521
55	Korkeakoulurakennukset	Educational buildings	531
56	Tutkimuslaitosrakennukset	Educational buildings	532
57	Järjestöjen, liittojen, työnantajien yms. opetusrakennukset	Educational buildings	541
58	Muualla luokittelemattomat opetusrakennukset	Educational buildings	549
59	Voimalaitosrakennukset	Industrial buildings	611
60	Yhdyskuntatekniikan rakennukset	Industrial buildings	613
61	Teollisuushallit	Industrial buildings	691
62	Teollisuus- ja pienteollisuustalot	Industrial buildings	692
63	Muut teollisuuden tuotantorakennukset	Industrial buildings	699
64	Teollisuusvarastot	Warehouses	711
65	Kauppavarastot	Warehouses	712
66	Muut varastorakennukset	Warehouses	719
67	Paloasemat	Fire fighting and rescue service buildings	721
68	Väestönsuojat	Fire fighting and rescue service buildings	722
69	Muut palo- ja pelastustoimen rakennukset	Fire fighting and rescue service buildings	729
70	Navetat, sikalat, kanalat yms.	Agricultural buildings	811
71	Eläinsuojat, ravihevostallit, maneesit	Agricultural buildings	819
72	Viljankuivaamot ja viljan säilytysrakennukset	Agricultural buildings	891
73	Kasvihuoneet	Agricultural buildings	892
74	Turkistarhat	Agricultural buildings	893
75	Muut maa-, metsä- ja kalatalouden rakennukset	Agricultural buildings	899
76	Saunarakennukset	Other buildings	931
77	Talousrakennukset	Other buildings	941
78	Muualla luokittelemattomat rakennukset	Other buildings	999
79	Ammatilliset oppilaitokset	Educational buildings
80	Kirjastot	Other buildings
81	Lastenkodit, koulukodit	Other buildings
82	Loma- lepo- ja virkistyskodit	Other buildings
83	Monitoimi- ja muut urheiluhallit	Other buildings
84	Museot, taidegalleriat	Assembly buildings
85	Muut kerrostalot	Blocks of flats
86	Muut majoitusrakennukset	Commercial
87	Muut terveydenhoitorakennukset	Buildings for institutional care
88	Terveydenhoidon erityislaitokset (mm. kuntoutuslaitokset)	Buildings for institutional care
89	Vapaa-ajan asunnot	Free-time residential buildings
90	Viljankuivaamot ja viljan säilytysrakennukset, siilot	Warehouses

----#: . Viimeiset 12 riviä (ilman numeroa) ovat tyyppejä jotka ovat datassa (tai ainakin vanhassa taulukossa) mutta puuttuvat Sonjan luokittelusta. --Jouni (talk) 12:57, 24 August 2015 (UTC) (type: truth; paradigms: science: comment)

For residential buildings (classes A and B) the classification is kept more detailed than for other buildings. This is because residential buildings are the biggest energy consumers in Helsinki and different classes of residential buildings are examined separately.
Reference for the classification: http://www.stat.fi/meta/luokitukset/rakennus/001-1994/koko_luokitus.html

Heating types(-)
Obs	Heating types in Facta	Heating
1		Other
2	Kauko- tai aluelämpö	District heating
3	Kevyt polttoöljy	Light oil
4	Kivihiili, koksi tms.	Coal
5	Maalämpö tms.	Geothermal
6	Puu	Wood
7	Raskas polttoöljy	Fuel oil
8	Sähkö	Electricity
9	Kaasu	Gas
10	Muu	Other

The structures of the tables are based on CyPT Excel file N:\YMAL\Projects\ilmastotiekartta\Helsinki Data Input Template - Building Data.xlsx.

+ Show code - Hide code

library(OpasnetUtils)
library(ggplot2)

# [[Building stock in Helsinki]], building stock, locations by city area (in A Finnish coordinate system)
#stockBuildings <- Ovariable("stockBuildings", ddata = "Op_en7115.stock_details")
#colnames(stockBuildings@data)[colnames(stockBuildings@data) == "Built"] <- "Time"
#colnames(stockBuildings@data)[colnames(stockBuildings@data) == "Postal code"] <- "City_area"

# [[Building stock in Helsinki]]
dat <- opbase.data("Op_en7115.stock_details")[ , c(
#	"Rakennus ID",
	"Sijainti",
	"Valmistumisaika",
#	"Julkisivumateriaali",
	"Käyttötarkoitus",
#	"Lämmitystapa",
	"Polttoaine",
#	"Rakennusaine",
#	"Varusteena koneellinen ilmanvaihto",
#	"Perusparannus",
#	"Kunta rakennuttajana",
#	"Energiatehokkuusluokka",
#	"Varusteena aurinkopaneeli",
	"Tilavuus",
	"Kokonaisala",
	"Result" # Kerrosala m2
)]

colnames(dat) <- c("City_area", "Time", "Building types in Facta", "Heating types in Facta", "Tilavuus", "Kokonaisala", "Kerrosala")
dat$Time <- as.numeric(substring(dat$Time, nchar(as.character(dat$Time)) - 3))

#dat <- dat[dat$Time != 2015 , ] # This is used to compare numbers to 2014 statistics.

dat$Time <- as.numeric(as.character((cut(dat$Time, breaks = c(0, 1885 + 0:26*5), labels = as.character(1885 + 0:26*5)))))
dat$Tilavuus <- as.numeric(as.character(dat$Tilavuus))
dat$Kokonaisala <- as.numeric(as.character(dat$Kokonaisala))
dat$Kerrosala <- as.numeric(as.character(dat$Kerrosala))

build <- tidy(opbase.data("Op_en7115.building_types"))
colnames(build)[colnames(build) == "Result"] <- "Building"

heat <- tidy(opbase.data("Op_en7115.heating_types"))
colnames(heat)[colnames(heat) == "Result"] <- "Heating"

######################
# Korjaus
########################
temp <- as.character(heat$Heating)
temp[temp == "District heating"]  <- "District"
temp[temp == "Light oil"]  <- "Oil"
temp[temp == "Fuel oil"]  <- "Oil"

heat$Heating <- temp
########################################

dat <- merge(merge(dat, build), heat)#[c("City_area", "Time", "Building", "Heating", "stockBuildingsResult")]

dat$Kerrosala[is.na(dat$Kerrosala)] <- dat$Kokonaisala[is.na(dat$Kerrosala)] * 0.8 # If floor area is missing, estimate from total area.

cat("Kerrosala ilman 2015 (m^2)\n")
oprint(aggregate(dat["Kerrosala"], by = dat["Building"], FUN = sum, na.rm = TRUE))
cat("Kokonaisala ilman 2015 (m^2)\n")
oprint(aggregate(dat["Kokonaisala"], by = dat["Building"], FUN = sum, na.rm = TRUE))
cat("Tilavuus ilman 2015 (m^3)\n")
oprint(aggregate(dat["Tilavuus"], by = dat["Building"], FUN = sum, na.rm = TRUE))

temp <- aggregate(dat["Kerrosala"], by = dat[c("Time", "Building", "Heating")], FUN =sum, na.rm = TRUE)
colnames(temp)[colnames(temp) == "Kerrosala"] <- "stockBuildingsResult"

stockBuildings <- Ovariable("stockBuildings", data = temp)

objects.store(stockBuildings)
cat("Ovariable stockBuildings stored.\n")

Construction and demolition

It is assumed that construction occurs at a constant rate so that there is an increase of 42% in 2050 compared to 2013. Energy efficiency comes from Energy use of buildings.

+ Show code - Hide code

# This code is Op_en7115/changeBuildings on page [[Building stock in Helsinki]]
library(OpasnetUtils)

changeBuildings <- Ovariable("changeBuildings", 
	dependencies = data.frame(
		Name = c(
			"stockBuildings", 
			"efficiencyShares"
		),
		Ident = c(
			"Op_en7115/stockBuildings", # [[Building stock in Helsinki]]
			"Op_en5488/efficiencyShares" # [[Energy use of buildings]]
		)
	),
	formula = function(...) {

		out <- oapply(stockBuildings, cols = c("Time", "Constructed"), FUN = sum)
		out <- out * 0.013125 * 5 * efficiencyShares # linear increase 42% from 2013 to 2050
		out@output <- out@output[as.numeric(as.character(out@output$Time)) >= 2015 , ]

		return(out)
	}
)

objects.store(changeBuildings)
cat("Ovariable changeBuildings stored.\n")

Fraction of houses demolished per year.

Demolition rate(% /a)
Obs	Age	Rate
1	0	0
2	50	1
3	1000	1

+ Show code - Hide code

# This code is Op_en7115/demolitionRate on page [[Building stock in Helsinki]]
library(OpasnetUtils)

demolitionRate <- Ovariable('demolitionRate',
	dependencies = data.frame(Name = "dummy"),
	formula = function(...) {
		temp <- tidy(opbase.data('Op_en7115', subset = 'Demolition rate'))
		temp$Age <- round(as.numeric(as.character(temp$Age)))
		out <- as.data.frame(approx(
			temp$Age, 
			temp$Result, 
			n = (max(temp$Age) - min(temp$Age) + 1),
			method = "constant"
		))
		colnames(out) <- c("Age", "demolitionRateResult")
		out$demolitionRateResult <- out$demolitionRateResult / 100 * 10 # For ten-year intervals
		out <- Ovariable("demolitionRate", output = out, marginal = c(TRUE, FALSE))
		return(out)
	}
)

objects.store(demolitionRate)
cat("Object demolitionRate stored.\n")

Heating type conversion

The fraction of heating types in the building stock reflects the situation at the moment of construction and not currently. The heating type conversion corrects this by changing a fraction of heating methods to a different one at different timepoints. Cumulative fraction, other timepoints will be interpolated.

Yearly_heating_converted_factor(m2/m2)
Obs	Heating_from	Heating_to	Time	Result
1	Oil	Geothermal	2005	0
2	Oil	Geothermal	2015	0.5
3	Oil	Geothermal	2025	1

+ Show code - Hide code

library(OpasnetUtils)

heatTypeConversion <- Ovariable("heatTypeConversion", 
		dependencies = data.frame(
				Name = c(
						"buil", # stock at different timepoints
						"obstime"
				)
		),
		formula = function(...) {
			dat <- opbase.data("Op_en7115", subset = "Yearly_heating_converted_factor")
			colnames(dat)[colnames(dat) == "Time"] <- "Obsyear"

			dat$Obs <- NULL
			
			out <- data.frame()
			temp <- unique(dat[c("Heating_from", "Heating_to")])
			for (i in 1:nrow(temp)) {
				onetype <- merge(temp[i,], dat)
				tempout <- merge(obstime@output, onetype, all.x = TRUE)[c("Obsyear","Result")]
				tempout <- merge(tempout, temp[i,])
				
				for (j in (1:nrow(tempout))[is.na(tempout$Result)]) {
					a <- onetype$Obsyear[which.min(abs(as.numeric(as.character(onetype$Obsyear)) - as.numeric(as.character(obstime$Obsyear[j]))))]
					tempout$Result[j] <- onetype$Result[a]
				}
				out <- rbind(out, tempout)
			}
			
			out <- Ovariable(output = out, marginal = colnames(out) != "Result")
			
			colnames(out@output)[colnames(out@output) == "Heating_from"] <- "Heating"

			out <- buil * out
			
			out1 <- out
			out1$Result <- - out1$Result
			out1$Heating_to <- NULL
			
			out$Heating <- out$Heating_to
			out$Heating_to <- NULL
			
			out@output <- rbind(out1@output, out@output)
			
			#sum(out$Result)
			#nrow(out1@output)*2 - nrow(out@output)
			
			return(out)
		}
)
objects.store(heatTypeConversion)
cat("Ovariable heatTypeConversionstored.\n")

Renovations

Estimates from Laura Perez and Stephan Trüeb, unibas.ch N:\YMAL\Projects\Urgenche\WP9 Basel\Energy_scenarios_Basel_update.docx

Fraction of houses renovated per year(%)
Obs	Age	Result	Description
1	0	0	Estimates from Laura Perez and Stephan Trüeb
2	20	0	Assumption Result applies to buildings older than the value in the Age column.
3	25	1
4	30	1
5	50	1
6	100	1
7	1000	1

+ Show code - Hide code

library(OpasnetUtils)

renovationRate <- Ovariable('renovationRate',
	dependencies = data.frame(Name = "dummy"),
	formula = function(...) {
		temp <- tidy(opbase.data('Op_en7115', subset = 'Fraction of houses renovated per year'))
		temp$Age <- round(as.numeric(as.character(temp$Age)))
		out <- as.data.frame(approx(
			temp$Age, 
			temp$Result, 
			n = (max(temp$Age) - min(temp$Age) + 1),
			method = "constant"
		))
		colnames(out) <- c("Age", "renovationRateResult")
		out$renovationRateResult <- out$renovationRateResult / 100
		out <- Ovariable("renovationRate", output = out, marginal = c(TRUE, FALSE))
		return(out)
	}
)

objects.store(renovationRate)
cat("Object renovationRate stored.\n")

Popularity of renovation types(%)
Obs	Renovation	Fraction
1	None	0
2	Windows	65
3	Technical systems	30
4	Sheath reform	5
5	General	0

+ Show code - Hide code

library(OpasnetUtils)

renovationShares <- Ovariable("renovationShares",
	dependencies = data.frame(Name = "dummy"),
	formula = function(...) {
	out <- Ovariable("raw", ddata = 'Op_en7115', subset = 'Popularity of renovation types')
	out <- findrest((out), cols = "Renovation", total = 100) / 100

	renovationyear <- Ovariable("renovationyear", data = data.frame(
		Obsyear = factor(c(2015, 2025, 2035, 2045, 2055, 2065)),
		Result = 1
	))

	out <- out * renovationyear # renovation shares repeated for every potential renovation year.

	out@output$Renovation <- factor(out@output$Renovation, levels = c(
		"None", 
		"General", 
		"Windows", 
		"Technical systems", 
		"Sheath reform"
	), ordered = TRUE)

	return(out)
	}
)

objects.store(
	renovationShares # Fraction of renovation type when renovation is done.
)

cat("Objects renovationShares stored.\n")

Locations of city areas

Locations of city areas (hidden for readability).

Show details

The positions listed here are used for exposure modelling. Area code matches with stock detail data on Building stock in Helsinki. The coordinates should be visually checked from http://www.karttapaikka.fi referencing picture X.

Locations of city areas(epsg:ETRS-TM35FIN)
Obs	City_area	Area code	N	E
1	001	KRU	6672352	386953
2	002	KLU	6672912	385513
3	003	KAA	6671692	386153
4	004	KAM	6671692	385233
5	005	PUN	6671352	385113
6	006	E	6670792	385573
7	007	UL	6670372	385973
8	008	KAT	6671752	387933
9	009	KAI	6670632	387573
10	010	SÖR	6674072	387453
11	011	KAL	6673712	385933
12	012	ALP	6673712	385933
13	013	ETU	6672552	383733
14	014	TAK	6673472	384753
15	015	ARI	6673872	382813
16	016	RUS	6676072	383793
17	017	PAS	6676092	385093
18	018	LAA	6675052	384433
19	019	MUSKOR	6672592	388413
20	020	LÄN	6670552	384033
21	021	HER	6675432	387573
22	022	VAL	6674912	386573
23	023	TOU	6676272	387793
24	024	KUM	6676192	386593
25	025	KÄP	6676932	386153
26	026	KOS	6677812	387393
27	027	VAN	6676972	387933
28	028	OUL	6678952	386533
29	029	HAA	6678032	383353
30	030	MUN	6674752	381733
31	031	LAU	6670952	381593
32	032	KON	6679852	380593
33	033	KAA	6680752	382413
34	034	PAK	6680392	385993
35	035	TUO	6682492	385653
36	036	VII	6676912	389553
37	037	PUK	6680352	388573
38	038	MAL	6680252	390153
39	039	TAP	6682632	389273
40	040	SUUT	6684152	389693
41	041	SUUR	6682512	393113
42	042	KUL	6674292	389193
43	043	HER	6675272	391093
44	044	TAM	6674252	392653
45	045	VAR	6677372	394013
46	046	PIT	6678172	381453
47	047	MEL	6679192	394193
48	048	VAR	6672872	393793
49	049	LAA	6672072	391593
50	050	VIL	6670412	395553
51	051	SAN	6668612	392993
52	052	SUO	6668912	388813
53	053	ULK	6666992	395973
54	054	VUO	6675252	397553
55	055	ÖST	6681312	399633
56	056	SAL	6679252	3985130
57	057	TAL	6679452	400333
58	058	KAR	6680652	401453
59	059	ULT	6683472	400453
60	401		6684572	390899
61	402		6680780	382563
62	403		6677628	383571
63	404		6682460	385139
64	405		6675756	391603
65	406		6679980	391731
66	407		6679724	380771
67	408		6676828	387779
68	409		6673900	389379
69	410		6675708	386355
70	411		6678556	387027
71	412		6671724	392691
72	413		6674156	391539
73	414		6668124	381699
74	415		6673356	380707
75	417		6677388	399763
76	418		6680476	390883
77	419		6678956	395043
78	420		6676332	381987
79	421		6683244	385635
80	422		6678972	386803
81	423		6680252	385939
82	424		6679740	388819
83	425		6669196	391683
84	426		6683676	388515
85	427		6684108	389843
86	428		6678156	381315
87	429		6682524	391027
88	430		6672204	391459
89	431		6681740	386131
90	432		6672924	385635
91	433		6677196	394211
92	434		6678188	390147
93	435		6676380	397027
94	436		6676380	384755
95	437		6674156	383123
96	438		6682316	398147
97	439		6679612	400499
98	440		6684124	402355
99	441		6679724	399027
100	442		6682076	400499
101	878		6678380	390771
102	895		6678380	390771

Data not used

This contains data that was not used in the model's calculations. This includes renovation rates, the rates of heat flowing out of buildings and total floor areas of multiple types of buildings in Helsinki. The floor area data is also found in the background data of this page, which was used in the model.

**Effective floor area of buildings by building type.**
Building	Baseline	2020	2025	2050	Year of baseline	Description
Residential	27884795	32472388	34890241	44069914	2014	Building stock of Helsinki area, 2014
Public	4537025	4764475	4945952	5855546	2014	Building stock of Helsinki area, 2014
Industrial	3277271	3306063	3360467	3640854	2014	Building stock of Helsinki area, 2014
Other	10861972	11406505	11840973	13806423	2014	Building stock of Helsinki area, 2014

Notes

Estimates were based on Siemens City Performance toolin seuraava kokous 2.2 and some derived calculations on BUILDING STOCK CALCULATION 2015.
How to get the numbers for the baseline floor area for residential, public, industrial and other: Residential floor area was named as residential together, public by summing the floor area of health care, education and common buildings, industrial buildings were as such and other buildings comprise of business, traffic, office and storage buildings.
Ref. Helsinki master plan for 2050: there are 860 000 citizens living in Helsinki (ref. www.yleiskaava.fi, visio2050); Residental buildings => fast growth
Prediction of citizen number in Helsinki in 2020, 2030, 2040 and 2050 was used for calculations (ref. Helsingin 30% päästövähennysselvitys).
Helsinki’s climate policy: 30% reduction in emissions: In 2010 the proportion of jobs in services and public sectors was 94%, and in industry 6%. In 2020 the proportion of jobs in services and public sectors is estimated to be 96%, and in industry 4%. Public and other buildings => between fast growth option and basic option, Industry=> Basic option
Prediction of job number in Helsinki in 2020, 2030, 2040 and 2050 was used for calculations (ref. Helsingin 30% päästövähennysselvitys).
Tables one and two The presentation of Tables 1 and 2

Technical notes:

Sheet 4_Input Buildings (Area Demand). Priority 1. Auxiliaries PPT. Absolute increase/decrease rate will be based on the inhabitants projected in time.

This is another list building types that was considered but rejected as too complex: Residential buildings, Government & public administration buildings, Commercial offices buildings, Data centers buildings, Education and K12 and universitiy buildings, Hospitals and healthcare buildings, Hotels and hospitality and leisure buildings, Exhibitions and fairs and halls buildings, Retail and stores and shops buildings, Warehouses & shopping mall buildings, Industrial buildings, Non residential buildings unspecified.

There was a problem with missing data. There is more than 400000 m^2 floor area that is missing; this is estimated from total area that is available for these buildings. For other buildings, there is more than 400000 m^2 total area missing from buildings where floor area is given. See statistical analysis [1]. This was corrected by inputation so that is floor area was missing, 0.8*total_area was used instead [2].

Renovations per year made in residental buildings owned by Helsinki city, by construction year of the buildings.^[1]
Construction year	Balcony glasses	Windows	Julkisivujen peruskorjaus	Vesikattojen peruskojaus	Lämmönvaihtimen uusiminen	Patteriverkoston säätö	Kylpyhuonekalusteiden vaihto	Patteriventtiilien vaihto	New balcony doors	LTO-laitteen asennus	Water consumption measurements
-20	0,0 %	1,1 %	1,1 %	1,1 %	1,1 %	1,1 %	1,1 %	1,1 %	1,1 %	1,1 %	1,1 %
21-25	0,0 %	10,3 %	1,2 %	11,1 %	10,3 %	10,3 %	1,2 %	10,3 %	1,2 %	10,3 %	10,3 %
26-30	0,0 %	0,0 %	0,0 %	0,0 %	0,0 %	0,0 %	0,0 %	0,0 %	0,0 %	9,5 %	0,0 %
31-35	0,0 %	0,0 %	0,0 %	0,0 %	0,0 %	0,0 %	0,0 %	0,0 %	0,0 %	0,0 %	0,0 %
36-40	0,0 %	0,0 %	0,0 %	0,0 %	4,2 %	4,2 %	0,0 %	0,0 %	0,0 %	4,2 %	0,0 %
41-45	0,0 %	16,7 %	0,0 %	16,7 %	16,7 %	16,7 %	0,0 %	16,7 %	0,0 %	16,7 %	16,7 %
46-50	0,0 %	5,2 %	0,0 %	7,4 %	7,4 %	7,4 %	0,0 %	7,4 %	0,0 %	5,2 %	5,2 %
51-55	0,0 %	11,3 %	0,0 %	8,8 %	8,8 %	8,8 %	0,0 %	8,8 %	0,0 %	8,8 %	16,2 %
56-60	0,0 %	5,4 %	0,0 %	4,9 %	6,2 %	7,1 %	0,0 %	6,2 %	4,5 %	4,5 %	5,4 %
61-65	0,0 %	1,5 %	1,3 %	0,8 %	2,9 %	2,4 %	1,0 %	2,4 %	0,9 %	0,9 %	2,9 %
66-70	0,6 %	2,9 %	1,2 %	2,8 %	1,4 %	2,3 %	1,1 %	1,1 %	0,1 %	1,1 %	1,1 %
71-75	3,2 %	3,1 %	3,4 %	2,9 %	3,1 %	2,6 %	0,2 %	1,1 %	0,2 %	0,2 %	0,2 %
76-80	0,1 %	2,7 %	0,1 %	0,7 %	2,0 %	1,7 %	1,1 %	1,2 %	0,2 %	0,4 %	0,2 %
81-85	1,0 %	2,8 %	0,7 %	2,3 %	3,3 %	4,8 %	3,5 %	0,0 %	0,0 %	0,0 %	0,8 %
86-90	0,0 %	1,3 %	0,0 %	2,1 %	6,1 %	1,6 %	0,7 %	1,8 %	0,3 %	0,3 %	1,0 %
91-95	0,6 %	0,3 %	0,0 %	3,9 %	8,6 %	1,9 %	5,1 %	0,8 %	0,2 %	0,0 %	1,3 %
96-00	0,1 %	0,0 %	0,0 %	0,6 %	1,2 %	1,0 %	1,5 %	1,0 %	0,0 %	0,0 %	4,2 %
01-05	2,9 %	0,0 %	0,0 %	0,0 %	1,2 %	1,0 %	0,0 %	1,0 %	0,0 %	0,0 %	0,7 %
06-10	1,7 %	0,0 %	0,0 %	0,0 %	0,5 %	0,5 %	0,0 %	0,5 %	0,0 %	0,0 %	0,0 %

←--#: . In the document there are similar tables for total renovations from 2010 onwards to years 2016, 2020 and 2050. --Heta (talk) 09:28, 16 June 2015 (UTC) (type: truth; paradigms: science: defence)

**Toimenpiteiden vaikutukset yksittäisessä kohteessa ja toimenpiteisiin liittyviä huomautuksia.^[1]**
Action	The feature in question	Difference to before	Unit	Notes
Glass for balconies	U-value for windows	-0,3	W/m²,K	Säästö 1-4% rakennustasolla
Changing the windows	U-value for windows	-1	W/m²,K	Vanhoista osa kaksilasisia ja osa kolmilasisia. Uudes 1,0 W/m²,K tai alle
Julkisivun peruskorjaus	U-value of walls	-0,2	W/m²,K	U-arvo puolitetaan eli n. 100 mm lisäeristys
Vesikattojen peruskorjaus	Yläpohjan U-arvo	-0,15	W/m²,K	Oletetaan 50% lisäeristys U-arvo puoleen eli n. 100 mm lisäerstys
Balcony door change	U-value of doors	-0,5	W/m²,K	Tiivistyminen tuo lisäsäästöä

**Thermal transmittances of building components and air flow rates. Averaged values calculates from the detailed model are presented here.^[2]**
Construction decade		Thermal transmittance factors for building components (W/m2K)					Ventilation and leakage air rates (1/h)
Construction decade		Floor	Roof	Walls	Windows	Outdoors	Supply air through the heat recovery unit	Supply air bypassing the heat recovery unit	Leakage air
Before 1980	Single family house	0.52	0.32	0.54	2.14	1.18	0.30	0.05	0.20
	Row house	0.52	0.36	0.56	2.15	1.00	0.3	0.05	0.20
	Apartment building	0.59	0.37	0.61	2.18	1.40	0.37	0.00	0.10
1980's	Single family house	0.30	0.21	0.28	1.70	1.00	0.30	0.05	0.15
	Row house	0.32	0.22	0.30	1.70	1.00	0.30	0.05	0.15
	Apartment building	0.34	0.23	0.29	1.80	1.40	0.35	0.00	0.10
1990's	Single family house	0.25	0.20	0.25	1.70	1.00	0.30	0.05	0.15
	Row house	0.32	0.22	0.28	1.70	1.00	0.30	0.05	0.15
	Apartment building	0.332	0.22	0.28	1.75	1.40	0.38	0.00	0.10
2000's	Single family house	0.24	0.17	0.24	1.40	1.00	0.30	0.05	0.13
	Row house	0.28	0.18	0.26	1.50	1.00	0.45	0.05	0.15
	Apartment building	0.28	0.18	0.26	1.50	1.40	0.55	0.00	0.10
2010's	Single family house	0.16	0.09	0.17	1.00	1.00	0.30	0.05	0.10
	Row house	0.16	0.09	0.17	1.00	1.00	0.50	0.05	0.15
	Apartment building	0.16	0.09	0.17	1.00	1.00	0.60	0.00	0.10

References

↑ ^1.0 ^1.1 HAESS Final report, Tampere University of Technology, 2010
↑ MK Mattinen, J Heljo, J Vihola, A Kurvinen, S Lehtoranta, A Nissinen: Modeling and visualisation of residential sector energy consumption and greenhouse gas emissions

Related files

[uarvo-1] 1.0 ^1.1 HAESS Final report, Tampere University of Technology, 2010

[2] MK Mattinen, J Heljo, J Vihola, A Kurvinen, S Lehtoranta, A Nissinen: Modeling and visualisation of residential sector energy consumption and greenhouse gas emissions

[1]

[2]

In English
Assessment	Main page \| Helsinki energy decision options 2015
Helsinki data	Building stock in Helsinki \| Helsinki energy production \| Helsinki energy consumption \| Energy use of buildings \| Emission factors for burning processes \| Prices of fuels in heat production \| External cost
Models	Building model \| Energy balance \| Health impact assessment \| Economic impacts
Related assessments	Climate change policies in Helsinki \| Climate change policies and health in Kuopio \| Climate change policies in Basel
In Finnish
Yhteenveto	Helsingin energiapäätös 2015 \| Helsingin energiapäätöksen vaihtoehdot 2015 \| Helsingin energiapäätökseen liittyviä arvoja \| Helsingin energiapäätös 2015.pptx

Building stock in Helsinki: Difference between revisions

Latest revision as of 08:47, 18 December 2018

Contents

Question

Answer

Rationale

Carbon neutral Helsinki 2035

Building stock

Construction and demolition

Heating type conversion

Renovations

Locations of city areas

Data not used

See also

References

Related files

Navigation menu

@@ Line 1: / Line 1: @@
+<noinclude>
 [[Category:Helsinki]]
 [[Category:Buildings]]
 {{variable|moderator=Jouni}}
+:''During [[Decision analysis and risk management 2015]] course, this page was used to collect student contributions. To see them, look at [http://en.opasnet.org/en-opwiki/index.php?title=Building_stock_in_Helsinki&oldid=37151 an archived version]. The page has since been updated for its main use. Data in the archived tables was moved: [[Helsinki energy consumption#Energy parametres of buildings| Table 2. Energy parametres of buildings]], [[Helsinki energy consumption#Energy demand|Table 4. Energy sinks]], [[Helsinki energy consumption#Energy demand| Table 5. Changes in energy efficiency]], [[Helsinki energy consumption#Heating parametres of buildings|Table 6. Important energy parametres]]. Tables 3, 7, and 8 did not contain data and were removed.
+</noinclude>
 == Question ==
-What is the building stock in Helsinki and what are some of the key parameters of energy use?
+What is the building stock in Helsinki and its projected future?
 == Answer ==
-=== Data ===
+<gallery widths="400px" heights="350px">
+File:Current building stock in Helsinki.png|Current building stock in Helsinki by heating type.
+File:Building stock in Helsinki by heating.png|Projected building stock based on 2015 data and urban plans.
+</gallery>
-* [[Unit heat consumption of buildings in Finland]]
+<rcode embed=1 graphics=1>
-* http://era17.fi/wp-content/uploads/2010/10/sitran_selvityksia_39.pdf page 25
+## This code is Op_en7115/ on page [[Building stock in Helsinki]].
-* http://www.teeparannus.fi/attachements/2010-12-21T11-54-1114846.pdf pages 8-9, also 40-45
-* http://www.vtt.fi/inf/pdf/tiedotteet/2007/T2377.pdf page 20-21, also 30, 80
+library(OpasnetUtils)
-* [[Heating consumption of buildings]]
+library(ggplot2)
+objects.latest("Op_en7115", code_name = "stockBuildings")
+stockBuildings <- EvalOutput(stockBuildings)
+ggplot(stockBuildings@output, aes(x = Time, weight = stockBuildingsResult, fill = Heating)) +
+	geom_bar(binwidth = 5) + theme_gray(base_size = 24) +
+	labs(
+		title = "Current building stock (floor area) by heating type \n and year of construction",
+		x = "Construction year",
+		y = expression("Floor area ( "*m^2*" )"))
+ggplot(stockBuildings@output, aes(x = Time, weight = stockBuildingsResult, fill = Building)) +
+	geom_bar(binwidth = 5) + theme_gray(base_size = 24) +
+	labs(
+		title = "Current building stock (floor area) by building type \n and year of construction",
+		x = "Construction year",
+		y = expression("Floor area ( "*m^2*" )"))
+</rcode>
+== Rationale ==
+This part contains the data needed for calculations about the building stock in Helsinki. It shows the different building and heating types in Helsinki, and how much and what kind of renovations are done for the existing building stock in a year, including how much and how old building stock is demolished. This data is used in further calculations in the model.
+There is also some other important data that wasn't used in the model's calculations. These include more accurate renovation statistics for residential buildings, U-value changes for renovations and thermal transmittance of different parts of residential buildings. This data is found under [[Building stock in Helsinki#Data not used|Data not used]].
+=== Carbon neutral Helsinki 2035 ===
+<rcode label="Push indicators to HNH2035 (for developers only)" embed=1>
+# This is code Op_en/7115 on page [[Building stock in Helsinki]]
+library(OpasnetUtils)
+library(plotly)
+objects.latest("Op_en6007", code_name = "miscellaneous") # [[OpasnetUtils/Drafts]] truncateIndex
+objects.latest("Op_en6007", code_name = "hnh2035") # [[OpasnetUtils/Drafts]] pushIndicatorGraph
+objects.latest("Op_en7237", code_name = "intermediates") # [[Helsinki energy decision 2015]] buildings etc.
+buildings <- EvalOutput(buildings)
+tmp <- truncateIndex(buildings,"Building",6)
+colnames(tmp@output)[colnames(tmp@output)=="EnergySavingPolicy"] <- "Scenario"
+#> unique(tmp$Scenario)
+#[1] BAU                    Energy saving moderate Energy saving total
+#[4] WWF energy saving
+levels(tmp$Scenario) <- c("BAU","NA","tavoite","NA")
+tmp <- tmp[tmp$Scenario!="NA",]
+p_buildings_b <- plot_ly(
+  oapply(tmp[tmp$Scenario=="BAU",], c("Building","Time"),sum)@output,
+  x = ~Time, y = ~buildingsResult, color = ~Building,
+  type = 'scatter', mode = 'lines') %>%
+layout(
+  title="Rakennusala talotyypeittäin",
+  xaxis=list(title="Vuosi"),
+  yaxis=list(title="Rakennusala (m2)")
+)
+p_buildings_h <- plot_ly(
+  oapply(tmp[tmp$Scenario=="BAU",], c("Heating","Time"),sum)@output,
+  x = ~Time, y = ~buildingsResult, color = ~Heating,
+  type = 'scatter', mode = 'lines') %>%
+  layout(
+    title="Rakennusala lämmitysmuodoittain",
+    xaxis=list(title="Vuosi"),
+    yaxis=list(title="Rakennusala (m2)")
+  )
+pushIndicatorGraph(p_buildings_b, "https://hnh.teamy.fi/v1/indicator/12/")
+pushIndicatorGraph(p_buildings_h, "https://hnh.teamy.fi/v1/indicator/13/")
+</rcode>
+=== Building stock ===
+'''These tables are based on FACTA database classifications and their interpretation for assessments.
+This data is used for modelling. The data is large and can be seen from [http://en.opasnet.org/w/Special:Opasnet_Base?id=Op_en7115.stock_details the Opasnet Base]. Technical parts on this page are hidden for readability. Building types should match [[Energy use of buildings#Baseline energy consumption]].
+{{hidden|
+<t2b name="Building types" index="Building types in Facta" obs="Building" desc="Number of the class" unit="-">
+Yhden asunnon talot|Detached and semi-detached houses|11
+Kahden asunnon talot|Detached and semi-detached houses|12
+Muut erilliset pientalot|Detached and semi-detached houses|13
+Rivitalot|Attached houses|21
+Ketjutalot|Attached houses|22
+Luhtitalot|Blocks of flats|32
+Muut asuinkerrostalot|Blocks of flats|39
+Vapaa-ajan asuinrakennukset|Free-time residential buildings|41
+Myymälähallit|Commercial|111
+Liike- ja tavaratalot, kauppakeskukset|Commercial|112
+Myymälärakennukset|Commercial|119
+Hotellit, motellit, matkustajakodit, kylpylähotellit|Commercial|121
+Loma-, lepo- ja virkistyskodit|Commercial|123
+Vuokrattavat lomamökit ja osakkeet (liiketoiminnallisesti)|Commercial|124
+Muut majoitusliikerakennukset|Commercial|129
+Asuntolat, vanhusten palvelutalot, asuntolahotellit|Commercial|131
+Muut asuntolarakennukset|Commercial|139
+Ravintolat, ruokalat ja baarit|Commercial|141
+Toimistorakennukset|Offices|15
+Toimistorakennukset|Offices|151
+Rautatie- ja linja-autoasemat, lento- ja satamaterminaalit|Transport and communications buildings|161
+Kulkuneuvojen suoja- ja huoltorakennukset|Transport and communications buildings|162
+Pysäköintitalot|Transport and communications buildings|163
+Tietoliikenteen rakennukset|Transport and communications buildings|164
+Muut liikenteen rakennukset|Transport and communications buildings|169
+Keskussairaalat|Buildings for institutional care|211
+Muut sairaalat|Buildings for institutional care|213
+Terveyskeskukset|Buildings for institutional care|214
+Terveydenhuollon erityislaitokset|Buildings for institutional care|215
+Muut terveydenhuoltorakennukset|Buildings for institutional care|219
+Vanhainkodit|Buildings for institutional care|221
+Lasten- ja koulukodit|Buildings for institutional care|222
+Kehitysvammaisten hoitolaitokset|Buildings for institutional care|223
+Muut huoltolaitosrakennukset|Buildings for institutional care|229
+Lasten päiväkodit|Buildings for institutional care|231
+Muualla luokittelemattomat sosiaalitoimen rakennukset|Buildings for institutional care|239
+Vankilat|Buildings for institutional care|241
+Teatterit, konsertti- ja kongressitalot, oopperat|Assembly buildings|311
+Elokuvateatterit|Assembly buildings|312
+Kirjastot ja arkistot|Assembly buildings|322
+Museot ja taidegalleriat|Assembly buildings|323
+Näyttelyhallit|Assembly buildings|324
+Seurain-, nuoriso- yms. talot|Assembly buildings|331
+Kirkot, kappelit, luostarit, rukoushuoneet|Assembly buildings|341
+Seurakuntatalot|Assembly buildings|342
+Muut uskonnollisten yhteisöjen rakennukset|Assembly buildings|349
+Jäähallit|Assembly buildings|351
+Uimahallit|Assembly buildings|352
+Tennis-, squash- ja sulkapallohallit|Assembly buildings|353
+Monitoimihallit ja muut urheiluhallit|Assembly buildings|354
+Muut urheilu- ja kuntoilurakennukset|Assembly buildings|359
+Muut kokoontumisrakennukset|Assembly buildings|369
+Peruskoulut, lukiot ja muut|Educational buildings|511
+Ammatillisten oppilaitosten rakennukset|Educational buildings|521
+Korkeakoulurakennukset|Educational buildings|531
+Tutkimuslaitosrakennukset|Educational buildings|532
+Järjestöjen, liittojen, työnantajien yms. opetusrakennukset|Educational buildings|541
+Muualla luokittelemattomat opetusrakennukset|Educational buildings|549
+Voimalaitosrakennukset|Industrial buildings|611
+Yhdyskuntatekniikan rakennukset|Industrial buildings|613
+Teollisuushallit|Industrial buildings|691
+Teollisuus- ja pienteollisuustalot|Industrial buildings|692
+Muut teollisuuden tuotantorakennukset|Industrial buildings|699
+Teollisuusvarastot|Warehouses|711
+Kauppavarastot|Warehouses|712
+Muut varastorakennukset|Warehouses|719
+Paloasemat|Fire fighting and rescue service buildings|721
+Väestönsuojat|Fire fighting and rescue service buildings|722
+Muut palo- ja pelastustoimen rakennukset|Fire fighting and rescue service buildings|729
+Navetat, sikalat, kanalat yms.|Agricultural buildings|811
+Eläinsuojat, ravihevostallit, maneesit|Agricultural buildings|819
+Viljankuivaamot ja viljan säilytysrakennukset|Agricultural buildings|891
+Kasvihuoneet|Agricultural buildings|892
+Turkistarhat|Agricultural buildings|893
+Muut maa-, metsä- ja kalatalouden rakennukset|Agricultural buildings|899
+Saunarakennukset|Other buildings|931
+Talousrakennukset|Other buildings|941
+Muualla luokittelemattomat rakennukset|Other buildings|999
+Ammatilliset oppilaitokset|Educational buildings|
+Kirjastot|Other buildings|
+Lastenkodit, koulukodit|Other buildings|
+Loma- lepo- ja virkistyskodit|Other buildings|
+Monitoimi- ja muut urheiluhallit|Other buildings|
+Museot, taidegalleriat|Assembly buildings|
+Muut kerrostalot|Blocks of flats|
+Muut majoitusrakennukset|Commercial|
+Muut terveydenhoitorakennukset|Buildings for institutional care|
+Terveydenhoidon erityislaitokset (mm. kuntoutuslaitokset)|Buildings for institutional care|
+Vapaa-ajan asunnot|Free-time residential buildings|
+Viljankuivaamot ja viljan säilytysrakennukset, siilot|Warehouses|
+</t2b>
+{{comment|# |Viimeiset 12 riviä (ilman numeroa) ovat tyyppejä jotka ovat datassa (tai ainakin vanhassa taulukossa) mutta puuttuvat Sonjan luokittelusta.|--[[User:Jouni|Jouni]] ([[User talk:Jouni|talk]]) 12:57, 24 August 2015 (UTC)}}
+For residential buildings (classes A and B) the classification is kept more detailed than for other buildings. This is because residential buildings are the biggest energy consumers in Helsinki and different classes of residential buildings are examined separately.<br />
+Reference for the classification: http://www.stat.fi/meta/luokitukset/rakennus/001-1994/koko_luokitus.html
-==== Building stock ====
+<t2b name="Heating types" index="Heating types in Facta" obs="Heating" unit="-">
+|Other
+Kauko- tai aluelämpö|District heating
+Kevyt polttoöljy|Light oil
+Kivihiili, koksi tms.|Coal
+Maalämpö tms.|Geothermal
+Puu|Wood
+Raskas polttoöljy|Fuel oil
+Sähkö|Electricity
+Kaasu|Gas
+Muu|Other
+</t2b>
 The structures of the tables are based on CyPT Excel file N:\YMAL\Projects\ilmastotiekartta\Helsinki Data Input Template - Building Data.xlsx.
+}}
+<rcode name="stockBuildings" label="Initiate stockBuildings (developers only)" embed=1 store=1>
+library(OpasnetUtils)
+library(ggplot2)
+# [[Building stock in Helsinki]], building stock, locations by city area (in A Finnish coordinate system)
+#stockBuildings <- Ovariable("stockBuildings", ddata = "Op_en7115.stock_details")
+#colnames(stockBuildings@data)[colnames(stockBuildings@data) == "Built"] <- "Time"
+#colnames(stockBuildings@data)[colnames(stockBuildings@data) == "Postal code"] <- "City_area"
+# [[Building stock in Helsinki]]
+dat <- opbase.data("Op_en7115.stock_details")[ , c(
+#	"Rakennus ID",
+	"Sijainti",
+	"Valmistumisaika",
+#	"Julkisivumateriaali",
+	"Käyttötarkoitus",
+#	"Lämmitystapa",
+	"Polttoaine",
+#	"Rakennusaine",
+#	"Varusteena koneellinen ilmanvaihto",
+#	"Perusparannus",
+#	"Kunta rakennuttajana",
+#	"Energiatehokkuusluokka",
+#	"Varusteena aurinkopaneeli",
+	"Tilavuus",
+	"Kokonaisala",
+	"Result" # Kerrosala m2
+)]
+colnames(dat) <- c("City_area", "Time", "Building types in Facta", "Heating types in Facta", "Tilavuus", "Kokonaisala", "Kerrosala")
+dat$Time <- as.numeric(substring(dat$Time, nchar(as.character(dat$Time)) - 3))
+#dat <- dat[dat$Time != 2015 , ] # This is used to compare numbers to 2014 statistics.
+dat$Time <- as.numeric(as.character((cut(dat$Time, breaks = c(0, 1885 + 0:26*5), labels = as.character(1885 + 0:26*5)))))
+dat$Tilavuus <- as.numeric(as.character(dat$Tilavuus))
+dat$Kokonaisala <- as.numeric(as.character(dat$Kokonaisala))
+dat$Kerrosala <- as.numeric(as.character(dat$Kerrosala))
+build <- tidy(opbase.data("Op_en7115.building_types"))
+colnames(build)[colnames(build) == "Result"] <- "Building"
+heat <- tidy(opbase.data("Op_en7115.heating_types"))
+colnames(heat)[colnames(heat) == "Result"] <- "Heating"
+######################
+# Korjaus
+########################
+temp <- as.character(heat$Heating)
+temp[temp == "District heating"]  <- "District"
+temp[temp == "Light oil"]  <- "Oil"
+temp[temp == "Fuel oil"]  <- "Oil"
+heat$Heating <- temp
+########################################
+dat <- merge(merge(dat, build), heat)#[c("City_area", "Time", "Building", "Heating", "stockBuildingsResult")]
+dat$Kerrosala[is.na(dat$Kerrosala)] <- dat$Kokonaisala[is.na(dat$Kerrosala)] * 0.8 # If floor area is missing, estimate from total area.
+cat("Kerrosala ilman 2015 (m^2)\n")
+oprint(aggregate(dat["Kerrosala"], by = dat["Building"], FUN = sum, na.rm = TRUE))
+cat("Kokonaisala ilman 2015 (m^2)\n")
+oprint(aggregate(dat["Kokonaisala"], by = dat["Building"], FUN = sum, na.rm = TRUE))
+cat("Tilavuus ilman 2015 (m^3)\n")
+oprint(aggregate(dat["Tilavuus"], by = dat["Building"], FUN = sum, na.rm = TRUE))
+temp <- aggregate(dat["Kerrosala"], by = dat[c("Time", "Building", "Heating")], FUN =sum, na.rm = TRUE)
+colnames(temp)[colnames(temp) == "Kerrosala"] <- "stockBuildingsResult"
+stockBuildings <- Ovariable("stockBuildings", data = temp)
+objects.store(stockBuildings)
+cat("Ovariable stockBuildings stored.\n")
+</rcode>
+=== Construction and demolition ===
+It is assumed that construction occurs at a constant rate so that there is an increase of 42% in 2050 compared to 2013. Energy efficiency comes from [[Energy use of buildings]].
+<rcode name="changeBuildings" label="Initiate changeBuildings (for developers only)" embed=1>
+# This code is Op_en7115/changeBuildings on page [[Building stock in Helsinki]]
+library(OpasnetUtils)
+changeBuildings <- Ovariable("changeBuildings",
+	dependencies = data.frame(
+		Name = c(
+			"stockBuildings",
+			"efficiencyShares"
+		),
+		Ident = c(
+			"Op_en7115/stockBuildings", # [[Building stock in Helsinki]]
+			"Op_en5488/efficiencyShares" # [[Energy use of buildings]]
+		)
+	),
+	formula = function(...) {
+		out <- oapply(stockBuildings, cols = c("Time", "Constructed"), FUN = sum)
+		out <- out * 0.013125 * 5 * efficiencyShares # linear increase 42% from 2013 to 2050
+		out@output <- out@output[as.numeric(as.character(out@output$Time)) >= 2015 , ]
+		return(out)
+	}
+)
+objects.store(changeBuildings)
+cat("Ovariable changeBuildings stored.\n")
+</rcode>
-'''Table 1. Effective floor area of buildings by building type.
+'''Fraction of houses demolished per year.
-<t2b name="Effective floor area of buildings" index="Building,Year" locations="Baseline,2020,2025,2050" unit="m2" desc="Year of baseline,Type of data,Quality,Description">
+<t2b name="Demolition rate" index = "Age" obs="Rate" unit="% /a">
-Residential|27884795|32472388|34890241|44069914|2014|||Building stock of Helsinki area, 2014
+|0
-Public|4537025|4764475|4945952|5855546|2014|||Building stock of Helsinki area, 2014
+|1
-Industrial|3277271|3306063|3360467|3640854|2014|||Building stock of Helsinki area, 2014
+|1
-Other|10861972|11406505|11840973|13806423|2014|||Building stock of Helsinki area, 2014
 </t2b>
-;Notes:
+<rcode name="demolitionRate" label="Initiate demolitionRate (for developers only)" embed=1>
-* Estimates were based on {{#l:Siemens City Performance toolin seuraava kokous 2.2.pdf}} and some derived calculations on {{#l:BUILDING STOCK CALCULATION 2015.xlsx}}.
+# This code is Op_en7115/demolitionRate on page [[Building stock in Helsinki]]
-* How to get the numbers for the ''baseline floor area'' for residential, public, industrial and other: Residential floor area was named as residential together, public by summing the floor area of health care, education  and common  buildings, industrial buildings were as such and other buildings comprise of business, traffic, office and storage buildings.
+library(OpasnetUtils)
-* Ref. Helsinki master plan for 2050: there are 860 000 citizens living in Helsinki  (ref. www.yleiskaava.fi, visio2050);  Residental buildings => fast growth
-* Prediction of citizen number in Helsinki in 2020, 2030, 2040 and 2050 was used for calculations (ref. Helsingin 30% päästövähennysselvitys).
+demolitionRate <- Ovariable('demolitionRate',
-* Helsinki’s climate policy: 30% reduction in emissions:  In 2010 the proportion of jobs in services and public sectors was 94%, and in industry 6%.  In 2020 the proportion of jobs in services and public sectors is estimated to be 96%, and in industry 4%. Public and other buildings => between fast growth option and basic option,  Industry=> Basic option
+	dependencies = data.frame(Name = "dummy"),
-* Prediction of job number in Helsinki in 2020, 2030, 2040 and 2050 was used for calculations (ref. Helsingin 30% päästövähennysselvitys).
+	formula = function(...) {
-* {{#l:Tables one and two.pdf}} The presentation of Tables 1 and 2
+		temp <- tidy(opbase.data('Op_en7115', subset = 'Demolition rate'))
-* Estimates for floor area development are asked from Alpo Tani (KSV) and Olli-Pekka Pietiläinen (SYKE) as well (26.5.). No answers yet.
+		temp$Age <- round(as.numeric(as.character(temp$Age)))
+		out <- as.data.frame(approx(
+			temp$Age,
+			temp$Result,
+			n = (max(temp$Age) - min(temp$Age) + 1),
+			method = "constant"
+		))
+		colnames(out) <- c("Age", "demolitionRateResult")
+		out$demolitionRateResult <- out$demolitionRateResult / 100 * 10 # For ten-year intervals
+		out <- Ovariable("demolitionRate", output = out, marginal = c(TRUE, FALSE))
+		return(out)
+	}
+)
+objects.store(demolitionRate)
+cat("Object demolitionRate stored.\n")
-''Technical notes'':
+</rcode>
-: Sheet 4_Input Buildings (Area Demand). Priority 1. Auxiliaries PPT. Absolute increase/decrease rate will be based on the inhabitants projected in time.
-: This is another list building types that was considered but rejected as too complex: Residential buildings, Government & public administration buildings, Commercial offices buildings, Data centers buildings, Education and K12 and universitiy buildings, Hospitals and healthcare buildings, Hotels and hospitality and leisure buildings, Exhibitions and fairs and halls buildings, Retail and stores and shops buildings, Warehouses & shopping mall buildings, Industrial buildings, Non residential buildings unspecified
-Types of data used in CyPT:
-* Average, City
-* Example, city
-* Average, city close by
-* Example, city close by
-* Average, national
-* Example, country
-Qualities of data used in CyPT
-* Statistics
-* Extrapolated
-* Calculated from statistics
-* Calculated from stat. inc. assumptions
+=== Heating type conversion ===
-'''Table 2. Existing situation of important energy parametres in the building stock.
+The fraction of heating types in the building stock reflects the situation at the moment of construction and not currently. The heating type conversion corrects this by changing a fraction of heating methods to a different one at different timepoints. Cumulative fraction, other timepoints will be interpolated.
-<t2b name="Existing situation of total stock" index="Property,Building" locations="Residential,Public,Industrial,Other" desc="Description" unit="%">
+<t2b name='Yearly_heating_converted_factor' index='Heating_from,Heating_to,Time' unit='m2/m2'>
-Wall insulation|17||||Default building data - Helsinki.xlsx and CyPT Data collection - To Jouni.pptx
+Oil|Geothermal|2005|0
-High efficient glazing|35|||| Energy performance class A in building automation and www.siemens.com
+Oil|Geothermal|2015|0.5
-Efficient lighting in baseline|1.4||||Default building data - Helsinki.xlsx
+Oil|Geothermal|2025|1
-Demand oriented lighting|26.9||||Default building data - Helsinki.xlsx
-Building Efficiency Monitoring|||||
-Building Remote Monitoring|||||
-Building Performance Optimization|||||
-Demand controlled ventilation|16.2 - 22.4||||Default building data - Helsinki.xlsx: Non-residential, cell C35
-Heat and Cold Recovery in ventilation|17.8||||
-Efficient Motors|||||
-Building Automation BACS Class C|||||
-Building Automation BACS Class B|||||
-Building Automation BACS Class A|||||
-Room Automation HVAC|30||||www.siemens.com
-Room Automation HVAC + lighting|||||
-Building Automation HVAC + lighting + blinds|60||||www.siemens.com
 </t2b>
-Description of parametres:
+<rcode name="heatTypeConversion" label="Initiate heatTypeConversion(developers only)" embed=1>
-* Wall Insulation: Building outside walls with a thermal transmission coefficient < 0.5(W/(m²*k)
+library(OpasnetUtils)
-* High efficient glazing: Building outside windows with a thermal transmission coefficient < 1(W/(m²*k
-* Efficient lighting: Building with lighting technology with an efficiency of >75lumen/Watt
+heatTypeConversion <- Ovariable("heatTypeConversion",
-* Demand oriented lighting: Buildings with a lighting regulation that controls the presents of users and/or the incident sun light to dim or shut off the lighting to save electricity.
+		dependencies = data.frame(
-* Efficient Motors: Buildings that are equipped with pressure regulated variable speed drives for heating circulation pumps or ventilation drives.
+				Name = c(
-* Building Remote Monitoring: Buildings with metering and remote evaluation of energy demand, so that an professional engineer can evaluate the energy demand and the need for maintenance and improvement measures
+						"buil", # stock at different timepoints
-* Building Performance Optimization: Buildings with an optimization contract, where an professional engineer can start maintenance and  improvement measures
+						"obstime"
-* Demand controlled ventilation: Buildings with a ventilation regulation that controls the air quality (e.B.CO2) to slow down or shut off the ventilation when it is not needed to save electricity.
+				)
-* Heat and Cold Recovery in ventilation: Buildings where the heat/cold of the exhaust air is recovered by a heat exchanger to precondition the fresh air to save energy for cooling/heating.
+		),
-* Room Automation HVAC: Buildings where the heating/ventilation/Air Condition demand is regulated to the demand of every single room to prevent energy demand for not used rooms.
+		formula = function(...) {
+			dat <- opbase.data("Op_en7115", subset = "Yearly_heating_converted_factor")
+			colnames(dat)[colnames(dat) == "Time"] <- "Obsyear"
-;Notes: Data from:
+			dat$Obs <- NULL
-* {{#l:CyPT Data collection - To Jouni.pptx}}
-* {{#l:Default Building Data - Helsinki.xlsx}}
+			out <- data.frame()
-* [http://www.siemens.com/download?A6V10330398 Energy performance class A in building automation] www.siemens.com [http://www.buildingtechnologies.siemens.com]
+			temp <- unique(dat[c("Heating_from", "Heating_to")])
-The numbers found are not reliable but most of the high technology buildings such as insulated walls, windows.... are started to build from 10 to 15 years ago, so if we could find the building area in the year 2000, we could subtract that from the building area in Helsinki at the moment and get the building area which is built during these 10-15 years and they are high tech building areas with regard to 2 % renovation rate and rebuilding which is on going every year which should be added to the total amount.
+			for (i in 1:nrow(temp)) {
+				onetype <- merge(temp[i,], dat)
+				tempout <- merge(obstime@output, onetype, all.x = TRUE)[c("Obsyear","Result")]
+				tempout <- merge(tempout, temp[i,])
+				for (j in (1:nrow(tempout))[is.na(tempout$Result)]) {
+					a <- onetype$Obsyear[which.min(abs(as.numeric(as.character(onetype$Obsyear)) - as.numeric(as.character(obstime$Obsyear[j]))))]
+					tempout$Result[j] <- onetype$Result[a]
+				}
+				out <- rbind(out, tempout)
+			}
+			out <- Ovariable(output = out, marginal = colnames(out) != "Result")
+			colnames(out@output)[colnames(out@output) == "Heating_from"] <- "Heating"
-''Technical notes:'' Sheets 5_Input Residential, 6.0_Input Non Residential, 6.2_Input Public Admin. Priority 1. Auxiliaries PPT.<br />
+			out <- buil * out
+			out1 <- out
+			out1$Result <- - out1$Result
+			out1$Heating_to <- NULL
+			out$Heating <- out$Heating_to
+			out$Heating_to <- NULL
+			out@output <- rbind(out1@output, out@output)
+			#sum(out$Result)
+			#nrow(out1@output)*2 - nrow(out@output)
+			return(out)
+		}
+)
+objects.store(heatTypeConversion)
+cat("Ovariable heatTypeConversionstored.\n")
+</rcode>
-==== Energy demand ====
+=== Renovations ===
-'''Table 3. Total energy demand by energy type and building type.
+Estimates from Laura Perez and Stephan Trüeb, unibas.ch N:\YMAL\Projects\Urgenche\WP9 Basel\Energy_scenarios_Basel_update.docx
-<t2b name="Total energy demand by type" index="Energy type,Building" locations="Residential,Public,Industrial,Other" desc="Description" unit="kWh /m2 /a">
+<t2b name='Fraction of houses renovated per year' index="Age" obs="Result" desc="Description" unit= "%">
-Electricity|||||
+|0|Estimates from Laura Perez and Stephan Trüeb
-Cooling|||||
+|0|Assumption Result applies to buildings older than the value in the Age column.
-Heating|||||
+|1|
+|1|
+|1|
+|1|
+|1|
 </t2b>
-;Notes: Heating includes warm water.
+<rcode name="renovationRate" label="Initiate renovationRate (developers only)" embed=1>
-:{{comment|# |See [[Helsinki energy decision 2015]]. More of relevant data may be collected there.|--[[User:Jouni|Jouni]] ([[User talk:Jouni|talk]]) 14:16, 19 May 2015 (UTC)}}
+library(OpasnetUtils)
-:{{comment|# |These numbers could be estimated from the [[Building model]] when teh Facta data is applied. We are planning to do that in early June, 2015.|--[[User:Jouni|Jouni]] ([[User talk:Jouni|talk]]) 08:22, 21 May 2015 (UTC)}}
+renovationRate <- Ovariable('renovationRate',
+	dependencies = data.frame(Name = "dummy"),
+	formula = function(...) {
+		temp <- tidy(opbase.data('Op_en7115', subset = 'Fraction of houses renovated per year'))
+		temp$Age <- round(as.numeric(as.character(temp$Age)))
+		out <- as.data.frame(approx(
+			temp$Age,
+			temp$Result,
+			n = (max(temp$Age) - min(temp$Age) + 1),
+			method = "constant"
+		))
+		colnames(out) <- c("Age", "renovationRateResult")
+		out$renovationRateResult <- out$renovationRateResult / 100
+		out <- Ovariable("renovationRate", output = out, marginal = c(TRUE, FALSE))
+		return(out)
+	}
+)
-''Technical notes:'' Sheets 5_Input Residential, 6.0_Input Non Residential, 6.2_Input Public Admin. Priority 1. Auxiliaries PPT.
+objects.store(renovationRate)
+cat("Object renovationRate stored.\n")
-'''Table 4. Shares of different energy sinks by building type.
+</rcode>
-<t2b name="Share of energy demand by use type" index="Energy type,Use,Building" locations="Residential,Other,Public,Industry" unit="kWh /m2 /a" desc="Description,Auxiliaries">
+<t2b name='Popularity of renovation types' index='Renovation' obs='Fraction' desc='Description' unit='%'>
-Cooling|Infiltration|0.0|0.0|0.0|0.0||PPT
+None|0|
-Cooling|Ventilation|0.0|0.0|0.0|9.0||PPT
+Windows|65|
-Cooling|Losses through walls through transmission|0.0|0.0|0.0|0.0||PPT
+Technical systems|30|
-Cooling|Heat input by solar radiation through windows|0.0|0.0|0.0|0.0||PPT
+Sheath reform|5|
-Cooling|Losses through windows through transmission|0.0|0.0|0.0|0.0||PPT
+General|0|
-Cooling|Other effects (e.g. people, electrical Appliances)|0.0|0.0|0.0|0.0||PPT
-Heating|Infiltration|0.0|0.0|0.0|0.0||PPT
-Heating|Ventilation|29.19|27.56|27.22|27.22||PPT
-Heating|Walls|34.75|32.81|32.40|32.40||PPT
-Heating|Windows|15.49|14.63|14.44|14.44||PPT
-Heating|Floors|8.74|8.25|8.15|8.15||PPT
-Heating|Roofs|9.33|8.81|8.70|8.70||PPT
-Heating|Other|0.0|0.0|0.0|0.0||PPT
-Heating|Warm water|1.89|0.0|1.76|1.76||Copenhagen Excel
-Electricity|Lighting|2.82|20.05|49.68|8.67||Copenhagen Excel
-Electricity|Appliances|24.84|18.74|14.19|13.00||Copenhagen Excel
-Electricity|Ventilation|0|12.03|21.29|18.24||Copenhagen Excel
-Electricity|Other|0.56|23.69|56.77|51.76||Copenhagen Excel
 </t2b>
-;Notes:
+<rcode name="renovationShares" label="Initiate renovationShares (developers only)" embed=1>
-* Data from {{#l:Climate policies Helsinki additional data.zip}}
+library(OpasnetUtils)
-* We went through the data mentioned above and also the files given in {{#l:Climate policies Helsinki data.zip}} but could not find the data for cooling, heating:infiltration, heating:other, heating:warm water:other and electricity:ventilation:residential.
-* Total estimated amount of energy needed for cooling 23504480 kWh/a (whole Helsinki). Based on [http://www.energiatehokashelsinki.fi/energiankulutus/Helsinki] 14332 GWh/a for housing (total energy demand minus traffic 18 % [http://www.stadinilmasto.fi/files/2013/04/PEK-raportti.pdf] and [http://www.korjaustieto.fi/pientalot/pientalojen-energiatehokkuus/energiatehokkuus-pientaloissa/pientalon-energiankulutus-ja-paastot.html] 2 % of total energy demand of housing used for cooling. Total floor area of Helsinki needed (table 1).
+renovationShares <- Ovariable("renovationShares",
+	dependencies = data.frame(Name = "dummy"),
+	formula = function(...) {
+	out <- Ovariable("raw", ddata = 'Op_en7115', subset = 'Popularity of renovation types')
+	out <- findrest((out), cols = "Renovation", total = 100) / 100
+	renovationyear <- Ovariable("renovationyear", data = data.frame(
+		Obsyear = factor(c(2015, 2025, 2035, 2045, 2055, 2065)),
+		Result = 1
+	))
-''Technical notes:'' Sheets 5_Input Residential, 6.0_Input Non Residential, 6.2_Input Public Admin. Priority 1. Auxiliaries: see table.
+	out <- out * renovationyear # renovation shares repeated for every potential renovation year.
+	out@output$Renovation <- factor(out@output$Renovation, levels = c(
+		"None",
+		"General",
+		"Windows",
+		"Technical systems",
+		"Sheath reform"
+	), ordered = TRUE)
-'''Table 5. Changes in energy efficiency of different energy sinks.
+	return(out)
+	}
+)
-<t2b name="Efficiency increase decreasing energy demand" index="Energy type,Use,Building" locations="Residential,Public,Industrial,Other" desc="Description" unit="% /a">
+objects.store(
-Electricity|Lighting /Lamp stock|0.6|0.6|0.6|0.6|
+	renovationShares # Fraction of renovation type when renovation is done.
-Electricity|Appliances|0.6|0.6|0.6|0.6|
+)
-Electricity|Ventilation|0.6|0.6|0.6|0.6|
-Electricity|Other|0.6|0.6|0.6|0.6|
-Cooling|Infiltration|2|0.6|0.6|0.6|
-Cooling|Ventilation|2|0.6|0.6|0.6|
-Cooling|Other (e.g. electric appliances, people)|2|0.6|0.6|0.6|
-Heating|Infiltration|0.6|0.6|0.6|0.6|
-Heating|Ventilation|0.6|0.6|0.6|0.6|
-Heating|Floors|0.6|0.6|0.6|0.6|
-Heating|Roofs|0.6|0.6|0.6|0.6|
-Heating|Other reasons|0.6|0.6|0.6|0.6|
-Heating|Warm water|1.1|0.6|0.6|0.6|
-</t2b>
-;Notes:
+cat("Objects renovationShares stored.\n")
-* Estimated 3 % of houses renovated/year and 20 % increase in energy efficiency when renovated. [http://www.hel.fi/static/rakvv/ohjeet/energiatehokkuus_korjaamisessa.pdf] Data apart from 0.6% values from {{#l:Climate policies Helsinki additional data.zip}}
-* The presentation about tables 4 and 5 {{#l:PresentationHW9.pptx}}
-''Technical notes:''  Sheets 5_Input Residential, 6.0_Input Non Residential, 6.2_Input Public Admin. Priority 3. Auxiliaries Excel.
+</rcode>
+<noinclude>
+=== Locations of city areas ===
+;Locations of city areas (hidden for readability).
-'''Table 6. Important energy parameters.
+{{hidden|
+The positions listed here are used for exposure modelling. Area code matches with stock detail data on [[Building stock in Helsinki]]. The coordinates should be visually checked from http://www.karttapaikka.fi referencing picture X.
-<t2b name="Energy parameters" index="Parameter,Unit,Building" locations="Residential,Public,Industrial,Other" unit="-" desc="Description,Auxiliary">
+<t2b name="Locations of city areas" index="City_area,Area code,Location" locations="N,E" unit="epsg:ETRS-TM35FIN">
-Ratio of wall area / effective area|-|0.00|0.00|0.00|0.00||PPT
+|KRU|6672352|386953
-Ratio of window/effective area|-|0.00|0.00|0.00|0.00||PPT
+|KLU|6672912|385513
-U-value of windows|W /m2 /K|1.0|1.4|1.4|1.4||PPT
+|KAA|6671692|386153
-Solar heat gain coefficient "G-Value" of windows|%|0.40|0.0|0.0|0.0||PPT
+|KAM|6671692|385233
-Efficiency increase of G-value of windows|% /a|0.0|0.0|0.0|0.0||Excel
+|PUN|6671352|385113
-Efficiency increase of U-value of windows|% /a|0.0|0.0|0.0|0.0||Excel
+|E|6670792|385573
-U-value of building walls|W /m2 /K|0.16|0.25|0.25|0.28||PPT
+|UL|6670372|385973
+|KAT|6671752|387933
+|KAI|6670632|387573
+|SÖR|6674072|387453
+|KAL|6673712|385933
+|ALP|6673712|385933
+|ETU|6672552|383733
+|TAK|6673472|384753
+|ARI|6673872|382813
+|RUS|6676072|383793
+|PAS|6676092|385093
+|LAA|6675052|384433
+|MUSKOR|6672592|388413
+|LÄN|6670552|384033
+|HER|6675432|387573
+|VAL|6674912|386573
+|TOU|6676272|387793
+|KUM|6676192|386593
+|KÄP|6676932|386153
+|KOS|6677812|387393
+|VAN|6676972|387933
+|OUL|6678952|386533
+|HAA|6678032|383353
+|MUN|6674752|381733
+|LAU|6670952|381593
+|KON|6679852|380593
+|KAA|6680752|382413
+|PAK|6680392|385993
+|TUO|6682492|385653
+|VII|6676912|389553
+|PUK|6680352|388573
+|MAL|6680252|390153
+|TAP|6682632|389273
+|SUUT|6684152|389693
+|SUUR|6682512|393113
+|KUL|6674292|389193
+|HER|6675272|391093
+|TAM|6674252|392653
+|VAR|6677372|394013
+|PIT|6678172|381453
+|MEL|6679192|394193
+|VAR|6672872|393793
+|LAA|6672072|391593
+|VIL|6670412|395553
+|SAN|6668612|392993
+|SUO|6668912|388813
+|ULK|6666992|395973
+|VUO|6675252|397553
+|ÖST|6681312|399633
+|SAL|6679252|3985130
+|TAL|6679452|400333
+|KAR|6680652|401453
+|ULT|6683472|400453
+||6684572|390899
+||6680780|382563
+||6677628|383571
+||6682460|385139
+||6675756|391603
+||6679980|391731
+||6679724|380771
+||6676828|387779
+||6673900|389379
+||6675708|386355
+||6678556|387027
+||6671724|392691
+||6674156|391539
+||6668124|381699
+||6673356|380707
+||6677388|399763
+||6680476|390883
+||6678956|395043
+||6676332|381987
+||6683244|385635
+||6678972|386803
+||6680252|385939
+||6679740|388819
+||6669196|391683
+||6683676|388515
+||6684108|389843
+||6678156|381315
+||6682524|391027
+||6672204|391459
+||6681740|386131
+||6672924|385635
+||6677196|394211
+||6678188|390147
+||6676380|397027
+||6676380|384755
+||6674156|383123
+||6682316|398147
+||6679612|400499
+||6684124|402355
+||6679724|399027
+||6682076|400499
+||6678380|390771
+||6678380|390771
 </t2b>
+}}
-;Notes:
+=== Data not used ===
-* Data used: [[Unit heat consumption of buildings in Finland]].
-* Data {{#l:Climate policies Helsinki additional data.zip}} only contained 0.00 for all the parameters.
-* EU legislation value for U-value of windows in the document below was 1.0, so we used it for building buildings and the past years' values for the non-residential buildings. We assumed this will be the new residential buildings to be within the legislative value. <ref>Economidou, M., Atanasiu, B., Despret, C., Maio, J., Nolte, I., & Rapf, O. (2011). Europe’s buildings under the microscope. A Country-by-country review of the energy performance of buildings, 131.</ref> <ref>Kragh, J., Laustsen, J. B., & Svendsen, S. (2008). Proposal for Energy Rating System of windows in EU. DTU Civil Engineering-Report R-201.</ref> <ref>http://www.ziegel.at/gbc-ziegelhandbuch/eng/ressourcen/energie/graue.htm</ref>
-* HW9 table 6 presentation: {{#l:Helsinki Building Stock.pptx}}
-''Technical notes:'' Sheets 5_Input Residential, 6.0_Input Non Residential, 6.2_Input Public Admin. Priority 3. Auxiliaries: see table.
-Values derived from [[Unit heat consumption of buildings in Finland]] (these could be used to update Table 6):
+This contains data that was not used in the model's calculations. This includes renovation rates, the rates of heat flowing out of buildings and total floor areas of multiple types of buildings in Helsinki. The floor area data is also found in the background data of this page, which was used in the model.
 {| {{prettytable}}
-|+ '''Important energy parameters
+|+'''Effective floor area of buildings by building type.
-!Parameter || Value || Table ||Description
-|----
-|| Efficiency increase of U values walls 1/a|| 0.019642857|| u.factor||(0.28-0.17)/0.28/(2010-1990)
-|----
-|| Efficiency increase of U values windows 1/a|| 0.014285714|| u.factor||(1.4-1)/1.4/(2010-1990)
 |----
-|| U value wall W/m2/K|| 0.17-0.28|| u.factor||values for buildings built 1990-2010
+|| Building|| Baseline|| 2020|| 2025|| 2050|| Year of baseline|| Description
 |----
-|| U value window W/m2/K|| 1.0-1.4|| u.factor||values for buildings built 1990-2010
+|| Residential|| 27884795|| 32472388|| 34890241|| 44069914|| 2014|| Building stock of Helsinki area, 2014
 |----
-|| G value %|| 70|| sun.heat.absorption.parameters||
+|| Public|| 4537025|| 4764475|| 4945952|| 5855546|| 2014|| Building stock of Helsinki area, 2014
 |----
-|| Ratio of wall/effective area|| 0.647727273|| surface.area|| year 2010: 114/176
+|| Industrial|| 3277271|| 3306063|| 3360467|| 3640854|| 2014|| Building stock of Helsinki area, 2014
 |----
-|| Ratio of window/effective area|| 0.1|| surface.area|| year 2010: 17.6/176
+|| Other|| 10861972|| 11406505|| 11840973|| 13806423|| 2014|| Building stock of Helsinki area, 2014
 |----
 |}
-==== Lighting ====
+;Notes:
+* Estimates were based on {{#l:Siemens City Performance toolin seuraava kokous 2.2.pdf}} and some derived calculations on {{#l:BUILDING STOCK CALCULATION 2015.xlsx}}.
+* How to get the numbers for the ''baseline floor area'' for residential, public, industrial and other: Residential floor area was named as residential together, public by summing the floor area of health care, education  and common  buildings, industrial buildings were as such and other buildings comprise of business, traffic, office and storage buildings.
+* Ref. Helsinki master plan for 2050: there are 860 000 citizens living in Helsinki  (ref. www.yleiskaava.fi, visio2050);  Residental buildings => fast growth
+* Prediction of citizen number in Helsinki in 2020, 2030, 2040 and 2050 was used for calculations (ref. Helsingin 30% päästövähennysselvitys).
+* Helsinki’s climate policy: 30% reduction in emissions:  In 2010 the proportion of jobs in services and public sectors was 94%, and in industry 6%.  In 2020 the proportion of jobs in services and public sectors is estimated to be 96%, and in industry 4%. Public and other buildings => between fast growth option and basic option,  Industry=> Basic option
+* Prediction of job number in Helsinki in 2020, 2030, 2040 and 2050 was used for calculations (ref. Helsingin 30% päästövähennysselvitys).
+* {{#l:Tables one and two.pdf}} The presentation of Tables 1 and 2
-'''Tables 7-8. Run times and shares of lamps by lamp type and building type.
-<t2b name="Average run time of lamps per year" index="Lamp,Building" locations="Residential,Public,Industrial,Other" desc="Description" unit="h /a">
+''Technical notes'':
-Incandescent lamps|||||
+: Sheet 4_Input Buildings (Area Demand). Priority 1. Auxiliaries PPT. Absolute increase/decrease rate will be based on the inhabitants projected in time.
-Compact fluorescent lamps|||||
+: This is another list building types that was considered but rejected as too complex: Residential buildings, Government & public administration buildings, Commercial offices buildings, Data centers buildings, Education and K12 and universitiy buildings, Hospitals and healthcare buildings, Hotels and hospitality and leisure buildings, Exhibitions and fairs and halls buildings, Retail and stores and shops buildings, Warehouses & shopping mall buildings, Industrial buildings, Non residential buildings unspecified.
-Fluorescent lamps|||||
+* There was a problem with missing data. There is more than 400000 m^2 floor area that is missing; this is estimated from total area that is available for these buildings. For other buildings, there is more than 400000 m^2 total area missing from buildings where floor area is given. See statistical analysis [http://en.opasnet.org/en-opwiki/index.php?title=Special:RTools&id=026ekUv81jP0A6rI]. This was corrected by inputation so that is floor area was missing, 0.8*total_area was used instead [http://en.opasnet.org/en-opwiki/index.php?title=Special:RTools&id=oE7UXNQt3Izdo4tE].
-Low voltage halogen lamps|||||
-Medium voltage halogen lamps|||||
-</t2b>
-<t2b name="Shares of lamp types" index="Lamp,Building" locations="Residential,Public,Industrial,Other" desc="Description" unit="%">
+{| {{prettytable}}
-Incandescent lamps|||||
+|+ Renovations per year made in residental buildings owned by Helsinki city, by construction year of the buildings.<ref name="uarvo">[http://www.tut.fi/ee/en/Materiaali/HAESS_loppuraportti_TTY_14062010.pdf HAESS Final report], Tampere University of Technology, 2010</ref>
-Compact fluorescent lamps|||||
+|---
-Fluorescent lamps|||||
+! Construction year !! Balcony glasses !! Windows !! Julkisivujen peruskorjaus !! Vesikattojen peruskojaus !! Lämmönvaihtimen uusiminen !! Patteriverkoston säätö !! Kylpyhuonekalusteiden vaihto !! Patteriventtiilien vaihto !! New balcony doors !! LTO-laitteen asennus !! Water consumption measurements
-Low voltage halogen lamps|||||
+|---
-Medium voltage halogen lamps|||||
+| -20 || 0,0 % || 1,1 % || 1,1 % || 1,1 % || 1,1 % || 1,1 % || 1,1 % || 1,1 % || 1,1 % || 1,1 % || 1,1 %
-</t2b>
+|---
+| 21-25 ||0,0 % || 10,3 % || 1,2 % || 11,1 % || 10,3 % || 10,3 % || 1,2 % || 10,3 % || 1,2 % || 10,3 % || 10,3 %
+|---
+| 26-30 || 0,0 % || 0,0 % || 0,0 % || 0,0 % || 0,0 % || 0,0 % || 0,0 % || 0,0 % || 0,0 % || 9,5 % || 0,0 %
+|---
+| 31-35 || 0,0 % || 0,0 % || 0,0 % || 0,0 % || 0,0 % || 0,0 % || 0,0 % || 0,0 % || 0,0 % || 0,0 % || 0,0 %
+|---
+| 36-40 || 0,0 % || 0,0 % || 0,0 % || 0,0 % || 4,2 % || 4,2 % || 0,0 % || 0,0 % || 0,0 % || 4,2 % || 0,0 %
+|---
+| 41-45 || 0,0 % || 16,7 % || 0,0 % || 16,7 % || 16,7 % || 16,7 % || 0,0 % || 16,7 % || 0,0 % || 16,7 % || 16,7 %
+|---
+| 46-50 || 0,0 % || 5,2 % || 0,0 % || 7,4 % || 7,4 % || 7,4 % || 0,0 % || 7,4 % || 0,0 % || 5,2 % || 5,2 %
+|---
+| 51-55 || 0,0 % || 11,3 % || 0,0 % || 8,8 % || 8,8 % || 8,8 % || 0,0 % || 8,8 % || 0,0 % || 8,8 % || 16,2 %
+|---
+| 56-60 || 0,0 % || 5,4 % || 0,0 % || 4,9 % || 6,2 % || 7,1 % || 0,0 % || 6,2 % || 4,5 % || 4,5 % || 5,4 %
+|---
+| 61-65 || 0,0 % || 1,5 % || 1,3 % || 0,8 % || 2,9 % || 2,4 % || 1,0 % || 2,4 % || 0,9 % || 0,9 % || 2,9 %
+|---
+| 66-70 || 0,6 % || 2,9 % || 1,2 % || 2,8 % || 1,4 % || 2,3 % || 1,1 % || 1,1 % || 0,1 % || 1,1 % || 1,1 %
+|---
+| 71-75 || 3,2 % || 3,1 % || 3,4 % || 2,9 % || 3,1 % || 2,6 % || 0,2 % || 1,1 % || 0,2 % || 0,2 % || 0,2 %
+|---
+| 76-80 || 0,1 % || 2,7 % || 0,1 % || 0,7 % || 2,0 % || 1,7 % || 1,1 % || 1,2 % || 0,2 % || 0,4 % || 0,2 %
+|---
+| 81-85 || 1,0 % || 2,8 % || 0,7 % || 2,3 % || 3,3 % || 4,8 % || 3,5 % || 0,0 % || 0,0 % || 0,0 % || 0,8 %
+|---
+| 86-90 || 0,0 % || 1,3 % || 0,0 % || 2,1 % || 6,1 % || 1,6 % || 0,7 % || 1,8 % || 0,3 % || 0,3 % || 1,0 %
+|---
+| 91-95 || 0,6 % || 0,3 % || 0,0 % || 3,9 % || 8,6 % || 1,9 % || 5,1 % || 0,8 % || 0,2 % || 0,0 % || 1,3 %
+|---
+| 96-00 || 0,1 % || 0,0 % || 0,0 % || 0,6 % || 1,2 % || 1,0 % || 1,5 % || 1,0 % || 0,0 % || 0,0 % || 4,2 %
+|---
+| 01-05 || 2,9 % || 0,0 % || 0,0 % || 0,0 % || 1,2 % || 1,0 % || 0,0 % || 1,0 % || 0,0 % || 0,0 % || 0,7 %
+|---
+| 06-10 || 1,7 % || 0,0 % || 0,0 % || 0,0 % || 0,5 % || 0,5 % || 0,0 % || 0,5 % || 0,0 % || 0,0 % || 0,0 %
+|}
-;Notes: Sheets 5_Input Residential, 6.0_Input Non Residential, 6.2_Input Public Admin. Priority 3. Auxiliaries Excel.
+{{defend|# |In the document there are similar tables for total renovations from 2010 onwards to years 2016, 2020 and 2050.|--[[User:Heta|Heta]] ([[User talk:Heta|talk]]) 09:28, 16 June 2015 (UTC)}}
-==== Other ====
+{| {{prettytable}}
+|+'''Toimenpiteiden vaikutukset yksittäisessä kohteessa ja toimenpiteisiin liittyviä huomautuksia.<ref name="uarvo"/>
-Sheet 4_Input Buildings (Area Demand). Priority 1. Auxiliaries PPT. Nice to have specific factor otherwise we adapt standard data or other studies.
+|---
+! Action !! The feature in question !! Difference to before !! Unit !! Notes
+|---
+| Glass for balconies || U-value for windows || -0,3 || W/m<sup>2</sup>,K || Säästö 1-4% rakennustasolla
+|--
+| Changing the windows || U-value for windows || -1 || W/m<sup>2</sup>,K || Vanhoista osa kaksilasisia ja osa kolmilasisia. Uudes 1,0  W/m<sup>2</sup>,K tai alle
+|---
+| Julkisivun peruskorjaus || U-value of walls || -0,2 ||  W/m<sup>2</sup>,K || U-arvo puolitetaan eli n. 100 mm lisäeristys
+|---
+| Vesikattojen peruskorjaus || Yläpohjan U-arvo || -0,15 ||  W/m<sup>2</sup>,K || Oletetaan 50% lisäeristys U-arvo puoleen eli n. 100 mm lisäerstys
+|---
+| Balcony door change || U-value of doors || -0,5 ||  W/m<sup>2</sup>,K || Tiivistyminen tuo lisäsäästöä
+|}
 {| {{prettytable}}
-|+''Possibly important information
+|+'''Thermal transmittances of building components and air flow rates. Averaged values calculates from the detailed model are presented here.<ref>MK Mattinen, J Heljo, J Vihola, A Kurvinen, S Lehtoranta, A Nissinen: Modeling and visualisation of residential sector energy consumption and greenhouse gas emissions</ref>
-!Data!!Result
+|---
-|----
+|colspan="2" rowspan="2"| Construction decade ||colspan="5"| Thermal transmittance factors for building components (W/m2K) ||colspan="3"| Ventilation and leakage air rates (1/h)
-|Number of households||
+|---
-|----
+| Floor || Roof || Walls || Windows || Outdoors || Supply air through the heat recovery unit || Supply air bypassing the heat recovery unit || Leakage air
-|Number of persons per household||
+|---
+|rowspan="3"| Before 1980 || Single family house || 0.52 || 0.32 || 0.54 || 2.14 || 1.18 || 0.30 || 0.05 || 0.20
+|---
+| Row house || 0.52 || 0.36 || 0.56 || 2.15 || 1.00 || 0.3 || 0.05 || 0.20
+|---
+| Apartment building || 0.59 || 0.37 || 0.61 || 2.18 || 1.40 || 0.37 || 0.00 || 0.10
+|---
+|rowspan="3"| 1980's || Single family house || 0.30 || 0.21 || 0.28 || 1.70 || 1.00 || 0.30 || 0.05 || 0.15
+|---
+| Row house || 0.32 || 0.22 || 0.30 || 1.70 || 1.00 || 0.30 || 0.05 || 0.15
+|---
+| Apartment building || 0.34 || 0.23 || 0.29 || 1.80 || 1.40 || 0.35 || 0.00 || 0.10
+|---
+|rowspan="3"| 1990's || Single family house || 0.25 || 0.20 || 0.25 || 1.70 || 1.00 || 0.30 || 0.05 || 0.15
+|---
+| Row house || 0.32 || 0.22 || 0.28 || 1.70 || 1.00 || 0.30 || 0.05 || 0.15
+|---
+| Apartment building || 0.332 || 0.22 || 0.28 || 1.75 || 1.40 || 0.38 || 0.00 || 0.10
+|---
+|rowspan="3"| 2000's || Single family house || 0.24 || 0.17 || 0.24 || 1.40 || 1.00 || 0.30 || 0.05 || 0.13
+|---
+| Row house || 0.28 || 0.18 || 0.26 || 1.50 || 1.00 || 0.45 || 0.05 || 0.15
+|---
+| Apartment building || 0.28 || 0.18 || 0.26 || 1.50 || 1.40 || 0.55 || 0.00 || 0.10
+|---
+|rowspan="3"| 2010's || Single family house || 0.16 || 0.09 || 0.17 || 1.00 || 1.00 || 0.30 || 0.05 || 0.10
+|---
+| Row house || 0.16 || 0.09 || 0.17 || 1.00 || 1.00 || 0.50 || 0.05 || 0.15
+|---
+| Apartment building || 0.16 || 0.09 || 0.17 || 1.00 || 1.00 || 0.60 || 0.00 || 0.10
 |}
-=== Facta database building categories and heating types ===
+== See also ==
-'''These tables are based on FACTA database classifications and their interpretation for assessments.
-<t2b name="Building types" index="Building types in Facta" obs="Building" unit="-">
-Ammatilliset oppilaitokset|Public
-Asuntolat, vanhusten palvelutalot, asuntolahotellit|Other
-Elokuvateatterit|Public
-Hotellit, motellit, matkustajakodit, kylpylähotellit|Public
-Kahden asunnon talot|Residential
-Kasvihuoneet|Industrial
-Kauppavarastot|Industrial
-Kirjastot|Public
-Kirkot, kappelit, luostarit, rukoushuoneet|Public
-Korkeakoulurakennukset|Public
-Kulkuneuvojen suoja- ja huoltorakennukset|Industrial
-Lasten päiväkodit|Public
-Lastenkodit, koulukodit|Residential
-Liike- ja tavaratalot, kauppakeskukset|Other
-Monitoimi- ja muut urheiluhallit|Other
-Museot, taidegalleriat|Public
-Muut erilliset pientalot|Residential
-Muut kerrostalot|Residential
-Muut liikenteen rakennukset|Industrial
-Muut palo- ja pelastustoimen rakennukset|Other
-Muut sairaalat|Other
-Muut teollisuuden tuotantorakennukset|Industrial
-Muut terveydenhoitorakennukset|Other
-Muut urheilu- ja kuntoilurakennukset|Other
-Muut uskonnollisten yhteisöjen rakennukset|Public
-Muut varastorakennukset|Other
-Myymälärakennukset|Other
-Peruskoulut, lukiot ja muut|Public
-Pysäköintitalot|Other
-Rautatie- ja linja-autoasemat, lento- ja satamaterminaalit|Public
-Ravintolat, ruokalat ja baarit|Public
-Rivitalot|Residential
-Saunarakennukset|Other
-Seurakuntatalot|Public
-Talousrakennukset|Other
-Teollisuus- ja pienteollisuustalot|Industrial
-Teollisuushallit|Industrial
-Toimistorakennukset|Other
-Tutkimuslaitosrakennukset|Other
-Vapaa-ajan asunnot|Residential
-Voimalaitosrakennukset|Industrial
-Väestönsuojat|Other
-Yhden asunnon talot|Residential
-Muualla luokittelemattomat opetusrakennukset|Other
-Muut kokoontumisrakennukset|Public
-Muut rakennukset|Other
-Muut sosiaalitoimen rakennukset|Public
-Myymälähallit|Other
-Teollisuusvarastot|Industrial
-Yhdyskuntatekniikan rakennukset|Other
-Järjestöjen, liittojen, työnantajien yms. opetusrakennukset|Other
-Muut huoltolaitosrakennukset|Industrial
-Tietoliikenteen rakennukset|Industrial
-Seurain-, nuoriso- yms. talot|Public
-Terveyskeskukset|Public
-Vanhainkodit|Residential
-Luhtitalot|Residential
-Navetat, sikalat, kanalat yms.|Industrial
-Muut majoitusliikerakennukset|Other
-Muut majoitusrakennukset|Other
-Muut maa-, metsä- ja kalatalouden rakennukset|Other
-Kehitysvammaisten hoitolaitokset|Residential
-Loma- lepo- ja virkistyskodit|Other
-Eläinsuojat, ravihevostallit, maneesit|Other
-|Other
-Paloasemat|Other
-Vuokrattavat lomamökit ja osakkeet (liiketoiminnallisesti)|Other
-Teatterit, konsertti- ja kongressitalot, oopperat|Public
-Jäähallit|Public
-Keskussairaalat|Other
-Näyttelyhallit|Other
-Terveydenhoidon erityislaitokset (mm. kuntoutuslaitokset)|Other
-Viljankuivaamot ja viljan säilytysrakennukset, siilot|Industrial
-Uimahallit|Public
-Vankilat|Other
-Ketjutalot|Residential
-Tennis-, squash- ja sulkapallohallit|Other
-</t2b>
-<t2b name="Heating types" index="Heating types in Facta" obs="Heating" unit="-">
-|Other
-Kauko- tai aluelämpö|District heating
-Kevyt polttoöljy|Light oil
-Kivihiili, koksi tms.|Coal
-Maalämpö tms.|Geothermal
-Puu|Wood
-Raskas polttoöljy|Fuel oil
-Sähkö|Electricity
-Kaasu|Gas
-Muu|Other
-</t2b>
-=== Calculations ===
-== See also ==
+{{Helsinki energy decision 2015}}
+* [[Building stock in Helsinki metropolitan area]]
 * [http://en.opasnet.org/en-opwiki/index.php?title=Building_stock_in_Helsinki&oldid=35248#Calculations Descriptions about the summary calculations on sheet Parameter Balance] (not needed any more).
 * [http://ptp.hel.fi/paikkatietohakemisto/?id=125 Rakennustietoruudukko pääkaupunkiseudulta] [https://www.hsy.fi/fi/asiantuntijalle/avoindata/Sivut/AvoinData.aspx?dataID=14]
+* [[Unit heat consumption of buildings in Finland]]
+* [http://era17.fi/wp-content/uploads/2010/10/sitran_selvityksia_39.pdf Sitra, page 25]
+* [http://www.teeparannus.fi/attachements/2010-12-21T11-54-1114846.pdf Tee parannus pages 8-9, also 40-45]
+* [http://www.vtt.fi/inf/pdf/tiedotteet/2007/T2377.pdf VTT tiedotteet page 20-21, also 30, 80]
+* [[Heating consumption of buildings]]
+* [http://www.tut.fi/ee/Tutkimus/lammike.html Lämmitystapavalintojen kehitys]
 == References ==
@@ Line 356: / Line 778: @@
 == Related files ==
 <!-- __OBI_TS:1431310608 -->
+</noinclude>