SkyServer: Table Descriptions
Table Descriptions
DR7 Help
 Site News
 Cooking with Sloan
 Search Form Guide
 SQL Tutorial
 SQL in SkyServer
 Sample SQL Queries
 Query Limits
 Searching Advice
 Archive Intro
 Table Descriptions
 Schema Browser
 Web Browsers
 Data Publications
 SkyServer Sites
 Contact Help Desk

SpecPhotoAllSpectroThis is a pre-computed join between the PhotoObjAll and SpecObjAll tables. 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.