Central Data Repository City of Sugar Land, Office of Data and Innovation
PRODUCTION
Marisol Ortega, Data and Innovation Administrator (CDR Administrator)
View as Administrator Data engineer Utilities steward Police steward

Overview

One governed source for cross-department reporting. Last run R-20261111-0200 succeeded at 11/11/2026 02:13.
Required sources connected9 of 910 connectors in production
Curated records477K13 curated tables
Metrics reconciled168/168metric months vs legacy database
Data quality score99.0%R-20261111-0200
Open alerts20 high severity
Departments live1of 9 in the transition plan

Recent pipeline runs

RunKindStartedStatusRows extractedQuarantinedReleasedAlerts openedResolved
R-20261111-0200Nightly11/11/2026 02:01Succeeded 3,1840000
R-20261110-0200Nightly11/10/2026 02:01Succeeded 3,0120000
R-20261109-0200Nightly11/09/2026 02:01Succeeded 2,8310000
R-20261108-0200Nightly11/08/2026 02:01Succeeded 12,1010000
R-20261107-0200Nightly11/07/2026 02:01Succeeded 2,991011504
R-20261106-0200Nightly11/06/2026 02:01Succeeded with alerts 2,964115040

All runs

Performance metrics, latest month

CS-01 311 requests closed within service level
84.8%
Oct 2026, target 90.0
CS-02 Median hours to close 311 requests
33.6hours
Oct 2026, target 36.0
DS-01 Residential building permits issued
143permits
Oct 2026
DS-02 Median business days to issue residential building permits
5.0business days
Oct 2026, target 7.0
DS-03 Inspections completed by the next business day
89.4%
Oct 2026, target 90.0
DS-04 Code enforcement cases closed within 30 days
76.2%
Oct 2026, target 75.0

Open alerts

Low CAD incident summaries: 11 records held by DQ-401
Rule DQ-401 (first unit on scene is after dispatch, a clock sync check) failed for 11 records. They are held out of the curated layer until the source is corrected.
A-1041, opened 11/01/2026 01:10, to Jasmine Patel, Data Steward. Acknowledged by Jasmine Patel
Low Munis utility bills: 6 records held by DQ-502
Rule DQ-502 (billed consumption is not negative) failed for 6 records. They are held out of the curated layer until the source is corrected.
A-1042, opened 11/01/2026 01:10, to Brandon Hayes, Data Steward. Acknowledged by Brandon Hayes

All alerts

Department transition

DepartmentStageCutover
UtilitiesCut over10/26/2026
Public WorksTraining12/07/2026
Development ServicesUser testing12/14/2026
Citizen Services (311)User testing12/14/2026
PoliceViews built01/11/2027
FireViews built01/11/2027
FinanceAssessed02/08/2027
Human ResourcesAssessed02/08/2027
Parks and RecreationAssessed03/08/2027

Adoption and training

Data as of run R-20261111-0200, finished 11/11/2026 02:13 Central. Curated layer: curated schema.