map4data: a mobile app to refine geodata for the …...2015/05/28  · 1. model e import geodata on...

51
Piergiorgio Cipriano Map4Data: a mobile App to refine geodata for the SUNSHINE “Building Efficiency Pre- certification Service” 2015-05-28

Upload: others

Post on 13-Jul-2020

0 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

Piergiorgio

Cipriano

Map4Data: a mobile App to

refine geodata for the SUNSHINE

“Building Efficiency Pre-

certification Service”

2015-05-28

Page 2: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

WARNING

This presentation is not on

BIM or pseudo-realistic 3D

models

Page 3: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

WARNING

This presentation is on

INSPIRE driven-data model

and semantics for

“Buildings” data theme

Page 4: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

WARNING

This presentation is on

energy maps at buildings

level for municipal energy

planning

Page 5: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

®

®

© 2015 Open Geospatial Consortium

Urban Energy workshop

OGC and bSI

Geospatial and BIM

CityGML and IFC

INSPIRE-GWF 2015

Bart De Lathouwer

OGC

Page 6: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

OGC ®

Looking for communalities

• Where are Geo and BIM on this map?

© 2015 Open Geospatial Consortium

Pla

nn

ing

Co

nce

ptu

al

Desig

n

Deta

ile

d

De

sig

n

Co

ns

tru

cti

on

Op

era

te &

Man

ag

em

en

t

Page 7: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

Numbers

Page 8: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

Actually, in the EU we do

not have any actual data about the real existing

building stock

Page 9: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

What we know is based on

statistics, and …

Page 10: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

There are three kinds of lies:

lies, damned lies, and

statistics

Mark Twain, Benjamin Disraeli

Page 11: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

About 35% of the EU's buildings are over 50 years old.

By improving the energy efficiency of buildings, we could

reduce total EU energy consumption by 5% to 6% and

lower CO2 emissions by about 5%.

Buildings are responsible for 40% of energy consumption

and 36% of CO2 emissions in the EU.

While new buildings generally need less than three to 5

liters of heating oil per square meter per year, older

buildings consume about 25 litres on average. Some

buildings even require up to 60 litres.

https://ec.europa.eu/energy/en/topics/energy-efficiency/buildings

Page 12: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

25 billion m2 useful space

30,528 km2 gross floor space

BPIE, 2011, Europe’s buildings under the microscope

http://www.bpie.eu/documents/BPIE/WEB_executive%20summary.pdf

Page 13: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

Is your house already having

an “energy performance

certificate?”

Page 14: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,
Page 15: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,
Page 16: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,
Page 17: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

Energy performance

certificates provide

information for new or

renovated buildings, as well

buildings to be purchased or

rented.

1-2%

Page 18: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

http://bpie.eu/uploads/lib/document/attachment/81/BPIE_Energy_Performance_Certificates_EU_mapping_-_2014.pdf

Page 19: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

Like BIM (and energy smart

meters), the EP certificates only

apply to a small share of building

stock:

UK: 12,000,000 bdg units IT: 3,600,000 bdg units ( 6%)

PT: 700,000 bdg units

http://bpie.eu/uploads/lib/document/attachment/81/BPIE_Energy_Performance_Certificates_EU_mapping_-_2014.pdf

http://www.cti2000.eu/rapporto-ce-2014/

Page 20: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

http://www.cti2000.eu/rapporto-ce-2014/

At December 2014, the number

of EPC in the Emilia-Romagna (IT)

was

595.389

... less than 4% of the building stock

Page 21: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

… equal to

120,000,000€

(assuming an average cost of 200€ per EP certificate)

Page 22: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,
Page 23: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

We need data …

Page 24: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,
Page 25: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,
Page 26: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

Footprint from cadastre

or high quality topo db

Energy consumption

from SIATEL

3D from high res. Lidar

UValues and other properties (e.g. age of

construction) from Energy Certificates registers

Page 27: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

https://www.dati.lombardia.it/Energia/CENED-Certificazione-ENergetica-degli-EDifici/rsg3-xhvk

Energy certificates open data

Page 28: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

http://www.agenziaentrate.gov.it/wps/content/nsilib/nsi/home/servizi+online/servizi+per+enti/siate

l+puntofisco/accesso+siatel+v20+puntofisco

Energy consumption SIATEL

Page 29: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

In the SUNSHINE project we implemented a set of

OSS components to:

1. Model e import geodata on spatial db – GeoUML Catalogue, PostGIS, QGIS

2. View and edit – GeoServer (WMS, WFS-T)

3. VGI check completeness and correctness – PhoneGap

4. Estimate “energy performance” – GeoServer (WPS)

5. View/ validate – CesiumJS

6. Export / Import CityGML Energy AD – CityGML4J / deegree

Page 30: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

In the SUNSHINE project we implemented a set of

OSS components to:

1. Model e import geodata on spatial db – GeoUML Catalogue, PostGIS, QGIS

2. View and edit – GeoServer (WMS, WFS-T)

3. VGI check completeness and correctness – PhoneGap

4. Estimate “energy performance” – GeoServer (WPS)

5. View/ validate – CesiumJS

6. Export / Import CityGML Energy AD – CityGML4J / deegree

Page 31: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

Low cost

Open standard based

KISS

Page 32: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

In Ferrara (IT) buildings’

data have been

collected, but some

attributes are still missing

or need to be checked

(e.g. “age of

construction, age of

renovation, uses, …”).

An on-site campaign

has been organized by

the Municipality,

involving Board of

Architects and Civil

Engineers, and the local

Schoolof Architecture.

People is using

smartphones and tablets

to edit attributes via

WFS-T service, and

updates data on PostGIS

database.

Page 33: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

Buildings properties

missing, on-site to be

performed

Some buildings

properties still missing,

on-site already done

Buildings properties

available, on-site

check suggested

Buildings properties

available and on-site check performed

Page 34: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

In just 27 hours on site, properties of more than 1000 buildings have bee checked and

data update submitted

Page 35: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

Building selection (on 1st click)

Page 36: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

Building properties (on 2nd click)

Editing of multi-value attribute

Page 37: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,
Page 38: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

https://www.youtube.com/watch?v=W5pNYAUKZI0&feature=youtu.be

Page 39: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

http://episcope.eu/fileadmin/tabula/public/docs/brochure/IT_TABULA_TypologyBrochure_POLITO.pdf

Page 40: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,
Page 41: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

Buildings base parameters

Typical

consumption

Qt

[kWh/mA2annum]

Energy Performance estimation

(Source: Carrión et al, 2010)

Page 42: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

Qt = 10-3 HT 24 DD V S/V A

[kWh/mA2annum] = [kW/mS

2K] [h°K/anno] [mS2/mA

2]

Bdg typology Age(s)

Envelope

elements

U-value [W/m2K] Typical

% of

facade

Walls Mattoni pieni/semi-pieni 1,08

60%

Roof Laterizio e cemento 0,95

10%

Pavement Laterizio e cemento 0,92

10%

Openings thermal break frames + low-emission glass

2,63

20%

Typical trasmission coefficient

HT [W/mS2K]

Country Climatic zone

Climate parameters

Heating season duration 183

giorni

Average outdoor temp. 12° C

Indoor comfort temp. 20° C

Degree days

DDt

[giorni °K/anno]

Typical building

shape parameters

Heated volume

(V)

1234

mS3

Shape factor

(S/V)

0.66 mS-

1

Useful floor area

(A)

353 mS2

Consumption

Qt [kWh/mA2annum]

Page 43: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

Heating [kWh/mA

2year]

Electricity [kWh/mA

2year]

Measured energy use,

Qm

126 129

Typical energy use,

Qt

120 95

(factor) energy source

w

(proportional to CO2

generated per kWh)

0.6 0.4

elet

elet

t

elet

mheat

m

t

heat

t

heat

m wQ

Qw

DD

DD

Q

QR 100

Class R

(min)

R

(max)

A < 0 25

B 26 50

C 51 75

D 76 100

E 101 125

F 126 150

G > 150

Operational Energy Rating

[A (efficient) – B – C – D (typical) – E – F – G (inefficient)

Consumo tipico

Qt [kWh/mA2anno]

Gradi giorno misurati

DDm [days/Kanno]

Measured consumption

Qm [kWh/mA2annum]

Degree days

DDt [days/Kannum]

Page 44: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

ww

w.s

un

shin

ep

roje

ct.

eu

SUNSHINE - Smart UrbaN ServIces for Higher eNergy Efficiency (GA no: 325161)

https://www.youtube.com/watch?v=6kslOHSRY8U

http://sunshine.graphitech-projects.com

Page 45: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

ww

w.s

un

shin

ep

roje

ct.

eu

SUNSHINE - Smart UrbaN ServIces for Higher eNergy Efficiency (GA no: 325161)

Page 46: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

Validating the algorithm for

EP estimation

Page 47: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

ww

w.s

un

shin

ep

roje

ct.

eu

SUNSHINE - Smart UrbaN ServIces for Higher eNergy Efficiency (GA no: 325161)

Validation dataset (gas)

Page 48: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

ww

w.s

un

shin

ep

roje

ct.

eu

SUNSHINE - Smart UrbaN ServIces for Higher eNergy Efficiency (GA no: 325161)

Validation dataset (real EP certificates)

Page 49: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

ww

w.s

un

shin

ep

roje

ct.

eu

SUNSHINE - Smart UrbaN ServIces for Higher eNergy Efficiency (GA no: 325161)

citygml4j

pseudo-INSPIRE structure

(tables, codelists, constraints)

+ TABULA full dataset

CityGML Energy ADE WFS

+ W

PS

Cadastral data TABULA EP certificates Annual energy amount

PostgreSQL / PostGIS

EP labelling and CityGML Energy ADE

Page 50: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

ww

w.s

un

shin

ep

roje

ct.

eu

SUNSHINE - Smart UrbaN ServIces for Higher eNergy Efficiency (GA no: 325161)

EP certificates and energy labels (NL)

http://energielabelatlas.nl/#zuid-holland/delft/17/52.0122/4.3612

Page 51: Map4Data: a mobile App to refine geodata for the …...2015/05/28  · 1. Model e import geodata on spatial db –GeoUML Catalogue, PostGIS, QGIS 2. View and edit –GeoServer (WMS,

[email protected]

Thanks

www.sunshineproject.eu