search

thespacedoctor / sherlock

The QUB Transient Classifier
GNU General Public License v3.0
11 stars 5 forks source link

Spurious Redshifts in SDSS Spectroscopic catalogue #148

Closed thespacedoctor closed 2 years ago

thespacedoctor commented 2 years ago

I have found ~15,000 'galaxies' in the SDSS spectroscopic catalogue with a redshift z < 0.0001. Inspecting some of them, I generally find little or no spectral coverage.

Photometric classifications are typically 'star', and they look stellar in the images, but the spectral classifications are 'galaxy'.

http://skyserver.sdss.org/dr12/en/tools/explore/Summary.aspx?id=1237672815974351224 http://skyserver.sdss.org/dr12/en/tools/explore/Summary.aspx?id=1237671696598174297

I am going to hide these sources in the database so that Sherlock will not match them in the spectroscopic catalogue (it will find them in the photometric catalogue correctly labelled as stars).

thespacedoctor commented 2 years ago

Fixed in the QUB database now.

I added the following to the 'where' clauses of tcs_view_qso_sdss_spect_galaxies_qsos_dr12 and tcs_view_galaxy_sdss_spect_galaxies_qsos_dr12:

AND (`tcs_cat_sdss_spect_galaxies_qsos_dr12`.`z_` > 0.001))

I need to do the same for the Lasair databases.

thespacedoctor commented 2 years ago

Views have now been updated across ROE and Sommerville instances of the Sherlock database.