Examples for Hubble Source Catalog TAP service

Query with ADQL geometry

The main table in the Hubble Source Catalog (v3) indexed for geometric queries in TAP is the materialized view dbo.SumMagAper2CatView. The columns used for RA and Dec are MatchRA and MatchDec, respectively.

            SELECT TOP 10 * FROM dbo.SumMagAper2CatView
            WHERE CONTAINS(POINT('ICRS', MatchRA, MatchDec),CIRCLE('ICRS',129.23,7.95,.1))=1
          

Query with time filters and ADQL geometry

The main table in the Hubble Source Catalog (v3) indexed for geometric queries in TAP is the materialized view dbo.SumMagAper2CatView. The columns used for RA and Dec are MatchRA and MatchDec, respectively. We can also filter our query with other clauses that do not relate to geometry.

            SELECT TOP 10 * FROM dbo.SumMagAper2CatView
            WHERE CONTAINS(POINT('ICRS', MatchRA, MatchDec),CIRCLE('ICRS',129.23,7.95,.1))=1
            and dbo.SumMagAper2CatView.StartTime > '2015-01-01' AND dbo.SumMagAper2CatView.StopTime < '2015-04-01'
          

Query on the Hubble Catalog of Variables with ADQL geometry

The view in Hubble Source Catalog (v3) for the Hubble Catalog of Variables indexed for geometric queries in TAP is dbo.HCVsummaryView. The columns used for RA and Dec are RA and Dec, respectively. We can also filter our query with other clauses that do not relate to geometry.


            SELECT TOP 10 * FROM dbo.HCVsummaryView
            WHERE CONTAINS(POINT('ICRS', RA, Dec),CIRCLE('ICRS',3.584,-30.383,.1))=1