Examples for the Common Archive Observation Model TAP service at STScI

Query for Webb First Images: NGC 3324 (Carina)

The Webb First Image data is available for download via this service. The following query gives metadata and access URLs for public data for program 2731, targeting NGC 3324, Carina nebula.

				select obspointing.*, access_url
				from obspointing natural join ivoa.obscore
				where
				obs_collection = 'JWST'
				and dataRights = 'PUBLIC'
				and proposal_id = 2731
				order by calib_level, obs_id
          

Query for Webb First Images: Stephan's Quintet

The Webb First Image data is available for download via this service. The following query gives metadata and access URLs for public data for program 2732, Stephan's Quintet

				select obspointing.*, access_url
				from obspointing natural join ivoa.obscore
				where
				obs_collection = 'JWST'
				and dataRights = 'PUBLIC'
				and proposal_id = 2732
				order by calib_level, obs_id
          

Query for Webb First Images: NGC 3132 (Southern Ring Nebula)

The Webb First Image data is available for download via this service. The following query gives metadata and access URLs for public data for program 2733, NGC 3132 (Southern Ring Nebula)

				select obspointing.*, access_url
				from obspointing natural join ivoa.obscore
				where
				obs_collection = 'JWST'
				and dataRights = 'PUBLIC'
				and proposal_id = 2733
				order by calib_level, obs_id
          

Query for JWST Early Release Observations: WASP-96 b and HAT-P-18 b exoplanets

JWST Early Release Observation data is available for download via this service. The following query gives metadata and access URLs for public data for program 2734, WASP-96 b and HAT-P-18 b exoplanets

				select obspointing.*, access_url
				from obspointing natural join ivoa.obscore
				where
				obs_collection = 'JWST'
				and dataRights = 'PUBLIC'
				and proposal_id = 2734
				order by calib_level, obs_id
          

Query for Webb First Images: SMACS 0723 galaxy lensing cluster ("JWST Deep Field")

The Webb First Image data is available for download via this service. The following query gives metadata and access URLs for public data for program 2736, SMACS 0723 galaxy lensing cluster ("JWST Deep Field")

				select obspointing.*, access_url
				from obspointing natural join ivoa.obscore
				where
				obs_collection = 'JWST'
				and dataRights = 'PUBLIC'
				and proposal_id = 2736
				order by calib_level, obs_id
          

Query on ivoa.obscore with ADQL geometry

The Table Access Protocol Service for CAOM at STScI allows geometric queries with two tables. The first is the standard ivoa.obscore, which is in actuality a materialized view of other CAOM components. For querying to obscore, a special format is used as described in the IVOA Obscore Standard Document.

            SELECT * FROM ivoa.obscore
            WHERE CONTAINS(POINT('ICRS', 16.0, 40.0),s_region)=1
          

Query on dbo.ObsPointing with ADQL geometry

The ObsPointing view is the same as used by the MAST portal and API, which may be familiar to many users. The columns "s_ra" and "s_dec" are used for RA and Dec, respectively.

            SELECT TOP 10 *
            FROM dbo.obspointing o
            WHERE CONTAINS(POINT('ICRS',o.s_ra,o.s_dec),CIRCLE('ICRS',129.23,7.95,1))=1
          

Query for access URLs with ADQL polygon footprint

The CAOM database and its obscore view contain TESS footprints for full-frame images. One can search for the footprints based on naming conventions with sector, camera, and chip information. Once the footprint is found, CAOM holdings from TESS and other missions can be found using the polygonal footprint stored in the database. Here we're pulling up the related full-frame images and download information for them.

                SELECT top 1 obs_id, access_url, access_format, access_estsize, s_region
                FROM ivoa.obscore
                WHERE obs_collection = 'TESS' and
                dataproduct_type = 'image' and target_name = 'FIELD' and
                CONTAINS(POINT('ICRS',s_ra,s_dec),POLYGON('ICRS', 330.38144700, -44.39669600, 324.98193300, -33.40896600, 337.79557200, -28.35517500, 344.63253800, -38.64027600))=1