SIMBAD TAPivo://CDS.SIMBAD/TAPCDS SIMBAD serviceSebastien DerriereGregory Mantelet2012-05-102015-02-021.0CDS support team

CDS, Observatoire de Strasbourg, 11 rue de l'Universite, F-67000 Strasbourg, France

cds-question@unistra.frTAPThis service provides TAP access to a simplified view of the SIMBAD databasehttps://simbad.cds.unistra.frOrganisationResearchhttp://simbad.cds.unistra.fr/simbad/sim-tap/availabilityhttp://simbad.cds.unistra.fr/simbad/sim-tap/capabilitieshttp://simbad.cds.unistra.fr/simbad/sim-tap/tableshttp://simbad.cds.unistra.fr/simbad/sim-tapADQL2.0ADQL 2.0

uppercase(str VARCHAR) -> VARCHAR

Put all characters of the given string in upper-case.

lowercase(str VARCHAR) -> VARCHAR

Put all characters of the given string in lower-case.

normId(id VARCHAR) -> VARCHAR

Normalise the given Simbad's object identifier (e.g. 'm1', 'andromeda').

array_agg(str VARCHAR) -> VARCHAR

Aggregate inside an array the value of the given expression for each row.

regexp(str VARCHAR, pattern VARCHAR) -> INTEGER

Determine whether the given string - str - matches the given regular expression - pattern. If yes, 1 is returned, else 0.

radec2sexa(ra DOUBLE, dec DOUBLE, prec SMALLINT) -> VARCHAR

Format the given coordinates into a Sexagesimal notation.

string_agg(str VARCHAR, delim VARCHAR) -> VARCHAR

Aggregate inside a single string the value of the given expression for each row. Row value are separated by the given string - delim.text/xmlvotableapplication/jsonjsontext/csvcsvtext/tsvtsvtext/plaintext432000432000360036002000020002000TAP_SCHEMASet of tables listing and describing the schemas, tables and columns published in this TAP service.TAP_SCHEMA.schemasList of schemas published in this TAP service.schema_nameschema name, possibly qualifiedVARCHARindexedprimarydescriptionbrief description of schemaVARCHARutypeUTYPE if schema corresponds to a data modelVARCHARTAP_SCHEMA.tablesList of tables published in this TAP service.table_indexthis index is used to recommend table ordering for clientsINTEGERschema_namethe schema name from TAP_SCHEMA.schemasVARCHARindexedprimarytable_nametable name as it should be used in queriesVARCHARindexedprimarytable_typeone of: table, viewVARCHARdescriptionbrief description of tableVARCHARutypeUTYPE if table corresponds to a data modelVARCHARTAP_SCHEMA.columnsList of columns of all tables listed in TAP_SCHEMA.TABLES and published in this TAP service.column_indexthis index is used to recommend column ordering for clientsINTEGERtable_nametable name from TAP_SCHEMA.tablesVARCHARindexedprimarycolumn_namecolumn nameVARCHARindexedprimarydatatypeADQL datatype as in section 2.5VARCHARarraysizelength of variable length datatypesINTEGER"size"length of variable length datatypesINTEGERdescriptionbrief description of columnVARCHARutypeUTYPE of column if anyVARCHARunitunit in VO standard formatVARCHARucdUCD of column if anyVARCHARindexedan indexed column; 1 means true, 0 means falseINTEGERprincipala principal column; 1 means true, 0 means falseINTEGERstda standard column; 1 means true, 0 means falseINTEGERTAP_SCHEMA.keysList all foreign keys but provides just the tables linked by the foreign key. To know which columns of these tables are linked, see in TAP_SCHEMA.key_columns using the key_id.key_idunique key identifierVARCHARindexedprimaryfrom_tablefully qualified table nameVARCHARtarget_tablefully qualified table nameVARCHARdescriptiondescription of this keyVARCHARutypeutype of this keyVARCHARTAP_SCHEMA.key_columnsList all foreign keys but provides just the columns linked by the foreign key. To know the table of these columns, see in TAP_SCHEMA.keys using the key_id.key_idunique key identifierVARCHARindexedprimaryfrom_columnkey column name in the from_tableVARCHARtarget_columnkey column name in the target_tableVARCHARpublicDefault schemaallfluxesall flux/magnitudes U,B,V,I,J,H,K,u_,g_,r_,i_,z_BDOUBLEGDOUBLEHDOUBLEIDOUBLEJDOUBLEKDOUBLERDOUBLEUDOUBLEVDOUBLEg_DOUBLEi_DOUBLEoidrefObject internal identifierBIGINTr_DOUBLEu_DOUBLEz_DOUBLEbasicoidrefoidalltypesall object types concatenated with pipeoidrefObject internal identifierBIGINTotypesList of all object types concatenated with pipesrc.classCLOBbasicoidrefoidauthorAuthor of a bibliographic referencenameAuthor of a bibliographical referencemeta.bib.authorVARCHARoidbibrefBibcode internal identifiermeta.record;meta.bibBIGINTposPosition of the author in the bib refmeta.number;meta.bib.authorSMALLINTrefoidbibrefoidbibbasicGeneral data about an astronomical objectcoo_bibcodeCoordinate referencemeta.bib.bibcode;pos.eqCHARcoo_err_angleCoordinate error angledegpos.posAng;pos.errorEllipse;pos.eqSMALLINTcoo_err_majCoordinate error major axismasphys.angSize.smajAxis;pos.errorEllipse;pos.eqREALcoo_err_maj_precCoordinate error major axis precisionSMALLINTcoo_err_minCoordinate error minor axismasphys.angSize.sminAxis;pos.errorEllipse;pos.eqREALcoo_err_min_precCoordinate error minor axis precisionSMALLINTcoo_qualCoordinate qualitymeta.code.qual;pos.eqCHARcoo_wavelengthWavelength class for the origin of the coordinates (R,I,V,U,X,G)instr.bandpass;pos.eqCHARdec_precDeclination precisionSMALLINTgaldim_angleGalaxy ellipse angledegpos.posAngSMALLINTgaldim_bibcodeGalaxy dimension referencemeta.bib.bibcode;phys.angSizeCHARgaldim_majaxisAngular size major axisarcminphys.angSize.smajAxisREALgaldim_majaxis_precAngular size major axis precisionSMALLINTgaldim_minaxisAngular size minor axisarcminphys.angSize.sminAxisREALgaldim_minaxis_precAngular size minor axis precisionSMALLINTgaldim_qualGalaxy dimension qualitymeta.code.qual;phys.angSizeCHARhpxHealpix number at ORDER=10meta.idBIGINTindexedmorph_bibcodemorphological type referencemeta.bib.bibcode;src.morph.typeCHARmorph_qualMorphological type qualitymeta.code.qual;src.morph.typeCHARmorph_typeMorphological typesrc.morph.typeVARCHARnbrefnumber of referencesmeta.bib;meta.numberINTEGERoidObject internal identifiermeta.record;meta.idBIGINTotypeObject type, binary formsrc.class;meta.code.classINTEGERplx_bibcodeParallax referencemeta.bib.bibcode;pos.parallax.trigCHARplx_errParallax errormasstat.error;pos.parallax.trigREALplx_err_precParallax error precisionSMALLINTplx_precParallax precisionSMALLINTplx_qualParallax qualitymeta.code.qual;pos.parallax.trigCHARplx_valueParallaxmaspos.parallax.trigDOUBLEpm_bibcodeProper motion referencemeta.bib.bibcode;pos.pmCHARpm_err_angleProper motion error angledegpos.posAng;pos.errorEllipse;pos.pmSMALLINTpm_err_majProper motion error major axismas.yr-1phys.angSize.smajAxis;pos.errorEllipse;pos.pmREALpm_err_maj_precProper motion error major axis precisionSMALLINTpm_err_minProper motion error minor axismas.yr-1phys.angSize.sminAxis;pos.errorEllipse;pos.pmREALpm_err_min_precProper motion error minor axis precisionSMALLINTpm_qualProper motion qualitymeta.code.qual;pos.pmCHARpmdecProper motion in DECmas.yr-1pos.pm;pos.eq.decDOUBLEpmdec_precProper motion in DEC precisionSMALLINTpmraProper motion in RAmas.yr-1pos.pm;pos.eq.raDOUBLEpmra_precProper motion in RA precisionSMALLINTra_precRight ascension precisionSMALLINTrvz_bibcodeRadial velocity / redshift referencemeta.bib.bibcode;spect.dopplerVelocCHARrvz_errRadial velocity / redshift errorkm.s-1stat.error;spect.dopplerVelocREALrvz_err_precRadial velocity / redshift error precisionSMALLINTrvz_naturevelocity / redshift naturemeta.code;spect.dopplerVelocCHARrvz_qualRadial velocity / redshift qualitymeta.code.qual;spect.dopplerVelocCHARrvz_radvelRadial Velocitykm.s-1spect.dopplerVeloc.optDOUBLErvz_radvel_precRadial velocity precisionSMALLINTrvz_redshiftredshiftsrc.redshiftDOUBLErvz_redshift_precredshift precisionSMALLINTrvz_typeRadial velocity / redshift typeCHARsp_bibcodespectral type referencemeta.bib.bibcode;src.spTypeCHARsp_qualSpectral type qualitymeta.code.qual;src.spTypeCHARsp_typeMK spectral typesrc.spTypeVARCHARupdate_dateDate of last modificationtime.processingvlsrvelocity in Local Standard of Rest reference framephys.veloc;pos.lsr;stat.meanDOUBLEmain_idMain identifier for an objectmeta.id;meta.mainVARCHARprimaryotype_txtObject typesrc.classVARCHARprimaryraRight ascensiondegpos.eq.ra;meta.mainDOUBLEprimarydecDeclinationdegpos.eq.dec;meta.mainDOUBLEprimarybiblioBibliographybiblioList of Bibcodes separated with a pipemeta.record;meta.biboidrefObject internal identifiermeta.record;meta.idBIGINTbasicoidrefoidcatCatalogues namecat_nameCatalogue namemeta.id;meta.datasetVARCHARsizeNumber of objects of the Catalogue in SIMBADmeta.id;meta.numberINTEGERfilterDescription of a flux filterdescriptionflux filter descriptionmeta.note;instr.filterVARCHARfilternameflux filter nameinstr.filterVARCHARunitphysical unit namemeta.unitVARCHARfluxMagnitude/Flux information about an astronomical objectbibcodeflux referencemeta.bib.bibcode;phot.fluxCHARfilterflux filter nameinstr.filterVARCHARfluxREALflux_errflux errorstat.error;phot.magREALflux_err_precflux error precisioninstr.precision;stat.error;phot.fluxSMALLINTflux_precflux precisioninstr.precision;phot.fluxSMALLINToidrefObject internal identifierBIGINTqualflux quality flagmeta.code.qual;phot.fluxCHARbasicoidrefoidfilterfilterfilternameh_linkhierarchy of membership measurechildchild oidmeta.record;meta.idBIGINTlink_bibcodelink referencemeta.bib.bibcodeCHARmembershipmembership probabilitypercentSMALLINTparentparent oidmeta.record;meta.idBIGINTbasicchildoidbasicparentoidhas_refAssociations between astronomical objects and their bibliographic referencesobj_freqflagmeta.id;meta.numberSMALLINToidbibrefBibcode internal identifiermeta.record;meta.bibBIGINToidrefObject internal identifierBIGINTref_flagflagmeta.code;meta.bibSMALLINTref_raw_idid like it appears in the articlemeta.id;meta.bibVARCHARbasicoidrefoidrefoidbibrefoidbibidentIdentifiers of an astronomical objectidIdentifiermeta.idVARCHARoidrefObject internal identifierBIGINTbasicoidrefoididsall names concatenated with pipeidsList of all identifiers concatenated with pipemeta.idCLOBoidrefObject internal identifierBIGINTbasicoidrefoidkeywordsList of keywords in a paperkeywordKeyword text and linkmeta.recordoidbibrefObject internal identifier of referencemeta.record;meta.idBIGINTpositionPosition of the keyword in the publicationmeta.recordINTEGERrefoidbibrefoidbibmesDiameterCollection of stellar diameters.bibcodemeasurement bibcodemeta.bib.bibcodeCHARdiameterDiameter valuephys.angSizeDOUBLEdiameter_precPrecision (# of decimal positions) associated with the column diameterSMALLINTerrorErrorstat.errorDOUBLEerror_precPrecision (# of decimal positions) associated with the column errorSMALLINTfilterfilter or wavelengthinstr.filterCHARmesposPosition of a measurement in a list of measurementsSMALLINTmethodcalculation methodinstr.setupCHARoidrefObject internal identifierBIGINTqualQualitymeta.code.qualCHARunitUnit (mas/km)meta.unitCHARbasicoidrefoidmesDistanceCollection of distances (pc, kpc or Mpc) by several means.bibcodemeasurement bibcodemeta.bib.bibcodeCHARdistDistance valuepos.distanceDOUBLEdist_precPrecision (# of decimal positions) associated with the column distSMALLINTmesposPosition of a measurement in a list of measurementsSMALLINTmethoddistance calculation methodinstr.setupCHARminus_errminus errorstat.errorDOUBLEminus_err_precPrecision (# of decimal positions) associated with the column minus_errSMALLINToidrefObject internal identifierBIGINTplus_errplus errorstat.errorDOUBLEplus_err_precPrecision (# of decimal positions) associated with the column plus_errSMALLINTqualQualitymeta.code.qualCHARunitUnit (pc,kpc or Mpc)meta.unitCHARbasicoidrefoidmesFe_hCollection of metallicity, as well as Teff, logg for stars.bibcodemeasurement bibcodemeta.bib.bibcodeCHARcatnoStar in the Cayrel et al. (1997A&AS..124..299C) compilationmeta.id;meta.mainCHARcompstarDesignates the comparison star from which the [Fe/H] value was obtainedmeta.idCHARfe_hMetallicity index relative to the Sunphys.abund.FeREALfe_h_precPrecision (# of decimal positions) associated with the column fe_hSMALLINTflagFlag on the [Fe/H] valuemeta.code.errorCHARlog_gDecimal logarithm of the surface gravitycm/s**2phys.gravityREALlog_g_precPrecision (# of decimal positions) associated with the column log_gSMALLINTmesposPosition of a measurement in a list of measurementsSMALLINToidrefObject internal identifierBIGINTteffEffective Temperatureunit-degKphys.temperature.effectiveINTEGERbasicoidrefoidmesHerschelThe Herschel observing LogalphaRight Ascension J2000h:m:spos.eq.ra;meta.mainCHARdeltaDeclination J2000d:m:spos.eq.dec;meta.mainCHARmesposPosition of a measurement in a list of measurementsSMALLINTobsidObservation identifiermeta.id;meta.mainCHARoidrefObject internal identifiermeta.record;meta.idBIGINTbasicoidrefoidmesISOInfrared Space Observatory (ISO) observing log.decDeclinationdegpos.eq.dec;meta.mainDOUBLEdec_precPrecision (# of decimal positions) associated with the column decSMALLINTmesposPosition of a measurement in a list of measurementsSMALLINTobsidObservation identifiermeta.id;meta.mainCHARoidrefObject internal identifierBIGINTraRight ascensiondegpos.eq.ra;meta.mainDOUBLEra_precPrecision (# of decimal positions) associated with the column raSMALLINTbasicoidrefoidmesIUEInternational Ultraviolet Explorer observing log.abnormcodeAbnormality codemeta.code.qualCHARapertureAperture designation codeinstr.fovCHARbibcodemeasurement bibcodemeta.bib.bibcodeCHARcamidCamera idmeta.id;instrCHARclasscodeIUE class codesrc.classSMALLINTcommentsCommentsmeta.noteCHARcomplidComplementary Identifiermeta.idCHARdispcodeDispersion codemeta.codeCHARexpqualcodeExposure quality codemeta.code.classCHARexptimeEffective exposure timesectime.expoINTEGERfescountFES countphot.count;em.optINTEGERfesmodeFES modemeta.codeCHARflagFlagmeta.codeCHARimageImage numberobs.imageINTEGERmesposPosition of a measurement in a list of measurementsSMALLINTnameHomogenized Namemeta.id;meta.mainCHARobsdateObservation datetime.epochCHARobstimeObservation timetime.epochCHARoidrefObject internal identifierBIGINTprogidObserving Program Identificationmeta.id;obsCHARstationStation (V=Vilspa/G=Goddard)meta.flag;instr.telCHARbasicoidrefoidmesPLXCollection of trigonometric parallaxes.bibcodemeasurement bibcodemeta.bib.bibcodeCHARmesposPosition of a measurement in a list of measurementsSMALLINTobscodeObservatory codemeta.id;instr.obstyCHARoidrefObject internal identifierBIGINTplxParallaxearcsecpos.parallax.trigREALplx_errsigma{plx}arcsecstat.errorSMALLINTplx_precPrecision (# of decimal positions) associated with the column plxSMALLINTbasicoidrefoidmesPMCollection of proper motions.bibcodemeasurement bibcodemeta.bib.bibcodeCHARcoosystemcoordinates system designationpos.frameCHARmesposPosition of a measurement in a list of measurementsSMALLINToidrefObject internal identifierBIGINTpmdeProper motion DEC.mas.yr-1pos.pm;pos.eq.decREALpmde_errsigma{pm-de}mas.yr-1stat.errorREALpmde_err_precPrecision (# of decimal positions) associated with the column pmde_errSMALLINTpmde_precPrecision (# of decimal positions) associated with the column pmdeSMALLINTpmraProper motion R.A.mas.yr-1pos.pm;pos.eq.raREALpmra_errsigma{pm-ra}mas.yr-1stat.errorREALpmra_err_precPrecision (# of decimal positions) associated with the column pmra_errSMALLINTpmra_precPrecision (# of decimal positions) associated with the column pmraSMALLINTbasicoidrefoidmesRotStellar Rotational Velocities.bibcodemeasurement bibcodemeta.bib.bibcodeCHARmesposPosition of a measurement in a list of measurementsSMALLINTnbmesNumber of measurementsmeta.numberSMALLINToidrefObject internal identifierBIGINTqualQualitycode.qualCHARupvsiniUpper value of Vsinimeta.codeCHARvsiniV sinikm.s-1phys.veloc.rotatREALvsini_errerrorstat.errorREALvsini_err_precPrecision (# of decimal positions) associated with the column vsini_errSMALLINTvsini_precPrecision (# of decimal positions) associated with the column vsiniSMALLINTbasicoidrefoidmesSpTCollection of spectral types.bibcodemeasurement bibcodemeta.bib.bibcodeCHARdispsystemdispersive systemmeta.id;instrCHARmesposPosition of a measurement in a list of measurementsSMALLINTmssnotemss notesmeta.noteCHARoidrefObject internal identifierBIGINTsptypeMK/MSS spectral typesrc.spTypeCHARbasicoidrefoidmesVarCollection of stellar variability types and periods.bibcodemeasurement bibcodemeta.bib.bibcodeCHARepochEpoch of maximum or minimumdaytime.epochDOUBLEepoch_precPrecision (# of decimal positions) associated with the column epochSMALLINTlowVmaxUpper limit flag for Vmaxmeta.code.errorCHARmagtypMagnitude typemeta.id;photCHARmesposPosition of a measurement in a list of measurementsSMALLINToidrefObject internal identifierBIGINTperiodPerioddaytime.periodDOUBLEperiod_precPrecision (# of decimal positions) associated with the column periodSMALLINTr_epochUncertainty on epoch (:)meta.code.errorCHARr_periodUncertainty flag on period (:)meta.code.errorCHARr_raisingTimeUncertainty flag on raising timemeta.code.errorCHARr_vmaxUncertainty flagmeta.code.errorCHARr_vminUncertainty flag for Vminmeta.code.errorCHARraisingTimeRaising time for all other variable typestime.intervalREALraisingTime_precPrecision (# of decimal positions) associated with the column raisingTimeSMALLINTuppVminLower limit flag for Vminmeta.codeCHARupperiodLower limit flag for the periodmeta.codeCHARvartypType of variabilitymeta.code;src.varCHARvmaxMaximum of brightnessmagphot.magREALvmax_precPrecision (# of decimal positions) associated with the column vmaxSMALLINTvminMinimum of brightnessmagphot.magREALvmin_precPrecision (# of decimal positions) associated with the column vminSMALLINTbasicoidrefoidmesVelocitiesCollection of HRV, Vlsr, cz and redshifts.bibcodemeasurement bibcodemeta.bib.bibcodeCHARd'D' if the resolution is a conversion from the dispersionmeta.codeCHARmeanErrorsigma(Value)stat.errorREALmeanError_precPrecision (# of decimal positions) associated with the column meanErrorSMALLINTmesposPosition of a measurement in a list of measurementsSMALLINTnaturenature of the measurementmeta.code;spect.dopplerVelocCHARnbmesNumber of measurementsmeta.numberSMALLINTobsdateObservation datetime.epochDOUBLEobsdate_precPrecision (# of decimal positions) associated with the column obsdateSMALLINToidrefObject internal identifierBIGINToriginOrigin of the radial velocitymeta.noteCHARqualQualitymeta.code.qualCHARqualityQualitymeta.code.qualCHARremarkcolon is uncertain question mark is questionablemeta.noteCHARremarksRemarksmeta.noteCHARresolutionResolutionspect.resolutionINTEGERvelTypevelocity type (v, z or cz)meta.code;spect.dopplerVelocCHARvelValueVelocityspect.dopplerVelocDOUBLEvelValue_precPrecision (# of decimal positions) associated with the column velValueSMALLINTwdomainWavelength domain (Rad,mm,IR,Opt,UV,XRay,Gam)em.wl.central;spect.dopplerVelocCHARbasicoidrefoidmesXmmXMM observing log.mesposPosition of a measurement in a list of measurementsSMALLINTobsidObservation identifiermeta.id;meta.mainCHARoidrefObject internal identifierBIGINTbasicoidrefoidotypedefall names and definitions for the object typesotypeObject typesrc.classINTEGERotype_longnameObject type, full description stringsrc.classVARCHARotype_shortnameObject type, short namesrc.classVARCHARbasicotypeotypeotypesotypeotypeotypesList of all object types associated with an objectoidrefObject internal identifierBIGINToriginexplanation of origin of this typeotypeObject typesrc.classINTEGERotype_txttextual object typebasicoidrefoidrefBibliographic referenceabstract(revisited) Abstract of published papermeta.recordbibcodeBibcodemeta.bib.bibcodeCHARdoiDOI designationmeta.code;meta.bibVARCHARjournalAbbreviation for the journalmeta.bib.journalVARCHARlast_pageLast page numbermeta.bib.pageINTEGERnbobjectNumber of objects studied inmeta.numberINTEGERoidbibBibcode internal identifiermeta.record;meta.bibBIGINTpagepage numbermeta.bib.pageINTEGERtitleTitlemeta.titleCLOBvolumevolume numbermeta.bib.volumeINTEGERyearPublication yearmeta.note;meta.bibSMALLINT