Schrieffer-Wolff Transformation of the Lattice Anderso Impurity Model: Local Moments, Kondo Lattice, Heavy Fermions, Intermediate Valence, and Band Theory