0 votes
122 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, 2020 by andreacmejiasa (160 points) | 122 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, 2020 by datalab (11,520 points)

261 questions

264 answers

304 comments

1,747 users

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