Star glow might work for the street lights. You could render a street light only luminescence pass, add star glow to that, and add it over your video. But at a really low level, other wise it would be pretty overwhelming.
I second the lens flares—not sure about knoll, but VideoCopilot allows you to place the flares on 3D lights in AE—so if you can export the Camera Information from your 3d application, the 3D lights would track with your camera. Also, you could place 3D lights in the scene with AE, and purchase Trapcode Lux, which creates volumetric lighting.
Johnny Cuevas, Editor
Thinkck.com
“I have not failed 700 times. I have succeeded in proving that those 700 ways will not work. When I have eliminated the ways that will not work, I will find the way that will work.”
—THOMAS EDISON on inventing the light bulb.