nsc_dr1.meas table is missing from the TAP service

Question

Dear whom it may concern, the nsc_dr1.meas table is missing from the TAP service. Thank you very much!

Answer 1

Thank you for pointing that out to us.  It is updated now.  Let us know if you have any other issues.

Comments

Hi Adam, many thanks for the update. However, now the table is there but no columns (I'm using TOPCAT). Could you check it please? Thanks~

---

Glad you found this!  It is ready now.  Descriptions will be updated later.  Let me know if there are any questions.

---

Hi Adam, thanks very much! Also, I'm just wondering is there any way to crossmatch nsc_dr1.meas table with a list of known targets? I have a list of ~20,000 targets which needs time-series data. However, the upload option is unavailable for the TAP service. For now, I try to download all time-series data for the whole region (~100 deg^2) with some constraint parameters. But it would be great if there is an easier way to work around. Many thanks!

---

Hi deepeyesym,

if you start a Jupyter notebook and run

from dl.helpers.crossmatch import xmatch
help(xmatch)

That should get you started until we get the new feature in place to upload your target list.

(edit): That is for local data only and not for a xmatch on the database.  Looking for alternatives...

For right now, if you do a cone search per object, it should take about 3 hours for 20,000.    See the example in the link on how to perform a cone search query: https://datalab.noao.edu/docs/manual/Appendices/ExampleQueries/ExampleQueries.html?highlight=cone%20search

Hope this helps.