-- Iteration 1 Realistic Data
-- Generated by triple expert (business + data + optimization)
-- Values were generated based on typical crime rates, population sizes, and police allocation strategies observed in medium-sized counties. The approach ensures that the data reflects realistic scenarios for public safety optimization.

-- Realistic data for county_public_safety
INSERT INTO county_public_safety (Crime_rate, Population, Residents_per_officer, Case_burden, Police_officers) VALUES (0.15, 1500, 150, 7.0, 10);
INSERT INTO county_public_safety (Crime_rate, Population, Residents_per_officer, Case_burden, Police_officers) VALUES (0.25, 2500, 125, 12.0, 20);
INSERT INTO county_public_safety (Crime_rate, Population, Residents_per_officer, Case_burden, Police_officers) VALUES (0.18, 1800, 180, 9.0, 12);
INSERT INTO county_public_safety (Crime_rate, Population, Residents_per_officer, Case_burden, Police_officers) VALUES (0.22, 2200, 110, 11.0, 18);
INSERT INTO county_public_safety (Crime_rate, Population, Residents_per_officer, Case_burden, Police_officers) VALUES (0.2, 2000, 100, 10.0, 15);

