Creating a Digital Bridge for Municipal Fiscal Health

by Dec 10, 2015Smart Cities

Lourdes German

Lourdes German currently serves as a Fellow at the Lincoln Institute of Land Policy where she is advancing the Institute’s municipal fiscal health campaign. Lourdes also serves as founder and director of the Civic Innovation Project. Outside of work, Lourdes advises the Governor of the Commonwealth of Massachusetts as a gubernatorial appointee to the State Finance and Governance Board, and is an appointee of the Mayor of Boston to the committee focused on the City of Boston’s audit and finance matters.

Who will you meet?

Cities are innovating, companies are pivoting, and start-ups are growing. Like you, every urban practitioner has a remarkable story of insight and challenge from the past year.

Meet these peers and discuss the future of cities in the new Meeting of the Minds Executive Cohort Program. Replace boring virtual summits with facilitated, online, small-group discussions where you can make real connections with extraordinary, like-minded people.


Recently, I was privileged to listen to Mayor Libby Schaaf, from the City of Oakland, California, deliver one of the most poignant speeches that I have ever heard. As she held up the city’s 600 page budget, Mayor Schaaf proclaimed, “this is the city budget – it’s the most important thing we do every year in government.” She described her multi-year effort to convert those 600 pages into “one elegant visualization” that communicated the city’s story of fiscal stewardship. Mayor Schaaf credits the significance of this moment for inspiring a new level of awareness within her team. By creating this digital bridge, both city leadership and citizens were now able to interact with government fiscal data in a more meaningful way. All involved were now able to see and identify challenges, red flags, and potential opportunities for positive growth with greater clarity.

Mayor Schaaf’s remarks left me with questions. What happens to the community that wants to transform its approach to fiscal discipline, but lacks the capacity and resources? How do you unlock the power of data to inform the leadership of a community on the brink of fiscal decline and reverse that trajectory? How do you bridge the gap between peers in government, making information accessible from one community to another so leaders can see how they stand in the delivery of public services, managing revenues, and infrastructure investments? Can data teach a leader to open a new dialogue on municipal fiscal health and sustainability?

I’m addressing these questions by developing an electronic Municipal Fiscal Health Dashboard for 150 cities across America, scheduled for public release in early 2016. The tool, and policy paper that will accompany it, are being produced for the Lincoln Institute of Land Policy in my role as a resident fellow of the Institute, to advance the Institute’s new campaign to promote municipal fiscal health. The project promotes the notion that a new ethos of transparency and governance can be created by empowering leaders of municipalities at every level to engage in data-driven decision-making in the critically important realm of municipal fiscal health.

Why is municipal fiscal health important?

Everyone in the world is the citizen of a municipality. Thus, municipal fiscal health is a strategic priority of ongoing concern on a global scale. The serious social, political, and economic impacts of fiscal distress are evident in Greece, Detroit, and Puerto Rico’s public declarations of impending insolvency: when a government cannot pay its debt or fund its operations, the consequences extend far beyond the bankruptcy filing. The costs of insolvency are often humanitarian, resulting from the failure of government to deliver lifeline services and underinvestment in infrastructure, ending with the gradual erosion of trust between citizens and their leader.

At any given time, countless municipalities across the world struggle with initial phases of fiscal decline that is not immediately obvious. Just as an assortment of puzzle pieces does not reflect the full picture until it is assembled, the fiscal narrative of a municipality at times makes it difficult to identify all the attendant factors leading to a crisis. Municipalities experiencing early stages of fiscal stress could be grappling with any number of structural factors that, absent identification and intervention, can result in a crisis. Examples can include:

  • Cash flow that barely covers the costs required to fund basic operations and services of government, as liquidity narrows on a consistent and recurring basis.
  • Eroding strength and diversity of the tax base, occasioning an over-reliance on unpredictable and unsustainable fees to meet expenditures.
  • An inability to make annual required contributions that are necessary to honor multi-year promises made to vulnerable populations of retirees.
  • Debt that is incurred at unsustainable levels to pay for roads, schools, bridges and other brick-and-mortar projects that are the heart of the community.

Transparency, knowledge sharing and a proactive stance of local leaders lie at the core of strong municipal fiscal health. Adding resources that enhance the capacity of leaders to identify, evaluate, and understand key data points that impact fiscal health improves the chances of achieving this goal.

The Components of the Municipal Fiscal Health Dashboard

The Municipal Fiscal Health Dashboard is an electronic tool that will help the leader of a municipality answer the following question: is my community fiscally strong enough?

The tool presents data for a cross section of all 50 states, featuring 150 U. S. cities, and was developed using the Fiscally Standardized Cities database (FiSC) of the Lincoln Institute of Land Policy. The tool visualizes local government data across more than 120 categories of revenues, expenditures, debt, and assets, for a 35 year time horizon for each FiSC city. Additionally, I supplemented the FiSC data with Comprehensive Annual Financial Report data gathered for all 150 FiSC cities, and selected demographic and fiscal data for all 50 states nationally, in order to provide meaningful reference points for comparison in key areas.

At present, it is virtually impossible to make meaningful fiscal comparisons among the nation’s cities due to major differences in how cities deliver public services, with some city governments providing a full array of public services, while others share that responsibility with a variety of overlapping independent governments. The unique methodology of the FiSC data accounts for these differences in local government structure, and supports the development of visualizations that allow governments to identify and reliably compare fiscal data across a sample of their peer municipalities.

The tool will provide leaders with several diagnostic options. By clicking a few buttons they can change how data is visualized, either as a stand-alone analysis for their municipality, or in comparative views against other cities, and the nation. Leaders will now be able to answer questions, such as:

  • What is the measure of per capita spending on public services over time in my municipality?
  • What is our most important source of tax revenue, and is it sufficient in view of our overall revenue profile as a municipality?
  • Have levels of federal and state intergovernmental aid changed over time in view of the ebbs and flows of our expenditure needs and liabilities?

A liquidity calculator within the tool visualizes derived ratios, and facilitates fiscal and demographic trend analyses, using Comprehensive Annual Financial Report data and other Census data. A municipal leader can also import any of their own data into the tool. This makes the tool useful for leaders of any municipality (even those outside of the FiSC cities) who want to measure, track, and assess data to gain a daily snapshot of the changing social indicators and core strength of the central funding source for all municipal activities: the general fund.

To facilitate ease of adoption and use, I am designing and building the tool with the technology resources of the Microsoft business intelligence platform. Any user familiar with basic Excel spreadsheets will be able to easily use the tool. It is also compatible with virtually any operating system, has mobile capabilities, and will be offered to municipalities at no cost.

Introducing a New Ethos of Transparency

The Municipal Fiscal Health Dashboard is more than just a tool developed as a service for government – it is an experiential research instrument that will demonstrate the power of one resource to shape a leader’s experience and vision for fiscal data transparency.

This project is unfolding at the center of vigorous national public policy initiatives, as well as conversations about the future of government fiscal transparency by key federal leaders, and countless local leaders. It speaks directly to a pressing regulatory priority, and presents a unique opportunity to advance this important conversation by doing something that has never been attempted: demonstrating the power of a tangible resource that makes transparency a daily part of fiscal governance and transforms the foundation of civic decision-making that impacts citizens across America.

The author acknowledges Jenna DeAngelo and Adam Langley of the Lincoln Institute of Land Policy for their contributions to the data collection process that has been integral to the development of the Municipal Fiscal Health Dashboard.


Leave your comment below, or reply to others.

Please note that this comment section is for thoughtful, on-topic discussions. Admin approval is required for all comments. Your comment may be edited if it contains grammatical errors. Low effort, self-promotional, or impolite comments will be deleted.

1 Comment

  1. Truly visionary and important work – I would like to see and learn more about this, as it’s an important contribution to the landscape for cities across America and even world wide who are struggling with this challenge and broader sustainability.


Submit a Comment

Your email address will not be published. Required fields are marked *

Read more from

Spotlighting innovations in urban sustainability and connected technology

Middle-Mile Networks: The Middleman of Internet Connectivity

Middle-Mile Networks: The Middleman of Internet Connectivity

The development of public, open-access middle mile infrastructure can expand internet networks closer to unserved and underserved communities while offering equal opportunity for ISPs to link cost effectively to last mile infrastructure. This strategy would connect more Americans to high-speed internet while also driving down prices by increasing competition among local ISPs.

In addition to potentially helping narrow the digital divide, middle mile infrastructure would also provide backup options for networks if one connection pathway fails, and it would help support regional economic development by connecting businesses.

Wildfire Risk Reduction: Connecting the Dots

Wildfire Risk Reduction: Connecting the Dots

One of the most visceral manifestations of the combined problems of urbanization and climate change are the enormous wildfires that engulf areas of the American West. Fire behavior itself is now changing.  Over 120 years of well-intentioned fire suppression have created huge reserves of fuel which, when combined with warmer temperatures and drought-dried landscapes, create unstoppable fires that spread with extreme speed, jump fire-breaks, level entire towns, take lives and destroy hundreds of thousands of acres, even in landscapes that are conditioned to employ fire as part of their reproductive cycle.

ARISE-US recently held a very successful symposium, “Wildfire Risk Reduction – Connecting the Dots”  for wildfire stakeholders – insurers, US Forest Service, engineers, fire awareness NGOs and others – to discuss the issues and their possible solutions.  This article sets out some of the major points to emerge.

Innovating Our Way Out of Crisis

Innovating Our Way Out of Crisis

Whether deep freezes in Texas, wildfires in California, hurricanes along the Gulf Coast, or any other calamity, our innovations today will build the reliable, resilient, equitable, and prosperous grid tomorrow. Innovation, in short, combines the dream of what’s possible with the pragmatism of what’s practical. That’s the big-idea, hard-reality approach that helped transform Texas into the world’s energy powerhouse — from oil and gas to zero-emissions wind, sun, and, soon, geothermal.

It’s time to make the production and consumption of energy faster, smarter, cleaner, more resilient, and more efficient. Business leaders, political leaders, the energy sector, and savvy citizens have the power to put investment and practices in place that support a robust energy innovation ecosystem. So, saddle up.

The Future of Cities

Mayors, planners, futurists, technologists, executives and advocates — hundreds of urban thought leaders publish on Meeting of the Minds. Sign up to follow the future of cities.

You have Successfully Subscribed!

Wait! Before You Leave —

Wait! Before You Leave —

Subscribe to receive updates on the Executive Cohort Program!

You have Successfully Subscribed!

Share This