4.3 igsl_source_catalog_ids

SourceId in original catalogues

Columns description:

solution_id : Solution Identifier (long)

The data in the MDB will be described by means of a ”Solution identifier” parameter. This will be a numeric field attached to each table row that can be used to unequivocally identify the version of all the subsystems that where used in the generation of the data as well as the input data used. Each DPC generating the data will have the freedom to choose the Solution identifier number, but they must ensure that given the Solution identifier they can provide detailed information about the ”conditions” used to generate the data: versions of the software, version of the data used…

source_id : Gaia source id from IGSL2 (long)

A unique single numerical identifier of the source (for a detailed description see gaia_source.source_id)

id_gsc23 : Identifier in ref. catalogs (long)

These are the IDs as published in the various input catalogs converted to a big integer. For the GSC23 we have had to alter slightly the name,specifically: GSC2.3 objects have original names that are combination of region names and running number, e.g. S00000001 is the first object in the region S0000000, we have converted the region names to the “official” numerical values in the htm level 6 structure, hence the smallest is S0000000 = 32768 and N3333333 = 65535 is the highest.

id_sdss : Identifier in ref. catalogs (long)

These are the IDs as published in the SDSS DR9 in big integer format.

id_ucac : Identifier in ref. catalogs (int)

These are the IDs as published in the UCAC4 specfically a running star ID number.

id_lqrf : Identifier in ref. catalogs (int)

These are the running number in the Gaia Initial Quasar Catalog - version 4 - updated September 2011 - GIQC_4.

id_tycho : Identifier in ref. catalogs (long)

These are the IDs as published in Tycho2. In TYCHO-2 objects were identified by 3 numbers (TYC1,TYC2 and TYC3) and we have combined these into one complete number given by
(TYC1*1000000.0d0)+(TYC2*10.0d0)+(TYC3*1.0d0)

id_hip : Hipparcos number (int)

If the source is a Hipparcos star this field contains the Hipparcos number.

id_ppmxl : PPMXL Identifier (long)

These are the IDs as published in the PPMXL, the ipix Identifier (Q3C ipix of the USNO-B 1.0 object) converted to a big integer.

id_ogle : OGLE Identifier (long)

The OGLE ID is given by a combination of
A region of sky identifier (RI) equal to 10, 11, 12, 13, 14 corresponding to map names blg, car, cen, lmc, mus.
The file running number ( NNN.N)
The running number in the file (RN)
The ID is defined as: long(string(RI)+string(NNN.N * 10000))+RN.

id_tmass : Identifier in ref. catalogs (long)

The Two Mass provided the names in a IAU standard fashion of 2MASS JHHMMSS.S +DDMMSS.S these were codeified as +HHMMSSSDDMMSSS.

id_epc : Identifier in ref. catalogs (string)

The IDs in the Gaia Ecliptic Pole Catalogue Version (GEPC 3.0) given as IAU standards:
JHHMMSS.SS+DDMMSS.S.