Sloan Digital Sky Survey
SkyServer DR14  
Not logged in Login Help

DR14 Help
 Start Here
 Cooking with Sloan
 Contact Help Desk
 Searching SDSS
 SQL Tutorial
 SQL in SkyServer
 Sample SQL Queries
 Query Limits
 Searching Advice
 About the Database
 Table Descriptions
 Schema Browser
Table Descriptions

WISE_xmatchPHOTO Astrometric cross-matches between SDSS and WISE objects.
This is a 'join table' which contains 'pointers' to the matched objects in the SDSS and WISE tables. The SDSS objects appear in the PhotoObjAll, PhotoObj,and PhotoTag tables. The WISE objects appear in the WISE_allsky table. Eg, to get r- and W1-band magnitudes of matched objects: 'select s.psfmag_r as r, w.w1mpro as w1 from wise_xmatch as xm join photoObjAll as s on xm.sdss_objid = s.objid join wise_allsky as w on xm.wise_cntr = w.cntr'