Legacy Surveys DR11 Column Name Incorrect

Question

The LS DR11 tractor catalog 'type' column contains catalog identifiers (ie. 'G3'), while 'ref_cat' contains the morphological information (ie. 'PSF', 'DUP', etc.). This disagrees with the format used in the other tractor catalogs and the catalog column name description (they should be swapped I believe). I have not checked if any other column names are misaligned.

This can problem can be seen with a simple query like:

SELECT t.ref_cat, t.type

FROM ls_dr11.tractor AS t

WHERE t.brick_primary = 1 AND q3c_radial_query(t.ra, t.dec, 300,1,0.03)

Answer 1

Hello,
Thank you for reporting this.
We've noticed it a while ago and the table ls_dr11.tractor is being fixed, but not ready yet.
This occurs on Southern sources ONLY, i.e. coming from tractor_s. The tractor_s table is fixed already.
In the mean time, you want to consider the following within your SQL queries when using the tractor table:
ref_cat = type, type = ref_cat WHERE release = 11010
That is the key to know what sources are from tractor_s within tractor.

I hope this helps!
Best,
David