Exploratory study of urban resilience in the region of Stuttgart based on OpenStreetMap and literature resilience indicators
This is a modal window.
The media could not be loaded, either because the server or network failed or because the format is not supported.
Formal Metadata
Title |
| |
Title of Series | ||
Number of Parts | 295 | |
Author | ||
Contributors | ||
License | CC Attribution 3.0 Germany: You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal purpose as long as the work is attributed to the author in the manner specified by the author or licensor. | |
Identifiers | 10.5446/43566 (DOI) | |
Publisher | ||
Release Date | ||
Language |
Content Metadata
Subject Area | ||
Genre | ||
Abstract |
| |
Keywords |
FOSS4G Bucharest 201918 / 295
15
20
28
32
37
38
39
40
41
42
43
44
46
48
52
54
57
69
72
75
83
85
87
88
101
103
105
106
108
111
114
119
122
123
126
129
130
131
132
137
139
140
141
142
143
144
147
148
149
155
157
159
163
166
170
171
179
189
191
192
193
194
195
196
197
202
207
212
213
214
215
216
231
235
251
252
263
287
00:00
Observational studyPressure volume diagramPlanningThomas KuhnComputer fontGrass (card game)Physical systemPerspective (visual)Variable (mathematics)System programmingVariety (linguistics)Moving averageView (database)Level (video gaming)Control flowUniverse (mathematics)Open setSoftware developerTerm (mathematics)State of matterBitState observerMeasurementMathematicsSpeciesPerspective (visual)Context awarenessObject (grammar)Focus (optics)Stress (mechanics)Price indexObservational studyPhysical systemDivisorComputer fontContent (media)Contrast (vision)Greatest elementDialectField (computer science)Theory of relativityAreaHypermediaWordGroup actionMultiplication signLeakDivision (mathematics)Database normalizationResultantComputer animation
03:25
Finite element methodChannel capacityHazard (2005 film)Gamma functionIntrusion detection systemField (computer science)Hazard (2005 film)Content (media)Electronic program guideChannel capacityState of matterComputer animation
04:22
Continuous functionPhysical systemEstimationPressure volume diagramLevel (video gaming)Archaeological field surveyFile formatSet (mathematics)FrequencyTemporal logicFeasibility studyWitt algebraStatisticsSoftware testingSystem identificationCharacteristic polynomialSource codePrice indexComputer programmingDenial-of-service attackPrice indexOrder (biology)Source codePhysical systemFile formatImage resolutionLimit (category theory)Slide ruleAuthorizationDifferent (Kate Ryan album)Machine learningState of matterOpen setAngular resolutionMeasurementDatabaseTerm (mathematics)Level (video gaming)BitTemporal logicComputer fileStandard deviationFeasibility studyMereologyDimensional analysisBasis <Mathematik>Computer animation
08:12
Price indexSummierbarkeitAreaDatabaseMoore's lawDatabaseCentralizer and normalizerMereologyMappingTerm (mathematics)Channel capacityElectronic data processingMilitary base
09:03
AreaSummierbarkeitBuildingStatisticsFluid staticsDatabaseBoundary value problemSet (mathematics)Table (information)Term (mathematics)PolygonAreaGeometryLine (geometry)StatisticsAuthorizationCountingInformationLengthDatabasePoint (geometry)Moore's lawKey (cryptography)MathematicsComputer animationProgram flowchart
10:17
AlgorithmSimilarity (geometry)Virtual machineMathematical analysisLinear regressionLeast squaresLinear mapForestPressure volume diagramComputer-generated imagerySource codeHausdorff dimensionHuman migrationData structureVariable (mathematics)Dependent and independent variablesFunction (mathematics)Price indexHuman migrationRight angleSource codeWave packetStatisticsDimensional analysisSelectivity (electronic)Chemical equationBasis <Mathematik>Pairwise comparisonSet (mathematics)Data structureOrder (biology)Computer animation
11:37
Pressure volume diagramHausdorff dimensionHuman migrationDependent and independent variablesVariable (mathematics)Data structureSource codeGrass (card game)CircleDifferent (Kate Ryan album)Dimensional analysisArithmetic meanTable (information)ResultantArrow of timeNumberSquare numberBuildingOpen setVapor barrierLevel (video gaming)Key (cryptography)Price indexEndliche ModelltheorieDeutscher FilmpreisObservational studyTerm (mathematics)Contrast (vision)Product (business)PredictabilityError messageRandomizationBitFunction (mathematics)Forest
13:17
AreaWorkstation <Musikinstrument>Vapor barrierSurfaceBuildingOrder (biology)Connected spaceMapping
13:50
Random numberForestStatisticsHuman migrationMassIntrusion detection systemData structureData structureResultantPrice indexEndliche ModelltheorieHuman migrationSlide ruleDifferent (Kate Ryan album)Attribute grammarFunction (mathematics)Chemical equationSimilarity (geometry)BitSocial classRandomizationForestPredictabilityMereologyStatisticsGoodness of fitProduct (business)Lie groupMultiplication signAreaRule of inference
16:13
Grass (card game)Point (geometry)Pressure volume diagramLine (geometry)StatisticsCharacteristic polynomialDecision theoryService (economics)Complex (psychology)Integrated development environmentLevel (video gaming)Link (knot theory)Goodness of fitNeuroinformatikOpen setPower (physics)ResultantCombinational logicOrder (biology)QuicksortClosed setPredictabilityPresentation of a groupDatabaseConnected spaceCASE <Informatik>Attribute grammarFreewareEndliche ModelltheoriePhysicalismMoore's law
18:19
MappingLevel (video gaming)QuicksortFunction (mathematics)TwitterReflection (mathematics)Point (geometry)SphereResultantData structureClosed setBlack boxStatisticsPhysicalismHuman migrationAreaFocus (optics)Execution unitPrice indexDivisorField (computer science)Lecture/Conference
20:51
Data structureLemma (mathematics)Maxima and minimaInclusion mapGrass (card game)Linear partial informationBitElectronic visual displayProof theoryParameter (computer programming)Multitier architectureChemical equationPrice indexHypothesisEndliche ModelltheorieHuman migrationContrast (vision)Point (geometry)Different (Kate Ryan album)Perspective (visual)Complete metric spaceFunction (mathematics)PredictabilityDistribution (mathematics)Lie groupOpen setMultiplication signConnected spaceObservational studyAreaLecture/Conference
23:23
Endliche ModelltheorieOrder (biology)State of matterTrailPrice indexDifferent (Kate Ryan album)Process (computing)Term (mathematics)Software testingSoftwareControl flowVector potentialSensitivity analysisCartesian coordinate systemPredictabilityValidity (statistics)Level (video gaming)Open sourceGeometryPresentation of a groupImage resolutionoutputData structurePersonal identification numberStorage area networkOpen setSource code40 (number)Product (business)Similarity (geometry)Forcing (mathematics)Lecture/Conference
Transcript: English(auto-generated)
00:07
Okay, we can have the last talk for this session and it's my pleasure to introduce Holger from the University of Stuttgart. He will give us the last talk of this session on OpenStreetMap. Again, you have 20 minutes, 5 minutes for questions and answers and then we will move to the coffee break.
00:25
Okay, thank you Marco. Let me introduce myself first. My name is Holger Sauter. I'm as Daniel at the Institute of Spatial and Regional Planning at the University of Stuttgart. We're colleagues. We worked both on this topic and as you can see at the title of my talk now, it's related.
00:46
We wanted to discover some hidden factors of OpenStreetMap, some hidden indicators. My approach was more, or the approach of this study was more from the bottom up to look exactly at region, at regional level
01:04
and the content of OpenStreetMap in the region of Stuttgart in contrast to the international perspective that Daniel just previously presented. So let me start with some, yeah, with a basic outline of the talk first.
01:23
I want to give you a brief background on resilience, on urban resilience because I'm not sure if at this conference with this technical focus or some technical stress on the methodology if you're aware about the concept.
01:44
So a few definitions at the beginning, then I come to the research objectives and will then introduce the methods we applied and come up with some results and conclusions. There will be a bit of redundancy, of course, because the topic is very similar to the one Daniel just presented.
02:02
But on the other hand, I'm happy I don't have to explain everything in depth because it was already explained. Okay, as I warned you, some definitions. What is resilience? Maybe you know Holling introduced this term, this concept in 1973 by observation of ecosystems,
02:24
ecological systems with populations of various species and he defined it as a measure of persistence of systems and their ability to absorb change and disturbance and still maintain the same relationship between population or state variables.
02:42
So he introduced the system perspective on terms like robustness, flexibility of system, how much can a system cope before it collapses or breaks down. This system perspective went into various research disciplines. It's a kind of buzzword nowadays in many research arenas you find it.
03:09
And it also entered many political agendas. One of it, the most important one each of you is aware of is the Sustainable Development Goals of the United Nations
03:21
where you find at least in these five goals specifically the term resilience in the goal. And we at the institute, at the University of Stuttgart work basically in the field of goal 13, climate action, which states that resilience has to be strengthened
03:46
and the adaptive capacity to climate related hazards and natural disasters has to be increased. This general goal specifically guides some goals of goal 11 or some
04:07
main contents of goal 11 to create resilient cities, sustainable cities and communities. So measuring resilience is very important in urban planning and spatial planning in this regard.
04:24
So if we go a bit more specifically to urban resilience, you see here our definition I like very well because the first term is very important to have a measurable ability of any urban system. And the rest is a bit like the definition of hauling. What means measurable? It means we need indicators.
04:46
We need something to measure on the urban level or the regional level to define the state of resilience to, as Daniel explained before as well, to determine how successful measures are, programs, initiatives or even single infrastructures that are built in order to increase resilience.
05:09
For example, what is the impact of this dam, of this flood prevention infrastructure to the overall resilience of the region? So we need these indicators and we have them already. This is not a very new topic to have these indicators for resilience.
05:30
So many regions or countries already have accepted and tested resilience indicator sets available which are in use.
05:41
But most of them have the shared problem. You need a lot of data because they consist of many, usually many indicators, a few dozens. Each of them belongs to other authorities or comes from other data sources which means different file formats, different spatial resolution, different temporal resolution.
06:08
And so it's always a big deal to standardize, to bring it together and compute it accordingly to an index. So we have a limited feasibility and standardization which led us to this idea how
06:25
can we use a standardized global database which OSM is to derive these indicators for resilience. So we did basically the same, almost the same as we did for
06:42
the World Risk Index with four recognized resilience indicators that we derived from literature. I will introduce them later on the later slides. And we tested the statistical learning methods in order to deduce these resilience indicators from OpenStreetMap.
07:04
So first of all before I go into the methods part I want to introduce the region of Stuttgart because I'm
07:22
not sure if all of you know it or know where it is and what dimension it has or it covers. We chose it because it has a very high OSM coverage and a very high contribution index compared internationally and offered a sound data source there.
07:43
So it's in Germany in the southwest in the federal state of Baden-Württemberg. And Baden-Württemberg consists of four federal districts, one of which is the federal district of Stuttgart which also holds the capital of the federal state Stuttgart here in the southwest, the economical center.
08:08
And as you can see at this map that the economical center or basis of this district is around Stuttgart.
08:22
In Stuttgart there are many sub-centers, Halbron, Ludwigsburg and so on with a high economical capacity whereas the eastern part and central part of the district is really rather rural area, small municipalities, small villages. But some global players, hidden champions inside some of these municipalities and this has some
08:47
influence as you will see later on maps where we compare the performance of the predictors. The data pre-processing, we already heard some of this before but we had a little different approach because
09:05
we could in terms of computational power in this example because the coverage on the data amount was lower. First we downloaded the database from Diofabric and pre-processed the data so throughout some information
09:22
of the database that was not very important like authors and so on and change information. Then we imported it into post GIS database with OSM2PGSQL with the full data set which was not clipped, not yet clipped
09:42
at the boundaries of the municipalities but we wanted to have statistics for each municipality so we clipped the geometries with QGIS. And built them in the post GIS database again the statistic tables for all polygons and lines and points so
10:00
we had statistics for each municipality for area length and counts and we normalized it by population in the municipalities. This table then could be or these tables, there were a few, could be connected with a package to R statistics where we performed basically these methods that you already heard from Daniel.
10:29
We decided Random Forest after testing all of them because it produced just the best outputs in comparison and deduced the indicators. What was the training data or the four indicators we've selected to be predicted by the model?
10:48
The four indicators were migration balance, demographic age structure, business tax revenue and unemployment representing these four dimensions.
11:02
You can see on the left of resilience dimensions, socioeconomic all of them and on the right you see the sources of these indicators. So they are tested and applied, as you know the business tax revenue data sets that usually each year
11:22
is produced, others like migration balance might not be available for each community on an annual basis and so on. So you already can see at this selection that the conventional method would be rather complicated in contrast to an optimized dynamic, maybe dynamic method that we did or developed within this study.
11:52
So let me show you some results. I don't have to explain the tags anymore because Marco already did. It's basically a key value pair from OpenStreetMap.
12:07
The tables here show the results of the different dimensions or indicators we measured and the number MSE, the increase of the mean squared error shows you the importance of the specific tag for the prediction of the model output.
12:24
So barrier liftgate for example has the highest impact on the model quality at the end, on the model prediction. If you leave it away, the mean squared error would increase accordingly, double as for example if you would leave it away, Deutsche Post, German Post.
12:45
We were surprised a bit by looking at the tags that were selected by the model that were of high importance. Some of them are obvious regarding the dimensions, some of them are not. We really wonder but it's basically the same surprise as we have with the world risk index.
13:04
That's the result or the funny thing with random forest models. You don't know what comes out. So if we have a look at for example tax revenues, it's very clear, industrial buildings, private access and so on, land use, industrial has a high impact as everyone would expect.
13:25
But when you look at unemployment, for example the situation is completely different, what has occurred, what has an orchid to do with unemployment you might ask.
13:40
But anyway, we didn't understand yet fully what the reasons behind these obviously logical connections are. But if you take a look at the maps, you really see that the results are quite convincing. On the left side, I will show you all the four indicators within the next slides. On the left
14:05
side you see the statistical data, the conventional mapping and on the right side the random forest output model. And yeah, feeling of belonging which we measured with the migration balance. So how much people migrate in to the municipality. You
14:25
can see there's a really good coverage or a really good similarity in the southwest, in the central areas, the economically strong areas. Whereas we have a bit of problem in the prediction here around this northeastern part. We didn't understand why at
14:44
the beginning but then we looked a bit into detail of the municipalities and we found out that here in Bad Meggentheim, we have the large company, I don't want to name it, I don't know if that is okay.
15:02
So it's a big producer of screws for industry and this economical asset pulls many people into the region but the infrastructure around it doesn't really reflect this economical strength of the region.
15:23
So the spatial attributes not always, obviously, can predict these special situations and this difference here or this specific issue about these, as I named them before, these hidden champions that are
15:44
located somewhere in rural regions, pops up in the other results as well a few times. Not as much here with the age structure but still one class left and here with the tax revenue, the prediction is rather good.
16:12
So another, the last indicator we mapped is the unemployment which also matched very well as you can see.
16:22
So it brings me already to the conclusions. This method we applied, of course, it's just a first step but already showed that there are really hidden attributes in OpenStreetMap regarding risk, regarding resilience.
16:41
Socioeconomic topics or social topics where the database was not made for but it's still hidden there and it's a quality of OpenStreetMap. We have found or proven that the method we applied is very simple. It
17:00
doesn't need a big computational power. You can easily do it with a good computer. Of course, you need some patience for the modeling but a few days should do it. It's just a first step. A lot of more research has to be done definitely and it might not
17:24
be sufficient to just use such methods and just use OpenStreetMap in order to have a dynamically produced indicator. It might be also useful to have other methods include in order to improve the quality of the prediction.
17:41
For example, remote sensing data that is also dynamically available could be linked with these methods. Thank you for your attention. That was it and I'm free for questions. Thank you. Another great presentation. Are there questions?
18:15
In the case of Daniel's presentation with the vulnerability, I can see more instinctive connection to physical features with resilience.
18:28
I think it's quite extraordinary that you get that sort of close mapping based on what is mostly mapping of physical features. On the face of it, it wouldn't have much to do with unemployment or migratory trends and then because some of this is just black box passing through,
18:49
the interesting thing here is how much the physical features that are being mapped in an area are a reflection of sort of certain issues like unemployment and stuff like that, because we don't map these statistics in any way.
19:04
And then the follow-up question to that would be how do you get any feel from this, from what isn't being mapped that could be mapped for these factors? Because everybody has their priorities when they do OSM mapping, they focus on certain things,
19:22
but are there things coming out of this that you think should be mapped that aren't? To be honest, both questions are tough questions because we're not that far yet. We produced these maps rather recently and we're still very surprised and the
19:42
point is we still don't know exactly why this is producing a good output or that good output, although we cannot really relate the tags to the topic or the spatial structures to the social sphere.
20:01
I just have to say where we will get more into detail and have a deeper look at it to uncover it. In Calgary maybe next year, we will show some new results explaining exactly these open questions and hopefully also why or what else could be integrated to produce more results.
20:26
Daniel, you have an idea for that question or an answer to that question? I join you basically in your answer, but interesting was looking especially at the age structure in our region.
20:43
It was what you would have expected somehow that you have an older age and more rural and looking at indicators, it was connected to farmland, hiking, and even the quite local, where is it?
21:04
It was mentioned when I really had to laugh because it's really a club to go hiking on the Swabian alp for older people and that the tier was somehow really unexpected, but also somehow for me proof of the model that such features
21:23
because they have houses to go to walk around and hiking, farmland. So that was similar like the tax revenue so you could understand how it is related. And it's also like the migration balance is such a softer topic and therefore it's harder to understand the connections again.
21:59
I have one question. In contrast to Daniel, you have applied basically the same method but on a very local area,
22:09
starting from the hypothesis that OSM is very well mapped because this has been proven that in Stuttgart it is very well mapped. My question is did you try also to run this in another country or another region of Germany when this is not the truth?
22:23
And if yes, can you provide some argument on how sensible it is, the completeness? Because one of the main issues of OSM is the uneven spatial coverage. So that has been studied a lot and of course this is a fact.
22:41
So again kind of same questions as to Daniel before. So how sensible is this to the completeness of the data? And again I have to say that's exactly the point where we have to re-enter now after this conference and that's what we're planning to do to just apply this model now to other regions with different spatial distribution and attributes,
23:07
especially the coverage of OpenStreetMap. To do this on the region of Stuttgart, the reason behind it was exactly that we had some output from the international perspective of the World Risk Index that was definitely of a bad prediction quality because of missing data and this data coverage difference
23:29
and we didn't have it in Stuttgart. That's exactly the reason why we did it there. But many regions in Europe are well covered so we definitely have a chance to apply it elsewhere
23:42
and then compare this in order to get or make some sensitivity tests of the model and improve the quality at the end or find out what really fosters the quality of prediction. And I think it's also going to be quite interesting. I really want to see in this term if we now take the same model for a different federal state,
24:06
first of all, does it work the same way and then if we move to another country, of course, to see are there different texts. So in order to develop a European indicator set basically for socioeconomic, would we need to have like models with validation for each
24:25
or for what resolution for each country, for each federal state or could we make them robust enough with using one model over more countries or does the cultural differences reflect upon the text related to a certain age structure.
24:40
So I think I'm really looking forward to see what's coming up there. Thank you. Any other input from the audience? Okay, so just to close the session and before the coffee break I would like just to make some final remark. Again, coming back to the keynote given yesterday by our GEO president where
25:04
she basically presented OSM data as the complement to the open source software. We are actually speaking about these two different sides of the same thing and I would like to thank Maria and Andrea to put actually a track
25:21
on, I mean a small session on OpenStreetMap in this academic track. I think this should be the usual and should be actually kept in the future editions of actually any academic track, especially on Phosphor-G. I've seen that as mentioned in the first presentation and as really shown by the second and the third, OSM is really strictly connected to open source.
25:44
So whenever you want to have some tools to process or to extract something from OSM you need actually to use Phosphor-G. So we are different communities but basically we are the same community. Just to close, again I will invite everyone to attend the academic track at State of the Map conference that will take place in Heidelberg, Germany, Baden-Württemberg.
26:06
In three or four weeks, so 21st to 23rd of September. Again, there will be kind of a similar conference to this one, so a general track and then one day of academic track where we will have similar presentations to this one. So you can see really the potential of OSM also for scientific academic applications.
26:26
So thank you to the speakers and to the audience for this very successful session and wish you all a nice coffee break and nice afternoon and evening. Thank you.