LAMOST ADQL example queries

If you have any question, please email to support(at)china-vo.org

Query LAMOST LRS Catalogue TOP 10

    SELECT TOP 10 * FROM catalogue ORDER BY obsid

Query LAMOST LRS Catalogue with position constraint

    SELECT TOP 10 obsid, ra, dec--, DISTANCE(POINT('ICRS',332.202274,-2.056767), POINT('ICRS',ra, dec)) AS ang_sep
    FROM catalogue 
    WHERE CONTAINS(POINT('ICRS',ra, dec), CIRCLE('ICRS',332.202274,-2.056767, 0.00028))=1

Query LAMOST LRS Catalogue using TAP_UPLOAD in TOPCAT

    SELECT TOP 10 * 
    FROM catalogue c
        JOIN tap_upload.t1 t ON CAST(t.obsid AS INTEGER)=c.obsid