Building D.C.'s data warehouse

The Court Services and Offender Supervision Agency for the District of Columbia has deployed a data warehouse that officials can use to monitor and supervise the more than 20,000 ex-offenders in the city. The backbone of the agency is the Supervision and Management Automated Records Tracking (SMART) case management system. A new component, the SMART-STAT Web portal, gives managers visibility into the outcome of offender supervision and treatment.

The environment runs on a SAS 9 platform and consists of a Microsoft Windows server on which the following technologies are loaded.

SAS Enterprise Data Integration Server

EDI provides a way to build and manage the Enterprise Data Warehouse that supports SMART-STAT and other forms of management reporting and intelligence-building exercises.

SAS Enterprise BusinEss Intelligence Server

EBI provides CSOSA a way to develop and surface reports via a portal, providing SMART-STAT intelligence to executives, managers and supervisors within the agency.

SAS Enterprise Miner and Text Miner

These tools provide an advanced analytic framework to begin generating offender typologies needed to focus on intervention efforts.

SAS Stat and ETS

SAS Stat and ETS provide CSOSA analysts and statisticians with an environment to explore the data warehouse and other data sources for potential new areas of management and performance reporting.

About the Author

Rutrell Yasin is is a freelance technology writer for GCN.


  • Records management: Look beyond the NARA mandates

    Pandemic tests electronic records management

    Between the rush enable more virtual collaboration, stalled digitization of archived records and managing records that reside in datasets, records management executives are sorting through new challenges.

  • boy learning at home (Travelpixs/

    Tucson’s community wireless bridges the digital divide

    The city built cell sites at government-owned facilities such as fire departments and libraries that were already connected to Tucson’s existing fiber backbone.

Stay Connected