Please provide me with the clearance rate of closed criminal activities for the present year and up to 10 years back, in Oakland. Please separate into different categories, homicide, robbery, etc. If possible please show comparisons to neighboring cities and for California in general.
Please also provide me with the amount of resources Oakland spends toward solving crime. Please provide budget and amount of staff. If possible please compare the % spent for solving crimes to neighboring cities and for California in general.