Threshold & Category Analysis

Category-specific alert thresholds for heterogeneous urban service demand

Urban service-demand forecasting is heterogeneous. Noise, housing, public safety, water/sewer, sanitation, infrastructure, environment, parking/traffic, and other categories have different base rates and alertability. Category-specific thresholds make this heterogeneity explicit.

Threshold Selection Summary

Score ColumnModelThreshold ModeSelected ThresholdVal F1Val PrecisionVal RecallVal ROC-AUC
lgbm_scoreTuned LightGBMglobal0.16700.37130.28530.53130.7547
xgb_scoreTuned XGBoostglobal0.16220.36830.27200.56990.7539
ensemble_lgbm_w0p500_scoreEnsemble LGBM(0.50) + XGB(0.50)global0.16910.37200.28380.53960.7563

Category Threshold Comparison

Thresholds vary meaningfully across categories — reflecting different base rates and signal strengths

Category Performance (F1, Precision, Recall)

Alert Rate vs Base Rate by Category

Category Support Table

CategoryRowsPositivesBase RateThreshold (Ensemble)F1PrecisionRecallROC-AUC
Noise27,5103,98214.47%0.17000.44230.34460.61730.7952
Housing & Building27,5103,72013.52%0.19010.40490.34760.48490.7803
Public Safety27,5103,53612.85%0.15710.39680.31570.53390.7812
Water/Sewer27,5103,46212.58%0.20500.39640.33190.49190.7822
Other27,5103,62013.16%0.15500.37250.28490.53810.7557
Parking/Traffic27,5103,58613.04%0.16500.36440.28100.51810.7470
Environment27,5102,89610.53%0.15760.35850.26650.54770.7830
Infrastructure27,5103,59613.07%0.18790.34950.27640.47530.7297
Sanitation27,5103,17211.53%0.17730.31940.26250.40760.7300