usage of european census data for sustainable land management – a german case study ulrike klein...

Usage of European Census Data for Sustainable Land Management – A German Case Study Ulrike Klein and Hartmut Müller

Usage of European Census Data for Sustainable Usage of European Census Data for Sustainable Land Management – A German Case Study Land Management – A German Case Study

Ulrike Klein and Hartmut MüllerInternational Conference SDI & SIM 2013, FIG-COM3, FIG-TF-PH & Geo-SEE

13-16 November 2013, Skopje, Macedonia

Technical Session 1: Cadastre and Land Management, 13 November 2013, 12:00-13:30


Torresin & Partner

Geoinformatics and Surveying

Since 1993


1

Introduction


“A picture is worth a thousand words”

Source: http://epp.eurostat.ec.europa.eu


CensusLong tradition of census data capture

Traditionally mostly long lists of pure numbers, and/or non-spatial diagrams

Spatial reference: units of public administration

For scientists and decision makers Need of summarizing current and predicting future scenarios for particular spatial areas Spatial representation of census data Prerequisite for visual interpretation and computational analysis


European Union Census 2011 Legislation

Nr. 1201 Technical Specifications of topics and breakdowns

No 519 programme of statistical data and metadata

No 1151 modalities and structure of quality reports and technical data formats


Population change, by NUTS 3 regions, 2011

Source: http://epp.eurostat.ec.europa.eu/cache/GISCO/yearbook2013/0202EN.pdf


2

Census 2011 in Germany


Topics of Census Collection Germany 2011

Attributes of buildingstype of building

year of constructionnumber of apartments

form of ownershiptype of heating

Attributes of apartmentstype of apartment

type of useliving space

number of roomsbathroom equipment

Attributes of inhabitantsgender

agemarital status

nationalityreligion

Attributes of householdstype of householdsize of household

Attributes of familiestype of familysize of family


Percentage of Buildings built before 1919Census Germany 2011, www.zensuskarte.de


Comparison of Age Structure at Building Block LevelCensus Germany 2011


3

Statistical Units in Germany


Source: Daniela Hogrebe, Andres von Dömming, Coordination Office SDI Germany


Schema of a German Building Block Cadastre Deutscher Städtetag 1981


Sample City (1) – Aerial Photo


Sample City (2) – Parcels and buildings


Sample City (3) – Creation of Districts

Split administrative boundaries with • transport network

• streets• railroads

• hydrography


Sample City (4) – Creation of Building Blocks

Split districts by • land use• development plans• parcels• buildings


Sample City, Detail (1) – Districts and building blocks


Sample City, Detail (2) – Districts, building blocks and addresses

Make Point-in-Polygon-Analysis for addresses, building blocks and districts

Building Block Cadastre is ready


Useful Spatial Information for Creation of Districts and Building Blocks

• Administrative Units• Transport Network

• Streets• Railroads

• Land Use• Hydrography• Buildings• Addresses


Digital Vector Data + Census Data Interactive Process Input Data for Analysis

Municipality No.

Municipality name

District No.

District Name Building block No.

Street House number

563678 Westerhorn 001 Dauenhof 5636780010001

Wiesengrund 1a


Wiesengrund 3


Wiesengrund 5


Wiesengrund 7

563678 Westerhorn 002 Bahnhofsviertel 5636780020001

Eulenweg 1

563678 Westerhorn 002 Bahnhofsviertel 5636780020001

Eulenweg 3

… … … … … … …

+


Representation of Census Data at Different ResolutionPopulation District Level (left) Building Block Level (right)


4

Geospatial Analysis of Statistical Data for Sustainable Land Managament


Human Lifecycle - Influencing the Need of Infrastructure

KindergartenSchools

WorkMedical Care

Building GroundTransportation

Graveyardsetc.


Problem: Demographic Change

1/7Under

18

1/3Under

18

1/8Above

65

1/3Above

65

2004 2025


Example Part 1: Amount of People Above the Age of 65 per Building Block


Example Part 2: Average Age of Buildings per Building Block


Example Part 3: Combination of both Charasteristics

„Golden Anniversary“

• Old Buildings

• Less and old Inhabitans

• Less Children

• Less Money for Repairs

• More Need of Medical Care

• More Need of easy accessable Infrastructure(Bus Stops, Supermarkets, Pharmacy)

• …

• Old Buildings

• Less and old Inhabitans

• Less Children

• Less Money for Repairs

• More Need of Medical Care

• More Need of easy accessable Infrastructure(Bus Stops, Supermarkets, Pharmacy)

• …


• How many people in which age do live in each district?

• In which condition are the buildings of the district?

• How is the quality of the infrastructure in the districts

• Which infrastructure will have a serious shortfall in capacity or overcapacities in the next years?

• Which infrastructures should be pooled because of spatial proximity?

• Which infrastructures should be maintained because of easy accessibility?

Important Questions Concerning Socioeconomic Factors, Infrastructure and Sustainable Land Management


5

Some Use Cases


Use Case 1 ‘Kindergarten’Children under 6 years Available Places in Kindergarten

Political Idea: Increasing female employment through better child care

Spatial Questions: Where do children under the age of 6 live?Which kindergartens are in the area?How many places do they have?How many children are already there?Which is the next kindergarten for each building block?Are there enough places available?If not: Are alternatives available?


Use Case 2 ‘Sewage System’Number of Inhabitants Condition of Sewage System

Problem:If less people use the sewage system problems with hygienic standards and damages of the sewage system occur(e.g. less money for necessairy repair, contamination with medical residues, in worst case: contamination of groundwater )

Spatial Questions: How many people of which age live in each building block?How is the condition of the sewage system?Which part should be repaired next?


Use Case 3 ‘Energy’Energy Efficiency Heating Requirements

Political Idea: Calculate heating requirements

Spatial Questions: How old are the buildings in each building block?Which energy efficiency do they have?How much energy is needed for heating?


Use Case 4 ‘Public Transportation’Catchment Areas Number of Inhabitants

Question:Is the infrastructure (like schools, doctors, workplaces) easy accessible through public transport systems?

Spatial Questions:Where are bus or train stops?How many people live in the catchment area of each station?How old are they? Do they need special equipment?


5

Conclusions


Census data, a highly valuable source for sustainable land management

The spatial dimension of census data – in practice often a hidden treasure

Unearthing the treasure

- needs integration of various data formats and representations

- is often a challenging and time intensive process

- helps to generate new knowledge on spatial patterns and relations of census data


Thank you for your attention!

[email protected]

[email protected]

usage of european census data for sustainable land management – a german case study ulrike klein...

Documents

sustainable land management

german case study ulrike

hartmut mller slide

hartmut mller source

hartmut mller schema

hartmut mller sample

blocks slide

introduction slide