Better urban planning through the standard geographical reference system of German municipalities

1
Better urban planning through the standard
geographical reference system of German
municipalities
European Conference, Darmstadt, 17 19 Oct.
2007
The International Network for Urban and Regional
Statistics
Session Territorial structure and standard
regional reference systems 
Andreas Gleich, City of Augsburg, Germany
Department for Urban Development and
Statistics KOSIS-Project AGK
2
Content of my presentation

• Some typical tasks in urban planning
• Managing requirements for data with geographical
  references
• Elements of a consistent geographical reference
  system
• Standardisation of the geographical references
• Perspectives

3
The object triangleof urban development

• Integrated (strategic) planning of urban
  development

Prosperity Employment and income withcreativity
and innovation
Quality of Life Protection the ecological and
aesthetical quality of the urban habitat
Cohesiveness Protection of social justice and
spatial balance
Functions in urban planning
Supervision concrete development intention and
procedures
Initiation new concepts at changing conditions
Coordination different interests at shared tasks
4
Procedure e.g. urban program education and
social cohesion
7. Further Programs, Projects,
6. Evaluation
1. Basis Information
Involvement of concernedActors
5. Monitoring
2. Model
Part of the politicians, planners, Part of
thestatisticians, researchers,
3. Program
4. Leading Projects
5
What is necessary to handle this duties?

• technical equipment (IT-Infrastructure, ...)
• data origins (register of inhabitants, students,
  employment, ...)
• geographical reference system
• application programs (AGK, GIS, SPSS, EXCEL, )
  to connect the systems and to analyse data
• qualified stuff (scientists, programmer,
  manager, )
• financial resources

6
Typical tasks in urban planning finding
locations

• easy, interactive use of school locations
• referenced by the addresses
• additional information context metadata,
  spatial distribution

7
Typical tasks in urban planning catchment areas
catchment areas of schools
number of the students
Recalculation of content data using the
geographical reference system
Conservation of the definitions for future
comparisons evaluation!
catchment area is a collection of hierarchical
elements
distribution of an age group based on address
data
8
Typical tasks in urban planning coverage area

• walking distances for each student address
• easily creating maps, reports and charts

sides ofbuildingblocks
secure way for walking
Student addresses and school location
9
Typical tasks in urban planning optimising

• school bus stops student addresses in a certain
  distance

• noise exposure

Producing comparable variations of solutions
10
Managing requirements for geographical references

• Maintenance (postal addresses, territorial codes
  and geometry)
• References between different territorial
  structures
• Reference date or beginning and end of validity
  (time reference) for geographical
  references and content data
• Archive and relationships of historical
  references, codes and geometries to actual
  references
• Validity checks plausibility, consistency and
  integrity (in space time)
• Link between content data and geographical data
  and tools
• Tools for spatial and statistical analysis

11
Structure of AGK the application to maintenance
the standardized geographical reference system
Cooperation of more then 40 German municipalities
in the maintenance and further development
KOSIS-Project (Kommunales Statistisches
InformationsSystem)Network for utilisation,
implementation and maintenance of computer based
instrumentswithin the association of the German
municipal statisticians (VDSt, Verband Deutscher
Städtestatistiker)Since 3 Years field-tested in
cities - with 100 - 600 thousands inhabitants
(20 100 thousands addresses, scalable to
millions)- with different kinds of hierarchical
structure - with or without geometryand in one
region with gt 20 smaller cities.
GIS Interface
DBMS
Graphical User Interface
12
Standard geographical reference system
AGK(Adresszentraldatei, Gebäudedatei und
Kleinräumige Gliederung)
Central management and hierarchical coding
system.Allocation of content data independent of
origin for any record date and any site from
the address to the side of the building block to
a zone
13
with standardized interface AGK
(Adresszentraldatei, Gebäudedatei und
Kleinräumige Gliederung)
with spatial-temporal integrity and consistency
dynamical interaction between code and
geometry systems for flexible code definitions
from the address to the side of the building
block to a zone
14
Elements of a consistent geographical reference
system
? Addresses for referencing locations and
collecting data (ca. 1 of the addresses of
a city are changing in one year ca. 10 of
the inhabitants are moving in one year!)
? Stable Territorial Units in the system of
building-blocks for collecting and to
associate data (belong to the addresses)
(lt0.1 of the building-blocks are changing in one
year)
? Flexible hierarchical system of the
building-blocks to aggregate data (1-3 level
above and 1-2 level below the block)
(normally 1 modification in one year!)
? Tessellation of the hierarchical Elements
to define new territorial units (sub urban
zones) (normally lt1 modification in one
year, decentralized at the responsible authority)
? Linkage of these Elements to geometry for
visualisation
? Central maintenance system for these Elements
with the possibility of shared processing
(multi-user system)
15
Standard procedures from raw data to product

• Opening of content date
• Validity checks plausibility, consistency and
  integrity (in space time)
• Linking between content data and geographical
  data and tools
• Spatial and functional aggregation according to
  the question
• Spatial and functional intersection with other
  content date
• Creating indices, indicators, correlations, ..
• Building databases with time series, prognoses
• Producing standard reports, tables, charts,
  maps,
• Evaluating model, program and projects

16
Simplified process chain from raw data to product
data origin allocate opening of content date
analyses
presentation
17
Interrelations of the Elements (simplified data
model)
? Alphanumerical Code and Geometry
? Defined Interrelations between the Elements
? Defined actions to maintenance the Elements
region
hierarchy
polygon
line
street
address
point
building
point/polygon
18
Open Interface ODBC
Standard IT
Geo. Ref. System
AGK
GIS
EXCEL ...
geographical content DB
Alphanumerik
DB
Geometry
WWW
GDB
Special IT
content data interface
GIS interface
19
Perspectives ...

• Automation of the communication between the
  Interfaces e.g. interactive WWW-Application,
  
• Description of the workflow for typical
  Questions
• Extension for integration of grid cells in the
  System
• Translation into foreign languages (on demand)
• Automation thematic cartography (content data
  interface)
• Integration of routing functionality
• Integration of external databases (WMS, Google,
  )

... and international cooperation
20
Thank you for your Attention!
For more information see - the SCORUS-papers-
www.kosis.deDemonstration of AGK ask me!
21
SCORUS-papersA Standard Regional Reference and
Geocoding System on the Subcity Level in Germany
(Potsdam 2003) Consistency in Space and Time
- Basis for Standardised Interfaces -
Realisation in AGK (Amsterdam 2005)GIS versus
SIS? How to combine the concepts of
geographical and statistical information systems
(Wroclaw 2006)