Building a Data Program from Scratch
govciooutlook

A featured contribution from Leadership Perspectives: a curated forum reserved for leaders nominated by our subscribers and vetted by the Gov CIO Outlook Advisory Board.

City of Richmond, California

Building a Data Program from Scratch

Sean Mooney

Government Data Builders

Sean Mooney has worked in public service for 25 years in roles spanning digital services, civic engagement, public libraries and public education.

Vedika Ahuja is the chief innovation officer at the City of Richmond and previously led the Data & Insights Program in San Rafael’s Department of Digital Service and Open Government.

Building a Citywide Framework for Data-Driven Progress

In 2021, the City of San Rafael committed to using data and metrics to track progress toward its goals and objectives. That commitment raised questions that extended well beyond data: What were we trying to accomplish? How did the work of individual departments contribute to the City’s priorities?

Over the next five years, a two-person data team, working alongside colleagues across departments, helped establish data governance, launch an open data portal, develop performance metrics and build staff capacity. Much of the value came from the work behind those milestones: improving data quality and access, equipping departmental experts and helping the City articulate its direction and how to measure progress.

Starting with people and practical needs

San Rafael, CA, is a town of over 60,000 people in Marin County, with a municipal workforce of 450 to 550 people depending on the season. San Rafael faces a lot of challenges that other cities face across the country. We have encampments, affordability challenges, retail vacancies, increased community and Council expectations and capacity constraints to meet both operational needs and ambitious strategic goals or priority projects.

When we set out to build our data program, we had an ambitious vision and a very small team. But there are leaders across every organization if you know what to look for and you create the space for collaborative conversation with room to innovate. We invited representatives from each department to a monthly ‘Data Leaders Group’, prioritizing broad participation over technical expertise. Each department inventoried its five to ten most important datasets, documenting sources, quality issues and privacy considerations. ‘Show and tells’ gave colleagues a chance to learn how other departments used data. Within a few months, we had the City’s first shared data inventory.

The data inventory provided the backbone for a pilot open data portal. Version 1 of the portal included City Council district and census maps, existing GIS applications that could be publicly displayed, a property and zoning tool and a dashboard of service request data.

Building the open data portal required substantial improvements to the City’s GIS data. Data engineer Sherman Peng led that work alongside normal GIS operations. GIS provided a practical starting point for our data work because departments already relied on geographic data and needed maps and applications.

“When we set out to build our data program, we had an ambitious vision and a very small team.”

We cleaned foundational datasets, made them available internally and through the open data portal and helped staff build maps. We extended those data management and sharing practices to other types of information, helping departments access the tools and reliable data they needed for their work.

From measuring progress to clarifying direction

As the program developed, we established an annual rhythm for supporting data projects and producing performance dashboards aligned with the budget and City Council goals.

In 2022, the City Council approved 15 key metrics across four policy areas: Economic Growth; Diversity, Equity, Inclusion & Belonging; Sustainability, Climate Change & Disaster Preparedness; and Housing & Homelessness.

Over the next few years, as the program matured, the metrics conversation soon became a planning conversation. By 2024, the City began developing a new strategic plan and we realized that measuring progress required departments to articulate what they wanted to achieve.

The data team and the broader Digital Service and Open Government team convened departments to discuss their vision, goals, planned work and measures of progress. These conversations helped shape the City’s strategy and work plan. One of our most consequential contributions was creating a shared process for making departmental direction explicit and connecting it to City priorities.

The process was imperfect. The work plan became very detailed, and some goals did not translate readily into meaningful measures, but we made progress in articulating direction. There is still work to do to prioritize commitments and create a plan that could guide decisions within available capacity.

We also learned that a data team can facilitate these conversations, but sustained leadership is essential to turn a plan into choices about resources and work. Establishing goals and metrics creates a foundation; their value depends on how they are used, reviewed and refined.

Connecting shared capacity to community needs

Alongside this organizational work, departments continued applying data to some of San Rafael’s most pressing challenges. The Sustainability and Climate Resilience team used data to map sea level rise impacts on critical facilities, residents and businesses in the Canal neighborhood, supporting adaptation planning in a community already experiencing the effects of rising seas.

The Police Department conducted an emergency response needs analysis and used heat maps of 911 calls to identify priority locations and times for the SAFE (Specialized Assistance for Everyone) program. SAFE responds to calls involving mental health, addiction, homelessness and other non-criminal, non-life-threatening situations. 

These projects reflect the expertise and initiative of departmental staff. The program’s role was to strengthen shared capabilities including data quality, access, tools and practices that could support work across the organization.

A milestone and the work ahead

Throughout this process and the growth of the data program, we began to develop a more comprehensive data strategy. Working with Bloomberg Philanthropies’ What Works Cities coaching team and framework helped us organize our efforts, develop policies and procedures and establish a foundation for the program’s continued development.

In January 2026, San Rafael achieved What Works Cities Silver Certification, recognizing its capabilities to use data in policymaking, resource allocation, service improvement, program evaluation and resident engagement.

The next stage is to strengthen the connection between measurement and action. That means refining goals and metrics, keeping work plans manageable and using regular discussions of progress to decide where services or priorities need to change. It also means improving the data needed to answer questions we cannot yet resolve and evaluating whether changes produce the intended results. As cities adopt emerging technologies, including artificial intelligence, this foundational work will remain essential.

For cities beginning a data program, our experience suggests starting with the people and information already in the organization. Improve the datasets staff depend on, help colleagues access and use the tools they need, and bring departments together to articulate what they are trying to achieve and how they will assess progress.

The articles from these contributors are based on their personal expertise and viewpoints, and do not necessarily reflect the opinions of their employers or affiliated organizations.

Weekly Brief