← Back to Portfolio Hub
Viz 2 of 3: Technical & Architecture Craft
Kansas City Open Data · Socrata API· 2,385,708 Total Requests· Public Domain Data

What the City Stopped Being Able to Measure

Kansas City replaced PeopleSoft CRM with MyKCMO in March 2021. The city publishes the two eras as separate datasets with incompatible schemas. Conforming them uncovers a severe civic casualty: a 63% collapse in taxonomy depth, and the total loss of neighborhood boundaries and SLA breach tracking.

Lifetime 311 Volume
2,385,708
Dec 2006 → Aug 2026
Taxonomy Granularity
−63.3%
1,236 types → 453 sub-types
Hierarchy Levels
6 → 2 Levels
Deep taxonomy collapsed
Neighborhoods Tracked
250 → 0 (Dropped)
Civic spatial accountability lost

The March 2021 Cutover: A Hard Replacement, Not a Parallel Run

Monthly volume recorded in 2021 confirms that traffic split rather than duplicated. Individual request matching is impossible.
Socrata IDs: 7at3-sxhp (Old) & d4px-6rwg (New)
Engineering Insight: The two datasets overlap on calendar dates for 8 months, which initially looks like a parallel run. But monthly volumes refute this: March 2021 was a hard cutover splitting the month (2,206 PeopleSoft vs 8,963 MyKCMO). No single request was recorded in both systems. Therefore, schema conformance must be proven through distributional shifts and category crosswalks, not record-level joins.

Interactive 4-Level Taxonomy Explorer

Click any bar to drill down: Department → Work Group → Request Type → Priority Detail.
Level 1 of 4: Department
Category Name Request Volume Share of Parent SLA Baseline Target

Schema Breakdown: What Was Lost in the Migration

Comparing the 34-column PeopleSoft CRM schema with the 18-column MyKCMO Socrata dataset.
Schema surface reduced by 47.1%
Architectural Feature PeopleSoft Era (2006–2021) MyKCMO Era (2021–2026) Downstream Analytic Impact
Classification Depth 6 Levels (Dept → WG → ReqType → Cat → Type → Detail) 2 Levels (Issue Type → Sub-Type) Deep root-cause failure analysis eliminated for city field crews.
Request Types 1,236 Distinct Categories 453 Distinct Sub-Types (−63.3%) Emergency calls (e.g. rim-damaging potholes) merged with routine maintenance.
Neighborhood Boundaries 250 Named Civic Neighborhoods DROPPED (None) Neighborhood associations lost civic accountability metrics; only council districts remain.
SLA Breach Flag exceeded_est_timeframe (Boolean) DROPPED (None) City-wide SLA breach rates can no longer be directly calculated from the public dataset.
Spatial & Property Identifiers parcel_id_no, police_district, zip_code DROPPED Cannot join 311 complaints against county tax assessment or property ownership records.