#AUTHOR: Mast, Husemann, Walcher 
#SOURCE: The SLoan Digital Sky Survey (DR7) 
#DATE: 2016-02-11
#VERSION: 3.0
#COLAPRV: CJW 
#PUBAPRV: none

This table provides the photometry from SDSS DR7 for the CALIFA mother sample 
galaxies as it was used for derivation of galaxy properties and for comparison 
with the extended sample galaxies. This content of this table has NOT been 
produced by the CALIFA collaboration and is available from the SDSS DR7 webpage. 
The only purpose of reproducing this table here is to allow users of the CALIFA 
Data Release 3 to identify in a unique manner which values were used for further 
sample characterization and to thus track and identify possible differences with 
other analyses. 

This catalog is a cross-match of the CALIFA mother sample with the SDSS DR7 
photometric pipeline results. The SDSS database was searched directly to find 
matching photometric objects using the SDSS CrossID tool for the DR7:
http://cas.sdss.org/astrodr7/en/tools/crossid/crossid.asp
The coordinates from the CALIFA mother sample table were uploaded and the search
was done for the nearest "Primary Object" within 15arcsec from the given coordinates.

The SQL search on the SDSS PhotoObjAll table for the matching entries is given below. 
Only a subset of the retrieved properties are reposted here, namely those that were 
actually used in the DR3 paper. 

SELECT 
   p.objID, p.ra, p.dec, p.b,p.l, p.run, p.rerun, p.camcol, p.field,p.obj,
   p.flags,
   p.petroMag_u, p.petroMag_g, p.petroMag_r, p.petroMag_i, p.petroMag_z,
   p.petroMagErr_u, p.petroMagErr_g, p.petroMagErr_r, p.petroMagErr_i, p.petroMagErr_z,
   p.petroRad_u, p.petroRad_g, p.petroRad_r, p.petroRad_i, p.petroRad_z,
   p.petroRadErr_u, p.petroRadErr_g, p.petroRadErr_r, p.petroRadErr_i, p.petroRadErr_z,
   p.petroR50_u, p.petroR50_g, p.petroR50_r,p.petroR50_i,p.petroR50_z,
   p.petroR50Err_u, p.petroR50Err_g, p.petroR50Err_r,p.petroR50Err_i,p.petroR50Err_z,
   p.petroR90_u, p.petroR90_g, p.petroR90_r,p.petroR90_i,p.petroR90_z,
   p.petroR90Err_u, p.petroR90Err_g, p.petroR90Err_r,p.petroR90Err_i,p.petroR90Err_z,
   p.isoA_u, p.isoA_g, p.isoA_r, p.isoA_i, p.isoA_z,
   p.isoB_u, p.isoB_g, p.isoB_r, p.isoB_i, p.isoB_z,
   p.isoAGrad_u,p.isoAGrad_g,p.isoAGrad_r,p.isoAGrad_i,p.isoAGrad_z,
   p.isoBGrad_u,p.isoBGrad_g,p.isoBGrad_r,p.isoBGrad_i,p.isoBGrad_z,
   p.isoPhi_u,p.isoPhi_g,p.isoPhi_r,p.isoPhi_i,p.isoPhi_z,
   p.modelMag_u, p.modelMag_g, p.modelMag_r, p.modelMag_i, p.modelMag_z,
   p.modelMagErr_u, p.modelMagErr_g, p.modelMagErr_r, p.modelMagErr_i, p.modelMagErr_z,
   p.extinction_u, p.extinction_g, p.extinction_r, p.extinction_i, p.extinction_z,
   p.dered_u, p.dered_g, p.dered_r, p.dered_i, p.dered_z

FROM #x x, #upload u, PhotoObj p
WHERE u.up_id = x.up_id and x.objID=p.objID 
ORDER BY x.up_id