I still have orange High pressure Sodium streetlights where I live but a few adjacent cities (Brea, Pomona, and Corona) have been going to induction lamps. Brea selected the shoe shaped "New Jersey" style fixtures by US lighting tech of Irvine, CA with the Sylvania Icetron system while Pomona is using GE M250A2 and M400A semi cutoff cobraheads that have been retrofitted with EcoWatt induction system by Tanko Lighting in San Fransisco. Recently, the city of Corona to the south of me has also jumped on the induction bandwagon and are using the "Cobra" series fixtures by US lighting tech (looks like a cross between a full cutoff AEL 113 and a GE M250A2 with a big, heatsinked door) in a light green finish with Sylvania Icetron lamps.
For LED, the closest I know of are BetaLED LEDWays in a neighborhood south of the 10 freeway between Benson and Mountain Ave in the City of Ontario.
Anaheim public utilities is still mostly HPS but are testing out Induction and recently LEDs. There are also some induction fixtures by American Induction Technologies in an industrial area a block from my work. Near a co-worker's home on Park Vista Street are some AEL 113s with 40 watt induction "circline" lamps in them (they are not very bright though). Two GE Evolve LED cobra heads have also popped less than a month ago three blocks away as well.
So who's cities or adjacent areas are installing or using such alternatives ? They can be Induction, LED, or CMH.