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
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'
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