ChiVO TAP serviceChiVO TAPivo://chivo/tapChiVOEquipo ChiVO/static/img/logo_chivo.png2017-10-20T18:56:31Mauricio Solar
Vicuna Mackenna 3939, Santiago, Chile
msolar@inf.utfsm.clVirtual observatoryCatalogsADQLThe ChiVO'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: alma_fits from the alma_fits schema, m83_obs from the m83_test1 schema, m83_obs from the m83_data schema, hd163296band6 from the hd163296band6 schema, columns, groups, key_columns, keys, schemas, tables from the tap_schema schema, main from the arihip schema, main from the tgas schema, dr1 from the gaia schema, data from the openngc schema, emptyobscore, obscore from the ivoa schema.https://vo.chivo.cl/__system__/tap/run/infoservice-forChiVO Data Provider for ALMA FITSOpenNGCGAIA Data Release 1 (DR1) main object tableTGAS cataloguehttps://vo.chivo.cl/tapObscore-1.1ADQL2.0ADQL 2.0
gavo_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 applications.
gavo_match(pattern TEXT, string TEXT) -> INTEGER
gavo_match returns 1 if the POSIX regular expression pattern matches anything in string, 0 otherwise.
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_string_agg(expression TEXT, delimiter TEXT) -> TEXT
An aggregate function returning all values of expression within a GROUP contcatenated with delimiter
gavo_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.
gavo_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.
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_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_apply_pm(ra DOUBLE PRECISION, dec DOUBLE PRECISION, pmra DOUBLE PRECISION, pmde DOUBLE PRECISON, epdist DOUBLE PRECISION) -> POINT
Returns a POINT (in the UNDEFINED reference frame) for the position an object at ra/dec with proper motion pmra/pmde has after epdist years. positions must be in degrees, PMs in should be in julian years (i.e., proper motions are expected in degrees/year). pmra is assumed to contain cos(delta). NOTE: This currently is a crappy approximation that does *not* go through the tangential plane. If you use it, let the operators know so we replace it with something real.
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 milage will vary.
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 http://www.postgresql.org/docs/8.3/static/textsearch.html for details.
BOX
POINT
CIRCLE
POLYGON
REGION
CENTROID
COORD1
COORD2
DISTANCE
CONTAINS
INTERSECTS
AREA
text/xmltext/htmlhtmlapplication/x-votable+xml;serialization=binary2votable/b2application/geo-jsongeojsonapplication/fitsfitstext/csvtext/csv;header=presentcsvapplication/x-votable+xml;serialization=tabledatavotable/tdapplication/jsonjsonapplication/x-votable+xmlvotabletext/plaintext/tab-separated-valuestsv1728003600200002000000020000000https://vo.chivo.cl/__system__/tap/run/availabilityhttps://vo.chivo.cl/__system__/tap/run/capabilitieshttps://vo.chivo.cl/__system__/tap/run/tableMetadataalma_fitsChiVO Data Provider for ALMA FITS The resource contains the recommendations and requirements for ALMA FITS products of the Inter-ARC ALMA Science Archive Working Group (ASAWG) with the view to including a metadataset that is complete and easily accessible by the ChiVO Data Provider (CDP).alma_fits.alma_fits The resource contains the recommendations and requirements for ALMA FITS products of the Inter-ARC ALMA Science Archive Working Group (ASAWG) with the view to including a metadataset that is complete and easily accessible by the ChiVO Data Provider (CDP) and ALMA Archives.accrefAccess key for the dataAccess.ReferencecharnullableownerOwner of the datacharnullableembargoDate the data will become/became publicacharnullablemimeMIME type of the file servedAccess.FormatcharnullableaccsizeSize of the data in bytesbyteVOX:Image_FileSizeAccess.SizelongnullablecenteralphaApproximate center of image, RAdegPOS_EQ_RA_MAINdoublenullablecenterdeltaApproximate center of image, DecdegPOS_EQ_DEC_MAINdoublenullableimagetitleSynthetic name of the imageVOX:Image_TitlecharnullableinstidIdentifier of the originating instrumentINST_IDcharnullabledateobsEpoch at midpoint of observationdVOX:Image_MJDateObsdoublenullablenaxesNumber of axes in dataVOX:Image_NaxesintnullablepixelsizeNumber of pixels along each of the axespixVOX:Image_NaxisintnullablepixelscaleThe pixel scale on each image axisdeg/pixVOX:Image_ScalefloatnullablerefframeCoordinate system reference frameVOX:STC_CoordRefFramecharnullablewcs_equinoxEquinox of the given coordinatesyrVOX:STC_CoordEquinoxfloatnullablewcs_projectionFITS WCS projection typeVOX:WCS_CoordProjectioncharnullablewcs_refpixelWCS reference pixelpixVOX:WCS_CoordRefPixelfloatnullablewcs_refvaluesWorld coordinates at WCS reference pixeldegVOX:WCS_CoordRefValuedoublenullablewcs_cdmatrixFITS WCS CDij matrixdeg/pixVOX:WCS_CDMatrixfloatnullablebandpassidFreeform name of the bandpass usedVOX:BandPass_IDcharnullablebandpassunitUnit of bandpass specifications (always m).VOX:BandPass_UnitcharnullablebandpassrefvalCharacteristic quantity for the bandpass of the imagemVOX:BandPass_RefValuefloatnullablebandpasshiUpper limit of the bandpass (in BandPass_Unit units)mVOX:BandPass_HiLimitfloatnullablebandpassloLower limit of the bandpass (in BandPass_Unit units)mVOX:BandPass_LoLimitfloatnullablepixflagsFlags specifying the processing done (C-original; F-resampled; Z-fluxes valid; X-not resampled; V-for display onlyVOX:Image_PixFlagscharnullablecoverageField covered by the imagedegdoubleindexednullabletarget_nameName for source observed.meta.id;meta.maincharnullablefile_nameName of the file FITS.meta.id;meta.file;meta.maincharnullableaccess_urlURL of the data file.meta.ref.url;meta.maincharnullablenaxisNumber of axes in the associated data array.pos.wcs.naxis;meta.mainfloatnullablenaxisnNumber of elements along axis n of a data array (n = 1-NAXIS). ASA data must have four NAXIS terms.pos.wcs.naxisn;meta.maincharnullabledate_obsObservation start time.time.epoch;meta.maincharnullables_raThe Right Ascension coordinate of image center, in the system specified in EQUINOX and RADESYS.pos.eq.ra;meta.mainfloatindexednullables_decThe Declination coordinate of image center, in the in the system specified in EQUINOX and RADESYS.pos.eq.dec;meta.mainfloatindexednullablespecsysReference frame for freq axis.pos.eq.specsys;meta.maincharnullableradesysName of the reference frame of equatorial or ecliptic coordinates.pos.eq.radesys;meta.maincharnullablerestfrqontingent on the type of measurements being made: For transition line measurements: the rest frequency of the of the spectral feature of interest in Hz. For continuum measurements: the centre of the band of the spectral window.pos.eq.restfrq;meta.mainfloatnullableobsgeo_xX−coordinate in cartesian geocentric terrestrial reference frame, specifying the location the observation took place at time given in MJD-AVG.pos.cartesian.x;meta.mainfloatnullableobsgeo_yY−coordinate in cartesian geocentric terrestrial reference frame, specifying the location the observation took place at time given in MJD-AVG.pos.cartesian.y;meta.mainfloatnullableobsgeo_zZ−coordinate in cartesian geocentric terrestrial reference frame, specifying the location the observation took place at time given in MJD-AVG.pos.cartesian.y;meta.mainfloatnullablemousMember observing unit set status uid.meta.mous;meta.maincharnullablegousGroup observing unit set status uid.meta.gous;meta.maincharnullablelonpoleLongitude in the coordinate system of celestial system’s north pole.meta.lonpole;meta.mainfloatnullablelatpoleLatitude in the coordinate system of celestial system’s north pole.meta.latpole;meta.mainfloatnullableinstrument_nameThe receiver band used for the image observations.meta.id;instr;meta.maincharnullable
gaiaGaia Data Release 1 (DR1) The Gaia satellite takes high-precision astrometry of a large number of astronomical objects. This data collection mirrors the larger tables released by DPAC.gaia.dr1GAIA Data Release 1 (DR1) main object table This table, corresponding to gaia_source of the full DR1, contains the 1.15 billion objects reliably detected in the first 14 months of Gaia observations. It essentially consists of high-precision positions and magnitudes. The TGAS subset (about 2 million objects observed by both Gaia and Hipparcos) has proper motions and parallaxes. Users are advised to beware strong correlations between the astrometric parameters present for some of the less densely observed objects and the inhomogeneous coverage in this first data release (solution id: 1635378410781933568).source_idUnique source identifiermeta.id;meta.mainlongindexedprimaryraBarycentric Right Ascension in ICRS at ref_epochdegpos.eq.ra;meta.maindoubleindexednullabledecBarycentric Declination in ICRS at ref_epochdegpos.eq.dec;meta.maindoubleindexednullablera_errorStandard error of ra (with cos δ applied).masstat.error;pos.eq.rafloatnullabledec_errorStandard error of decmasstat.error;pos.eq.decfloatnullablelGalactic longitude (converted from ra, dec)degpos.galactic.londoublenullablebGalactic latitude (converted from ra, dec)degpos.galactic.latdoublenullablepmraProper motion in right ascension of the source in ICRS at ref_epoch. This is the projection of the proper motion vector in the direction of increasing right ascension.mas/yrpos.pm;pos.eq.rafloatnullablepmdecProper motion in declination at ref_epoch.mas/yrpos.pm;pos.eq.decfloatnullablepmra_errorStandard error of pmramas/yrstat.error;pos.pm;pos.eq.rafloatnullablepmdec_errorStandard error of pmdecmas/yrstat.error;pos.pm;pos.eq.decfloatnullableparallaxAbsolute barycentric stellar parallax of the source at the reference epoch ref_epochmaspos.parallaxfloatnullableparallax_errorStandard error of parallaxmasstat.error;pos.parallaxfloatnullablephot_g_mean_magMean magnitude in the G band. This is computed from the G-band mean flux applying the magnitude zero-point in the Vega scale.magphot.mag;em.opt;stat.meanfloatnullablephot_g_mean_fluxG-band mean flux as electrons per second.s**-1phot.flux;em.opt;stat.meandoublenullablephot_g_mean_flux_errorError on phot_g_mean_fluxs**-1stat.error;phot.flux;em.opt;stat.meanfloatnullablephot_g_n_obsNumber of observations contributing to G photometrymeta.numbershortnullablephot_variable_flagPhotometric variability flagmeta.code;src.varcharnullableref_epochReference epoch to which the astrometic source parameters are referred, expressed as a Julian Year in TCB.yrmeta.ref;time.epochdoublenullableastrometric_delta_qHipparcos/Gaia data discrepancy (Hipparcos subset of TGAS only)stat.valuefloatnullableastrometric_excess_noiseExcess noise of the sourcemasstat.valuefloatnullableastrometric_excess_noise_sigSignificance of excess noisestat.valuefloatnullableastrometric_n_obs_acTotal number of observations ACmeta.numbershortastrometric_n_obs_alTotal number of observations ALmeta.numbershortastrometric_n_bad_obs_acNumber of bad observations ACmeta.numbershortastrometric_n_bad_obs_alNumber of bad observations ALmeta.numbershortastrometric_n_good_obs_acNumber of good observations ACmeta.numbershortastrometric_n_good_obs_alNumber of good observations ALmeta.numbershortastrometric_primary_flagOnly primary sources (for which this flag is True) contribute to the estimation of attitude, calibration, and global parameters. The estimation of source parameters is not affected by primariness.meta.codeshortmatched_observationsThe number of observations (detection transits) that have been matched to a given source during the last internal crossmatch revision.meta.numbershortastrometric_priors_usedType of prior used in in the astrometric solutionshortnullableastrometric_relegation_factorRelegation factor of the source calculated as per Eq. (118) in 2012A&A...538A..78L used for the primary selection process.arith.factorfloatnullableastrometric_weight_acMean astrometric weight of the sourcemas**-2stat.weight;stat.meanfloatnullableastrometric_weight_alMean astrometric weight of the sourcemas**-2stat.weight;stat.meanfloatnullableduplicated_sourceDuring data processing, this source happened to been duplicated and one source only has been kept.shortra_dec_corrCorrelation between right ascension and declinationstat.correlationfloatnullablera_pmra_corrCorrelation between right ascension and proper motion in right ascensionstat.correlationfloatnullablera_pmdec_corrCorrelation between right ascension and proper motion in declinationstat.correlationfloatnullabledec_pmra_corrCorrelation between declination and proper motion in right ascensionstat.correlationfloatnullabledec_pmdec_corrCorrelation between declination and proper motion in declinationstat.correlationfloatnullablepmra_pmdec_corrCorrelation between proper motion in right ascension and proper motion in declinationstat.correlationfloatnullablera_parallax_corrCorrelation between right ascension and parallaxstat.correlationfloatnullabledec_parallax_corrCorrelation between declination and parallaxstat.correlationfloatnullableparallax_pmra_corrCorrelation between parallax and proper motion in right ascensionstat.correlationfloatnullableparallax_pmdec_corrCorrelation between parallax and proper motion in declinationstat.correlationfloatnullablescan_direction_mean_k1Mean position angle of scan directions across the sourcedegfloatnullablescan_direction_strength_k1Degree of concentration of scan directions across the sourcefloatnullablescan_direction_mean_k2Mean position angle of scan directions across the sourcedegfloatnullablescan_direction_strength_k2Degree of concentration of scan directions across the sourcefloatnullablescan_direction_mean_k3Mean position angle of scan directions across the sourcedegfloatnullablescan_direction_strength_k3Degree of concentration of scan directions across the sourcefloatnullablescan_direction_mean_k4Mean position angle of scan directions across the sourcedegfloatnullablescan_direction_strength_k4Degree of concentration of scan directions across the sourcefloatnullablerandom_indexRandom index that can be used to deterministically select subsetsmeta.codelong
ivoaDefinition and support code for the ObsCore data model and table.ivoa.obscoreThe IVOA-defined obscore table, containing generic metadata for datasets within this datacenter.dataproduct_typeHigh level scientific classification of the data product, taken from an enumerationmeta.idobscore:obs.dataproducttypecharnullabledataproduct_subtypeData product specific typemeta.idobscore:obs.dataproductsubtypecharnullablecalib_levelAmount of data processing that has been applied to the datameta.code;obs.calibobscore:obs.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.url;meta.curationobscore:curation.publisherdidcharnullableobs_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.c1doublenullables_decDec of (center of) observation, ICRSdegpos.eq.decobscore:char.spatialaxis.coverage.location.coord.position2d.value2.c2doublenullables_fovApproximate spatial extent for the region covered by the observationdegphys.angSize;instr.fovobscore:char.spatialaxis.coverage.bounds.extent.diameterdoublenullables_regionRegion covered by the observation, as a polygonphys.angArea;obsobscore:char.spatialaxis.coverage.support.areadoublenullables_resolutionBest spatial resolution within the data setarcsecpos.angResolutionobscore:Char.SpatialAxis.Resolution.refvaldoublenullablet_minLower bound of times represented in the data set, as MJDdtime.start;obs.exposureobscore:char.timeaxis.coverage.bounds.limits.interval.starttimedoublenullablet_maxUpper bound of times represented in the data set, as MJDdtime.end;obs.exposureobscore:char.timeaxis.coverage.bounds.limits.interval.stoptimedoublenullablet_exptimeTotal exporure timestime.duration;obs.exposureobscore:char.timeaxis.coverage.support.extentfloatnullablet_resolutionMinimal significant time interval along the time axisstime.resolutionobscore:char.timeaxis.resolution.refvalfloatnullableem_minMinimal wavelength represented within the data setmem.wl;stat.minobscore:char.spectralaxis.coverage.bounds.limits.interval.lolimdoublenullableem_maxMaximal wavelength represented within the data setmem.wl;stat.maxobscore:char.spectralaxis.coverage.bounds.limits.interval.hilimdoublenullableem_res_powerSpectral resolving power delta lambda/lamdaspect.resolutionobscore:char.spectralaxis.resolution.resolpower.refvaldoublenullableo_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.numBins1longnullables_xel2Number of elements (typically pixels) along the second spatial axis.meta.numberobscore:Char.SpatialAxis.numBins1longnullablet_xelNumber of elements (typically pixels) along the time axis.meta.numberobscore:Char.TimeAxis.numBinslongnullableem_xelNumber of elements (typically pixels) along the spectral axis.meta.numberobscore:Char.SpectralAxis.numBinslongnullablepol_xelNumber of elements (typically pixels) along the polarization axis.meta.numberobscore:Char.SpectralAxis.numBinslongnullables_pixel_scaleSampling period in world coordinate units along the spatial axisarcsecphys.angSize;instr.pixelobscore:Char.SpatialAxis.Sampling.RefVal.SamplingPerioddoublenullableem_ucdNature of the product's spectral axismeta.ucdobscore:Char.SpectralAxis.ucdcharnullable
openngcOpenNGC OpenNGC is a database containing positions and main data of NGC (New General Catalogue) and IC (Index Catalogue) objects. It has been built by merging data from NED, HyperLEDA, SIMBAD, and several databases available at HEASARC. In this VO publication, we have changed most of the column names, mostly to make them work as ADQL column names without resorting to delimited identifiers. The mapping should be obvious.openngc.data OpenNGC is a database containing positions and main data of NGC (New General Catalogue) and IC (Index Catalogue) objects. It has been built by merging data from NED, HyperLEDA, SIMBAD, and several databases available at HEASARC. In this VO publication, we have changed most of the column names, mostly to make them work as ADQL column names without resorting to delimited identifiers. The mapping should be obvious.nameObject identifier, either from NGC or from IC.charindexednullableobj_typeObject Type. See note for terms and symbols used.charindexednullableraj2000Right Ascension in ICRS for Epoch J2000.0.degdoublenullabledej2000Declination in ICRS for Epoch J2000.0.degdoublenullableconstellationConstellation the object is located in.charnullablemaj_ax_degMajor axis of covering ellipsoid.degfloatnullablemin_ax_degMinor axis of covering ellipsoid.degfloatnullablepos_angPosition angle of covering ellipsoid, north over east.degfloatnullablemag_bApparent total magnitude in the B Band.magfloatnullablemag_vApparent total magnitude in the V Band.magfloatnullablemag_jApparent total magnitude in the J Band.magfloatnullablemag_hApparent total magnitude in the H Band.magfloatnullablemag_kApparent total magnitude in the K Band.magfloatnullablesurf_br_bMean surface brigthness within the 25 mag isophote (B-band); only given for galaxiesmag/arcsec**2floatnullablehubble_typeMorphological Hubble type for galaxies.charindexednullablecstar_mag_uFor planetary nebulae: Apparent magnitude of the central star in the U Band.magfloatnullablecstar_mag_bFor planetary nebulae: Apparent magnitude of the central star in the B Band.magfloatnullablecstar_mag_vFor planetary nebulae: Apparent magnitude of the central star in the V Band.magfloatnullablemessier_nrMessier number for this objectintnullableother_ngcOther NGC number for this object in case it was duplicated in IC or NCG.charnullableic_crossOther IC number for this object in case it was duplicated in IC or NCG.charnullablecstar_idIdentifier of the central star for planetary nebulae.charnullableother_idCross reference to other catalogs.charnullablecomnameCommon name(s) of the object.charnullablened_notesNotes about the object exported from NEDcharnullablenotesNotes about the object from OpenNGCcharnullable
tap_schema ChiVO's Table Access Protocol (TAP) service with table metadata.tap_schema.schemasSchemas containing tables available for ADQL querying.schema_nameFully qualified schema namecharindexedprimarydescriptionBrief description of the schemacharnullableutypeutype if schema corresponds to a data modelcharnullable
tap_schema.tablesTables available for ADQL querying.schema_nameFully qualified schema namecharnullabletable_nameFully qualified table namecharindexedprimarytable_typeOne of: table, viewcharnullabledescriptionBrief description of the tablecharnullableutypeutype 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)charnullable
tap_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_name
tap_schema.keysForeign key relationships between tables available for ADQL querying.key_idUnique key identifiercharindexedprimaryfrom_tableFully qualified table namecharnullabletarget_tableFully qualified table namecharnullabledescriptionDescription of this keycharnullableutypeUtype of this keycharnullablesourcerdId of the originating rd (local information)charnullable
tap_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)charnullable
tap_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 withing the groupcharnullablegroup_nameName of the groupcharnullablegroup_utypeutype of the groupcharnullablesourcerdId of the originating rd (local information)charnullabletap_schema.tablestable_nametable_name
tgasTGAS catalogue This table is a subset of GaiaSource comprising those stars in the Hipparcos and Tycho-2 Catalogues for which a full 5-parameter astrometric solution has been possible in Gaia Data Release 1. This is possible because the early Hipparcos epoch positions break some degeneracies due to the limited Gaia time coverage. This table contains a substantial fraction of the around 2.5 million stars in the Hipparcos and Tycho-2 catalogue. Many stars have been excluded due to several reasons, such as saturation, cross-match errors or bad astrometric solution. All rows have Gaia solution id 1635378410781933568.tgas.main This table is a subset of GaiaSource comprising those stars in the Hipparcos and Tycho-2 Catalogues for which a full 5-parameter astrometric solution has been possible in Gaia Data Release 1. This is possible because the early Hipparcos epoch positions break some degeneracies due to the limited Gaia time coverage. This table contains a substantial fraction of the around 2.5 million stars in the Hipparcos and Tycho-2 catalogue. Many stars have been excluded due to several reasons, such as saturation, cross-match errors or bad astrometric solution. All rows have Gaia solution id 1635378410781933568.source_idUnique source identifiermeta.id;meta.mainlongindexedprimaryraBarycentric Right Ascension in ICRS at ref_epochdegpos.eq.ra;meta.maindoubleindexednullabledecBarycentric Declination in ICRS at ref_epochdegpos.eq.dec;meta.maindoubleindexednullablera_errorStandard error of ra (with cos δ applied).masstat.error;pos.eq.rafloatnullabledec_errorStandard error of decmasstat.error;pos.eq.decfloatnullablelGalactic longitude (converted from ra, dec)degpos.galactic.londoublenullablebGalactic latitude (converted from ra, dec)degpos.galactic.latdoublenullablepmraProper motion in right ascension of the source in ICRS at ref_epoch. This is the projection of the proper motion vector in the direction of increasing right ascension.mas/yrpos.pm;pos.eq.radoublenullablepmdecProper motion in declination at ref_epoch.mas/yrpos.pm;pos.eq.decdoublenullablepmra_errorStandard error of pmramas/yrstat.error;pos.pm;pos.eq.rafloatnullablepmdec_errorStandard error of pmdecmas/yrstat.error;pos.pm;pos.eq.decfloatnullableparallaxAbsolute barycentric stellar parallax of the source at the reference epoch ref_epochmaspos.parallaxfloatnullableparallax_errorStandard error of parallaxmasstat.error;pos.parallaxfloatnullablephot_g_mean_magMean magnitude in the G band. This is computed from the G-band mean flux applying the magnitude zero-point in the Vega scale.magphot.mag;em.opt;stat.meanfloatnullablephot_g_mean_fluxG-band mean flux as electrons per second.s**-1phot.flux;em.opt;stat.meandoublenullablephot_g_mean_flux_errorError on phot_g_mean_fluxs**-1stat.error;phot.flux;em.opt;stat.meanfloatnullablephot_g_n_obsNumber of observations contributing to G photometrymeta.numbershortnullablephot_variable_flagPhotometric variability flagmeta.code;src.varcharnullableref_epochReference epoch to which the astrometic source parameters are referred, expressed as a Julian Year in TCB.yrmeta.ref;time.epochdoublenullableastrometric_delta_qHipparcos/Gaia data discrepancy (Hipparcos subset of TGAS only)stat.valuefloatnullableastrometric_excess_noiseExcess noise of the sourcemasstat.valuefloatnullableastrometric_excess_noise_sigSignificance of excess noisestat.valuefloatnullableastrometric_n_obs_acTotal number of observations ACmeta.numbershortastrometric_n_obs_alTotal number of observations ALmeta.numbershortastrometric_n_bad_obs_acNumber of bad observations ACmeta.numbershortastrometric_n_bad_obs_alNumber of bad observations ALmeta.numbershortastrometric_n_good_obs_acNumber of good observations ACmeta.numbershortastrometric_n_good_obs_alNumber of good observations ALmeta.numbershortastrometric_primary_flagOnly primary sources (for which this flag is True) contribute to the estimation of attitude, calibration, and global parameters. The estimation of source parameters is not affected by primariness.meta.codeshortmatched_observationsThe number of observations (detection transits) that have been matched to a given source during the last internal crossmatch revision.meta.numbershortastrometric_priors_usedType of prior used in in the astrometric solutionshortnullableastrometric_relegation_factorRelegation factor of the source calculated as per Eq. (118) in 2012A&A...538A..78L used for the primary selection process.arith.factorfloatnullableastrometric_weight_acMean astrometric weight of the sourcemas**-2stat.weight;stat.meanfloatnullableastrometric_weight_alMean astrometric weight of the sourcemas**-2stat.weight;stat.meanfloatnullableduplicated_sourceDuring data processing, this source happened to been duplicated and one source only has been kept.shortra_dec_corrCorrelation between right ascension and declinationstat.correlationfloatnullablera_pmra_corrCorrelation between right ascension and proper motion in right ascensionstat.correlationfloatnullablera_pmdec_corrCorrelation between right ascension and proper motion in declinationstat.correlationfloatnullabledec_pmra_corrCorrelation between declination and proper motion in right ascensionstat.correlationfloatnullabledec_pmdec_corrCorrelation between declination and proper motion in declinationstat.correlationfloatnullablepmra_pmdec_corrCorrelation between proper motion in right ascension and proper motion in declinationstat.correlationfloatnullablera_parallax_corrCorrelation between right ascension and parallaxstat.correlationfloatnullabledec_parallax_corrCorrelation between declination and parallaxstat.correlationfloatnullableparallax_pmra_corrCorrelation between parallax and proper motion in right ascensionstat.correlationfloatnullableparallax_pmdec_corrCorrelation between parallax and proper motion in declinationstat.correlationfloatnullablescan_direction_mean_k1Mean position angle of scan directions across the sourcedegfloatnullablescan_direction_strength_k1Degree of concentration of scan directions across the sourcefloatnullablescan_direction_mean_k2Mean position angle of scan directions across the sourcedegfloatnullablescan_direction_strength_k2Degree of concentration of scan directions across the sourcefloatnullablescan_direction_mean_k3Mean position angle of scan directions across the sourcedegfloatnullablescan_direction_strength_k3Degree of concentration of scan directions across the sourcefloatnullablescan_direction_mean_k4Mean position angle of scan directions across the sourcedegfloatnullablescan_direction_strength_k4Degree of concentration of scan directions across the sourcefloatnullablerandom_indexRandom index that can be used to deterministically select subsetsmeta.codelonghipHipparcos identifierintnullabletycho2_idTycho 2 identifiercharnullable