MDW

MDW

In 2005 OGRA worked collaboratively with the Ontario Ministry of Transportation (MTO) to derive a solution that would be seen as a “province-wide” success story and would promote the concept of a “data standard” for infrastructure as well as an aggregate view of the condition and extent of Ontario’s municipal infrastructure. The result of this collaboration was an asset management repository called Municipal Data Works (MDW).
In 2013 Marmak was selected as the technology custodian of MDW. Today MDW contains more than 400 municipal asset management data sets.
Inventory
MDW contains over 120 different asset types that includes but not limited to roads, bridges, sewers, waterlines, buildings, fleet and equipment.
Asset Types may contain relationships to a road section such as curbs and sidewalks.Asset Status Active Assigned to an asset, when the inventory information for that asset is to be used in CI3P, asset valuation or other applications.
GPS coordinates can be used to identify assets such as manholes, fire hydrants and catch basins. Location description (like municipal address) or GPS coordinates can be used for horizontal assets such as buildings and facilities.
Once the mandatory attributes are populated, all other attributes of the asset are optional and can be added or edited at any time.
Conditions
Municipal DataWorks has modules for pavement and bridge inspection built in. The condition and performance ratings generated from these built-in inspections can be stored in the repository along with other condition and performance values.
OSIM provides for the inspection of every element of every bridge. The bridge inspection module of Municipal DataWorks provides for that same detailed inspection and will calculate a Bridge Condition Index value based on the ratings of elements as excellent, good, fair and poor. The bridge inspection module will also allow the structural engineer to complete a visual overall inspection of a bridge or inspect one or more element groups of a bridge.
Pavement Condition Index (PCI) is a subjective measurement of pavement condition based on the ride comfort of the road section plus field observations of pavement surface deficiencies noting the severity and density of the deficiency. Municipal DataWorks has multiple condition and performance values built into a pick list. Other condition and performance values can be added to the pick list for other (objective) measurement methodologies.
Lifecycle
Lifecycle
Life Cycle Events (LCE) include the building or acquisition of a new asset and all work required to operate, maintain, renew and replace an asset. For each LCE, documentation related to that LCE can be stored as a lifecycle event attachment.
Condition and performance data should be updated at regular intervals. Municipal DataWorks will store the history of the lifecycle event (inspections) completed so that the rate of deterioration can be monitored.
Once asset condition is known, the remaining life of the asset can be estimated. This estimate is based on predicted deterioration curves and engineering judgment.
TCA Valuation
The MDW Asset Valuation module (AV module) uses the data from the inventory stored in MDW to calculate your asset values based on the PSAB 3150 Tangible Capital Assets requirements. The amortized value for all asset types in MDW can be calculated.
The AV module relies on attribute data in order to categorize assets within a single asset type, and lifecycle event data for the cost and timing of betterments to an asset or a write down/off and disposal of an asset.
The AV module calculates current values for your assets based on different approaches such as using historical costs vs. replacement costs; or completing asset valuation for individual assets or valuing by a count or a pool of assets.
Capital Forecast
Municipalities wanting to improve their capital planning capabilities can use MDW’s CI3P module. Designed for small municipalities, CI3P provides MDW users with the capability of producing a capital plan for all asset types included within the MDW asset repository for your municipality.
The Capital Infrastructure, Improvement and Investment Planning module (CI3 P) calculates the development of a capital plan.CI3P can establish criteria for grouping like assets together, set the strategies to be used for each group/category of like assets utilizing either an age based or condition based planning. Projects included in the plan can be moved from year to year or can be made into a multiyear project with a minimum of effort.
For each asset type, a user will be able to identify the work (strategies) that will be completed on the asset over the assets useful life and include local costs for each strategy identified in the plan. CI3P provides for the grouping (categorization) of like assets, the same as MDW’s Asset Valuation module.
Once the user has identified the strategies and costs for each category, created or imported, the module will create a plan using the values input by the user.
Reports
MDW provides standard reports that include asset valuation and amortization reporting and capital planning report.
Asset Condition Summary Tangible Capital Asset Threshold List
Asset List Tangible Capital Asset Detail By Asset categories
Asset Valuation Settings Asset Lifecycle Event
CIP Comparison for an Asset Type Asset Valuation Data Check
CIP Summary for all Asset Types Capital Asset Depreciation
Road Asset Traffic Counts CIP Summary for a single Asset Type
Structure Inspection List of Projects within a Single CIP
Structure Inventory Road Inventory Improvement Costs
Tangible Capital Asset Detail By Business Group Structure Inspection Results
×