Home

USER'S GUIDE

image

Contents

1. 6 2 2 5 Reference land value mu LY The reference land value is the average value m of a land use type and is used in the MMT in the context of estimating the market oriented value of land for the property in guestion Reference land values can be stored as default values and are then suggested automatically in the MMT once a land use type as per BauNVO has been allocated If this is not the case they have to be obtained elsewhere e g at building authorities or land registry or surveying agencies TLL m User s Guide Version 1 2 0 T Page 6 6 CI M MT 6 2 2 6 Land use type as per the German Federal Soil Protection Ordinance Two assessment factors relevant for the MMT are associated with liialt the land use types defined in the Federal Soil Protection Ordi groundhousing area nance BBodSchV a First different sampling depths are pre scribed for soil studies relating to different land use types and Doreen they simultaneously serve as depths that are relevant for reme Recreation area Industry Trade AgncultuneAllotment gar GrasslandGreenheld diation As such they effect the calculation of remediation costs b Second the regulation BBodSchV defines specific threshold No use vath access restr Noassignment Recreation alea values linked to the precautionary principle and to the need for testing and remediation measures prevention test and action
2. a User s Guide Version 1 2 0 T Page 15 4 E M MT The calculation of the objective function or fitness value SCORE is shown in the form of a so called pseudo code below Table 15 2 Pseudo code of target function calculation OBJ ECTIVE FUNCTION of optimisation module obj mmtl nutzungskarte map evaluierungskarten anzEvaluierungskarten ROWS COLS CELLS Randbedingungen anzRandbedingungen Wichtungen anzWichtungen init map evaluierungskarten 0 Beziehe initiale Karten Bestimme Anzahl vewendeteter Landnutzungstypen gt PatchRichness nutzungskarte Benenne Landnutzungtypen mit passender ID gt luName FOR i 1 to Anzahl Landnutzungstypen DO Pruefe Abweichung von initialen Nutzungstypanteilen IF Nutzungstypanteil i map lt oder gt als Randbedingung 0 Nutzungstypan teil i initiale Nutzungskarte DANN SCORE 0 Verlasse Zielfunktion SONST Mache weiter mit Zielfunktion END IF Berechne mittlere Abweichung von Nutzungsgroesse CA SCORE MEAN Berechne aktuelle Sanierungskosten auf Basis der Kostenkarten Berechne aktuellen Marktwert auf Basis der Marktwertkarten Normiere Sanierungskosten gegen max mit vorhandenen Nuztungstypen moeglichen Sanierungskosten 1 REMEDIATIONCOST_NORM Normiere Marktwert gegen max mit vorhandenen Nutzungstypen moeglichen Markt wert 1 MARKETVALUE NORM Berechne Nachhaltigkeitsindex SSI Normiere Nachhaltigkeitsindex SSI gegen maximal moeglichen SSI MAX
3. cccceceececceeeeeeeeeeeeeeeeeeeeeeeaeeeeaeeeeaeteeaeeetees 7 5 Fig 7 5 Dialogues for naming a new scenario above and a new layout below 7 5 Fig 7 6 Dialogue for confirming the deletion of an existing scenario ccceceeeeceeeeeeeeeeeees 7 6 Fig 7 7 ILUM with planning units for creating a new layout cccceceeeeeeeceeeeeeeeseeteeeeenes 7 6 FIG 8 1 Contaminants Tonne innen 8 2 any MT User s Guide Version 1 2 0 m Elvi Page xiii Fig 8 2 Remediation target values menu ninvenennnenennnnnnnnnnnnn nan na ann nennen 8 3 Fig 8 3 Messages relating to running the conflict analysis cccceeceeeeeeeeeeeeeeeeeeeeeeeeaees 8 4 Fig 8 4 Report at end of conflict analysis nrrvenvenenvnnennnne enne anne n anne n enn 8 4 Fig 8 5 Display and selection of results maps in the form results in Integrated assessment m ee et ee seers E EE t 8 5 Fig 8 6 Conflict map for PAK in soil at 0 to 30 cm depth example for model site Krampnitz ee ec eee ee Eee 8 5 Fig 8 7 Conflict map PCE in the groundwater example for model site Krampnitz 8 6 Fig 9 1 Selection of contaminant hotspot to be addressed based on data stored in the MMT Serato AEE A INNEN EEE 9 2 Fig 9 2 Main form of the PRESTO TOOL a ea nen 9 2 Fig 9 3 Site Contaminants input form for characterising the contaminant hotspot 9 3 Fig 9 4
4. 1 Define spatial context 2 Define local problem areas 3 Link to sustainability goals 4 Prioritize problems 5 Define Indicators 6 Sustainable Development 7 Expected Development i s Problem Areas Goal Indicator Assessment 1 Immisionen durch Hohes Verkehrsaufkommen in der Innenstadt iat L rmbelastung durch Verkehr Luftverschmutzung 2 Arbeitslosigkeit und Qualifizierung Schaffung von Arbeitspl tzen Arbeitslosigkeit 3 Unzureichende Anzahl von Gewerbefl chen A Betriebsfl che Revitalisierung von Brachfl chen 4 Eingeschranktes Angebot auf dem Wohnungsmarkt Geb ude und Wohnungsbestand in der Stadt Potsdam Wohnungsbestand in Stadtrand Gemeinden in gm 5 Erhaltung des kulturellen Erbes der Stadt 33 Anzahl denkmalgesch tzter Bauwerke und Ensembles 6 Psychologische Probleme aufgrund von Arbeitslosigkeit 1 1 nicht definiert 7 Unzureichende Gewerbefl chen f r wohnungsnahe Grundversorgung 1 22 Wohnunasnahe Grundversorgung 8 Extreme Armut als Folge von Arbeitslosigkeit und geringer Qualifizierung Ud nicht definiert 9 Geringe Qualifizierung von Arbeitskr ften 25 Aus und Weiterbildung 0080000000080 a A E Fig 12 11 MMT Sustainability assessment Presentation of results F m User s Guide Version 1 2 0 T Page 12 10 t MMT 13 Presentation of results reporting data export 13 1 Presenting the results of the integrated as sessment The menu item Integrated assessment gt Results
5. 3 Geringe Qualifizierung von Arbeitskr ften il EN nb 10 Sicherung des Kommunalen Einkommens il intery e loca as Er z a ceur 11 Verbesserung der Ausbildungschancen f r alle Bev lkerungsgruppen il 2 that prob yy i 12 Zugang zu Sozialeinrichtungen il redefinition Ifyou chose problem areas for further work you lt lt Back Continue gt gt Fig 12 3 MMT Sustainability assessment Step 2 Definition of problems Step 3 links the local problems with the sustainability objectives of the Helmholtz concept Starting out from the sustainability objectives the users themselves de cide which of the problems fit with which sustainability objectives The form Fig 12 4 offers the user 1 an explanation of the procedure and background 2 a list of all the sustainability objectives by clicking on general objective e g Securing Human Existence 3 a description of the respective sustainability objective ar User s Guide Version 1 2 0 a MMT Page 12 3 The allocation is done via the button Add a Problem Area to this Sustainability Goal This opens a subwindow containing the list of all the problems defined in Step 2 SAFIRA II Sustainability Assessment EI Save Assessment Load Assessment Area Modellstandort Krampnitz Potsdam Scenario SzenarioA Layout ScALayout1 5 Define Indicators 6 Sustainable Development 7 Expected Development Ooo Reus O 1 Define spatial con
6. Fig 12 1 Sustainability module first page AI aS User s Guide Version 1 2 0 MMT Page 12 1 12 2 Using the module The module guides the user step by step through the process of producing a set of criteria on which basis the development of a site can be assessed in terms of its sustainability This process includes defining the area to be examined describing the local problems associated with it and finally matching specific sustainability objectives to it By clicking on one of the tabs Fig 12 2 point 1 or on either of the buttons Con tinue or Back point 2 the user moves via 7 steps from the first page to the re sults display point 3 The functions of the individual pages of the form and the inputs required from the user point 4 are explained in descriptive texts point 5 Clicking on OK saves the assessment and opens the MMT Clicking on Cancel point 6 takes the user back to the MMT without accepting the changes The inputs and results of the sustainability assessment can be stored separately and loaded into the system whenever required point 7 Step 1 describes the conditions required for working with the tool This includes the area to be examined and the decision makers and representatives of interested parties involved in working out the sustainability criteria the stakeholders While working with the module it is important to remind oneself repeatedly of the context in which sustainabl
7. Geological and Site Characteristics input form for characterising the subsurface and the groundwater flow conditions rrrrrrnernennenaenannn nne nenne nenn nnennnnnnnnnn nennen 9 4 Fig 9 5 Groundwater Geochemical Parameters input form for characterising the OUI Wale een een 9 5 Fig 9 6 Results form The suitability of the remediation methods with regard to the three input data sets Site Contaminants Geological and Site Characteristics and Groundwater Geochemical Parameters is displayed using the colours green yellow and red 9 6 Fig 10 1 Groundwater flow based design of plume remediation systems 10 2 Fig 10 2 Flexible remediation cost calculation based on results from the conflict analysis 10 2 Fig 10 3 Cost estimation TOM aaa alalt 10 3 Fig 10 4 Dialogues for displaying and changing the total pumping rate as well as for stored files for identifying contaminant hotspots and plUMeS sssssssrrrrererererrrrrrrrererererrrrererers 10 4 Fig 10 5 Additional display of model details and settings shown here using the ROCO model EEE DCs E E E EE E E EEE E EE 10 5 Fig 10 6 Additional display of input data Shown here details of contaminant hotspots and DIAS See 0008 E eda ieeeiaeem 10 6 Fig 10 7 Additional display of cost maps Shown here map representation of cost grids after calculation of soil and groundwater remediation cos
8. Authors Fabio Serapiglia Michael Finkel and Sebastian Schadler _ bCrLf Center for Applied Geosciences vbCrLf University of Tuebingen vbCrLf wit h i contributions from UFZ DJ IETU P and Quadr ga D Save and Back Fig 9 2 Main form of the PRESTO tool Mm User s Guide Version 1 2 0 T Page 9 2 i M MT 9 3 Input form Site Contaminants This form enables the user to characterise the contamination to be addressed with regard to the contaminants at issue The contaminant groups on the site that are to be examined are highlighted from a list of 32 available groups Help buttons open a small information board on each of the contaminant groups When loaded the form already contains entries if either a PRESTO was loaded from the MMT with site data and a hotspot containing the requisite data was selected see above or b a data set was loaded in the main PRESTO form via the menu item Load file Otherwise the form is empty when loaded for the first time Changes are adopted within PRESTO using the OK button but are confirmed and saved in the project only when the user quits the main PRESTO form via the Save and Back button See section 9 2 The Clear Selected Contaminants button deletes all entries s Site Contaminants Clear Selected Contaminants Fig 9 3 Site Contaminants input form for characterising the contaminant hot spot ar
9. Durchsuchen Upload O N AGENCY 2 2 ES AL prot HIA OA 2 Fig 17 3 Selection of a data set for upload First a ZIP file generated by the MMT is selected via the input form The data set is loaded onto the server by clicking on the Upload button The user is then in formed that the data have successfully been uploaded Fig 17 4 A project login is required in SMARTe to save data projects permanently This requires the user to register the project After registration the user is allocated their own project area saving location and an additional control element the pro ject explorer is available as a navigation aid on the right hand side Uploaded MMT files are listed beneath the folder MMT and simultaneously constitute a link to the Comparative Evaluation There is also a direct link to the upload page for MMT files via the Add a document button AI aS User s Guide Version 1 2 0 MMT Page 17 3 An example data set can be found on the server This can be loaded into the work directory from the homepage of the tool via the main menu Input data gt Example data The data sets are then available for comparison SMA R Te Dia Nachhaltige Nutzung von Brachflachen Nutzungsbedingungen Danksagungen Kontakt i i Megasite Management Analysis 7 zl WELCOME MRSMART A A Eingabedaten gt You are currently logged in Home Mind Map Tools Fallstudien L
10. MANAGEMENT USER S GUIDE Version 1 2 0 March 2011 Contributions from Max Morio Sebastian Schadler Michael Finkel Andreas Justen Alena Bleicher Stephan Bartke Matthias Gross Universit t T bingen Zentrum f r Angewandte Geowissenschaften Sigwartstr 10 72076 T bingen Helmholtz Zentrum f r Umweltforschung Permoserstr 15 D 04318 Leipzig EH d Page iii H Page iv List of Contents Part 1 Introduction Installation and Preparation 1 SAFIRAII Megasite Management System and Management Toolsuitel 1 1 1 81975152 14100 EA SONS nee een 1 1 1 2 Land Use Scenarios and LAYOUS ccceceececeeceeeeeeeeeeeeeeeeeeeeeeeeeuteeeeeeeaetesaeneeaes 1 2 1 3 Uae lila eea A ene ee een ae 1 2 1 4 Te MN s uu tu senat aaa aaa a 1 2 2 Design of the Megasite Management Toolsuite nenenennnnanana nai 2 1 3 Installation instructions for Windows XP and XP PC in Windows 7 3 1 3 1 REOTA E e en a a TE 3 1 a Additional software needed een nenne 3 1 3 3 Environment Vall GDICS nee een 3 3 3 4 Installation of the Megasite Management Toolsuite MMT cccsecesseceeeeeeeeeeees 3 7 3 5 What if there are problems ussesesssnesnnnnnnnnnn nn onen nennen nenn nennen nennen nennen nenn 3 7 4 Data input requirements and preparatory Steps u zuuuununununnnnnnnnnnnnn 4 1 4 1 Data and Monna OD NEGAS aaa maa ten 4 1 4 2 Amount of work and prior knowledge required cceceseeeee
11. The MMT valuation module is structured in such a way that non experts can use it to estimate the expected market price of the land being valued The valuation can be conducted only by individuals with knowledge of the locality For a precise as sessment of the market value module users should have reasonable knowledge about the real estate market situation and the site s state of development If this information is not available it is recommended to consult and an expert s or ap praiser s opinion No special data need to be provided for the MMT sustainability evaluation module prior to its application The necessary information is gathered while working through the module If any objectives and indicators for sustainable development already exist at local municipal level these can and should be drawn upon as a benchmark for the evaluation Pm User s Guide Version 1 2 0 T Page 4 2 CI M MT If the MMT sustainability module is used ex post municipal development objectives need to be available If they do not exist in writing they can be ascertained by interviewing the relevant representatives of the municipal administration and local politicians e g town planners economists local council mayor The municipal development objectives serve as a substitute for the identification and prioritisation of existing socio economic problems i e specific local sustainability criteria are developed which then serve as a benchmark for evaluat
12. The form for the remediation costs module is essentially divided into two halves cf Fig 10 3 Separate frames for 1 soil remediation costs ii groundwater remedia m User s Guide Version 1 2 0 Bi Page 10 2 E MMT tion costs iii deconstruction demolition costs and iv other costs are shown on the left hand side of the form Within these frames are the cost models described in section 10 1 with corresponding information regarding the number of contaminants considered in each compartment or the number of buildings considered The results are summarised and annotated on the right hand side By clicking on one of the Calculate buttons a calculation is carried out for the relevant cost element using each of the available cost models and the results are shown for each calculation For each element of cost the user can select whether they want to take the result of one of the models implemented or whether they want to use their own cost figure for the general economic overview The assump tions underlying the selection or input made should be explained in the form s comments window bottom right Other input and information options are available in the form via the following but tons 0 Input of a total pumping rate 0 for PROSIDE May view of cost grid Details Display Setting of detailed maps on contaminated volumes as well as details on uncertainty and sur charge factors HF Display and where desired
13. gt Spread of points distributed SAFIRA II Sustainability Assessment Save Assessment Load Assessment Area Hodellstandort Krampnitz Potsdam Scenario Szenario Layout ScALayouti 5 Define Indicators 6 Sustainable Development 7 Expected Development pS Resuts Introduction 1 Define spatial context 2 Define local problem areas 3 Link to sustainability goals 4 Prioritize problems Prioritizing Problem Areas User Prioritisation RG AB Sustainable Development What does it mean Immisionen durch Hohes 5 5 Which land use option contributes mostto sustains Verkehrsaufkommen in der Innenstadt sustainability is it better to develop a housing area Arbeitslosigkeit und Qualifizierung a How can we base complex decisions on an integra Answering those questions previously to revitalizati Unzureichende Anzahl von In the theoretical debate on sustainable developme euere Te a Eingeschr nktes Angebot auf dem Wohnungsmarkt BE En Erhaltung des kulturellen Erbes der Stadt To rank problem areas please chose one of the Psychologische Probleme aufgrund von following options Arbeitslosigkeit Unzureichende Gewerbefl chen f r wohnungsnahe Grundversorgung Sort by maximal priorit e kki Extreme Armut als Folge von Arbeitslosigkeit und geringer Qualifizierung Sort by maximal conflict potential Geringe Qualifizierung von Arbeitskr ften 2 Sicherung des Kommunalen Einkommens 3 Restore initial order ee Verbesserung der A
14. Gewerbe Mischget 0 0 Om2 Renaturierung 0 0 O m2 Ackerland Forst 0 0 Om2 Market oriented risk rebate E 13 95 492 661 049 Freizeit und 0 0 Om2 Local Factor 20 65 Stadtparl 9 0 98 703 m2 Informational Factor Time Factor 115 00 Gr nriegel 0 0 Om2 Risk Passing on Factor Factor 3 00 Gruenpuffer 0 87 736 m2 Site s market value E 485 746 986 Sustainability assessment Problematic issues Indicator E valuation Eingeschr nktes Angebot auf dem Wohnungs Geb ude und Wohnungsbestand i Wohnungsbestand in Stadtrand G Erhaltung des kulturellen Erbes der Stad Anzahl denkmalgeschutzter Bauw Psychologische Probleme aufgrund von Arb nicht definiert Unzureichende Gewerbefl chen fur wohnung Wohnungsnahe Grundversorgung s cBLayout s gt Extreme Armut als Folge von Arbeitslosig nicht definiert Enlarge image Navigate through the conflict maps using the arrow buttons Togo Fig 13 1 Window showing results from the integrated assessment AI aS User s Guide Version 1 2 0 m MMT Page 13 1 13 2 Results report and data export 13 2 1 Using the form To access the form used for reporting and for exporting data to SMARTe DE click on the menu item File gt Export results There are then four options available in terms of data selection Fig 13 2 Along side the results report and data export to be uploaded later to SMARTe see section
15. Stadtpark E a l Il 107 407 Gr nriegel li l l 0 Gruenpuffer 3 il D ll 85 111 Cancel OK Fig 7 1 User interface of Interactive Land Use Map module 7 2 2 Modifying a layout 7 2 2 1 To modify an existing layout one or more polygons are selected using the mouse The polygons selected appear in the map in cyan and are also marked in colour in the table of attributes see Fig 7 2 Upon selection of the Selection tool four dif ferent options are available for selection Selecting and changing planning units polygons Selection of individual polygons on the map Individual polygons in the map are selected via mouse click If several polygons are clicked on one after the other all these polygons are selected Deselecting the planning units is done by clicking again on the polygon selected User s Guide Version 1 2 0 Page 7 2 on EMMT UMC Land Use Map Creator 100 TAGUS 2 Gewerbe 200 57032 0679453 100 45373 0602327 Load Empty Map Gewerbe 5 Gewerbe 200 H Gewerbe 77994 5454784 Name 7 Gewerbe 200 39876 6363491 ScBLayout1 8 Gewerbe 200 58517 9875341 9 Stadtpark 700 2 66630 2161585 4 gt 10 Gruenpuffer 900 33940 6919989 11 Wohnen 100 39482 8554313 Select by Land Use Category 12 Wohnen 100 56357 2171679 Wakhan 13 Wohnen 100 51978 7354934 Stadtpark 14 Gruenpuffer 900 24406 3190435 Gewerbe IE Gewerbe 35560 2996114 Gruenpuffer 16 Gewerbe 200 16458 0249493 17
16. The lower level goals and their accompanying indicators are shown within the priority goals For each of these the user selects via mouse click whether or not the individual characteristics apply to the planned future site use layout Below this there is space for descriptive comments The results updated automatically after each user in put are displayed in the lower part of the form MMT Potential for Sustainable Development Save as Load Settings Goal 1 SUSTAINABLE LAND MANAGEMENT 1 1 Short distances through complementary land uses Residential Areas in the surrounding i Assessment of the sustainability potential of brownfield A sites Green spaces in the surrounding area Local supplies within walking distance The potential that brownfield sites hold for sustainable urban development Neighbouring uses are strongly emitting 20 7 varies according to the future land use that is planned for the individual sites 1 2 Prevention from additional soil sealing This assessment procedure has been developed to assess what kind of 7 E future land use will achieve the goals of sustainable urban development and Site contains lt 40 sealed soil 2 i which land uses will run contrary to these goals The procedure is to be 1 3 Support for urban inner development applied before any plans have been defined to develop the site Site location within urban area 40 The basis of the assessment procedure is formed by the goals of sustainab
17. Wohnen 100 55009 9050125 18 Wohnen 100 30608 6134524 19 Wohnen 100 30858 8216752 Assign New Land Use Category to 20 Wohnen 100 43570 5929114 the highlighted Land Use Patch 21 wohnen 100 32757 8852536 22 Wohnen 100 58453 6517461 23 Wohnen 100 22561 4280401 24 Wohnen 100 25508 4582059 25 Gruenpuffer 900 26763 0223099 Gewerbe M ischgebiet 26 Wohnen 100 30418 0856626 Renaturierung Act Land Use Land Use Ratio Difference Threshold Actual Land Use Ratio Area m2 49 73 50 00 0 27 10 0 564 922 33 32 33 00 0 32 10 0 378 549 Gewerbe Mischgebiet 0 00 0 00 10 0 0 Renaturierung 0 00 0 00 10 0 0 Ackerland Forst 0 00 0 00 u 10 0 Freizeit und Erholung 0 00 0 00 10 0 0 Stadtpark 9 45 9 00 h 10 0 107 407 Gr nriegel 0 00 0 00 10 0 0 Gruenpuffer 7 49 8 00 D 10 0 85 111 Fig 7 2 Land use map with selected polygons Selecting a region in the map Using the Selection tool a rectangle can be dragged open in the map by moving the cursor with the mouse button pressed down When the mouse button is re leased all those polygons which are touched by this rectangle are selected All the previously selected polygons are automatically deselected in the process So only one rectangle at a time can be selected on the map additional polygons have to be selected individually Note This function can also be used to cancel the current selection by dragging open a small rectangle outside
18. al lt lt Back Continue gt gt Fig 12 10 MMT Sustainability assessment Step 7 Input of the development trend expected for each indicator By clicking on the Continue button the user gets to the result of the evaluation Fig 12 11 A comparison is made of the extent to which the development that would be likely to occur if the current land use scenario was realised as in Step 7 fits with the sustainable development required as in Step 6 The results form shows the problems in the order of priority in which they have been arranged in Step 4 A red dot means that the likely development is not sus tainable a green dot that the likely development is sustainable and a yellow dot marks all other cases A white dot appears whenever in Step 7 no evaluation has been carried out The inputs used to define the evaluation framework along with the result of the evaluation are incorporated into the MMT project by clicking on OK and form part of the integrated assessment If further land use scenarios are to be evaluated only Step 7 need be run through In order to do this quit the section Sustainability assessment and select the sce nario to be evaluated in the main MMT window AI aS User s Guide Version 1 2 0 MMT Page 12 9 SAFIRA II Sustainability Assessment Save Assessment Load Assessment Area Modellstandort Krampnitz Potsdam Scenario SzenarioA Layout ScALayout1
19. asc I Aielwertraster fertiggestellt Fig 8 3 Messages relating to running the conflict analysis es O x Polygonlayers fuer Wisualisierung B_PAK3 B_PAK6 U_PCE W TGE i 8 1 iRunsPerGontaminantlil 1 3 contrasternamelil in j loop PAK3B_B aux FAK3RA_B aux A aux contname PAKSH_B exidanceLayers n E PAKJA i 1 l iRunsPerGontaminant li 1 hk contrasternamelil in j loop PAK6H_B aux FAKGA_B aux A aux contname PAK66_B exidanceLayers n B_PAK6A l iRunsPerGontaminant i1 1 J contrasternamelil in j loop PCE_in_gw aux PGE in gw aux A aux contname PCE in gw exidanceLayers n UW PGE l iRunsPerContaminant il i hk contrasternamelil in j loop TCE in guw aux H aux in_gw W_ICE konvertiert von UNIS nach DOS Text Format konvertiert von UNIK nach DOS Text Format konvertiert von UNI A nach DOS Text Format konvertiert von UNI nach DOS Text Format konvertiert von UHIB nach DOS Text Format konvertiert von UNI A nach DOS Text Format konvertiert von UNIS nach DOS Text Format W_TCE_in_qu asc konvertiert von UNIS nach DOS Text Format 76 67206681698 gt seconds in total for this conflict analysis ttt K ONFLIKTANALYSE BEENDET Schliessen ie dieses Fenster um zum MegasiteManagementTool zurueckzukehren G mms latest version Projekt WorkszshopTue oktz h gt exit Fig 8 4 Report at end of conflic
20. directory e g using C Programmes FWTools2 4 6 bin gdal bin folder C gdalwin32 1 6 bin Note the quotation marks should not be used aS i User s Guide Version 1 2 0 System Properties sister Restore Automatic Updates Remate General Computer Hame Hardware Advanced You must se logged on as an Admnistator to make most of these changes Performance Visual eflecte processor schedulng memory usage and virtual rernary Settings User Profiles Desktop settngs related o your logon Settings Startup and Recover System startup system Failure and debucging information settings Environment Warables Fig 3 3 Adding changing Windows environment variables Environment Variables User variables for Oz Variable Value GO4L_DATA Oigodalvin3z2 1 idata TEFP C Documents and ettingst rziLocal Se TMF C Documents and Settingst ziLocal Se Systen variables Variable Value MUMBER OF P 1 Windows MT C WINDOW S systems2 C WINDOWS PATHEXT COM EXE EAT CMD YES YBEL JS PROCESSOR 4 x56 a Edit System Variable Varlable value esiFt l pols 4 brbn Lodalwins 1 Lire Cancel Fig 3 4 Adding to the system variable Path End the process of editing the system variable Path by clicking OK a User s Guide Version 1 2 0 a Page 3 4 CI M MT A new variable GDAL_DATA may also need to be set for GDAL WIN To
21. new selection of files with hotspot and plume file EUGEN KS Bi Display of explanations help for the individual models MMT Remediation Cost Estimation Settings Input Data Cost maps Soil remediation costs Run models Choose C Choose C Choose Contaminants considered 1 ROCO 176 850 g 4 KONUS 3 480 800 2 t Ext calculation 0 Groundwater remediation costs Run models Contaminants considered 2 ROCO 4 648 270 2 4 Choose PROSIDE 5 265 793 g Q 4 C Choose EUGEN KS 1 606 794 2 SP Details C Choose Ext calculation o C Choose Buildings deconstruction cost modify Run model Choose C Choose Input data not specified yet Number buildings not specified yet KONUS 0 EI Details Ext calculation o Additional costs Contaminated soil volume n Contaminated groundwater volume mm Soil remediation costs E Uncertainty factor Groundwater remediation costs E Uncertainty factor Sum remediation costs resulting uncertainty factor gt Remediation cost min E Remediation cost max Buildings deconstruction cost Subtotal Factor Surcharges gt Surcharges Deductions Additional costs Expected total costs Bitte geben Sie hier erlauternde Kommentare zur Kostenschatzung ein 6 610 2 602 216 176 850 1 0 4 648 270 1 0 4 825 120 4 825 120 4 825
22. tres the rather abstract idea of sustainable development can be defined systemati cally for every situation A detailed description of the concept can be found under the MMT module tab Introduction Fig 12 1 A useful assessment outcome is achieved if as many and diverse actors as possible run through the entire process together If a system of sustainability indicators already exists and is used to assess local developments it is very helpful to use it as a basis for conducting the assessment of land use options SAFIRA II Sustainability Assessment Save Assessment Load Assessment Area Modellstandort Krampnitz Potsdam Scenario SzenarioB Layout ScBLayout1 5 Define Indicators 6 Sustainable Development 7 Expected Development Asse Introduction 1 Define spatial context 2 Define local problem areas 3 Link to sustainability goals 4 Prioritize problems How to use the program Definition lokaler The integrative concept of sustainable development Problemfelder oak Schritt 2 Schritt 3 Sustainable Development What does it mean 44 gt Verbindung der What does the program feature Problemfelder mit den normativen Nachhaltigkeitszielen Schritt 3 v Definition von Indikatoren zur Bewertung der Entwicklung unter dem Aspekt der Nachhaltigkeit Schritte 4 5 v Vergleich der erwarteten mit der i S v Nachhaltigkeit geforderten Entwicklung anhand der Indikatoren Schritte 6 7 v
23. 2 1 US MG MS TO 13 2 13 2 2 Data EXCHANGE TOMAT een 13 3 13 2 3 21011528 POON ee 13 4 14 Comparative assessment z0u0u00n0n0nununununununnnunnnnnununununun nn un an anne 14 1 14 1 1nhoddcloh ausus ee i li aaa 14 1 14 27 SING ES HOU pcre Aaa OO AES 14 1 15 Automatically optimised design of land use options the MOOL tool 15 1 15 1 WIPO CUCU OM Ae ee ee ee nn peter iib ed 15 1 15 2 Methods used by thetool nvrnennnenn nne nne nun en annan anne annan enne nn na 15 1 15 3 Using TE TOOL en ee een ee 15 2 15 3 1 WORK SECU OWNS aaa E T 15 2 15 3 2 Available target function components Land use selection and relative weighting of OPTIMISATION targetSs 2essssesenennnnnennnnnnnnnnnnnnn nenn nnnnnnn nennen nennen nenn nennen 15 3 15 3 3 OPM AON SENO Saaie AAA t a 15 5 B m User s Guide Version 1 2 0 Ra M MT Page viii E 15 3 4 RUNNING The OPUMISALIONs isin nse 15 6 15 4 Visualisation of the result ende 15 7 15 5 Saving reusing the results of the optimisation sssssssrsrsrsrsrrrrrrrrerererrrrrrererere 15 8 16 Probabilistic conflict analysis uuuuuuunununnnnnnnnnunnnnnnnnnnnnnnunnnnnnnnnnnnnnn 16 1 10 1 UOC O eri EE een ee 16 1 16 2 Applying the MOQUIC isicisocdineateccansasaradveadensns eine nennen een 16 1 16 3 Information regarding project preparation ussssssennensnennnnn nenn nennen nennen nennen 16 2 17 Presentation and post processing of the MMT results in SMA
24. ASCII grid yes Estimate or analysis of existing meas m s m s urements and their spatial distribution by hydro geologist Alternatively constant value Buildings characteristics Polygon shapefile no Only if costs of deconstruction are to be estimated Lateral demarcation of ESRI ASCII grid no Required for prioritisation and suitabil contaminant sources and ity test of available remediation tech plumes nologies PRESTO module and for the remediation cost estimation using EUGEN KS note that alternative costing procedures are also available See also comments Table 4 3 Further parameters required values to be entered in the MMT Parameters Format unit Needed Comments Total area of planning Scalar quantity m7 yes area Target values relating Scalar quantity yes To be entered in the form by the user to contaminants ug l Unit must correspond to unit of con taminant distribution This should be done under the supervi sion of an expert in contaminated land management or in consultation with the relevant authorities district environ mental department in accordance with the BBodSchG BBodSchV These may be e g precaution driven concentration targets for the contaminants in question in the corresponding compartment soil or groundwater Reference land values Scalar quantity yes Use type specific reference land values EUR m2 for land use type to be considered In general to be obtained from expert committ
25. MB KS GesRuS MB MRADimO MB MRADimZ MB KS DimZRem MB MRADimR MB KS DimRRem MB MRAPro MB MWVIMw MB MWAbsMRA MB MWMarktw NB PF01 NB PF01 Ind1 NB PF01 Ind2 NB PF02 NB PF02 Ind1 NB PF02 Ind2 NB PF03 NB PF03 Indi NB PF03 Ind2 NB PF04 NB PF04 Ind1 NB PF04 Ind2 NB PF05 NB PF05 Indi NB PF06 NB PF06 Indl MITWIRKENDE NB PFO7 NB PF07 Ind1 NB PF08 NB PF08 Indi NB PF09 NB PF09 Indi NB PF10 ee i a NB PF10 Indi NB PF11 NB PF11 Indi NB PF11 Ind2 NB PF12 NB PF12 Indl s zn NB PF12 Ind2 ADD INFO1 and 2 records amp HELMHOLTZ ZENTRUM FUR UMWELTFORSCHUNG UFZ Fig 17 4 Successful data upload middle data set uploaded right project ex plorer u Documents li Datasets 17 3 Selection of data to be compared and presenta tion of results 17 3 1 Selection of data sets The form for selecting the data sets can be accessed via the menu item MMT gt Comparative assessment if the user is logged in also via the project explorer in the right hand menu bar In addition to selecting the data sets multiple selection using the CTRL key an other parameter area can be opened up by clicking on the symbol see Fig 17 5 bottom and Fig 17 6 Numerical values need to be given for the positive green light neutral amber light and negative red light evaluations of the individual indicators in the sus tainability assessment These numerical values are used in the analysis of
26. MMT Sustainability assessment Step 4 2 Overview of every participant s EoLA Ea o AIEEE EE een een een 12 6 Fig 12 8 MMT Sustainability assessment Step 5 Selection of indicators for evaluating the desired expected future development of the problemS essrsrsrsrsrrrrrrerererererrrrrrerererrrren 12 7 Fig 12 9 MMT Sustainability assessment Step 6 Input of development trend regarded as sustainable for each indicator criterion cccnesnensenseneenennnnnn onen ee nen nennen nne nenne nennen nenn 12 8 Fig 12 10 MMT Sustainability assessment Step 7 Input of the development trend expected PON SICH INGICALOL ee a ee la een 12 9 Fig 12 11 MMT Sustainability assessment Presentation of results 0 m 12 10 Fig 13 1 Window showing results from the integrated assessment mmmnnna 13 1 Fig 13 2 Selection options for reporting and data export ussesessenennenennenennennnnenenne nenne 13 2 Fig 13 3 Information on the files created n nnurnrnnr nn nne nne nenne nn nennen nan 13 3 Fig 13 4 Buttons shown upon completion of reporting exporting cccceceseeceeeeeeeeeeaees 13 3 Fig 14 1 Form used for a comparative assessment of different land use options 14 2 Fig 14 2 Input mask for translating the assessment results of individual sustainability indicators into numerical values Green indicator assessed positively Yellow indicator assessed
27. MT sers Guide i 9 3 input form Site Contaminants een aaa a 9 3 9 4 Geological and Site Characteristics input form ssssssserersrsrsrrrrrrnrererrrererrrrrn 9 4 9 5 Groundwater Geochemical Parameters input form ssssersrsrsrsrrrrrrrrrrerrrererrrrrn 9 5 9 6 KOSUS TOIM omma la connie a daa E AEE 9 6 9 7 211 23540016 00 AMMAS ESIMESTES TEATE ETEM 9 7 10 Costing Module nun 10 1 191 TREO Nee euere ee 10 1 102 6 ace ania a 010 lt A AAA ee er ne vere re 10 2 10 2 1 Models Details SUING S icc cis een ee 10 4 10 2 2 Sascha 10 6 10 3 Other information ee nennen 10 7 11 Market valuation module s 11 1 ILL NTO CUCO e a ee ee 11 1 112 U MONEO ee er en ETE 11 1 11 2 1 WORK SOCON ee E see 11 2 11 2 2 Determination of property location quality and development status 11 2 11 2 3 Estimating the market based deduction for LiSkK cccesceceeeeeeeeeeeeeeeeeeaeeeees 11 5 PES ONT TAM ON AT AO ee nenne aa ee 11 5 12 Sustainability assessment 2020 0n0n000n0nnnnnnnnnnununannnnnnununnnnn nn nun nn n ann 12 1 1251 nigela ee a ee ee en eier 12 1 122 Using th Mod le een sien milk da 12 2 13 Presentation of results reporting data export enennnnsns 13 1 13 1 Presenting the results of the integrated assessment mnnnne nunnu anna 13 1 13 2 Results report and data EXHITE ira iv na v i vanana a elena 13 2 13
28. Stadtpark Grunriegel Gruenpuffer 1 0 1 0 20 30 30 40 40 50 60 Category 2 micro location 2 30 36 34 34 3 6 3 4 3 4 3 4 1 0 Category 3 distances 2 3 0 34 34 34 3 4 34 3 4 3 4 1 0 Category 4 plot characteristic 2 30 36 34 3 4 45 3 4 3 4 3 4 1 0 gt gt gt gt gt gt gt gt gt 1 10 1 02 0 99 0 94 0 87 0 89 0 89 0 84 1 15 Legend Categories 1 through 4 Legend location quality factor WW excellent 1 average 3 HH poor 5 E good 2 acceptably 4 HH insufficient 6 0 4 0 0 T SSSe eee Legend state of development factor 0 Cancel OK Fig 11 2 Input form for determining the factors of location quality and develop ment status Assessment of location quality It does not make sense to apply a spatial differentiation in the case of the factor macro location The assessment is done for the entire site by entering the corre sponding point score per land use type directly in the form The entry must be con firmed by pressing the Enter Return key A spatially differentiated assessment should be carried out for the factors Micro location Distances and plot characteristics The input help dialogue Spatial specification of site s location state of development Fig 11 2 is accessed by double clicking on one of the maps Individual planning units can be selected here by clicking on them or else several at once by dragging a rectangle
29. Use the gt EASY gt gt gt file MapWindowCF47SRa x86 Setup exe from the folder addProgs Once the file has been run the installation procedure is self explanatory The procedure requires a little patience and the computer has to be re Started 7 aS l User s Guide Version 1 2 0 The conflict analysis is based on open source software environments such as Py thon and GDAL as well as MapServer To use the conflict analysis these environ ments must first be installed and configured locally so that the MMT can access them Note if ArcGIS is present in the system A particular version of Python is usually already installed along with ArcGIS The smooth running of certain ArcGIS functions is very closely linked to the Python version installed with it The existing version of Python must not be replaced by a newer one The EASY recommendations assume that ArcGIS is not installed on the PC The following software packages are needed in at least the version stated or a more recent one 2 Python Version 2 5 4 or higher http www python org download and se lect the Windows Installer gt EASY gt gt gt Use the Installer file python 2 6 4 msi from the folder addProgs 3 Python NumPy 1 3 0 3 Further instructions and download at http numpy scipy org and http sourceforge net projects numpy files gt EASY gt gt gt Use the file numpy 1 4 0 win32 superpack python2 6 exe from the folder add
30. User s Guide Version 1 2 0 m MI MT Page 9 3 9 4 Geological and Site Characteristics input form Characterisation of the subsurface and of groundwater flow conditions i e informa tion about the geometry of the aquifer its physical and hydraulic properties in and around the hotspot under consideration is carried out in the Geological and Site Characteristics input form The form also offers a rough estimate of the groundwater travel time to the receptor Fig 9 4 shows the extended version of the form Hydraulic properties of the soil separates can be changed in the lower section This lower part of the form is only visible when the user selects it via the Check or change default values for Hydrau lic Conductivity and Porosity button m Geological and Site Characteristics ots Check or change default values for Hydraulic Conductivity and Porosity OF Close window Fig 9 4 Geological and Site Characteristics input form for characterising the Subsurface and the groundwater flow conditions When loaded the form already contains entries if either a PRESTO was loaded from the MMT with site data and a hotspot containing the requisite data was selected see above or b a data set was loaded in the main PRESTO form via the menu item Load file Otherwise the form is empty when loaded for the first time no User s Guide Version 1 2 0 T Page 9 4 E M MT Changes are adopte
31. ask for the currently valid address 41 Muller W Rohr Zanker R 2009 Bewertung von Nachhaltigkeitspotenzia len stadtischer Brachflachen Abschlussbericht des Projekts Bewertung von Bau landpotenzialen aus der Sicht nachhaltiger Stadtentwicklung am Beispiel einer ehemaligen Milit rliegenschaft in Potsdam ISBN 978 3 934859 27 2 Download http www stadtregion net Downloads 36 0 html aS _ User s Guide Version 1 2 0 Br Ie
32. available the MMT of fers a choice of indicators which then need to be added i e selected by the user using the MMT sustainability module An Office software package MSOffice and a geographic information system GIS such as ArcGIS GRASS or similar are required in order to generate or prepare and where necessary convert data from other formats Once the data preparation has been completed a configuration file in ASCII format the initial project file Pro ject ini INI or CONFIG format needs to be created This file contains information about paths and files and needs to be created edited manually in a text editor for first time use The amount of work and knowledge required to use the MMT as well as the file formats and data needed are explained in greater detail in the following sections 7 aS _ User s Guide Version 1 2 0 MM Pagel 4 2 Amount of work and prior knowledge required As already mentioned it is not possible to say in general how much time and effort is required to prepare the site data in order to use the MMT this can only be esti mated in relation to each specific site In the case of sites where comprehensive studies have already taken place e g with regard to existing contamination it can generally be assumed that site information is available in sufficient quantity and often also in digital form In this case data preparation is essentially limited to converting and clipping digital info
33. conflict analysis is conducted via the following steps 1 The contaminants compartments relevant to the assessment are selected section 8 2 and depending on which approach has been selected either 2a the use related target values are defined section 8 3 or 2b the parameters for the risk assessment are set section 8 4 3 The conflicts between the actual and the target situation at the site in terms of the necessary quality of soil and groundwater are investigated section 8 5 The conflicts should always be investigated anew if either the choice of contaminants and compartments relevant to the assessment have been changed the use related target values have been redefined or the current layout has been modified see section 7 2 7 aS User s Guide Version 1 2 0 8 2 Selection of relevant contami nants compartments To access the list of choices click on the menu item Conflict analy sis Contaminants Fig 8 1 Contaminants form All the contaminants are displayed for which usable information is available on their presence and distribution in soil and or groundwater on the site and for which GIS data have been generated in the course of preparing the project The user can selected as many contaminant compartment pairings as they like from this list By default a deterministic conflict analysis is carried out Alternatively a probabilistic method may be chosen provided the input data for this are
34. dependent on numerous factors These include specifically the division of the site into planning units number and form of polygon areas on which the optimisation is based and the number of land use types and their associated possible minimum and maximum values of remediation costs market value and compactness For this reason it is not possible to set up any generally valid rules In order to establish the weighting relations that fit best with the target set by the user a number of test runs may need to be conducted Attention must be given to the fact that different metrics apply Table 15 1 to the optimisation goals section 15 2 For this reason criteria values are used in a Standardised form in the objective function scale between O and 1 The maximum objective function value maximum fitness of variant is sought In the case of the remediation costs to be minimised the standardisation is inverted so that the minimum achievable remediation costs are given a value of 1 and the maximum costs a value of 0 Table 15 1 Units of the optimisation criteria Optimisation criterion unit Remediation costs Potential for sustainable development degree of suitabil ity Compactness of land use units Minimum total length of edges TotalEdge of the land use areas Minimum relation amount surface of the land use units FRACDIM poss minimum no of land use units per use clusters per class
35. displayed Fig 14 2 Here the user enters the numerical value with which the different assessments of the individual indicators are to be taken into account when forming the overall re sult All the changes made within this frame are displayed in the diagram by clicking on the Update plot button white o Fig 14 2 Input mask for translating the assessment results of individual sus tainability indicators into numerical values Green indicator assessed positively Yellow indicator assessed neutrally Red indicator assessed negatively White indicator not assessed When the user quits the form using the Close button the selection of the use lay out and the settings for forming the results for the sustainability assessment are saved so that the data do not need to be re entered when the form is next opened B Er User s Guide Version 1 2 0 MM Page 14 3 m User s Guide Version 1 2 0 T gt Page 14 4 E M MT 15 Automatically optimised design of land use options the MOOL tool 15 1 Introduction One of the overarching aims of the MMT is to facilitate analysis of the planning scope available for brownfields by means of an integrative assessment and to make optimum use of it To facilitate the quest for land use options that make the best possible use of this planning scope the Interactive Land Use Map ILUM tool made available within the MMT enables the user to change exist
36. do this search the System variables for GDAL DATA If there is an entry here see example Fig 3 6 nothing else need be done at this point If there is no entry click on New in System variables In the field Name enter the variable GDAL_DATA In the field Value enter the path C gdalwin32 1 6 data Fig 3 5 Please check afterwards whether the environment variable is set correctly Fig 3 6 System variables Variable ARS TSHOME E ArcalSs ComSpec CoWINDOW Sisystemse cmd exe FP HO HOST C NO GOAL DATA Cigdalwin32 1 6data NUMBER OFF 1 Fig 3 5 System variable GDAL_DATA already present Neue Systemvariable 7 x Mame der Variablen GDAL DATA Werk der ariablen ongdalvin32 1 61data Fig 3 6 Adding the system variables GDAL DATA System variables Variable ARE GISHOME EN ArcGIS Comspec CUWINDOW Sisystemazicmd exe FP NO HOST C NO GOAL DATA Oigdalwin3 2 1 6idata NUMBER OF FP 1 Fig 3 7 New entry of system variables GDAL DATA AI aS User s Guide Version 1 2 0 ul M MT Page 3 5 After completing the installation and configuration of the packages named above check that GDAL has been successfully installed Open a DOS window Start gt Run gt CMD see Fig 3 8 and Fig 3 9 and en ter ogr2ogr You should now get a few items of information about this pro gramme if GDAL has been installed correctly To check whether Python and GDA
37. enbereich der Stadt Potsdam Grundst ck bebaut teilweise historische denkmalgeschutzte Geb ude Entwurf des Flachennutzungsplanes amt Neu Fahrland Wohn und Gewerbegebiet Project file Projekt iri 21 Site data Land use scenario la sea pe Details Modi m y ooze DEM masl Grid DEM_end asc Wohnen 546 350 me Baer 361 911 mz andus Aquifer base mba Grid aquiferbasis asc scenario Depth to GY m and GW S_ Sep2007 asc Te a na eee ame fie Om2 Rare Freizeit und Erholung Ome Buildings file Stadtpark 33 703 m Grunnegel Ome and use layou Gruenpuffer 37 736 me Gewerbe Mischgebiet Ome Renatunerung Ome Contaminants Contaminants considered 3 Compartment Contaminant Soil Groundwater MEW PCE PAK BETES CE Fhenole Mitroaromaten Schwermetalle Cyanide Quecksilber Arsen e e ih 5 sd hi l N Bel rn 2 u R Je E El aug Enlarge image choose layouts i EEMI Fig 5 1 SAFIRA II MMT user interface with initial information Pm User s Guide Version 1 2 0 T Page 5 2 b M MT 5 3 Setting up a new project This option is not yet available 5 4 Editing existing projects 5 4 1 Loading the project The only file the user needs to select is the main project file for the project in ques tion To select the main project file choose Load project in the File menu usu ally Project ini in the directory lt Path to Project folder gt DATA Ev
38. item Conflict analysis gt Contaminants targets The table values are also called a target value set These sets can be stored separately file type rtv and later re loaded as required a Target values Su Schadstoff Kompartiment Ackerland Forst eel Stadtpark Gr nriegel Gruenpuffer Boden 100 GW GW Save set of target values Read set of target values Fig 8 2 Remediation target values menu 8 4 Parameters for the risk assessment This functionality is not yet available 8 5 Conducting a conflict analysis The conflict analysis is loaded via the submenu entry Conflict analysis gt Start con flict analysis The analysis is conducted on the basis of the OpenSource pro gramme modules and libraries described in section 3 2 which need to be installed along with the MMT 8 5 1 Target value related conflict analysis After the conflict analysis has been launched a DOS window opens up also input command or console in which the python script for the conflict analysis is run python MMSConflictAnalysis py lt path to project gt and numerous messages are displayed relating to the individual steps of the conflict analysis The key steps in the conflict analysis are 1 The project file Project ini is read Current locations are identified for sav ing the scenario and layout to be assessed as well as the contaminants to be evaluated 2 Results from previous as
39. leads to the summary presenta tion of all evaluation results assuming the evaluations for the current land use lay out of the scenario selected have already been carried out The relevant site data the current scenario and the current layout are presented in the left hand part of the form Fig 13 1 while the outcome of the monetary evaluation and the sus tainability assessment are shown in separate frames on the right hand side The layout and the maps produced in the conflict analysis module can be selected and viewed in the frame Land use layout conflict area using the arrow keys see also section Fig 8 6 Results Project Monetary assessment Krampnitz Preliminary land value Beispielszenario f r den Standort Kaserne Krampnitz im Au enbereich der Stadt Potsdam Grundst ck bebaut teilweise historische denkmalgesch tzte Geb ude A A Entwurf des Fl chennutzungsplanes Amt Neu Fahrland Deconstruction and remediation cost E 4 825 120 Wohn und Gewerbegebiet Soil remediation following KONUS 176 850 Groundwater remediation E following ROCO 4 648 270 Uncertainty factor following ITVA C5 3 1 00 Total area 1 096 700 mf expected remediation cost E 4 825 120 Remediation costs min Max 4 825 120 4 825 120 11 739 184 nee Costs deconstruction of buildings E 0 Wohnen 50 0 549 350 m2 Mora LEHRE a Gewerbe 33 0 361 911 m2 Preliminary market value 6 914 064
40. lee Wohnungsnahe Grundversorgung v il E ie wohnungsnahe Grundversorgung Extreme Armut als Folge von Arbeitslosigkeit und Ta nicht definiert il p p geringer Qualifizierung Geringe Qualifizierung von Arbeitskr ften 25 Aus und Weiterbildung il A ri gt Sicherung des Kommunalen Einkommens A hicht definiert il B Pe lt lt Back Continue gt gt Fig 12 8 MMT Sustainability assessment Step 5 Selection of indicators for evaluating the desired expected future development of the problems The definition of what sustainability means depend User s Guide Version 1 2 0 B m By MT Page 12 7 In Step 6 an indication must be given of the direction in which each indica tor criterion should develop so that the development can be described as sustain able Fig 12 9 In the case of most indicators this direction or trend is already given Nonetheless this determination has been defined in a very specific context so it may be that the development needs to move in a different direction in your particular case if it is to embody sustainability A good example of this is the criterion rents In prosperous regions these are usually high and not very socially equitable while in structurally weak regions they are often so low that investment in building stocks is not possi ble Newly defined indicators do not have any f
41. may provide an important basis for planning land use plans on account of the information they contain cf Fig 4 4 These data can be included as background in the visualisation of land use plans and in the evaluation results um i x x 4 oi ag ANS 3 mgd A AA Ni j i i in f en 4 f J x A t WA gt N A k A I x N A A i E Fig 4 4 Example of presentation of information relevant to planning The data listed in Table 4 4 can be incorporated into the visualisation of the land use plans and into the evaluation results provided they have been introduced to Bn ar User s Guide Version 1 2 0 the MMT This is done by entering the files and the associated information for pres entation colours classification of presentation line strengths etc into one of two template files which then controls how the visualisation of the results is displayed based on UMN Mapserver Mapfile syntax see Annex 2 and http mapserver org for further details Table 4 4 Optional site data example demo project data File Format Umgebung Krampnitz tif TIFF Ortho tiff TIFF Strassen shp Seen shp fluesse shp ge Shapefile Polygon or baeude shp Polyline Gws_datum shp Shapefile Polyline GWM_datum shp Shapefile Point Other site data Shapefiles ESRI ASCII or binary grid TIFF JPEG PNG etc User s Guide Version 1 2 0 Page 4 8 Needed no no no no no no no Comm
42. must be installed The computer s country settings must be set to German decimal point repre sented by a comma as standard Windows 7 64 bit Windows own virtual XP PC must be used to install and later use the MMT along with its extra programmes However as Windows 7 is not installed on this XP PC as standard it has to be installed subsequently The download and detailed instructions on how to install the XP PC can be found at http www microsoft com windows virtual pc download aspx An unzip programme must be available on this XP PC download e g here http www softonic de s winrar freeware Running the MMT requires additional software and a few system settings need to be altered Detailed step by step information on this can be found in sections 3 2 and 3 3 3 2 Additional software needed The following is a step by step description of the installation process In addition to providing information about the extra programmes and where they can be sourced a set of EASY recommendations are given for users with little experience in PC system administration Also all the setup programmes are provided in the folder MMT_Setup addProgs on the installation DVD IMPORTANT The programmes must be installed in the order described To use the land use plan module MapWinGIS ActiveX Control must be installed 1 Install the appropriate MapWindow GIS application http www mapwindow org download php
43. neutrally Red indicator assessed negatively White indicator not assessed 14 3 Fig 15 1 Optimisation module user interface n mrrrnnrnve terest nnn nan enter eta nnnnen 15 3 Fig 15 2 Parameters set for the optimisation extract from the input file 15 6 Fig 15 3 Question prompt after changing the optimisation parameters 11 15 6 Fig 15 4 Presentation of results map and accompanying Criterla ccesseceeeeeeeeeeeeeeeeees 15 7 Fig 15 5 Presentation of optimization results as diagrams ccccceceeseceeeeeeeeeeeeeeeaeeeeaes 15 8 Fig 17 1 Web platform SMARTe work sections cccceceeeeceeeeeeeeeeeeeeeeeaetaeeeensaetaeeeeagas 17 2 any MT User s Guide Version 1 2 0 m Eiri Page xv Fig 17 2 Navigation within the SMARTe website to the Megasite Management Analysis tool 9 17 2 Fig 17 3 Selection of a data set for upload nnrvurnvnnenav na nnn en nennen nennen 17 3 Fig 17 4 Successful data upload middle data set uploaded right project explorer 17 4 Fig 17 5 Form for selecting a data set and inputting parameters for the assessment function M pale M t ti 17 5 Fig 17 6 Opened form weightings for the assessment function ccececeeeeeeeeeeeeeeeaeees 17 5 Fig 17 7 Diagrams generated for the data sets of use layouts ScALayoutl ScBLayoutl ScCLayoutl demo data set for the case that priorities a
44. quantifying landscape structure Corvallis Forest Science De partment Oregon State University Further details about the implementation of the spatial metrics can be found in in the appendix of Morio et al 2010 32 If the value is increased the optimization can lead to suggested layouts which can then be entered into a new scenario 33 Note The parameters file is saved temporarily Even after the parameters file has been saved in the editor the original parameters file can be restored by answering No to the prompt 34 If the optimisation module has already been applied to the current layout and if results are available in the layout folder from previous applications of the optimisation module then these results are also displayed prior to the renewed launch of the optimisation 35 The allocation of the IDs is done internally within the MMT as a rule num bers from 100 to 900 according to use and need not be heeded any further by the user 36 Name with relative path name below the layout file folder 37 When a genetic algorithm is used potential land use arrangements indi viduals are analysed by generation 38 Equivalent to the best individual of a generation 39 The data available for this is laid down in the configuration file contami nants agd in the folder DATA The file format is explained in Annex XY 40 At the time of completion of this manual If this link is no longer active please
45. r alle l 2 P amp H Frau Homuth Open Bev lkerungsgruppen JS Herr Sch ck Open 12 Zugang zu Sozialeinrichtungen DO R EE TZ Herr Zill Open Total points Points already allocated PM Herr Menger Open Remaining Points 10 PW Her Weiller Open ono N Oo N 8 w N lt lt Back Continue gt gt m Fig 12 6 MMT Sustainability assessment Step 4 Prioritising the problems Er User s Guide Version 1 2 0 Further information on the procedure Enter a point score between 0 and 5 in the box next to each problem Give a reason for your choice in order to document it for yourself and for the other participants Before going further in the programme all the participants should do this priori tisation participants listed in Step 1 All the individual evaluations are displayed in the overview which you see after clicking on the Show overview button Fig 12 7 The left hand column shows the problem title A full description is shown by clicking on the problem In the heading you will see the name and function of the person who made the evalua tion in question The additional buttons in the left hand part of the overview Fig 12 7 serve to arrange the problems according to particular prioritisation criteria They are ar ranged according to the problem number in the standard setting In addition you can arrange the problems according to the total point score or the degree of conflict
46. remediation cost Legend Pointer functions a a el You can select here whether 0 lt 507 you want to zoom in zoom 507 lt 1 015 out pan or zoom to the entire ti extent of the map 1 015 21 522 1 522 lt 2 029 2 029 lt 2 536 HR 2 536 lt 3 044 Lal lal 1 3 3 044 lt 3 551 Close window Fig 10 7 Additional display of cost maps Shown here map representation of cost grids after calculation of soil and groundwater remediation costs using ROCO 10 3 Other information The module for the cost estimate reads the grids generated by the conflict analysis module of the current land use layout and contaminant target value exceedances from the respective layout folder If a conflict analysis has not yet been carried out the menu item Remediation costs is greyed out No other information data are needed beyond those input data described in section 4 1 Default values e g for unit costs where required are stored in the pro gramme If a cost calculation for the current layout is already available from previous appli cations the settings used in it and the results calculated are carried over For the EUGEN KS model it is assumed that hotspots and plumes of groundwater contamination are known and have been stored in corresponding index files in the DATA folder The different cost models write cost grids with the extension asc ROCO KONUS PROSIDE and or log files wi
47. screen SAFIRA II MMT Market value assessment Assessment of market value Assessment of Mercantile Yalue Reduction Result of value assessment E 57 227 100 soil land value excludin Mercantile Value Reduction Scoring Assessment encumbrances and public Uncertainties perceived by market participants can significantly reduce the market value In this worksheet a scoring approach is applied to charges assess this so called Mercantile Value Reduction MYR 47 693 348 ye Sete MVR takes into account the local situation a time dimension and the situation on the property market Estimate MYA below using the implementation E following worksheets 10 689 323 preliminary soil land value E Local Factor Informational Factor Time Risk Passing on Factor E levelling E Below you find dimensions of the extent of risk perception of market participants according to literature and the results of a survey of experts 4 645 860 Costs for site remediation Considering the property to be assessed enter below for each factor describing possible characteristics of that site to which extent you agree that they are actually correct Use a score between 5 strongly agree and 1 strongly disagree 4 881 888 preliminary market value If you are unsure about an assessment select as score 3 so that the factor is included with an average weighting in the calculation p gt Scores greater than 3 lead to higher surcha
48. the optimisation the following steps need to be taken 1 Using the ILUM tool a new scenario layout needs to be generated from the current layout with the desired land use types and land use ratios see sec tion 7 2 2 After changing to the new layout the optimisation module can be opened with the new layout making available the land use types stipulated there aS User s Guide Version 1 2 0 15 3 2 2 Selection of criteria and their relative weighting The optimisation can be carried out in relation to one or More objectives By select ing or deselecting the individual objectives in frame 2 of the form see Fig 15 1 the user determines the overall goal of the optimisation which is formulated inter nally to the programme by an objective function for which an optimum function value is sought If several objectives are being pursued it must generally be assumed that conflicts will arise between them i e that optimal solutions will be possible only by weighing one objective against another or by reaching a compromise solution The relative weighting of the individual objectives acquires great importance here The user themself decides on the level of the weighting values For this the form offers cor responding slide controls 1 not important to 10 absolutely important Crucial here are the relations of the individual weighting values to one another The importance impact of the weighting on the optimisation results is
49. the re sults to aggregate the indicator values to an overall value The parameters are al ready preset with the values 2 1 and 0 These can be changed within the value User s Guide Version 1 2 0 F m Page 17 4 By MT range of O to 5 in whole numbers The values are transferred for calculation by clicking on the Submit button SMAR Te DE Nachhaltige Nutzung von Brachfl chen et zn Sen oma Denke nen ne ie WELCOME MRSMART You are currently logged in Logout VERGLEICHENE MY PROJECT meyas e mia ment Analysis Feedback BEWERTUNG Vergleichende Bewertung eg ee ee ac ek es A or view your project specific gt User Interf A Aaa baad Einleitung 7 Feedback files aa P Help What does all this MEGASITE MANAGEMENT Das Tool MMT Result Comparison erm glicht den Import von Ergebnisdaten aus dem mean ANALYSIS Megasite Management Tool und erzeugt eine Ergebnisseite zur Betrachtung und zum Adda revitalization option Vergleich dieser Daten gt Einleitung Fi A n A H MMT ame Uber den Men punkt Input Data gt Upload your data lassen sich zuvor generierte ee nah Ergebnisdaten aus dem Megasite Managemant System hochladen EM Vannitoa Anschlie end k nnen die Daten mittels MMT gt Result Comparison betrachtet werden Option Falls mehrere Datens tze hochgeladen wurden lassen sich diese ber ein Men auf der Ergebnisseite ausw hlen Documents Wenn ein Projekt angelegt
50. those that are suitable is selected for estimating the costs In addition KONUS can be used to estimate deconstruc tion demolition costs on the basis of building data such as former use type of construction and gross volume 4 EUGEN KS 2 Cost estimate modules for contaminant plume remediation using a treatment wall funnel and gate or pump and treat are available as a prototype for a tailored cost estimate The required capture zone and other relevant technology design parame ters are roughly estimated based on aquifer and contamination geometry and groundwater flow direction data see Fig 10 1 The expected costs for construction and operation of the remediation system are then calculated based on these design parameters and standard unit price values 7 aS User s Guide Version 1 2 0 Q Flow direction Reactive Material Source Zone A and discharge Impermeable Wall a Pumping Well Fig 10 1 Groundwater flow based design of plume remediation systems All the models work on the basis of the results from the conflict analysis Fig 10 2 This means that the module can only be loaded once a conflict analysis has been carried out i e once the land or volumes to be cleaned up are ready to be deter mined Fig 10 2 Flexible remediation cost calculation based on results from the conflict analysis a GAN lt In sa u Be i A t 5 2 SO A 10 2 Using the module
51. user can pick and choose whether or not they want to display the Ticks the Grid the Labels or the Axis position of the land use options All the display elements are activated as standard The preferred position of the ticks can also be chosen if outside is chosen the abscissa is located on the lower edge and the ordinate on the left hand edge of the diagram Otherwise the axes run through the origin of the diagram provided this lies in the diagram area Shown The diagram area is automatically adjusted to the data points shown Multicriteria Assessment Sustainability Index Comparative Analysis of Site Re Use Options 14 E ScBLayout BScClayout Consideration of target factors How shall priority factors be considered No consideration Explanation Priority factors allocated by the participants to the individual problem areas will be not considered in aggregation of the results No weighting of individual indicator values is made E ScALayoutl Aggregation of results from sustainability assessment Which method shall be used Only positive marks v 1 el S aA Mn 200 150 100 50 WScDLapoutt gt Market value x 10E6 View settings Selection of planning variants Grid WV Show Ticks v Show Labels Iv Ticks v Sc layouti v ScBLayout1 Vv ScCLayout1 7 ScDLayoutl Explanation OF all ratings only the positive ones green light are considered Thi
52. using the mouse These then appear highlighted in colour in the map and in the table Fig 11 3 The selected planning units are allocated a point score or a percentage figure by either entering a score into the text field on the left or more quickly by clicking on the coloured legend buttons AI aS User s Guide Version 1 2 0 m MMT Page 11 3 bottom left Additional information and comments on the assessment can be en tered and displayed in the lower right hand section of the form Spatial specification of site s location quality and state of development Map tools EA MAKRO1 MIKRO1 DIST1 GM1 a a va 12 m ww oo Ww oo oo oo 13 oo Boo to wo oo to Ue T2 1 2 UAL 1 15 1 15 1 05 0 95 2 T2 o 1i m m a LESA LESA Gnd L and to the land use type Wohnen 10 11 12 13 14 Set new value by 15 entering it here or by A i clicking in the legend For the assessment of the micro location you need to evaluate the guality of the actual site with regard to its direct environment and neighbourhood The evaluation of this category is t be done for each planning unit Evidence of a very high compared to a very low guality is fo example that the site is situated in the city center instead of an undeveloped outskirt area a nationally recognized rather than deplorable neighbourhood quality characterisitc and openspace rather than standardised compact construction the proximity to excellently Apply change
53. values in respect of different contaminants and contaminant Recreation area gt groups These threshold values on which site remediation needs Grasstand Greenfiel are based are deduced from risk analyses of the impact path ways soil humans soil domesticated plants and soil groundwater 6 2 2 7 Colour Colour 1100 The definition of the colour of a land use type is done via the Win dows colour selection dialogue which is loaded by clicking on the coloured buttons The colours are used in the MMT to represent the land use types in the land use maps In addition the colour definition is passed on to the different data export formats to display the re sults more clearly 6 2 2 8 Risk assessment Risk Analysts E E E PERE os EMMT If the remediation needs are to be established on the basis of a risk based approach risk analysis and the user has selected this option in the form Settings under File the Edit button leads directly to the input form Exposure pathways in which the exposure pathways are defined that are relevant to each type of land use and potential risk to human health User s Guide Version 1 2 0 Page 6 7 m User s Guide Version 1 2 0 T gt Page 6 8 CI M MT 7 Spatial planning 7 1 Select current layout A new layout can be selected for consideration at any time from among the layouts that have already been designed Choose Select cu
54. wurde ber My Project Login in der rechten Men leiste so E W Datasets werden die hochgeladenen Datensatze in der Projekt Meniileiste unter dem Ordner MMT aufgelistet und sind bei erneutem Besuch der SMARTe Webseite weiterhin verfiigbar Die MITWIRKENDE Datensatze lassen sich ber diesen Link direkt anw hlen und betrachten Ebenso kann ber das eect Set pi galaden werden Add a document INSTITUTIONEN asie Projekt Men leiste dient lediglich a me eu Funktionen ScALayoutl csv sdml ScBLayout1 csv sdml Datensatzauswahl Eia Ka eee M igliche Navigationshilfe und bietet amp HELMHOLTZ ZENTRUM FUR UMWELTFORSCHUNG UFZ EBERHARD KARLS UNIVERSITAT T BINGEN 5 ED ST4 Neg 7 6 AL prot FR Federal Ministry T of Education and Resarch Datensatzauswahl WOHIAA ar m 0 v init Optionen fiir die Ergebnisdarstellung Nachhaltigkeitswerte werden mithilfe einer Bewertungsfunktion generiert Eine Gewichtung f r die einzelnen Werte Rot Gelb Gr n kann hier angegeben werden Nachhaltigkeitsbewertung Submit a z 2 e Y Fig 17 5 Form for selecting a data set and inputting parameters for the assess ment function Optionen fiir die Ergebnisdarstellung Nachhaltigkeitswerte werden mithilfe einer Bewertungsfunktion generiert Eine Gewichtung fiir die einzelnen Werte Rot Gelb Griin kann hier angegeben werden N
55. yet available m User s Guide Version 1 2 0 T Page 8 6 E M MT 9 Identifying suitable remediation technolo gies The technical suitability of numerous soil and groundwater remediation methods can be tested using the PRESTO module PRESelection of Treatment Options PRESTO is a screening level tool The applicability test is based on specific site characteristics key parameters These are 1 the geological conditions 2 the geochemistry of the groundwater and 3 the types of contaminant to be treated on the site i e the contaminated area concerned The assessment of technical suitability is done with the aid of straightforward rules and functional relationships that draw on one or more of the key parameters men tioned above The result is a rough ranking of the technologies using a traffic light scheme If the site presents a number of contaminant hotspots that differ markedly with regard to one or more key parameters PRESTO should be applied separately to each hotspot If contaminant sources and plumes have been demarcated laterally in the context of project preparation see section 4 3 4 some of the key parameters can be taken directly from the project data 9 1 Applying the tool The assessment tool PRESTO can be loaded via the menu item Integrated assess ment gt Remediation technology applicability PRESTO The tool is available even if no MMT project has been loaded beforehand Submenu item us
56. 120 0 4 825 120 1 0 0 0 4 825 120 Details Details Details 7 bernehmen Ext calculation 0 The cost estimation methods that are implemented in this tool are partly or entirely based on empirical values and formulae In the uncertainties section in the advanced settings a quantification of the uncertainties inherent with these estimates is sought Generally those uncertainties are high within the context of brownfields In a report by the German Federal Environmental Agency cost uncertainty is estimated to amount to 40 even after a remedial investigation has been performed UBA 2003 FKZ 200 77 252 Fig 10 3 Cost estimation form User s Guide Version 1 2 0 Page 10 3 B p MMT The display input of a new total pumping rate Q for the PROSIDE model as well as of new contaminant hotspot and plume files for EUGEN KS after clicking on the Q or SP buttons is done via corresponding dialogues Fig 10 4 If an input already exists from a previous use application the old value or file path is displayed and can be overwritten by the user Pumping rate for capturing the entire site m h po Input of the pumping rate that i required to capture the OK entire site After this input the calculation is updated PE vborlt amp Old value Oh Abbrechen Contamimant sources and plumes Current project path CHLisalProjekt The Following Files in the DATA folder are used for th
57. 17 1 results data can be exported for further analysis to MS Excel and as well as in the form of raw data Exporting data to SMARTe producing the results report and exporting raw data are all done at layout level In other words what is being exported are data for each individual reuse option They include all relevant descriptive data on the land use option and the evaluation results obtained By contrast the data package for MS Excel contains the data from all layouts investigated in the current project Details of the data and information exported are explained in Annex 5 Once the exporting process has begun Start export button the programme pro vides information about the files generated Fig 13 3 Once the process has been completed a new batch of data can be exported if required New selection but ton or else the menu can be shut down using the Close button Fig 13 4 m Export of results Data selection Result report Current layout MS WORD r Data esport for DE SMARTe for the existing curent layout Results All layouts MS Excel Results Current layout raw data Lancel Start export Fig 13 2 Selection options for reporting and data export m User s Guide Version 1 2 0 Ei Page 13 2 CI MMT Export of results Sele Data selection W Result report Current layout MS WORD ri Data export for DE SMARTe for the existing current layout Results All layouts MS Exce
58. 7 from the scenario definition then either the cur rent layout can be overwritten or a new layout set up for the current scenario If the site use components of the edited layout no longer fit the scenario re quirements as a result of the changes made the user can either set up a new scenario or overwrite the current scenario These options are explained in greater detail in the following sections IMPORTANT Depending on which of the options listed is implemented various changes to the file and folder system of the project are required These changes are done automatically by the MMT without any further warning This may involved some folders together with their contents being deleted and new ones being added For this reason the user should make sure that all the files they have cre ated themselves not needed for running the MMT are not stored in scenario or layout folders but in separate file folders 7 2 3 1 Overwriting the current layout If the changed layout still fits the current scenario data the user is presented with the choice of either overwriting the current scenario or adding another layout to the current scenario Fig 7 3 SAFIRAI MMS Wahlen Sie OK wenn Sie mit Ihren nderungen das bestehende Layout berschreiben m chten Wahlen Sie bbrechen wenn Sie ein neues Layout erstellen m chten Fig 7 3 Dialogue after changing a layout in the Scenario requirements frame If OK is selected t
59. A II Sustainability Assessment Save Assessment Load Assessment Area Modellstandort Krampnitz Potsdam Scenario SzenarioA Layout ScALayout1 5 Define Indicators 6 Sustainable Development 7 Expected Development pS Besuts 9 Introduction 1 Define spatial context 2 Define local problem areas 3 Link to sustainability goals Prioritizing Problem Areas Goal Prioritisation and Explanation Immisionen durch Hohes Yerkehrsaufkommen in der Ul 5 Innenstadt Sustainable Development What does it mean Which land use option contributes most to sustain re 13 2 sustainability is it better to develop a housing area How can we base complex decisions on an integra Unzureichende Anzahl von Gewerbefl chen 25 3 Answering those guestions previously to revitalizati Inthetheoretical debate on sustainable developme Eingeschr nktes Angebot auf dem Wohnungsmarkt 1 2 0 Erhaltung des kulturellen Erbes der Stadt 218 Show Overview Psychologische Probleme aufgrund von Arbeitslosigkeit 1 3 Aktueller Teilnehmer HE leled ii Unzureichende Gewerbefl chen fiir wohnungsnahe E 3 Il Mu Grundversorgung 1 RG Her Gerhardt Open Extreme Armut als Folge von Arbeitslosigkeit und f 3 o o geringer Qualifizierung 4B Frau Bronner 0 mag 9 Geringe Qualifizierung von Arbeitskr ften u EEE JE Herr Eichele Open UH Herr Hiester Open 10 Sicherung des Kommunalen Einkommens EIN MF Frau Fi ie TURE 11 Verbesserung der Ausbildungschancen f
60. Berechne Kompaktheit aus Mittlere FractalDimension FRACDIM MEAN und mittlere Anzahl der Cluster per Nutzung noCLUSTER_NORM und Anzahl vorhandener Nutzungen PR_SCORE SCORE PR SCORE wichtung 10 1 1 wichtung 10 noCLUSTER_NORM wichtung 11 1 1 wichtung 11 FRACDIM MEAN wichtung 9 1 1 wichtung 9 SankostenNormiert wichtung 13 1 1 wichtung 13 MarktwertNormiert wichtung 12 SSI wichtung 14 1 1 wichtung 14 Return SCORE As part of the optimisation process it may be helpful to examine the potential for optimisation beyond the given scope set within the scenario definition namely by the maximum permissible deviation of the land use ratio for each of the individual use types which is set at 10 by default In the text input box Allowed differ ence of land use type s area a value can be set that differs from the default value 15 3 3 Optimisation settings 15 3 3 1 Optimise additionally for each individual criterion If this option is selected a separate optimisation run is conducted additionally for each individual target item selected the other criteria are not taken into considera tion i e they are not considered as part of the objective function In addition to optimisation on the basis of an integrative evaluation scheme the best land use alternative is sought here with regard to the minimisation or maximisation of a sin aS _ Use
61. L are connected correctly enter python in the DOS window In the Python environment type from osgeo import ogr If an error message appears re start the computer If necessary check whether the environment variables Path and GDAL DATA have been entered cor rectly with no typing errors w Internet ey My Documents jl amp My Pictures 3 E mail A fer My Music EEH SAFIRA II MMT er My Computer t My Network Places a ArcMap 2 Control Panel EN Notepad F fet Program Access and Defaults Microsoft Office Excel 2003 l i Help and Support pay SAFIRA II MMT entfernen Fees a Internet Explorer Mo fo Add ons Opere a program folder document or eb site TD P Lag CFF 0 Tum OF Computer Type the name of a program folder document or Internet resource and Windows will open it for vou Open i Cancel Browse Fig 3 9 Programme cmd to open a DOS window F m User s Guide Version 1 2 0 T Page 3 6 CI M MT 3 4 Installation of the Megasite Management Tool suite MMT The user should ensure that a directory name without spaces is chosen as the installation folder for the MMT setup during the installation process That is not C Programme Files but rather for example C Programmes Safira2mmt or if there is no write permission for the directory Programmes C Users Data Klaus Safira2mmt etc The MMT setup file is in the
62. Management System and Management Toolsuite 1 1 Goals and End Users The aim of the SAFIRA II Megasite Management System MMS is to provide a deci sion support system for assessing and developing sustainable and effective land use Strategies on large scale contaminated sites megasites The SAFIRA II MMS consists of a set of operational modules in the form of mutually compatible software tools that are integrated into an overall system the so called Megasite Management Toolsuite MMT The MMT is complemented by a set of prac tical guidelines MMG in which the tasks and decisions required for a revitalisation process are described and discussed from the perspective of a variety of stake holders The particular purpose of the operational modules is to support the decision maker s in identifying and assessing potential site development options use clean up remediation taking into account available planning options and in determining suitable economically feasible options for construction and clean up planning It is aimed potentially at planners and decision makers in municipal au thorities and private companies who in various kinds of contexts need to make informed judgements about activities e g private investment or measures e g site clean up etc in connection with a megasite The principal aim of the MMS is to stimulate and support discussion among all those involved particularly during the pre planning and strategisin
63. Mischgebiet Renaturierung Ackerland Forst Freizeit und Erholung Stadtpark Gr nriegel Gruenpuffer Zus tzliche Bemerkungen Gesetzte Werte Wohnen Gewerbe Gewerbe Mischgebiet Renaturierung Ackerland Forst Freizeit und Erholung Stadtpark Gr nriegel Gruenpuffer Bodenwert belastungs und abgabenfrei Fl chenaufbereitungs ErschlieBungskosten und Realisierungsrisiken Vorl ufiger Bodenwert if m TE si sil ace Run nunnu 43 ant 20 kabe ScALavout1 ScBLavout1 ScCLavout1 Krampnitz Krampnitz Krampnitz RG Herr Gerhardt RG Herr Gerhardt RG Herr Gerhardt AB Frau Bronner AB Frau Bronner AB Frau Bronner JE Herr Eichele JE Herr Eichele JE Herr Eichele UH Herr Hiester UH Herr Hiester UH Herr Hiester MF Frau Freygang MF Frau Freygang MF Frau Freygang AH Frau Homuth AH Frau Homuth AH Frau Homuth JS Herr Sch ck JS Herr Sch ck JS Herr Sch ck TZ Herr Zill TZ Herr Zill TZ Herr Zill PM Herr Menger PM Herr Menger PM Herr Menger PV Herr Weiller 1 P Herr Weiller Wiedernutzungsszenario Flachenanteile der einzelnen Nutzungen in PV Herr Weiller 58594926 77133653 62303527 29297463 60910718 44331356 29297463 16222935 17972171 Fig 17 8 Extract from comparison chart using the example of data sets ScALay outl ScBLayoutl ScCLayoutl User s Guide Version 1 2 0 Page 17 8 m MMT Nachhaltigkeitsbewertung Immisionen durch Hohes Verkehrsaufkom
64. Progs 4 Download and unzip GDAL 1 5 4 2 or higher http download osgeo org gdal win32 1 6 gdalwin32exe160 zip The directory can be selected at ran dom but is relevant for the installation of PYTHON GDAL and for setting the environment variables If the programme is not unzipped in C the defi nition of the environment variable GDAL_DATA section 3 3 needs to be ad justed later gt EASY gt gt gt Unzip the file gdalwin32exel60 zip from the folder addProgs and unzip in C see Fig 3 1 C gdabwin32 1 6 Fe kdt view Favorites loos Help E Q pak us Bj Search iy Folders Ak Acdress Chgcalwin32 1 6 a Folders x Meme size Type Date Modfied T Desktop A bin File Felder 23 06 2010 04 35 E E My Documerts data File Felder 23 06 2010 04 35 E iy Compute E RCADMI CC TST ED Tesk Docunen 09 12 2000 14 39 Cl u 31 Fluppy A ww Local Diss 2 E Documerts aid Settings IS flexdm a DO Et A IC Program Files O Projekt WorkshosTue oht2003 G Pyth 1861 188 al 3 objects Dick free saare 468 MR 263 aves ing My Comp iker Fig 3 1 Installation of the GDAL library Mm User s Guide Version 1 2 0 m Page 3 2 CI M MT 5 PYTHON GDAL 1 6 2 1 http pypi python org pypi GDAL 1 6 1 download GDAL 1 6 1 win32 py2 x exe according to the Python version installed and install it gt EASY gt gt gt Use the file GDAL 1 6 1 win32 py2 6 exe from the folder
65. RTe 17 1 17 1 Overview and structure of Internet platform SMARTE ccececceeeeeeeeeeeeeaeeneeeass 17 1 142 7 Data ubload and project older 17 3 17 3 Selection of data to be compared and presentation of results 1 17 4 17 3 1 Selection of data setSs ceesessesnennennnnennnennnnnnennennnnennnnnnnnne nennen nenne nenne 17 4 17 3 2 Presentation OF results dala ssassn EEEE 17 6 18 Enahotes derra an A A E 18 1 User s Guide Version 1 2 0 L M MT ser s Guide PE 4 H Page x List of Figures Fig 1 1 Schematic representation of the MMS and its core elements ieee 1 1 Fig 3 1 Installation of the GDAL library 22422222222202 ee RnB nennen nennen nennen nennen nnnenen nenn 3 2 Fig 3 2 Installation of MapServer via FWTOOIS ceteris onen nn nn nn nnennn 3 3 Fig 3 3 Adding changing Windows environment variables cccccccceceeseeeeeeeeees 3 4 Fig 3 4 Adding to the system variable Path sesseseenennennnnennennn nenne nenne nenne 3 4 Fig 3 5 System variable GDAL DATA already present ssesseenennennennnn nn 3 5 Fig 3 6 Adding the system variables GDAL_DATA sssssesnennennennennnn nunnana 3 5 Fig 3 7 New entry of system variables GDAL_DATA sssessesnesnennennennnne nennen 3 5 Fig 3 8 Run open programmes documents in Win XP uzessesessesennenennnnenennennnnne 3 6 Fig 3 9 Programme cmd to open a DOS window eessesees
66. RTe DE Sustainable Management and Revitalization Tools electronic f r 5 n r DEutschland ist eine freie open source Internet Plattform zum Thema Fl chenrecycling ita P bzw zur Brachfl chenrevitalisierung Ein besonderer Augenmerk richtet sich dabei auf mm Se gt st dtische oder stadtnahe gro fl chige und vornutzungsbedingt kontaminierte Standorte SMARTe DE richtet sich an alle Akteure bzw Beteiligte von MITWIRKENDE Project Schedule Brachflachenrevitalisierungsvorhaben und bietet INSTITUTIONEN Other 2 v e grundlegenden Informationen zum Thema A REN 6 e Werkzeuge Software Tools zur Unterst tzung bei der Entwicklung nachhaltiger und ZENTRUM F R effizienter Nutzungsstrategien f r Brachfl chen sowie UMWELTFORSCHUNG e eine Datenbank f r die Vorhaltung Verbreitung und Visualisierung von ure Projektergebnissen an EBERHARD KARIS _ UNIVERSITAT Sowohl die Anwendung der Tools als auch die Einstellung von Informationen zum TUBINGEN jeweiligen Vorhaben ist dabei in aller Regel fachverst ndigen Personen und Institutionen wie TED STa D p e Planungsb ros und planende Beh rden Ingenieurb ros welche in den Bereichen Altlastensanierung und SZ Flachenrevitalisierung t tig sind sowie f private und kommunale Fl chenentwickler sowie Fl cheneigent mer oder Investoren 74L prow vorbehalten Der interessierten Offentlichkeit Laien bietet SMARTe DE durch
67. Se BLayoutl 295 Co PrP o 27 8 T A Ca SeALayoutl a a 0 5 10 15 20 5 30 0 2 4 6 8 10 Arzahl negineutralipas richt bewerteter PF gewichtet nach PF Marktwert tin Mio Eure Negativ bewertete Indikatoren Positiv bewertete Indikatoren AD T n Eo g A mi n zi Il a A ti 35 gt 43 a op ob 4 E o Es s ks 7 2 u E urn SE _ Ze u E 5 oo 0 2 4 6 a 10 0 2 4 5 5 10 Marktwert in Mio Euro Marktwert in Mio Euro Fig 17 9 Diagrams generated for the data sets of land use layouts ScALayoutl ScBLayoutl ScCLayoutl demo data set with sustainability assessment results weighted by the median of the priorities 7 aS User s Guide Version 1 2 0 MM m User s Guide Version 1 2 0 T gt Page 17 12 CI M MT 18 Endnotes 1 http www sinbra de 2 These distributions should preferably be generated using existing measure ments interpolation procedure poss even by hand Alternatively if no measure ment data are available or if there are gaps in the data results from the historical study areas suspected of being contaminated can also be rendered in digital form 3 GIS is not needed to use the software once the data have been prepared 4 A definitive description of the file formats can be found at http docs codehaus org display GEOTOOLS Arcl nfo ASCll Grid format ASCIIG rid bzw http www esri com library whitepapers pdfs shapefile pdf 5 If the data needed to load a menu item
68. Version 1 2 0 T Page 7 6 CI M MT 8 Conflict analysis 8 1 Basic information Using the functions of a geographic information system GIS the required remedia tion of the site is investigated in relation to the planned reuse and its associated demands on environmental quality This investigation is based on the existing situation regarding environmental burdens main contaminants detected on the site The conflict analysis may be run either on the basis of land use specific target val ues or using a risk based method Depending on which approach is selected in the form Settings in the File menu see section 5 5 either the quality requirements of soil and groundwater target values in terms of concentration standards for individual contaminants and land use types are placed in relation to the spatial ar rangement of a reuse scenario or a risk assessment is conducted on the basis of use specific exposure scenarios Target value or acceptable risk level exceedance maps showing the extent of con flict between the goals of desired future land use and cost avoidance minimisation of remediation efforts emerge in line with the spatial arrangement and sensitivity of the planned uses The distribution of conflicts is recorded in the system along with other information e g depth of contamination in the form of tables and grid data and forms the ba sis for the subsequent remediation cost estimate see section 9 The
69. ached from the Megasite Management Analysis tool via the main menu Input data gt Data upload SMA R Te Dia Nachhaltige Nutzung von Brachflachen a oes ee ee gerug maaan PROJEKT LOGIN v9 Projekt ID Hilfe Tutorial udien Links waLc m vp vau Passwort MEGASITE MANAGEMENT Daten Upload f r MMT Ergebnisdaten ANALYSIS 3 a BER 2 Neues Projekt Hier anlegen gt Finleikung Ein MMT Datensatz besteht aus mehreren Dateien Einer CSV Datei die numerische Daten gt Methods und Text enth lt sowie bis zu f nf Bild Datei im JPEG Format Die Dateien k nnen entweder u einzeln hochgeladen werden oder gezippt als Containerdatei Anmelden CSV Datei Textdatei zum Austausch einfach strukturierter Daten csv JPEG Datei Dateien im Grafikformat JPEG jpg ial ZIP Datei Containerdatei in der mehrere Dateien oder auch ganze INSTITUTIONEN Verzeichnisb ume zusammengefasst werden k nnen zip 6 a HELMHOLTZ Bemerkung Die Dateigr e ist auf ca 1 MB beschr nkt Das Hochladen gr erer z J ZENTRUM F R Dateien kann zu Fehlern f hren UMWELTFORSCHUNG UFZ Bei Projekt Login werden die hochgeladenen CVS Dateien im Projekt Men unterhalb des m MMT Ordner abgelegt BERHARD KARIS _ DENE nn Klicken Sie auf Durchsuchen und w hlen Sie den gew nschen Datensatz auf Ihren T BINGEN U Vau Destaltl yieD ST4 N Tp home andreas pos6ExData
70. achhaltigkeitsbewertung i Bewertungsfunktion Faktor f r Gr n x 2 b Bewertungsfunktion Faktor f r Gelb v 1 w Bewertungsfunktion Faktor f r Rot z Ov Fig 17 6 Opened form weightings for the assessment function User s Guide Version 1 2 0 ay MT Page 17 5 17 3 2 Presentation of results data 17 3 2 1 Overview After the data set selection one data set per evaluated layout and the parameter inputs have been confirmed and sent using the Submit button the following are automatically generated atable with all data and results from the selected data sets and five figures one figure for each of the 5 options for taking account of the priori tisation factors given by the participants in the sustainability assessment A new window Comparative assessment see Fig 17 7 opens up displaying the comparison of land use options On the left hand side is a list of the analyses generated this serves as a navigation bar SMARTe Megasite Management Analysis Mozilla Firefox EX http u 155 c181 zag uni tuebingen de smarte tools MegasiteMManagement nalysisfindex xml mode results amp doc workspace users anon 784505292631 5 RESULTS Ergebnis Tabelle Results Figure 1 1 Marktwert Hachhaltigkeits Plot ohne Previous Next Priorisierung Page 2 of 6 Figure 2 1 Marktwert 2 A E ee Nachhaltigkeits Plot mit Figure 1 1 Marktwert Nachhaltigkeits Plot ohne Priorisier
71. addProgs 6 Shp2img exe is an auxiliary programme in MapServer that generates images from geodata It can be installed using FWTools a minimum installation is sufficient gt EASY gt gt gt Use the file FWTools246 exe from the folder addProgs During installation de select the components selected as standard Developer Files Demo Data and Desktop Short cuts Fig 3 2 ir FWTools Setup Installation Options Ses Check the components you want to install and uncheck the components you don t want to install Click Next to continue Select components to install FWTools Executables required Developer Files h lib LI Demo Data Desktop Shortcuts Space required 79 1MB Fig 3 2 Installation of MapServer via FWTools 3 3 Environment variables Once the extra programmes have been installed a number of environment vari ables still need to be set To do this a right click on Computer gt Properties leads to the window System properties Here select the tab Advanced Fig 3 3 Click on the button Environment Variables In the window that then appears se lect Path under System variables and then click on Edit Fig 3 4 Here add to the paths for the following directories separated from the previous entries using a semi colon Python installation folder e g C Python26 Complete FW Tools bin
72. age 15 8 CI MMT 16 Probabilistic conflict analysis 16 1 Introduction The estimate of remediation costs likely to be incurred if one of the planning vari ants is realised is of crucial significance to judging the variant in question One im portant pillar of the costing is the result of the conflict analysis which in turn is directly dependent on the contamination situation at the site i e on the spatial distribution of contaminant concentrations in the soil and groundwater With regard to the contaminant situation however considerable uncertainties may exist depending on the extent of investigations undertaken The significance of these uncertainties for the evaluation result can be estimated using the probabilistic conflict analysis module The module incorporates several realisations of statisti cally equally probable contaminant concentration distributions The conflict analy sis is carried out for each of these realisations and delivers several possible sets of results accordingly as many as the realisations considered these results reflect the uncertainties that exist regarding remediation needs 16 2 Applying the module The user can decide which kind of conflict analysis deterministic or probabilistic is to be carried out in the Contaminants form see section 8 2 If there is only one realisation of the concentration distribution for a contaminant the setting Probabil istic has no effect 2 The probabil
73. and use in the vicinity local and regional planning regulations It is not only possible but indeed desirable to generate a broad range of options that includes different and even contrasting ideas Establishing remediation objectives Use oriented remediation objectives need to be defined for each type of land use in the scenarios to be assessed and evaluated Conflict analysis remediation needs Remedia tion needs are identified by overlaying the relevant maps in the GIS i e conflicts be tween use related remediation objectives and os EMMT Preparation Data Inquiry Site Investigation GIS Based Data Management Visions and Plans for Future Use Definition of Remediation Targets Conflict Analysis Required Actions 4 a O A Holistic Integrated Assessment Iterative Procedure Cost Estimation Market Oriented Econ Valuation Sustainability Assessment Visualization and Export of Results Fig 2 1 Planning and evalua tion steps using the MMT User s Guide Version 1 2 0 Page 2 1 existing soil and groundwater contamination are pinpointed This feeds into a calculation of contaminant specific conflict maps and exceedance maps These maps form the basis for the use based remediation cost calculation Site preparation and remediation costs The MMT makes available a variety of procedures for estimating costs These can be used flexibly depending on the data availab
74. are not yet available because an other work step to be gone through beforehand has not yet been carried out the menu item in question is grayed out indicating that it is inactive 6 The system of assessment has been kept simple in line with its purpose and therefore does not take account of the specific framework conditions of a site which may be relevant to the assessment The process thus delivers a well founded and comprehensible assessment of which land uses are best suited to the objectives of sustainable urban development It cannot however provide a substitute for a de tailed case by case examination 7 Land utilisation ordinance version as per announcement published on 23 1 1990 Fed Law Gazette I p 132 amended by Art 3 of the law of 22 4 1993 Fed Law Gazette I p 466 8 German Federal Soil Protection Ordinance of 12 July 1999 Fed Law Ga zette p 1554 most recently amended by Article 16 of the law of 31 July 2009 Fed Law Gazette 1 p 2585 9 It is advisable to consult with the relevant authorities when setting the remediation target values 10 Note It is also possible to enter the script from the command line without using the MMT The conflict analysis is then run with the last scenario and layout that were active in the project without having to launch the MMT The scripts can also be launched from the command line without an argument if they have previ ously been copied into the
75. ario specific areas of uses a given in the column scenario In the column RLY you need to specify levelling locally and re use specific reference land values in a currency per area unit here EUR r In general use specific values are assessed by referring to market data of comparable uncontaminated sites in the region of the brownfield to be appraised The data is to be obtained 4 645 960 in a separate market analysis in a sales comparison approach or can be obtained in several jurisdictions as RLY that represents regional ae average values of properties based on recent purchase prices RLY are available from regional committees of valuation experts The default values refer to a site in the North of Potsdam Germany and may have to be adjusted The RLY is corrected for the site s location 4 881 888 preliminary market value E guality and state of development for each sub area Press the button under the respective column to complete these entries and then go tothe second worksheet Costs for site remediation Mercantile Value Reduction MYR Land use type Scenario RLY 7m location SDev Result for 22 4 Local Factor quality factor soil land A A m factor value E 1 15 Informational Factor Time 0 30 Risk Passing on Factor Wohnen Gewerbe 6 017 775 0 7 7 MYR in percent 3 369 600 377 677 MVR absolute E 20 148 sd aaa 0 120 225 4 504 211 Market value of site Gewerbe Mischgebiet Renaturie
76. attern involving minimum sprawl i e maximised compactness of land use units The resulting degree of sprawl depends on the weighting of this criterion in relation to those mentioned previously 27 Morio M Finkel M und A Srinivasan 2010 SAFIRA II Megasite Mana gementsystem MMS Automatische Optimierung der r umlichen Verteilung der Landnutzungen MOOL Multi Objective Optimisation of Land Re Use Hand buch Dokumentation zu Methodik und Anwendung innerhalb der Megasite Mana gement Toosuite MMT project report 71pp 28 This means that at least two land use types have to be selected for it to make sense to run an optimization 29 For example if all the weighting values are the same and greater than 0 then the weighting value itself is insignificant 30 The spatial metrics used to evaluate the compactness of the land use units are based on McGarigal K and B J Marks 1995 FRAGSTATS spatial pattern Pm User s Guide Version 1 2 0 T Page 18 2 E MMT analysis program for quantifying landscape structure Corvallis Forest Science De partment Oregon State University Further details regarding the implementation of the metrics for the target function can be found in the annex of the MOOL module description Morio et al 2010 31 The spatial metrics used to evaluate the compactness of the land use units are based on McGarigal K and B J Marks 1995 FRAGSTATS spatial pattern analysis program for
77. aunched for the first time 3 Buildings data Summary and display of building data stored along with the resulting costs per building available only after conducting the demoli tion cost estimate aS User s Guide Version 1 2 0 Fahnen ase 9 Sehsdmtottherde Fahnen identifiriert Eredetle mittlere Fliedeichtungen flr 9 Schadstsffhecrde Eemittle Heedbreiten senkrecht zus Fliebeichtung Herd 1 von 3 Anzahl Zellen 46 Gradient 0 0359 Abs Herd 2 von 9 i Anzahl Zeilen 116 Gradient 6 0015 Abe Herd 3 von F Anzahl Zellen 198 Geadient 0 0019 Abhi Herd 4 von 9 Anzabi Zeilen 132 Gradient 0 0614 Ab Herd 5 von 9 Anzahl Zeilen 67 Grading 0 0042 ABS Herd amp fon 9 5 Anzahl Zeilen 35 Gradient 0 0121 Abs Herd 7 von 5 Anzahl Zellen 6 Gradient 0 025 Abati Herd von F Anzahl Zeilen l Gradient 0 0066 Absa Herd 9 von F 1 Anrahl Zellen Gradient 0 0014 Abati Fake Li 130 Zeilen ber cksicheige mitti Ziejwecrt berschreiting 9718 09930128728 Foneakereeie 131 1634 M Fahne 2 321 Zellen ber cksichtigt Ritel Zielvect berschreieisg 11803 498498 546 Fontectreite 133 945 Fahze Ji 382 zellen ber cksichtigt mitel Zislweccibtrsacheeitiong 15194 4314534155 Kontakt teeiti 17 5526 er _ ND E MP Fahne 4 400 Zeilen ber cksichtigt Fig 10 6 Additional display of input data Shown here d
78. available see section 16 for more details on the probabilistic conflict analysis Contaminants Contaminant selection Contaminants Compartments GIS data are available for EJ PAE im Boden Deterministic Probabilistic PY TCE im Gy 6 Deterministic Probabilistic EH PCE im Gi 6 Deterministic Probabilistic Fig 8 1 Contaminants form 8 3 Use of concentration standards use related remediation target values It is necessary to set remediation target values when the conflict analysis is to be done on the basis of a Spatially differentiated comparison of the actual and target value of the concentration of the contaminants in soil and or groundwater consid ered relevant For this a concentration target value needs to be determined for each individual land use type for the previously selected contaminant compartment pairings see section 8 2 Regulatory requirements must be taken into account For each contaminant a spatial distribution of the concentration target is calculated that represents the requirements of the land use layout under consideration This distribution is compared with the spatial distribution of contaminant concentrations in soil groundwater within the GIS based analysis geoprocessing Multiple con taminants may be analysed in parallel Pm User s Guide Version 1 2 0 T Page 8 2 b M MT To access the input table for remediation target values Fig 8 2 click on the menu
79. ble Spatial allocations of land use types on the site are translated into a binary repre sentation The current land use layout serves as the starting point initial map for the opti misation The initial population is generated from this integer array representa tion of the planning units Detailed information is contained in the annex to the report on the optimisation module In the course of the optimisation process the solution is altered successively by means of genetic operators pairing mutation and crossover cf Goldberg 19892 until it becomes an optimal solution This is done by drawing on the GAlib pro 7 aS _ User s Guide Version 1 2 0 gramme library Wall 199624 and an extended version of LUPOlib Holzk mper 2006 The suitability or optimality of the solution in question is evaluated using a multi criteria objective function The latter is not fixed in advance but is defined in line with the user s requirements The optimisation can be geared towards the following goals a minimising remediation costs b maximising market value incl depreciation in the sense of a market oriented mercantile value reduction c maximising the degree of suitability with respect to sustainable develop ment spatially differentiated and aggregated into an overall result and d w maximising the compactness of the land use units A detailed description of the optimisation methods u
80. charges to the average costs are calculated Mm User s Guide Version 1 2 0 T Page 10 4 MMT Rocn T T EUGENES T Limgestainiien ROCI n kaasad on method by Earl a a TER Rech a ee eh re ae io ee 4 quack reiche eimai ol oad and groundwater remediaton costs within the contest ol large number of brosme prvatizaton oben The method ama tor the deksmmnaton of a so called mean scenano in order Io provide a comect eine when the sum of a large number of tet a conmdeied The model reeds only tile input data The comiamngiion depth and contavenated anes paking Ure coals are part of the POCO model caliesbon and can not be modiind by the usa Sed remechaison cost models totli Gieundeate romian cost models solimy Degree of ee lache Dane il Excesdance lacio ky i komm I t hag 50 high 5 Fig 10 5 Additional display of model details and settings shown here using the ROCO model as an example 10 2 2 Input data In this part the input data for the cost estimation models are summarised and pre sented in prepared form The following three tabs are available 1 Concentration exceedance Display of results from the conflict analysis in the form of detailed target value exceedance maps and a statistical sum mary which is calculated when the window is opened 2 Contaminant sources and plumes Overview of the contaminant hotspots and plumes stored for EUGEN KS including an analysis of them available only after the EUGEN KS tool has been l
81. cted site use op tion and the existing contamination in the soil and groundwater This involves se lecting the contaminants that are relevant to the analysis and where necessary characterising them more precisely In addition the land use types to be consid ered need to be defined more precisely with regard to their susceptibility to threats from existing contamination in the form of permissible maximum concentration values or in the case of a riSk based conflict analysis by selecting and specifying relevant exposure pathways Integrated assessment gt This is where the suitability of the currently selected site use option is assessed in an integrated manner i e both economically and in terms of its contribution to sustainable development To do this there are modules for i assessing the basic suitability of remediation technologies ii estimating the remediation costs iii undertaking a market oriented estimation of land value and iv the sustainability assessment The results of the integrated assessment along with interim results can also be presented here in summary form Optimisation gt This is where optimal layouts for site use can be generated auto matically using a simulation optimisation tool Comparative Assessment gt This is where costs and benefits of multiple use op tions can be compared both economically and with regard to their sustainability The complete menu structure can be found in Annex 3 5 2 T
82. d Otherwise analysis functions used within the evaluation system will not work correctly Legende A 1 area of Interestshp C laarasLayauttamplata shp N mask area of interest ase BE Li 0 250 500 Meter Fig 4 2 Demarcation of planning area using area_of_interest shp for the dem onstration site Krampnitz os User s Guide Version 1 2 0 T Page 4 4 l M MT The breakdown of the planning area into planning units needs to be stored in an other shapefile in the demo project Leereslayouttemplate shp The polygons can be arranged in any way desired and can be displayed in any resolution e g they can be oriented towards infrastructure elements such as roads etc This breakdown forms the basis for generating the user s own use plans in the MMT Table 4 1 Input data demarcation of planning area File Format Needed Comments Area_of_interest shp Shapefile Polygon yes A polygon that demarcates the planning area Area_of_interest asc ESRI ASCII grid yes Cell values any rational number single precision within planning area No Data Value outside planning area Masked _ ESRI ASCII grid yes 1 outside planning area O within plan Area_of_interest shp ning area Leereslayouttempla Shapefile Polygon yes Needed for the user to generate use te shp plans Attribute table contains the fields use string category integer and area double where area alone has to contain valu
83. d within PRESTO using the OK button but are confirmed and saved in the project only when the user quits the main PRESTO form via the Save and Back button see section 9 2 The Close Window button quits the form without accepting parameter changes 9 5 Groundwater Geochemical Parameters input form A third input form asks for the geochemical conditions of the groundwater in and around the hotspot under consideration The concentrations of a few constituents are entered in the upper section of the form cf Fig 9 5 representative values from the lab analyses of groundwater samples If no values are available the user can for purposes of simplification draw on standard values choice between Aero bic conditions and Anaerobic conditions w Groundwater Geochemical Parameters Phosphate o mr are Te C Redox Potential ofthe jo 00 Temperature of the Groundwater C o C lj Close Window Fig 9 5 Groundwater Geochemical Parameters input form for characterising the groundwater When loaded the form already contains entries if either a PRESTO was loaded from the MMT with site data and a hotspot containing the requisite data was selected see above or b a data set was loaded in the main PRESTO form via the menu item Load file Otherwise the form is empty when loaded for the first time User s Guide Version 1 2 0 m E MMT Page 9 5 Changes are adop
84. ders 6 The land use type Large space business centre refers to land which is pre dominantly built on where there are few open spaces and generally a lot of public traffic It includes large scale retail trade facilities DIY and garden stores furniture stores and direct manufacturer outlet stores indoor lei sure parks fun pools and large wellness facilities as well as regional or na tional indoor sports facilities events and exhibition halls 7 Among the land use type Mono functional facilities are large public or pri vate training and research institutions e g campus universities or colleges large public or private health and rehabilitation institutions e g clinics with parkland as well as other large facilities with large open spaces e g hotel complexes with sports facilities Land use types without any building development do not require an allocation 6 2 2 4 Land use type as per the Federal Land Utilisation Ordi nance Use type BauNVO It is important and also makes sense to allocate the MMT land oosse types to one of the land use types defined by the German SEES Federal Land Utilisation Ordinance BauNVO when reference Small residential estate W S 5 l l Pure housing area WR land values are to be used which have been stored in the project Common residential areafwA Special residential er for each land use type as per BauNVO Village area MD Mixed use area Ml Centre zone ME Business park GE
85. die eingestellten Informationen und Daten sowie durch grundlegende Informationen zum Thema und weiterf hrenden Links die M glichkeit sich ein selbst ein Bild von den Rahmenbedingungen ihres Projekts und den Konsequenzen m glicher Nutzungsstrategien zu machen SMARTe DE bildet die Fragestellung in seiner ganzen Breite ab Es werden planerische konomische soziale und sozio konomische sowie Umweltaspekte behandelt Alle Informationen und Werkzeuge k nnen mit einem Webbrowser Microsoft Internet Explorer Mozilla Firefox etc abgerufen bzw verwendet werden Indem Sie diese Internet Plattform verwenden erkl ren Sie sich mit den Nutzungsbedingungen einverstanden and Research FR Federal Ministry AA of Education Fig 17 1 Web platform SMARTe work sections SMAR e a DE Nachhaltige Nutzung von Brachfl chen Nutzungsbedingungen Danksagungen Kontakt Suche Los Getting Started P PROJEKT LOGIN Site Description P Praga iD Future Land Use P SMARTe Tool Collection feedback Passwort Community Involvement P TE Environmental Management p Project Vision Ftnsibark Neues Projekt Hier anlegen Liability P Financial Analysis e Tools Checklists Anmelden Sources of Money y v Community Involvement Techniques Land Reuse Options MITWIRKENDE Project Schedule gt x Y Select a Consultant Potential Stakeholders ER INSTITUTIONEN Other gt The Vision to Action is currently Select a Lawyer ava
86. e Version 1 2 0 2 Design of the Megasite Management Tool suite The Megasite Management Toolsuite supports the development and holistic as sessment of land use options for large and complexly contaminated brownfields using a set of interlinked software modules These modules are linked with a geo graphic information system GIS and work with a common database The MMT represents a continuation of developmental work begun in 2006 with the joint research project SINBRA contributing additional methods and modules Potential users of the toolsuite include municipal authorities planners and inves tors Due to the involvement of experts from a variety of fields it is crucial to en sure that the information required is fed into the assessment in sufficient breadth and detail In general terms the assessment follows the steps outlined below Preparing data information Using the toolsuite requires setting up a GIS project which provides input data to use with the tools In terms of the amount and quality of data needed only a few minimum requirements apply Generally speaking the toolsuite can be used for very varied data Standards Generating land use ideas A few possible alternatives for reuse scenarios need to be developed first This should ideally be done in consultation with all those involved and Should take account of all the relevant boundary conditions e g existing infrastructure listed buildings types of l
87. e at the end of their name beginning with 0 So with 100 realisations e g TCE in gw0 asc TCE in gwl asc TCE in gw2 asc TCE in gw99 asc File Schadstoffe agd the line must contain the number of realisations as the second but last parameter The last parameter assigns the default realisation used in the case of a deterministic conflict analysis if so desired see also sec tion 4 3 5 TCE_in_gw aux TCE 5 GW 100 TCE_in_gwO m User s Guide Version 1 2 0 T Page 16 2 MMT 17 Presentation and post processing of the MMT results in SMARTe 17 1 Overview and structure of Internet platform SMARTe SMARTe Sustainable Management Approaches and Revitalization Tools elec tronic is an open source Internet platform for brownfields revitalisation gt http www smarte org SMARTe makes available information and tools which can all be accessed and used with a web browser Microsoft Internet Explorer Mozilla Firefox etc SMARTe covers the entire breadth of the issue of brownfields revitali sation Planning economic social and socio economic aspects as well as environ mental factors are addressed SMARTe originated in a collaborative effort between the U S Environmental Protec tion Agency EPA and the Federal Ministry for Education and Research BMBF which has been continued without interruption in the form of a bilateral working group for about the last 10 years The Interstate Technology and R
88. e blank assess ment sheets In this case the user cannot draw on any stored project data on contaminant sources and plumes If an MMT project has already been loaded PRESTO should be opened preferably via the second submenu item Include site data In this case the user has first to select the contaminant hotspot for which the technology screening is to be car ried out see Fig 9 1 The module then loads the data relevant to the plume concerned whereupon the main PRESTO form becomes visible Fig 9 2 If assessments of this hotspot have already been done they are restored in the input forms Otherwise the menus are empty and the user has to enter all the inputs first 7 aS _ User s Guide Version 1 2 0 PRESTO Chose the plume to evaluate 3 A 5 The following plumes were identified from the file Chose plume index Please chose a plume x Fig 9 1 Selection of contaminant hotspot to be addressed based on data stored in the MMT 9 2 Main PRESTO form In the main form it is possible to load previous assessments and save current ones via the menu item File load the three data sets for contaminants geology and geochemistry via the menu item Input form and view the assessment of remediation methods via the menu item Results REMEDIATION TECHNOLOGY PRESELECTION TOOL Files Data Input Results Preselection of Treatment Options ersion 1 1 PRESTO
89. e development is being considered A clear definition of the area to be examined helps those involved not to lose the thread and to have discus sions that are productive and efficient Participants are added by clicking on and deleted by clicking on 5 SAFIRA Il Sustainability Assessment 7 Modellstandort Krampnitz Pots Scenario SzenarioB Layout ScBLayout1 5 Define Indicators 6 Sustainable Development 7 Expected Development Reis Introduction 1 Define spatial context 2 Define local problem areas 3 Link to sustainability goals 4 Prioritize problems Definition of Spatial and Temporal Context Please insert the scope here Modellstandort Krampnitz Potsdam Sustainable Development What does it mean Which land use Please insert the names of participants who will assess the development within the reference Number of Participants 11 6 HFH o OA 7 JS Her Sch ck X 8 TZ Her Zill 9 Pm Herr Menger 10 PW Herr Weiller a lt lt Back Continue gt gt Fig 12 2 MMT Sustainability assessment Step 1 Definition of area to be exam ined and list of participating stakeholders Pm User s Guide Version 1 2 0 T Page 12 2 MMT In Step 2 the participants define the problems that in their view exist in the specific spatial context defined Fig 12 3 Problems are those issues and aspects of a site regarded by the actors involved as problematic e g groundwater contamina
90. e identification of contamimant sources and plumes Sources herde asc Plumes Fahnen asc Do you want bo change this File Nein Fig 10 4 Dialogues for displaying and changing the total pumping rate as well as for stored files for identifying contaminant hotspots and plumes The other buttons and Details each load another form that is divided into three tabs 1 MODELS Details Settings see Fig 10 5 ii INPUT DATA see Fig 10 6 and iii COST MAPS see Fig 10 7 which are explained in the following paragraphs The user can also access the corresponding tabs of this additional display via the menu items Settings Input data and Cost maps The Close window button takes the user out of the additional window and back to the remediation cost estimation form 10 2 1 Models Details Settings Here the user will find explanations pertaining to the individual cost estimation models and the settings which they can activate for each of the models There are specific input options for each model such as for unit costs or for classifying levels of contamination Under the tab Uncertainties uncertainty factors are determined according to the PROSIDE method Various selection lists enable the user to give their estimation of the reliability of site data and other data on the basis of which the uncertainty factors are determined and percentage discounts or sur
91. e optimisation process in diagram form Diagrams but ton see section 15 4 a User s Guide Version 1 2 0 T Page 15 2 E M MT mon m a D ai i vi Je DL a L s seda ee a LEE kl PU Spat gina of lend ne laut bared on ano genetic sipi ihren ri i ara 7 lees FN Znirial Bap der afl lei ration Powe Ln Im bergat ian on land wre Eyps e ares Sim rigi eee eee Ear i 20 PRCA os ss Gee ee ehk Click map der larger ikage a ee ee ee pier stony gelte 3 Coriri Land woe Ropers agen eben end thes reba emagi Re tAemidsbonoooti omme can ee Fr oot A pain oe bsn opile r fr T ae ne LES ae Eee ee juil ae ai Edi prassa He EPEAT ONLY Eppa ee ee bischen Ales ference of lord ute hes area 7 7 Fast Apply Fig 15 1 Optimisation module user interface 15 3 2 Available target function components Land use selec tion and relative weighting of optimisation targets 15 3 2 1 Selection of land use types to be considered The land use types to be considered in the optimisation can be defined by the user All the land use types present in the current layout are considered by default If the user deselects individual land use types they are exempted from the optimisation i e all those parcels of land that are allocated to these deselected land use types remain unaltered during the optimisation If land use types other than those used in the current scenario or new ones are to be included in
92. e percentage of land use may be 300 smaller or la if constraint is set to zero 0 0 then it is not to be evaluated landusemap lu_map 2 inputmaps ROC0100 ROCO288 ROC0388 ROC0488 ROC0588 ROC0688 ROC0O700 ROC0888 R MV600 MV700 MV300 MV900 Fig 15 2 Parameters set for the optimisation extract from the input file Overwrite existing optimization parameter 7 Really overwrite existing parameter files For optimization Previous settings get lost TF you want to keep existing setting create a new layout from existing one to conduct alternativce optimization runs Mo Fig 15 3 Question prompt after changing the optimisation parameters 15 3 4 Running the optimisation Once all the parameters have been set in the form and where necessary the pa rameters file has been modified manually all the inputs settings are saved using the Apply button Settings from previous optimisation runs are overwritten in the process after confirmation by the user upon a warning prompt Pm User s Guide Version 1 2 0 T Page 15 6 CI MMT The optimisation is launched using the RunOPT button For each optimisation run the input prompt opens in minimised form see task bar and closes automatically once the optimisation run is finished The optimisation lasts between one and several minutes The duration is dependent on the complexity dimensionality of the question entered and the settings made For example the
93. e property can be carried out in a Spatially differentiated way for the different planning units in the form Factor location quality and development stage Fig 11 2 A total correction factor for location quality is calculated on the basis of the value of these criteria point system from which in turn a factor for location quality is determined The assessment categories mentioned above can be seen in the left hand column of the form Clicking on the buttons brings up an explanatory help text The range of possible points for the categories used for assessing location quality extends from 1 very good to 6 unsatisfactory The development status is ex pressed as a percentage figure This figure is calculated on the basis of develop ment and preparation costs waiting times etc and goes up to 100 for land ready for development construction The assessment of the categories should be conducted separately for each land use To this end the form contains a column for each land use type Maps display the current status of the assessment The two menu items adopt for all categories and adopt for all land use types are accessed by right clicking on a map These can then be used to copy detailed inputs quickly by the row or by the line a User s Guide Version 1 2 0 T Page 11 2 E M MT T SAFIRA II MMT Factor location quality and development stage Gewerbe Gewerbe Renaturierung Ackerland Freizeit und
94. e with regard to its contribution to and compatibility with the goal of sustainable municipal urban development varies according to which kind of reuse is being proposed In many cases it will be sensible prior to any actual spatial planning to first con duct a basic assessment regarding what kind of reuse meets the objectives of sus tainable development and what kind is contrary to these objectives The outcome of this assessment can then serve as an input when specific reuse options are being considered and discussed In the context of the assessment both the specific features of a brownfield and its Surroundings as well as the impacts of various types of use are taken into consid eration Five priority goals are represented in the module by 23 characteristics which are used to assess the potential for sustainable development of various kinds of reuses of the land in the sense of the above definition The five priority objec tives are i sustainable land management ii conservation of nature and the land scape ill resource conserving and emissions reducing controls on mobility iv high quality residential environment and high quality of life and v strengthening of local economy Since the assessment is carried out at an early stage the large number of possible land use types has been typologised by combining land use types which use land in a comparable way and thus have similar impacts on the land and on its nearby sur ro
95. ee for land values 4 3 5 Data on contaminants The data on contaminants especially their spatial concentration distribution consti tute an essential input among others for the remediation costing process The distributions of contaminants are to be stored in the ESRI ASCII grid format It is recommended that an expert be consulted for the generation of the spatially con tinuous data Data generation may be based on interpolation of point measurement data or by means of simulations using a mathematical transport model Furthermore a text file must be generated that lists the existing contaminants the compartment concerned and the associated grid file cf Fig 4 3 The file name must be Schadstoffe agd The first line contains the number of contaminant files present the following lines each contain the file names the names of the contami Pm User s Guide Version 1 2 0 T Page 4 6 CI M MT nants or group of contaminants a key number for the contaminant type as well as the compartment soil groundwater E Schadstoffe agd C Projekt DATA GYIM1 Edit Tools Syntax Buffers Window Doxy Plugin Help PAK B aux PAK 3 Boden 3 TCE in gw aux TCE 5 GW PCE in gw aux PCE 5 GW Fig 4 3 Text file Schadstoffe agd 4 3 6 Information about site surroundings infrastructure etc optional The Megasite Management Toolsuite also visualises data that are not entered di rectly into the evaluation but
96. egulatory Coun cil ITRC in the USA supports the EPA in this project A German platform SMARTe DE is currently being developed based on the U S version of SMARTe This is being made available on a server at the University of Tubingen during the development phase and can be accessed via the following link http u 155 c181 zag uni tuebingen de smarte home index xml SMARTe is divided into a total of six work and information sections see homepage in Fig 17 1 1 Header area 2 Main menu 3 Links bar 4 Content area 5 User login 6 Sponsors A new tool Megasite Management Analysis has been developed to administer and process the MMT results data in SMARTe DE Starting from the SMARTe homepage the new tool can be accessed via the link Tools gt Megasite Management Analysis in the links bar at the top Fig 17 2 The homepage of the tool contains informa tion about MMT as well as instructions for using the tool in SMARTe 7 aS l User s Guide Version 1 2 0 SMA R Te DE Nachhaltige Nutzung von Brachfl chen Getting Started v dE i poi PROJEKT LOGIN rt XK 7 Site Description gt i ca Fi s 4 ts 3 Projekt ID Home Mind Map Tools Fallstudien Links Hilfe Tutorial PDF Future Land Use P SMARTe DE Z Feedback Passwort Community Involvement P Environmental Management Was bietet SMARTe DE Feedback Neues Projekt Hier anlegen Liability SMA
97. ell as child care centres and primary schools 3 The land use type Recreational area includes public open spaces whose catchment area is larger than the residential area itself This includes public parks and gardens outdoor areas for sports football pitches mini golf fa cilities half pipes as well as grounds where public celebrations town fairs etc are held 4 The land use type Trade and industry encompasses a broad spectrum of dif ferent private sector and public uses which extend beyond the immediate vi cinity in terms of the people who use them the functions they fulfil and their Spatial orientation This includes retail trade and services small mainte nance firms such as plumbers electricians etc small scale production facili ties administrations gastronomy and hotels as well as cultural social and sporting indoor events and activities a aS _ User s Guide Version 1 2 0 5 The types of land use associated with Pollution emitting industries and transport intensive commercial enterprise are characterised by the fact that they cannot be integrated straightforwardly i e without conflicts into small scale residential structures and a neighbourhood sensitive to emis sions and image This type includes large scale manufacturing companies production companies or facilities which emit strong smells or pollutants into the surrounding environment as well as logistics companies warehousing companies and wholesale tra
98. em Wohnungsmarkt Wohnungsbestand in Erhaltung des kulturellen Erbes der Stadt Anzahl denkmalgeschutzter Bauwerke a ee ke Wohnungsbestand in der 4 b Te 7 sat sat Stadtrand Gemeinden in qm und Ensembles Psychologische Probleme aufgrund von Arbeitslosigkeit nicht definiert set Unzureichende Gewerbefl chen f r wohnungsnahe Grundversorgung Wohnungsnahe Grundversorgung gt Extreme Armut als Folge von Arbeitslosigkeit und geringer Qualifizierung Geringe Qualifizierung von Arbeitskr ften Aus und Weiterbildung nicht definiert vet gt f lt lt Back Continue gt gt me Fig 12 9 MMT Sustainability assessment Step 6 Input of development trend re garded as sustainable for each indicator criterion Finally on the basis of the sustainability framework defined in Steps 1 to 6 the current land use scenario is evaluated in Step 7 The evaluation applies to the land use scenario that is currently selected shown in the form header User s Guide Version 1 2 0 Page 12 8 os EMMT An estimate must be made for each indicator of how it would develop if the sce nario in question were to be realised The trends falling staying the same and rising can again be selected SAFIRA II Sustainability Assessment Save Assessment Load Assessment Area Hodellstandort Krampnitz Potsdam Scenario SzenarioA Layo
99. ents Geo referenced topographical map 1 25K Geo referenced aerial photo Groundwater table isolines Groundwater observation wells with fields containing measured levels on certain test days Other geodata that can be visualised by UMN Mapserver os EMMT Part 2 How To Use the MMT 5 User interface and work environment 5 1 Basic information for use The user interface Fig 5 1 provides access to all the MMT functionalities The dif ferent MMT modules are launched via the menu bar Fig 5 1 point 1 The MMT tools are organised in different themes as follows File gt This is where prepared projects are loaded and where edited projects and assessments are stored or exported Word Excel and raw data tables Important settings for using the MMT are also adjusted here Preparation gt This is where the spatial input data prepared in the course of pro ject preparation can be looked at and the subsequent spatial planning of potential future site uses is initialised This occurs by evaluating the general potential for sustainable development relating to possible structural uses and determining those land use types that are to be considered Spatial planning gt This is where land use plans are devised interactively using a planning editor or where existing plans are amended Conflict analysis gt This is where any conflicts are identified which may exist be tween the environmental quality demanded by the currently sele
100. erything else loading reading the site scenario and layout data and possibly the inputs and out puts of the last assessment is done by the MMT 5 4 2 Navigation within the project 5 4 2 1 Selecting an existing land use scenario Clicking on the button Choose land use scenario in the main window see Fig 5 1 point 4 brings up the form Select land use scenarios which enables you to select one of the scenarios stored in the current project Fig 5 2 When changing from one scenario to another and confirming this change upon leav ing the form the data along with any previously conducted assessments of the newly selected scenario and its first layout are loaded into the programme m Future Utilization data input he following table displays all land use scenarios currently present in this project Please choose the scenario you wantto assess Details with respect to he land use types can be found in the main form in menu Preparation gt Land use types Share in in future intended use Use type and property SzenarioB SzenarioC SzenarioD Wohnen Gewerbe Gewerbe Mischgebiet Renaturierung Ackerland Forst Freizeit und Erholung Stadtpark Grunriegel Gruenpuffer Cancel Fig 5 2 Form for selecting one of the stored land use scenarios 5 4 2 2 Selecting the land use layout The button Enlarged image Choose layouts in the main window of the MMT in Fig 5 1 point 5 takes you to a detailed map
101. es for the shapes 4 3 4 Site specific information required The site specific information listed in Table 4 2 has to be available in the form of ESRI ASCII grids see Table 4 2 and the comments therein on the acquisition and or generation of these data In some cases where it doesn t appear to make sense to generate a Spatial distribution due to the data situation a constant value can be set instead of a spatially continuous distribution These global values are likewise stored in the form of maps Table 4 2 Site data required re subsurface geometry and properties Parameters Format Needed Comments Total site area Scalar quantity m yes Entry in Project ini Digital elevation model in ESRI ASCII grid yes The DEM can be obtained e g from the m NN regional surveying agencies More exact site models can be generated via interpolation from locally surveyed ground surface levels e g at investi gation wells Alternatively constant value Aquifer basis MUNN ESRI ASCII grid yes Can be generated by interpretation and interpolation of site investigation data e g exploratory drilling or outcrop data Geologist hydrogeologist needed Alternatively constant value Pressure level of ground ESRI ASCII grid yes See comments on Aquifer basis water m uGOK 7 aS User s Guide Version 1 2 0 Parameters Format Needed Comments Soil density Scalar quantity yes Entry in Project ini t m Hydraulic permeability ESRI
102. essment Save Assessment Load Assessment Area Modellstandort Krampnitz Potsdam Scenario SzenarioA Layout ScALayout1 Introduction 1 Define spatial context 2 Define local problem areas 3 Link to ee goals 4 Prioritize problems 5 Define indicators 6 Sustainable Development 7 Expected Development m Selection and definition of Indicators Problem Areas Goal Indicators that can be chosed What are indicators 1 Immisionen durch Hohes Verkehrsaufkommen in U L imbelastung durch Verkehr il _ der Innenstadt How indicators will be used within the Megasite DSS Luftverschmutzung il A How should indicators look like Arbeitslosigkeit und Qualifizierung 1 3 Schaffung von Arbeitspl tzen vf Ri j P h How to choose indicators for the description of problem areas Rn Arbeitslosigkeit il x Where can indicators be found Teoh ea Unzureichende Anzahl von Gewerbeflachen 25 Betriebsfl che il A Revitalisierung von Brachfl chen il 3 Eingeschranktes Angebot auf dem 12 Geb ude und Wohnungsbestand il A F s z Wohnungsmarkt de ele hg si ga ibs Wohnungsbestand in Stadtrand G il s on an integra previously to revitalizati Erhaltung des kulturellen Erbes der Stadt 33 Anzahl denkmalgesch tzter Bauw il i A able dev relopme ns Psychologische Probleme aufgrund von 1 1 nicht definiert il p F Arbeitslosigkeit Unzureichende Gewerbefl chen f r
103. etails of contaminant hot spots and plumes In all three areas detailed information is presented in tables that may also be viewed in an external programme via the Open LOG button 10 2 3 Cost maps Working with contaminated volumes the cost estimation models ROCO and PROSIDE calculate costs on the basis of the target value exceedance grids calcu lated by the conflict analysis module The calculation of remediation costs is like wise done first on a grid basis The results of this intermediate step are presented in map form in this tab Three cost maps are shown one for the soil remediation costs top left one for the groundwater remediation costs top right and one for the overall costs bottom left The result from one cost estimate model is shown in each of the maps at the top The selection lists above these maps enable the user to switch between the models The third map presents the sum of the model results currently selected above The costs in euros m are presented in the legend which is updated automatically The cursor functions in the lower right hand section of the form are equivalent to those described for the ILUM see section 7 2 1 and are explained succinctly when the cursor is held over the buttons for a short time wu User s Guide Version 1 2 0 T Page 10 6 l MMT MMT Remediation Cost Estimation MODELS Details Settings INPUT DATA 1 Soil remediation cost Roco 2 Groundwater
104. folder MMT Setup on the installation DVD The setup file has to be run to begin the installation gt double click A demo project data set can be found on the accompanying programme DVD in the folder SampleProject This data set needs to be copied onto the hard disk of the PC e g in C Write permission needs to be assigned to this folder and all subfolders Linking file name extensions to software programs In order to safeguard cer tain functions for several file types it needs to be defined in the operating sys tem which software program shall be automatically used to open the file This can be done e g in Windows Explorer 1 Right click on a file with the relevant ending e g in the folder DATA 2 Select Open or Open with 3 Select the programme from the list shown in the form that appears Place a tick against Always open file type using selected programme Table 3 1 Required links File name extension gt Programme 3 5 What if there are problems 1 Document the problem brief report in note form where necessary with screenshot 2 Report the problem Send report to support safira mmt de 3 If necessary phone for assistance Sebastian Schadler Tel 49 7071 2973 181 Max Morio Tel 49 7071 29 73178 Michael Finkel Tel 49 7071 2973177 7 aS _ User s Guide Version 1 2 0 4 Data input requirements and preparatory steps 4 1 Data and information need
105. g phase by using the results from a transparent ob jective and holistic assessment to highlight the benefits and consequences of possi ble options for future use or reuse Site Invest igation Software Toolsuite Guideline Data Information nee Acquisition A Data Information ei 2 Decision 2 nn er mation er X Li 17 KE i zumal 2 Decision AN Case by case continuous implementation of the revitalsiation plan remediation or re use of subareas Revitalisation Plan Fig 1 1 Schematic representation of the MMS and its core elements User s Guide Version 1 2 0 B m By MT Page 1 1 Three areas are addressed in the holistic assessment of site development options Costs of implementing the planned option in terms of clean up and site prepa ration Economic benefit market based evaluation of the site for the planned option Sustainability of the planned option within a pre defined setting and time hori zon Planning for site reuse requires a process of weighing up use value market value and sustainability index against the amount of investment needed for site reme diation and preparation measures The assessment supports this process The MMT is especially suited to evaluate brownfields on which there is significant soil and or groundwater contamination and whose size means that a certain degree of flexibility exists regarding potential land use strategies hence t
106. he main MMT window Once a project has been loaded the most important data and information relating to it are displayed in the main MMT window see Fig 5 1 The name and a descrip 7 aS User s Guide Version 1 2 0 MM Pages i tion of the site are displayed and where necessary edited within the frame Project data point 2 in the Fig Another frame summarises the site data on which the project is based 3 The button Details Modify lead to the Input data form where site data can be viewed in detail and may be changed by experienced users Alternatively the form can be accessed via Input Data in menu Preparation The frame Land use scenario displays the scenario data that is the proportions of land allocated to specific use types in the current scenario The frame Land use layout displays the layout i e the spatial distribution of land reuse that has been assessed or is yet to be assessed The frame Contaminants displays contaminants on the basis of the contaminant groups used in the module Contaminant groups that have been selected in the menu Contaminants target values see below are marked with an X SAFIRA II Megasite Management Toolsuite _ File Preparation Land use vision Conflict analysis Integrated Assessment Optimization Comparative assessment 7 Project data Hame Krampnitz Description Beispielszenaro fur der Standort Kaseme Krampnitz im Au
107. he old layout with its assessment results is deleted and re placed by the new layout which is immediately available for assessment using the MMT 7 2 3 2 Adding a new layout to the current scenario Instead of overwriting the current layout the user can save the changed layout as a new layout by choosing Cancel in the dialogue above Fig 7 3 The user is then asked to give a name for the new layout Fig 7 4 Pm User s Guide Version 1 2 0 T Page 7 4 E M MT Creating a new scenario Enter layout name fx Additionally enter a name for your layout Abbrechen Fig 7 4 Dialogue for naming a new layout After selecting OK a new layout folder is automatically created with the neces sary files and subfolders a corresponding entry is made in the project file Pro ject ini in the DATA folder and the new shapefile is loaded into the MMT once the ILUM has been closed 7 2 3 3 Adding a new scenario If the changed layout does not conform to the current scenario the system as sumes that a new scenario is to be created Accordingly the user is asked to give a name for this new scenario and once this has been given they are also asked to give a name for the layout to be created in the new scenario Fig 7 5 Creating a new scenario Please enter a name for your new scenario Additionally enter a name for your layout Abbrechen Fig 7 5 Dialogues for naming a new scenario above and a
108. he term megasite The aim of the integrative assessment is to enable the practical op tions resulting from this size and flexibility to be analysed and exploited to the full in line with the demands of sustainable municipal development 1 2 Land Use Scenarios and Layouts Basic ideas for site use that conform to existing regional and city municipal plan ning stipulations are defined as so called land use scenarios e g 35 residential area s 15 green spaces 50 commercial land These scenarios are translated into specific site use options so called land use plans or land use layouts that in clude a Spatial distribution of the intended types of land use and are then assessed see section 17 3 for an example of the outcome of a comparative assessment 1 3 Preparation The integrated assessment using the MMT is based on site data which have to be either available in digital form or made usable see section 4 as well as on other knowledge and information about the site Should any land use plans already exist these can be taken into consideration 1 4 The Manual The present manual provides an introduction to using the various tools available in the MMT The Description of methods integrated into the Megasite Management Toolsuite MMT see German language report of 31 12 2009 offers further infor mation about the underlying methods used m User s Guide Version 1 2 0 Ei Page 1 2 CI MMT F m T a User s Guid
109. ilable only through registering and Purchasing a Brownfield Property VA HELMHOLTZ logging in a Project V Finding an Insurance Broker ZENTRUM FUR v Do I need a permit UMWELTFORSCHUNG i UFZ Y Selecting a Developer v Understanding Units of Measurement ge a aes UNIVERSITAT Writing a Request for Proposals for TUBINGEN Environmental Site Assessment or Cleanup TED STay Y What are Quality Assurance Project 2 m Plans m 7 N 2 G q O Environmental Feedback Ya ce L prot Human Health Risk Calculator oe Federal Ministry Site Characterization of Education y and Resarch Monitoring Data Analysis Bereit 111115100 Megasite Management Analysis Econon X A Net Benefit Calculator is available through registering and logging in a Project Fig 17 2 Navigation within the SMARTe website to the Megasite Management Analysis tool F m User s Guide Version 1 2 0 T Page 17 2 t MMT 17 2 Data upload and project folders Zip files are used for exchanging data between MMT and SMARTe These contain text based CSV files and JPEG image files In CSV files text data and numerical data can be stored in tabular form The conversion and the packing of MMT results data into the ZIP files is done automatically within the MMT while the data are un zipped and saved into the work directory on the server automatically within SMARTe The input form Fig 17 3 below for the data upload of MMT results data is re
110. ing land use layouts and define new ones see section 7 Using an interactive manipulable land use map the consequences of new or changed layouts for the conflict analysis and the outcome of the holistic assessment can be calculated and visualised as a whole The ILUM thus enables the user to optimise the options manually The integrative evaluation of land uses depends on various criteria which in turn depend on a large number of parameters that may vary spatially e g contamina tion of soil and groundwater stage of development of the land adjacent uses land value market prices depending on use and location etc For this reason the search for optimum land use options can prove to be a complex problem that can not always be solved to optimum effect using a manual mode of optimisation In these cases the MOOL tool Multi Objective Optimisation of Land Re Use offers the MMT user the opportunity to conduct an automated optimisation Land use options that match the user s requirements are selected and evaluated automatically The use of a optimisation method based on Genetic Algorithms guarantees an efficient search for the best possible options MOOL builds on and extends existing pro gramme libraries for optimisation and spatial evaluation 15 2 Methods used by the tool MOOL Is essentially a control module for a spatially explicit optimisation algorithm It draws on a genetic algorithm Possible solutions to a problem i e the possi
111. inks 2 Tutorial TT MMT a a II File Management MEGASITE MANAGEMENT ScCLayout1 csv contains 150 variables Name Titel Team Team2 WN Bem Nutzungl MY PROJECT ANALYSIS WN FA1 WN COL1 Nutzung2 WN FA2 WN COL2 Nutzung3 WN FA3 WN COL3 8 Use this sidebar to add to edit Tr Nutzung4 WN FA4 WN COLA Nutzung5 WN FAS WN COL5 Nutzung6 WN FA6 or view your project specific EEE WN COL6 Nutzung7 WN FA7 WN COL7 Nutzung WN FA8 WN COL8 Nutzung9 WN FA9 WN COL9 WN Jpg BW UNITI BW UNIT3 BW Wertil BW Wert21 BW Wert31 BW Wert12 BW Wert22 BW Wert32 BW Wert13 BW Wert23 BW Wert33 BW Wert14 BW Wert24 BW Wert34 BW Wert15 BW Wert25 BW Wert35 BW Wert16 BW Wert26 BW Wert36 BW Wert17 BW Wert27 BW Wert37 BW Wert18 BW Wert28 BW Wert38 BW Wert19 BW Wert29 BW Wert39 BW Bua BW Kosten BW WertVi KONF UNITI KONF Wertli KONF Werti2 KONF Wert13 KONF Wert14 Add a document KONF Wert15 KONF Wert16 KONF Wert17 KONF Wert18 KONF Wert19 SEE KONF UNIT2 KONF Wert21 KONF Wert22 KONF Wert23 KONF Wert24 RR tad KONF Wert25 KONF Wert26 KONF Wert27 KONF Wert28 KONF Wert29 D anaia KONF_UNIT3 KONF Wert31 KONF Wert32 KONF Wert33 KONF Wert34 Sr pikas KONF Wert35 KONF Wert36 KONF Wert37 KONF Wert38 KONF Wert39 KONE Jpg1 ER ee KONF Jpg2 KONF Jpg3 KONF Jpg4 MBKSKBv MBKSAgv MBKSBk Or onti re goiza MB KS BskRem MB KS Gwsk MB KS GwskRem MB KS SumSk MB KS Grok Pe MB KS GrbkRem MB KS StrSv
112. ion If a system of indica tors already exists for monitoring local municipal sustainability this can be used as well 4 3 Description of input data for the MMT 4 3 1 Standard data formats in the MMT The MMT is based on common file standards As far as is possible information is stored in text based ASCII files For the spatial data the formats ESRI ASCII Grid grid based and ESRI Shapefile scale based are used Both formats can be read and written by a variety of geo graphic information systems The MMT requires that all input files are based on the same spatial extent and in the case of grid data use the same cell discretisation size of individual cells in the grid MS Office file formats such as Excel and Word are mainly used for exporting re sults Part of the input data for the sustainability evaluation is also stored in Excel It is assumed that Microsoft Office or at least MS Word and MS Excel are installed Additional more information rich site data which are not processed digitally in the evaluation are image formats such as BMP JPEG and TIFF georeferenced They are used for data visualisation only 4 3 2 Structure of directory data storage An MMT project deals with a particular site All site relevant data are stored in this project along with the land use plans we speak of scenarios and layouts and their accompanying evaluations The project data can be shifted on the computer as long as the project i
113. is against the sustainability value y axis for each data set The sustainability value is defined by sustainability value x red y amber 2z green where red number of indicators evaluated negatively sum of red lights amber number of indicators evaluated neutrally sum of amber lights green number of indicators evaluated positively sum of green lights 7 aS _ User s Guide Version 1 2 0 The weightings x y and z can be entered by the user via the input form see above 1 Negatively evaluated indicators bottom left gt For each data set the market value x axis is shown against the number of negatively evaluated problem fields so a high sustainability value in this diagram is evaluated negatively sustainability value red 2 Positively evaluated indicators bottom right gt As in the previous ca se although the number of positively evaluated problem fields per data set is added up sustainability value green 17 3 2 4 Taking account of the prioritisation made by participants in the sustainability assessment In the MMT each participant can attach a priority value to each problem see sec tion 12 2 This gives rise to a weighting of the individual problems The following values are generated for each problem from the priority values prio max highest priority value prio min lowest priority value prio mean mean of all priority values prio median median of all priority va
114. istic conflict analysis is run in the same way as the deterministic con flict analysis via the menu item Conflict analysis gt Start conflict analysis The computation time with the probabilistic conflict analysis increases according to the number of realisations being considered With the probabilistic conflict analysis several sets of results files are generated according to the number of realisations being considered Each set of results con sists of a grid file ESRI ASCII grid of the target value exceedance factor in relation to the layout specific target value a shapefile and a grid file with 1 0 values target value exceedance given not given and a graphic file JPEG of the area of conflict based on the above mentioned Shapefile with site data and the land use plan of the current layout as back ground The grid files ESRI ASCII grid of the exceedance factor from all the sets forms the basis for a further statistical examination of the areas of conflict and of the reme 7 aS _ User s Guide Version 1 2 0 MMT Pageib i diation needs On this basis the remediation costs can then be calculated with the corresponding level of uncertainty 16 3 Information regarding project preparation To apply a probabilistic conflict analysis the data structure must follow the following conventions Name convention for contaminant grid the realisations of the contaminant dis tribution must be numbered in sequenc
115. ixed sustainable development trend The three possible development trends are described using the words falling staying the same and rising Clicking on the corresponding arrows activates the trend indicated SAFIRA II Sustainability Assessment Save Assessment Load Assessment Scenario Szenario Layout ScALayout1 1 Define spatial context 2 Define local problem areas 3 Link to sustainability goals 5 Define Indicators 6 Sustainable Development 7 Expected Development Results sd Definition of Sustainable Development Problem Areas Area Hodellstandort Krampnitz Potsdam 4 Prioritize problems Sustainable evelopmen gt t gt Tt gt it gt t gt it it Indicator 1 Immisionen durch Hohes Yerkehrsaufkommen in der Innenstadt L rmbelastung durch Verkehr Step 6 Define Sustainable Development tarth i a een Luftverschmutzung Within this step you define the envisioned sustainable trend for each indicator Arbeitslosigkeit und Qualifizierung Schaffung von Arbeitspl tzen The definition ofthe indicator s trend follows the question How the c or has to develop in the future so that this mentis consistent with the respective sustainability goal Arbeitslosigkeit Unzureichende Anzahl von Gewerbeflachen Betriebsflache The goal of sustainable development designates the trend of indicators Revitalisierung von Brachfl chen Eingeschr nktes Angebot auf d
116. l Results Current layout raw data Cancel Start export Results for the existing current layout will be exported Please be patient for a moment The following files will be produced in your project folder SzenaroB45cBLayoutl doc SzenarnoB 5cBLayoutl 45cBLayoutl csv SzenaroB45cBLavoutl 45cBLayout zip Files are created during 15 to 25 seconds Please mind further MeSSaqes Fig 13 3 Information on the files created m Export of results Data selection W Result report Current layout MS WORD Vv Data export for DE SMART for the existing current layout Results All layouts MS Excel Results Current layout raw data ess Bose Results for the existing curent layout will be exported Please be patient for a moment The following files will be produced in your project folder SzenaroB45cBLayouti doc SzenarioB 5 cB Layout ScBLayoutl csv SzenarioB S cB Layout ScBLayoutl zip File export finished New selection Fig 13 4 Buttons shown upon completion of reporting exporting 13 2 2 Data exchange format The text based CSV format is used to transfer data from the MMT to DE SMARTe The CSV file created to upload the data to SMARTe DE contains links to various im age files land use maps and the results of the conflict analysis These image files are compressed along with the CSV file lt layout gt csv in an archive file lt lay out gt zip It is only this archive file that ha
117. le urban development They represent the three dimensions of ecological social Goal 2 PRESERVATION OF NATURE AND LANDSCAPE and economic sustainability and have been derived from an analysis of Goal 3 RESOURCE CONSERVING EMISSION REDUCING MOBILITY MANAGEMENT ileal ial ian sid ri LEERE EEA development are structured in a target framework comprising general goals Goal 4 HIGH QUALITY RESIDENTIAL ENVIRONMENT and the sub goals that substantiate them The assessment procedure aims to identify the potential of reuse of Goal 5 STRENGTHENING OF LOCAL ECONOMY brownfield sites for sustainable urban development t assumes that reuse requires construction Thus the assessment procedure should be applied only where no compelling obstacles prevent buildings on the site Indicators that rule out land use for buildings e g provisions of environmental law Bitte tragen Sie hier die Ihrer Bewertung zugrunde liegenden Annahmen und Erkl rungen ein pollution that cannot be remediated or topographical conditions are therefore not incorporated into the assessment The characteristics relate predominantly to small scale conditions such as transport connections adjacent land uses soil contamination or distance from Results services In order to obtain valid results for the assessment of the site Rank Deg of Suitability Land use type potential the procedure is therefore only to be applied for sites with to some 15 V Emi tting in dustry degree ho
118. le ROCO PROSIDE and KONUS These are complemented by a procedure developed by the authors EUGEN KS for estimating groundwater clean up costs Sustainability of use scenarios The sustainability module supports the process of developing sustainability criteria that are adapted to each given situation Development ideas and land use scenarios can be compared with one another in terms of their sustainability on the basis of these criteria Market oriented value For each land use scenario the market value of the brownfield under consideration is evaluated on the basis of reference land val ues taking account of the development status of the land and of reduced value for risks perceived in the market Visualising exporting results The results of the holistic assessment in respect of each of the reuse options considered are stored by the MMT and can be pre sented in a clear and easily accessible way The results can also be exported into SMARTe DE to be presented managed and further analysed A detailed re sults report can also be generated automatically All the MMT functions can be selected via a graphical user interface User s Guide Version 1 2 0 m Page 2 2 MMT 3 Installation instructions for Windows XP and XP PC in Windows 7 3 1 Requirements If the following points are heeded the user will be guaranteed trouble free use of the MMT Microsoft Windows 2000 or higher must be installed Microsoft Excel
119. lues These are contained in each data set generated by the MMT export function on this see also section 13 2 2 It is mean x 1 td n and a odd 2 median x K Xj X sorted X 4 x neven 2 3 3 The priority values related to the problems are recalculated according to the follow ing relation to indicator specific weighting factors m User s Guide Version 1 2 0 m Page 17 10 CI M MT priority value for associated problem weighting factor for indicator l total number of indicators of associated problem A separate figure is generated for each of the above listed priority values See e g Fig 17 9 In addition there is a further figure containing results when no prioriti sation is taken into account weighting factor for all indicators is identical 1 Each of the figures contains all the diagrams described above however the indica tor values of the sustainability assessment and the aggregated overall result differ Thus red gt weighting factor forindicator I negatively evaluated indicators I t amber gt weighting factor forindicator VW neutrally evaluated indicators I green gt weighting factor forindicatorI V positively evaluated indicators I Figure 4 1 Marktwert Nachhaltigkeits Plot mit Priorisierung Median Yertellung der Bewertungen Gesamtbewertung ga A So Layout ls Ti 2 ScAlayout Cao A ScBLayouti o F E So Lauti o
120. men in der Innenstadt L rmbelastung durch Verkehr Luftverschmutzung Arbeitslosigkeit und Qualifizierung Schaffung von Arbeitspl tzen Arbeitslosigkeit Unzureichende Anzahl von Gewerbefl chen Betriebsfl che Revitalisierung von Brachfl chen Eingeschr nktes Angebot auf dem Wohnungsmarkt Geb ude und Wohnungsbestand in der Stadt Potsdam Wohnungsbestand in Stadtrand Gemeinden in qm Erhaltung des kulturellen Erbes der Stadt Anzahl denkmalgeschiitzter Bauwerke und Ensembles Psychologische Probleme aufgrund von Arbeitslosigkeit Kein Indikator gew hlt C Unzureichende Gewerbefl chen f r wohnungsnahe Grundversorgung Wohnungsnahe Grundversorgung Extreme Armut als Folge von Arbeitslosigkeit und geringer Qualifizierung O 9 O 9 9 00 00 00 O 9 O 9 9 00 00 00 Kein Indikator gew hlt C Geringe Qualifizierung von Arbeitskr ften Aus und Weiterbildung Fig 17 8 contd Extract from the comparison chart using the example of data sets ScALayoutl ScBLayoutl ScCLayout1 17 3 2 3 Figures All the figures generated are structured in the same way and consist of four dia grams see Fig 17 7 1 Stacked bar chart Distribution of evaluations top left gt Each bar sums up the number of problems per data set that are evaluated negatively neutrally and positively or are not evaluated 2 Overall evaluation for plot top right gt The overall evaluation shows the market value x ax
121. mogeneous characteristics Very large sites do not lend themselves 25 ill Recreational area to a clear assessment using these criteria for example on a large site public 27 VI Large space business centre transport can be 100 yards or a mile away the soil can be heavily 33 VIL Monofunctional facility contaminated or hardly contaminated the deqree of sealing can be high or x 43 Residential area 52 IVY Trade and industry Fig 6 1 Graphical user interface of the module for assessing potential for sustain able development Each individual indicator has a Help button If this is clicked on a detailed de scription of the indicator including the priority goal and the lower level goal ap pears in the right hand part of the screen DE i User s Guide Version 1 2 0 T Page 6 2 b M MT Assessments are saved to the project automatically by leaving the form using the OK button However the results can be saved under any other file name and later reloaded at any time in other projects via the menu items Save project as and Load project which open up a file dialogue no Figure for the process of loading and saving Under the menu item Settings the values of the weighting factors for the individ ual indicators can be set manually Settings gt Enable manual weightings or else the default values can be re established 6 2 Definition of uses 6 2 1 Introduction Land reuse
122. n this basis if necessary Visualization of optimization s convergence and single criteria results x optweighted scores_1 csv optMViscores 1 C5v obj value RCst oe obj value RCst VV LA 500000 5 0 6 500000 504 a 02 a 4 00 0 1188111 81 EEE AH aE 18 1 11 LEE e 1 E 1 2 Jt ET 1 FI NI N N X NUN Ri Score normis th Kosten EUR Kosten EUR Generation Generation optCompactiscores_1 csv optSSi scores_1 csv not available obj value RCst m VV ho if Kosten EUR n 0 Wil ITLI NTT TTL NTT ET tT UST a et AEI Fs EE e ef LF NI N N N N N N Generation optCostiscores_1 csv obj value RCst oe 54 N 500000 Suote noraierl Kosten EUR ia IOMMI TT aeaeaei paaa f FH 1 F 4 Un id cally a amp Generation Fig 15 5 Presentation of optimization results as diagrams 15 5 Saving reusing the results of the optimisation The optimisation result can be analysed further using all the evaluation modules available in the MMT To do this the land use variant of interest needs to be se lected by clicking on the map display carried over into a new scenario layout by clicking on the Create new layout from selection button and saved in the project data set After quitting the optimisation module this new layout scenario can be selected for further evaluation see section 7 1 NAA JAKK User s Guide Version 1 2 0 T P
123. nennnnnnnnennnnnnnenn nn 3 6 Fig 4 1 Directory structure of an MMT project ueressesesnesenneeennnnenneennnenenne nenn nennen nennen 4 4 Fig 4 2 Demarcation of planning area using area of interest shp for the demonstration site FAWN I Zee ee een 4 4 Fig 4 3 Texte Schadstoffe 390 nennen naeanunenanuen 4 7 Fig 4 4 Example of presentation of information relevant to Planning ccccesceceeeeeeeeeeeees 4 7 Fig 5 1 SAFIRA II MMT user interface with initial information cccceceeseeeeeeeeeeeeeeeeenees 5 2 Fig 5 2 Form for selecting one of the stored land use scenarios usssssesnennenenenneenne nenne 5 3 Fig 5 3 View and selection of the land use layout uessessesnesnennennennnnennnnnnne nenne nnennen nenn 5 4 Fig 5 4 Form for changing programme settings cccccceceececeeeeeeseeeeeeeeeeseeeeeeeseeteeeeenees 5 4 Fig 6 1 Graphical user interface of the module for assessing potential for sustainable SY SOON AVA ee a ee ee Bee 6 2 Fig 6 2 Input form for defining land use types nrrrnrnnnennnnrennne annan anne nn na 6 4 Fig 7 1 User interface of Interactive Land Use Map module n nnennnnrnnnnn anna 7 2 Fig 7 2 Land use map with selected polygons ccccceesecseeeeeeeeeeeeeeeeeeeeeeeeeeeeeaeteseesetages 7 3 Fig 7 3 Dialogue after changing a layout in the Scenario requirements frame 7 4 Fig 7 4 Dialogue for naming a new layout
124. new layout below 7 2 3 4 Overwriting a scenario Overwriting a scenario means completely deleting the contents so far contained in the associated scenario folder This means that all the layouts of this scenario in put data and results are deleted An existing scenario should therefore be over written only when the user really is very sure that this is the right thing to do Overwriting is done by entering an existing scenario name in the dialogue described above Fig 7 5 A further dialogue Fig 7 6 asks the user to confirm once more the final deletion of the existing scenario by clicking on Ignore or to reject it with Retry which gives them another opportunity to enter a new scenario name B Er User s Guide Version 1 2 0 MMT Page 7 5 Folder already exists NewScenario Folder already exists amp vberlf amp Ignore to overwrite folder amp vberlf amp retry enables you to enter a new name for the scenario amp vOcrlF amp cancel returns to the map without sawing Retry Ignore Fig 7 6 Dialogue for confirming the deletion of an existing scenario 7 3 Creating a new layout As an alternative to overwriting an existing layout the ILUM module can also be used to create an entirely new layout Via the menu item Spatial planning gt Cre ate new layout the planning editor is loaded without the land use distribution of the current layout Note Alternatively by clicking on the b
125. nning unit In general reference land values RLYW or comparable selling prices of 50 properties can be obtained only for the development state ready for building Therefore these reference values need to be adjusted for the actual state of development As a rule thumb brownfield sites are usually in a shell or inprepared stage 4 factor between 0 and 101 Apply changes percent is used to assess the state of development in comparison to the reference land valu For a precise evaluation the correction factor for the actual state of development should include development costs 4 reduction in value to reflect the uncertainty of development Legend State of development factor land preparation costs a reduction in value to reflect the uncertainty of the development pla 0 20 gt 20 Cancel Fig 11 4 Input form for development status Example land use type Housing Pm User s Guide Version 1 2 0 T Page 11 4 E MMT 11 2 3 Estimating the market based deduction for risk The estimation of market based reduction for risk requires various user inputs on the characteristics of the property and with regard to the existing contamination Fig 11 5 The form contains three tabs Local Factor Informational Factor Time and Risk assing on Factor Brief explanations clarify which inputs are expected The impact of the inputs is displayed at all times via updated results in the right hand part of the
126. nternal folder structure remains the same gt relative paths are used The directory structure of a MMT project is shown in Fig 4 1 The folder lt pro ject gt DATA contains the project specific configuration file Project ini detailed description in Annex 1 In addition the demarcation of the planning area area of interest is stored as both a polygon and a grid file in this folder Other site specific data Subsurface geometry and properties distribution of contaminants are stored in the form of grid data see section 4 3 3 7 aS User s Guide Version 1 2 0 MM Page4 3 The data specific to scenarios land use plans and layout spatial arrangement of uses are stored within the project in folders bearing the names of the scenarios or in subfolders named after the layout Address CiProjekt Folders a Projekt E DATA Szenario ID info 7 ScALaywoukl Sc layoutz E SzenarioB 7 info DO ScBLayoutl C Szenarioc E SzenarioD gt info 7 ScDLawouti m EB ri ones Fig 4 1 Directory structure of an MMT project 4 3 3 Input data 4 3 3 1 Delineation of the planning area The demarcation of the planning area must be stored in a polygon file in the demo project area of interest shp see Fig 4 2 The demarcation is to be stored addi tionally as a grid On doing so a coherent cell discretisation and extent in relation to the other input data must be ensure
127. oject An input file typical for PRESTO is shown in Annex 4 7 aS _ User s Guide Version 1 2 0 MT Page9 7 m User s Guide Version 1 2 0 T gt Page 9 8 CI M MT 10 Costing module 10 1 Introduction The module for calculating remediation and site preparation costs contains various model approaches for estimating costs for the remediation of groundwater and soil contamination and for deconstruction demolition Four models are available 1 ROCO ROugh Cost The ROCO model is a purely empirical tool for estimating the costs of groundwater and soil remediation Contaminated volumes are multiplied by standard unit costs and by several empirical cost driving factors without consideration of specific remediation methods 2 PROSI DE The PROSIDE model is based on a slightly more complex approach in comparison to ROCO It can be used to estimate groundwater remediation costs The estimate Is based on the assumption that a pump and treat remediation is carried out The model integrates uncertainty of input parameters and calculates cost ranges 3 KONUS The KONUS model can be used to calculate the costs of any soil remediation meas ures required The approach is based on the KOSAL model 2 Depending on the contaminants and contaminant groups present on the site 11 different groups or classes are specified and on site conditions the suitability of 13 remediation meth ods is determined and the most inexpensive of
128. ond to mouse clicks one click on the map marks the position This brings up a display of the use type and the use type identification number 1D2 linked with it in the status bar on the lower edge of the window next to the geographical coordinates and the grid coordinates no of line and column of the map matrix of the position marked In addition the entry belonging to the current map is highlighted in grey in the file name list in the lower left hand corner of the form The Charts button opens another form in which the temporal development of the optimisation is illustrated For each optimisation run a diagram shows the develop 7 aS l User s Guide Version 1 2 0 ment of the main evaluation criteria values and objective function value gt syn onymous with the suitability of the solution examined Fig 15 5 The generations analysed appear on the X axis Each diagram shows the value score i of the objective function obj value ii of the remediation costs RCst iii of the market value MV and iv of the degree of suitability with respect to sustainable development Ssl for the best land use arrangement of a generation The diagrams provide information about the efficiency of the optimisation e g is a plateau reached that might be only a quasi optimum Is there an improvement towards the end of the optimisa tion Another more efficient optimisation run can be conducted o
129. onetheless necessary and desired in order for example to include consideration of new or different land use types a new project should be set up 7 aS User s Guide Version 1 2 0 6 2 2 Operating the module Choose the menu item Preparation gt Use types and properties to open the input form Fig 6 2 SAFIRA II MMT Definition von Landnutzungstypen Please define the land use types which your planning optionsn are going to be based on Please note that any changes in this form will affect your entire project including ALL use options and may render all previous assessments invalid Description please choose Weinen eraen e Freizeit und Erholung v Gue Iv ls l ls le le l l Land use type PSD Trade and industry v Use type BauN YO RLY 5 pecial area 50 X No assignment 55 X No assignment 25 v Ceme zme NK No assignment gt X Business park GE Risk Analysis Dil Edit Colour Use type BBodSchy 2 lIndusty Trade HI Et lIndusty Trade HI _ Edit No use with access HI Edit Playing ground hous ME _ Edit Recreation area SN Edit Recreation area MM Eit Grassland Greentiel J Ei M Cancel OK Fig 6 2 Input form for defining land use types 6 2 2 1 Designation Land use types are clearly designated within the pro ject The designation can be selected from a list of defi nitions provided Designati
130. ons may not be freely de fined by the user as this may lead to a lack of clarity Using a list of common designations also ensures con sistency and comparability between different MMT pro jects Description please choose Please select Wohnen Gewerbe Gemerbe Mischgebiet Renstunenung Ackerland F orst Freizeit und Erholung Stadtoark be The list of designations is saved in the file Landnutzungsbezeichnungen LUT in the project sub folder DATA and can contain as many entries as one likes Table 6 1 gives an example Table 6 1 Contents of file Landnutzungsbezeichnungen LUT Example Nutzungsliste n entries 13 entry 1 Wohnen entry 2 Exklusives Wohnen entry 3 Gewerbe entry 4 Gewerbe Mischgebiet entry 5 Renaturierung entry 6 Ackerland entry Forst entry 8 Ackerland oder Forst entry 9 Freizeit und Erholung entry 10 Stadtpark entry 11 Gr nriegel User s Guide Version 1 2 0 Page 6 4 on EMMT entry 12 entry 13 Quartiersplatz s onstige 6 2 2 2 Explanatory comments In addition to the designation of land use types TE other features of a specific land use type can be ur malm noted in an explanatory comment Click on next Bitte geben Sie hier erl uternde Kommentare zum Landnutzungstyp ein to the designation to open the input form By click ing on the OK bu
131. option lt Additionally perform single criterion optimization no ticeably lengthens the time taken by the calculation process Generally speaking the time required for the calculation increases along with the number of use types to be considered and with the number of planning units The composition of the objective function is also a factor 15 4 Visualisation of the results Once the optimisation has been completed the new layout plans generated are automatically displayed in the results frame of the form cf Fig 15 4 Optimization results Quasi Optimum weighted cost optimized market val optmized Sustainability optimizec and compactness optimized San kosten 131220 00 San kosten 0 00 San kosten 369360 00 lblOptResultsFooter San kosten 247050 00 Marktwert 265900 00 Marktwert 479700 00 Marktwert 230900 00 Marktwert 276400 00 Nachh Grad 0 00 Nachh Grad 0 00 Nachh Grad 0 00 Nachh Grad 0 00 Opt Karten Create new layout from selection E Chats Row Col LU Fig 15 4 Presentation of results map and accompanying criteria Each of the maps shows the spatial distribution of use types on the site for the best individual from the last generation examined using the genetic algorithm as part of the optimisation process Beneath the maps are the calculations for total remedia tion costs market value and the degree of suitability with respect to sustainable development The map images resp
132. options are defined by the spatial arrangement of different land use types on the site under consideration The land use types may differ in terms of several features that are relevant to the assessment Because of this complete assessment of a site use layout requires a complete definition of these features for each land use type used The following aspects are part of a complete description of land use types in the MMT Designation Explanatory comments Land use type acc to assessment of potential for sustainable development Land use type as per BauNVO German Federal Land Utilisation Ordinance Reference land value Land use type as per BBodSchV German Federal Soil Protection Ordinance 2 Colour for displaying on maps Parameters for the risk assessment These aspects are described in greater detail in the following sections A reuse scenario along with its accompanying layouts can be composed of up to nine different and freely selectable land use types The types of land use introduced and stipulated in the relevant regulations need to be allocated to these land use types where possible IMPORTANT INFORMATION The definition of land use types should be done early on as part of the preparatory work i e as soon as an MMT project is set up and should not be changed again in the course of working on the project Later changes in the definition will inevitably lead to inconsistencies in the project If changes are n
133. precisely one sustainability objective only If it turns out that a problem fits with more than one sustainability objective and needs to be matched to several of them the problematic aspect in guestion needs to be defined as a new problem in Step 2 Previously matched problems are therefore highlighted in colour pink Fig 12 5 ZH User s Guide Version 1 2 0 Ar Page 12 4 ja MMT Problem Areas 1 Immisionen durch Hohes Y erkehrsautkommen in der Innenstadt Iw Link to 4 goal and back to 2 Arbeitslosigkeit und Qualifizierung jE main menu 3 Unzureichende Anzahl von Gewerbefl chen ie 4 Eingeschranktes Angebot auf den Wohnungsmarkt E 5 Erhaltung des kulturellen Erbes der Stadt in 6 Peychologieche Probleme aufgrund von Arbeitslosigkeit r T Unzureichende Gewerbefl chen f r wohnungsnahe Grundversorgung E 8 Extreme Armut ale Folge von Arbeitslosigkeit und geringer Qualifizierung i Fig 12 5 MMT Sustainability assessment Step 3 2 Form for the actual matching In Step 4 the problems are prioritised Fig 12 6 The prioritisation serves to make clear the preferences of the participating actors for different issues Each partici pant evaluates the problems for themselves Each participant has a certain maxi mum number of points at their disposal which can be allocated The maximum number is derived from the number of problems n and the maximum number of points to be allocated per problem 5 points 0 5 n 5 SAFIR
134. project folder 11 The visualisation is done using MapServer The features displayed on the JPEGs are dependent on the geodata defined in the files DATA HEADER map and DATA TAIL map for example topographical maps infrastructure etc 12 ROCO was developed in the EU project WELCOME and is based on Bonnen berg H Grunewald V Milde G Seiffe E Spittank H amp Wassermann W 1992 Altlast Schatzung ein Arbeitsinstrument zur komplexen Bewertung ostdeutscher Verdachtsstandorte und zur Prognose des Altlasten Gesamtrisikos Abfall wirtschafts ournal 4 1 908 917 7 aS User s Guide Version 1 2 0 MM y 13 PROSIDE cost prediction published as part of the EU research project PROSIDE www proside info available from Sachverst ndigenb ro Dr Thomas Ertel thomas sv ertel de 14 UBA Umweltbundesamt 2003 Fachinstrumente Flachenrecycling Kos tenermittlung f r Fl chenaufbereitung KONUS German Federal Environmental Agency 30 03 Berlin 15 UBA Umweltbundesamt 1995 Entwicklung einer Systematik zur Kosten ermittlung bei der Altlastensanierung KOSAL German Federal Environmental Agency 20 95 Berlin 16 EUGEN KS was developed within the SINBRA project in the BMBF priority REFINA as part of the planning and decision aid EUGEN 17 Values from LUA NRW 2005 Materialien zur Altlastensanierung und zum Bodenschutz Band 20 Leistungsbuch Altlasten und Fl chenentwicklung 2004 2005 Landesumwel
135. r s Guide Version 1 2 0 Mm OO ren gle criterion A comparison of the optimisation results thus obtained enables con clusions to be drawn retrospectively on the importance of individual evaluation cri teria 15 3 3 2 Editing the parameters file The parameters file for the optimisation can be edited manually Clicking on the Edit parameters file button opens the file using the standard editor Fig 15 2 The individual parameters are explained in Annex 7 After saving the file in the edi tor the user must confirm that the values have been accepted A corresponding question prompt appears after the editor has been closed cf Fig 15 3 gt pMut 8 8 pRepl 1 8 75 nGen 58 8 5 pConv 88 nConv 8 alleleset_area 108 2 alleleset line area change except line change except line edge except AREA IDMAP id area arealD cat 108 400 neighbourhood 4 min area 10 LINE IDMAP id area lineID cat 2 linelD except gt min length 8 weightings 0 0 0 0 8 8 8 8 0 0 8 8 8 8 0 0 8 8 8 454545454545455 8 08 8 0 8 8 5 wheights CA ED LPI COH EdS TEd ShI LSI MSI FrD PR nP RCst MV Ss constraints 61 1 8 1 0 1 0 1 8 14 1 0 1 0 14 1 9 2 0 1 6 1 0 8 6 0 6 0 constraintsnames A ED LPI COH EdS TEd ShI LSI MSL FrD PR nP Rist a7 ca8 ca9 Ist constraint gives the maximum percentage that classes are allowed to differ if constraint is e g 3 0 th
136. r depreciation factors e g for perceived uncertainties are taken into account in the form of a market based mercantile value reduction for risk 11 2 Using the module The input form is loaded via the menu item Integrated assessment gt Market value SAFIRA II MMT Market value assessment Assessment of market value Assessment of Mercantile Value Reduction Result of value assessment 57 227 100 soil land value excluding encumbrances and public charges E Costs for site clearing development and risk of implementation Using this module you can assess the market value of the site taking the current use layout into account This assessment does not replace a valuation report the estimation of market value depends however on the accepted comparison approach based on reference land values RLY and adjusted for value diminutions due to the remediation cost estimates and a mercantile value reduction MYR to 47 699 348 include market perceived uncertainties On the left you find an overview of the curent evaluation The module is divided into two worksheets In this worksheet the initial assessment is based on the assumption that the site is clean i e as if uncontaminated Each type of use must be evaluated separately by sub areas before an overall consideration of MYR can take place ia inthe second worksheet 10 689 923 preliminary soil land value E O Costs for site clearing and For the initial assessment scen
137. re not considered Left Overview of all Peg E EE E A T T E ee are are ne rer 17 6 Fig 17 8 Extract from comparison chart using the example of data sets ScALayoutl SCBLAVOULL SCL LAYOUT seen euer aaa 17 8 Fig 17 9 Diagrams generated for the data sets of land use layouts ScAlayoutl ScBLayout1 ScCLayoutl demo data set with sustainability assessment results weighted by the median of oi OO ee ee 17 11 ae ar User s Guide Version 1 2 Page xvi E MMT List of Tables Table 3 1 Required links File name extension gt Programme zessesssensnnnnnnnnnnnnnnnnnnnn nenn 3 7 Table 4 1 Input data demarcation of planning area sssssseenenennnnnnnnnnn nennen nennen nennen nenn 4 5 Table 4 2 Site data required re subsurface geometry and properties ccccceceeeeeeeeeeeees 4 5 Table 4 3 Further parameters required values to be entered in the MMT 4 6 Table 4 4 Optional site data example demo project data nnrnnnenennnne nne 4 8 Table 6 1 Contents of file Landnutzungsbezeichnungen LUT Example nne 6 4 Table 15 1 Units of the optimisation criteria nnanseseneneeeneeennnnenenennnnnnne nennen 15 4 Table 15 2 Pseudo code of target function calculation errereen 15 5 any MT User s Guide Version 1 2 0 m id Page xvii n User s Guide Version 1 2 0 Ra Page xviii E M MT Teil 1 Introduction Installation and Preparation 1 SAFI RA Il Megasite
138. rges scores less than 3 to lower ones Mercantile Value Reduction MYR 22 4 Local Factor 2 The specific area of supposed contamination cannot be traced easiely Tre Ma 0 30 Risk Passing on Factor w ol ie The area of supposed contamination is relatively large more than 15 percent of valuation site oe e Groundwater contamination is confirmed or very likely nen The impression is that the property is cluttered waste pits 377 677 MVP absolute ON Visible safety measures are implemented on site security fences barriers oO Public authorities stated clear clean up demands 4 504 211 Market value of site The site is recorded in an official register of suspected contaminated sites I co A A 3 Y A legally binding contract on remediation is in action between owner and responsibly authority Ollie The site brownfield has not been used for more than 5 years The site is adjacent to a residentially used area The supposed contamination spot is situated at the edge of the site but still within it Oi Media reports often on the sits s contamination issues and risks TE CA e o v eo e o C e amp e o v e LE 0 S o e o AIK AN 3 e A 3 There are public debates on the site s developement Fig 11 5 User interface of the market valuation module Estimation of market based depreciation 11 3 Other info
139. rmation The module reads the scenario data for the current layout the RLV allocated to the land use types a shapefile with the spatial distribution of location qualities and de velopment status and the result of the remediation cost analysis from the project folder If a market valuation has already been conducted for the current layout this is loaded when the module is opened The module writes a file with the extension we into the layout folder of the cur rent layout This contains the settings and results for the current assessment AI aS User s Guide Version 1 2 0 MMT Page 11 5 m User s Guide Version 1 2 0 T gt Page 11 6 CI M MT 12 Sustainability assessment 12 1 Introduction The module for assessing the sustainability of land use options offers the opportu nity to compare various development scenarios with one another in terms of their sustainability The assessment benchmark for sustainable development is defined by working out stepwise and in a participatory way a set of criteria for sustain able development It is based on a holistic idea of sustainability that includes eco nomic social and ecological aspects With the help of these criteria potential land use options for the land to be revitalised can be assessed with regard to their sus tainability Following this methodology which is based on an integrative sustain ability concept developed by the Helmholtz Association of German Research Cen
140. rmation by means of GIS To do this it is as sumed that the person concerned has at least a sound basic knowledge of vector and grid based geo data processing If site information is available in analogue form only it needs to be digitalised in a suitable way or else the digital form needs to be converted into the data format required by the MMT If no data e g relating to the pollution inventory are available contaminant distri butions can also be estimated roughly on the basis say of information from a his torical survey of areas suspected of being contaminated or from other site investi gations It should be borne in mind that uncertainties associated with assumptions and approximations in the input data will have an impact on the reliability of the assessment results that will be obtained using the MMT The time required for data preparation can be anything between a few days and a few weeks not including any necessary work on site such as surveys establishing contaminant concentrations and similar tasks The module market oriented valuation requires the input of various data concern ing the state of the land e g location characteristics level of land development This includes in particular land use specific reference land values RLV for the planning units If no reference values are available for the site RLV for the sur rounding plots of land may be used instead RLV can be obtained through expert committees
141. rrent layout in the menu Spa tial planning to open the selection form as an alternative to the corresponding button in the main window see section 5 2 7 2 Edit current layout The drafting or editing of site reuse options is done using the programme module ILUM Interactive Land Use Map ILUM is based on the functions of the free geo graphical information system GIS MapWindow http mapwindow org and is used to view and modify the attributes of the shapefile polygon file with use and planning units for the layout The module is loaded via the menu item Spatial planning gt Edit current layout The menu item can only be selected once an MMT project has been loaded 7 2 1 ILUM user interface When the ILUM is opened the current layout of the MMT project that has been loaded is displayed and is available for modification The graphical user interface shows the planning units polygons of the layout shapefile in the middle of the window and its table of attributes on the right hand side Four different tools can be selected in the upper left hand part of the form Select ing the tool affects subsequent mouse clicks within the map The following tools are available the Selection tool is activated as standard 2 Enlarge Show total map E a Reduce The Selection tool is activated as EA Move standard EN Selection In the lower part of the window Allocation Statistics frame the site reuse sta
142. rung Ackerland Forst Freizeit und Erholung Stadtpark Grunriegel wo 215151 1122151 aj aleolklelelo Sl l olal a a on Gruenpuffer Show Modify Fig 11 1 User interface for the market valuation module Estimation of market value aS User s Guide Version 1 2 0 MT Pageii i 11 2 1 Work sections The module s two work sections Assessment of market value and Assessment of Mercantile Value Reduction are selected via the corresponding tabs on the left hand side of the form Fig 11 1 For the estimation of market value the scenario data land use ratios and the reference land values RLV for individual land use types are taken over from the project The user must also say how they rate the location quality and development status construction readiness of land for the individual uses The Show Modify button opens the form Factor location quality and devel opment stage see section 11 2 2 The right hand side of the form shows the results of this assessment the result of the remediation cost calculation and as an overall result the expected market value of the current land use layout 11 2 2 Determination of property location quality and devel opment status Four criteria or categories are important for determining location quality the general macro location micro location distances and property features Assess ments of these categories and of the development status of th
143. s The following input data and information are indispensable delineation of the planning area polygon data for demarcating the planning area from its surroundings division of the planning area into planning units structuring the area into indi vidual parcels to be differentiated according to their types of use information on pollution inventory estimation of requisite site preparation and remediation and of the costs thus incurred is carried out on the basis of the spa tial distribution of pollutant concentrations in soil and groundwater information data on the geometry and properties of the subsurface this in cludes spatially continuous data on a site altitude in metres above sea level b distance between groundwater table and ground surface and depth to the aquifer base and c the hydraulic permeability of the aquifer and information on the developmental state of the land as well as site and use related reference land values for estimating the market value of the site Further information which may optionally be taken into consideration are data on existing buildings data on existing infrastructure and similar planning related data within the planning area and its surroundings sustainability indicators if indicators already exist for the municipality in which the site concerned is located they can be incorporated into the MMT in the form of an Excel spreadsheet If there are no such indicators
144. s maintained roads instead of a cart track safe rather than the lack of supply of electricity and means of communication 0 A A ean a an a i A A AA ee 070 a NIND Ww i M Legend Categories 1 through 4 m excellent 1 average 3 E poor 5 E good 2 EI acceptably 4 m insufficient 6 Cancel Fig 11 3 Input help for location quality assessment Example Category Dis tances for land use type Housing Assessment of development status A spatial differentiation is done analogously for assessing state of development Double clicking on a map takes the user to the input form see Fig 11 4 Explana tions and information relevant to the assessment of the development status can be entered and displayed in the lower right hand part of the form Spatial specification of site s location quality and state of development Map tools MAKRO2 MIKRO2 DIST2 GM2 LQ2 a A YK A Deselect all oo i m el ee el and to the land use type Gewerbe 23 03 0 03 J to 3 WWW www Www Ww 03 03 03 03 Www ww ww Oo 3 LJ WW 03 03 03 Www www QJ LJ LJ LJ J J J 03 Ww Www www we mb EET mt mt mt E E ee EE ee Er A a ai a Set new value by entering it here or by i clicking in the legend To assess the state of development you need to assess the level of the site s preparedness for normal construction building The evaluation of this category is to be done for each pla
145. s means that the weighted if applicable number of indicators the value of which is expected to follow a V Data ratings is the most sustainable one Axis position Qutside at origin Update plot Fig 14 1 Form used for a comparative assessment of different land use options The right hand section of the form contains two more input frames In the upper frame Consideration of target factors the user can decide whether and if so how the priority factors chosen by those participating in the sustainability assessment process should feed into the calculation of the sustainability result Here the user makes a selection from the five options listed above Once a choice has been made explanatory comments on the kind of consideration chosen are displayed in the text window below To display this User s Guide Version 1 2 0 Page 14 2 on EMMT selection in the diagram as well as to display a change in the use options se lected click on the Update plot button In the lower frame Aggregation of results from sustainability assessment the user selects how the assessment results from the different sustainability indica tors are to be taken into account when forming the overall result One of the three methods listed above can be chosen The method chosen is explained in greater detail in the comment window underneath If the third method is se lected Total Evaluation a further input field is
146. s to be loaded into SMARTe DE later on This is explained further in section 17 2 7 aS User s Guide Version 1 2 0 13 2 3 Results report The new reporting function enables the assessment results to be presented in a standardised form as a results report in MS WORD format doc The report in cludes the principal assessment results along with some key background informa tion about the cost estimation procedures used and the inputs for the market based mercantile value reduction for risk Annex 6 shows the report produced for one land use option for the model site of Krampnitz m User s Guide Version 1 2 0 T Page 13 4 CI M MT 14 Comparative assessment 14 1 Introduction The MMT offers the possibility of making a comparative assessment of several land use options for the site The assessment results for the individual sustainability in dicators are aggregated for this purpose The user can choose from among various simple aggregation methods and where appropriate take account of the priorities set by the stakeholders in the assessment process The following aggregation methods have been implemented Number of positive assessments green traffic lights Number of negative assessments red traffic lights Overall assessment using user defined factors of importance numerical values between 5 and 5 for positive neutral and negative assessments The prioritisations made by the participants in the as
147. seccetoonttented E E E E versa mec satt 6 3 6 2 2 Operating the module n nnrvennnnennnn annae nn annan enne nan n nan nn nan 6 4 7 Spatial BIAMMIMG a aaa 7 1 7 1 SEISCLCUFTENE 5 7070120 scan se ee nee see ee 7 1 7 2 GE CUP FENG Way OU ee a a A a ee 7 1 1 21 IEUMUSTT ea la 7 1 7 2 2 Modifying aay uuema aaa a uu M 7 2 7 2 3 Saving cancelling ModiNcall nsaunses en ea 7 4 7 3 creating anew Fa VOUT ee A 7 6 8 Conflict analysis can naar aasa 8 1 8 1 Basie IMONMaAl ON een ee eat estate 8 1 8 2 Selection of relevant contaminants compartments sssesesnennnennnnnnn nn nennen nennen 8 2 8 3 Use of concentration standards use related remediation target values 8 2 8 4 Parameters for the risk assessment een 8 3 8 5 Conducting aconflict analysis een 8 3 8 5 1 Target value related conflict ANALYSIS cccecceceeseceeeeeeeeeeeeeeeeeeeaeteeeeeeaetess 8 3 8 5 2 Risk based conflict analySiS ssesesensnsnrrererersrrrrrrnrerererrrrnrnrrrererererrrrererero 8 4 8 6 ROSU ee ee ee 8 5 8 6 1 Target value related conflict ANALYSIS cccecceceeseceeeeeeeeeeeeeeeeeeeeeeaeteteeeeraetess 8 5 8 6 2 Risk based conflict ANALYSIS ccecceceececeeeeeeeceeeeeeeeeeeeeeeeeaeeeeeeseteeeeeeseteraetess 8 6 9 Identifying suitable remediation technologies nnenenenenans 9 1 9 1 ADDIYNG Me OOl ee een 9 1 9 2 Malt PRESTO TOIMI aa aaa ee nee een 9 2 nr User s Guide Version 1 2 0 E M
148. sed and of the optimisation module s programme and data structure can be found in Morio et al 2010 15 3 Using the tool 15 3 1 Work sections To access MOOL within the MMT click on the menu item Optimization gt Start land use layout optimization The optimisation module can be opened only once a land use scenario and an accompanying layout have been defined The graphical user interface for controlling the optimisation process is organised in a single form Fig 15 1 The form is divided into four frames cf Fig 15 1 1 Information on the current scenario layout This is where the layout map clicking on a map opens an enlarged view and the percentage shares of land of the land use types are displayed 2 Components of the target function and its relative weighting This is where the relevant settings for the optimisation of the land use patterns are adjusted see section 15 3 2 2 3 Optimisation settings This is where further settings can be adjusted in addition to the multi criteria evaluation according to the set weightings a separate optimisation run can be conducted for each individual criterion Ex perienced users familiar with optimisation methods may modify further set tings by directly accessing the parameters file of the optimisation pro gramme 4 The optimisation run is also launched from this form frame 5 Optimisation results Presentation of optimisation results in map form and presentation of th
149. seeeeeeseeeaeeeeeeaeeeeeeneanes 4 2 4 3 Description of input data for the MMT nnrnrnnnnrnvnnnn annan navn annan annan 4 3 4 3 1 Standard data formats in the MMT mmrme nne nnr nunnu nunnana nan nn manna 4 3 4 3 2 Struct reor alreelory data Storage van 4 3 43 3 DE ae ee ee ae een 4 4 4 3 4 Site specific information required uesesesssnseennnnnnnnnnnnnnnnnnnnnnnn nn nennen nennen nenn 4 5 235 Data OM Conlainane sci maana kinaasi ajama kalana loa lis aces 4 6 4 3 6 Information about site surroundings infrastructure etc optional 4 7 nr User s Guide Version 1 2 0 E M M T sers Guide ld ae 4 H Page vi Part 2 How To Use the MMT 5 User interface and work environment uuuuuu000unn0nnnnnnnnnnnnnnnnnnnnn nun 5 1 5 1 Basic MAMM TON OSC ate ernten 5 1 5 2 Pie Wai MMT WNION Aa ea O 5 1 5 3 Setting UNS NEW DREO EC MADARA m 5 3 5 4 Editing existing BIO EC ernannten 5 3 5 4 1 Loading the project ussssesnerennenennenennnennnennnennnenennennnnennnnennnenennennnennnnen 5 3 5 4 2 Navigation within the project een 5 3 5 5 440701 IN SELL OS ea nee 5 4 6 PRION ALI On 6 1 6 1 Assessing the general potential for sustainable development mnn 6 1 6 1 1 The assessment procedure ccceececseceeeeceeeeceeeeeeeeeeeeaeeseeeeeeaeeeeaeeeeeaetaesetegs 6 1 0 1 2 Operating che MOdUlE escrian N 6 2 6 2 VST ICON OT WS OS ery ate E een 6 3 0 21 IAOU CUO sestcicrce
150. sessment can additionally be used in various ways as weighting factors for each of the three assessments Without taking account of the prioritisation Minimal value Mean value Median value Maximum value This means that in total there are 15 different ways of combining the results of the sustainability assessment into an overall result in the form of a numerical value The monetary and non monetary results are then presented in an x y diagram 2 14 2 Using the form To access the form for the comparative assessment of land use options click on the menu item Comparative assessment gt Start comparative assessment or press Alt B The main part of the form consists of the diagram area which displays the results of all the available layouts when the form is opened for the first time from the MMT Below the diagram area a list appears of all the land use layouts worked on in the project Here the user can select the layouts to be displayed in the diagram After one or more land use options have been selected and then confirmed using the button Update plot the results are displayed in the diagram cf Fig 14 1 The module scales the diagram axes automatically to the range required to properly display the results of the selected layouts y Er _ User s Guide Version 1 2 0 Mer SS 99000 To the left of the layout list in the frame View settings the presentation in the diagram can be adjusted The
151. sessments are removed in order to avoid combining information from different assessments 3 Scenario dependent target values are loaded 4 Grid files of the spatial target value distribution for all the contami nant compartment pairings to be considered are generated Fig 8 3 5 The spatial distribution of target value exceedances exceedance factor is calculated and corresponding grid files are generated 7 aS User s Guide Version 1 2 0 MM Pege 3 6 Image files format JPEG of the target value exceedances for taminant are generated each con Once the conflict analysis is completed the console must be exited by entering the word Exit Fig 8 4 After this the results of the conflict analysis are available in Integrated assessment gt Results see section 8 6 1 and the rest of the assess ment steps can be conducted using the MMT Anzahl Kontaminanten CB und GW 4 ol Beruecksichtigte Schadstoffe L FAK3B_B aux PAHG6A B aux PGE in gu aux TGE in guw aux J Einstellungen bzgl Konfliktanalyse unveraendert Skip Erzeugung neues Layout Raster Layout shapefile mit Zielwerten SzenarioAschLayout1 amp cALayouti1_tyl shp Zielwertraster abgelegt in SzenarioA scALayoutl1 PAK3B_target asc Zielwertraster abgelegt in S Szenarioh chLavyout1 PAKGB target ase Zlelwertraster abgelegt in SzenarioA ScALayout1 PCE_target asc Zielwertraster abgelegt in Szenariof ScALayout1 TCE_target
152. t analysis 8 5 2 Risk based conflict analysis This functionality is not yet available User s Guide Version 1 2 0 Page 8 4 E MMT 8 6 Results 8 6 1 Target value related conflict analysis For each relevant contaminant compartment pairing the so called conflict maps show the spatial distribution of those parts of the site on which an exceedance of the remediation target value has been determined These maps can be displayed in Integrated assessment gt Results in the form frame Land use layout Conflict area Fig 8 5 By using the arrow keys the individual conflict maps can be se lected and displayed via the button Enlarge image see results of the demo pro ject in Fig 8 6 and Fig 8 7 Fig 8 5 Display and selection of results maps in the form results in Integrated assessment O Exceedance Fete 0 97 1 jk a TREE E Geacte E were Miengenic E be natune ry E TT ADA E Seite E or nrepei oruennuter Panung ie beet A Strassen E teen A Poi Fig 8 6 Conflict map for PAK in soil at O to 30 cm depth example for model site Krampnitz 7 aS User s Guide Version 1 2 0 MM Page8 5 Enneslante AE Wohrsen BO Gewerte E Lewerbe tischgebiet Mee ine FS i E J A iy me n N Fig 8 7 Conflict map PCE in the groundwater example for model site Kramp nitz 8 6 2 Risk based conflict analysis This functionality is not
153. tamt Nordrhein Westfalen Essen 2005 18 This requires an appropriate application e g Microsoft Word or Notepad that is linked with the file ending log see also section 3 4 19 Inthe current version of the MMT the prioritisation is not entered into the calculation but it does get entered into the presentation of results 20 The results values of the sustainability indicators have deliberately not been monetarised here as monetarisation would not do justice to the complexity of the assessment of sustainability factors 21 Note the form ts available only after an MMT project has been loaded 22 Morio Max Finkel Michael und Arunkumar Srinivasan 2010 SAFIRA II Megasite Managementsystem MMS Automatische Optimierung der raumlichen Verteilung der Landnutzungen MOOL Multi Objective Optimisation of Land Re Use Handbuch Dokumentation zu Methodik und Anwendung innerhalb der Megasi te Management Toolsuite MMT project report 71pp 23 Goldberg D E 1989 Genetic algorithms in search optimization and ma chine learning Reading Mass Addison Wesley Pub Co 24 Wall M 1996 GAlib A C library of genetic algorithm components Me chanical Engineering Department Massachusetts Institute of Technology 25 Holzk mper A 2006 LUPOlib a C C Library for land use pattern op timization http www ufz de index php en 17779 last accessed 11 11 2009 26 The aim is to produce a land use p
154. ted within PRESTO using the OK button but are confirmed and saved in the project only when the user quits the main PRESTO form via the Save and Back button see section 9 2 The Close Window button quits the form with out accepting parameter changes 9 6 Results form The results form shows the assessments of the remediation methods via coloured displays The assessments are arranged according to the categories in situ and ex situ as well as Source treatment and Plume management Green stands for an option that is recommended yellow for a potential option but one that is probably not the most efficient and red stands for a method that cannot be ap plied The analysis is carried out separately for each of the three input data sets so the displays are only shown in full once all the input forms have been filled in com pletely Otherwise the displays remain white The methods best suited in each case green for all three areas of assessment can be listed in the upper right hand sec tion of the form via the selection button Three buttons in the lower part of the form lead to explanations of what each of the colours means The Close Window button leads back to the main PRESTO window Results Seles Technology Applicability Technology Applicability Select Best Results For Source According to Geological According to Groundwater Treatment and Plume Parameters Ge en Management In Sit
155. text 2 Define local problem areas 3 Link to sustainability goals 4 Prioritize problems Connection Problem Area and Sustainability Goal Normative Sustainability Goals of the Helmholtz Concept Securing human existence Click on minimized Step 3 Linkage problem sustainability goal Protection of human health apes ae to show Procedure Ensuring the satisfaction of basic needs Autonomous subsistence based on income from own work 1 Became fa miliar with the sustainability Just distribution of chances for using natural resources es goal Byc k 7 Reduction of extreme income and wealth inegualities eee society s productive potential Sd 2 In your group discuss for eac poe society s options for development and action ii sustainability go Ais a kd oe Instrumental Aspects Economical framework of sustainable development 3 Attach a problem to the goal by clicking in Political and institutional framework of sustainable development the box behind the respective problem 4 Ifyou find that a problem can be attached you should Sustainability Goal 1 1 Protection of human health Hazards and unreasonable risks for human health due to Add a Problem Area to this i a Sustainability Goal manmade environmental pollution are to be avoided lt lt Back Continue gt gt E Fig 12 4 MMT Sustainability assessment Step 3 Matching local problems with the Helmholtz sustainability objectives Each problem can be matched to
156. th interim results EUGEN KS into the folder of the current layout When the user guits the module via the OK button the module writes a file with the extension cost into the folder of the current layout in which 7 aS User s Guide Version 1 2 0 MT Page 10 7 the settings and results of the calculation are saved This file is also read again when an already edited project is loaded In addition the explanatory comments are written into a file with the extension cosk and are loaded accordingly Tabular summaries of input data and calculation results that have been displayed at some point in the module cf section 10 2 are likewise located as files with the extension log in the current layout folder a User s Guide Version 1 2 0 T Page 10 8 E M MT 11 Market valuation module 11 1 Introduction The financial assessment module estimates the market value of the property This draws on the results of the remediation cost analysis which needs to have been conducted first The important factors in estimating market value are the scenario s land use ratios percentage of property area allocated to particu lar land use types their reference land values RLV the location of the property and the development status of the property These factors can be determined in a spatially differentiated way The costs of clearing the land and of remediation are taken into account as impairment Othe
157. the site map Selecting the polygons according to land use type It is possible to select all the polygons in the map at once which are allocated to a particular land use type This is done by clicking on the desired land use type in the corresponding widget on the left hand side of the form Select by land use cate gory Selecting the polygons via the table of attributes Alternatively individual polygons can be selected from the table of attributes 7 2 2 2 Allocating a use to selected polygons From the drop down list on the left hand side of the form Select by land use cate gory to the highlighted land use patch one of the land use types available in the aS User s Guide Version 1 2 0 MMT page73 MMT is selected via mouse click The land use type selected is allocated to all the previously selected polygons 7 2 3 Saving cancelling modifications The ILUM can be exited via the OK or Cancel buttons If Cancel is chosen all the changes made to the layout are cancelled after a warning message has been acknowledged i e the old layout is restored Choose OK to confirm the changes A number of options for incorporating the modified data into the project are available depending on the changes made If the changed layout fits with the current scenario in other words if the land use ratio of the individual land use types deviates only slightly see threshold column in Fig 7
158. tion lack of transportation links These problems are entered in the form Some prob lems need to be described in a lot of detail in these cases a short and succinct problem title should be chosen in addition to the longer description to appear in the subsequent steps The problem title is entered into the text field under i the de tailed description Problems can be added or deleted at any time Caution Once a problem has been deleted this action cannot be reversed SAFIRA Il Sustainability Assessment Save Assessment Load Assessment Area Modellstandort Krampnitz Potsdam Scenario SzenarioB Layout ScBLayout1 5 Define Indicators 6 Sustainable Development 7 Expected Development p Rests O 1 Define spatial context 2 Define local problem areas 3 Link to sustainability goals 4 Prioritize problems Problem Areas 1 Immisionen durch Hohes Verkehrsaufkommen in der Innenstadt il A Step 2 Definition of local problem areas The concept on which this module is based takes 2 Arbeitslosigkeit und Qualifizierung il the local situation into account 3 Uneureichende Anzahl von Gewerbefl chen il f 4 E ingeschr nktes Angebot auf dem Wohnungsmarkt il A 5 Ethaltung des kulturellen Erbes der Stadt il 6 Psychologische Probleme aufgrund von Arbeitslosigkeit il 7 Uneureichende Gewerbefl chen f r wohnungsnahe Grundversorgung il 2 8 Extreme Armut als Folge von Arbeitslosigkeit und geringer Qualifizierung il z
159. tis tics of the current layout are compared with the settings of the corresponding sce nario i e it is shown to what extent the land use layout still conforms to the use scenario see below also section 7 2 3 7 aS _ User s Guide Version 1 2 0 UMC Land Use Map Creator Map Cursor Tool Load Empty Map ScBLavout1 Select by Land Use Category Wohnen Stadtpark Gewerbe Gruenpuffer Assign New Land Use Category to the highlighted Land Use Patch E 1 Stadtpark 2 Gewerbe 4 Gewerbe 5 Gewerbe 6 Gewerbe 7 Gewerbe 8 Gewerbe 9 Stadtpark 10 Gruenpuffer 11 Wohnen 12 wohnen 13 Wohnen 14 Gruenpuffer 15 Gewerbe 16 Gewerbe 17 wohnen 18 Wohnen 191 Wohnen 20 Wohnen 21 wohnen 22 Wohnen 23 Wohnen 24 wohnen 25 Gruenpuffer 26 wohnen 57032 0673453 45373 0602327 43018 5312585 44030 532625 779945454784 39876 6363491 5951 7 9875341 66630 2161585 33940 6919989 39482 8554313 56357 2171679 51978 7354834 24406 9190435 35560 2996114 16458 0249493 55009 9050125 30608 6134524 30858 8216752 43570 5929114 327578852536 58453 651 7461 22561 4280401 25508 4582059 26763 0223099 30418 0856626 Allocation Statistics tk las T Act Land Use Land Use Ratio Difference Threshold Actual Land Use re Ratio Area m2 Wohnen I ll 0 27 10 0 564 922 Gewerbe f A 0 32 Gewerbe Mischgebiet Renaturierung Ackerland Forst Freizeit und Erholung li l i
160. ts using ROCO ssssssssrriererererrrrrrerne 10 7 Fig 11 1 User interface for the market valuation module Estimation of market value 11 1 Fig 11 2 Input form for determining the factors of location quality and development status A ee ee 11 3 Fig 11 3 Input help for location quality assessment Example Category Distances for land Use Tye HOUSING rennen ee 11 4 U Guide V 1 2 0 ser s Guide Version 1 2 Page xiv E M MT Fig 11 4 Input form for development status Example land use type Housing 11 4 Fig 11 5 User interface of the market valuation module Estimation of market based Ge DPC Cla ION ea rennen ee 11 5 Fig 12 1 Sustainability module first page essesenneneenennnneennnnnennnennnnnennnnn anna annan nennen 12 1 Fig 12 2 MMT Sustainability assessment Step 1 Definition of area to be examined and list of DalelGlDa IG Stance MOG 516 zes en ee ee a een 12 2 Fig 12 3 MMT Sustainability assessment Step 2 Definition of problems 12 3 Fig 12 4 MMT Sustainability assessment Step 3 Matching local problems with the Helmholtz sustainability objectives nrrrrnrnnnnenennnnnnr vann nn naene nn nn enne naa nne n annan nn sanee 12 4 Fig 12 5 MMT Sustainability assessment Step 3 2 Form for the actual matching 12 5 Fig 12 6 MMT Sustainability assessment Step 4 Prioritising the problems 12 5 Fig 12 7
161. tton to confirm the comments are written into the file LUT lt Land use type in Mit OK wird der Kommentar ins Projekt gespeichert ook dex gt txt in the proj ect folder DATA Details Nutzungstyp 1 6 2 2 3 Land use type Potential for sustainable development Land use type PSD The assessment of potential for sustainable development PSD is based on land use types specially defined for this purpose Each of the land use types used in the MMT see Please select labove therefore should be allocated to the types used in Residenhal area Local sennces the PSD assessment see below Select the type which Recreational area corresponds most closely to the type defined in the MMT rts The following land use types are identified by M ller amp Lange space business centre IRohr Z nker 2009 for PSD assessment Monafunchonal Facility _ u 1 The land use type Residential areas includes all kinds of residential buildings as well as any green or open spaces such as strips of grass between proper ties children s play areas parking spaces and private gardens directly asso ciated with these buildings 2 The land use type Local services includes all land use types that provide the local residential population with daily necessities local amenities This in cludes local shops such as small supermarkets butchers bakeries etc and household related services social and health care services as w
162. u Source 0909000 Ex Situ Source Best Options for Source Treatment Options Treatment Options Treatment Air Sparging Bioventing Chemical Oxidation Dual Phase Extraction Biopile Chemical Extraction Composting Excavation and Disposal Incineration Slurry Phase Biolo Treat Soil Washing Thermal Desorption Best Options for Plume Plume Management Plume Management Management Natural Attenuation Permeable Reactive Barriers Bi Landfill Capping or Seal ei Management p and Treat Physical Protection Measures aa E A Fig 9 6 Results form The suitability of the remediation methods with regard to the three input data sets Site Contaminants Geological and Site Characteristics and Groundwater Geochemical Parameters is displayed using the colours green yellow and red User s Guide Version 1 2 0 m Page 9 6 MMT 9 7 File structure The PRESTO tool initially uses the same information regarding contaminant hot spots and plumes as the costs module EUGEN KS see following section The map displayed with site data when PRESTO is loaded is located in the DATA folder and is based on this same information If assessments are carried out using PRESTO they are saved in the DATA folder This contains a file for each contaminant hotspot named lt Contaminant index gt presto for example files 1 presto to 9 presto for nine different contaminant plumes as were identified for the demo pr
163. undings The assessment module therefore takes account of the following land use types see also section 6 2 Land use type I Housing Land use type Il Local shopping etc facilities and housing infrastructure Land use type Ill Recreational Green spaces sports grounds and play areas Land use type IV Small scale commercial enterprise and services Land use type V Pollution emitting production plants and transport intensive commercial enterprise Land use type VI Business centres large scale amenities and leisure ac tivities with regional and transregional impact Land use type VII Complex mono functional facilities with large amounts of open space 7 aS _ User s Guide Version 1 2 0 When conducting the assessment it is necessary to decide for each characteristic whether or not it applies to the land this leads to an assessment result between 100 and 100 Details on the assessment matrix can be found in Rohr Z nker et al 2010 6 1 2 Operating the module The module is launched by clicking on the menu item Preparation gt Potential for Sustainable Development PSD Fig 6 1 shows the graphical user interface of the module the five priority goals of sustainable municipal development are shown in the top left hand part of the form four of which are minimised folded shut to simplify the view and to save space on the monitor screen They come into full view when they are clicked on
164. ung Priorisierung Max Figure 3 1 Marktwert Nachhaltigkeits Plot mit Vertellung der Bewertungen Gesamtbewertu ng Priorisierung Mean Figure 4 1 Marktwert Nachhalttigkeits Plot mit Priorisierung Median Figure 5 1 Marktwert Nachhalttigkeits Plot mit Priorisierung Min 5 10 15 20 25 30 2 8 pP 2 3 2 5 a Oo 5 C x oO 0 0 2 4 6 8 10 Arzahl neg ineutralipos inicht bewerteter PF Marktwert in Mio Euro Negativ bewertete Indikatoren Positiv bewertete Indikatoren A Arzshl Rot Arcahl Gr n Nachhaltigkeitswert Nachhattigkeitswert Marktwert in Mio Euro Marktwert lin Mio Euro Previous Next Page 2 of 6 Top lt m Fig 17 7 Diagrams generated for the data sets of use layouts ScALayoutl ScBLayoutl ScCLayoutl demo data set for the case that priorities are not con sidered Left Overview of all results generated F m User s Guide Version 1 2 0 T Page 17 6 m M MT 17 3 2 2 Results table The table containing a detailed comparison of the land use options includes all the data provided by the MMT via the export function see also section 13 2 Extracts from the comparison chart are shown in Fig 17 8 using the example of three land use options for the model site of Krampnitz 7 aS l User s Guide Version 1 2 0 Datensatz Titel Team Mitglieder Verteilung der Nutzungen auf dem Modellstandort Wohnen Gewerbe Gewerbe
165. usbildungschancen fur 2 alle Bev lkerunasaruppen Ee lt lt Back Continue gt gt m Fig 12 7 MMT Sustainability assessment Step 4 2 Overview of every partici pant s prioritisation F m User s Guide Version 1 2 0 T Page 12 6 l MMT In Step 5 indicators are selected as criteria for the evaluation of the de sired expected future development of the problems Fig 12 8 The indicators available for selection are stored in an Excel file which is to be created beforehand Alternatively it is also possible within the MMT to draw on a file with indicators from existing sustainability indicator systems required MS Excel Format xls Files can be loaded via the Open file with indicators button More than one indica tor can be selected for each problem Further information on the procedure At the beginning of Step 5 you see all the problems listed together with an indi cation of the sustainability objective to which it has been matched For each problem select at least one or at most three indicators which can serve as criteria to describe the problem and its development f it is not possible to find an indicator for the descriptions new indicators can be defined and entered in the indicator file Since the indicators are identified according to their position in the table new entries in the file should be made at the end of the list SAFIRA II Sustainability Ass
166. ut ScALayout1 Introduction 1 Define spatial context 4 Prioritize problems 5 Define Indicators 6 Sustainable Development Results ooo Expected Development Problem Areas Indicator Expected evelopment alue 1 Immisionen durch Hohes Verkehrsaufkommen in der L rmbelastung durch Verkehr 4 gt t ss and decide for each indicatoricriteria how Step 7 Expected Development for the Current Innenstadt nn Luftverschmutzung J o gt ve when the respective scenario would R en 2 _ Arbeitslosigkeit und Qualifizierung Schaffung von Arbeitspl tzen ur blue field on the right hand site above the register Arbeitslosigkeit E gt Unzureichende Anzahl von Gewerbefl chen Betriebsfl che Revitalisierung von Brachflachen J Eingeschranktes Angebot auf dem Wohnungsmarkt Geb ude und W ohnungsbestand in der E Stadt Potsdam gt t Wohnungsbestand in Stadtrand Gemeinden in qm Vv gt J Erhaltung des kulturellen Erbes der Stadt Anzahl denkmalgesch tzter Bauwerke und Ensembles gt t s Psychologische Probleme aufgrund von Arbeitslosigkeit nicht definiert 4 gt 4 Unzureichende Gewerbefl chen f r wohnungsnahe Wohnungsnahe Grundversorgung Grundversorgung gt Extreme Armut als Folge von Arbeitslosigkeit und geringer nicht definiert Qualifizierung Geringe Qualifizierung von Arbeitskr ften Aus und Weiterbildung J gt
167. utton Load empty map in the upper left hand part of the ILUM form an empty map can be loaded i e the shapefile of the planning units cf Fig 7 7 shown here with more precisely discretised planning units To allocate the land uses follow the procedure described above UMC Land Use Map Creator 41982 2251426 40776 7710433 57032 0679453 453730602327 49018 5312585 44090 532625 77994 5454784 39876 6363491 5851 7 9875341 66630 2161585 33940 6919989 39482 8554313 56357 2171679 51978 7354834 24406 9190435 35560 2996114 16458 0249493 55009 30501 25 30608 6134524 30858 8216752 43570 5929114 32757 8852536 58453 651 7461 22561 4280401 25508 4582059 26763 0223099 30418 0856626 Load Empty Map Empty Map Ej Select by Land Use Category Assign New Land Use Category to the highlighted Land Use Patch OO00000000 0000000000000 00000 Allocation Statistics Be Act Land Use Land Use Ratio Difference Threshold Actual Land Use and Use Type Ratio Area m2 Wohnen 0 00 50 00 50 00 10 0 Gewerbe 0 00 33 00 33 00 10 0 Gewerbe Mischgebiet 0 00 0 00 10 0 Renaturierung 0 00 0 00 10 0 Ackerland Forst 0 00 0 00 10 0 Freizeit und Erholung 0 00 0 00 _ 10 0 Stadtpark 0 00 9 00 g 10 0 Gr nriegel 0 00 0 00 10 0 Gruenpuffer 0 00 8 00 8 10 0 Cancel OK EEE EEE ad Fig 7 7 ILUM with planning units for creating a new layout Pm User s Guide
168. view in which you can select one of the layouts available Fig 5 3 Using the arrow keys you can browse through the 7 aS User s Guide Version 1 2 0 MM Page53 existing layouts and select the one you wish to analyse by clicking on the corre sponding button You can then leave the menu using the button Close view SAFIRAII MMS Select a layout Legende Wigs n A T O wohnen M Gewerbe O Gewerbe Mischgebiet 0 Renaturierung E Acke land Forst E Freizeit und Erholung Oo Stadtpark O Gr nriegel 0 Gruenpuffer Planungsgebiet N Strassen H seen AN Fluss E Geb ude Elected land use layout Navigate via arrow keys ScBLayout1 Select layout Fig 5 3 View and selection of the land use layout 5 5 Program settings Choose Settings from the File menu to change the programme settings Fig 5 4 specifically for the calculation procedure to be used in the conflict analysis and the language used on the user interface m Settings Calculation method for conflict analysis i Use specific target values f Risk based calculation Data export ta SMART e Use of the Umlaut No use of the Umlaut Language C German f English Fig 5 4 Form for changing programme settings User s Guide Version 1 2 0 Er Page 5 4 m MMT 6 Preparation 6 1 Assessing the general potential for sustainable development 6 1 1 The assessment procedure The potential for developmental reuse of a sit

Download Pdf Manuals

image

Related Search

Related Contents

Samsung 32" General display MD32B User Manual  Bienvenidos al Manual de Usuario  CLOR-FLIX 90  WEBLINKBOX  TUC229A1IN - Segurança Industrial Equipamentos  Infotainment (MY15.0)  Zanussi ZWF 1010 W Instruction Booklet  74536TE Manual  Online UPS Uninterruptible Power Supply System User Manual  Harbor Freight Tools Quick Change Sanding Drum Set 4 Pc Product manual  

Copyright © All rights reserved.
Failed to retrieve file