Mapping the Past and Informing the Future: A Framework for Accessing and Communicating Historic Canadian Flood Impact Data

Abstract

Flooding is one of Canada's most frequent and costly natural disasters, with major negative impacts on people, economies, and ecosystems. Yet, historic Canadian flood impact data remain fragmented, inconsistent, and difficult for both the public and policymakers to access. This research develops a framework for collecting, standardizing, and visualizing historic flood impact data to improve natural disaster communication and public safety. Using the Canadian Disaster Database as a foundation, flood events from 2010 to 2024 were analyzed and assigned standardized impact scores reflecting social, environmental, and economic costs. These data were stored in a dynamic PostgreSQL database that automates calculations and supports future updates. An interactive Geographic Information System (GIS) platform was created to visualize this information, allowing users to explore flood histories across Canada, view event details, and track changing regional vulnerability through time. Unlike traditional flood maps that emphasize water extent or depth, this tool focuses on accessibility and interpretation, bridging scientific information with public awareness and policy development. By making complex flood data transparent and interactive, this framework advances science communication, strengthens evidence-based decision-making, and supports a more resilient Canada in the face of increasing climate-related risks.