ALMA ObsCore /examples

Query for ObsCore data by Project Code

                select * from ivoa.obscore where proposal_id = '2011.0.00004.E'
            

Query for ObsCore data by partial Project Code

                select * from ivoa.obscore where proposal_id like '2013%'
            

Note: URL encode the % to be %25 when using with command line tools such as cURL, or send it through a service like this ↗Encoder/Decoder.

Query for ObsCore data by Spatial Functions

When querying against geometric columns, in particular coverage, use ↗ADQL's CONTAINS or INTERSECTS functions.

                select distinct member_ous_uid
                from ivoa.obscore
                where INTERSECTS(CIRCLE('ICRS',168.1155600,-76.739526,0.001), s_region) = 1
            

List all schema table and column information

                select t.schema_name, c.table_name, c.column_name
                from TAP_SCHEMA.columns c JOIN TAP_SCHEMA.tables t on t.table_name = c.table_name