What Will 'Green Jobs' Look Like?

Obama's proposal to pour billions into "green jobs" is the new shiny bauble all the special interests want to get a hold of. The lobbying is well underway. For an example, I just saw a press release from environmental nonprofit American Rivers that might provide some clues into what government-funded "green jobs" will look like in practice:

Green infrastructure incorporates natural systems that can help supply clean water, reduce polluted runoff, stop sewer overflows, minimize flooding and enhance community health and safety. It means restoring floodplains instead of building taller and taller levees.  It means planting trees and installing green roofs, rather than enlarging sewers or building a costly new treatment plant. And it means retrofitting buildings and homes with water-efficient plumbing instead of constructing an expensive water supply dam.

It sounds along similar lines to the construction projects headed up under Roosevelt's New Deal like those in the Works Progress Administration. There is still much debate today about just how much these projects helped resuscitate the economy. 

One could justify these programs as being environmentally sound, but are they effective economic stimulus?