Data Quality Dashboard
Automated validation rules, issue tracking, and data health scoring
7 / 8
2
11
118
90.7%
Issues by Category
Category Breakdown
Validates all required fields are populated for assets, facilities, and trail segments
Identifies duplicate community submissions based on location, description, and submission time
Validates all foreign key references (facility_id, asset_id, zone_id) point to existing records
Verifies all lat/lng coordinates fall within the Snyderville Basin district boundaries
Flags assets where condition score has not been updated in 12+ months
Detects work orders not linked to any asset or facility
Validates condition scores are within 0-100 range and consistent with inspection history
Checks that replacement_cost >= acquisition_cost and depreciation values are reasonable
Data quality rules run on a configurable schedule (default: every 6 hours). Results are logged to the audit trail. Auto-fix actions require confirmation and are fully reversible.