Notes sur l'ingestion du SDSS DR12

Liens utiles

SDSS DR12 schema browser

SDSS DR9 in VizieR

CasJobs

Tables à récupérer

Correspondances des noms avec l'existant dans VizieR :

PhotoObjAll

-- Table PhotoObjAll
SELECT
objID,mode,type,ra,dec,raErr, decErr,
u,g,r,i,z,Err_u,Err_g,Err_r,Err_i,Err_z,
psfMag_u, psfMag_g, psfMag_r, psfMag_i, psfMag_z,
psfMagErr_u, psfMagErr_g, psfMagErr_r, psfMagErr_i, psfMagErr_z,
nChild, flags,
petroMag_u, petroMag_g, petroMag_r, petroMag_i, petroMag_z,
petroMagErr_u, petroMagErr_g, petroMagErr_r, petroMagErr_i,
petroMagErr_z,
petroRad_u, petroRad_g, petroRad_r, petroRad_i, petroRad_z,
petroRadErr_u, petroRadErr_g, petroRadErr_r, petroRadErr_i,
petroRadErr_z,
devRad_u, devRad_g, devRad_r, devRad_i, devRad_z,
deVAB_u, deVAB_g, deVAB_r, deVAB_i, deVAB_z,
deVPhi_u, deVPhi_g, deVPhi_r, deVPhi_i, deVPhi_z,
flags_u, flags_g, flags_r, flags_i, flags_z,
type_u, type_g, type_r, type_i, type_z,
probPSF_u, probPSF_g, probPSF_r, probPSF_i, probPSF_z,
resolveStatus,
offsetRa_u, offsetRa_g, offsetRa_r, offsetRa_i, offsetRa_z,
offsetDec_u, offsetDec_g, offsetDec_r, offsetDec_i, offsetDec_z,
parentID, SpecObjID, fieldID, clean, mjd
FROM PhotoObjAll

ProperMotions

Jointure sur objID

-- Table ProperMotions
Select objID, match, pmRa, pmDec, pmRaErr, pmDecErr, sigRa, sigDec,
nFit,
O, E, J, F, N
from ProperMotions

Field

Jointure sur PhotoObjAll.fieldID = Field.fieldID

-- Table Field
SELECT
fieldID,skyVersion,rerun,run,camcol,field,quality,mjd_u,mjd_g,mjd_r,mjd_i,mjd_z
FROM Field

SpecObjAll

Jointure sur PhotoObjAll.specObjID = SpecObjAll.specObjID

-- Table SpecObjAll
select
specObjID, mjd, plate, tile, xFocal, yFocal, fiberID, z, zErr,
zWarning,
velDisp, velDispErr, snMedian, ra, dec,
spectroFlux_g, spectroFlux_r, spectroFlux_i,
primTarget, secTarget, seguePrimary, sciencePrimary,
plateID, spectrographID, targetObjID, bestObjID,
run2d, instrument, sourceType, class, subClass
from SpecObjAll

Photoz

Jointure sur objID

On ne conservera que les colonnes suivantes :

• objID
• z
• zErr
• chisq
• absMag*

-- Table Photoz
SELECT
objID, z, zErr, chisq, absMagU, absMagG, absMagR, absMagI, absMagZ
FROM Photoz

PhotozRF

UPDATE: la table PhotozRF n'existe plus dans la DR12, cf. http://www.sdss.org/dr12/algorithms/photo-z/ :

Data Release 12 includes photometric redshift estimations for all primary photometric measurements tagged as galaxies (i.e. the elements of the GalaxyTag view). The current version features a greatly expanded training set, an updated method of template fitting and a more detailed approach to errors. As opposed to previous releases, we only provide one version of the table, with one estimation technique; in particular, the photozRF table has been discontinued.

-- ThomasBoch - 2015-09-17