UWSpace is currently experiencing technical difficulties resulting from its recent migration to a new version of its software. These technical issues are not affecting the submission and browse features of the site. UWaterloo community members may continue submitting items to UWSpace. We apologize for the inconvenience, and are actively working to resolve these technical issues.
 

Multi-Level GIS-Based Data Management Model for Building Maintenance and Repair Data

Thumbnail Image

Files

Ibraheem_MASc_20219312.pdf (4.44 MB)

Date

2008-04-02T18:22:17Z

Authors

Al-Bukhari, Ibraheem

Journal Title

Journal ISSN

Volume Title

Publisher

University of Waterloo

Abstract

With the increasing cost of new construction projects, keeping the built facilities at acceptable levels of functionality has become a vital and challenging task. This is particularly so for non-residential buildings, such as schools, which are important infrastructure assets that require frequent maintenance and repair of their many components and sub-components. Maintenance and repair jobs, however, involve huge sets of data which contain useful interrelated information about costs, resources, conditions, and productivity. To support decision making at different management levels with respect to the utilization of resources requires the managing, analyzing, and visualizing of these huge amount of data. This thesis presents a simple and inexpensive approach to managing, reporting, and facilitating the visualization of maintenance and repair data for school buildings. The proposed model conveniently integrates widely used spreadsheet software – MS Excel – and Geographic Information System (GIS) software – MS MapPoint. The spreadsheet’s simple and powerful capability of managing data is exploited to design a data warehouse that can facilitate reporting and visualization. The Visual Basic for Applications (VBA) programming language was used to facilitate the integration between the two software systems and to automate the generation of a variety of reports and maps that can show analysis trends, reveal hidden relationships, and support decision making for different management levels. A real-life case study involving two years of maintenance data for 93 schools at the Toronto District School Board (TDSB) is used in this thesis to illustrate the development of the model and to demonstrate its simplicity and efficiency. The use of the model as part of an integrated framework for building asset management is also highlighted.

Description

Keywords

Visualization, Asset Management

LC Keywords

Citation

URI

http://hdl.handle.net/10012/3600

Collections

Theses
Civil and Environmental Engineering