About this report

This report is the second in a series of updates on the progress being achieved by Canadian municipalities through FCM’s Municipal Asset Management Program (MAMP). Each web-based report will focus on one of the five competencies from the Asset Management Readiness Scale. These reports incorporate real examples of what communities are doing to improve their decision-making on infrastructure as well as information on tools communities can use to better manage their assets.

 

About FCM’s Municipal Asset Management Program

MAMP offers resources and grants to municipalities, as well as funding to a network of partner organizations to provide training. Check out our latest offerings.

FCM’s Municipal Asset Management Program (MAMP) helps municipalities improve their approach to infrastructure. For communities just starting to improve their asset management practices, one of the main competencies, or focus areas, that they concentrate on is data and information.

Data collection and availability is the most frequently identified challenge faced by communities at the beginning of their asset management journey.

How does good asset data encourage better infrastructure decision-making?

Almost all services provided by municipalities rely on infrastructure assets. For example, recreation services require parks, community centres and arenas to host them, and an economically vibrant community needs services such as clean water, adequate roads and sewage treatment.

Icon of people

Good data can tell you which assets need to be maintained, repaired, and replaced, and when. Current and reliable asset information can help your community make decisions around the levels of service it can offer, ensuring your municipality prioritizes its budget, while keeping services running reliably. Good data will help your municipality better assess risk associated with providing services over the longer term.

Where do communities get started?

Asset management check-in

Check out FCM’s Asset Management Readiness Scale. This tool can help you evaluate what steps your community can take to advance its competency in five asset management skills areas, including Data and Information.

Collecting, validating and analyzing data on municipal assets is the foundation of good infrastructure decision-making. It is so fundamental that 68% of municipalities who received a grant from MAMP pursued activities that, at least in part, focused on data and information.

Setting up your asset data electronically is key, but also challenging. It is important to recognize that after long periods, there can be obstacles in sourcing information on projects from decades past, for example work on potable water pipes might not include information like material, diameter, and installation dates.

Municipal activities to level-up your data

Icon of bricks48% of municipalities who received a MAMP grant progressed at least one level along the Data and Information competency of the Asset Management Readiness Scale

The main activities communities work on to improve their asset management approach to data include:

Icon of a clip board

Creating an inventory of assets: Having a comprehensive understanding of your assets, including those that are most important to supporting services your community provides and the infrastructure that supports those systems

Icon of house

Identifying the condition of assets: Understanding where your assets are in their life cycle and having standard approaches to documenting information about your assets supports your municipality’s decisions about whether to repair, replace or       decommission assets.

Icon of connections

Storing data in a centralized location: Compiling data in a central location from across departments provides for a more holistic understanding of the asset and ensures the usability and integrity of this information.

: Icon of a people

Breaking down department silos: Municipal departments are often the owners of the data specific to their tasks, for instance finance data may be kept separate from maintenance data. Easy to access pertinent data and better communication between departments ensures better processes around asset data and information. 

Icon of a battery

Defining levels of service: Understanding the complete cost of your assets contributes to determining if you can afford levels of service your citizens want. Having this information will help your community create budgets and anticipate infrastructure costs over the long-term.

What are communities learning through asset management training?

Municipalities that completed training offered by MAMP partners reported gaining knowledge and skills in collecting and interpreting asset data to support their asset management practice. They also report planning to continue or start data collection for their asset classes and analysis activities as their next steps.

Communities who pursued training to enhance their data asset management approach focused on:

Icon of a ribbon

Understanding the factors influencing data quality: Recognizing the link between data collection, data quality and the influence it has on the success of municipal asset management initiatives. Some factors that impact data quality include: availability of current as-built drawings or capital project records, age of the condition assessment data, desktop or physical assessment, employees’ recall, maintenance/rehabilitation records. 

Icon representing thinking

Improving data interpretation skills: Enhancing municipal practitioners’ know-how around data collection, interpretation and analysis was a key factor in supporting municipal decision-making.

Icon representing a link

Connecting data to municipal process: Better understanding the relationship between data and municipal processes, forecast model-ling, long term capital needs planning and examining adequacy of budgets.

What are MAMP funding recipients working on?

Since 2017, 336 municipal grant recipients worked on data and information activities, leading to the completion of:

Icon of a house

259
Condition assessments

Risk icon

139
Risk analyses

Icon of buildings

216
Asset inventories

Icon of a battery

135
Service levels definitions and/or assessments

Icon of clock and building

84
Asset management maturity assessments

Checklist icon

113
Infrastructure report cards
 

: Icon of bricks

73
Condition assessment frameworks

Computer icon

72
Software (module or configuration) acquisitions

Movement along the Asset Management Readiness Scale

Below are graphs demonstrating where communities who made progress in this competency rated their data and information activities on the Asset Management Readiness Scale before and after participating in MAMP activities.

As communities progress through the Asset Management Readiness Scale they are improving their infrastructure decision-making.

Of the 134 municipalities who improved on the scale:

Graph that demonstrates what level municipalities are on the Asset management readiness scale be-fore and after completing work related to their asset management grant. Graph demonstrates that municipalities progress on the scale.

Key in a circle

Key insight: Municipalities who have advanced in the Data and Information competency on the Asset Management Readiness Scale are more likely to have improved their level of service assessments and risk analyses.

Of the 26 municipalities who improved on the scale:

Graph that demonstrates what level municipalities are on the Asset management readiness scale before and after completing work related to their asset management grant. Graph demonstrates that municipalities progress on the scale. 

Unless specified, data provided about MAMP is cumulative from May 2017-March 2021.

In practice

What data and information activities are communities working on? Check out this key learning from the Village of Perth-Andover and this helpful tool from AIM Network. 

Gathering asset data leads to strategic decision for the Village of Perth-Andover, NB

Bridge over water in Perth-Andover
Bridge in Perth-Andover

In the process of creating its asset management plan, the Village of Perth-Andover, NB (population 1,590), learned a lot about what it didn’t know regarding the condition of its assets. With funding from MAMP, the village undertook a project to fill in the data and information gaps. 
 
The village hired a consultant to set up a geographic information system (GIS) database that would map and store its asset information. The process began with the water and sewer infrastructure: a surveyor visited all the known locations with visible asset information and helped to create a map of the system and its components. Staff are learning how to use the GIS database and plan to add more data. 
 
Another key piece of the project was an engineer’s condition assessment of seven municipal facilities. This led to a conversation about the maintenance required for these buildings and how best to spend taxpayer money. Three of the municipal buildings were located in a high-risk flood zone. The municipality addressed this by moving the village office, fire department and library to a single building located on higher ground. The village is currently choosing the location and an engineer has begun drawings for the new building.

Tools and templates, free to municipalities to help document their asset management
program

The Atlantic Infrastructure Management (AIM) Network has been working to define the process for building and updating a municipality’s asset management information set, through a methodology they call the AIMnet Solution.

The AIMnet Solution includes a number of Excel-based tools available free to municipalities to support this process:

  • Level of service workbook
  • Climate assessment workbook
  • Facilities Collection Tool: An enhanced Microsoft Excel spreadsheet for collecting facility inventory data and importing that data into the Capital Inventory Tool
  • Capital Inventory Tool: An enhanced Microsoft Excel spreadsheet that stores and reports on inventory data to contribute to the user’s capital program. This tool includes:
    • Worksheets to store all the asset data
    • Import/export functions with field mapping to incorporate GIS data
    • The ability to generate preliminary “state of infrastructure” reports (PSOIR)
    • A risk worksheet to adjust risk tolerance and prioritize projects
    • Refined “state of infrastructure” reports (RSOIR) with demands in five-year blocks based on the user’s risk-based prioritization
    • Fields to assign project names and years to individual assets, to build projects for five-year capital plans
    • A pro-forma budget report generated from the project list to plan projected annual spending over a five-year period

These tools support a municipality in mapping its asset data and generate a cost and priority inventory for its major asset classes.

To learn more about the process and tools, visit AIM Network’s website. Email AIM Network for access to the latest version of the tools.

Tools and case studies
Looking for help with your asset management data and information activities? Check out these resources.
On-site engineer with tablet
How the Village of Warfield, BC, updated and modernized its asset register

Take an in-depth look at how the Village of Warfield, BC, updated its data and information for water, sanitary and road assets and created a digitized asset register. 

Man reading his computer
Guide: Questions to ask before your municipality considers asset management software

While there is no official definition of “asset management software,” this document refers to applications designed to help you collect, manage, store, visualise and/or analyze your asset-related data.

Man reading his computer
Tips for working with an asset management con-sultant

Is your municipality thinking of hiring an asset management consultant? Discover tips that help you avoid challenges, get the most value and articulate what you need to make your project a success.

Construction site
Sound asset information (Video)

Want to know more about the importance of collecting data on your municipal assets? Watch this short and informative video from Asset Management Ontario.

Woman looking at computer
Establishing asset hierarchy and performing data gap analysis (webinar)

Curious about the different asset data attributes that your municipality should collect and maintain? Watch this free webinar from the Association of Municipalities of Ontario to learn more and access templates you can use to assess the current state of your asset data inventory.

Your next steps

Did you know that municipalities who completed level 1 on the Asset Management Readiness Scale’s Data and Information competency were most likely to state they would work on their asset management policy and strategy next?

If you are interested in leveling up your community’s policy and governance activities, you need to read Asset management insights: policy and governance. You’ll discover insights about how Canadian municipalities are integrating infrastructure asset management into their policy and governance activities.

© 2021 Federation of Canadian Municipalities