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_akari_cache | SimbadCache | Object data of cached SIMBAD entries. |
| simbad_akari_ident | SimbadIdent | Identifier data of cached SIMBAD entries. |
| simbad_akari_fis_bsc_1_rel | SimbadFis | Relation between SIMBAD OID and FIS objID. |
| simbad_akari_irc_psc_1_rel | SimbadIrc | Relation between SIMBAD OID and IRC objID. |
| ned_akari_cache | NedCache | Object data of cached NED entries. |
| ned_akari_fis_bsc_1_rel | NedFis | Relation between NED objName and FIS objID. |
| ned_akari_irc_psc_1_rel | 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 |
|---|---|---|---|---|
| objID | INT4 | P |
Unique identifier for the DARTS database.
[3000001-3427071] objID is defined as VVxxxxxx in the decimal system.
VV indicates the version code of the catalog,
and xxxxxx shows row number.
Do not refer to this ID in your literature.
|
|
| objName | CHAR(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. | |
| ra | FLOAT8 | S | deg | J2000 Right Ascension of the source position. |
| dec | FLOAT8 | S | deg | J2000 Declination of the source position. |
| cx | FLOAT8 | C1 | Unit vector for ra+dec | |
| cy | FLOAT8 | C1 | Unit vector for ra+dec | |
| cz | FLOAT8 | C1 | Unit vector for ra+dec | |
| ra1950 | FLOAT8 | S | deg | Right Ascension (B1950) |
| dec1950 | FLOAT8 | S | deg | Declination (B1950) |
| lambda | FLOAT8 | S | deg | Ecliptic longitude |
| beta | FLOAT8 | S | deg | Ecliptic latitude |
| l | FLOAT8 | S | deg | Galactic longitude |
| b | FLOAT8 | S | deg | Galactic latitude |
| posErrMj | FLOAT4 | 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 . | |
| posErrMi | FLOAT4 | 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 . | |
| posErrPA | FLOAT4 | 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_65 | FLOAT4 | 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_90 | FLOAT4 | 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_140 | FLOAT4 | 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_160 | FLOAT4 | 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_65 | FLOAT4 | 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_90 | FLOAT4 | 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_140 | FLOAT4 | 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_160 | FLOAT4 | 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_65 | INT2 | 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_90 | INT2 | 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_140 | INT2 | 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_160 | INT2 | 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_65 | INT2 | 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_90 | INT2 | 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_140 | INT2 | 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_160 | INT2 | 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_65 | INT2 | S | Number of scans on which the source is properly detected with logEvidence larger than the threshold. | |
| nScanC_90 | INT2 | S | Number of scans on which the source is properly detected with logEvidence larger than the threshold. | |
| nScanC_140 | INT2 | S | Number of scans on which the source is properly detected with logEvidence larger than the threshold. | |
| nScanC_160 | INT2 | S | Number of scans on which the source is properly detected with logEvidence larger than the threshold. | |
| nScanP_65 | INT2 | S | Total number of scans that passed on the source (that possibly observed the source) | |
| nScanP_90 | INT2 | S | Total number of scans that passed on the source (that possibly observed the source) | |
| nScanP_140 | INT2 | S | Total number of scans that passed on the source (that possibly observed the source) | |
| nScanP_160 | INT2 | S | Total number of scans that passed on the source (that possibly observed the source) | |
| mConf_65 | INT2 | 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_90 | INT2 | 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_140 | INT2 | 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_160 | INT2 | 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. |
|
| nDens | INT2 | 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 |
|---|---|---|---|---|
| objID | INT4 | P |
Unique identifier for the DARTS database.
[200000001-200870973] objID is defined as VVxxxxxxxx in the decimal system.
VV indicates the version code of the catalog,
and xxxxxxxx shows row number.
Do not refer to this ID in your literature.
|
|
| objName | CHAR(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. | |
| ra | FLOAT8 | S | deg | J2000 Right Ascension of the source position. |
| dec | FLOAT8 | S | deg | J2000 Declination of the source position. |
| cx | FLOAT8 | C1 | Unit vector for ra+dec | |
| cy | FLOAT8 | C1 | Unit vector for ra+dec | |
| cz | FLOAT8 | C1 | Unit vector for ra+dec | |
| ra1950 | FLOAT8 | S | deg | Right Ascension (B1950) |
| dec1950 | FLOAT8 | S | deg | Declination (B1950) |
| lambda | FLOAT8 | S | deg | Ecliptic longitude |
| beta | FLOAT8 | S | deg | Ecliptic latitude |
| l | FLOAT8 | S | deg | Galactic longitude |
| b | FLOAT8 | S | deg | Galactic latitude |
| posErrMj | FLOAT4 | 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. | |
| posErrMi | FLOAT4 | 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. | |
| posErrPA | FLOAT4 | 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_09 | FLOAT4 | S | Jy | Flux density of the source in S9W in Jansky. |
| flux_18 | FLOAT4 | S | Jy | Flux density of the source in L18W in Jansky. |
| fErr_09 | FLOAT4 | Jy | Flux error in S9W. | |
| fErr_18 | FLOAT4 | Jy | Flux error in L18W. | |
| fQual_09 | INT2 | S | Flux density quality flag for S9W. 3 when flux is valid and 0 when flux is not available. | |
| fQual_18 | INT2 | S | Flux density quality flag for L18W. 3 when flux is valid and 0 when flux is not available. | |
| flags_09 | INT2 | 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_18 | INT2 | 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_09 | INT2 | 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_18 | INT2 | 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_09 | INT2 | S | The number of times the source position has been scanned during the survey. | |
| nScanP_18 | INT2 | S | The number of times the source position has been scanned during the survey. | |
| mConf_09 | INT2 | S | 1 is month confirmed and 0 is not. Inverted value of LSB of flags_09 | |
| mConf_18 | INT2 | S | 1 is month confirmed and 0 is not. Inverted value of LSB of flags_18 | |
| nDens_09 | INT2 | S | The number of sources in 45 arcsec radius. | |
| nDens_18 | INT2 | S | The number of sources in 45 arcsec radius. | |
| extended_09 | INT2 | 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_18 | INT2 | 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_09 | FLOAT4 | 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_18 | FLOAT4 | 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. | ||
| nDataPos | INT2 | 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_09 | INT2 | 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_18 | INT2 | 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. |
| name | type | index | unit | description |
|---|---|---|---|---|
| objID | INT4 | P |
Unique identifier for the DARTS database.
[2101000001-2101023011] objID is defined as 2101xxxxxx in the decimal system.
xxxxxx shows row numbers.
Do not refer to this ID in your literature.
|
|
| name | VARCHAR(12) | U | Primary name. | |
| aliases | VARCHAR(26) | S | Other names. | |
| PGC_name | VARCHAR(10) | U | PGC (Paturel et al. 1989a,b) designation. | |
| ra | FLOAT8 | S | deg | Updated J2000 R.A. using NED service. |
| dec | FLOAT8 | S | deg | Updated J2000 Dec. using NED service. |
| ra_orig | FLOAT8 | S | deg | J2000 R.A. in RC3 catalog. The values in this column do not have enough accuracy for a number of objects. |
| dec_orig | FLOAT8 | S | deg | J2000 Dec. in RC3 catalog. The values in this column do not have enough accuracy for a number of objects. |
| good_position | INT4 | The values of ra_orig/dec_orig are good to 0.1 sec time, 1 asec. (otherwise, 0.1 min time, 1 amin) | ||
| galactic_l | FLOAT8 | deg | Galactic longitude in the IAU 1958 system (Blaauw et al. 1960); good to 0.01 degrees. | |
| galactic_b | FLOAT8 | deg | Galactic latitude in the IAU 1958 system (Blaauw et al. 1960); good to 0.01 degrees. | |
| superGalactic_l | FLOAT8 | deg | Supergalactic longitude in the RC2 system; good to 0.01 degrees. | |
| superGalactic_b | FLOAT8 | deg | Supergalactic latitude in the RC2 system; good to 0.01 degrees. | |
| PosAngle | FLOAT8 | 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_type | CHAR(7) | Mean revised morphological type in the RC2 system, coded as in RC2. | ||
| rc2_typeSource | CHAR(6) | Sources of revised morphological type estimate. | ||
| T_type | FLOAT8 | S | Mean numerical index of stage along the Hubble sequence in the RC2 system. | |
| T_typeErr | FLOAT8 | Error in T_type. | ||
| LC_rc2 | FLOAT8 | Mean numerical luminosity class in the RC2 system. | ||
| LC_rc2Err | FLOAT8 | Error in LC_rc2. | ||
| n_L | FLOAT8 | Number of luminosity class estimates. | ||
| B_T | FLOAT8 | 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_TErr | FLOAT8 | mag | Error in B_T. | |
| B_Tsource | CHAR(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_T0 | FLOAT8 | mag | Total ``face-on'' magnitude corrected for Galactic and internal extinction, and for redshift. | |
| M_B | FLOAT8 | 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_BErr | FLOAT8 | mag | Error in M_B. | |
| M_FIR | FLOAT8 | 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_21cm | FLOAT8 | 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_21cmErr | FLOAT8 | mag | Error in M_21cm. | |
| BV_T | FLOAT8 | 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_TErr | FLOAT8 | mag | Error in BV_T. | |
| BV_T0 | FLOAT8 | mag | Total B-V color index corrected for Galactic and internal extinction, and for redshift. | |
| BV_e | FLOAT8 | mag | Mean B-V color index within the effective aperture A_e, derived by interpolation from photoelectric color-aperture data. | |
| BV_eErr | FLOAT8 | mag | Error in BV_e. | |
| UB_T | FLOAT8 | 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_TErr | FLOAT8 | mag | Error in UB_T. | |
| UB_T0 | FLOAT8 | mag | Total U-B color index corrected for Galactic and internal extinction, and for redshift. | |
| UB_e | FLOAT8 | 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_eErr | FLOAT8 | mag | Error in UB_e. | |
| lgD_25 | FLOAT8 | 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_25Err | FLOAT8 | 0.1 arcmin | Error in lgD_25. | |
| lgD_0 | FLOAT8 | 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_25 | FLOAT8 | 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_25Err | FLOAT8 | Error in lgR_25. | ||
| logA_e | FLOAT8 | 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_eErr | FLOAT8 | Error in logA_e. | ||
| m_e | FLOAT8 | 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_eErr | FLOAT8 | mag | Error in m_e. | |
| m_25 | FLOAT8 | 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_25Err | FLOAT8 | mag/arcmin^2 | Error in m_25. | |
| A_B | FLOAT8 | mag | Galactic extinction in B-band magnitudes, calculated following Burstein and Heiles (1978a,b, 1982, 1984). | |
| A_HI_self | FLOAT8 | mag | HI line self-absorption in magnitudes (for correction to face-on), calculated from logR and T >= 1. | |
| A_B_int | FLOAT8 | mag | Internal extinction in B-band magnitudes (for correction to face-on), calculated from logR and T. | |
| W_20 | FLOAT8 | km/s | Neutral hydrogen line full width measured at the 20% level (I_20/I_max). | |
| W_20Err | FLOAT8 | km/s | Error in W_20. | |
| W_50 | FLOAT8 | km/s | Neutral hydrogen line full width measured at the 50% level (I_50/I_max). | |
| W_50Err | FLOAT8 | km/s | Error in W_50. | |
| HI | FLOAT8 | 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_21cm | FLOAT8 | km/s | Mean heliocentric radial velocity, and its mean error, in km/s derived from neutral hydrogen observations. | |
| V_21cmErr | FLOAT8 | km/s | Error in V_21cm. | |
| V_opt | FLOAT8 | km/s | Mean heliocentric radial velocity, and its mean error, in km/s derived from optical observations. | |
| V_optErr | FLOAT8 | km/s | Error in V_opt. | |
| V_GSR | FLOAT8 | km/s | Weighted mean of the neutral hydrogen and optical velocities, corrected to the ``Galactic standard of rest''. | |
| V_3K | FLOAT8 | km/s | Weighted mean velocity corrected to the reference frame defined by the 3 K microwave background radiation. | |
| cx | FLOAT8 | C1 | Unit vector for J2000 ra+dec. | |
| cy | FLOAT8 | C1 | Unit vector for J2000 ra+dec. | |
| cz | FLOAT8 | 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 |
|---|---|---|---|---|
| objID | INT4 | P |
Unique identifier for the DARTS database.
[2117000001-2117245889] objID is defined as 2117xxxxxx in the decimal system.
xxxxxx shows the row number.
Do not refer to this ID in your literature.
|
|
| pscname | VARCHAR(11) | U | IRAS source name. | |
| ra | FLOAT8 | S | deg | RA equinox J2000.0, epoch B1983.5. |
| dec | FLOAT8 | S | deg | Dec equinox J2000.0, epoch B1983.5. |
| semimajor | INT2 | arcsec | 95% confidence error ellipse semimajor axis. | |
| semiminor | INT2 | arcsec | 95% confidence error ellipse semiminor axis. | |
| posang | INT2 | deg | Uncertainty ellipse position angle. | |
| nhcon | INT2 | Number of times observed. | ||
| fnu_12 | FLOAT8 | S | Jy | Average non-color corrected flux density, 12um. |
| fnu_25 | FLOAT8 | S | Jy | Average non-color corrected flux density, 25um. |
| fnu_60 | FLOAT8 | S | Jy | Average non-color corrected flux density, 60um. |
| fnu_100 | FLOAT8 | S | Jy | Average non-color corrected flux density, 100u. |
| fqual_12 | INT2 | S | Flux density quality, 12um. | |
| fqual_25 | INT2 | S | Flux density quality, 25um. | |
| fqual_60 | INT2 | S | Flux density quality, 60um. | |
| fqual_100 | INT2 | S | Flux density quality, 100um. | |
| nlrs | INT2 | Number of significant LRS spectra. | ||
| lrschar | CHAR(2) | Characterization of averaged LRS spectrum. | ||
| relunc_12 | INT2 | Percent relative flux den. uncertainty, 12um. | ||
| relunc_25 | INT2 | Percent relative flux den. uncertainty, 25um. | ||
| relunc_60 | INT2 | Percent relative flux den. uncertainty, 60um. | ||
| relunc_100 | INT2 | Percent relative flux den. uncertainty, 100um. | ||
| tsnr_12 | INT4 | 10x minimum signal-to-noise ratio, 12um. | ||
| tsnr_25 | INT4 | 10x minimum signal-to-noise ratio, 25um. | ||
| tsnr_60 | INT4 | 10x minimum signal-to-noise ratio, 60um. | ||
| tsnr_100 | INT4 | 10x minimum signal-to-noise ratio, 100um. | ||
| cc_12 | VARCHAR(2) | Point source correlation coefficient, 12um. | ||
| cc_25 | VARCHAR(2) | Point source correlation coefficient, 25um. | ||
| cc_60 | VARCHAR(2) | Point source correlation coefficient, 60um. | ||
| cc_100 | VARCHAR(2) | Point source correlation coefficient, 100um. | ||
| var | INT2 | Percent likelihood of variability. | ||
| disc | CHAR(1) | Discrepant fluxes flag, 1 per band, hex encode. | ||
| confuse | CHAR(1) | Confusion flags, 1 per band, hex encoded. | ||
| pnearh | INT2 | Number of nearby hours-confirmed point sources. | ||
| pnearw | INT2 | Number of nearby weeks-confirmed point sources. | ||
| ses1_12 | INT2 | Nearby seconds-confirmed small ext. src., 12um. | ||
| ses1_25 | INT2 | Nearby seconds-confirmed small ext. src., 25um. | ||
| ses1_60 | INT2 | Nearby seconds-confirmed small ext. src., 60um. | ||
| ses1_100 | INT2 | Nearby seconds-confirmed small ext. src., 100u. | ||
| ses2_12 | INT2 | Nearby weeks-confirmed small ext. src., 12um. | ||
| ses2_25 | INT2 | Nearby weeks-confirmed small ext. src., 25um. | ||
| ses2_60 | INT2 | Nearby weeks-confirmed small ext. src., 60um. | ||
| ses2_100 | INT2 | Nearby weeks-confirmed small ext. src., 100um. | ||
| hsdflag | CHAR(1) | High source density bin flag, hex encoded. | ||
| cirr1 | INT2 | Number of nearby 100 micron only WSDB sources. | ||
| cirr2 | INT2 | 100 micron sky brightness ratio to flux den. | ||
| cirr3 | INT2 | MJy/sr | Total 100 micron sky surface brightness. | |
| nid | INT2 | Number of positional associations. | ||
| idtype | INT2 | Type of object. | ||
| mhcon | INT2 | Possible number of HCONs. | ||
| fcor_12 | INT2 | Flux correction factor applied (times 1000). | ||
| fcor_25 | INT2 | Flux correction factor applied (times 1000). | ||
| fcor_60 | INT2 | Flux correction factor applied (times 1000). | ||
| fcor_100 | INT2 | Flux correction factor applied (times 1000). | ||
| rat_12_25 | FLOAT8 | fnu_12 / fnu_25. | ||
| err_12_25 | FLOAT8 | % uncertainty in rat_12_25, -1=upperlim, -2=lowerlim. | ||
| rat_25_60 | FLOAT8 | fnu_25 / fnu_60. | ||
| err_25_60 | FLOAT8 | % uncertainty in rat_25_60, -1=upperlim, -2=lowerlim. | ||
| rat_60_100 | FLOAT8 | fnu_60 / fnu_100. | ||
| err_60_100 | FLOAT8 | % uncertainty in rat_60_100, -1=upperlim, -2=lowerlim. | ||
| cx | FLOAT8 | C1 | Unit vector for J2000 ra+dec. | |
| cy | FLOAT8 | C1 | Unit vector for J2000 ra+dec. | |
| cz | FLOAT8 | 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 |
|---|---|---|---|---|
| objID | INT4 | P |
Unique identifier for the DARTS database.
[2121000001-2121173044] objID is defined as 2121xxxxxx in the decimal system.
xxxxxx shows the row number.
Do not refer to this ID in your literature.
|
|
| fscname | VARCHAR(12) | U | Source name. | |
| ra | FLOAT8 | S | deg | RA equinox J2000.0, epoch B1983.5. |
| dec | FLOAT8 | S | deg | Dec equinox J2000.0, epoch B1983.5. |
| semimajor | INT2 | arcsec | 95% confidence error ellipse semimajor axis. | |
| semiminor | INT2 | arcsec | 95% confidence error ellipse semiminor axis. | |
| posang | INT2 | deg | Uncertainty ellipse position angle. | |
| nobs_12 | INT2 | S | Number of times observed at 12um. | |
| nobs_25 | INT2 | S | Number of times observed at 25um. | |
| nobs_60 | INT2 | S | Number of times observed at 60um. | |
| nobs_100 | INT2 | S | Number of times observed at 100um. | |
| fnu_12 | FLOAT8 | S | Jy | Non-color corrected flux density at 12um. |
| fnu_25 | FLOAT8 | S | Jy | Non-color corrected flux density at 25um. |
| fnu_60 | FLOAT8 | S | Jy | Non-color corrected flux density at 60um. |
| fnu_100 | FLOAT8 | S | Jy | Non-color corrected flux density at 100um. |
| fqual_12 | INT2 | S | Flux density quality at 12um. | |
| fqual_25 | INT2 | S | Flux density quality at 25um. | |
| fqual_60 | INT2 | S | Flux density quality at 60um. | |
| fqual_100 | INT2 | S | Flux density quality at 100um. | |
| relunc_12 | INT2 | S | Percent rel. flux density uncertainty at 12um. | |
| relunc_25 | INT2 | S | Percent rel. flux density uncertainty at 25um. | |
| relunc_60 | INT2 | S | Percent rel. flux density uncertainty at 60um. | |
| relunc_100 | INT2 | S | Percent rel. flux density uncertainty at 100um. | |
| minrel | INT2 | Percent minimum source reliability. | ||
| snr_12 | FLOAT8 | SNR at 12um. | ||
| snr_25 | FLOAT8 | SNR at 25um. | ||
| snr_60 | FLOAT8 | SNR at 60um. | ||
| snr_100 | FLOAT8 | SNR at 100um. | ||
| locsnr_12 | FLOAT8 | Local SNR at 12um. | ||
| locsnr_25 | FLOAT8 | Local SNR at 25um. | ||
| locsnr_60 | FLOAT8 | Local SNR at 60um. | ||
| locsnr_100 | FLOAT8 | Local SNR at 100um. | ||
| area_12 | INT2 | Number of pixels above threshold at 12um. | ||
| area_25 | INT2 | Number of pixels above threshold at 25um. | ||
| area_60 | INT2 | Number of pixels above threshold at 60um. | ||
| area_100 | INT2 | Number of pixels above threshold at 100um. | ||
| catnbr | INT2 | Number of nearby catalog sources. | ||
| extnbr_12 | INT2 | Number of nearby extractions at 12 um. | ||
| extnbr_25 | INT2 | Number of nearby extractions at 25 um. | ||
| extnbr_60 | INT2 | Number of nearby extractions at 60 um. | ||
| extnbr_100 | INT2 | Number of nearby extractions at 100 um. | ||
| cirrus | INT2 | Number of nearby 100 um-only extraction. | ||
| confuse | INT2 | Confusion flag, 1 per band, hex-encoded. | ||
| noiscor_12 | FLOAT8 | Noise correction factor at 12um. | ||
| noiscor_25 | FLOAT8 | Noise correction factor at 25um. | ||
| noiscor_60 | FLOAT8 | Noise correction factor at 60um. | ||
| noiscor_100 | FLOAT8 | Noise correction factor at 100um. | ||
| nid | INT2 | Number of positional associations. | ||
| idtype | INT2 | Type of object. | ||
| noisrat_12 | FLOAT8 | Ratio of 85% to 68% of flux distribution, 12um. | ||
| noisrat_25 | FLOAT8 | Ratio of 85% to 68% of flux distribution, 25um. | ||
| noisrat_60 | FLOAT8 | Ratio of 85% to 68% of flux distribution, 60um. | ||
| noisrat_100 | FLOAT8 | Ratio of 85% to 68% of flux distribution, 100u. | ||
| rat_12_25 | FLOAT8 | fnu_12 / fnu_25. | ||
| err_12_25 | FLOAT8 | % uncertainty in rat_12_25, -1=upperlim, -2=lowerlim. | ||
| rat_25_60 | FLOAT8 | fnu_25 / fnu_60. | ||
| err_25_60 | FLOAT8 | % uncertainty in rat_25_60, -1=upperlim, -2=lowerlim. | ||
| rat_60_100 | FLOAT8 | fnu_60 / fnu_100. | ||
| err_60_100 | FLOAT8 | % uncertainty in rat_60_100, -1=upperlim, -2=lowerlim. | ||
| cx | FLOAT8 | C1 | Unit vector for J2000 ra+dec. | |
| cy | FLOAT8 | C1 | Unit vector for J2000 ra+dec. | |
| cz | FLOAT8 | 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 |
|---|---|---|---|---|
| objID | INT4 | P |
Unique identifier for the DARTS database.
[500000001-970992970] Do not refer to this ID in your literature. |
|
| ra | FLOAT8 | C1,C2 | deg | J2000 right ascension. |
| dec | FLOAT8 | C1,C2 | deg | J2000 declination. |
| err_maj | FLOAT4 | arcsec | Semi-major axis length of the one sigma position uncertainty ellipse. | |
| err_min | FLOAT4 | arcsec | Semi-minor axis length of the one sigma position uncertainty ellipse. | |
| err_ang | INT2 | deg | Position angle on the sky of the semi-major axis of the position uncertainty ellipse (East of North). | |
| designation | CHAR(17) | Sexagesimal, equatorial position-based source name in the form: hhmmssss+ddmmsss[ABC...]. | ||
| j_m | FLOAT4 | 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_cmsig | FLOAT4 | 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_msigcom | FLOAT4 | mag | Combined, or total photometric uncertainty for the default J-band magnitude. | |
| j_snr | FLOAT4 | mag | J-band "scan" signal-to-noise ratio.. | |
| h_m | FLOAT4 | 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_cmsig | FLOAT4 | 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_msigcom | FLOAT4 | mag | Combined, or total photometric uncertainty for the default H-band magnitude. | |
| h_snr | FLOAT4 | mag | H-band "scan" signal-to-noise ratio.. | |
| k_m | FLOAT4 | 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_cmsig | FLOAT4 | 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_msigcom | FLOAT4 | mag | Combined, or total photometric uncertainty for the default Ks-band magnitude. | |
| k_snr | FLOAT4 | mag | Ks-band "scan" signal-to-noise ratio.. | |
| ph_qual | CHAR(3) | Photometric quality flag. | ||
| rd_flg | CHAR(3) | Read flag. | ||
| bl_flg | CHAR(3) | Blend flag. | ||
| cc_flg | CHAR(3) | Contamination and confusion flag. | ||
| ndet | CHAR(6) | Frame detection statistics. | ||
| prox | FLOAT4 | arcsec | Proximity. The distance between this source and its nearest neighbor in the PSC. | |
| pxpa | INT2 | 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.. | |
| pxcntr | INT4 | The pts_key value of the nearest source in the PSC. | ||
| gal_contam | INT2 | Extended source "contamination" flag. | ||
| mp_flg | INT2 | Minor Planet Flag. Indicates if this source is associated with the predicted position of a known minor planet, comet, planet or planetary satellite. | ||
| pts_key | INT4 | A unique identification number for the PSC source. | ||
| hemis | CHAR(1) | Hemisphere code for the 2MASS Observatory from which this source was observed. | ||
| date | DATE | The observation reference date for this source expressed in ISO standard format. | ||
| scan | INT2 | The nightly scan number in which the source was detected. | ||
| glon | FLOAT4 | deg | Galactic longitude. | |
| glat | FLOAT4 | deg | Galactic latitude. | |
| x_scan | FLOAT4 | arcsec | Mean cross-scan focal plane position of the source in the Universal scan (U-scan) coordinate system. | |
| jdate | FLOAT8 | day | The Julian Date of the source measurement accurate to +30 seconds. | |
| j_psfchi | FLOAT4 | Reduced chi-squared goodness-of-fit value for the J-band profile-fit photometry made on the 1.3 s "Read_2" exposures. | ||
| h_psfchi | FLOAT4 | Reduced chi-squared goodness-of-fit value for the H-band profile-fit photometry made on the 1.3 s "Read_2" exposures. | ||
| k_psfchi | FLOAT4 | 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_stdap | FLOAT4 | mag | J-band "standard" aperture magnitude. | |
| j_msig_stdap | FLOAT4 | mag | Uncertainty in the J-band standard aperture magnitude. | |
| h_m_stdap | FLOAT4 | mag | H-band "standard" aperture magnitude. | |
| h_msig_stdap | FLOAT4 | mag | Uncertainty in the H-band standard aperture magnitude. | |
| k_m_stdap | FLOAT4 | mag | Ks-band "standard" aperture magnitude. | |
| k_msig_stdap | FLOAT4 | mag | Uncertainty in the Ks-band standard aperture magnitude. | |
| dist_edge_ns | INT4 | arcsec | The distance from the source to the nearest North or South scan edge. | |
| dist_edge_ew | INT4 | arcsec | The distance from the source to the nearest East or West scan edge. | |
| dist_edge_flg | CHAR(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_src | INT2 | Duplicate source flag. | ||
| use_src | INT2 | Use source flag. | ||
| a | CHAR(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_opt | FLOAT4 | arcsec | Distance separating 2MASS source position and associated optical source within 5". | |
| phi_opt | INT2 | 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_opt | FLOAT4 | mag | Blue magnitude of associated optical source. | |
| vr_m_opt | FLOAT4 | mag | Visual or red magnitude of the associated optical source. | |
| nopt_mchs | INT2 | The number of USNO-A2.0 or Tycho 2 optical sources found within a 5" radius of the 2MASS position. | ||
| ext_key | INT4 | Unique identification number of the record in the XSC that corresponds to this point source. | ||
| scan_key | INT4 | 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_key | INT4 | 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. | ||
| coadd | INT2 | Sequence number of the Atlas Image in which the position of this source falls. | ||
| cx | FLOAT8 | Unit vector for J2000 ra+dec. | ||
| cy | FLOAT8 | Unit vector for J2000 ra+dec. | ||
| cz | FLOAT8 | Unit vector for J2000 ra+dec. |
TABLE simbad_akari_cache
| Object data of cached SIMBAD entries. |
Table contents.
| name | type | index | unit | description |
|---|---|---|---|---|
| oid | INT4 | P | Unique object ID for the SIMBAD database. | |
| ra | FLOAT8 | S | deg | J2000 R.A. |
| dec | FLOAT8 | S | deg | J2000 Dec. |
| type | VARCHAR(3) | S | Object type. | |
| specType | VARCHAR(24) | Spectral type. | ||
| morphType | VARCHAR(16) | Morphological type. | ||
| u | FLOAT4 | U magnitude. | ||
| b | FLOAT4 | B magnitude. | ||
| v | FLOAT4 | V magnitude. | ||
| r | FLOAT4 | R magnitude. | ||
| i | FLOAT4 | I magnitude. | ||
| j | FLOAT4 | J magnitude. | ||
| h | FLOAT4 | H magnitude. | ||
| k | FLOAT4 | K magnitude. |
TABLE simbad_akari_ident
| Identifier data of cached SIMBAD entries. |
Table contents.
| name | type | index | unit | description |
|---|---|---|---|---|
| ident | VARCHAR(48) | P | Identifier for the SIMBAD database. | |
| orderIdent | INT2 | U1 | Order of identifiers for an OID. | |
| oid | INT4 | 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 |
|---|---|---|---|---|
| oid | INT4 | S | Unique object ID for the SIMBAD database. | |
| objID | INT4 | U1 | Object ID of AKARI FIS object. | |
| orderDistance | INT2 | U1 | Order of distance for an AKARI object. | |
| distance | FLOAT8 | 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 |
|---|---|---|---|---|
| oid | INT4 | S | Unique object ID for the SIMBAD database. | |
| objID | INT4 | U1 | Object ID of AKARI IRC object. | |
| orderDistance | INT2 | U1 | Order of distance for an AKARI object. | |
| distance | FLOAT8 | S | arcmin | Distance between AKARI object and SIMBAD object. |
TABLE ned_akari_cache
| Object data of cached NED entries. |
This table has two views: ned_fis_cache_bsc_1_cache, ned_irc_cahce_irc_psc_1_cache
Table contents.| name | type | index | unit | description |
|---|---|---|---|---|
| objName | VARCHAR(32) | P | Unique object name for the NED database. | |
| ra | FLOAT8 | S | deg | J2000 R.A. |
| dec | FLOAT8 | S | deg | J2000 Dec. |
| type | VARCHAR(8) | S | Object type. | |
| redshift | FLOAT8 | Redshift. | ||
| redshiftFlag | VARCHAR(4) | Redshift Flag. |
TABLE ned_fis_cache
| Relation between NED objName and FIS objID. |
This table has a view:ned_fis_bsc_1_cache
Table contents.| name | type | index | unit | description |
|---|---|---|---|---|
| objName | VARCHAR(32) | S | Unique object name for the NED database. | |
| objID | INT4 | U1 | Object ID of AKARI FIS object. | |
| orderDistance | INT2 | U1 | Order of distance for an AKARI object. | |
| distance | FLOAT8 | 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_psc_1_cache
Table contents.| name | type | index | unit | description |
|---|---|---|---|---|
| objName | VARCHAR(32) | S | Unique object name for the NED database. | |
| objID | INT4 | U1 | Object ID of AKARI IRC object. | |
| orderDistance | INT2 | U1 | Order of distance for an AKARI object. | |
| distance | FLOAT8 | S | arcmin | Distance between AKARI object and NED object. |