X-match with DECAPS DR1 gives an Error: Query timeout at 300 sec

Question

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

Comments

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.

Answer 1

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.