What criteria are you reviewing each USD? Only API? Have your children shown an aptitude in a particular field of study you/they are looking to concentrate on?
Unless you identify and prioritize what is most important for You and your Children any information we provide may not even apply.
From what I saw, there isn't a loser in the bunch.
But, you find different info depending upon Elementary, Middle or High.
If this is important to you, as it sounds, you should not take other opinions; you should do the dilligence.
Having lived in Dublin for many years; I would opt for San Ramon; but then, that is my opinion.