Aug 9, 2012

Two SDSS data pulls around Pal5

/home/ch558/palomar5/sdss_result.csv
proper motions
ra, dec, psfmag_g, gmr, pm_ra, pm_dec, pm_ra_err, pm_dec_err
pulled with web interface


/home/ch558/palomar5/sdss_pal5_fehz.csv
Fe/H and z redshift
elodieFeH, elodieZ, elodieZErr, z, zErr, ra, dec, g, r
pulled with SQL, i.e.:


SELECT s.ra, s.dec, s.psfmag_g, (s.psfmag_g - s.psfmag_r) as gmr,
    pm.pmra, pm.pmdec, pm.pmraerr, pm.pmdecerr
FROM star s
    JOIN propermotions pm ON s.objid = pm.objid 
WHERE 
   s.ra BETWEEN 239.38 AND 243.38
   AND s.dec BETWEEN 5.2 AND 7.2
   AND CLEAN=1



Both data files cover the same areas, as suggested by Nitya: Combined separate queries +/- 2 degrees in RA, and +/- 1 degree in Dec around the following pointings:
    RA      DEC
1) 226.5, -2.5
2) 228.36, -0.66
3) 230.22, 0.75
4) 232.08, 2
5) 233.94, 3.2
6) 239.52, 5.9
7) 241.38, 6.2

No comments: