The solution here is obvious. All of these shootings are facilitated by cars. If we ban cars then people will not be able to transport their guns to the gun free zones.
As a side effect, think about how many lives will be saved just from eliminating drunk drivers, distracted drivers, teen drivers, car bombs, vehicle suicides, high speed chases, hit and runs, etc.
We would also see a decrease in birth rates, general crime, greenhouse emissions, pollution, etc. as well.
Not to mention the billions spent yearly on road projects and traffic infrastructure, insurance, gasoline.
We would finally be free of foreign oil!!
...
Wow that was easy.
And nobodys rights are infringed!