6dFGS Database - SQL Query

Examples of SQL query box text are given here

Please select your desired options, enter your SQL query (replacing the example query) and then click "Execute SQL". The example query in the textarea below is given as an example, it only selects objects with good quality extra-galactic redshifts that originate from the primary input catalogues (2MASS, DENIS and SuperCOSMOS)

Data Format:	HTML table summary (select number of rows returned below)     CSV File (downloadable, all rows written to CSV file, with HTML table summary on-screen)
CSV Compression:	(none) GZIP
Other Options:	NROWS, Maximum no. of rows to return in HTML table summary (limited to 10,000)     Output RA & DEC as decimal degrees (default is sexagesimal)
TAR saveset:	no yes if yes enter email address below and ensure format=CSV and that targetname is a selected parameter
Email:	only required if requesting a TAR file
SQL Query:	SELECT specid,targetname,obsra,obsdec,z_helio,quality FROM spectra WHERE (quality=3 or quality=4) and progID <=8