i h lAsset Management with Open Source ToolsAsset Management with Open Source ToolsAsset Management with Open Source Tools

Dr. Anna Steidle - GermanyDr. Anna Steidle Germany

Ingredients:Ingredients:g

1 Lib Offi C l O Offi C l ( Offi E l)1 x Libre Office Calc or Open Office Calc (or Office Excel)1 x Libre Office Calc or Open Office Calc (or Office Excel)

1 x Libre Office Base Open Office Base ( Office Access)1 x Libre Office Base or Open Office Base (or Office Access)p ( )

1 x Qgis or gvSIG or MapWindow Open Source GIS or another which is able to create shp Files1 x Qgis or gvSIG or MapWindow Open Source GIS or another which is able to create .shp-Files

1 Bi M G l M tiff1 x Bing-Maps or Google Maps or a .tiff1 x Bing Maps or Google Maps or a .tiff

Di tiDirections:Directions:

1. Take the GIS.1. Take the GIS.

2 Add a Raster Graphic from your city by Bing-Maps or Google Maps2. Add a Raster Graphic from your city by Bing Maps or Google Maps

or the tiffor the .tiff

3 Create shp files of your urban green areas you have to maintain3. Create shp files of your urban green areas you have to maintain.

4 G t th f ld i t4. Go to the folder in your computer.y p

5. Take the OpenOffice Calc file of your5. Take the OpenOffice Calc file of your

urban green areas.urban green areas.

6 Open them with your Calculation Programm (Libre Office Calc Open Office Calc Excel)6. Open them with your Calculation Programm (Libre Office Calc, Open Office Calc, Excel)

7 Insert all information you need for your Asset Management7. Insert all information you need for your Asset Management.

8 Create a database with Libre Office Base or Open Office Base or Access8. Create a database with Libre Office Base or Open Office Base or Access.

9 Insert 4 Files: Area Maintenance Plan Benchmarks Time Green Elements9. Insert 4 Files: Area, Maintenance Plan, Benchmarks Time, Green Elements

10 Create all the querys you need:10. Create all the querys you need:

1) What kind of quality in maintenance do we provide? ) q y p

2) Wh t d h t d th t k th lit ?2) What do we have to do every month to keep the quality?

3) How many people per month do we need?3) How many people per month do we need?

4) H d d t i t i th lit ?4) How many money do we need to maintain the quality?

5)5) ….

Dr. Steidle ConsultUrban Landscape ManagementConsulting‐Training‐Applied ResearchEhrenbürgstr. 2D – 81249 MünchenGermanyyTel. 089/55 27 07 70Fax 089/55 27 07 50/E‐Mail: Steidle@steidle‐consult.dewww.steidle‐consult.de