SQL Schema: Views
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.
Index of Views:
View name after January, 2018 | View name until December, 2017 | Description |
---|---|---|
akari_fis_bsc_1_digest | FisObj | Digest version of AKARI FIS Bright Source Catalogue v1.0 (AKARI FIS BSC 1.0). |
akari_irc_psc_1_digest | IrcObj | Digest version of AKARI IRC Point Source Catalogue v1.0 (AKARI IRC PSC 1.0). |
twomass_digest | twomassobj (Had been used in "SQL Search" I/F.) | Digest version of 2MASS Point Source Catalogue (2MASS PSC). |
(Not created. Please request to recreate, if necessary.) | SimbadFisAll | Relation between SIMBAD OID and FIS objID and object data of cached SIMBAD entries. |
(Not created. Please request to recreate, if necessary.) | SimbadIrcAll | Relation between SIMBAD OID and IRC objID and object data of cached SIMBAD entries. |
(Not created. Please request to recreate, if necessary.) | SimbadCacheAll | Object data of cached SIMBAD entries including relation between SIMBAD OID and IRC/FIS objID. |
ned_akari_fis_bsc_1_cache | NedFisAll | Created from the tables, ned_akari_fis_bsc_1_rel and ned_akari_cache. Relation between NED object name and FIS objID and object data of cached NED entries. |
ned_akari_irc_psc_1_cache | NedIrcAll | Created from the tables, ned_akari_irc_psc_1_rel and ned_akari_cache. Relation between NED object name and IRC objID and object data of cached NED entries. |
(Not created. Please request to recreate, if necessary.) | NedCacheAll | Object data of cached NED entries including relation between NED object name and IRC/FIS objID. |
Digest version of AKARI FIS Bright Source Catalogue v1.0 (AKARI FIS BSC 1.0; 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. |
Digest version of AKARI IRC Point Source Catalogue v1.0 (AKARI IRC PSC 1.0; 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 twomass_digest
Digest version of 2MASS Point Source Catalogue (2MASS PSC; 470992970 rows). |
Table contents.
name | type | unit | description | |
---|---|---|---|---|
objID | INT4 | P | Unique identifier for the DARTS database. Do not refer this ID in your literatures. | |
ra | FLOAT8 | C1,C2 | deg | J2000 right ascension. |
dec | FLOAT8 | C1,C2 | deg | J2000 declination. |
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 meas urement taken at the position of the source on the Atlas Image. |
j_msigcom | FLOAT4 | mag | Combined, or total photometric uncertainty for the default J-band magnitude. | |
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 meas urement taken at the position of the source on the Atlas Image. |
h_msigcom | FLOAT4 | mag | Combined, or total photometric uncertainty for the default H-band magnitude. | |
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 me asurement taken at the position of the source on the Atlas Image. |
k_msigcom | FLOAT4 | mag | Combined, or total photometric uncertainty for the default Ks-band magnitude. | |
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. | ||
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 satel lite. |
VIEW SimbadFisAll - ** This view is obsoluted. Please request to recreate, if necessary. **
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 - ** This view is obsoluted. Please request to recreate, if necessary. **
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 - ** This view is obsoluted. Please request to recreate, if necessary. **
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 ned_akari_fis_bsc_1_cache
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 ned_akari_irc_psc_1_cache
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 - ** This view is obsoluted. Please request to recreate, if necessary. **
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. |