![[new!]](/ir/akari/new.gif)
SQL Schema: Views
Index of Views:| FisObj | Digest version of AKARI FIS Bright Source Catalogue (AKARI FIS BSC). |
| IrcObj | Digest version of AKARI IRC Point Source Catalogue (AKARI IRC PSC). |
| SimbadFisAll | Relation between SIMBAD OID and FIS objID and object data of cached SIMBAD entries. |
| SimbadIrcAll | Relation between SIMBAD OID and IRC objID and object data of cached SIMBAD entries. |
| SimbadCacheAll | Object data of cached SIMBAD entries including relation between SIMBAD OID and IRC/FIS objID. |
| NedFisAll | Relation between NED object name and FIS objID and object data of cached NED entries. |
| NedIrcAll | Relation between NED object name and IRC objID and object data of cached NED entries. |
| NedCacheAll | Object data of cached NED entries including relation between NED object name and IRC/FIS objID. |
VIEW FisObj
| Digest version of AKARI FIS Bright Source Catalogue (AKARI FIS BSC; 427071 rows). |
Table contents.
| name | type | unit | description |
|---|---|---|---|
| objID | INT4 |
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.
|
|
| objName | CHAR | 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 | deg | J2000 Right Ascension of the source position. |
| dec | FLOAT8 | deg | J2000 Declination of the source position. |
| flux_65 | FLOAT4 | 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 | 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 | 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 | 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. |
| fQual_65 | INT2 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | Number of scans on which the source is properly detected with logEvidence larger than the threshold. | |
| nScanC_90 | INT2 | Number of scans on which the source is properly detected with logEvidence larger than the threshold. | |
| nScanC_140 | INT2 | Number of scans on which the source is properly detected with logEvidence larger than the threshold. | |
| nScanC_160 | INT2 | Number of scans on which the source is properly detected with logEvidence larger than the threshold. | |
| nScanP_65 | INT2 | Total number of scans that passed on the source (that possibly observed the source) | |
| nScanP_90 | INT2 | Total number of scans that passed on the source (that possibly observed the source) | |
| nScanP_140 | INT2 | Total number of scans that passed on the source (that possibly observed the source) | |
| nScanP_160 | INT2 | Total number of scans that passed on the source (that possibly observed the source) | |
| mConf_65 | INT2 | 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 | 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 | 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 | 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. |
VIEW IrcObj
| Digest version of AKARI IRC Point Source Catalogue (AKARI IRC PSC; 870973 rows). |
Table contents.
| name | type | unit | description |
|---|---|---|---|
| objID | INT4 |
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.
|
|
| objName | CHAR | 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 | deg | J2000 Right Ascension of the source position. |
| dec | FLOAT8 | deg | J2000 Declination of the source position. |
| flux_09 | FLOAT4 | Jy | Flux density of the source in S9W. |
| flux_18 | FLOAT4 | Jy | Flux density of the source in L18W. |
| fQual_09 | INT2 | Flux density quality flag for S9W. 3 when flux is valid and 0 when flux is not available. | |
| fQual_18 | INT2 | Flux density quality flag for L18W. 3 when flux is valid and 0 when flux is not available. | |
| flags_09 | INT2 |
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. |
|
| flags_18 | INT2 |
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 | 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 | 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 | The number of times the source position has been scanned during the survey. | |
| nScanP_18 | INT2 | The number of times the source position has been scanned during the survey. | |
| mConf_09 | INT2 | 1 is month confirmed and 0 is not. Inverted value of LSB of flags_09 | |
| mConf_18 | INT2 | 1 is month confirmed and 0 is not. Inverted value of LSB of flags_18 |
VIEW SimbadFisAll
| Relation between SIMBAD OID and FIS objID and object data of cached SIMBAD entries. |
Table contents.
| name | type | unit | description |
|---|---|---|---|
| oid | INT4 | Unique object ID for the SIMBAD database. | |
| primIdent | VARCHAR | Primary identifier for the SIMBAD database. | |
| ra | FLOAT8 | deg | J2000 R.A. of SIMBAD object. |
| dec | FLOAT8 | deg | J2000 Declination of SIMBAD object. |
| type | VARCHAR | Type of SIMBAD object. | |
| specType | VARCHAR | Spectral type of SIMBAD object. | |
| morphType | VARCHAR | Morphological type of SIMBAD object. | |
| u | FLOAT4 | mag | U magnitude. |
| b | FLOAT4 | mag | B magnitude. |
| v | FLOAT4 | mag | V magnitude. |
| r | FLOAT4 | mag | R magnitude. |
| i | FLOAT4 | mag | I magnitude. |
| j | FLOAT4 | mag | J magnitude. |
| h | FLOAT4 | mag | H magnitude. |
| k | FLOAT4 | mag | K magnitude. |
| objID | INT4 | Object ID of AKARI FIS object. | |
| orderDistance | INT2 | Order of distance for an AKARI object. | |
| distance | FLOAT8 | arcmin | Distance between AKARI object and SIMBAD object. |
VIEW SimbadIrcAll
| Relation between SIMBAD OID and IRC objID and object data of cached SIMBAD entries. |
Table contents.
| name | type | unit | description |
|---|---|---|---|
| oid | INT4 | Unique object ID for the SIMBAD database. | |
| primIdent | VARCHAR | Primary identifier for the SIMBAD database. | |
| ra | FLOAT8 | deg | J2000 R.A. of SIMBAD object. |
| dec | FLOAT8 | deg | J2000 Declination of SIMBAD object. |
| type | VARCHAR | Type of SIMBAD object. | |
| specType | VARCHAR | Spectral type of SIMBAD object. | |
| morphType | VARCHAR | Morphological type of SIMBAD object. | |
| u | FLOAT4 | mag | U magnitude. |
| b | FLOAT4 | mag | B magnitude. |
| v | FLOAT4 | mag | V magnitude. |
| r | FLOAT4 | mag | R magnitude. |
| i | FLOAT4 | mag | I magnitude. |
| j | FLOAT4 | mag | J magnitude. |
| h | FLOAT4 | mag | H magnitude. |
| k | FLOAT4 | mag | K magnitude. |
| objID | INT4 | Object ID of AKARI IRC object. | |
| orderDistance | INT2 | Order of distance for an AKARI object. | |
| distance | FLOAT8 | arcmin | Distance between AKARI object and SIMBAD object. |
VIEW SimbadCacheAll
| Object data of cached SIMBAD entries including relation between SIMBAD OID and IRC/FIS objID. |
Table contents.
| name | type | unit | description |
|---|---|---|---|
| oid | INT4 | Unique object ID for the SIMBAD database. | |
| primIdent | VARCHAR | Primary identifier for the SIMBAD database. | |
| ra | FLOAT8 | deg | J2000 R.A. of SIMBAD object. |
| dec | FLOAT8 | deg | J2000 Declination of SIMBAD object. |
| type | VARCHAR | Type of SIMBAD object. | |
| specType | VARCHAR | Spectral type of SIMBAD object. | |
| morphType | VARCHAR | Morphological type of SIMBAD object. | |
| u | FLOAT4 | mag | U magnitude. |
| b | FLOAT4 | mag | B magnitude. |
| v | FLOAT4 | mag | V magnitude. |
| r | FLOAT4 | mag | R magnitude. |
| i | FLOAT4 | mag | I magnitude. |
| j | FLOAT4 | mag | J magnitude. |
| h | FLOAT4 | mag | H magnitude. |
| k | FLOAT4 | mag | K magnitude. |
| objID_Fis | INT4 | Object ID of AKARI FIS object. | |
| orderDistance_Fis | INT2 | Order of distance for an AKARI FIS object. | |
| distance_Fis | FLOAT8 | arcmin | Distance between AKARI FIS object and SIMBAD object. |
| objID_Irc | INT4 | Object ID of AKARI IRC object. | |
| orderDistance_Irc | INT2 | Order of distance for an AKARI IRC object. | |
| distance_Irc | FLOAT8 | arcmin | Distance between AKARI IRC object and SIMBAD object. |
VIEW NedFisAll
| Relation between NED object name and FIS objID and object data of cached NED entries. |
Table contents.
| name | type | unit | description |
|---|---|---|---|
| objName | VARCHAR | Unique object name for the NED database. | |
| ra | FLOAT8 | deg | J2000 R.A. of NED object. |
| dec | FLOAT8 | deg | J2000 Declination of NED object. |
| type | VARCHAR | Type of NED object. | |
| redshift | FLOAT8 | Redshift of NED object. | |
| redshiftFlag | VARCHAR | Redshift flag of NED object. | |
| magFilter | VARCHAR | Magnitude/Filter of NED object. | |
| objID | INT4 | Object ID of AKARI FIS object. | |
| orderDistance | INT2 | Order of distance for an AKARI object. | |
| distance | FLOAT8 | arcmin | Distance between AKARI object and NED object. |
VIEW NedIrcAll
| Relation between NED object name and IRC objID and object data of cached NED entries. |
Table contents.
| name | type | unit | description |
|---|---|---|---|
| objName | VARCHAR | Unique object name for the NED database. | |
| ra | FLOAT8 | deg | J2000 R.A. of NED object. |
| dec | FLOAT8 | deg | J2000 Declination of NED object. |
| type | VARCHAR | Type of NED object. | |
| redshift | FLOAT8 | Redshift of NED object. | |
| redshiftFlag | VARCHAR | Redshift flag of NED object. | |
| magFilter | VARCHAR | Magnitude/Filter of NED object. | |
| objID | INT4 | Object ID of AKARI IRC object. | |
| orderDistance | INT2 | Order of distance for an AKARI object. | |
| distance | FLOAT8 | arcmin | Distance between AKARI object and NED object. |
VIEW NedCacheAll
| Object data of cached NED entries including relation between NED object name and IRC/FIS objID. |
Table contents.
| name | type | unit | description |
|---|---|---|---|
| objName | VARCHAR | Unique object name for the NED database. | |
| ra | FLOAT8 | deg | J2000 R.A. of NED object. |
| dec | FLOAT8 | deg | J2000 Declination of NED object. |
| type | VARCHAR | Type of NED object. | |
| redshift | FLOAT8 | Redshift of NED object. | |
| redshiftFlag | VARCHAR | Redshift Flag of NED object. | |
| magFilter | VARCHAR | Magnitude/Filter of NED object. | |
| objID_Fis | INT4 | Object ID of AKARI FIS object. | |
| orderDistance_Fis | INT2 | Order of distance for an AKARI FIS object. | |
| distance_Fis | FLOAT8 | arcmin | Distance between AKARI FIS object and NED object. |
| objID_Irc | INT4 | Object ID of AKARI IRC object. | |
| orderDistance_Irc | INT2 | Order of distance for an AKARI IRC object. | |
| distance_Irc | FLOAT8 | arcmin | Distance between AKARI IRC object and NED object. |