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.

The summary is below:

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_fis_cache_all NedFisAll Created from the tables, ned_fis_cache and ned_fis_irc_cache.
Relation between NED object name and FIS objID and object data of cached NED entries.
ned_irc_cache_all NedIrcAll Created from the tables, ned_irc_cache and ned_fis_irc_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.

VIEW   akari_fis_bsc_1_digest

Digest version of AKARI FIS Bright Source Catalogue v1.0 (AKARI FIS BSC 1.0; 427071 rows).
 
Table contents.
name type unit description
objIDINT4 Unique identifier for the DARTS database. objID is defined like VVxxxxxx in the decimal system. VV indicates the version code of catalog, and xxxxxx shows row number. Do not refer this ID in your literatures.
objNameCHAR Source identifier from its J2000 coordinates, following the IAU Recommendations for Nomenclature (2006). The format is HHMMSSS+/-DDMMSS, e.g., 0123456+765432 for a source at (01h23m45.6s, +76d54m32s). The source must be referred to in the literatures by its full name; AKARI-FIS-V1 J0123456+765432.
raFLOAT8 deg J2000 Right Ascension of the source position.
decFLOAT8 deg J2000 Declination of the source position.
flux_65FLOAT4 Jy Flux density of the source in the four FIS bands in Jansky. In the catalogue the four FIS bands are indicated by their central wavelength as 65, 90, 140 and 160.
Values are given even for the unconfirmed sources as much as possible, though such the data are not guaranteed. If it is not possible to measure the source flux, `NULL' is set.
flux_90FLOAT4 Jy Flux density of the source in the four FIS bands in Jansky. In the catalogue the four FIS bands are indicated by their central wavelength as 65, 90, 140 and 160.
Values are given even for the unconfirmed sources as much as possible, though such the data are not guaranteed. If it is not possible to measure the source flux, `NULL' is set.
flux_140FLOAT4 Jy Flux density of the source in the four FIS bands in Jansky. In the catalogue the four FIS bands are indicated by their central wavelength as 65, 90, 140 and 160.
Values are given even for the unconfirmed sources as much as possible, though such the data are not guaranteed. If it is not possible to measure the source flux, `NULL' is set.
flux_160FLOAT4 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_65INT2 Four level flux quality indicator:
3:  High quality (the source is confirmed and flux is reliable)
2:  The source is confirmed but flux is not reliable (see flags_65)
1:  The source is not confirmed
0:  Not observed (no scan data available)
fQual_90INT2 Four level flux quality indicator:
3:  High quality (the source is confirmed and flux is reliable)
2:  The source is confirmed but flux is not reliable (see flags_90)
1:  The source is not confirmed
0:  Not observed (no scan data available)
fQual_140INT2 Four level flux quality indicator:
3:  High quality (the source is confirmed and flux is reliable)
2:  The source is confirmed but flux is not reliable (see flags_140)
1:  The source is not confirmed
0:  Not observed (no scan data available)
fQual_160INT2 Four level flux quality indicator:
3:  High quality (the source is confirmed and flux is reliable)
2:  The source is confirmed but flux is not reliable (see flags_160)
1:  The source is not confirmed
0:  Not observed (no scan data available)
flags_65INT2 A 16-bit flag per band indicating various data condition. In version 1 catalogue three bits are used. The first bit (bit0) is used to indicate the CDS sampling mode. The second bit (bit1) warns the flux of the band is less than a half of the detection limit, and is not reliable. The fourth bit (bit3) tells that the source is possibly false detection due to `side-lobe' effects (see, Section 7.7 of the Release Note). The third bit (bit2) was previously indicated an anomaly which does not exist in the current version, and thus is kept unused. Sources with bit1 or bit3 = 1 have fQual_65 = 2 or less. Other bits are reserved for the future implementation.
                                   USB ------------- bit ----- LSB
                                       ... 7  6  5  4  3  2  1  0
                                   decimal |  |  |  |  |  |  |  |
   reserved ------------------------- 128 -+  |  |  |  |  |  |  |
   reserved -------------------------- 64 ----+  |  |  |  |  |  |
   reserved -------------------------- 32 -------+  |  |  |  |  |
   reserved -------------------------- 16 ----------+  |  |  |  |
   1: possibly `side-lobe' detection--- 8 -------------+  |  |  |
   not used --------------------------- 4 ----------------+  |  |
   1: Flux too low--------------------- 2 -------------------+  |
   0: Normal mode, 1: CDS mode -------- 1 ----------------------+
   
`NULL' is set in case of no measurement (fQual_65 = 0).
flags_90INT2 A 16-bit flag per band indicating various data condition. In version 1 catalogue three bits are used. The first bit (bit0) is used to indicate the CDS sampling mode. The second bit (bit1) warns the flux of the band is less than a half of the detection limit, and is not reliable. The fourth bit (bit3) tells that the source is possibly false detection due to `side-lobe' effects (see, Section 7.7 of the Release Note). The third bit (bit2) was previously indicated an anomaly which does not exist in the current version, and thus is kept unused. Sources with bit1 or bit3 = 1 have fQual_90 = 2 or less. Other bits are reserved for the future implementation.
                                   USB ------------- bit ----- LSB
                                       ... 7  6  5  4  3  2  1  0
                                   decimal |  |  |  |  |  |  |  |
   reserved ------------------------- 128 -+  |  |  |  |  |  |  |
   reserved -------------------------- 64 ----+  |  |  |  |  |  |
   reserved -------------------------- 32 -------+  |  |  |  |  |
   reserved -------------------------- 16 ----------+  |  |  |  |
   1: possibly `side-lobe' detection--- 8 -------------+  |  |  |
   not used --------------------------- 4 ----------------+  |  |
   1: Flux too low--------------------- 2 -------------------+  |
   0: Normal mode, 1: CDS mode -------- 1 ----------------------+
   
`NULL' is set in case of no measurement (fQual_90 = 0).
flags_140INT2 A 16-bit flag per band indicating various data condition. In version 1 catalogue three bits are used. The first bit (bit0) is used to indicate the CDS sampling mode. The second bit (bit1) warns the flux of the band is less than a half of the detection limit, and is not reliable. The fourth bit (bit3) tells that the source is possibly false detection due to `side-lobe' effects (see, Section 7.7 of the Release Note). The third bit (bit2) was previously indicated an anomaly which does not exist in the current version, and thus is kept unused. Sources with bit1 or bit3 = 1 have fQual_140 = 2 or less. Other bits are reserved for the future implementation.
                                   USB ------------- bit ----- LSB
                                       ... 7  6  5  4  3  2  1  0
                                   decimal |  |  |  |  |  |  |  |
   reserved ------------------------- 128 -+  |  |  |  |  |  |  |
   reserved -------------------------- 64 ----+  |  |  |  |  |  |
   reserved -------------------------- 32 -------+  |  |  |  |  |
   reserved -------------------------- 16 ----------+  |  |  |  |
   1: possibly `side-lobe' detection--- 8 -------------+  |  |  |
   not used --------------------------- 4 ----------------+  |  |
   1: Flux too low--------------------- 2 -------------------+  |
   0: Normal mode, 1: CDS mode -------- 1 ----------------------+
   
`NULL' is set in case of no measurement (fQual_140 = 0).
flags_160INT2 A 16-bit flag per band indicating various data condition. In version 1 catalogue three bits are used. The first bit (bit0) is used to indicate the CDS sampling mode. The second bit (bit1) warns the flux of the band is less than a half of the detection limit, and is not reliable. The fourth bit (bit3) tells that the source is possibly false detection due to `side-lobe' effects (see, Section 7.7 of the Release Note). The third bit (bit2) was previously indicated an anomaly which does not exist in the current version, and thus is kept unused. Sources with bit1 or bit3 = 1 have fQual_160 = 2 or less. Other bits are reserved for the future implementation.
                                   USB ------------- bit ----- LSB
                                       ... 7  6  5  4  3  2  1  0
                                   decimal |  |  |  |  |  |  |  |
   reserved ------------------------- 128 -+  |  |  |  |  |  |  |
   reserved -------------------------- 64 ----+  |  |  |  |  |  |
   reserved -------------------------- 32 -------+  |  |  |  |  |
   reserved -------------------------- 16 ----------+  |  |  |  |
   1: possibly `side-lobe' detection--- 8 -------------+  |  |  |
   not used --------------------------- 4 ----------------+  |  |
   1: Flux too low--------------------- 2 -------------------+  |
   0: Normal mode, 1: CDS mode -------- 1 ----------------------+
   
`NULL' is set in case of no measurement (fQual_160 = 0).
nScanC_65INT2 Number of scans on which the source is properly detected with logEvidence larger than the threshold.
nScanC_90INT2 Number of scans on which the source is properly detected with logEvidence larger than the threshold.
nScanC_140INT2 Number of scans on which the source is properly detected with logEvidence larger than the threshold.
nScanC_160INT2 Number of scans on which the source is properly detected with logEvidence larger than the threshold.
nScanP_65INT2 Total number of scans that passed on the source (that possibly observed the source)
nScanP_90INT2 Total number of scans that passed on the source (that possibly observed the source)
nScanP_140INT2 Total number of scans that passed on the source (that possibly observed the source)
nScanP_160INT2 Total number of scans that passed on the source (that possibly observed the source)
mConf_65INT2 The month confirmation flags are prepared per band. The value is 1 when the source is observed in the scans separated more than one months (usually an object is visible at every 6 months). This information is independent to hours confirmation and can be 1 even if the source is not confirmed (fQual_65 = 1). Because of the visibility constraint of the AKARI Survey, some sky regions were observed by scans only within a month.
This flag is `NULL' for fQual_65 = 0 sources.
mConf_90INT2 The month confirmation flags are prepared per band. The value is 1 when the source is observed in the scans separated more than one months (usually an object is visible at every 6 months). This information is independent to hours confirmation and can be 1 even if the source is not confirmed (fQual_90 = 1). Because of the visibility constraint of the AKARI Survey, some sky regions were observed by scans only within a month.
This flag is `NULL' for fQual_90 = 0 sources.
mConf_140INT2 The month confirmation flags are prepared per band. The value is 1 when the source is observed in the scans separated more than one months (usually an object is visible at every 6 months). This information is independent to hours confirmation and can be 1 even if the source is not confirmed (fQual_140 = 1). Because of the visibility constraint of the AKARI Survey, some sky regions were observed by scans only within a month.
This flag is `NULL' for fQual_140 = 0 sources.
mConf_160INT2 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   akari_irc_psc_1_digest

Digest version of AKARI IRC Point Source Catalogue v1.0 (AKARI IRC PSC 1.0; 870973 rows).
 
Table contents.
name type unit description
objIDINT4 Unique identifier for the DARTS database. objID is defined like VVxxxxxx in the decimal system. VV indicates the version code of catalog, and xxxxxx shows row number. Do not refer this ID in your literatures.
objNameCHAR Source name from its J2000 coordinates, following the IAU Recommendations for Nomenclature (2006). The format is HHMMSSS+/-DDMMSS, e.g., 0123456+765432 for a source at (01h23m45.6s, +76d54m32s). The source must be referred to in the literatures by its full name: AKARI-IRC-V1 J0123456+765432, where V1 refers to the version code.
raFLOAT8 deg J2000 Right Ascension of the source position.
decFLOAT8 deg J2000 Declination of the source position.
flux_09FLOAT4 Jy Flux density of the source in S9W.
flux_18FLOAT4 Jy Flux density of the source in L18W.
fQual_09INT2 Flux density quality flag for S9W. 3 when flux is valid and 0 when flux is not available.
fQual_18INT2 Flux density quality flag for L18W. 3 when flux is valid and 0 when flux is not available.
flags_09INT2 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_18INT2 Bit flags of data quality for L18W:
1(LSB): not month confirmed:
This means that the period between the first detection and the last detection is shorter than a month.
2: saturated (not used in this version)
4: use SAA (not used in this version)
8(MSB): use edge events:
If the number of events is too small, we use the event data near the edge of the image strip. In this case, this flag warn you of underestimation of the flux.
nScanC_09INT2 Number of scans on which the source is detected. Normally, nScanC is less or equal to nScanP. In some exceptional case, resultant position of the source drops out from the image stripe boundary and nScanC is larger than nScanP.
nScanC_18INT2 Number of scans on which the source is detected. Normally, nScanC is less or equal to nScanP. In some exceptional case, resultant position of the source drops out from the image stripe boundary and nScanC is larger than nScanP.
nScanP_09INT2 The number of times the source position has been scanned during the survey.
nScanP_18INT2 The number of times the source position has been scanned during the survey.
mConf_09INT2 1 is month confirmed and 0 is not. Inverted value of LSB of flags_09
mConf_18INT2 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
objIDINT4 P Unique identifier for the DARTS database. Do not refer this ID in your literatures.
raFLOAT8 C1,C2 deg J2000 right ascension.
decFLOAT8 C1,C2 deg J2000 declination.
designationCHAR(17) Sexagesimal, equatorial position-based source name in the form: hhmmssss+ddmmsss[ABC...].
j_mFLOAT4 S mag Default J-band magnitude, or if the source is not detected in the J-band, the 95% confidence upper limit derived from a 4" radius aperture meas urement taken at the position of the source on the Atlas Image.
j_msigcomFLOAT4 mag Combined, or total photometric uncertainty for the default J-band magnitude.
h_mFLOAT4 S mag Default H-band magnitude, or if the source is not detected in the H-band, the 95% confidence upper limit derived from a 4" radius aperture meas urement taken at the position of the source on the Atlas Image.
h_msigcomFLOAT4 mag Combined, or total photometric uncertainty for the default H-band magnitude.
k_mFLOAT4 S mag Default Ks-band magnitude, or if the source is not detected in the Ks-band, the 95% confidence upper limit derived from a 4" radius aperture me asurement taken at the position of the source on the Atlas Image.
k_msigcomFLOAT4 mag Combined, or total photometric uncertainty for the default Ks-band magnitude.
ph_qualCHAR(3) Photometric quality flag.
rd_flgCHAR(3) Read flag.
bl_flgCHAR(3) Blend flag.
cc_flgCHAR(3) Contamination and confusion flag.
gal_contamINT2 Extended source "contamination" flag.
mp_flgINT2 Minor Planet Flag. Indicates if this source is associated with the predicted position of a known minor planet, comet, planet or planetary 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
oidINT4 Unique object ID for the SIMBAD database.
primIdentVARCHAR Primary identifier for the SIMBAD database.
raFLOAT8 deg J2000 R.A. of SIMBAD object.
decFLOAT8 deg J2000 Declination of SIMBAD object.
typeVARCHAR Type of SIMBAD object.
specTypeVARCHAR Spectral type of SIMBAD object.
morphTypeVARCHAR Morphological type of SIMBAD object.
uFLOAT4 mag U magnitude.
bFLOAT4 mag B magnitude.
vFLOAT4 mag V magnitude.
rFLOAT4 mag R magnitude.
iFLOAT4 mag I magnitude.
jFLOAT4 mag J magnitude.
hFLOAT4 mag H magnitude.
kFLOAT4 mag K magnitude.
objIDINT4 Object ID of AKARI FIS object.
orderDistanceINT2 Order of distance for an AKARI object.
distanceFLOAT8 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
oidINT4 Unique object ID for the SIMBAD database.
primIdentVARCHAR Primary identifier for the SIMBAD database.
raFLOAT8 deg J2000 R.A. of SIMBAD object.
decFLOAT8 deg J2000 Declination of SIMBAD object.
typeVARCHAR Type of SIMBAD object.
specTypeVARCHAR Spectral type of SIMBAD object.
morphTypeVARCHAR Morphological type of SIMBAD object.
uFLOAT4 mag U magnitude.
bFLOAT4 mag B magnitude.
vFLOAT4 mag V magnitude.
rFLOAT4 mag R magnitude.
iFLOAT4 mag I magnitude.
jFLOAT4 mag J magnitude.
hFLOAT4 mag H magnitude.
kFLOAT4 mag K magnitude.
objIDINT4 Object ID of AKARI IRC object.
orderDistanceINT2 Order of distance for an AKARI object.
distanceFLOAT8 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
oidINT4 Unique object ID for the SIMBAD database.
primIdentVARCHAR Primary identifier for the SIMBAD database.
raFLOAT8 deg J2000 R.A. of SIMBAD object.
decFLOAT8 deg J2000 Declination of SIMBAD object.
typeVARCHAR Type of SIMBAD object.
specTypeVARCHAR Spectral type of SIMBAD object.
morphTypeVARCHAR Morphological type of SIMBAD object.
uFLOAT4 mag U magnitude.
bFLOAT4 mag B magnitude.
vFLOAT4 mag V magnitude.
rFLOAT4 mag R magnitude.
iFLOAT4 mag I magnitude.
jFLOAT4 mag J magnitude.
hFLOAT4 mag H magnitude.
kFLOAT4 mag K magnitude.
objID_FisINT4 Object ID of AKARI FIS object.
orderDistance_FisINT2 Order of distance for an AKARI FIS object.
distance_FisFLOAT8 arcmin Distance between AKARI FIS object and SIMBAD object.
objID_IrcINT4 Object ID of AKARI IRC object.
orderDistance_IrcINT2 Order of distance for an AKARI IRC object.
distance_IrcFLOAT8 arcmin Distance between AKARI IRC object and SIMBAD object.

VIEW   ned_fis_cache_all

Relation between NED object name and FIS objID and object data of cached NED entries.
 
Table contents.
name type unit description
objNameVARCHAR Unique object name for the NED database.
raFLOAT8 deg J2000 R.A. of NED object.
decFLOAT8 deg J2000 Declination of NED object.
typeVARCHAR Type of NED object.
redshiftFLOAT8 Redshift of NED object.
redshiftFlagVARCHAR Redshift flag of NED object.
magFilterVARCHAR Magnitude/Filter of NED object.
objIDINT4 Object ID of AKARI FIS object.
orderDistanceINT2 Order of distance for an AKARI object.
distanceFLOAT8 arcmin Distance between AKARI object and NED object.

VIEW   ned_irc_cache_all

Relation between NED object name and IRC objID and object data of cached NED entries.
 
Table contents.
name type unit description
objNameVARCHAR Unique object name for the NED database.
raFLOAT8 deg J2000 R.A. of NED object.
decFLOAT8 deg J2000 Declination of NED object.
typeVARCHAR Type of NED object.
redshiftFLOAT8 Redshift of NED object.
redshiftFlagVARCHAR Redshift flag of NED object.
magFilterVARCHAR Magnitude/Filter of NED object.
objIDINT4 Object ID of AKARI IRC object.
orderDistanceINT2 Order of distance for an AKARI object.
distanceFLOAT8 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
objNameVARCHAR Unique object name for the NED database.
raFLOAT8 deg J2000 R.A. of NED object.
decFLOAT8 deg J2000 Declination of NED object.
typeVARCHAR Type of NED object.
redshiftFLOAT8 Redshift of NED object.
redshiftFlagVARCHAR Redshift Flag of NED object.
magFilterVARCHAR Magnitude/Filter of NED object.
objID_FisINT4 Object ID of AKARI FIS object.
orderDistance_FisINT2 Order of distance for an AKARI FIS object.
distance_FisFLOAT8 arcmin Distance between AKARI FIS object and NED object.
objID_IrcINT4 Object ID of AKARI IRC object.
orderDistance_IrcINT2 Order of distance for an AKARI IRC object.
distance_IrcFLOAT8 arcmin Distance between AKARI IRC object and NED object.

Last Modified: 19 November 2018