How to grow? -Modeling land use change to develop sustainable pathways for settlement growth in the hinterland of Cologne, Germany
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 | 351 | |
Author | ||
License | CC Attribution 3.0 Unported: 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/68916 (DOI) | |
Publisher | ||
Release Date | ||
Language | ||
Production Year | 2022 |
Content Metadata
Subject Area | ||
Genre | ||
Abstract |
| |
Keywords |
FOSS4G Firenze 2022326 / 351
1
7
13
22
25
31
33
36
39
41
43
44
46
52
53
55
58
59
60
76
80
93
98
104
108
127
128
133
135
141
142
143
150
151
168
173
176
178
190
196
200
201
202
204
211
219
225
226
236
242
251
258
263
270
284
285
292
00:00
Mathematical modelUniverse (mathematics)MereologyFlow separationProjective planeMountain passComputer animation
00:27
AreaElectric currentData miningNumberData miningMountain passMoment (mathematics)Projective planeRevision controlMathematicsSoftware developerMereologyComputer animation
02:07
PlanningIntegrated development environmentSign (mathematics)Link (knot theory)Natural numberSimulationBasis <Mathematik>Mathematical modelOpen sourceSoftwareSoftware developerOpen sourceSoftwareOpen setMathematical modelComputer animation
02:41
AreaSimulationFrequencyWorkstation <Musikinstrument>Population densityBuildingElectric currentSoftware developerDistanceOcean currentLocal ringWorkstation <Musikinstrument>Computer animation
03:44
Electric currentOpen setLocal ringWorkstation <Musikinstrument>Associative propertyTopologySet (mathematics)Open sourceError messageRevision controlUniform convergenceFaktorenanalyseProcess (computing)Mathematical modelRandom numberForestAreaObservational studyPreprocessorAutomationPerformance appraisalSimulationPopulation densityBuildingFrequencyDistribution (mathematics)SpacetimeCategory of beingPressure volume diagramAdditionOverlay-NetzSpeciesInformationPrice indexOcean currentResource allocationPerformance appraisalMathematical modelResultantOpen sourceDivisorSpeciesFormal languageCategory of beingCellular automatonMetreProjective planeLocal ringNetwork topologyDatabaseProcess (computing)CatastrophismGoodness of fitLevel (video gaming)Vector potentialDistanceGraph (mathematics)SoftwareAreaForestSlide ruleRandomizationSpacetimeRevision controlOpen setDiallyl disulfidePlanningCase moddingNumberUniformer RaumComputer animation
09:23
Observational studyPlanningOcean currentRevision controlAreaMathematicsPhysical systemData conversionResultantMathematical modelSoftware developerMoment (mathematics)Service (economics)Plug-in (computing)Level (video gaming)DistanceOpen setPresentation of a groupInformationGastropod shellPointer (computer programming)Library (computing)Software testingCase moddingPoint (geometry)Diallyl disulfideComputer animation
Transcript: English(auto-generated)
00:00
Thank you. First of all, I'm a little bit nervous because my first talk for international plenary in English. What I present today is a part of a research project we've done with several stakeholders from municipalities and other universities in our region of Cologne in Germany.
00:26
Cologne, if you can, you can for this cathedral and the carnival. In the region of Cologne, we have an influx of 170,000 people from 2018 to 2014.
00:59
This people came from new industries like IT and bio science and aeration and for this people we need like 3,300 hectares of new settlement areas.
01:18
And this is a big problem because we have conflicts with agriculture and natural resources and on the other part
01:28
we have in the region a structural change in the traditional industries like light mining for light coal and chemistry industry.
01:45
So we have the typical situation of urban sprawl at the moment and we would look in our project how can we bring this development of more sustainable with ongoing the SDG number 11 and the SDG number 2 in the second tray.
02:14
For this we have three main questions on my work.
02:21
It's possible to develop a land use model on open source software and open data and what can the model bring for the stakeholders in the region and for the urban planning. For CHEC it's possible to develop a model. We have developed two scenarios
02:42
with the local stakeholders for the development of the region from 2018 to 2015. One scenario is we ongoing with the current development of new residential areas and the other
03:03
scenario is we will protect very high potential areas too from development of new residential areas. And we have looked for some predictors who were interesting for people to go in new residential areas.
03:31
The predictors can you see in zoom? The distance to train stations, motorways and social infrastructure.
03:45
On these days we have looked if we can find open data through these themes. For the current land use the government of Germany and not Westphalia have all data over land use bring on
04:05
a free license which near is to the to a nonzero license that we have freaked information over current land use. Then the public transport organizations brings her information to the CEC license and the
04:24
other information over social infrastructure and motorways we can found an open street map. So we have free data. But the devil is in the detail. First of all for a good model we must bring this data of uniform quick from 100 and 100 meter per grid cell.
04:48
And one problem is the mostly data have trouble local and gamutally errors. So we have the data now we must look for a model.
05:05
You can see the results of the data processing. That is the current language in the region based on the German official catastrophe system. That is the distance to the train station and to the motorway.
05:24
Please speak to the microphone. Okay. Now we have looked what for software have for model.
05:41
And we have lot of good open source tools for such land use model. We have found a way to build up model in completely open source deck with QGIS, Postgres as database and the typical Python scientific stack with Pandas and Skidlearn and NumPy.
06:11
For the allocation to simulate the allocation process of the residential areas we use a random forest model.
06:30
But for we can use the model we must preprocess the data in SQL.
06:40
First we must the data bring of one similar projection. Then we must repair the broken gamutries and topologies. Then we can cut then first we can cutting the data to the study area. And in the last strip we transform the data of the uniform grid.
07:05
With this data we can train the random forest with the current land use and the describing factors. Now if we train the random forest we gave the random forest the information from the different scenarios.
07:24
And for the current practice order the maintaining agriculture scenario who we protect the very high agriculture areas.
07:41
After the random forest process we became a map of potential new residential area grid cells. With this map we go in the second step of the model who we disputed the needed new residential spaces on the potential areas.
08:08
And we evaluate the model results with some tools. Now the evaluation of the results we have developed 20 indicators from 5 categories are used for evaluation of the sustainability.
08:35
And we can analyze the impact of the new residential areas on protected species on protected plants.
08:46
To show conflicts for the regional planning and the urban planning very early.
09:00
On this slide you can see some indicators. We have indicators from infrastructure, from agriculture value of areas and for ecological questions.
09:25
Now we see the first result. The first result is the map of the potential new areas. You can see in here. Maybe you can use this as a pointer.
09:40
For me it's difficult. I'm visually impaired. Yes, sorry. Okay. It should be like that. Ah, okay. Thank you. We can see here. We can see which grid shell from agriculture is changed to potential new area in which scenario.
10:00
In the second map, I write that not good to see. We can see which grid shell in which year will be changed from agriculture to residential area.
10:21
And the last and the stakeholders in main result is they have a chance to found a conflict very early. With nature conversation or other things. That is a problem in the German regional planning system.
10:45
Because information over conflicts came in the German planning systems very late. And so it's mostly planning work was going on and the justice must look what to do with conflicts with nature or with agriculture.
11:08
Now we have a tool we can see conflicts very, very, very early. And can give some other sustainable development changes.
11:31
At the moment I will be re-implemented the model with some new technologies.
11:42
Since I have the model developed in the year 2018, we have some nice new software libraries. Like Geopandas, like Fiona, like Moving Pandas. And the open world service from Heidelberg. So that we have such better model in the next year.
12:03
What will I implemented as a QGIS plugin so that people can use the model all over the world. Because I have checked that the model works with the current land use data and with distance data from other countries.
12:22
On my journey to Norway last year, I have tested the model with Norwegian data and it works seamless too.
12:44
And if some people have regions or can test the model in the world, I am very interested. Questions and discussing points?
13:04
Thank you Mirko for your presentation.