I expect you have seen thousands of Sodium lamps, you just didn't realise it! Sodium lamps come in 2 basic types low pressure and high pressure. Low pressure Sodium lamps are the "yellow" street lamps that were very common in past decades. They produce a lot of light for the power and last a long time, that is why they were so popular.
High pressure Sodium lamps are now used for street lighting and in warehouse type situations. They have many of the desirable characteristics of low pressure lamps, but have a better colour rendition, although compared to natural light, it is still very poor, things look weird colours under them, although not as weird as the older models.