Bim to Asset Management

Hi,  my name is Max and I am an architect working for Wellington City Council at present looking at taking information from bim models to asset management systems.
 The process started very simply and evolved over time through trial and lots of errors.
 The idea behind the blog is to leave breadcrumbs for others following on the path of using bim models not just for construction but for whole of life of the asset.
 The initial start on the journey was looking at using autocrat and attribute blocks to send data for water,  sewer and storm water pipes to an asset management system.  The method is a 2d approach.  On discussion of moving across to buildings,  most designers are working in 3d so the idea of taking 3d information,  collapsing it to 2d and filling out attribute blocks with data seemed a backward step.
 We looked at using Autodesk.com Revit as the bim modelling tool and the database that is in use for asset management in WCc at present is SPM.  This has a tiered hierarchy for its information.
 There were two initial projects,  a large 10 story refurbished social housing development that started in 2008 and was modelled in Revit architecturally,  services were done in autocad.  This project was nearing completion and it was felt that it would make a good pilot project.  The second project was a stand alone 3 bedroom house,  one of 5.  Both models were developed to about LOD 300.  The large building was also imbued with a bim - centric developed "B"  special that was based on a 2d cad specification from Australia.
The smaller model was used to try and define the SPM database hierarchy and map directly to it on a one to one basis.

SPM database and data capture.
One of the services that SPM offer is an on- side survey of properties by surveyors and manual measurements of areas of spaces and recording of components within their hierarchy of definitions.  They use imams to tabulate the data in a specific format and also photograph each space,  minimum of 6 photos of,  the four walls,  ceiling and floor.
As well as quantifying the asset,  they also gave the quality using a condition scale of 1 to 5.  The higher the number,  the more worn out the item is.
So,  given the quantity of an item,  an age for a specific asset,  and it's present condition,  they have built in algorithms for deducing the rest of the life of the asset.  So they can also place a cost against an item,  New,  and have a depreciation curve and a replacement cost.

Using bim to populate the database,  take one.  Revit schedules.