Asset Management -

CITY OF ROCKINGHAM Asset Management 1 16/01/2009 Asset Management In May 2000 what was my Vision? An Integrated Parks and Gardens Asset Management System that satisfied, achieved and provided for :   The Local Government Asset Management Guidelines Recorded useful information as a Management tool. Provided useful information as an Operational tool. 2 16/01/2009 Asset Management In considering how to achieve the outcome that I wanted I adopted the following approach:Classified features required to be recorded, sorted, valued and life cycled into Hardscapes vs Softscapes  Divide each „Scape‟ into separate Audits.  Deal with the results on an individual basis.  Develop the methodology into degrees of accuracy.  Acknowledge that the initial vision will change. 3 16/01/2009 Asset Management  Hardscapes           Playground Equipment Footpath Kerbing Pumps Reticulation Electrical Cabinets Gazebos / Shade Structures BBQ‟s Cricket Wickets etc 4 16/01/2009 Asset Management  Softscapes Area of Turf Grass  Areas of Natural Bush  Areas of Planted beds both natural and exotic  Foreshore Reserves  Street Trees  5 16/01/2009 How do they rank in terms of accuracy required to pick up the asset (Higher the figure the lower the accuracy:6 8 5 Telstra Audit 3 Softscape audit Irrigation Audit Natural Bushland Audit 10 Foreshore Reserve Audit Western Power Audit Natural Reserve Audit Water Authority Audit 1 IPGAMS Parks Asset Audit (Hardscape) 9 Street Tree Audit 7 2 4 6 16/01/2009 Asset Management The Irrigation Audit is highest ranked “why”. The Team Leader will expect that the reticulation fitter will be able to locate and fix a problem solenoid valve situated below the ground level without delay. The current GPS used by the staff provides an accuracy of + - 1.5 metres 7 16/01/2009 Asset Management Imagine if the reticulation fitter needed in order to locate the valve, dig a hole one meter in depth and 1.5m radius. As his or her Manager I would not request these works unless I had an accurate plan. On second thoughts there are a couple of fitters that? 8 16/01/2009 Asset Management So what is the accuracy required within a Street Tree Audit with the following information requirements ? Quantity of Trees  Size of Trees  Health of the Trees  Register of Significant trees  Species Type  Damage caused by the tree (Structural)?  9 16/01/2009 Asset Management – Tree Audit  Tree Audit Outcome An accurate register of all street trees and there relationship to Western Power lines. With this information we can produce:- 10 16/01/2009 Asset Management – Tree Audit Pruning Programs  Tree Replacement Programs  Street Tree Planting Programs  Street Tree Removal Programs  Assist in calculating our Urban Forest and it‟s worth in terms of the ecosystem.  11 16/01/2009 Audit Design Methodology Determination Hardcopy Field Inventory  Formal survey  GPS/Palmtop  12 16/01/2009 Initial Brief To develop a desktop\web based GIS application to facilitate:- Interactive interrogation;analysis and reporting on the asset audits  Tracking of maintenance/capital works and work orders  Development of future works budgets  Reserve Design  Public access via WWW to selected information  Recreation planning/allocation  13 16/01/2009 EVOLUTION Project evolved to concentrate primarily on:- Persistent database design  Audit implementation design  WHY? Opportunistic involvement in data collection revealed many assumed 1:1 relationships were in fact many to many Intimate relationship between application design and data requirements. 14 16/01/2009 15 16/01/2009 16 16/01/2009 RETICULATION AUDIT RESERVE Number PUMP MAKE: TYPE: Start Amps: High Pressure Switch Setting Main Line Operating Pressure Date Purchased: Warranty Period: Remarks: BORE Total Probe Depth (m) Supplier: Licence No MODEL Rating: Run Amps: DATE: Name: / / Hp / KW Low Pressure Probe Level Cutout (m) Low Level Probe Type ( Standard / Transducer ) Type Construction Date Warranty Period Licence Number: Water Allowance/annum Depth (m) Diameter (cm) Draw down (m) Contractor Static Water Level (m) Expiry Date Depth to Pump Intake (m) 17 16/01/2009 SprinklerT ype SprinklerTypeIOD Drive ReplacementCycleYrs AssetValue Make Model DB_LONG DB_TEXT(10) DB_INTEGER DB_CURRENCY DB_TEXT(10) DB_TEXT(10) SprinklerPipe SprinklerPipeIOD PipeTypeIOD Number SprinklerPerformanceIOD DB_INTEGER DB_LONG DB_INTEGER DB_LONG SprinklerNozzle SprinklerNozzleIOD SprinklerTypeIOD NozzleSize NozzleColour DB_LONG DB_LONG DB_TEXT(8) DB_TEXT(10) Sprinkler SprinklerIOD LocationMethod DateInstalled SprinklerPerformanceIOD PrevLateralIOD SprinklerNozzleIOD PressureKPA PrecipitationMMHr LocationPrecision DB_LONG DB_TEXT(3) DB_DATE DB_LONG DB_LONG DB_LONG DB_INTEGER DB_DOUBLE(6,2) DB_TEXT(10) SprinklerPerformance SprinklerPerformanceIOD PressureKPA FlowLPM RadiusM SprinklerNozzleIOD DB_LONG DB_INTEGER DB_DOUBLE(5,1) DB_DOUBLE(5,1) DB_LONG SprinklerHistory SprinklerMaintenanceIOD DamageSourceIOD SprinklerTypeIOD SprinklerIOD DateReplaced DateInstalled DB_LONG DB_LONG DB_LONG DB_LONG DB_DATE DB_DATE SprinklerDamageSource DamageSourceIOD DB_LONG 18 16/01/2009 Design Overview Desktop Analysis Determine Requirements/Outcomes  Review hardcopy recording sheets  Develop initial Entity Relationship Diagrams  Design of persistent database  Determine KEY entity attributes  Design composite tables  Develop short code lists (pick lists)  19 16/01/2009 Design Overview Desktop Analysis Determine appropriate background Cadastre themes (e.g. Road Reserves / Allotment / Zoning maps/Western Power transmission detail)  Convert all layers to WGS 84 Lat/Long (HGIS requirement)  Export from Mapinfo in Mid/Mif format  Transfer resulting Mif/Mid files to Palmtop (Lablink)  20 16/01/2009 Design Overview Palmtop Procedures Import into HGIS  Conduct survey  Download captured attribute data to desktop  21 16/01/2009 Design Overview Desktop Analysis Import Mif/Mid files back into Mapinfo  Use scripts to distribute the composite table data into their respective base tables within the persistent database.  Generate appropriate management reports  Review entity and persistent database structure and relationships.  Continue development of GIS application  22 16/01/2009 Relational Vs Absolute Positioning Within desktop GIS environment it is CRITICAL that the displayed relationships between features faithfully reflects the physical reality .  In practice GPS is rarely used as mechanism for re-location (e.g. street trees use street address to locate target stem)  Many attribute relationship are intolerant of 1 – 2 metre confidence intervals (consider pathways with widths of 2m, transmission wire width; sprinkler spacings etc)  23 16/01/2009 IMPLICATIONS FOR GPS GPS : 1m + Resolution Identify all entities for which relative positioning is more important than absolute .  Import from existing sources as much pre existing spatial data of independent attributes as possible (e.g. Western power transmission data in tree audit).  Turn off GPS and use GPS software in manual data capture mode for dependent attribute (e.g. tree location).  24 16/01/2009 IMPLICATIONS FOR GPS GPS : 1cm + Resolution      Proposal is to purchase 1cm horizontal and 1.5 cm vertical resolution GPS unit at total cost of $74 000 Identify all key entities. Use GPS to capture locations of ALL key features (eg Transmission pole location and midline of overhead lines say for tree audit). This ensures internal relational consistency. What about consistency with true data custodian (eg Western power.) 25 16/01/2009 IMPLICATIONS FOR GPS Historical Perspective    10 years + ago – Corporations had solid , reliable datasets but there exist poor tools for interactive data interrogation/display. Today GIS software/computing capacity is relatively cheap and abundant but due to budget/staff constraints our underpinning data is probably in its worst state for some time. Perhaps its time for us to put aside our our GIS software tools and return to what for many of us is our primary Corporate responsibility and that is the acquisition and provision of reliable, robust corporate data. 26 16/01/2009 Parks & Reserves Integrated Management System (PRIMS) - Irrigation Module may Licence regulate Available Groundwater Via B ore may start Draws Feeds Main Line may contain In-Line Pumps via mains lead to control the opening of Regulate Flows to may update Probes Laterals Master Controller may control may start Pump start may may start multiple Slave/Sole Controller RESERVE contains Irrigation Schedules (Stations) Solenoid Valves Supply measured by remedies Wat er Dispersal Water Deficit in may predicted by result regulates Site Moisture Loss Rate contributes to influence Vegetation Types contain a Nozzle Sprinklers contribute to influences Evapouration Climate influence contain contain may Parks and Reserves addressed by may influence Irrigation Schedule Optimisation Module influences 27 16/01/2009