Information on resource '__system__/tap'

Services defined within this resource descriptor

• CeSAM Virtual Observatory Server TAP service

  The CeSAM Virtual Observatory Server's TAP end point. The Table Access Protocol (TAP) lets you execute queries against our database tables, inspect various metadata, and upload your own data. It is thus the VO's premier way to access public data holdings.

  Tables exposed through this endpoint include: main from the aspic_6df schema, g02, g09g12g15 from the aspic_gama schema, main from the aspic_muse_wide schema, w1, w1_video, w4 from the aspic_vipers schema, cosmos, ecdfs from the aspic_vuds schema, catalogue, spectra from the el_cosmos_dr1 schema, spectra from the gama_dr3 schema, obscore from the ivoa schema, spectra from the muse_wide_dr1 schema, bolshoi2022, uchuu2022 from the sides schema, columns, groups, key_columns, keys, schemas, tables from the tap_schema schema, spectra from the vipers_dr2 schema, spectra from the vuds_dr1 schema, spectra from the zcosmos_20k schema.

Tables defined within this resource descriptor

• tap_schema.columns – queryable through TAP and ADQL

  Columns in tables available for ADQL querying.

• tap_schema.groups – queryable through TAP and ADQL

  Columns that are part of groups within tables available for ADQL querying.

• tap_schema.key_columns – queryable through TAP and ADQL

  Columns participating in foreign key relationships between tables available for ADQL querying.

• tap_schema.keys – queryable through TAP and ADQL

  Foreign key relationships between tables available for ADQL querying.

• tap_schema.schemas – queryable through TAP and ADQL

  Schemas containing tables available for ADQL querying.

• tap_schema.supportedmodels

  Standard data models supported by this service.

  This is a non-standard tap_schema table used by DaCHS in the creation of registry records. It is manipulated through gavo imp on tables with supportsModel and supportsModelURI properties.

• tap_schema.tables – queryable through TAP and ADQL

  Tables available for ADQL querying.

• tap_schema.tapjobs

  A non-standard (and not tap-accessible) table used for managing asynchronous TAP jobs. It is manipulated through TAP job creation and destruction internally. Under very special circumstances, operators can use the gavo admin cleantap command to purge jobs from this table.

  Note that such jobs have corresponding directories in $STATEDIR/uwsjobs, which will be orphaned if this table is manipulated through SQL.

[Manage RD]