Seattle 311 Service Requests
City of Seattle Open Data Portal
82/100
Completeness
91%
Accuracy
78%
Consistency
74%
Timeliness
94%
WSDOT Traffic Count Stations
WA State DOT — AADT Dataset
78/100
Completeness
94%
Accuracy
76%
Consistency
61%
Timeliness
88%
SPD Calls for Service
Seattle Police Dept — Open Data
87/100
Completeness
96%
Accuracy
88%
Consistency
84%
Timeliness
91%
USAspending.gov Contracts
Federal Awards — FPDS Data
68/100
Completeness
72%
Accuracy
74%
Consistency
58%
Timeliness
76%
Quality Score Trend — 6 MonthsAll Datasets
Issue Type Breakdown18 Total
Active Issue Log — AI Flagged6 issues
| Dataset | Issue Type | Description | Records | Severity | Auto-Fix | Remediation |
|---|---|---|---|---|---|---|
| WSDOT Traffic | Consistency | Duplicate station IDs across county boundaries | 8,412 | Critical | Yes | Deduplicate using composite key |
| USAspending | Completeness | Missing NAICS codes on sub-award records | 14,820 | Critical | Yes | Impute from parent award NAICS |
| USAspending | Consistency | Agency name inconsistencies (72 variants) | 31,400 | Critical | Yes | Standardize to FPDS agency table |
| Seattle 311 | Accuracy | Coordinates outside Seattle boundary | 482 | Medium | Partial | Geocode from address field |
| WSDOT Traffic | Accuracy | Station WA-412: zero counts 14 consecutive days | 14 days | Medium | No | Field inspection required |
| USAspending | Consistency | Award date after end date on 6.2% of records | 18,200 | Critical | Yes | Swap fields where delta < 30 days |
AI Remediation RecommendationsPrioritized
1. Deduplicate WSDOT Station IDs
Apply composite key deduplication using station ID + county FIPS + location coordinates. Impact: +11 quality points.
⏱ Effort: Low · Auto-fix script available
2. Standardize USAspending Agency Names
Map 72 agency name variants to canonical FPDS agency table. Impact: +8 quality points.
⏱ Effort: Low · Crosswalk table generated
3. Impute Missing NAICS Codes
Propagate NAICS codes from parent award to sub-award records. 94% accuracy on test set. Impact: +6 quality points.
⏱ Effort: Medium · ML imputation model ready
4. Re-geocode 311 Outlier Coordinates
482 records with coordinates outside Seattle boundary. Geocoding achieves 89% recovery rate. Impact: +4 points.
⏱ Effort: Medium · Geocoding script provided
Quality After Remediation (Projected)Forecast