PADC TAPivo://padc.obspm.voparis-rr/tapParis Astronomical Data CentrePADChttp://voparis-srv-paris.obspm.fr/logos/PADC_small.pngPADC support team

77 av. Denfert Rochereau, 75014 Paris, FRANCE

vo.paris@obspm.fr0033140512082virtual-observatoriescatalogsThe PADC TAP Server on voparis-rr.obspm.fr'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: columns, services, tables from the glots schema, obscore from the ivoa schema, alt_identifier, authorities, capability, g_num_stat, interface, intf_param, registries, relationship, res_date, res_detail, resource, res_role, res_schema, res_subject, res_table, stc_spatial, stc_spectral, stc_temporal, subject_uat, table_column, tap_table, validation from the rr schema, columns, groups, key_columns, keys, schemas, tables from the tap_schema schema.http://voparis-rr.obspm.fr/__system__/tap/run/infoIsServiceForGAVO RegTAP Service (Paris Mirror)GloTS, the Global TAP SchemaPADC TAP Server on voparis-rr.obspm.fr Obscore Tablehttp://voparis-rr.obspm.fr/tapGloTS 1.0GloTS 1.0Registry 1.2ADQL2.02.1The Astronomical Data Query Language is the standard IVOA dialect of SQL; it contains a very general SELECT statement as well as some extensions for spherical geometry and higher mathematics.

gavo_getauthority(ivoid TEXT) -> TEXT

returns the authority part of an ivoid (or, more generally a URI). So, ivo://org.gavo.dc/foo/bar#baz becomes org.gavo.dc. The behaviour for anything that's not a full URI is undefined.

gavo_ipix(long REAL, lat REAL) -> BIGINT

gavo_ipix returns the q3c ipix for a long/lat pair (it simply wraps the 13c_ang2ipix function). This is probably only relevant when you play tricks with indices or PPMXL ids.

gavo_match(pattern TEXT, string TEXT) -> INTEGER

gavo_match returns 1 if the POSIX regular expression pattern matches anything in string, 0 otherwise.

gavo_mocintersect(moc1 MOC, moc2 MOC) -> MOC

returns the intersection of two MOCs.

gavo_mocunion(moc1 MOC, moc2 MOC) -> MOC

returns the union of two MOCs.

gavo_specconv(expr DOUBLE PRECISION, dest_unit TEXT) -> DOUBLE PRECISION

returns the spectral value expr converted to dest_unit. expr has to be in either energy, wavelength, or frequency, and dest_unit must be a VOUnit giving another spectral unit (e.g., MHz, keV, nm, or Angstrom). This is intended to let users express spectral constraints in their preferred unit independently of the choice of unit in the database. Examples:: gavo_specconv(obscore.em_min, "keV") > 300 gavo_specconv(obscore.em_max, "MHz") > 30 gavo_specconv(spectral_start, "Angstrom") > 4000 There is a variant of gavo_specconv accepting expr's unit in a third argument.

gavo_specconv(expr NUMERIC, expr_unit TEXT, dest_unit TEXT) -> NUMERIC

returns expr assumed to be in expr_unit expressed in dest_unit. This is a variant of the two-argument gavo_specconv for when the unit of expr is not known to the ADQL translator, either because it because it is a literal or because it does not look like a spectral unit. Examples:: gavo_specconv(656, 'nm', 'J') BETWEEN spectral_start AND spectral_end gavo_specconv(arccos(phi)*incidence, 'Hz', 'eV') Clearly, overriding known units is likely to yield bad results; the translator therefore warns if an existing unit is overridden with a different unit.

gavo_vocmatch(vocname TEXT, term TEXT, matchagainst TEXT) -> INTEGER

returns 1 if matchagainst is term or narrower in the IVOA vocabulary vocname, 0 otherwise. This is intended for semantic querying. For instance, gavo_vocmatch('datalink/core', 'calibration', semantics) would be 1 if semantics is any of calibration, bias, dark, or flat. For RDF-flavoured vocabularies (strict trees), term will expand to the entire branch rooted in term. For SKOS-flavoured vocabularies (where narrower is not transitive), only directly narrower terms will be included. Both the term and the vocabulary name must be string literals (i.e., constants). matchagainst can be any string-valued expression.

ivo_geom_transform(from_sys TEXT, to_sys TEXT, geo GEOMETRY) -> GEOMETRY

The function transforms ADQL geometries between various reference systems. geo can be a POINT, a CIRCLE, or a POLYGON, and the function will return a geometry of the same type. In the current implementation, from_sys and to_sys must be literal strings (i.e., they cannot be computed through expressions or be taken from database columns). All transforms are just simple rotations, which is only a rough approximation to the actual relationships between reference systems (in particular between FK4 and ICRS-based ones). Note that, in particular, the epoch is not changed (i.e., no proper motions are applied). We currently support the following reference frames: ICRS, FK5 (which is treated as ICRS), FK4 (for B1950. without epoch-dependent corrections), GALACTIC. Reference frame names are case-sensitive.

ivo_hashlist_has(hashlist TEXT, item TEXT) -> INTEGER

The function takes two strings; the first is a list of words not containing the hash sign (#), concatenated by hash signs, the second is a word not containing the hash sign. It returns 1 if, compared case-insensitively, the second argument is in the list of words coded in the first argument. The behaviour in case the the second argument contains a hash sign is unspecified.

ivo_hasword(haystack TEXT, needle TEXT) -> INTEGER

gavo_hasword returns 1 if needle shows up in haystack, 0 otherwise. This is for "google-like"-searches in text-like fields. In word, you can actually employ a fairly complex query language; see https://www.postgresql.org/docs/current/textsearch.html for details.

ivo_healpix_center(hpxOrder INTEGER, hpxIndex BIGINT) -> POINT

returns a POINT corresponding to the center of the healpix with the given index at the given order.

ivo_healpix_index(order INTEGER, ra DOUBLE PRECISION, dec DOUBLE PRECISION) -> BIGINT

Returns the index of the (nest) healpix with order containing the spherical point (ra, dec). An alternative, 2-argument form ivo_healpix_index(order INTEGER, p POINT) -> BIGINT is also available.

ivo_histogram(val REAL, lower REAL, upper REAL, nbins INTEGER) -> INTEGER[]

The aggregate function returns a histogram of val with nbins+2 elements. Assuming 0-based arrays, result[0] contains the number of underflows (i.e., val<lower), result[nbins+1] the number of overflows. Elements 1..nbins are the counts in nbins bins of width (upper-lower)/nbins. Clients will have to convert back to physical units using some external communication, there currently is no (meta-) data as lower and upper in the TAP response.

ivo_interval_has(val NUMERIC, iv INTERVAL) -> INTEGER

The function returns 1 if the interval iv contains val, 0 otherwise. The lower limit is always included in iv, behaviour on the upper limit is column-specific.

ivo_interval_overlaps(l1 NUMERIC, h1 NUMERIC, l2 NUMERIC, h2 NUMERIC) -> INTEGER

The function returns 1 if the interval [l1...h1] overlaps with the interval [l2...h2]. For the purposes of this function, the case l1=h2 or l2=h1 is treated as overlap. The function returns 0 for non-overlapping intervals.

ivo_nocasematch(value TEXT, pattern TEXT) -> INTEGER

ivo_nocasematch returns 1 if pattern matches value, 0 otherwise. pattern is defined as for the SQL LIKE operator, but the match is performed case-insensitively. This function in effect provides a surrogate for the ILIKE SQL operator that is missing from ADQL. On this site, this is actually implemented using python's and SQL's LOWER, so for everything except ASCII, your mileage will vary.

ivo_normal_random(mu REAL, sigma REAL) -> REAL

The function returns a random number drawn from a normal distribution with mean mu and width sigma. Implementation note: Right now, the Gaussian is approximated by summing up and scaling ten calls to random. This, hence, is not very precise or fast. It might work for some use cases, and we will provide a better implementation if this proves inadequate.

ivo_simbadpoint(identifier TEXT) -> POINT

gavo_simbadpoint queries simbad for an identifier and returns the corresponding point. Note that identifier can only be a literal, i.e., as simple string rather than a column name. This is because our database cannot query simbad, and we probably wouldn't want to fire off millions of simbad queries anyway; use simbad's own TAP service for this kind of application.

ivo_string_agg(expression TEXT, delimiter TEXT) -> TEXT

An aggregate function returning all values of expression within a GROUP contcatenated with delimiter

ivo_to_jd(d TIMESTAMP) -> DOUBLE PRECISION

The function converts a postgres timestamp to julian date. This is naive; no corrections for timezones, let alone time scales or the like are done; you can thus not expect this to be good to second-precision unless you are careful in the construction of the timestamp.

ivo_to_mjd(d TIMESTAMP) -> DOUBLE PRECISION

The function converts a postgres timestamp to modified julian date. This is naive; no corrections for timezones, let alone time scales or the like are done; you can thus not expect this to be good to second-precision unless you are careful in the construction of the timestamp.

BOX

POINT

CIRCLE

POLYGON

REGION

CENTROID

COORD1

COORD2

DISTANCE

CONTAINS

INTERSECTS

AREA

COALESCE

LOWER

ILIKE

UPPER

OFFSET

CAST

IN_UNIT

WITH

TABLESAMPLE

Written after a table reference, TABLESAMPLE(10) will make the database only use 10% of the rows; these are `somewhat random' in that the system will use random blocks. This should be good enough when just testing queries (and much better than using TOP n).

MOC

A geometry function creating MOCs. It either takes a string argument with an ASCII MOC ('4/13 17-18 8/3002'), or an order and another geometry.

VECTORMATH

You can compute with vectors here. See https://wiki.ivoa.net/twiki/bin/view/IVOA/ADQLVectorMath for an overview of the functions and operators available.

CASE

The SQL92 CASE expression

UNION

EXCEPT

INTERSECT

text/tab-separated-valuestsvtext/plaintxttext/csvcsv_baretext/csv;header=presentcsvapplication/jsonjsonapplication/geo+jsongeojsonapplication/x-votable+xmlvotableapplication/x-votable+xml;serialization=BINARY2votable/b2votableb2application/x-votable+xml;serialization=TABLEDATAtext/xmlvotable/tdvotabletdapplication/x-votable+xml;serialization=TABLEDATA;version=1.1text/xmlvotabletd1.1application/x-votable+xml;version=1.1text/xmlvotable1.1application/x-votable+xml;serialization=TABLEDATA;version=1.2text/xmlvotabletd1.2application/x-votable+xml;serialization=TABLEDATA;version=1.6vodmlapplication/x-votable+xml;version=1.6vodmlbtext/htmlhtmlapplication/fitsfits172800602000020000000500000http://voparis-rr.obspm.fr/__system__/tap/run/capabilitieshttp://voparis-rr.obspm.fr/__system__/tap/run/availabilityhttp://voparis-rr.obspm.fr/__system__/tap/run/tableMetadatahttp://voparis-rr.obspm.fr/__system__/tap/run/examplesrr Tables containing the information in the IVOA Registry. To query these tables, use `our TAP service`_. For more information and example queries, see the `RegTAP specification`_. .. _our TAP service: /__system__/tap/run/info .. _RegTAP specification: http://www.ivoa.net/documents/RegTAP/ivo://ivoa.net/std/regtap#1.2rr.resource The resources (like services, data collections, organizations) present in this registry.xpath:/ivoidUnambiguous reference to the resource conforming to the IVOA standard for identifiers.xpath:identifiercharindexedprimaryres_typeResource type (something like vg:authority, vs:catalogservice, etc).xpath:@xsi:typecharnullablecreatedThe UTC date and time this resource metadata description was created.xpath:@createdcharnullableshort_nameA short name or abbreviation given to something, for presentation in space-constrained fields (up to 16 characters).xpath:shortNamecharindexednullableres_titleThe full name given to the resource.xpath:titleunicodeCharindexednullableupdatedThe UTC date this resource metadata description was last updated.xpath:@updatedcharnullablecontent_levelA hash-separated list of content levels specifying the intended audience.xpath:content/contentLevelcharnullableres_descriptionAn account of the nature of the resource.xpath:content/descriptionunicodeCharindexednullablereference_urlURL pointing to a human-readable document describing this resource.xpath:content/referenceURLcharnullablecreator_seqThe creator(s) of the resource in the order given by the resource record author, separated by semicolons.xpath:curation/creator/nameunicodeCharindexednullablecontent_typeA hash-separated list of natures or genres of the content of the resource.xpath:content/typecharnullablesource_formatThe format of source_value. This, in particular, can be ``bibcode''.xpath:content/source/@formatcharnullablesource_valueA bibliographic reference from which the present resource is derived or extracted.xpath:content/sourceunicodeCharnullableres_versionLabel associated with creation or availablilty of a version of a resource.xpath:curation/versioncharnullableregion_of_regardA single numeric value representing the angle, given in decimal degrees, by which a positional query against this resource should be ``blurred'' in order to get an appropriate match.degxpath:coverage/regionOfRegardfloatnullablewavebandA hash-separated list of regions of the electro-magnetic spectrum that the resource's spectral coverage overlaps with.xpath:coverage/wavebandcharnullablerightsA statement of usage conditions (license, attribution, embargo, etc).xpath:/rightscharnullablerights_uriA URI identifying a license the data is made available under.xpath:/rights/@rightsURIcharnullableharvested_fromIVOID of the registry this record came from.charnullablerr.registriesharvested_fromivoidrr.capability Pieces of behaviour of a resource.xpath:/capability/ivoidThe parent resource.xpath:/identifiercharindexedprimarycap_indexAn arbitrary identifier of this capability within the resource.shortindexedprimarycap_typeThe type of capability covered here. If looking for endpoints implementing a certain standard, you should not use this column but rather match against standard_id.xpath:@xsi:typecharnullablecap_descriptionA human-readable description of what this capability provides as part of the over-all service.xpath:descriptionunicodeCharnullablestandard_idA URI for a standard this capability conforms to.xpath:@standardIDcharnullablerr.resourceivoidivoidrr.tap_table TAP-queriable tables.ivo://ivoa.net/std/regtap#1.2residIVOA identifier of the resource this table was taken from (where there is a dedicated resource containing this table in its tableset, that resource is preferred over a TAP service).charindexednullablesvcidIVOA identifier of the TAP service making this table queriable.charindexednullabletable_nameThe fully qualified name of the table. As per VODataService, this includes all catalog or schema prefixes needed to distinguish it in a query, and it comes with SQL delimiters where necessary.xpath:namecharindexednullabletable_titleA descriptive, human-interpretable name for the table.xpath:titleunicodeCharindexednullabletable_descriptionA free-text description of the table's contents.xpath:descriptionunicodeCharindexednullabletable_utypeAn identifier for a concept in a data model that the data in this table as a whole represent.xpath:utypecharnullablerr.stc_spatial The spatial coverage of resources. This table associates footprints (ADQL geometries) with ivoids. The footprints are intended for resource discovery; a reasonable expectation for the resolution thus is something like a degree.xpath:/coverage/spatialivoidThe parent resource.xpath:/identifiercharindexednullablecoverageA geometry representing the area a resource contains data for; this should be tight at least with a resolution of degrees.posxpath:.charnullableref_system_nameThe reference frame coverage is written in. This is currently reserved and fixed to NULL. Clients should always add a constraint to NULL for this to avoid matching non-celestial resources later.pos.framexpath:@framecharnullablerr.resourceivoidivoidrr.stc_temporal The temporal coverage of resources, given as one or more intervals. The total coverage is (a subset of) the union of all intervals given for a resource. All times are understood as MJD for TDB at the solar system barycenter.xpath:/coverage/temporalivoidThe parent resource.xpath:/identifiercharindexednullabletime_startLower limit of a time interval covered by the resource in MJD.dxpath:.floattime_endUpper limit of a time interval covered by the resource in MJD.dxpath:.floatrr.resourceivoidivoidrr.stc_spectral The spectral coverage of resources, given as one or more intervals. The total coverage is (a subset of) the union of all intervals given for a resource. The spectral values are given as messenger energy.xpath:/coverage/spectralivoidThe parent resource.xpath:/identifiercharindexednullablespectral_startLower limit (in Joules) of messenger energy interval covered by the resource (for the solar system barycenter).Jxpath:.floatspectral_endUpper limit (in Joules) of messenger energy interval covered by the resource (for the solar system barycenter).Jxpath:.floatrr.resourceivoidivoidrr.registries Administrative table: publishing registries we harvest, together with the dates of last full and incremental harvests.ivo://ivoa.net/std/regtap#1.2ivoidIVOID of the registry.charindexedprimaryaccessurlURL of the registry's OAI-PMH endpoint.charnullabletitleName of the registry.unicodeCharnullablelast_full_harvestDate and time of the last full harvest of the registry.charnullablelast_inc_harvestDate and time of the last incremental harvest of the registry.charnullablerr.authorities A mapping between the registries and the authorities they claim to manage.ivo://ivoa.net/std/regtap#1.2ivoidIVOID of the registry.charnullablemanaged_authorityAn authority this registry claims to serve.charindexedprimaryrr.registriesivoidivoidrr.res_role Entities (persons or organizations) operating on resources: creators, contacts, publishers, contributors.ivo://ivoa.net/std/regtap#1.2ivoidThe parent resource.xpath:/identifiercharindexednullablerole_nameThe real-world name or title of a person or organization.unicodeCharindexednullablerole_ivoidAn IVOA identifier of a person or organization.charnullablestreet_addressA mailing address for a person or organization.unicodeCharnullableemailAn email address the entity can be reached at.charnullabletelephoneA telephone number the entity can be reached at.charnullablelogoURL pointing to a graphical logo, which may be used to help identify the entity.charnullablebase_roleThe role played by this entity; this is one of contact, publisher, contributor, or creator.charindexednullablealt_identifierA non-IVOA identifier for the entity, for instance an ORCID or a ROR id. See the RegTAP document for the notations for the various identifier types.charindexednullablerr.resourceivoidivoidrr.res_subject Topics, object types, or other descriptive keywords about the resource.xpath:/content/ivoidThe parent resource.xpath:/identifiercharindexednullableres_subjectTopics, object types, or other descriptive keywords about the resource.xpath:subjectcharindexednullablerr.resourceivoidivoidrr.subject_uat res_subject mapped to the UAT. This is based on a manual mapping of keywords found in 2020, where subjects not mappable were dropped. This is a non-standard, local extension. Don't base your procedures on it, we will tear it down once there is sufficient takeup of the UAT in the VO.ivo://ivoa.net/std/regtap#1.2ivoidThe parent resource.xpath:/identifiercharindexednullableuat_conceptTerm from http://www.ivoa.net/rdf/uat; most of these resulted from mapping non-UAT designations.charindexednullablerr.resourceivoidivoidrr.res_schema Sets of tables related to resources.xpath:/tableset/schema/ivoidThe parent resource.xpath:/identifiercharindexedprimaryschema_indexAn arbitrary identifier for the res_schema rows belonging to a resource.shortindexedprimaryschema_descriptionA free text description of the tableset explaining in general how all of the tables are related.xpath:descriptionunicodeCharnullableschema_nameA name for the set of tables.xpath:name charnullableschema_titleA descriptive, human-interpretable name for the table set.xpath:titleunicodeCharnullableschema_utypeAn identifier for a concept in a data model that the data in this schema as a whole represent.xpath:utypecharnullablerr.resourceivoidivoidrr.res_table (Relational) tables that are part of schemata or resources.xpath:/(tableset/schema/|)table/ivoidThe parent resource.xpath:/identifiercharindexedprimaryschema_indexIndex of the schema this table belongs to, if it belongs to a schema (otherwise NULL).shortnullabletable_descriptionA free-text description of the table's contents.xpath:descriptionunicodeCharnullabletable_nameThe fully qualified name of the table. As per VODataService, this includes all catalog or schema prefixes needed to distinguish it in a query, and it comes with SQL delimiters where necessary.xpath:namecharnullabletable_indexAn arbitrary identifier for the tables belonging to a resource.shortindexedprimarytable_titleA descriptive, human-interpretable name for the table.xpath:titleunicodeCharnullabletable_typeA name for the role this table plays. Recognized values include "output", indicating this table is output from a query; "base_table", indicating a table whose records represent the main subjects of its schema; and "view", indicating that the table represents a useful combination or subset of other tables. Other values are allowed.xpath:@typecharnullabletable_utypeAn identifier for a concept in a data model that the data in this table as a whole represent.xpath:utypecharnullablenrowsAn estimate for the number of rows in the table.xpath:nrowslongnullablerr.resourceivoidivoidrr.table_column Metadata on columns of a resource's tables.xpath:/(tableset/schema/|)/table/column/ivoidThe parent resource.xpath:/identifiercharindexednullabletable_indexIndex of the table this column belongs to.shortnameThe name of the column.xpath:namecharindexednullableucdA unified content descriptor that describes the scientific content of the column.xpath:ucdcharindexednullableunitThe unit associated with all values in the column.xpath:unitcharnullableutypeAn identifier for a role in a data model that the data in this column represents.xpath:utypecharnullablestdIf 1, the meaning and use of this column is reserved and defined by a standard model. If 0, it represents a database-specific column that effectively extends beyond the standard.xpath:@stdshortnullabledatatypeThe type of the data contained in the column.xpath:dataTypecharnullableextended_schemaAn identifier for the schema that the value given by the extended attribute is drawn from.xpath:dataType/@extendedSchemacharnullableextended_typeA custom type for the values this column contains.xpath:dataType/@extendedTypecharnullablearraysizeThe shape of the array that constitutes the value, e.g., 4, *, 4*, 5x4, or 5x*, as specified by VOTable.xpath:dataType/@arraysizecharnullabledelimThe string that is used to delimit elements of an array value when arraysize is not '1'.xpath:dataType/@delimcharnullabletype_systemThe type system used, as a QName with a canonical prefix; this will ususally be one of vs:simpledatatype, vs:votabletype, and vs:taptype.xpath:dataType/@xsi:typecharnullableflagHash-separated keywords representing traits of the column. Recognized values include "indexed", "primary", and "nullable".xpath:flagcharnullablecolumn_descriptionA free-text description of the column's contents.xpath:descriptionunicodeCharindexednullablerr.res_tableivoidivoidtable_indextable_indexrr.g_num_stat An experimental table containing advanced statistics for numeric table columns. This is only available for very few tables at this point. Note that the values reported here may be estimates based on a subeset of the table rows.ivo://ivoa.net/std/regtap#1.2ivoidThe parent resource.xpath:/identifiercharnullabletable_indexIndex of the table this column belongs to.shortnameName of the column (see rr.table_column for more metadata).charindexednullablefill_factorAn estimate for the ratio of non-NULL values in this column to the number of rows in the table.floatnullablemin_valueThe largest value found in the column.floatnullablepercentile03An estimate for the value in the 3rd percentile of the column's distribution (for a Gaussian, roughly the lower limit of a 2σ interval).floatindexednullablemedianAn estimate for the median value (or 50th percentile) of the column's distributionfloatindexednullablepercentile97An estimate for the value in the 97th percentile of the column's distribution (for a Gaussian, roughly the upper limit of a 2σ interval).floatindexednullablemax_valueThe largest value found in the column.floatnullablerr.res_tableivoidivoidtable_indextable_indexrr.res_detail XPath-value pairs for members of resource or capability and their derivations that are less used and/or from VOResource extensions. The pairs refer to a resource if cap_index is NULL, to the referenced capability otherwise.ivo://ivoa.net/std/regtap#1.2ivoidThe parent resource.xpath:/identifiercharindexednullablecap_indexThe index of the parent capability; if NULL the xpath-value pair describes a member of the entire resource.shortnullabledetail_xpathThe xpath of the data item.charnullabledetail_value(Atomic) value of the member.unicodeCharnullablerr.resourceivoidivoidrr.interface Information on access modes of a capability.xpath:/capability/interface/ivoidThe parent resource.xpath:/identifiercharindexedprimarycap_indexThe index of the parent capability.shortindexedintf_indexAn arbitrary identifier for the interfaces of a resource.shortindexedprimaryintf_typeThe type of the interface (vr:webbrowser, vs:paramhttp, etc).xpath:@xsi:typecharnullableintf_roleAn identifier for the role the interface plays in the particular capability. If the value is equal to "std" or begins with "std:", then the interface refers to a standard interface defined by the standard referred to by the capability's standardID attribute.xpath:@rolecharnullablestd_versionThe version of a standard interface specification that this interface complies with. When the interface is provided in the context of a Capability element, then the standard being refered to is the one identified by the Capability's standardID element.xpath:@versioncharnullablequery_typeHash-joined list of expected HTTP method (get or post) supported by the service.xpath:queryTypecharnullableresult_typeThe MIME type of a document returned in the HTTP response.xpath:resultTypecharnullablewsdl_urlThe location of the WSDL that describes this Web Service. If NULL, the location can be assumed to be the accessURL with '?wsdl' appended.xpath:wsdlURLcharnullableurl_useA flag indicating whether this should be interpreted as a base URL ('base'), a full URL ('full'), or a URL to a directory that will produce a listing of files ('dir').xpath:accessURL/@usecharnullableaccess_urlThe URL at which the interface is found.xpath:accessURLcharnullablemirror_urlSecondary access URLs of this interface, separated by hash characters.xpath:mirrorURLcharnullableauthenticated_onlyA flag for whether an interface is available for anonymous use (=0) or only authenticated clients are served (=1).shortsecurity_method_idThis column was mentioned in drafts of RegTAP 1.1 but was abandoned before RegTAP 1.1 REC. Do not use any more. This is just here to avoid a flag day for clients that experimentally used this column. This is always NULL here.not mappedcharnullablerr.capabilityivoidivoidcap_indexcap_indexrr.relationship Relationships between resources (like mirroring, derivation, serving a data collection).xpath:/content/relationship/ivoidThe parent resource.xpath:/identifiercharindexednullablerelationship_typeThe type of the relationship; these terms are drawn from a controlled vocabulary and are DataCite-compatible.xpath:relationshipTypecharnullablerelated_idThe IVOA identifier for the resource referred to.xpath:relatedResource/@ivo-idcharnullablerelated_nameThe name of resource that this resource is related to.xpath:relatedResourcecharnullablerelated_alt_identifierA non-IVOA identifier for the related resource. This will typically be a DOI in URI form (“doi:10...”)xpath:relatedResource/@altIdentifiercharnullablerr.resourceivoidivoidrr.intf_param Input parameters for services.xpath:/capability/interface/param/ivoidThe parent resource.xpath:/identifiercharindexednullableintf_indexThe index of the interface this parameter belongs to.shortnameThe name of the parameter.xpath:namecharnullableucdA unified content descriptor that describes the scientific content of the parameter.xpath:ucdcharnullableunitThe unit associated with all values in the parameter.xpath:unitcharnullableutypeAn identifier for a role in a data model that the data in this parameter represents.xpath:utypecharnullablestdIf 1, the meaning and use of this parameter is reserved and defined by a standard model. If 0, it represents a database-specific parameter that effectively extends beyond the standard.xpath:@stdshortnullabledatatypeThe type of the data contained in the parameter.xpath:dataTypecharnullableextended_schemaAn identifier for the schema that the value given by the extended attribute is drawn from.xpath:dataType/@extendedSchemacharnullableextended_typeA custom type for the values this parameter contains.xpath:dataType/@extendedTypecharnullablearraysizeThe shape of the array that constitutes the value, e.g., 4, *, 4*, 5x4, or 5x*, as specified by VOTable.xpath:dataType/@arraysizecharnullabledelimThe string that is used to delimit elements of an array value when arraysize is not '1'.xpath:dataType/@delimcharnullableparam_useAn indication of whether this parameter is required to be provided for the application or service to work properly (one of required, optional, ignored, or NULL).xpath:@usecharnullableparam_descriptionA free-text description of the parameter's contents.xpath:descriptionunicodeCharnullablerr.interfaceivoidivoidintf_indexintf_indexrr.validationValidation levels for resources and capabilities.xpath:/(capability/|)validationLevelivoidThe parent resource.xpath:/identifiercharindexednullablevalidated_byThe IVOA ID of the registry or organisation that assigned the validation level.xpath:validationLevel/@validatedBycharnullableval_levelA numeric grade describing the quality of the resource description, when applicable, to be used to indicate the confidence an end-user can put in the resource as part of a VO application or research study.xpath:validationLevelshortnullablecap_indexIf non-NULL, the validation only refers to the capability referenced here.shortnullablerr.resourceivoidivoidrr.resourceivoidivoidrr.res_date A date associated with an event in the life cycle of the resource. This could be creation or update. The role column can be used to clarify.xpath:/curation/ivoidThe parent resource.xpath:/identifiercharindexednullabledate_valueA date associated with an event in the life cycle of the resource.xpath:datecharnullablevalue_roleA string indicating what the date refers to, e.g., created, availability, updated. This value is generally drawn from a controlled vocabulary.xpath:date/@rolecharnullablerr.resourceivoidivoidrr.alt_identifier An alternate identifier associated with this record. This can be a resiource identifier like a DOI (in URI form, e.g., doi:10.1016/j.epsl.2011.11.037).xpath:/(curation/creator/|)altIdentifierivoidThe parent resource.xpath:/identifiercharindexednullablealt_identifierAn identifier for the resource or an entity related to the resource in URI form.charindexednullablerr.resourceivoidivoidivoaDefinition and support code for the ObsCore data model and table.ivoa.obscoreThe IVOA-defined obscore table, containing generic metadata for datasets within this data centre.ivo://ivoa.net/std/obscore#table-1.1dataproduct_typeHigh level scientific classification of the data product, taken from an enumerationmeta.code.classobscore:obsdataset.dataproducttypecharnullabledataproduct_subtypeData product specific typemeta.code.classobscore:obsdataset.dataproductsubtypecharnullablecalib_levelAmount of data processing that has been applied to the datameta.code;obs.calibobscore:obsdataset.caliblevelshortobs_collectionName of a data collection (e.g., project name) this data belongs tometa.idobscore:dataid.collectioncharnullableobs_idUnique identifier for an observationmeta.idobscore:DataID.observationIDcharnullableobs_titleFree-from title of the data setmeta.title;obsobscore:dataid.titlecharnullableobs_publisher_didDataset identifier assigned by the publisher.meta.ref.ivoidobscore:curation.publisherdidcharindexednullableobs_creator_didDataset identifier assigned by the creator.meta.idobscore:dataid.creatordidcharnullableaccess_urlThe URL at which to obtain the data set.meta.ref.urlobscore:access.referencecharnullableaccess_formatMIME type of the resource at access_urlmeta.code.mimeobscore:access.formatcharnullableaccess_estsizeEstimated size of data productkbytephys.size;meta.fileobscore:access.sizelongnullabletarget_nameObject a targeted observation targetedmeta.id;srcobscore:Target.Namecharnullabletarget_classClass of the target object (star, QSO, ...)src.classobscore:target.classcharnullables_raRA of (center of) observation, ICRSdegpos.eq.raobscore:char.spatialaxis.coverage.location.coord.position2d.value2.c1doubleindexednullables_decDec of (center of) observation, ICRSdegpos.eq.decobscore:char.spatialaxis.coverage.location.coord.position2d.value2.c2doubleindexednullables_fovApproximate spatial extent for the region covered by the observationdegphys.angSize;instr.fovobscore:char.spatialaxis.coverage.bounds.extent.diameterfloatnullables_regionRegion covered by the observation, as a polygonpos.outline;obs.fieldobscore:char.spatialaxis.coverage.support.areacharnullables_resolutionBest spatial resolution within the data setarcsecpos.angResolutionobscore:Char.SpatialAxis.Resolution.refval.valuefloatnullablet_minLower bound of times represented in the data setdtime.start;obs.exposureobscore:char.timeaxis.coverage.bounds.limits.starttimedoublenullablet_maxUpper bound of times represented in the data setdtime.end;obs.exposureobscore:char.timeaxis.coverage.bounds.limits.stoptimedoublenullablet_exptimeTotal exposure timestime.duration;obs.exposureobscore:char.timeaxis.coverage.support.extentfloatnullablet_resolutionMinimal significant time interval along the time axisstime.resolutionobscore:char.timeaxis.resolution.refval.valuefloatnullableem_minMinimal wavelength represented within the data setmem.wl;stat.minobscore:char.spectralaxis.coverage.bounds.limits.lolimitfloatnullableem_maxMaximal wavelength represented within the data setmem.wl;stat.maxobscore:char.spectralaxis.coverage.bounds.limits.hilimitfloatnullableem_res_powerSpectral resolving power lambda/delta lambdaspect.resolutionobscore:char.spectralaxis.resolution.resolpower.refvalfloatnullableo_ucdUCD for the product's observablemeta.ucdobscore:char.observableaxis.ucdcharnullablepol_statesList of polarization states in the data setmeta.code;phys.polarizationobscore:Char.PolarizationAxis.stateListcharnullablefacility_nameName of the facility at which data was takenmeta.id;instr.telobscore:Provenance.ObsConfig.facility.namecharnullableinstrument_nameName of the instrument that produced the datameta.id;instrobscore:Provenance.ObsConfig.instrument.namecharnullables_xel1Number of elements (typically pixels) along the first spatial axis.meta.numberobscore:Char.SpatialAxis.numBins1intnullables_xel2Number of elements (typically pixels) along the second spatial axis.meta.numberobscore:Char.SpatialAxis.numBins2intnullablet_xelNumber of elements (typically pixels) along the time axis.meta.numberobscore:Char.TimeAxis.numBinsintnullableem_xelNumber of elements (typically pixels) along the spectral axis.meta.numberobscore:Char.SpectralAxis.numBinsintnullablepol_xelNumber of elements (typically pixels) along the polarization axis.meta.numberobscore:Char.PolarizationAxis.numBinsintnullables_pixel_scaleSampling period in world coordinate units along the spatial axisarcsecphys.angSize;instr.pixelobscore:Char.SpatialAxis.Sampling.RefVal.SamplingPeriodfloatnullableem_ucdNature of the product's spectral axis (typically, em.freq, em.wl, or em.energy)meta.ucdobscore:Char.SpectralAxis.ucdcharnullablepreviewURL of a preview (low-resolution, quick-to-retrieve representation) of the data.meta.ref.url;meta.previewcharnullablesource_tableName of a TAP-queriable table this data originates from. This source table usually provides more information on the the data than what is given in obscore. See the TAP_SCHEMA of the originating TAP server for details.meta.id;meta.tablecharnullabletap_schema PADC TAP Server on voparis-rr.obspm.fr's Table Access Protocol (TAP) service with table metadata.tap_schema.tablesTables available for ADQL querying.schema_nameFully qualified schema namecharnullabletable_nameFully qualified table namecharindexedprimarytable_typeOne of: table, viewcharnullabledescriptionBrief description of the tableunicodeCharnullableutypeutype if the table corresponds to a data modelcharnullabletable_indexSuggested position this table should take in a sorted list of tables from this data centerintnullablesourcerdId of the originating rd (local information)charnullablenrowsThe approximate size of the table in rowslongnullabletap_schema.schemasschema_nameschema_nametap_schema.columnsColumns in tables available for ADQL querying.table_nameFully qualified table namecharindexedprimarycolumn_nameColumn namecharindexedprimarydescriptionBrief description of columnunicodeCharnullableunitUnit in VO standard formatcharnullableucdUCD of column if anycharnullableutypeUtype of column if anycharnullabledatatypeADQL datatypecharnullablearraysizeArraysize in VOTable notationcharnullablextypeVOTable extended type information (for special interpretation of data content, e.g., timestamps or points)charnullable"size"Legacy length (ignore if you can).intnullableprincipalIs column principal?intindexedIs there an index on this column?intstdIs this a standard column?intsourcerdId of the originating rd (local information)charnullablecolumn_index1-based index of the column in database order.shortnullabletap_schema.tablestable_nametable_nametap_schema.schemasSchemas containing tables available for ADQL querying.schema_nameFully qualified schema namecharindexedprimarydescriptionBrief description of the schemaunicodeCharnullableutypeutype if schema corresponds to a data modelcharnullableschema_indexSuggested position this schema should take in a sorted list of schemas from this data center.intnullabletap_schema.keysForeign key relationships between tables available for ADQL querying.key_idUnique key identifiercharindexedprimaryfrom_tableFully qualified table namecharnullabletarget_tableFully qualified table namecharnullabledescriptionDescription of this keyunicodeCharnullableutypeUtype of this keycharnullablesourcerdId of the originating rd (local information)charnullabletap_schema.tablesfrom_tabletable_nametap_schema.tablestarget_tabletable_nametap_schema.key_columnsColumns participating in foreign key relationships between tables available for ADQL querying.key_idKey identifier from TAP_SCHEMA.keyscharnullablefrom_columnKey column name in the from tablecharnullabletarget_columnKey column in the target tablecharnullablesourcerdId of the originating rd (local information)charnullabletap_schema.keyskey_idkey_idtap_schema.groupsColumns that are part of groups within tables available for ADQL querying.table_nameFully qualified table namecharnullablecolumn_nameName of a column belonging to the groupcharnullablecolumn_utypeutype the column within the groupcharnullablegroup_nameName of the groupcharnullablegroup_utypeutype of the groupcharnullablesourcerdId of the originating rd (local information)charnullabletap_schema.tablestable_nametable_nameglots The global TAP schema collects information on tables and columns from known TAP servers. This facilitates locating queriable data by physics (via UCD) or keywords (via description). Note that this shouldn't really be necessary as all information present here should be exposed through Registry records. However, in reality data providers currently are much more liable to give column metadata in their tap_schema than in their Registry records. Hence, for the time being, we maintain this service by harvesting tap_schemas about monthly.glots.servicesA table of TAP services harvested from the registry (and some spoon-fed).ivoidIVOA identifier of providing servicecharindexedprimaryaccessurlBase URL of TAP endpointcharnullablenextharvestNext scheduled harvest of datacharnullableharvestintervalApproximate interval of harvestdintnullablelastsuccessLast successful harvest of this servicecharnullableglots.tablesA table of tables accesible through the TAP services known to glots.services.ivoidIVOA identifier of providing servicecharindexedprimarytable_nameFully qualified table namecharindexedprimarytable_descBrief description of the tableunicodeCharindexednullableutypeutype if the table corresponds to a data modelcharnullableglots.servicesivoidivoidglots.columnsA table of columns within the tables listed in glots.tables.ivoidIVOA identifier of providing servicecharindexedprimarytable_nameFully qualified table namecharindexedprimarycolumn_nameColumn namecharindexedprimarydescriptionBrief description of columncharindexednullableunitUnit in VO standard formatcharnullableucdUCD of column (some services still have 1.0 UCDs).charindexednullableutypeUtype of columncharnullabledatatypeADQL datatypecharnullable"size"Length of variable length datatypesintnullableprincipalIs column principal?charnullableindexedIs there an index on this column?intnullablestdIs this a standard column?charnullableglots.tablesivoidivoidtable_nametable_name