Skip to content

November 13, 2025

Connecting Campus with Space Data via the Enterprise Data Platform

UW Facilities manages more than 15 million square feet of owned space on the Seattle campus and over 2 million square feet of leased space across the greater Seattle area. These spaces are essential to the University’s academic, research, and administrative operations. To effectively manage them, UW Facilities relies on a Space Management System that supports data-driven decision-making and ensures compliance with federal and state reporting requirements—including the Facilities & Administrative (F&A) rate proposal, which depends on reliable research space data.

When UW Facilities began the project to replace its Space Management System earlier this year, it opened the door for UW-IT to expand how space data is managed and shared across the University. Together, the teams delivered two major outcomes for enterprise data customers: the introduction of space data into the Enterprise Data Warehouse (EDW) and the transition of the existing Space Web Service to the new system as its data source.

About the Solutions

Enterprise Data Warehouse (EDW)

UW Facilities needed a more scalable, dependable, and integrated way to manage and share space data across the UW. Previously, customers accessed this data directly from Facilities’ systems—creating extra work for Facilities staff and limiting the ability to combine space data with other enterprise datasets.

To address this, the project team moved space data into the EDW and established a new database—SpaceDataStore—to house the data in a comprehensive relational structure designed to support a wide range of reporting and analytics needs.

This solution:

  • Standardizes data access and security
  • Ensures reliability and consistent uptime
  • Reduces operational overhead for Facilities
  • Enables integration with other EDW datasets (for example, HR, Finance, Academics, and Core Data)
  • Supports strategic planning, spatial analysis, and indirect cost recovery
  • Provides Space Data customers with a familiar, standard approach to both EDW change management and customer support.
  • Consolidates direct-access customers into the EDW, improving data consistency and simplifying how space data is managed across campus.

Notes:

  • Existing EDW customers have access to most of the new Space Data through their existing EDW data access role. No need to put in a new data access request.
  • Definitions for all the new Space Data remain under development and will be published in Knowledge Navigator soon.

For more information about SpaceDataStore, refer to Announcement: Launch of the New SpaceDataStore Database in EDW.

Enterprise Web Services (EWS)

In parallel, the EWS team transitioned the Space Web Service to use FM:Systems as its new data source. Despite a tight timeline and complex dependencies, the transition was completed seamlessly—with no disruption to customers or downstream systems.

The updated solution:

  • Preserves existing customers’ integrations with no interruptions or changes
  • Ensures stability and continuity for web service customers
  • Reinforces UW’s commitment to dependable, enterprise-scale solutions
  • Continues to protect Space Data customers (such as Workday) from upstream changes

Collaboration Across Teams

This project demonstrates the power of collaboration—both across UW-IT and with campus partners. What began as a system replacement became an opportunity to modernize how space data is connected, managed, and shared across the University. By combining technical and operational expertise, UW-IT and UW Facilities delivered a streamlined, enterprise-level solution that strengthens the foundation for smarter planning and more connected data at the UW.

The effort brought together the following groups, each contributing essential expertise to make the project a success.

Enterprise Data Warehouse Solution:

  • Analysis & Design, UW-IT – Trina Mosher, Daniel Kim, Robert McLaughlin
  • Enterprise Data Warehouse, UW-IT – Dre Tanner, Ian Stewart, Rosalie Leano
  • UW Facilities – Jay Dahlstrom, Corey Chan, LaMonte McGraw

Enterprise Web Services Solution:

  • Analysis & Design, UW-IT – Trina Mosher, Daniel Kim, Robert McLaughlin
  • Enterprise Web Services, UW-IT – Gary Lu, Dominic Ho
  • UW Facilities – Jay Dahlstrom, Corey Chan, LaMonte McGraw

Questions?

Email help@uw.edu and include “EDW” or “EWS” in the subject line.