Question: how to get red light camera footage?
Answer: I would start by contacting the local police and the Department of Transportation first. It always helps doing this face-to-face at the local city offices or police station if you can. Ask the clerk or office for a freedom of information act request form.