Sounds like a great deal for the city. Put an old filing cabinet in a dusty corner of the basement, assign a well-deserving officer close to retirement to the duty of collecting and “filing” cases for a year and collect $500 K. Repeat annually.
It won’t affect crime or help gun owners, but I am sure the city can find a way to spend the money.