=================== Data set 1 =================== Data available: - Abell.catalog: Abell clusters catalogs candidates for Neil & I ASTE observation next week. - SQL Queries on the SDSS database (or SDSS1.csv and SDSS2.csv if it does not work !) Your goal: 1) Find Abell candidates RA, DEC and redshift range. 2) Make a SQL query on the SDSS database: http://cas.sdss.org/astro/en/tools/search/sql.asp to get the list of galaxies within the Abell clusters candidates RA, DEC and redshifts range. Save the SQL query you used somewhere. 3) Find which cluster is in the SDSS strip. Illustrate that. 4) Change the SQL query to focus on the galaxy cluster that is in the SDSS strip. 5) Illustrate the overdensity of galaxies within the cluster compared to field galaxies. 6) Give the radial density profile: dNGal/dR as a function of R and fit a King profile to the density profile. Help & suggestions: - SQL queries take the form: SELECT top 10000 p.objid, p.ra, s.z FROM PhotoObj as p, SpecPhoto as s WHERE p.Objid = s.objid and (p.ra between RaMin and RaMax) and s.z < ZLimit - Explanations: # SELECT top 10000 p.objid, p.ra, s.z --> this line SELECT the FIELDS of the TABLE you want, eg, the data you want. Here for instance we want the RA from table p, the redshift from table s and the ID of the objects from table p # FROM PhotoObj as p, SpecPhoto as s --> this line specify the TABLE FROM where to get the data. Here for instance we query data from the TABLES PhotoObj and SpecPhoto of the database. We just give alias to these table to simplify there names: p and s instead of PhotoObj and SpecPhoto. # WHERE p.Objid = s.objid and (p.ra between RaMin and RaMax) and s.z < ZLimirt --> this line specify the CONSTRAINTS on the data you want. For instance: "p.Objid = s.objid" ensure that your data from the TABLE s and from the TABLE p will concern the same galaxy, "p.ra between RaMin and RaMax" allow to select only object WHERE their RA is < RaMax and > RaMin degree, etc. etc. - Interesting fields: p.objid, p.ra, p.dec, s.z