The Runways 01s and 10s arrivals are very rare indeed. As has been previously mentioned, the 01s are used when there is a strong north offshore wind, usually accompanied by dry weather. Criteria I've heard the Tower used when offering it to pilots is when winds are anywhere from 350-050 over 20 knots. When those things happen, it is a spectacular day to watch the heavies perform the approach to the 28s and then circle to land by turning southbound and flying over the foothills as they prepare to make their final turn to the 1s. Quite often the tower advises of low altitude warnings as I assume they get pretty close to the rising terrain.
The 10s require a very strong easterly wind which is also rare, usually dry weather accompanies it. However, during one strong winter storm a couple of years ago the 10s were used for arrivals and departures. Problem was the cloud deck was quite low and there was no precision approach to the 10s. You could hear pilots being advised of low altitude alert as they came in through the gap to make the approach. The majority of them couldn't pick up the airport by the decision height or were too high on the approach when they broke out of the clouds and had to fly the missed approach. Eventually it got so bad that most everything diverted to OAK
. Departures could go out, so by about 2 pm, all the terminals were deserted of aircraft but full of people. It was only a short term thing. A couple of hours later, the weather improved and everything came back in. Sure was interesting and unique though.
The 19s are used mainly during the winter when storms come through bringing southeast winds. Actually the term Norcal Approach uses is the Southeast Plan. The majority of time aircraft depart the 10s while arriving the 19s. However, on somewhat rare occasions the winds become so strong from the south that they depart and land on the 19s. Another amazing sight is to watch aircraft rotate off the 19s and climb rather fast and turn left to avoid the rising terrain.
One other note, you can tell when a storm front passes over the airport. Winds drastically change from the south to a strong westerly flow. Usually as the storm approaches the 19s are in use for landing and the 10s for takeoff. Once the front passes, the airport goes to a straight 28 operation.