Table Descriptions
Help
 Archive Intro
 Table Descriptions
 Schema Browser
 Glossary
 Algorithms
 Introduction to SQL
 Form Query User Guide
 Query Limits
 How To
 FAQ
 API
 sdssQA
 Download
 SkyServer Sites
 SkyServer Traffic Page
 Web Browsers
 Contact Help Desk

nametypetext
SpecPhotoAllSpectroThis is a pre-computed join between the PhotoObjAll and SpecObjAll tables. There are several criteria used for the join between these two tables, including some tiling and targeting information. Please see the FAQ entry for SpecPhotAll for more information. The photo attributes included are similar to those in PhotoTag. The table also includes certain attributes from Tiles. Many users will want to query the SpecPhoto view, which contains only those objects which are spectroscopically sciencePrimary and photometrically Primary.