Regional conservation planning tool: A spreadsheet model to support spatial prioritization and resource allocation decisions

Prioritization is a central component of natural resource management because conservation needs routinely exceed available resources. Waterfowl and wetland conservation programs in North America are at the forefront of landscape-scale prioritization and transboundary management decisions due to the migratory nature of ducks, geese, and swans. The growing availability of geographic information systems (GIS) and geospatial technologies has accelerated the development of multi-objective landscape prioritization models, including applications of structured decision making and multi-criteria decision analysis to spatial planning for waterfowl and wetlands at the continental scale. However, regional managers and conservationists could benefit from flexibility in downscaling continental tools, selecting objectives, and assigning weights for rapid production of spatial prioritization models at smaller spatial scales without extensive computer coding or GIS analysis. We developed a spatial value model that prioritizes landscapes at sub-continental scales (e.g., states and provinces, bird conservation regions, etc.) and provides flexibility for users to select waterfowl conservation objectives of interest and weights. Our model can be used for direct downscaling of an existing continental geospatial model or further customized with region-specific geospatial data. We illustrate how regional prioritization can vary with the spatial scale selected by the user. The spatial value modeling framework and the downscaling tool presented here could increase the use of multi-criteria decision analysis and linear value modeling in spatial landscape prioritization, while also providing flexibility for selecting scales, objectives, and weights. Our spreadsheet tool was developed specifically for use by regional biologists, conservationists, and managers and does not require knowledge of GIS software (although results can be exported from the spreadsheet for spatial analysis using GIS). Together, the model outputs and the accompanying spreadsheet tool provide a bridge between continental waterfowl conservation and regional implementation, enabling rapid, stakeholder-driven, value-explicit prioritization.