Current state assessment
Phase 0 inventory of source systems, today's point-to-point extracts and manual reports, owners and stewards, and the priority order for integration. Priority score weighs metric dependency, reporting effort removed and data readiness.
Systems assessed10with owner and steward confirmed
Point-to-point extracts51replaced by CDR connectors
Manual reports91candidates for retirement
Manual reporting effort6,552 hper year, at 6 hours per report per month (interviews)
| Priority | System | Department | Platform | Data owner | Data steward | Records | Extracts today | Manual reports | Priority score |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Performance metrics database (PerfDB) | Office of Data and Innovation | PostgreSQL | Data and Innovation Administrator | Kevin Tran | 18 thousand | 0 | 13 | 95 |
| 2 | Tyler Munis Financials | Finance | On premises SQL Server | Chief Financial Officer | Grace Lin | 4.1 million | 9 | 14 | 92 |
| 3 | Tyler Munis Utility Billing | Utilities | On premises SQL Server | Utilities Director | Brandon Hayes | 3.3 million | 6 | 11 | 90 |
| 4 | EnerGov | Development Services | SQL Server and API | Development Services Director | Michael Okafor | 1.2 million | 5 | 9 | 88 |
| 5 | Cityworks | Public Works | SQL Server and API | Public Works Director | Elena Ruiz | 780 thousand | 4 | 7 | 84 |
| 6 | 311 CRM | Citizen Services (311) | SaaS | Citizen Services Manager | Sofia Martinez | 410 thousand | 3 | 6 | 81 |
| 7 | CAD (summary view) | Police | On premises SQL Server | Police Chief | Jasmine Patel | 2.6 million | 4 | 8 | 79 |
| 8 | ArcGIS Enterprise | Office of Data and Innovation | ArcGIS | Data and Innovation Administrator | Kevin Tran | 62 layers | 7 | 2 | 76 |
| 9 | HR and payroll (Munis HR) | Human Resources | On premises SQL Server | Human Resources Director | Tamika Wells | 95 thousand | 2 | 5 | 70 |
| 10 | SharePoint department lists | Office of Data and Innovation | SharePoint Online | Department directors | Department stewards | 140 lists | 11 | 16 | 58 |
Data quality analysis of priority datasets (initial load)
| Dataset | Rule | Dimension | Finding | Checked | Failed | Pass % |
|---|---|---|---|---|---|---|
| Parks program registrations | DQ-701 | Standards | Race and ethnicity conforms to the DM8 profile | 3,181 | 446 | 85.98 |
| 311 service requests | DQ-201 | Validity | Request location falls inside the City limits | 29,476 | 232 | 99.21 |
| Work orders | DQ-302 | Referential | Service request link resolves to a 311 request | 21,838 | 20 | 99.91 |
| Employees | DQ-602 | Standards | Sex conforms to the City demographic standard | 1,044 | 16 | 98.47 |
| Employees | DQ-601 | Standards | Race and ethnicity conforms to the DM8 profile | 1,044 | 12 | 98.85 |
| CAD incident summaries | DQ-401 | Validity | First unit on scene is after dispatch, a clock sync check | 37,631 | 11 | 99.97 |
| Utility bills | DQ-502 | Reasonableness | Billed consumption is not negative | 316,800 | 6 | 100.00 |
Data as of run R-20261111-0200, finished 11/11/2026 02:13 Central. Curated layer: curated schema.