Central Data Repository City of Sugar Land, Office of Data and Innovation
PRODUCTION
Jasmine Patel, Police Data Steward (Public Safety Analyst)
View as Administrator Data engineer Utilities steward Police steward

Data quality

Automated rules run on every load. Blocking rules hold records in quarantine; warnings are scored and routed to the data steward. Results from R-20261111-0200.

Pass rate by dataset, each run

Score by dataset

DatasetScoreFailing records
CAD incident summaries
99.99%
11

Rules

RuleDatasetDimensionSeverityDescriptionStewardCheckedFailedPass %
DQ-401CAD incident summariesValidityBlock (quarantine) First unit on scene is after dispatch, a clock sync check
on_scene_at < dispatched_at fails
Police38,6001199.97
DQ-402CAD incident summariesReasonablenessWarn Response time under 120 minutes
extract(epoch from on_scene_at - received_at) / 60 > 120 fails
Police38,6000100.00

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