0 votes
12 views
I would like to retrieve rows after doing a database join between the nsc_dr1.object and nsc_dr1.nsc_allwise tables.

Do any of the fields in the nsc_dr1.nsc_allwise table give the index of the corresponding object in the nsc_dr1.object table, or do I have to do a sphere match?

Thanks,
asked May 7 by dwelly (120 points) | 12 views

1 Answer

0 votes
The nsc_dr1.nsc_allwise 'id' column us the nsc_dr1.object 'id' value, and likewise the 'coadd_id' and 'source_id' columns are the matched rows from AllWISE.  Each of these columns is indexed in both parents and the 'nsc_allwise' crossmatch table and so you could do a simply JOIN (depending on your query) on these values.  The index-value/row-number is not stored in the tables.
answered May 7 by datalab (2,990 points)
Thanks for the help.

Note that when accessing these tables in Topcat (v4.5-1) via http://datalab.noao.edu/tap, the  'id'  column of the nsc_dr1.object table is presented as a CHAR[1] whereas it should presumably be a CHAR[16].

Things became much clearer when I used the datalab query interface,
http://datalab.noao.edu/query.php?name=nsc_dr1.object

Thanks again.
Tom
Thanks for pointing that out.  The column width is correct is database for nsc_dr1.object.id, however the 'tap_schema' tables that describe the tables for TAP clients such as TOPCAT only had this listed as a single char.  This has been fixed, you should see the full width now after reloading TOPCAT.

78 questions

61 answers

9 comments

126 users

Welcome to Data Lab Help Desk, where you can ask questions and receive answers from other members of the community.