AIP GAVO TAPivo://aip.gavo.org/tapGAVO at Leibniz-Institute for Astrophysics PotsdamThe GAVO data center teamhttp://vo.ari.uni-heidelberg.de/docs/GavoTiny.pngHarry Enke

Leibnitz-Institut fr Astrophysik

henke@aip.de++49 6221 541837virtual-observatoriescatalogsThe AIP DaCHS'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: dens256, fof, redshifts from the bolshoi schema, columns, services, tables from the glots schema, fof, fofmtree, fofparticles, particles85, redshifts, treesnapnums from the mdr1 schema, rave_dr4 from the ravedr4 schema, alt_identifier, authorities, capability, g_num_stat, interface, intf_param, registries, relationship, res_date, res_detail, res_role, res_schema, res_subject, res_table, resource, 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://gavo.aip.de/__system__/tap/run/infoIsServiceForGAVO RegTAP Service (Potsdam mirror)GloTS, the Global TAP SchemaAIP DaCHS Obscore Tablehttp://gavo.aip.de/tapRegistry 1.2GloTS 1.0ADQL2.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/fitsfits1728003600200002000000020000000http://gavo.aip.de/__system__/tap/run/availabilityhttp://gavo.aip.de/__system__/tap/run/capabilitieshttp://gavo.aip.de/__system__/tap/run/tableMetadatahttp://gavo.aip.de/__system__/tap/run/examplestap_schema AIP DaCHS'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_namerr 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.resourceivoidivoidbolshoi This is an extract of the Bolshoi simulation data. It is used for testing and demonstration purposes only. The full data is available at https://www.cosmosim.org/.bolshoi.dens256Densities for 256^3 grid cells; for some snapnumswebidunique id for the entry in the database table, corresponds to the line number in the original file, starting with 0 at first linemeta.idlongindexedprimaryixspatial grid index, x-direction; ix= floor(x/nx); multiply/divide by factors of 2 when comparing with a finer/coarser gridpos.cartesian.xintindexediyspatial grid index, y-direction; iy = floor(y/ny)pos.cartesian.yintindexedizspatial grid index, z-direction; iz = floor(z/nz)pos.cartesian.zintindexedphkeyPeano-Hilbert key; multiply/divide by factors of 8 when comparing with a finer/coarser gridintindexeddensoverdensity, dens = (rho - rho_b)/rho_b, rho_b = mean background density of matterphys.density;arith.ratiofloatindexedsnapnumunique id for the entry in the database table, corresponds to the line number in the original file, starting with 0 at first linetime.epochintbolshoi.fofFriends-of-Friends halo catalogue, level 0 with relative linking length 0.17fofidunique id for FOF-groupmeta.id;meta.mainlongindexedprimarysnapnumnumber of snapshot; look into redshifts-table to find the corresponding redshifttime.epochshortindexedlevellevel of substructure, indicates the different linking lengthsshortninfileline number of FOF-group in original catalogue file (= rank in file)meta.idintxcomoving position, x-componenth-1.Mpcpos.cartesian.xdoubleycomoving position, y-componenth-1.Mpcpos.cartesian.ydoublezcomoving position, z-componenth-1.Mpcpos.cartesian.zdoublevxpeculiar velocity, x-componentkm/sphys.veloc;pos.cartesian.xdoublevypeculiar velocity, y-componentkm/sphys.veloc;pos.cartesian.ydoublevzpeculiar velocity, z-componentkm/sphys.veloc;pos.cartesian.zdoublenpnumber of particles inside the FOF group ('halo')meta.numberintmasstotal mass of the FOF grouph-1.solMassphys.massdoubleindexedsize'radius' of the FOF group, if it were a sphere, computed based on the volumeh-1.Mpcphys.size.radiusdoubledispdispersionh-1.Mpcphys.dispMeasuredoubledisp_vvelocity dispersionkm/sphys.veloc.dispersiondoubledeltaoverdensity (mass/volume) in terms of mean background density rho_bphys.density;arith.ratiodoublespinspin parameter (Gottloeber and Yepes 2007, ApJ 664, 117)doubleangmom_xangular momentum, x-componenth-2.solMass.Mpc.km/sphys.angMomentum;pos.cartesian.xdoubleangmom_yangular momentum, y-componenth-2.solMass.Mpc.km/sphys.angMomentum;pos.cartesian.ydoubleangmom_zangular momentum, z-componenth-2.solMass.Mpc.km/sphys.angMomentum;pos.cartesian.zdoubleangmomabsolute value of angular momentumh-2.solMass.Mpc.km/sphys.angMomentumdoubleaxis1major axis of the ellipsoidal shape, not normalizeddoubleaxis2intermediate axis of the ellipsoidal shape, not normalizeddoubleaxis3minor axis of the ellipsoidal shape, not normalizeddoubleaxis1_xdirection of major axis, unit eigenvector of the inertia tensor, x-componentdoubleaxis1_ydirection of major axis, y-componentdoubleaxis1_zdirection of major axis, z-componentdoubleaxis2_xdirection of intermediate axis, unit eigenvector of the inertia tensor, x-componentdoubleaxis2_ydirection of intermediate axis, y-componentdoubleaxis2_zdirection of intermediate axis, z-componentdoubleaxis3_xdirection of minor axis, unit eigenvector of the inertia tensor, x-componentdoubleaxis3_ydirection of minor axis, y-componentdoubleaxis3_zdirection of minor axis, z-componentdoubleixspatial index, x-directionpos.cartesian.xintiyspatial index, y-directionpos.cartesian.yintizspatial index, z-directionpos.cartesian.zintphkeyPeano-Hilbert keyintindexedbolshoi.redshiftsRedshifts for snapshot numberssnapnumsnapshot numbertime.epochshortindexedprimaryaexpexpansion factor of the universetime.epochfloatzredcorresponding redshifttime.epochfloatglots 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_namemdr1 This is an extract of the MultiDark Run 1 simulation data. It is used for testing and demonstration purposes only. The full data is available at https://www.cosmosim.org/.mdr1.fofFriends-of-Friends halo catalogue, level 0 with relative linking length 0.17fofidunique id for FOF-groupmeta.id;meta.mainlongindexedprimarysnapnumnumber of snapshot; look into redshifts-table to find the corresponding redshifttime.epochshortindexedlevellevel of substructure, indicates the different linking lengthsshortninfileline number of FOF-group in original catalogue file (= rank in file)meta.idintxcomoving position, x-componenth-1.Mpcpos.cartesian.xdoubleycomoving position, y-componenth-1.Mpcpos.cartesian.ydoublezcomoving position, z-componenth-1.Mpcpos.cartesian.zdoublevxpeculiar velocity, x-componentkm/sphys.veloc;pos.cartesian.xdoublevypeculiar velocity, y-componentkm/sphys.veloc;pos.cartesian.ydoublevzpeculiar velocity, z-componentkm/sphys.veloc;pos.cartesian.zdoublenpnumber of particles inside the FOF group ('halo')meta.numberintmasstotal mass of the FOF grouph-1.solMassphys.massdoubleindexedsize'radius' of the FOF group, if it were a sphere, computed based on the volumeh-1.Mpcphys.size.radiusdoubledispdispersionh-1.Mpcphys.dispMeasuredoubledisp_vvelocity dispersionkm/sphys.veloc.dispersiondoubledeltaoverdensity (mass/volume) in terms of mean background density rho_bphys.density;arith.ratiodoublespinspin parameter (Gottloeber and Yepes 2007, ApJ 664, 117)doubleangmom_xangular momentum, x-componenth-2.solMass.Mpc.km/sphys.angMomentum;pos.cartesian.xdoubleangmom_yangular momentum, y-componenth-2.solMass.Mpc.km/sphys.angMomentum;pos.cartesian.ydoubleangmom_zangular momentum, z-componenth-2.solMass.Mpc.km/sphys.angMomentum;pos.cartesian.zdoubleangmomabsolute value of angular momentumh-2.solMass.Mpc.km/sphys.angMomentumdoubleaxis1major axis of the ellipsoidal shape, not normalizeddoubleaxis2intermediate axis of the ellipsoidal shape, not normalizeddoubleaxis3minor axis of the ellipsoidal shape, not normalizeddoubleaxis1_xdirection of major axis, unit eigenvector of the inertia tensor, x-componentdoubleaxis1_ydirection of major axis, y-componentdoubleaxis1_zdirection of major axis, z-componentdoubleaxis2_xdirection of intermediate axis, unit eigenvector of the inertia tensor, x-componentdoubleaxis2_ydirection of intermediate axis, y-componentdoubleaxis2_zdirection of intermediate axis, z-componentdoubleaxis3_xdirection of minor axis, unit eigenvector of the inertia tensor, x-componentdoubleaxis3_ydirection of minor axis, y-componentdoubleaxis3_zdirection of minor axis, z-componentdoubleixspatial index, x-directionpos.cartesian.xintiyspatial index, y-directionpos.cartesian.yintizspatial index, z-directionpos.cartesian.zintphkeyPeano-Hilbert keyintmdr1.treesnapnumsSnapshot numbers of merger tree datatreesnapnumsnapshot number in FOF merger tree-time.epochintindexedprimarysnapnumsnapshot number (in full snapshot sample)-time.epochintaexpexpansion factor of the universe-time.epochfloatzredcorresponding redshift-time.epochfloatmdr1.fofmtreeMerger trees for FOF-objectsfoftreeidunique id for FOF-group = treeRootId + rank in merger tree (depth first order)meta.id;meta.mainlongindexedprimaryfofidcorresponding id of this FOF group in the FOF tablemeta.idlongindexedtreesnapnumsubsequent number of snapshot used for creating the merger tree, not the same number as in FOF tabletime.epochshortindexeddescendantidfofTreeId for direct descendant (to which the FOF group will merge in the next timestep)meta.id.assoclongindexedlastprogidfofTreeId of last progenitor in depth-first ordermeta.id.assoclongindexedmainleafidfofTreeId of last leaf on main branch, which is defined by the most massive progenitorsmeta.id.assoclongindexedtreerootidroot in merger treemeta.id.assoclongindexedxcomoving position, x-componenth-1.Mpcpos.cartesian.xdoubleycomoving position, y-componenth-1.Mpcpos.cartesian.ydoublezcomoving position, z-componenth-1.Mpcpos.cartesian.zdoublevxcomoving velocity, x-componentkm/sphys.veloc;pos.cartesian.xdoublevycomoving velocity, y-componentkm/sphys.veloc;pos.cartesian.ydoublevzcomoving velocity, z-componentkm/sphys.veloc;pos.cartesian.zdoublenpnumber of particles inside the FOF groupmeta.numberintmasstotal mass of the FOF grouph-1.solMassphys.massdoublesize'radius' of the FOF group, if it were a sphere, computed based on the volumeh-1.Mpcphys.size.radiusdoublespinspin parameter (Gottloeber and Yepes 2007, ApJ 664, 117)doubleixspatial index, x-directionpos.cartesian.xintiyspatial index, y-directionpos.cartesian.yintizspatial index, z-directionpos.cartesian.zintphkeyPeano-Hilbert keyintindexedmdr1.fofparticlesLinks between FOF groups at z=0 (snapnum=85) and their particlesfofparticleidunique id for each record (for usage as primary key), combined from fofId and particleIdmeta.id;meta.maincharindexedprimaryfofidid of the FOF group, same as fofId in corresponding FOF-tablemeta.id;meta.mainlongindexedparticleidid for particle, same as particleId in particles-tablemeta.id;meta.mainlongindexedsnapnumnumber of snapshottime.epochshortmdr1.particles85Snapshot of the simulation at redshift z=0, list of simulation particlesparticleidunique id for particlemeta.id;meta.mainlongindexedprimaryxcomoving position, x-componenth-1.Mpcpos.cartesian.xdoubleycomoving position, y-componenth-1.Mpcpos.cartesian.ydoublezcomoving position, z-componenth-1.Mpcpos.cartesian.zdoublevxpeculiar velocity, x-componentkm/sphys.veloc;pos.cartesian.xdoublevypeculiar velocity, y-componentkm/sphys.veloc;pos.cartesian.ydoublevzpeculiar velocity, z-componentkm/sphys.veloc;pos.cartesian.zdoublephkeyPeano-Hilbert keyintindexedravedr4 This service gives access to the 4th data release of RAVE (RAdial Velocity Experiment). It contains radial velocities of stars, stellar atmospheric parameters, some abundances and distances.ravedr4.rave_dr4This is the main DR4 table, containing a summary of most values from the other tables.rave_obs_idUnique Identifier for RAVE objects: Observation Date, Fieldname, Fibernumbermeta.id;meta.maincharindexedprimaryraveid(J2000 GCS) $RA_h,$RA_m,(int(10*$RA_s+0.51))/10.0,$DEsign,$DE_h,$DE_m,int($DE_s+0.51)) RA(hh:mm:ss) Dec(hh:mm:ss) from fits filemeta.idcharnullableradegRight Ascension (J2000 GCS)degpos.eq.ra;meta.maindoubleindexednullablededegDeclination (J2000 GCS)degpos.eq.dec;meta.maindoubleindexednullableglonLongitude (J2000 GCS)degpos.galactic.londoublenullableglatLatitude (J2000 GCS)degpos.galactic.latdoublenullablehrvHeliocentric radial velocitykm/sspect.dopplerVeloc;pos.heliocentricfloatnullableehrvError of Heliocentric radial velocity stat.errorkm/sstat.error;spect.dopplerVeloc;pos.heliocentricfloatnullablecorrelationcoeffTonry-Davis $R$ correlation coefficient(R+)stat.correlationfloatnullablepeakheightHeight of correlation peak[0,1]stat.correlation;stat.valuefloatnullablepeakwidthWidth of correlation peakkm/sstat.correlation;stat.valuefloatnullablecorrectionrvZero point correction applied Heliocentric Radial Velocitykm/sspect.dopplerVeloc;arith.zpfloatnullableskyhrvMeasured Sky Heliocentric Radial Velocitykm/sspect.dopplerVelocfloatnullableeskyhrvError of Measured Sky Heliocentric Radial Velocitykm/sspect.dopplerVelocfloatnullableskycorrelationcoefffloatnullablezeropointflagQuality Flag for ZeroPoint correction (see DR3, Note )meta.code.qualcharnullablestn_sparvfloatnullableid_tycho2TYCHO2 designationmeta.idcharnullabledist_tycho2Center Distance Target-Catalog [orig. period, approx. formula] (see Note XQFL)arcsecpos.angDistancefloatnullablexidqualityflag_tycho2Cross-Identification Flag (see Note XQFL)meta.code.qualcharnullablepmra_tycho2Proper Motion (Right Ascension)mas/yrpos.pmfloatnullableepmra_tycho2Proper Motion error (Right Ascension)mas/yrstat.error;pos.pmfloatnullablepmde_tycho2Proper Motion (Declination)mas/yrpos.pmfloatnullableepmde_tycho2Proper Motion error (Declination)mas/yrstat.error;pos.pmfloatnullableid_ucac2UCAC2 designationmeta.idcharnullabledist_ucac2Center Distance Target-Catalog [J2000] (see Note XQFL)arcsecpos.angDistancedoublenullablexidqualityflag_ucac2Cross-Identification Flag (see Note XQFL)meta.code.qualcharnullablepmra_ucac2Proper Motion (Right Ascension)mas/yrpos.pmfloatnullableepmra_ucac2Proper Motion error (Right Ascension)mas/yrstat.error;pos.pmfloatnullablepmde_ucac2Proper Motion (Declination)mas/yrpos.pmfloatnullableepmde_ucac2Proper Motion error (Declination)mas/yrstat.error;pos.pmfloatnullableid_ucac3UCAC3 designationmeta.idcharnullabledist_ucac3Center Distance Target-Catalog [J2000] (see Note XQFL)arcsecpos.angDistancedoublenullablexidqualityflag_ucac3Cross-Identification Flag (see Note XQFL)meta.code.qualcharnullablepmra_ucac3Proper Motion (Right Ascension)mas/yrpos.pmfloatnullableepmra_ucac3Proper Motion error (Right Ascension)mas/yrstat.error;pos.pmfloatnullablepmde_ucac3Proper Motion (Declination)mas/yrpos.pmfloatnullableepmde_ucac3Proper Motion error (Declination)mas/yrstat.error;pos.pmfloatnullableid_ucac4UCAC4 designationmeta.idcharnullabledist_ucac4Center Distance Target-Catalog [J2000] (see Note XQFL)arcsecpos.angDistancedoublenullablexidqualityflag_ucac4Cross-Identification Flag (see Note XQFL)meta.code.qualcharnullablepmra_ucac4Proper Motion (Right Ascension)mas/yrpos.pmfloatnullableepmra_ucac4Proper Motion error (Right Ascension)mas/yrstat.error;pos.pmfloatnullablepmde_ucac4Proper Motion (Declination)mas/yrpos.pmfloatnullableepmde_ucac4Proper Motion error (Declination)mas/yrstat.error;pos.pmfloatnullableid_ppmxlPPMXL designationmeta.idcharnullabledist_ppmxlCenter Distance Target-Catalog [J2000] (see Note XQFL)arcsecpos.angDistancedoublenullablexidqualityflag_ppmxlCross-Identification Flag (see Note XQFL)meta.code.qualcharnullablepmra_ppmxlProper Motion (Right Ascension)mas/yrpos.pmfloatnullableepmra_ppmxlProper Motion error (Right Ascension)mas/yrstat.error;pos.pmfloatnullablepmde_ppmxlProper Motion (Declination)mas/yrpos.pmfloatnullableepmde_ppmxlProper Motion error (Declination)mas/yrstat.error;pos.pmfloatnullableobsdateObservation Date (YYYYMMDD)YYYYMMDDtime.obscharnullablefieldnameCenter of Observed Field (RA/Dec)meta.id;meta.filecharnullableplatenumberInstrument Plate Number[1,2,3]meta.id;instr.plateshortnullablefibernumberInstrument FiberNumber[1,150]meta.id.instr.partshortnullableteff_kEffective TemperatureKphys.temperature.effectivefloatnullableeteff_kEffective Temperature errorKphys.temperature.effectivefloatnullablelogg_kGravitydexphys.gravityfloatnullableelogg_kGravitydexphys.gravityfloatnullablemet_k[m/H]dexphys.abund.Zfloatnullablemet_n_k[m/H], (matisse-calibrated)dexphys.abund.Zfloatnullableemet_k[m/H]dexphys.abund.Zfloatnullablesnr_kSignal/Noise Ratio of Pipeline V 5.x(R+)stat.snrfloatnullablealgo_conv_k0 = MATISSE converged. 1 = no convergence. 2 = MATISSE oscillates between two values and the mean has been performed. 3 = results of MATISSE at the boundaries or outside the grid and the DEGAS value has been adopted 4 = then the metal-poor giants with snr less than 20 have been re-run by degas with a scale factor (ie, internal parameter of DEGAS) of 0.40[0,1,2,3,4]meta.code.qualshortnullableal[Al/H] abundance of Aldexphys.abund.Zfloatnullableal_nNumber of used spectral lines in calc. of [Al/H]meta.numbershortnullablesi[Si/H] abundance of Sidexphys.abund.Zfloatnullablesi_nNumber of used spectral lines in calc. of [Si/H]meta.numbershortnullablefe[Fe/H] abundance of Fedexphys.abund.Zfloatnullablefe_nNumber of used spectral lines in calc. of [Fe/H]meta.numbershortnullableti[Ti/H] abundance of Tidexphys.abund.Zfloatnullableti_nNumber of used spectral lines in calc. of [Ti/H]meta.numbershortnullableni[Ni/H] abundance of Nidexphys.abund.Zfloatnullableni_nNumber of used spectral lines in calc. of [Ni/H]meta.numbershortnullablemg[Mg/H] abundance of Mgdexphys.abund.Zfloatnullablemg_nNumber of used spectral lines in calc. of [Mg/H]meta.numbershortnullablechisq_cchi square [Chemical pipeline]stat.fit.chi2floatnullableteff_sparvEffective TemperatureKphys.temperature.effectivefloatnullablelogg_sparvGravitydexphys.gravityfloatnullablealpha_sparv[Alpha/Fe]dexphys.abundfloatnullableid_2mass2MASS designationmeta.idcharnullabledist_2massCenter Distance Target-Catalog [J2000] (see Note XQFL)arcsecpos.angDistancedoublenullablexidqualityflag_2massCross-Identification Flag (see Note XQFL)meta.code.qualcharnullablejmag_2massJ selected default magnitude from 2MASSmagphot.mag;em.IR.Jfloatnullableejmag_2masserror 2MASS J magnitudemagstat.error;phot.mag;em.IR.Jfloatnullablehmag_2massH selected default magnitude from 2MASSmagphot.mag;em.IR.Hfloatnullableehmag_2masserror 2MASS H magnitudemagstat.error;phot.mag;em.IR.Hfloatnullablekmag_2massK_s selected default magnitude from 2MASSmagphot.mag;em.IR.Kfloatnullableekmag_2masserror 2MASS K magnitudemagstat.error;phot.mag;em.IR.Kfloatnullableid_denisDENIS designationmeta.idcharnullabledist_denisCenter Distance Target-Catalog [J2000] (see Note XQFL)arcsecpos.angDistancedoublenullablexidqualityflag_denisCross-Identification Flag (see Note XQFL)meta.code.qualcharnullableimag_denisInput Catalog I magnitudemagphot.mag;em.opt.Idoublenullableeimag_deniserror DENIS I magnitudemagstat.error;phot.mag;em.opt.Idoublenullablejmag_denisJ selected default magnitude from 2MASSmagphot.mag;em.IR.Jdoublenullableejmag_deniserror DENIS J magnitudemagstat.error;phot.mag;em.IR.Jdoublenullablekmag_denisK_s selected default magnitude from 2MASSmagphot.mag;em.IR.Kdoublenullableekmag_deniserror DENIS K magnitudemagstat.error;phot.mag;em.IR.Kdoublenullableid_usnob1USNOB-1 designationmeta.idcharnullabledist_usnob1Center Distance Target-Catalog [J2000] (see Note XQFL)arcsecpos.angDistancedoublenullablexidqualityflag_usnob1Cross-Identification Flag (see Note XQFL)meta.code.qualcharnullableb1mag_usnob1B mag from USNO-Bmagphot.mag;em.opt.Bdoublenullabler1mag_usnob1R mag from USNO-Bmagphot.mag;em.opt.Rdoublenullableb2mag_usnob1B mag from USNO-Bmagphot.mag;em.opt.Bdoublenullabler2mag_usnob1R mag from USNO-Bmagphot.mag;em.opt.Rdoublenullableimag_usnob1Input Catalog I magnitudemagphot.mag;em.opt.IdoublenullableparallaxParallaxmaspos.parallaxfloatnullablee_parallaxmasstat.error;pos.parallaxfloatnullabledistDistance (kpc)kpcpos.distancefloatnullablee_distError of Distancekpcstat.error;pos.distancefloatnullabledistancemodulus_binneyfloatnullableedistancemodulus_binneyfloatnullableavlog_10(Av) optical extinction, see p4 ff, Mon. Not. R. Astron. Soc. 000, 1-8 (2012)log_10(Av)phys.absorptionfloatnullablee_averror log_10(Av) optical extinction, see p4 ff, Mon. Not. R. Astron. Soc. 000, 1-8 (2012)log_10(eAv)stat.error;phys.absorptionfloatnullableagelog_10(age) Age estimationlog10(age(yr))time.agefloatnullablee_ageerror log_10(age) error of age estimationlog10(age(yr))stat.error;time.agefloatnullablemassMassMsunphys.massfloatnullablee_massError of MassMsunstat.error;phys.massfloatnullablec11.st minimum distance to base spectrum given by one of the types (see enumeration)[a,b,c,d,e,g,h,n,o,p,t,u,w]meta.codecharnullablec22.nd minimum distance to base spectrum given by one of the types (see enumeration)[a,b,c,d,e,g,h,n,o,p,t,u,w]meta.codecharnullablec33.rd minimum distance to base spectrum given by one of the types (see enumeration)[a,b,c,d,e,g,h,n,o,p,t,u,w]meta.codecharnullablec44.th minimuml distance to base spectrum given by one of the types (see enumeration)[a,b,c,d,e,g,h,n,o,p,t,u,w]meta.codecharnullablec55.th minimum distance to base spectrum given by one of the types (see enumeration)[a,b,c,d,e,g,h,n,o,p,t,u,w]meta.codecharnullablec66.th minimum distance to base spectrum given by one of the types (see enumeration)[a,b,c,d,e,g,h,n,o,p,t,u,w]meta.codecharnullablec77.th minimum distance to base spectrum given by one of the types (see enumeration)[a,b,c,d,e,g,h,n,o,p,t,u,w]meta.codecharnullablec88.th minimum distance to base spectrum given by one of the types (see enumeration)[a,b,c,d,e,g,h,n,o,p,t,u,w]meta.codecharnullablec99.th minimum distance to base spectrum given by one of the types (see enumeration)[a,b,c,d,e,g,h,n,o,p,t,u,w]meta.codecharnullablec1010.th minimum distance to base spectrum given by one of the types (see enumeration)[a,b,c,d,e,g,h,n,o,p,t,u,w]meta.codecharnullablec1111.th minimum distance to base spectrum given by one of the types (see enumeration)[a,b,c,d,e,g,h,n,o,p,t,u,w]meta.codecharnullablec1212.th minimum distance to base spectrum given by one of the types (see enumeration)[a,b,c,d,e,g,h,n,o,p,t,u,w]meta.codecharnullablec1313.th minimum distance to base spectrum given by one of the types (see enumeration)[a,b,c,d,e,g,h,n,o,p,t,u,w]meta.codecharnullablec1414.th minimum distance to base spectrum given by one of the types (see enumeration)[a,b,c,d,e,g,h,n,o,p,t,u,w]meta.codecharnullablec1515.th minimum distance to base spectrum given by one of the types (see enumeration)[a,b,c,d,e,g,h,n,o,p,t,u,w]meta.codecharnullablec1616.th minimum distance to base spectrum given by one of the types (see enumeration)[a,b,c,d,e,g,h,n,o,p,t,u,w]meta.codecharnullablec1717.th minimum distance to base spectrum given by one of the types (see enumeration)[a,b,c,d,e,g,h,n,o,p,t,u,w]meta.codecharnullablec1818.th minimum distance to base spectrum given by one of the types (see enumeration)[a,b,c,d,e,g,h,n,o,p,t,u,w]meta.codecharnullablec1919.th minimum distance to base spectrum given by one of the types (see enumeration)[a,b,c,d,e,g,h,n,o,p,t,u,w]meta.codecharnullablec2020.th minimum distance to base spectrum given by one of the types (see enumeration)[a,b,c,d,e,g,h,n,o,p,t,u,w]meta.codecharnullable