0 votes
48 views
I'm trying to crossmatch a table with the DECAPS DR1, and it always hangs and after a while it gives an error saying "Query timeout at 300 sec".

My table has 234.705 sources. I selected the following options;

Step 1: Table name; ra; dec; All

Step 2: Datalab table; decaps_dr1; decaps_dr1.object; ra_ok; dec_ok; All

Step 3: Table name; radius 1 arcs; Nearest neighbor; download results to your computer only

I tried with a shorter table that you can find attached here, and the result was exactly the same.

--------------------------------------------------------------------------------------------------------------------------------------------

ra,dec,dis,Z,Z_err,Y,Yerr,J,J_err,H,H_err,Ks,Ks_err
174.43362,-63.07945,3914.94,18.735,0.025,18.219,0.032,17.533,0.024,16.959,0.026,16.62,0.077
174.44731,-63.05888,3914.91,17.854,0.013,17.033,0.012,16.33,0.012,15.715,0.013,15.409,0.035
174.45502,-63.0476,3914.89,17.782,0.012,17.258,0.018,16.71,0.01,16.231,0.017,16.034,0.042
174.4183,-63.10342,3914.95,17.397,0.011,16.693,0.01,16.013,0.011,15.476,0.01,15.175,0.027
174.50237,-62.97621,3914.82,17.847,0.012,17.432,0.016,16.855,0.012,16.177,0.014,15.939,0.043
174.48206,-63.00709,3914.85,16.808,0.006,16.37,0.009,15.811,0.009,15.235,0.009,15.005,0.02
174.41608,-63.10722,3914.94,18.047,0.014,17.615,0.021,17.12,0.017,16.55,0.017,16.34,0.062
174.47408,-63.01974,3914.85,17.809,0.013,17.332,0.015,16.783,0.01,16.293,0.015,16.13,0.055
174.51382,-62.95948,3914.79,19.119,0.031,18.552,0.039,17.944,0.022,17.334,0.034,17.002,0.122

--------------------------------------------------------------------------------------------------------------------------------------------

Thanks in advance for the help!!

Andrea
asked Jan 29 by andreacmejiasa (120 points) | 48 views
In the drop-down it's listing ra_ok as a potential column and it should not.  Please use ra and dec instead until we tweak these.  

Thank you for your patience.

1 Answer

0 votes

The xmatch tool on the website has a time limit of 300 seconds. If you need to do the xmatch with big table, please use the notebook server(https://gp02.datalab.noao.edu/hub/login), you can find an example notebook for xmatch (How_to_crossmatch_tables.ipynb) there.

answered Jan 29 by datalab (8,420 points)

190 questions

187 answers

168 comments

1,326 users

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