SQL Schema: Tables

Important announcements

The database for AKARI CAS was restructured into multiple databases. The 'cas' database is available as a new database instead of 'DR1'.
Due to the reconfiguration of the database, the name of some tables and views had changed. If you keep the previously created SQL and want to use again, please do substitution of the name. And also, the usage of some functions had changed.
The correspondence between the new name and the old name is written in Tables and Views. In Functions, please specify the catalogue names ('akari_fis_bsc_1' or 'akari_irc_psc_1') instead of the instrument ('Fis' or 'Irc'). We appreciate in your inconvenience.

The summary is below:

Index of Tables:

Table name after January, 2018 Table name until December, 2017 Description
akari_fis_bsc_1 FisObjALL AKARI FIS Bright Source Catalogue v1.0 (AKARI FIS BSC 1.0).
akari_irc_psc_1 IrcObjALL AKARI IRC Point Source Catalogue v1.0 (AKARI IRC PSC 1.0).
rc3 RC3 Third Reference Catalog of Bright Galaxies (RC3 catalog). All J2000 positions (ra and dec) were updated using NED service to get enough accuracy.
iras Iras IRAS Point Source Catalog v2.1 (IRAS PSC).
irasfsc IrasFsc IRAS Faint Source Catalog v2.0 (IRAS FSC).
twomass Twomass 2MASS Point Source Catalog (2MASS PSC).
simbad_fis_irc_cache SimbadCache Object data of cached SIMBAD entries.
simbad_fis_irc_ident SimbadIdent Identifier data of cached SIMBAD entries.
simbad_fis_cache SimbadFis Relation between SIMBAD OID and FIS objID.
simbad_irc_cache SimbadIrc Relation between SIMBAD OID and IRC objID.
ned_fis_irc_cache NedCache Object data of cached NED entries.
ned_fis_cache NedFis Relation between NED objName and FIS objID.
ned_irc_cache NedIrc Relation between NED objName and IRC objID.

Symbol for Database Index

P Primary Key
S Single Column Index
Cn Composite Index
Un Unique Constraint

TABLE   akari_fis_bsc_1

AKARI FIS Bright Source Catalogue v1.0 (AKARI FIS BSC 1.0; 427071 rows).

This table has a view: akari_fis_bsc_1_digest

Table contents.
name type index unit description
objIDINT4 P Unique identifier for the DARTS database. objID is defined like VVxxxxxx in the decimal system. VV indicates the version code of catalog, and xxxxxx shows row number. Do not refer this ID in your literatures.
objNameCHAR(14) U Source identifier from its J2000 coordinates, following the IAU Recommendations for Nomenclature (2006). The format is HHMMSSS+/-DDMMSS, e.g., 0123456+765432 for a source at (01h23m45.6s, +76d54m32s). The source must be referred to in the literatures by its full name; AKARI-FIS-V1 J0123456+765432.
raFLOAT8 S deg J2000 Right Ascension of the source position.
decFLOAT8 S deg J2000 Declination of the source position.
cxFLOAT8 C1 Unit vector for ra+dec
cyFLOAT8 C1 Unit vector for ra+dec
czFLOAT8 C1 Unit vector for ra+dec
ra1950FLOAT8 S deg Right Ascension (B1950)
dec1950FLOAT8 S deg Declination (B1950)
lambdaFLOAT8 S deg Ecliptic longitude
betaFLOAT8 S deg Ecliptic latitude
lFLOAT8 S deg Galactic longitude
bFLOAT8 S deg Galactic latitude
posErrMjFLOAT4 arcsec One-sigma error of the source position expressed by an ellipse with Major and Minor axes in arcsec, and Position Angle in degees measured from North to East. In the currently version we give the same value (6.0 arcsec) for all the sources both in the major and minor axis (thus polar-angle is 0.0) based on the statistical analysis in Section 5.5 of the Release Note .
posErrMiFLOAT4 arcsec One-sigma error of the source position expressed by an ellipse with Major and Minor axes in arcsec, and Position Angle in degees measured from North to East. In the currently version we give the same value (6.0 arcsec) for all the sources both in the major and minor axis (thus polar-angle is 0.0) based on the statistical analysis in Section 5.5 of the Release Note .
posErrPAFLOAT4 deg One-sigma error of the source position expressed by an ellipse with Major and Minor axes in arcsec, and Position Angle in degees measured from North to East. In the currently version we give the same value (6.0 arcsec) for all the sources both in the major and minor axis (thus polar-angle is 0.0) based on the statistical analysis in Section 5.5 of the Release Note .
flux_65FLOAT4 S Jy Flux density of the source in the four FIS bands in Jansky. In the catalogue the four FIS bands are indicated by their central wavelength as 65, 90, 140 and 160.
Values are given even for the unconfirmed sources as much as possible, though such the data are not guaranteed. If it is not possible to measure the source flux, `NULL' is set.
flux_90FLOAT4 S Jy Flux density of the source in the four FIS bands in Jansky. In the catalogue the four FIS bands are indicated by their central wavelength as 65, 90, 140 and 160.
Values are given even for the unconfirmed sources as much as possible, though such the data are not guaranteed. If it is not possible to measure the source flux, `NULL' is set.
flux_140FLOAT4 S Jy Flux density of the source in the four FIS bands in Jansky. In the catalogue the four FIS bands are indicated by their central wavelength as 65, 90, 140 and 160.
Values are given even for the unconfirmed sources as much as possible, though such the data are not guaranteed. If it is not possible to measure the source flux, `NULL' is set.
flux_160FLOAT4 S Jy Flux density of the source in the four FIS bands in Jansky. In the catalogue the four FIS bands are indicated by their central wavelength as 65, 90, 140 and 160.
Values are given even for the unconfirmed sources as much as possible, though such the data are not guaranteed. If it is not possible to measure the source flux, `NULL' is set.
fErr_65FLOAT4 Jy Flux uncertainty of the source flux in Jansky. It is evaluated as the standard deviation of the fluxes measured on the individual scans divided by the root square of the number of measurements (presented in nScanC_65). The error thus only includes relative uncertainty at the measurements. Details of the flux uncertainty are discussed in Section 5.3 of the Release Note .
When it is not possible to calculate the standard deviation, `NULL' is set to this column.
fErr_90FLOAT4 Jy Flux uncertainty of the source flux in Jansky. It is evaluated as the standard deviation of the fluxes measured on the individual scans divided by the root square of the number of measurements (presented in nScanC_90). The error thus only includes relative uncertainty at the measurements. Details of the flux uncertainty are discussed in Section 5.3 of the Release Note .
When it is not possible to calculate the standard deviation, `NULL' is set to this column.
fErr_140FLOAT4 Jy Flux uncertainty of the source flux in Jansky. It is evaluated as the standard deviation of the fluxes measured on the individual scans divided by the root square of the number of measurements (presented in nScanC_140). The error thus only includes relative uncertainty at the measurements. Details of the flux uncertainty are discussed in Section 5.3 of the Release Note .
When it is not possible to calculate the standard deviation, `NULL' is set to this column.
fErr_160FLOAT4 Jy Flux uncertainty of the source flux in Jansky. It is evaluated as the standard deviation of the fluxes measured on the individual scans divided by the root square of the number of measurements (presented in nScanC_160). The error thus only includes relative uncertainty at the measurements. Details of the flux uncertainty are discussed in Section 5.3 of the Release Note .
When it is not possible to calculate the standard deviation, `NULL' is set to this column.
fQual_65INT2 S Four level flux quality indicator:
3:  High quality (the source is confirmed and flux is reliable)
2:  The source is confirmed but flux is not reliable (see flags_65)
1:  The source is not confirmed
0:  Not observed (no scan data available)
fQual_90INT2 S Four level flux quality indicator:
3:  High quality (the source is confirmed and flux is reliable)
2:  The source is confirmed but flux is not reliable (see flags_90)
1:  The source is not confirmed
0:  Not observed (no scan data available)
fQual_140INT2 S Four level flux quality indicator:
3:  High quality (the source is confirmed and flux is reliable)
2:  The source is confirmed but flux is not reliable (see flags_140)
1:  The source is not confirmed
0:  Not observed (no scan data available)
fQual_160INT2 S Four level flux quality indicator:
3:  High quality (the source is confirmed and flux is reliable)
2:  The source is confirmed but flux is not reliable (see flags_160)
1:  The source is not confirmed
0:  Not observed (no scan data available)
flags_65INT2 S A 16-bit flag per band indicating various data condition. In version 1 catalogue three bits are used. The first bit (bit0) is used to indicate the CDS sampling mode. The second bit (bit1) warns the flux of the band is less than a half of the detection limit, and is not reliable. The fourth bit (bit3) tells that the source is possibly false detection due to `side-lobe' effects (see, Section 7.7 of the Release Note). The third bit (bit2) was previously indicated an anomaly which does not exist in the current version, and thus is kept unused. Sources with bit1 or bit3 = 1 have fQual_65 = 2 or less. Other bits are reserved for the future implementation.
                                   USB ------------- bit ----- LSB
                                       ... 7  6  5  4  3  2  1  0
                                   decimal |  |  |  |  |  |  |  |
   reserved ------------------------- 128 -+  |  |  |  |  |  |  |
   reserved -------------------------- 64 ----+  |  |  |  |  |  |
   reserved -------------------------- 32 -------+  |  |  |  |  |
   reserved -------------------------- 16 ----------+  |  |  |  |
   1: possibly `side-lobe' detection--- 8 -------------+  |  |  |
   not used --------------------------- 4 ----------------+  |  |
   1: Flux too low--------------------- 2 -------------------+  |
   0: Normal mode, 1: CDS mode -------- 1 ----------------------+
   
`NULL' is set in case of no measurement (fQual_65 = 0).
flags_90INT2 S A 16-bit flag per band indicating various data condition. In version 1 catalogue three bits are used. The first bit (bit0) is used to indicate the CDS sampling mode. The second bit (bit1) warns the flux of the band is less than a half of the detection limit, and is not reliable. The fourth bit (bit3) tells that the source is possibly false detection due to `side-lobe' effects (see, Section 7.7 of the Release Note). The third bit (bit2) was previously indicated an anomaly which does not exist in the current version, and thus is kept unused. Sources with bit1 or bit3 = 1 have fQual_90 = 2 or less. Other bits are reserved for the future implementation.
                                   USB ------------- bit ----- LSB
                                       ... 7  6  5  4  3  2  1  0
                                   decimal |  |  |  |  |  |  |  |
   reserved ------------------------- 128 -+  |  |  |  |  |  |  |
   reserved -------------------------- 64 ----+  |  |  |  |  |  |
   reserved -------------------------- 32 -------+  |  |  |  |  |
   reserved -------------------------- 16 ----------+  |  |  |  |
   1: possibly `side-lobe' detection--- 8 -------------+  |  |  |
   not used --------------------------- 4 ----------------+  |  |
   1: Flux too low--------------------- 2 -------------------+  |
   0: Normal mode, 1: CDS mode -------- 1 ----------------------+
   
`NULL' is set in case of no measurement (fQual_90 = 0).
flags_140INT2 S A 16-bit flag per band indicating various data condition. In version 1 catalogue three bits are used. The first bit (bit0) is used to indicate the CDS sampling mode. The second bit (bit1) warns the flux of the band is less than a half of the detection limit, and is not reliable. The fourth bit (bit3) tells that the source is possibly false detection due to `side-lobe' effects (see, Section 7.7 of the Release Note). The third bit (bit2) was previously indicated an anomaly which does not exist in the current version, and thus is kept unused. Sources with bit1 or bit3 = 1 have fQual_140 = 2 or less. Other bits are reserved for the future implementation.
                                   USB ------------- bit ----- LSB
                                       ... 7  6  5  4  3  2  1  0
                                   decimal |  |  |  |  |  |  |  |
   reserved ------------------------- 128 -+  |  |  |  |  |  |  |
   reserved -------------------------- 64 ----+  |  |  |  |  |  |
   reserved -------------------------- 32 -------+  |  |  |  |  |
   reserved -------------------------- 16 ----------+  |  |  |  |
   1: possibly `side-lobe' detection--- 8 -------------+  |  |  |
   not used --------------------------- 4 ----------------+  |  |
   1: Flux too low--------------------- 2 -------------------+  |
   0: Normal mode, 1: CDS mode -------- 1 ----------------------+
   
`NULL' is set in case of no measurement (fQual_140 = 0).
flags_160INT2 S A 16-bit flag per band indicating various data condition. In version 1 catalogue three bits are used. The first bit (bit0) is used to indicate the CDS sampling mode. The second bit (bit1) warns the flux of the band is less than a half of the detection limit, and is not reliable. The fourth bit (bit3) tells that the source is possibly false detection due to `side-lobe' effects (see, Section 7.7 of the Release Note). The third bit (bit2) was previously indicated an anomaly which does not exist in the current version, and thus is kept unused. Sources with bit1 or bit3 = 1 have fQual_160 = 2 or less. Other bits are reserved for the future implementation.
                                   USB ------------- bit ----- LSB
                                       ... 7  6  5  4  3  2  1  0
                                   decimal |  |  |  |  |  |  |  |
   reserved ------------------------- 128 -+  |  |  |  |  |  |  |
   reserved -------------------------- 64 ----+  |  |  |  |  |  |
   reserved -------------------------- 32 -------+  |  |  |  |  |
   reserved -------------------------- 16 ----------+  |  |  |  |
   1: possibly `side-lobe' detection--- 8 -------------+  |  |  |
   not used --------------------------- 4 ----------------+  |  |
   1: Flux too low--------------------- 2 -------------------+  |
   0: Normal mode, 1: CDS mode -------- 1 ----------------------+
   
`NULL' is set in case of no measurement (fQual_160 = 0).
nScanC_65INT2 S Number of scans on which the source is properly detected with logEvidence larger than the threshold.
nScanC_90INT2 S Number of scans on which the source is properly detected with logEvidence larger than the threshold.
nScanC_140INT2 S Number of scans on which the source is properly detected with logEvidence larger than the threshold.
nScanC_160INT2 S Number of scans on which the source is properly detected with logEvidence larger than the threshold.
nScanP_65INT2 S Total number of scans that passed on the source (that possibly observed the source)
nScanP_90INT2 S Total number of scans that passed on the source (that possibly observed the source)
nScanP_140INT2 S Total number of scans that passed on the source (that possibly observed the source)
nScanP_160INT2 S Total number of scans that passed on the source (that possibly observed the source)
mConf_65INT2 S The month confirmation flags are prepared per band. The value is 1 when the source is observed in the scans separated more than one months (usually an object is visible at every 6 months). This information is independent to hours confirmation and can be 1 even if the source is not confirmed (fQual_65 = 1). Because of the visibility constraint of the AKARI Survey, some sky regions were observed by scans only within a month.
This flag is `NULL' for fQual_65 = 0 sources.
mConf_90INT2 S The month confirmation flags are prepared per band. The value is 1 when the source is observed in the scans separated more than one months (usually an object is visible at every 6 months). This information is independent to hours confirmation and can be 1 even if the source is not confirmed (fQual_90 = 1). Because of the visibility constraint of the AKARI Survey, some sky regions were observed by scans only within a month.
This flag is `NULL' for fQual_90 = 0 sources.
mConf_140INT2 S The month confirmation flags are prepared per band. The value is 1 when the source is observed in the scans separated more than one months (usually an object is visible at every 6 months). This information is independent to hours confirmation and can be 1 even if the source is not confirmed (fQual_140 = 1). Because of the visibility constraint of the AKARI Survey, some sky regions were observed by scans only within a month.
This flag is `NULL' for fQual_140 = 0 sources.
mConf_160INT2 S The month confirmation flags are prepared per band. The value is 1 when the source is observed in the scans separated more than one months (usually an object is visible at every 6 months). This information is independent to hours confirmation and can be 1 even if the source is not confirmed (fQual_160 = 1). Because of the visibility constraint of the AKARI Survey, some sky regions were observed by scans only within a month.
This flag is `NULL' for fQual_160 = 0 sources.
nDensINT2 S Number of sources in the catalogue within the distance of 5 arcmin from the source. This value is intended to be an indicator of crowdedness of the sky region. Since the source extraction program is tuned so that a unique source is found within 48 arcsec radius, the 5 arcmin radius corresponds to approximately 40 beams.

TABLE   akari_irc_psc_1

AKARI IRC Point Source Catalogue v1.0 (AKARI IRC PSC 1.0; 870973 rows).

This table has a view:akari_irc_psc_1_digest

Table contents.
name type index unit description
objIDINT4 P Unique identifier for the DARTS database. objID is defined like VVxxxxxxxx in the decimal system. VV indicates the version code of catalog, and xxxxxxxx shows row number. Do not refer this ID in your literatures.
objNameCHAR(14) U Source name from its J2000 coordinates, following the IAU Recommendations for Nomenclature (2006). The format is HHMMSSS+/-DDMMSS, e.g., 0123456+765432 for a source at (01h23m45.6s, +76d54m32s). The source must be referred to in the literatures by its full name: AKARI-IRC-V1 J0123456+765432, where V1 refers to the version code.
raFLOAT8 S deg J2000 Right Ascension of the source position.
decFLOAT8 S deg J2000 Declination of the source position.
cxFLOAT8 C1 Unit vector for ra+dec
cyFLOAT8 C1 Unit vector for ra+dec
czFLOAT8 C1 Unit vector for ra+dec
ra1950FLOAT8 S deg Right Ascension (B1950)
dec1950FLOAT8 S deg Declination (B1950)
lambdaFLOAT8 S deg Ecliptic longitude
betaFLOAT8 S deg Ecliptic latitude
lFLOAT8 S deg Galactic longitude
bFLOAT8 S deg Galactic latitude
posErrMjFLOAT4 arcsec One-sigma error of the source position expressed by an ellipse with Major and Minor axes [arcsec], and Position Angle [deg; East from North]. If only two events are available, posErrMj is calculated from the distance of the two events and PosErrMi is set to the same as PosErrMj.
posErrMiFLOAT4 arcsec One-sigma error of the source position expressed by an ellipse with Major and Minor axes [arcsec], and Position Angle [deg; East from North]. If only two events are available, posErrMj is calculated from the distance of the two events and PosErrMi is set to the same as PosErrMj.
posErrPAFLOAT4 deg One-sigma error of the source position expressed by an ellipse with Major and Minor axes [arcsec], and Position Angle [deg; East from North]. If only two events are available, posErrMj is calculated from the distance of the two events and PosErrMi is set to the same as PosErrMj.
flux_09FLOAT4 S Jy Flux density of the source in S9W in Jansky.
flux_18FLOAT4 S Jy Flux density of the source in L18W in Jansky.
fErr_09FLOAT4 Jy Flux error in S9W.
fErr_18FLOAT4 Jy Flux error in L18W.
fQual_09INT2 S Flux density quality flag for S9W. 3 when flux is valid and 0 when flux is not available.
fQual_18INT2 S Flux density quality flag for L18W. 3 when flux is valid and 0 when flux is not available.
flags_09INT2 S Bit flags of data quality for S9W:
1(LSB): not month confirmed:
This means that the period between the first detection and the last detection is shorter than a month.
2: saturated (not used in this version)
4: use SAA (not used in this version)
8(MSB): use edge events:
If the number of events is too small, we use the event data near the edge of the image strip. In this case, this flag warn you of underestimation of the flux.
flags_18INT2 S Bit flags of data quality for L18W:
1(LSB): not month confirmed:
This means that the period between the first detection and the last detection is shorter than a month.
2: saturated (not used in this version)
4: use SAA (not used in this version)
8(MSB): use edge events:
If the number of events is too small, we use the event data near the edge of the image strip. In this case, this flag warn you of underestimation of the flux.
nScanC_09INT2 S Number of scans on which the source is detected. Normally, nScanC is less or equal to nScanP. In some exceptional case, resultant position of the source drops out from the image stripe boundary and nScanC is larger than nScanP.
nScanC_18INT2 S Number of scans on which the source is detected. Normally, nScanC is less or equal to nScanP. In some exceptional case, resultant position of the source drops out from the image stripe boundary and nScanC is larger than nScanP.
nScanP_09INT2 S The number of times the source position has been scanned during the survey.
nScanP_18INT2 S The number of times the source position has been scanned during the survey.
mConf_09INT2 S 1 is month confirmed and 0 is not. Inverted value of LSB of flags_09
mConf_18INT2 S 1 is month confirmed and 0 is not. Inverted value of LSB of flags_18
nDens_09INT2 S The number of sources in 45 arcsec radius.
nDens_18INT2 S The number of sources in 45 arcsec radius.
extended_09INT2 S The flag indicates that the source is possibly more extended than the point spread function. This is "TRUE" when meanAB > 15.6 [arcsec].
extended_18INT2 S The flag indicates that the source is possibly more extended than the point spread function. This is "TRUE" when meanAB > 15.6 [arcsec].
meanAB_09FLOAT4 The average of radius along major and minor axes of images, i.e. (< a > + < b >)/2 where < a > and < b > are the mean semi-major and semi-minor axis lengths of images estimated by SExtractor.
meanAB_18FLOAT4 The average of radius along major and minor axes of images, i.e. (< a > + < b >)/2 where < a > and < b > are the mean semi-major and semi-minor axis lengths of images estimated by SExtractor.
nDataPosINT2 S Number of events used to calculate the mean coordinates. If the source has more than two available S9W events, the position is estimated from S9W events only, else the position is estimated from L18W events,
i.e. nDataPos = nScanC09 for nScanC09 ≥ 2
nDataPos = nScanC18 for nScanC09 < 2
nData_09INT2 S Number of events that contribute to the flux measurements in the two bands. Normally, events near the edge of the image strip are excluded from the measurements. Note that if only 0 or 1 event are available, the flux is computed also from edge events.
nData_18INT2 S Number of events that contribute to the flux measurements in the two bands. Normally, events near the edge of the image strip are excluded from the measurements. Note that if only 0 or 1 event are available, the flux is computed also from edge events.

TABLE   rc3

Third Reference Catalog of Bright Galaxies (RC3; 23011 rows). All J2000 positions (ra and dec) were updated using NED service to get enough accuracy.
Table contents.
name type index unit description
objIDINT4 P Unique identifier for the DARTS database. objID is defined like 2101xxxxxx in the decimal system. xxxxxx shows row number. Do not refer this ID in your literatures.
nameVARCHAR(12) U Primary name.
aliasesVARCHAR(26) S Other names.
PGC_nameVARCHAR(10) U PGC (Paturel et al. 1989a,b) designation.
raFLOAT8 S deg Updated J2000 R.A. using NED service.
decFLOAT8 S deg Updated J2000 Dec. using NED service.
ra_origFLOAT8 S deg J2000 R.A. in RC3 catalog. The values in this column do not have enough accuracy for a number of objects.
dec_origFLOAT8 S deg J2000 Dec. in RC3 catalog. The values in this column do not have enough accuracy for a number of objects.
good_positionINT4 The values of ra_orig/dec_orig are good to 0.1 sec time, 1 asec. (otherwise, 0.1 min time, 1 amin)
galactic_lFLOAT8 deg Galactic longitude in the IAU 1958 system (Blaauw et al. 1960); good to 0.01 degrees.
galactic_bFLOAT8 deg Galactic latitude in the IAU 1958 system (Blaauw et al. 1960); good to 0.01 degrees.
superGalactic_lFLOAT8 deg Supergalactic longitude in the RC2 system; good to 0.01 degrees.
superGalactic_bFLOAT8 deg Supergalactic latitude in the RC2 system; good to 0.01 degrees.
PosAngleFLOAT8 deg Position angle, measured in degrees from north through east (all p.a. < 180 degrees), taken when available from UGC, ESO, and ESGC (and in a few cases from HI data).
rc2_typeCHAR(7) Mean revised morphological type in the RC2 system, coded as in RC2.
rc2_typeSourceCHAR(6) Sources of revised morphological type estimate.
T_typeFLOAT8 S Mean numerical index of stage along the Hubble sequence in the RC2 system.
T_typeErrFLOAT8 Error in T_type.
LC_rc2FLOAT8 Mean numerical luminosity class in the RC2 system.
LC_rc2ErrFLOAT8 Error in LC_rc2.
n_LFLOAT8 Number of luminosity class estimates.
B_TFLOAT8 mag Total (asymptotic) magnitude in the B system, derived by extrapolation from photoelectric aperture-magnitude data, B_T^A, and from surface photometry with photoelectric zero point, B_T^S.
B_TErrFLOAT8 mag Error in B_T.
B_TsourceCHAR(1) M when B_T is the weighted mean of B_T^A and B_T^S; V when B_T is a V-band magnitude rather than a B-band magnitude; v when the nucleus of the galaxy is variable; * when deriving B_T^A would have required an extrapolation in excess of 0.75 mag.
B_T0FLOAT8 mag Total ``face-on'' magnitude corrected for Galactic and internal extinction, and for redshift.
M_BFLOAT8 mag Photographic magnitude from Ames (1930), Shapley and Ames (1932), CGCG, Buta and Corwin (1986), and/or Lauberts and Valentijn (1989) reduced to the B_T system.
M_BErrFLOAT8 mag Error in M_B.
M_FIRFLOAT8 mag Far-infrared magnitude calculated from M_FIR = - 20.0 - 2.5 log_10(FIR), where FIR is the far infrared continuum flux measured at 60 and 100 microns as listed in the IRAS Point Source Catalog (1987). For galaxies larger than 8 arcmin in RC2 and for the Virgo cluster area, resolved by the IRAS beam, integrated fluxes are taken from Rice et al. (1988) or Helou et al. (1988).
M_21cmFLOAT8 mag 21-cm emission line magnitude, and its mean error, defined by m_21 = 21.6 - 2.5 log(S_H), where S_H is the measured neutral hydrogen flux density in units of 10^-24 W/m^2.
M_21cmErrFLOAT8 mag Error in M_21cm.
BV_TFLOAT8 mag Total (asymptotic) color index in the Johnson B-V system, derived by extrapolation from photoelectric color-aperture data, and/or from surface photometry with photoelectric zero point.
BV_TErrFLOAT8 mag Error in BV_T.
BV_T0FLOAT8 mag Total B-V color index corrected for Galactic and internal extinction, and for redshift.
BV_eFLOAT8 mag Mean B-V color index within the effective aperture A_e, derived by interpolation from photoelectric color-aperture data.
BV_eErrFLOAT8 mag Error in BV_e.
UB_TFLOAT8 mag Total (asymptotic) color index in the Johnson U-B system, derived by extrapolation from photoelectric color-aperture data, and/or from surface photometry with photoelectric zero point.
UB_TErrFLOAT8 mag Error in UB_T.
UB_T0FLOAT8 mag Total U-B color index corrected for Galactic and internal extinction, and for redshift.
UB_eFLOAT8 mag Mean U-B color index, and its mean error, within the effective aperture A_e, derived by interpolation from photoelectric color-aperture data.
UB_eErrFLOAT8 mag Error in UB_e.
lgD_25FLOAT8 lg(0.1 arcmin) Mean decimal logarithm of the apparent major isophotal diameter measured at or reduced to surface brightness level mu_B = 25.0 B-mag/arcsec^2.
lgD_25ErrFLOAT8 0.1 arcmin Error in lgD_25.
lgD_0FLOAT8 lg(0.1 arcmin)? Decimal logarithm of the isophotal major diameter corrected to ``face-on'' (inclination = 0 degrees), and corrected for Galactic extinction to A_g = 0, but not for redshift.
lgR_25FLOAT8 Mean decimal logarithm of the ratio of the major isophotal diameter, D_25, to the minor isophotal diameter, d_25, measured at or reduced to the surface brightness level mu_B = 25.0 B-mag/arcsec^2.
lgR_25ErrFLOAT8 Error in lgR_25.
logA_eFLOAT8 Decimal logarithm of the apparent diameter (in 0.1 arcmin) of the ``effective aperture,'' the circle centered on the nucleus within which one-half of the total B-band flux is emitted.
logA_eErrFLOAT8 Error in logA_e.
m_eFLOAT8 mag Mean B-band surface brightness in magnitudes per square arcmin (B-mag/arcmin^2) within the effective aperture A_e, as given by the relation m'_e = B_T + 0.75 + 5logA_e - 5.26. m'_e is statistically related to the effective mean surface brightness, mu'_e (RC2, p. 31; Olson and de Vaucouleurs 1981), with which it coincides when log R = 0 (i = 0 degrees).
m_eErrFLOAT8 mag Error in m_e.
m_25FLOAT8 mag/arcmin^2 m'_25 = the mean surface brightness in B-mag/arcmin^2 within the mu_B = 25.0 B-mag/arcsec^2 elliptical isophote of major axis D_25 and axis ratio R_25, defined as in RC2 (Equation 21) by: m'_25 = B_T + Delta m_25 + 5 logD_25 - 2.5 logR_25 - - 5.26, where Delta m_25 = 2.5 log(L_T/L_D_25) = B_25 - B_T is the magnitude increment contributed by the outer regions of a galaxy fainter than mu_B = 25.0 B-mag/arcsec^2.
m_25ErrFLOAT8 mag/arcmin^2 Error in m_25.
A_BFLOAT8 mag Galactic extinction in B-band magnitudes, calculated following Burstein and Heiles (1978a,b, 1982, 1984).
A_HI_selfFLOAT8 mag HI line self-absorption in magnitudes (for correction to face-on), calculated from logR and T >= 1.
A_B_intFLOAT8 mag Internal extinction in B-band magnitudes (for correction to face-on), calculated from logR and T.
W_20FLOAT8 km/s Neutral hydrogen line full width measured at the 20% level (I_20/I_max).
W_20ErrFLOAT8 km/s Error in W_20.
W_50FLOAT8 km/s Neutral hydrogen line full width measured at the 50% level (I_50/I_max).
W_50ErrFLOAT8 km/s Error in W_50.
HIFLOAT8 mag Corrected neutral hydrogen index, which is the difference m_21^0 - B_T^0 between the corrected (face-on) 21-cm emission line magnitude and the similarly corrected magnitude in the B_T system. N.n. Since m_21 and B_T are provided in this table, there is no need to list the uncorrected index.
V_21cmFLOAT8 km/s Mean heliocentric radial velocity, and its mean error, in km/s derived from neutral hydrogen observations.
V_21cmErrFLOAT8 km/s Error in V_21cm.
V_optFLOAT8 km/s Mean heliocentric radial velocity, and its mean error, in km/s derived from optical observations.
V_optErrFLOAT8 km/s Error in V_opt.
V_GSRFLOAT8 km/s Weighted mean of the neutral hydrogen and optical velocities, corrected to the ``Galactic standard of rest''.
V_3KFLOAT8 km/s Weighted mean velocity corrected to the reference frame defined by the 3 K microwave background radiation.
cxFLOAT8 C1 Unit vector for J2000 ra+dec.
cyFLOAT8 C1 Unit vector for J2000 ra+dec.
czFLOAT8 C1 Unit vector for J2000 ra+dec.

TABLE   iras

IRAS Point Source Catalog v2.1 (IRAS PSC; 245889 rows).
 
Table contents.
name type index unit description
objIDINT4 P Unique identifier for the DARTS database. objID is defined like 2117xxxxxx in the decimal system. xxxxxx shows row number. Do not refer this ID in your literatures.
pscnameVARCHAR(11) U IRAS source name.
raFLOAT8 S deg RA equinox J2000.0, epoch B1983.5.
decFLOAT8 S deg Dec equinox J2000.0, epoch B1983.5.
semimajorINT2 arcsec 95% confidence error ellipse semimajor axis.
semiminorINT2 arcsec 95% confidence error ellipse semiminor axis.
posangINT2 deg Uncertainty ellipse position angle.
nhconINT2 Number of times observed.
fnu_12FLOAT8 S Jy Average non-color corrected flux density, 12um.
fnu_25FLOAT8 S Jy Average non-color corrected flux density, 25um.
fnu_60FLOAT8 S Jy Average non-color corrected flux density, 60um.
fnu_100FLOAT8 S Jy Average non-color corrected flux density, 100u.
fqual_12INT2 S Flux density quality, 12um.
fqual_25INT2 S Flux density quality, 25um.
fqual_60INT2 S Flux density quality, 60um.
fqual_100INT2 S Flux density quality, 100um.
nlrsINT2 Number of significant LRS spectra.
lrscharCHAR(2) Characterization of averaged LRS spectrum.
relunc_12INT2 Percent relative flux den. uncertainty, 12um.
relunc_25INT2 Percent relative flux den. uncertainty, 25um.
relunc_60INT2 Percent relative flux den. uncertainty, 60um.
relunc_100INT2 Percent relative flux den. uncertainty, 100um.
tsnr_12INT4 10x minimum signal-to-noise ratio, 12um.
tsnr_25INT4 10x minimum signal-to-noise ratio, 25um.
tsnr_60INT4 10x minimum signal-to-noise ratio, 60um.
tsnr_100INT4 10x minimum signal-to-noise ratio, 100um.
cc_12VARCHAR(2) Point source correlation coefficient, 12um.
cc_25VARCHAR(2) Point source correlation coefficient, 25um.
cc_60VARCHAR(2) Point source correlation coefficient, 60um.
cc_100VARCHAR(2) Point source correlation coefficient, 100um.
varINT2 Percent likelihood of variability.
discCHAR(1) Discrepant fluxes flag, 1 per band, hex encode.
confuseCHAR(1) Confusion flags, 1 per band, hex encoded.
pnearhINT2 Number of nearby hours-confirmed point sources.
pnearwINT2 Number of nearby weeks-confirmed point sources.
ses1_12INT2 Nearby seconds-confirmed small ext. src., 12um.
ses1_25INT2 Nearby seconds-confirmed small ext. src., 25um.
ses1_60INT2 Nearby seconds-confirmed small ext. src., 60um.
ses1_100INT2 Nearby seconds-confirmed small ext. src., 100u.
ses2_12INT2 Nearby weeks-confirmed small ext. src., 12um.
ses2_25INT2 Nearby weeks-confirmed small ext. src., 25um.
ses2_60INT2 Nearby weeks-confirmed small ext. src., 60um.
ses2_100INT2 Nearby weeks-confirmed small ext. src., 100um.
hsdflagCHAR(1) High source density bin flag, hex encoded.
cirr1INT2 Number of nearby 100 micron only WSDB sources.
cirr2INT2 100 micron sky brightness ratio to flux den.
cirr3INT2 MJy/sr Total 100 micron sky surface brightness.
nidINT2 Number of positional associations.
idtypeINT2 Type of object.
mhconINT2 Possible number of HCONs.
fcor_12INT2 Flux correction factor applied (times 1000).
fcor_25INT2 Flux correction factor applied (times 1000).
fcor_60INT2 Flux correction factor applied (times 1000).
fcor_100INT2 Flux correction factor applied (times 1000).
rat_12_25FLOAT8 fnu_12 / fnu_25.
err_12_25FLOAT8 % uncertainty in rat_12_25, -1=upperlim, -2=lowerlim.
rat_25_60FLOAT8 fnu_25 / fnu_60.
err_25_60FLOAT8 % uncertainty in rat_25_60, -1=upperlim, -2=lowerlim.
rat_60_100FLOAT8 fnu_60 / fnu_100.
err_60_100FLOAT8 % uncertainty in rat_60_100, -1=upperlim, -2=lowerlim.
cxFLOAT8 C1 Unit vector for J2000 ra+dec.
cyFLOAT8 C1 Unit vector for J2000 ra+dec.
czFLOAT8 C1 Unit vector for J2000 ra+dec.

TABLE   irasfsc

IRAS Faint Source Catalog v2.0 (IRAS FSC; 173044 rows).
 
Table contents.
name type index unit description
objIDINT4 P Unique identifier for the DARTS database. objID is defined like 2121xxxxxx in the decimal system. xxxxxx shows row number. Do not refer this ID in your literatures.
fscnameVARCHAR(12) U Source name.
raFLOAT8 S deg RA equinox J2000.0, epoch B1983.5.
decFLOAT8 S deg Dec equinox J2000.0, epoch B1983.5.
semimajorINT2 arcsec 95% confidence error ellipse semimajor axis.
semiminorINT2 arcsec 95% confidence error ellipse semiminor axis.
posangINT2 deg Uncertainty ellipse position angle.
nobs_12INT2 S Number of times observed at 12um.
nobs_25INT2 S Number of times observed at 25um.
nobs_60INT2 S Number of times observed at 60um.
nobs_100INT2 S Number of times observed at 100um.
fnu_12FLOAT8 S Jy Non-color corrected flux density at 12um.
fnu_25FLOAT8 S Jy Non-color corrected flux density at 25um.
fnu_60FLOAT8 S Jy Non-color corrected flux density at 60um.
fnu_100FLOAT8 S Jy Non-color corrected flux density at 100um.
fqual_12INT2 S Flux density quality at 12um.
fqual_25INT2 S Flux density quality at 25um.
fqual_60INT2 S Flux density quality at 60um.
fqual_100INT2 S Flux density quality at 100um.
relunc_12INT2 S Percent rel. flux density uncertainty at 12um.
relunc_25INT2 S Percent rel. flux density uncertainty at 25um.
relunc_60INT2 S Percent rel. flux density uncertainty at 60um.
relunc_100INT2 S Percent rel. flux density uncertainty at 100um.
minrelINT2 Percent minimum source reliability.
snr_12FLOAT8 SNR at 12um.
snr_25FLOAT8 SNR at 25um.
snr_60FLOAT8 SNR at 60um.
snr_100FLOAT8 SNR at 100um.
locsnr_12FLOAT8 Local SNR at 12um.
locsnr_25FLOAT8 Local SNR at 25um.
locsnr_60FLOAT8 Local SNR at 60um.
locsnr_100FLOAT8 Local SNR at 100um.
area_12INT2 Number of pixels above threshold at 12um.
area_25INT2 Number of pixels above threshold at 25um.
area_60INT2 Number of pixels above threshold at 60um.
area_100INT2 Number of pixels above threshold at 100um.
catnbrINT2 Number of nearby catalog sources.
extnbr_12INT2 Number of nearby extractions at 12 um.
extnbr_25INT2 Number of nearby extractions at 25 um.
extnbr_60INT2 Number of nearby extractions at 60 um.
extnbr_100INT2 Number of nearby extractions at 100 um.
cirrusINT2 Number of nearby 100 um-only extraction.
confuseINT2 Confusion flag, 1 per band, hex-encoded.
noiscor_12FLOAT8 Noise correction factor at 12um.
noiscor_25FLOAT8 Noise correction factor at 25um.
noiscor_60FLOAT8 Noise correction factor at 60um.
noiscor_100FLOAT8 Noise correction factor at 100um.
nidINT2 Number of positional associations.
idtypeINT2 Type of object.
noisrat_12FLOAT8 Ratio of 85% to 68% of flux distribution, 12um.
noisrat_25FLOAT8 Ratio of 85% to 68% of flux distribution, 25um.
noisrat_60FLOAT8 Ratio of 85% to 68% of flux distribution, 60um.
noisrat_100FLOAT8 Ratio of 85% to 68% of flux distribution, 100u.
rat_12_25FLOAT8 fnu_12 / fnu_25.
err_12_25FLOAT8 % uncertainty in rat_12_25, -1=upperlim, -2=lowerlim.
rat_25_60FLOAT8 fnu_25 / fnu_60.
err_25_60FLOAT8 % uncertainty in rat_25_60, -1=upperlim, -2=lowerlim.
rat_60_100FLOAT8 fnu_60 / fnu_100.
err_60_100FLOAT8 % uncertainty in rat_60_100, -1=upperlim, -2=lowerlim.
cxFLOAT8 C1 Unit vector for J2000 ra+dec.
cyFLOAT8 C1 Unit vector for J2000 ra+dec.
czFLOAT8 C1 Unit vector for J2000 ra+dec.

TABLE   twomass

2MASS Point Source Catalog (2MASS PSC; 470992970 rows). See User's Guide on IPAC site for details.
 
Table contents.
name type index unit description
objIDINT4 P Unique identifier for the DARTS database. Do not refer this ID in your literatures.
raFLOAT8 C1,C2 deg J2000 right ascension.
decFLOAT8 C1,C2 deg J2000 declination.
err_majFLOAT4 arcsec Semi-major axis length of the one sigma position uncertainty ellipse.
err_minFLOAT4 arcsec Semi-minor axis length of the one sigma position uncertainty ellipse.
err_angINT2 deg Position angle on the sky of the semi-major axis of the position uncertainty ellipse (East of North).
designationCHAR(17) Sexagesimal, equatorial position-based source name in the form: hhmmssss+ddmmsss[ABC...].
j_mFLOAT4 S mag Default J-band magnitude, or if the source is not detected in the J-band, the 95% confidence upper limit derived from a 4" radius aperture measurement taken at the position of the source on the Atlas Image.
j_cmsigFLOAT4 mag Corrected photometric uncertainty for the default J-band magnitude. If rd_flg[1]="2", this is the measurement error from the profile-fitting procedure, corrected to be consistent with observed repeatability statistics.
j_msigcomFLOAT4 mag Combined, or total photometric uncertainty for the default J-band magnitude.
j_snrFLOAT4 mag J-band "scan" signal-to-noise ratio..
h_mFLOAT4 S mag Default H-band magnitude, or if the source is not detected in the H-band, the 95% confidence upper limit derived from a 4" radius aperture measurement taken at the position of the source on the Atlas Image.
h_cmsigFLOAT4 mag Corrected photometric uncertainty for the default H-band magnitude. If rd_flg[1]="2", this is the measurement error from the profile-fitting procedure, corrected to be consistent with observed repeatability statistics.
h_msigcomFLOAT4 mag Combined, or total photometric uncertainty for the default H-band magnitude.
h_snrFLOAT4 mag H-band "scan" signal-to-noise ratio..
k_mFLOAT4 S mag Default Ks-band magnitude, or if the source is not detected in the Ks-band, the 95% confidence upper limit derived from a 4" radius aperture measurement taken at the position of the source on the Atlas Image.
k_cmsigFLOAT4 mag Corrected photometric uncertainty for the default Ks-band magnitude. If rd_flg[1]="2", this is the measurement error from the profile-fitting procedure, corrected to be consistent with observed repeatability statistics.
k_msigcomFLOAT4 mag Combined, or total photometric uncertainty for the default Ks-band magnitude.
k_snrFLOAT4 mag Ks-band "scan" signal-to-noise ratio..
ph_qualCHAR(3) Photometric quality flag.
rd_flgCHAR(3) Read flag.
bl_flgCHAR(3) Blend flag.
cc_flgCHAR(3) Contamination and confusion flag.
ndetCHAR(6) Frame detection statistics.
proxFLOAT4 arcsec Proximity. The distance between this source and its nearest neighbor in the PSC.
pxpaINT2 deg The position angle on the sky of the vector from the source to the nearest neighbor in the PSC, in degrees East of North..
pxcntrINT4 The pts_key value of the nearest source in the PSC.
gal_contamINT2 Extended source "contamination" flag.
mp_flgINT2 Minor Planet Flag. Indicates if this source is associated with the predicted position of a known minor planet, comet, planet or planetary satellite.
pts_keyINT4 A unique identification number for the PSC source.
hemisCHAR(1) Hemisphere code for the 2MASS Observatory from which this source was observed.
dateDATE The observation reference date for this source expressed in ISO standard format.
scanINT2 The nightly scan number in which the source was detected.
glonFLOAT4 deg Galactic longitude.
glatFLOAT4 deg Galactic latitude.
x_scanFLOAT4 arcsec Mean cross-scan focal plane position of the source in the Universal scan (U-scan) coordinate system.
jdateFLOAT8 day The Julian Date of the source measurement accurate to +30 seconds.
j_psfchiFLOAT4 Reduced chi-squared goodness-of-fit value for the J-band profile-fit photometry made on the 1.3 s "Read_2" exposures.
h_psfchiFLOAT4 Reduced chi-squared goodness-of-fit value for the H-band profile-fit photometry made on the 1.3 s "Read_2" exposures.
k_psfchiFLOAT4 Reduced chi-squared goodness-of-fit value for the Ks-band profile-fit photometry made on the 1.3 s "Read_2" exposures.
j_m_stdapFLOAT4 mag J-band "standard" aperture magnitude.
j_msig_stdapFLOAT4 mag Uncertainty in the J-band standard aperture magnitude.
h_m_stdapFLOAT4 mag H-band "standard" aperture magnitude.
h_msig_stdapFLOAT4 mag Uncertainty in the H-band standard aperture magnitude.
k_m_stdapFLOAT4 mag Ks-band "standard" aperture magnitude.
k_msig_stdapFLOAT4 mag Uncertainty in the Ks-band standard aperture magnitude.
dist_edge_nsINT4 arcsec The distance from the source to the nearest North or South scan edge.
dist_edge_ewINT4 arcsec The distance from the source to the nearest East or West scan edge.
dist_edge_flgCHAR(2) Two character flag that specifies to which scan edges a source lies closest, and to which edges the dist_edge_ns and dist_edge_ew values refer.
dup_srcINT2 Duplicate source flag.
use_srcINT2 Use source flag.
aCHAR(1) Catalog identifier of an optical source from either the Tycho 2 or USNO-A2.0 catalog that falls within ~5" of the 2MASS source position.
dist_optFLOAT4 arcsec Distance separating 2MASS source position and associated optical source within 5".
phi_optINT2 deg Position angle on the sky of the vector from the the associated optical source to the 2MASS source position, in degrees East of North.
b_m_optFLOAT4 mag Blue magnitude of associated optical source.
vr_m_optFLOAT4 mag Visual or red magnitude of the associated optical source.
nopt_mchsINT2 The number of USNO-A2.0 or Tycho 2 optical sources found within a 5" radius of the 2MASS position.
ext_keyINT4 Unique identification number of the record in the XSC that corresponds to this point source.
scan_keyINT4 Unique identification number of the record in the Scan Information Table (NOT YET AVAILABLE) that corresponds to the survey scan in which this source was detected.
coadd_keyINT4 Unique identification number of the record in the Atlas Image Data Table (NOT YET AVAILABLE) that corresponds to Image in which the position of this source falls.
coaddINT2 Sequence number of the Atlas Image in which the position of this source falls.
cxFLOAT8 Unit vector for J2000 ra+dec.
cyFLOAT8 Unit vector for J2000 ra+dec.
czFLOAT8 Unit vector for J2000 ra+dec.

TABLE   simbad_fis_irc_cache

Object data of cached SIMBAD entries.
 
Table contents.
name type index unit description
oidINT4 P Unique object ID for the SIMBAD database.
raFLOAT8 S deg J2000 R.A.
decFLOAT8 S deg J2000 Dec.
typeVARCHAR(3) S Object type.
specTypeVARCHAR(24) Spectral type.
morphTypeVARCHAR(16) Morphological type.
uFLOAT4 U magnitude.
bFLOAT4 B magnitude.
vFLOAT4 V magnitude.
rFLOAT4 R magnitude.
iFLOAT4 I magnitude.
jFLOAT4 J magnitude.
hFLOAT4 H magnitude.
kFLOAT4 K magnitude.

TABLE   simbad_fis_irc_ident

Identifier data of cached SIMBAD entries.
 
Table contents.
name type index unit description
identVARCHAR(48) P Identifier for the SIMBAD database.
orderIdentINT2 U1 Order of identifiers for an OID.
oidINT4 U1 Unique object ID for the SIMBAD database.

TABLE   simbad_fis_cache

Relation between SIMBAD OID and FIS objID.
 
Table contents.
name type index unit description
oidINT4 S Unique object ID for the SIMBAD database.
objIDINT4 U1 Object ID of AKARI FIS object.
orderDistanceINT2 U1 Order of distance for an AKARI object.
distanceFLOAT8 S arcmin Distance between AKARI object and SIMBAD object.

TABLE   simbad_irc_cache

Relation between SIMBAD OID and IRC objID.
 
Table contents.
name type index unit description
oidINT4 S Unique object ID for the SIMBAD database.
objIDINT4 U1 Object ID of AKARI IRC object.
orderDistanceINT2 U1 Order of distance for an AKARI object.
distanceFLOAT8 S arcmin Distance between AKARI object and SIMBAD object.

TABLE   ned_fis_irc_cache

Object data of cached NED entries.

This table has two views: ned_fis_cache_all, ned_irc_cahce_all

Table contents.
name type index unit description
objNameVARCHAR(32) P Unique object name for the NED database.
raFLOAT8 S deg J2000 R.A.
decFLOAT8 S deg J2000 Dec.
typeVARCHAR(8) S Object type.
redshiftFLOAT8 Redshift.
redshiftFlagVARCHAR(4) Redshift Flag.
magFilterVARCHAR(8) Magnitude/Filter.

TABLE   ned_fis_cache

Relation between NED objName and FIS objID.

This table has a view:ned_fis_cache_all

Table contents.
name type index unit description
objNameVARCHAR(32) S Unique object name for the NED database.
objIDINT4 U1 Object ID of AKARI FIS object.
orderDistanceINT2 U1 Order of distance for an AKARI object.
distanceFLOAT8 S arcmin Distance between AKARI object and NED object.

TABLE   ned_irc_cache

Relation between NED objName and IRC objID.

This table has a view:ned_irc_cahce_all

Table contents.
name type index unit description
objNameVARCHAR(32) S Unique object name for the NED database.
objIDINT4 U1 Object ID of AKARI IRC object.
orderDistanceINT2 U1 Order of distance for an AKARI object.
distanceFLOAT8 S arcmin Distance between AKARI object and NED object.

Last Modified: 09 January 2019