The majority of street lights in the US are sodium, as are the majority of utility-owned parking lot floodlights.
However, privately-owned parking lot lighting tends to be metal halide.
You will see, on rare occasion, an ancient mercury vapor street light that has not been replaced yet.
If I might add an interesting side note, the street on which I used to live actually had incandescent street lamps up until the early 90's, with huge 300 or 500 watt mogul based bulbs. They were replaced with sodium lamps.
