CALET HITOMI MAXI SUZAKU ASCA GINGA TENMA AKARI IRTS BICE HALCA

DARTS Astrophysical Data Search

[ English | Japanese ]

Schema of Tables about AKARI

Satelite/Project Abstract of the data product Database table name Number of entries in the database Searhcable with Basic Search Searchable with SQL/ADQL Search Name in the previous query system
AKARI Information about each file,
with "AKARI Far-infrared All-Sky Survey Maps Version 2.1 (Public release version 1)" 		akari_fis_allskymap_2_1 6,688 Yes Yes akari_fis_allskymap_2_1 on DARTS/AKARI DAS
AKARI Catalogue data,
with "AKARI FIS All-Sky Survey Bright Source Catalogue Version 1.0" 		akari_fis_bsc_1 427,071 Yes Yes akari_fis_bsc_1 on DARTS/AKARI CAS
AKARI Catalogue data,
with "AKARI IRC All-Sky Survey Point Source Catalogue Version 1.0" 		akari_irc_psc_1 870,973 Yes Yes akari_irc_psc_1 on DARTS/AKARI CAS
AKARI Catalogue data,
with "AKARI NEP-Deep Mid-Infrared Source Catalogue Version 2" 		akari_irc_nep_deep_psc_2 27,770 Yes Yes
AKARI Catalogue data,
with "AKARI NEP-Wide IR Source Catalogue Version 1" 		akari_irc_nep_wide_psc_1 114,794 Yes Yes
AKARI Catalogue data,
with "AKARI-LMC Point Source Catalogue Version 1"
This contains all the detected sources by "AKARI" observations, named "Archive" by the author. 		akari_irc_lmc_psc_1_all 802,285 Yes Yes
AKARI Catalogue data,
with "AKARI-LMC Point Source Catalogue Version 1"
This includes only the sources that have a counterpart in the Spitzer SAGE point-source catalog, named "Catalog" by the author. 		akari_irc_lmc_psc_1_sage 660,286 Yes Yes
AKARI Information about each package file,
with "AKARI Pointed Observation Raw Data Version 1 (Phase 1&2) and Version 2 (Phase 3)" 		akari_pointed_rawdata_package_info 24,436 Yes Yes PKGINFO

akari_fis_allskymap_2_1

  • Columns to display in the Basic Search can be chosen either "digest" or "full" in the "Display" menu.
  • (*) means that the same coordinates as specified in the Basic Search "Coordinate" are displayed in the "digest" mode. If you use TargetName, Equatorial J2000 will be displayed.
  • On SQL Search and ADQL Search, all the columns are available, including columns marked "no output" in this table.
No. Column Name Type Unit Description Output Former Column Name Former Type Former Unit
1 data_file_id integer Data file ID digest / full fits_id INTEGER
2 reference_coordinate_lon double precision Coordinate Longitude of the reference point full crval1 DOUBLE
3 reference_coordinate_lat double precision Coordinate Latitude of the reference point full crval2 DOUBLE
4 coordinate_system character varying(8) Coordinate system of the data files. full ― ― ―
5 reference_pixel_x double precision Pixel x coordinate of reference point full crpix1 DOUBLE
6 reference_pixel_y double precision Pixel y coordinate of reference point full crpix2 DOUBLE
7 center_ra double precision degree Image center, Right Ascenstion J2000. digest (*) / full ra DOUBLE degree
8 center_dec double precision degree Image center, Declinatoion J2000. dec DOUBLE degree
9 center_ra_b1950 double precision degree Image center, Right Ascenstion B1950. Calculated from (center_ra, center_dec) ra1950 DOUBLE degree
10 center_dec_b1950 double precision degree Image center, Declinatoion B1950. Calculated from (center_ra, center_dec) dec1950 DOUBLE degree
11 center_ecliptic_lon double precision degree Image center, Ecliptic Longitude. Calculated from (center_ra, center_dec) lambda DOUBLE degree
12 center_ecliptic_lat double precision degree Image center, Ecliptic Latitude. Calculated from (center_ra, center_dec) beta DOUBLE degree
13 center_galactic_lon double precision degree Image center, Galactic Longitude. Calculated from (center_ra, center_dec) lon DOUBLE degree
14 center_galactic_lat double precision degree Image center, Galactic Latitude. Calculated from (center_ra, center_dec) lat DOUBLE degree
15 center_coordinate_x double precision Image center, x coordinate full cx DOUBLE
16 center_coordinate_y double precision Image center, y coordinate full cy DOUBLE
17 center_coordinate_z double precision Image center, z coordinate full cz DOUBLE
18 band_name character varying(8) Observation wavelength digest / full band VARCHAR(8)
19 pixel_counts_x integer Number of x pixels full naxis1 INTEGER
20 pixel_counts_y integer Number of y pixels full naxis2 INTEGER
21 rotation_1_1 double precision Rotation factor of the pixel counter electrode point near the reference point full cd1_1 DOUBLE
22 rotation_1_2 double precision Rotation factor of the pixel counter electrode point near the reference point full cd1_2 DOUBLE
23 rotation_2_1 double precision Rotation factor of the pixel counter electrode point near the reference point full cd2_1 DOUBLE
24 rotation_2_2 double precision Rotation factor of the pixel counter electrode point near the reference point full cd2_2 DOUBLE
25 data_file_create_time character varying(64) UTC Data file created time full create_date VARCHAR(64) UTC
26 data_access_url character varying(255) URL used to access dataset digest / full fits_name VARCHAR(64)
27 corner1_ra double precision degree Coordinate of the vertex1 of the observation field of view, Right Ascension J2000. full ― ― ―
28 corner1_dec double precision degree Coordinate of the vertex1 of the observation field of view, Declinationn J2000. full ― ― ―
29 corner2_ra double precision degree Coordinate of the vertex2 of the observation field of view, Right Ascension J2000. full ― ― ―
30 corner2_dec double precision degree Coordinate of the vertex2 of the observation field of view, Declinationn J2000. full ― ― ―
31 corner3_ra double precision degree Coordinate of the vertex3 of the observation field of view, Right Ascension J2000. full ― ― ―
32 corner3_dec double precision degree Coordinate of the vertex3 of the observation field of view, Declinationn J2000. full ― ― ―
33 corner4_ra double precision degree Coordinate of the vertex4 of the observation field of view, Right Ascension J2000. full ― ― ―
34 corner4_dec double precision degree Coordinate of the vertex4 of the observation field of view, Declinationn J2000. full ― ― ―
35 corner1_ra_b1950 double precision degree Coordinate of the vertex1 of the observation field of view, Right Ascension B1950. full ― ― ―
36 corner1_dec_b1950 double precision degree Coordinate of the vertex1 of the observation field of view, Declinationn B1950. full ― ― ―
37 corner2_ra_b1950 double precision degree Coordinate of the vertex2 of the observation field of view, Right Ascension B1950. full ― ― ―
38 corner2_dec_b1950 double precision degree Coordinate of the vertex2 of the observation field of view, Declinationn B1950. full ― ― ―
39 corner3_ra_b1950 double precision degree Coordinate of the vertex3 of the observation field of view, Right Ascension B1950. full ― ― ―
40 corner3_dec_b1950 double precision degree Coordinate of the vertex3 of the observation field of view, Declinationn B1950. full ― ― ―
41 corner4_ra_b1950 double precision degree Coordinate of the vertex4 of the observation field of view, Right Ascension B1950. full ― ― ―
42 corner4_dec_b1950 double precision degree Coordinate of the vertex4 of the observation field of view, Declinationn B1950. full ― ― ―
43 corner1_ecliptic_lon double precision degree Coordinate of the vertex1 of the observation field of view, Ecliptic Longitude. full ― ― ―
44 corner1_ecliptic_lat double precision degree Coordinate of the vertex1 of the observation field of view, Ecliptic Latitude. full ― ― ―
45 corner2_ecliptic_lon double precision degree Coordinate of the vertex2 of the observation field of view, Ecliptic Longitude. full ― ― ―
46 corner2_ecliptic_lat double precision degree Coordinate of the vertex2 of the observation field of view, Ecliptic Latitude. full ― ― ―
47 corner3_ecliptic_lon double precision degree Coordinate of the vertex3 of the observation field of view, Ecliptic Longitude. full ― ― ―
48 corner3_ecliptic_lat double precision degree Coordinate of the vertex3 of the observation field of view, Ecliptic Latitude. full ― ― ―
49 corner4_ecliptic_lon double precision degree Coordinate of the vertex4 of the observation field of view, Ecliptic Longitude. full ― ― ―
50 corner4_ecliptic_lat double precision degree Coordinate of the vertex4 of the observation field of view, Ecliptic Latitude. full ― ― ―
51 corner1_galactic_lon double precision degree Coordinate of the vertex1 of the observation field of view, Galactic Longitude. full ― ― ―
52 corner1_galactic_lat double precision degree Coordinate of the vertex1 of the observation field of view, Galactic Latitude. full ― ― ―
53 corner2_galactic_lon double precision degree Coordinate of the vertex2 of the observation field of view, Galactic Longitude. full ― ― ―
54 corner2_galactic_lat double precision degree Coordinate of the vertex2 of the observation field of view, Galactic Latitude. full ― ― ―
55 corner3_galactic_lon double precision degree Coordinate of the vertex3 of the observation field of view, Galactic Longitude. full ― ― ―
56 corner3_galactic_lat double precision degree Coordinate of the vertex3 of the observation field of view, Galactic Latitude. full ― ― ―
57 corner4_galactic_lon double precision degree Coordinate of the vertex4 of the observation field of view, Galactic Longitude. full ― ― ―
58 corner4_galactic_lat double precision degree Coordinate of the vertex4 of the observation field of view, Galactic Latitude. full ― ― ―

Scroll Back to Top ⏏

akari_fis_bsc_1

  • Columns to display in the Basic Search can be chosen either "digest" or "full" in the "Display" menu.
  • (*) means that the same coordinates as specified in the Basic Search "Coordinate" are displayed in the "digest" mode. If you use TargetName, Equatorial J2000 will be displayed.
  • On SQL Search and ADQL Search, all the columns are available, including columns marked "no output" in this table.
No. Column Name Type Unit Description Output with Basic Search on DARTS/AKARI CAS
Column Name Type Unit
1 object_id integer 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. digest / full objID INT4
2 object_name character varying(14) 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. digest / full objName CHAR(14)
3 object_ra double precision deg J2000 Right Ascension of the source position. digest (*) / full ra FLOAT8 deg
4 object_dec double precision deg J2000 Declination of the source position. dec FLOAT8 deg
5 object_ra_b1950 double precision deg Right Ascension (B1950) ra1950 FLOAT8 deg
6 object_dec_b1950 double precision deg Declination (B1950) dec1950 FLOAT8 deg
7 object_ecliptic_lon double precision deg Ecliptic longitude lambda FLOAT8 deg
8 object_ecliptic_lat double precision deg Ecliptic latitude beta FLOAT8 deg
9 object_galactic_lon double precision deg Galactic longitude l FLOAT8 deg
10 object_galactic_lat double precision deg Galactic latitude b FLOAT8 deg
11 object_coordinate_x double precision Unit vector for ra+dec full cx FLOAT8
12 object_coordinate_y double precision Unit vector for ra+dec full cy FLOAT8
13 object_coordinate_z double precision Unit vector for ra+dec full cz FLOAT8
14 position_err_with_major_axis double precision 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 . full posErrMj FLOAT4 arcsec
15 position_err_with_minor_axis double precision 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 . full posErrMi FLOAT4 arcsec
16 position_err_with_roll_angle double precision 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 . full posErrPA FLOAT4 deg
17 flux_density_65 double precision 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. 		digest / full flux_65 FLOAT4 Jy
18 flux_density_90 double precision 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. 		digest / full flux_90 FLOAT4 Jy
19 flux_density_140 double precision 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. 		digest / full flux_140 FLOAT4 Jy
20 flux_density_160 double precision 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. 		digest / full flux_160 FLOAT4 Jy
21 flux_err_65 double precision 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 scan_quantity_with_evidence_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. 		full fErr_65 FLOAT4 Jy
22 flux_err_90 double precision 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 scan_quantity_with_evidence_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. 		full fErr_90 FLOAT4 Jy
23 flux_err_140 double precision 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 scan_quantity_with_evidence_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. 		full fErr_140 FLOAT4 Jy
24 flux_err_160 double precision 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 scan_quantity_with_evidence_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. 		full fErr_160 FLOAT4 Jy
25 flux_quality_65 smallint 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 data_condition_flags_65)
1:  The source is not confirmed
0:  Not observed (no scan data available) 		full fQual_65 INT2
26 flux_quality_90 smallint 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 data_condition_flags_90)
1:  The source is not confirmed
0:  Not observed (no scan data available) 		full fQual_90 INT2
27 flux_quality_140 smallint 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 data_condition_flags_140)
1:  The source is not confirmed
0:  Not observed (no scan data available) 		full fQual_140 INT2
28 flux_quality_160 smallint 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 data_condition_flags_160)
1:  The source is not confirmed
0:  Not observed (no scan data available) 		full fQual_160 INT2
29 data_condition_flags_65 smallint 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 flux_quality_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 (flux_quality_65 = 0). 		full flags_65 INT2
30 data_condition_flags_90 smallint 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 flux_quality_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 (flux_quality_90 = 0). 		full flags_90 INT2
31 data_condition_flags_140 smallint 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 flux_quality_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 (flux_quality_140 = 0). 		full flags_140 INT2
32 data_condition_flags_160 smallint 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 flux_quality_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 (flux_quality_160 = 0). 		full flags_160 INT2
33 scan_quantity_with_evidence_65 smallint Number of scans on which the source is properly detected with logEvidence larger than the threshold. full nScanC_65 INT2
34 scan_quantity_with_evidence_90 smallint Number of scans on which the source is properly detected with logEvidence larger than the threshold. full nScanC_90 INT2
35 scan_quantity_with_evidence_140 smallint Number of scans on which the source is properly detected with logEvidence larger than the threshold. full nScanC_140 INT2
36 scan_quantity_with_evidence_160 smallint Number of scans on which the source is properly detected with logEvidence larger than the threshold. full nScanC_160 INT2
37 scan_total_quantity_65 smallint Total number of scans that passed on the source (that possibly observed the source) full nScanP_65 INT2
38 scan_total_quantity_90 smallint Total number of scans that passed on the source (that possibly observed the source) full nScanP_90 INT2
39 scan_total_quantity_140 smallint Total number of scans that passed on the source (that possibly observed the source) full nScanP_140 INT2
40 scan_total_quantity_160 smallint Total number of scans that passed on the source (that possibly observed the source) full nScanP_160 INT2
41 month_confirmation_flag_65 smallint 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 (flux_quality_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 flux_quality_65 = 0 sources. 		full mConf_65 INT2
42 month_confirmation_flag_90 smallint 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 (flux_quality_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 flux_quality_90 = 0 sources. 		full mConf_90 INT2
43 month_confirmation_flag_140 smallint 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 (flux_quality_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 flux_quality_140 = 0 sources. 		full mConf_140 INT2
44 month_confirmation_flag_160 smallint 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 (flux_quality_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 flux_quality_160 = 0 sources. 		full mConf_160 INT2
45 object_quantity_in5arcmin smallint 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. full nDens INT2
46 data_access_url character varying(255) URL used to access dataset digest / full ― ― ―

Scroll Back to Top ⏏

akari_irc_psc_1

  • Columns to display in the Basic Search can be chosen either "digest" or "full" in the "Display" menu.
  • (*) means that the same coordinates as specified in the Basic Search "Coordinate" are displayed in the "digest" mode. If you use TargetName, Equatorial J2000 will be displayed.
  • On SQL Search and ADQL Search, all the columns are available, including columns marked "no output" in this table.
No. Column Name Type Unit Description Output with Basic Search on DARTS/AKARI CAS
Column Name Type Unit
1 object_id integer Unique identifier for the DARTS database. objID is defined like VVxxxxxxxx in the decimal system. VV indicates the version code of catalog, and xxxxxxxx shows row number. Do not refer this ID in your literatures. digest / full objID INT4
2 object_name character varying(14) 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. digest / full objName CHAR(14)
3 object_ra double precision deg J2000 Right Ascension of the source position. digest (*) / full ra FLOAT8 deg
4 object_dec double precision deg J2000 Declination of the source position. dec FLOAT8 deg
object_ra_b1950 double precision deg Right Ascension (B1950) ra1950 FLOAT8 deg
6 object_dec_b1950 double precision deg Declination (B1950) dec1950 FLOAT8 deg
7 object_ecliptic_longitude double precision deg Ecliptic longitude lambda FLOAT8 deg
8 object_ecliptic_latitude double precision deg Ecliptic latitude beta FLOAT8 deg
9 object_galactic_longitude double precision deg Galactic longitude l FLOAT8 deg
10 object_galactic_latitude double precision deg Galactic latitude b FLOAT8 deg
11 object_coordinate_x double precision Unit vector for ra+dec full cx FLOAT8
12 object_coordinate_y double precision Unit vector for ra+dec full cy FLOAT8
13 object_coordinate_z double precision Unit vector for ra+dec full cz FLOAT8
14 position_err_with_major_axis double precision 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, position_err_with_major_axis is calculated from the distance of the two events and position_err_with_minor_axis is set to the same as position_err_with_major_axis. full posErrMj double precision arcsec
15 position_err_with_minor_axis double precision 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, position_err_with_major_axis is calculated from the distance of the two events and position_err_with_minor_axis is set to the same as position_err_with_major_axis. full posErrMi FLOAT4 arcsec
16 position_err_with_roll_angle double precision 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, position_err_with_major_axis is calculated from the distance of the two events and position_err_with_minor_axis is set to the same as position_err_with_major_axis. full posErrPA FLOAT4 deg
17 flux_density_09 double precision Jy Flux density of the source in S9W in Jansky. digest / full flux_09 FLOAT4 Jy
18 flux_density_18 double precision Jy Flux density of the source in L18W in Jansky. digest / full flux_18 FLOAT4 Jy
19 flux_err_09 double precision Jy Flux error in S9W. full fErr_09 FLOAT4 Jy
20 flux_err_18 double precision Jy Flux error in L18W. full fErr_18 FLOAT4 Jy
21 flux_quality_09 INT2 Flux density quality flag for S9W. 3 when flux is valid and 0 when flux is not available. full fQual_09 INT2
22 flux_quality_18 INT2 Flux density quality flag for L18W. 3 when flux is valid and 0 when flux is not available. full fQual_18 INT2
23 data_condition_flags_09 INT2 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. 		full flags_09 INT2
24 data_condition_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. 		full flags_18 INT2
25 scan_quantity_with_evidence_09 smallint Number of scans on which the source is detected. Normally, scan_quantity_with_evidence is less or equal to scan_total_quantity. In some exceptional case, resultant position of the source drops out from the image stripe boundary and scan_quantity_with_evidence is larger than scan_total_quantity. full nScanC_09 INT2
26 scan_quantity_with_evidence_18 smallint Number of scans on which the source is detected. Normally, scan_quantity_with_evidence is less or equal to scan_total_quantity. In some exceptional case, resultant position of the source drops out from the image stripe boundary and scan_quantity_with_evidence is larger than scan_total_quantity. full nScanC_18 INT2
27 scan_total_quantity_09 smallint The number of times the source position has been scanned during the survey. full nScanP_09 INT2
28 scan_total_quantity_18 smallint The number of times the source position has been scanned during the survey. full nScanP_18 INT2
29 month_confirmation_flag_09 smallint 1 is month confirmed and 0 is not. Inverted value of LSB of data_condition_flags_09 full mConf_09 INT2
30 month_confirmation_flag_18 smallint 1 is month confirmed and 0 is not. Inverted value of LSB of data_condition_flags_18 full mConf_18 INT2
31 object_quantity_in45arcsec_09 smallint The number of sources in 45 arcsec radius. full nDens_09 INT2
32 object_quantity_in45arcsec_18 smallint The number of sources in 45 arcsec radius. full nDens_18 INT2
33 extended_flag_09 smallint The flag indicates that the source is possibly more extended than the point spread function. This is "TRUE" when meanAB > 15.6 [arcsec]. full extended_09 INT2
34 extended_flag_18 smallint The flag indicates that the source is possibly more extended than the point spread function. This is "TRUE" when meanAB > 15.6 [arcsec]. full extended_18 INT2
35 position_err_average_radius_09 double precision 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. full meanAB_09 FLOAT4
36 position_err_average_radius_18 double precision 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. full meanAB_18 FLOAT4
37 observation_counts_for_decide_position smallint 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. observation_counts_for_decide_position = scan_quantity_with_evidence_09 for scan_quantity_with_evidence_09 ≥ 2
observation_counts_for_decide_position = scan_quantity_with_evidence_18 for scan_quantity_with_evidence_09 < 2 		full nDataPos INT2
38 observation_counts_for_measurement_flax_09 smallint 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. full nData_09 INT2
39 observation_counts_for_measurement_flax_18 smallint 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. full nData_18 INT2
40 data_access_url character varying(255) URL used to access dataset digest / full ― ― ―

Scroll Back to Top ⏏

akari_irc_nep_deep_psc_2

  • Columns to display in the Basic Search can be chosen either "digest" or "full" in the "Display" menu.
  • (*) means that the same coordinates as specified in the Basic Search "Coordinate" are displayed in the "digest" mode. If you use TargetName, Equatorial J2000 will be displayed.
  • On SQL Search and ADQL Search, all the columns are available, including columns marked "no output" in this table.
No. Column Name type Unit Description Output
1 object_id integer --- Source ID digest / full
2 object_name character varying(19) --- Source name [Jnnnnnn.nn+nnnnnn.n] digest / full
3 object_ra numeric(8,5) deg Right Ascension (J2000.0). The coordinates of the objects. It is mostly from MegaCam z' band. If it has no counterpart from MegaCam z' but WIRCam Ks, the coordinates were derived from WIRCam Ks. If it has a counterpart from S-Cam z', neither MegaCam z' nor WIRCam Ks, the coordinates were derived from S-Cam z'. Otherwise, they were from AKARI MIR detection. digest(*) / full
4 object_dec numeric(8,5) deg Declination (J2000.0). The coordinates of the objects. It is mostly from MegaCam z' band. If it has no counterpart from MegaCam z' but WIRCam Ks, the coordinates were derived from WIRCam Ks. If it has a counterpart from S-Cam z', neither MegaCam z' nor WIRCam Ks, the coordinates were derived from S-Cam z'. Otherwise, they were from AKARI MIR detection.
5 object_ra_b1950 numeric(8,5) deg Source position in Right Ascension (B1950). It is calculated from object_ra and object_dec.
6 object_dec_b1950 numeric(8,5) deg Source position in Declination (B1950). It is calculated from object_ra and object_dec.
7 object_ecliptic_lon numeric(8,5) deg Source position in Ecliptic longitude. It is calculated from object_ra and object_dec.
8 object_ecliptic_lat numeric(8,5) deg Source position in Ecliptic Latitude. It is calculated from object_ra and object_dec.
9 object_galactic_lon numeric(8,5) deg Source position in Galactic longitude. It is calculated from object_ra and object_dec.
10 object_galactic_lat numeric(8,5) deg Source position in Galactic Latitude. It is calculated from object_ra and object_dec.
11 ground_instument_and_band character varying(19) --- Band of ground-based catalogue. digest / full
12 catalogue_id_megacam_z_dash integer --- ID of ground-based catalogue. MegaCam z' band catalogue IDs. No IDs are given for either WIRCam Ks or S-Cam z' band catalogues. (Oi et al 2014, A&A 566 A60) digest / full
13 mir_id smallint --- ID of MIR detection catalogue. The same ID might be given to different objects, when multiple counterparts are found in the ground-based catalogue. digest / full
14 mir_object_ra numeric(8,5) deg RA from MIR detection (J2000.0) No coordinates based only on the NIR bands are available. MIR objects located at a region centred at (RA=269.60858, Dec=66.62320) within the radius of 5 arcmin were excluded in order to avoid the scattered light from NGC6543 (Cat's Eye Nebula). digest / full
15 mir_object_dec numeric(7,5) deg Dec from MIR detection(J2000.0) No coordinates based only on the NIR bands are available. MIR objects located at a region centred at (RA=269.60858, Dec=66.62320) within the radius of 5 arcmin were excluded in order to avoid the scattered light from NGC6543 (Cat's Eye Nebula). digest / full
16 magnitude_cfht_megacam_u_aster numeric(4,2) mag u* magnitude [CFHT/MegaCam] digest / full
17 magnitude_err_cfht_megacam_u_aster numeric(3,2) mag u* magnitude error digest / full
18 magnitude_flg_cfht_megacam_u_aster smallint --- u* magnitude flag. Flag is from the ground-based catalogue as follows:
  • 0 = no problem.
  • 1 = multiple counterparts are found for the base-band (i.e. MegaCam z' when GRDBAND=Z or WIRCam Ks when GRDBAND=K ) source when ground-based catalogues were created. The magnitude is summed of all the candidate magnitudes but S-cam.
  • 2 = multiple base-band sources have one common counterpart in other band.
  • NULL = no detection.
 digest / full
19 magnitude_cfht_megacam_g_dash numeric(4,2) mag g' magnitude [CFHT/MegaCam] digest / full
20 magnitude_err_cfht_megacam_g_dash numeric(3,2) mag g' magnitude error digest / full
21 magnitude_flg_cfht_megacam_g_dash smallint --- g' magnitude flag. Flag is from the ground-based catalogue as follows:
  • 0 = no problem.
  • 1 = multiple counterparts are found for the base-band (i.e. MegaCam z' when GRDBAND=Z or WIRCam Ks when GRDBAND=K ) source when ground-based catalogues were created. The magnitude is summed of all the candidate magnitudes but S-cam.
  • 2 = multiple base-band sources have one common counterpart in other band.
  • NULL = no detection.
 digest / full
22 magnitude_cfht_megacam_r_dash numeric(4,2) mag r' magnitude [CFHT/MegaCam] digest / full
23 magnitude_err_cfht_megacam_r_dash numeric(3,2) mag r' magnitude error digest / full
24 magnitude_flg_cfht_megacam_r_dash smallint --- r' magnitude flag. Flag is from the ground-based catalogue as follows:
  • 0 = no problem.
  • 1 = multiple counterparts are found for the base-band (i.e. MegaCam z' when GRDBAND=Z or WIRCam Ks when GRDBAND=K ) source when ground-based catalogues were created. The magnitude is summed of all the candidate magnitudes but S-cam.
  • 2 = multiple base-band sources have one common counterpart in other band.
  • NULL = no detection.
 digest / full
25 magnitude_cfht_megacam_i_dash numeric(4,2) mag i' magnitude [CFHT/MegaCam] digest / full
26 magnitude_err_cfht_megacam_i_dash numeric(3,2) mag i' magnitude error digest / full
27 magnitude_flg_cfht_megacam_i_dash smallint --- i' magnitude flag. Flag is from the ground-based catalogue as follows:
  • 0 = no problem.
  • 1 = multiple counterparts are found for the base-band (i.e. MegaCam z' when GRDBAND=Z or WIRCam Ks when GRDBAND=K ) source when ground-based catalogues were created. The magnitude is summed of all the candidate magnitudes but S-cam.
  • 2 = multiple base-band sources have one common counterpart in other band.
  • NULL = no detection.
 digest / full
28 magnitude_cfht_megacam_z_dash numeric(4,2) mag z' magnitude [CFHT/MegaCam] digest / full
29 magnitude_err_cfht_megacam_z_dash numeric(3,2) mag z' magnitude error digest / full
30 magnitude_flg_cfht_megacam_z_dash smallint --- z' magnitude flag . Flag is from the ground-based catalogue as follows:
  • 0 = no problem.
  • 1 = multiple counterparts are found for the base-band (i.e. MegaCam z' when GRDBAND=Z or WIRCam Ks when GRDBAND=K ) source when ground-based catalogues were created. The magnitude is summed of all the candidate magnitudes but S-cam.
  • 2 = multiple base-band sources have one common counterpart in other band.
  • NULL = no detection.
 digest / full
31 magnitude_cfht_wircam_y numeric(4,2) mag Y magnitude [CFHT/WIRCam] digest / full
32 magnitude_err_cfht_wircam_y numeric(3,2) mag Y magnitude error digest / full
33 magnitude_flg_cfht_wircam_y smallint --- Y magnitude flag. Flag is from the ground-based catalogue as follows:
  • 0 = no problem.
  • 1 = multiple counterparts are found for the base-band (i.e. MegaCam z' when GRDBAND=Z or WIRCam Ks when GRDBAND=K ) source when ground-based catalogues were created. The magnitude is summed of all the candidate magnitudes but S-cam.
  • 2 = multiple base-band sources have one common counterpart in other band.
  • NULL = no detection.
 digest / full
34 magnitude_cfht_wircam_j numeric(4,2) mag J magnitude [CFHT/WIRCam] digest / full
35 magnitude_err_cfht_wircam_j numeric(3,2) mag J magnitude error digest / full
36 magnitude_flg_cfht_wircam_j smallint --- J magnitude flag. Flag is from the ground-based catalogue as follows:
  • 0 = no problem.
  • 1 = multiple counterparts are found for the base-band (i.e. MegaCam z' when GRDBAND=Z or WIRCam Ks when GRDBAND=K ) source when ground-based catalogues were created. The magnitude is summed of all the candidate magnitudes but S-cam.
  • 2 = multiple base-band sources have one common counterpart in other band.
  • NULL = no detection.
 digest / full
37 magnitude_cfht_wircam_ks numeric(4,2) mag Ks magnitude [CFHT/WIRCam] digest / full
38 magnitude_err_cfht_wircam_ks numeric(3,2) mag Ks magnitude error digest / full
39 magnitude_flg_cfht_wircam_ks smallint --- Ks magnitude flag. Flag is from the ground-based catalogue as follows:
  • 0 = no problem.
  • 1 = multiple counterparts are found for the base-band (i.e. MegaCam z' when GRDBAND=Z or WIRCam Ks when GRDBAND=K ) source when ground-based catalogues were created. The magnitude is summed of all the candidate magnitudes but S-cam.
  • 2 = multiple base-band sources have one common counterpart in other band.
  • NULL = no detection.
 digest / full
40 magnitude_subaru_scam_b numeric(4,2) mag B magnitude [Subaru/S-Cam] digest / full
41 magnitude_err_subaru_scam_b numeric(5,2) mag B magnitude error. digest / full
42 magnitude_flg_subaru_scam_b smallint --- B magnitude flag. S-cam catalogue is created using SExtractor's dual mode, based on z' band. All flags are set as 0, as far as the source is detected in the band. digest / full
43 magnitude_subaru_scam_v numeric(4,2) mag V magnitude [Subaru/S-Cam]. digest / full
44 magnitude_err_subaru_scam_v numeric(4,2) mag V magnitude error. digest / full
45 magnitude_flg_subaru_scam_v smallint --- V magnitude flag. S-cam catalogue is created using SExtractor's dual mode, based on z' band. digest / full
46 magnitude_subaru_scam_rs numeric(4,2) mag Rs magnitude [Subaru/S-Cam]. digest / full
47 magnitude_err_subaru_scam_rs numeric(3,2) mag Rs magnitude error. digest / full
48 magnitude_flg_subaru_scam_rs smallint --- Rs magnitude flag. S-cam catalogue is created using SExtractor's dual mode, based on z' band. digest / full
49 magnitude_subaru_scam_i_dash numeric(4,2) mag i' magnitude [Subaru/S-Cam] . digest / full
50 magnitude_err_subaru_scam_i_dash numeric(3,2) mag i' magnitude error. digest / full
51 magnitude_flg_subaru_scam_i_dash smallint --- i' magnitude flag. S-cam catalogue is created using SExtractor's dual mode, based on z' band. digest / full
52 magnitude_subaru_scam_z_dash numeric(4,2) mag z' magnitude [Subaru/S-Cam]. digest / full
53 magnitude_err_subaru_scam_z_dash numeric(3,2) mag z' magnitude error. digest / full
54 magnitude_flg_subaru_scam_z_dash smallint --- z' magnitude flag. S-cam catalogue is created using SExtractor's dual mode, based on z' band. digest / full
55 magnitude_subaru_scam_nb711 numeric(4,2) mag NB711 mag. [Subaru/S-Cam]. digest / full
56 magnitude_err_subaru_scam_nb711 numeric(3,2) mag NB711 mag. error . digest / full
57 magnitude_flg_subaru_scam_nb711 smallint --- NB711 mag. flag. S-cam catalogue is created using SExtractor's dual mode, based on z' band. digest / full
58 flux_n2 numeric(9,8) Jy Flux in N2 band digest / full
59 flux_err_n2 numeric(9,8) Jy Flux error in N2 band digest / full
60 flux_unreliability_n2 smallint --- Flux flag in N2 band. Flag indicates whether the object is blended or not as follows:
  • 0 = not be blended.
  • 1 = blended, i.e., there are multiple counterparts in the search radius.
  • NULL = no detection
 digest / full
61 flux_n3 numeric(9,8) Jy Flux in N3 band digest / full
62 flux_err_n3 numeric(9,8) Jy Flux error in N3 band digest / full
63 flux_unreliability_n3 smallint --- Flux flag in N3 band. Flag indicates whether the object is blended or not as follows:
  • 0 = not be blended.
  • 1 = blended, i.e., there are multiple counterparts in the search radius.
  • NULL = no detection
 digest / full
64 flux_n4 numeric(9,8) Jy Flux in N4 band digest / full
65 flux_err_n4 numeric(9,8) Jy Flux error in N4 band digest / full
66 flux_unreliability_n4 smallint --- Flux flag in N4 band digest / full
67 flux_s7 numeric(9,8) Jy Flux in S7 band digest / full
68 flux_err_s7 numeric(9,8) Jy Flux error in S7 band digest / full
69 flux_unreliability_s7 smallint --- Flux flag in S7 band. Flag indicates whether the object is blended or not as follows:
  • 0 = not be blended.
  • 1 = blended, i.e., there are multiple counterparts in the search radius.
  • NULL = no detection
 digest / full
70 flux_s9w numeric(9,8) Jy Flux in S9W band digest / full
71 flux_err_s9w numeric(9,8) Jy Flux error in S9W band digest / full
72 flux_unreliability_s9w smallint --- Flux flag in S9W band. Flag indicates whether the object is blended or not as follows:
  • 0 = not be blended.
  • 1 = blended, i.e., there are multiple counterparts in the search radius.
  • NULL = no detection
 digest / full
73 flux_s11 numeric(9,8) Jy Flux in S11 band digest / full
74 flux_err_s11 numeric(9,8) Jy Flux error in S11 band digest / full
75 flux_unreliability_s11 smallint --- Flux flag in S11 band. Flag indicates whether the object is blended or not as follows:
  • 0 = not be blended.
  • 1 = blended, i.e., there are multiple counterparts in the search radius.
  • NULL = no detection
 digest / full
76 flux_l15 numeric(9,8) Jy Flux in L15 band digest / full
77 flux_err_l15 numeric(9,8) Jy Flux error in L15 band digest / full
78 flux_unreliability_l15 smallint --- Flux flag in L15 band. Flag indicates whether the object is blended or not as follows:
  • 0 = not be blended.
  • 1 = blended, i.e., there are multiple counterparts in the search radius.
  • NULL = no detection
 digest / full
79 flux_l18w numeric(9,8) Jy Flux in L18W band digest / full
80 flux_err_l18w numeric(9,8) Jy Flux error in L18W band digest / full
81 flux_unreliability_l18w smallint --- Flux flag in L18W band. Flag indicates whether the object is blended or not as follows:
  • 0 = not be blended.
  • 1 = blended, i.e., there are multiple counterparts in the search radius.
  • NULL = no detection
 digest / full
82 flux_l24 numeric(9,8) Jy Flux in L24 band digest / full
83 flux_err_l24 numeric(9,8) Jy Flux error in L24 band digest / full
84 flux_unreliability_l24 smallint --- Flux flag in L24 band. Flag indicates whether the object is blended or not as follows:
  • 0 = not be blended.
  • 1 = blended, i.e., there are multiple counterparts in the search radius.
  • NULL = no detection
 digest / full
85 stellarity_index numeric(3,2) --- Stellarity from the MegaCam z' band. Stellarity information derived from MegaCam z' band catalogue. This column is available only for objects with the MegaCam z' band counterparts. digest / full
86 angular_separation numeric(3,2) arcsec Angular separation from MIR detection toground-basedcoordinate. Angular separation from MIR objects to the counterparts in the ground-based catalogue. This column is available only for objects with the single counterpart. Object with the single counterpart searched from the coordinates based on each band image, but with the multiple searched from the one based on detection image, also have no angular separation. digest / full
87 data_access_url character varying(255) URL used to access dataset digest / full

Scroll Back to Top ⏏

akari_irc_nep_wide_psc_1

  • Columns to display in the Basic Search can be chosen either "digest" or "full" in the "Display" menu.
  • (*) means that the same coordinates as specified in the Basic Search "Coordinate" are displayed in the "digest" mode. If you use TargetName, Equatorial J2000 will be displayed.
  • On SQL Search and ADQL Search, all the columns are available, including columns marked "no output" in this table.
No. Column Name type Unit Description Output
1 object_id integer --- Internal Source ID digest / full
2 object_name character varying(20) --- Source name [Jnnnnnn.nn+nnnnnn.n] digest / full
3 object_ra numeric(8,5) deg Right Ascension (J2000) .The coordinates for each source are based on N2 band astrometry. If there is no detection in the N2 image, the coordinates were derived from the shortest wavelength with an identification. digest(*) / full
4 object_dec numeric(8,5) deg Declination (J2000) .The coordinates for each source are based on N2 band astrometry. If there is no detection in the N2 image, the coordinates were derived from the shortest wavelength with an identification.
5 object_ra_b1950 numeric(8,5) Source position in Right Ascension (B1950). It is calculated from object_ra and object_dec.
6 object_dec_b1950 numeric(8,5) Source position in Declination (B1950). It is calculated from object_ra and object_dec.
7 object_ecliptic_lon numeric(8,5) Source position in Ecliptic longitude. It is calculated from object_ra and object_dec.
8 object_ecliptic_lat numeric(8,5) Source position in Ecliptic Latitude. It is calculated from object_ra and object_dec.
9 object_galactic_lon numeric(8,5) Source position in Galactic longitude. It is calculated from object_ra and object_dec.
10 object_galactic_lat numeric(8,5) Source position in Galactic Latitude. It is calculated from object_ra and object_dec.
11 flux_n2 numeric(8,7) Jy Flux in AKARI/N2 band. The total flux (i.e., FLUX_AUTO) measured by SExtractor. The flux fainter than the detection limit is replaced with Blank. Non-detection also has NULL but their flux_unreliability_n2 is Blank. digest / full
12 flux_err_n2 numeric(9,8) Jy RMSFlux error in N2 band digest / full
13 flux_unreliability_n2 smallint --- Flag for the Flux in N2 band. Photometric flag derived by SExtractor as follows:
  • 0 = no problem
  • 1 = the source has close neighbors, bright and close enough to bias the 'FLUX_AUTO' or bad pixels (about 10% of the integrated area affected)
  • 2 = the object was blended with very close neighbors
  • 3 = 1+2
  • NULL = no detected, no photometric result
 digest / full
14 flux_n3 numeric(8,7) Jy Flux in AKARI/N3 band. The total flux (i.e., FLUX_AUTO) measured by SExtractor. The flux fainter than the detection limit is replaced with '0.00e+00'. Non-detection also has NULL but their flux_unreliability_n3 is 'NULL'. digest / full
15 flux_err_n3 numeric(9,8) Jy RMSFlux error in N3 band digest / full
16 flux_unreliability_n3 smallint --- Flag for the Flux in N3 band. Photometric flag derived by SExtractor as follows:
  • 0 = no problem
  • 1 = the source has close neighbors, bright and close enough to bias the 'FLUX_AUTO' or bad pixels (about 10% of the integrated area affected)
  • 2 = the object was blended with very close neighbors
  • 3 = 1+2
  • NULL = no detected, no photometric result
 digest / full
17 flux_n4 numeric(8,7) Jy Flux in AKARI/N4 band. The total flux (i.e., FLUX_AUTO) measured by SExtractor. The flux fainter than the detection limit is replaced with '0.00e+00'. Non-detection also has NULL but their flux_unreliablility_n4 is 'NULL'. digest / full
18 flux_err_n4 numeric(9,8) Jy RMSFlux error in N4 band digest / full
19 flux_unreliability_n4 smallint --- Flag for the Flux in N4 band. Photometric flag derived by SExtractor as follows:
  • 0 = no problem
  • 1 = the source has close neighbors, bright and close enough to bias the 'FLUX_AUTO' or bad pixels (about 10% of the integrated area affected)
  • 2 = the object was blended with very close neighbors
  • 3 = 1+2
  • NULL = no detected, no photometric result
 digest / full
20 flux_s7 numeric(8,7) Jy Flux in AKARI/S7 band. The total flux (i.e., FLUX_AUTO) measured by SExtractor. The flux fainter than the detection limit is replaced with '0.00e+00'. Non-detection also has NULL but their flux_unreliablility_n7 is 'NULL'. digest / full
21 flux_err_s7 numeric(9,8) Jy RMSFlux error in S7 band digest / full
22 flux_unreliability_s7 smallint --- Flag for the Flux in S7 band. Photometric flag derived by SExtractor as follows:
  • 0 = no problem
  • 1 = the source has close neighbors, bright and close enough to bias the 'FLUX_AUTO' or bad pixels (about 10% of the integrated area affected)
  • 2 = the object was blended with very close neighbors
  • 3 = 1+2
  • NULL = no detected, no photometric result
 digest / full
23 flux_s9w numeric(8,7) Jy Flux in AKARI/S9W band. The total flux (i.e., FLUX_AUTO) measured by SExtractor. The flux fainter than the detection limit is replaced with '0.00e+00'. Non-detection also has NULL but their flux_unreliablility_s9w is 'NULL'. digest / full
24 flux_err_s9w numeric(9,8) Jy RMSFlux error in S9W band digest / full
25 flux_unreliability_s9w smallint --- Flag for the Flux in S9W band. Photometric flag derived by SExtractor as follows:
  • 0 = no problem
  • 1 = the source has close neighbors, bright and close enough to bias the 'FLUX_AUTO' or bad pixels (about 10% of the integrated area affected)
  • 2 = the object was blended with very close neighbors
  • 3 = 1+2
  • NULL = no detected, no photometric result
 digest / full
26 flux_s11 numeric(8,7) Jy Flux in AKARI/S11 band. The total flux (i.e., FLUX_AUTO) measured by SExtractor. The flux fainter than the detection limit is replaced with '0.00e+00'. Non-detection also has NULL but their flux_unreliablility_s11 is 'NULL'. digest / full
27 flux_err_s11 numeric(9,8) Jy RMSFlux error in S11 band digest / full
28 flux_unreliability_s11 smallint --- Flag for the Flux in S11 band. Photometric flag derived by SExtractor as follows:
  • 0 = no problem
  • 1 = the source has close neighbors, bright and close enough to bias the 'FLUX_AUTO' or bad pixels (about 10% of the integrated area affected)
  • 2 = the object was blended with very close neighbors
  • 3 = 1+2
  • NULL = no detected, no photometric result
 digest / full
29 flux_l15 numeric(7,6) Jy Flux in AKARI/L15 band. The total flux (i.e., FLUX_AUTO) measured by SExtractor. The flux fainter than the detection limit is replaced with '0.00e+00'. Non-detection also has NULL but their flux_unreliablility_l15 is 'NULL'. digest / full
30 flux_err_l15 numeric(8,7) Jy RMSFlux error in L15 band digest / full
31 flux_unreliability_l15 smallint --- Flag for the Flux in L15 band. Photometric flag derived by SExtractor as follows:
  • 0 = no problem
  • 1 = the source has close neighbors, bright and close enough to bias the 'FLUX_AUTO' or bad pixels (about 10% of the integrated area affected)
  • 2 = the object was blended with very close neighbors
  • 3 = 1+2
  • NULL = no detected, no photometric result
 digest / full
32 flux_l18w numeric(7,6) Jy Flux in AKARI/L18W band. The total flux (i.e., FLUX_AUTO) measured by SExtractor. The flux fainter than the detection limit is replaced with '0.00e+00'. Non-detection also has NULL but their flux_unreliablility_l18w is 'NULL'. digest / full
33 flux_err_l18w numeric(8,7) Jy RMSFlux error in L18W band digest / full
34 flux_unreliability_l18w smallint --- Flag for the Flux in L18W band. Photometric flag derived by SExtractor as follows:
  • 0 = no problem
  • 1 = the source has close neighbors, bright and close enough to bias the 'FLUX_AUTO' or bad pixels (about 10% of the integrated area affected)
  • 2 = the object was blended with very close neighbors
  • 3 = 1+2
  • NULL = no detected, no photometric result
 digest / full
35 flux_l24 numeric(7,6) Jy Flux in AKARI/L24 band. The total flux (i.e., FLUX_AUTO) measured by SExtractor. The flux fainter than the detection limit is replaced with '0.00e+00'. Non-detection also has NULL but their flux_unreliablility_l24 is 'NULL'. digest / full
36 flux_err_l24 numeric(8,7) Jy RMSFlux error in L24 band digest / full
37 flux_unreliability_l24 smallint --- Flag for the Flux in L24 band. Photometric flag derived by SExtractor as follows:
  • 0 = no problem
  • 1 = the source has close neighbors, bright and close enough to bias the 'FLUX_AUTO' or bad pixels (about 10% of the integrated area affected)
  • 2 = the object was blended with very close neighbors
  • 3 = 1+2
  • NULL = no detected, no photometric result
 digest / full
38 nir_damaged_bands character varying(8) --- Caution about the NIR bands photometry. Flag to indicate partially damaged sources in NIR bands photometry during the cosmic-ray rejection, de-MUXbleed, and etc, as follows:
  • NULL = no damage in any bands
  • N2 = in N2 band
  • N3 = in N3 band
  • N4 = in N4 band
  • multiple = in more than one band
 digest / full
39 magnitude_cfht_u_aster numeric(4,2) mag AB magnitude in CFHT/u* band digest / full
40 magnitude_err_cfht_u_aster numeric(4,2) mag AB magnitude error in CFHT/u* band digest / full
41 magnitude_cfht_g_dash numeric(4,2) mag AB magnitude in CFHT/g' band digest / full
42 magnitude_err_cfht_g_dash numeric(4,2) mag AB magnitude error in CFHT/g' band digest / full
43 magnitude_cfht_r_dash numeric(4,2) mag AB magnitude in CFHT/r' band digest / full
44 magnitude_err_cfht_r_dash numeric(4,2) mag AB magnitude error in CFHT/r' band digest / full
45 magnitude_cfht_i_dash numeric(4,2) mag AB magnitude in CFHT/i' band digest / full
46 magnitude_err_cfht_i_dash numeric(4,2) mag AB magnitude error in CFHT/i' band digest / full
47 magnitude_cfht_z_dash numeric(4,2) mag AB magnitude in CFHT/z' band digest / full
48 magnitude_err_cfht_z_dash numeric(5,2) mag AB magnitude error in CFHT/z' band digest / full
49 magnitude_maidanak_b numeric(4,2) mag AB magnitude in Maidanak/B band digest / full
50 magnitude_err_maidanak_b numeric(4,2) mag AB magnitude error in Maidanak/B band digest / full
51 magnitude_maidanak_r numeric(4,2) mag AB magnitude in Maidanak/R band digest / full
52 magnitude_err_maidanak_r numeric(4,2) mag AB magnitude error in Maidanak/R band digest / full
53 magnitude_maidanak_i numeric(4,2) mag AB magnitude in Maidanak/I band digest / full
54 magnitude_err_maidanak_i numeric(4,2) mag AB magnitude error in Maidanak/I band digest / full
55 stellarity_index character varying(8) --- Stellarity measured from the optical data (point and extended). Stellarity information provided by SExtractor with the optical data from CFHT and Maidanak. If a source has optical counterparts in both the CFHT and Maidanak data, the stellarity determined from the CFHT data is used. digest / full
56 number_of_optical_sources smallint --- Number of optical sources found within 3 arcmin digest / full
57 distance_from_nearest_optical_source numeric(3,2) arcsec Angular separation between AKARI source and the nearest optical counterpart. digest / full
58 data_access_url character varying(255) URL used to access dataset digest / full

Scroll Back to Top ⏏

akari_irc_lmc_psc_1_all, akari_irc_lmc_psc_1_sage

  • Columns to display in the Basic Search can be chosen either "digest" or "full" in the "Display" menu.
  • (*) means that the same coordinates as specified in the Basic Search "Coordinate" are displayed in the "digest" mode. If you use TargetName, Equatorial J2000 will be displayed.
  • On SQL Search and ADQL Search, all the columns are available, including columns marked "no output" in this table.
No. Column Name type Unit Description Output
1 object_id character varying(8) Internal Object ID. 56****** for Catalog and 51****** for Archive. digest / full
2 object_name character varying(29) Source identifier. The structure is an acronym of the catalog + source position in Right Ascension (J2000). Acronyms are AKARI-LMCC for Catalog and AKARI-LMCA for Archive. Format of source potision is "Jhhmmss.ss-ddmmss.s". digest / full
3 object_ra numeric(9,6) deg Source position in Right Ascension (J2000). digest (*) / full
4 object_dec numeric(9,6) deg Source position in Declination (J2000).
5 object_ra_b1950 numeric(9,6) Source position in Right Ascension (B1950). It is calculated from object_ra and object_dec.
6 object_dec_b1950 numeric(9,6) deg Source position in Declination (B1950). It is calculated from object_ra and object_dec.
7 object_ecliptic_lon numeric(9,6) deg Source position in Ecliptic longitude. It is calculated from object_ra and object_dec.
8 object_ecliptic_lat numeric(9,6) deg Source position in Ecliptic Latitude. It is calculated from object_ra and object_dec.
9 object_galactic_lon numeric(9,6) deg Source position in Galactic longitude. It is calculated from object_ra and object_dec.
10 object_galactic_lat numeric(9,6) deg Source position in Galactic Latitude. It is calculated from object_ra and object_dec.
11 band_to_determine_coordinates character varying(3) Band at which the position is derived. The band at which the coordinates are determined [N3, S7, S11, L15, L24] digest / full
12 object_coordinate_x_axis_n3 numeric(6,3) pix Pixel X-Coordinate for N3. The NIR and MIR-S channels share the same FoV by means of the beam splitter, and thus N3, NP, S7, and S11 images are taken at the same region simultaneously. L15 and L24 images of the same region are taken at a different pointing observation since their FoV is located 20' away from that of the NIR/MIR-S in the direction perpendicular to the AKARI orbit (Onaka et al. 2007). full
13 object_coordinate_y_axis_n3 numeric(6,3) pix Pixel Y-Coordinate for N3. The NIR and MIR-S channels share the same FoV by means of the beam splitter, and thus N3, NP, S7, and S11 images are taken at the same region simultaneously. L15 and L24 images of the same region are taken at a different pointing observation since their FoV is located 20' away from that of the NIR/MIR-S in the direction perpendicular to the AKARI orbit (Onaka et al. 2007). full
14 magnitude_n3 numeric(5,3) mag Magnitude in the Vega system uncorrected for extinction, for N3. digest / full
15 magnitude_error_in_calculate_n3 numeric(5,3) mag Magnitude error; photometric uncertainty from ALLSTAR for N3. full
16 magnitude_error_in_total_n3 numeric(5,3) mag Magnitude error; total photometric uncertainty for N3. Including errors in the aperture correction, read-out noise, and conversion factor. digest / full
17 chi_in_psf_fitting_n3 numeric(5,3) Chi. PSF fit parameter for N3. The parameter χ increases with the difference in shape between the source and the PSF profile. The value NULL is assigned when the aperture photometry is employed. full
18 sharpness_in_psf_fitting_n3 numeric(5,3) PSF fit parameter, Sharpness for N3. A positive (negative) sharpness indicates that the source is more (less) extended than the PSF-profile, suggesting that the source may be a galaxy, an unresolved multi-star system, a cosmic ray, or image defect. The value NULL is assigned when the aperture photometry is employed. full
19 observation_start_time_n3 timestamp without timezone UTC Observing datetime for N3 in UTC. digest / full
20 observation_start_time_mjd_n3 double precision MJD Observing datetime for N3 in MJD. full
21 observation_id_n3 character varying(9) Observation identifier. "target_id" + "-" + "observation_count_of_each_target" (all three digits with leading 0) full
22 exposure_sec_n3 numeric(6,2) sec Exposure time for N3. At each position in pointing observation, both short- and long-exposure data are taken. The net integration times for a longer-exposure image are typically 133, 147, and 147 seconds for the NIR, MIR-S, and MIR-L channels, respectively, and that for a short-exposure image is 14.0, 1.75 and 1.75 seconds, respectively. (Kato et al. 2012, AJ, 144, 179) digest / full
23 exposure_n3 numeric(6,5) ksec Exposure time for N3 in Kiro-seconds. At each position in pointing observation, both short- and long-exposure data are taken. The net integration times for a longer-exposure image are typically 133, 147, and 147 seconds for the NIR, MIR-S, and MIR-L channels, respectively, and that for a short-exposure image is 14.0, 1.75 and 1.75 seconds, respectively. (Kato et al. 2012, AJ, 144, 179) full
24 photometory_method_n3 character varying(8) Method that identifies sources in the periphery area, for N3. [aperture(=aperture photometry) or PSF(=PSF fitting)] Blank means that sources undetected in this band. full
25 is_saturated_n3 character varying(1) Saturation flag, for N3. [Y (=saturated sources or their nearby sources) or N (=unsaturated sources)] Blank means that sources undetected in this band. digest / full
26 is_affected_by_column_pulldown_n3 character varying(1) Column pulldown flag, only for N3. [Y (=sources with a possibility to be affected by column pulldown belt) or N (=sources without pulldown effects)] Blank means that sources undetected in this band. digest / full
27 is_affected_by_mux_bleed_n3 character varying(1) Mux bleed flag, only for N3. [Y (=sources affected by column mux bleed) or N (=sources without mux bleed effects)] Blank means that sources undetected in this band. digest / full
28 is_multiple_detection_n3 character varying(1) Multiple detection flag for existence of the adjacent sources, for N3. [Y (=sources with adjacent sources) or N (=sources without adjacent sources)] Blank means that sources undetected in this band. digest / full
29 number_of_matched_sources_n3_s7 smallint The number of the matched sources (MAT) between N3 and S7. digest / full
30 distance_from_the_nearest_source_n3_s7 numeric(4,2) arcsec The distance from the nearest matched source (DR) between N3 and S7. digest / full
31 object_coordinate_x_axis_s7 numeric(6,3) pix Pixel X-Coordinate for S7. The NIR and MIR-S channels share the same FoV by means of the beam splitter, and thus N3, NP, S7, and S11 images are taken at the same region simultaneously. L15 and L24 images of the same region are taken at a different pointing observation since their FoV is located 20' away from that of the NIR/MIR-S in the direction perpendicular to the AKARI orbit (Onaka et al. 2007). full
32 object_coordinate_y_axis_s7 numeric(6,3) pix Pixel Y-Coordinate for S7. The NIR and MIR-S channels share the same FoV by means of the beam splitter, and thus N3, NP, S7, and S11 images are taken at the same region simultaneously. L15 and L24 images of the same region are taken at a different pointing observation since their FoV is located 20' away from that of the NIR/MIR-S in the direction perpendicular to the AKARI orbit (Onaka et al. 2007). full
33 magnitude_s7 numeric(5,3) mag Magnitude in the Vega system uncorrected for extinction, for S7. digest / full
34 magnitude_error_in_calculate_s7 numeric(5,3) mag Magnitude error; photometric uncertainty from ALLSTAR for S7. full
35 magnitude_error_in_total_s7 numeric(5,3) mag Magnitude error; total photometric uncertainty for S7. Including errors in the aperture correction, read-out noise, and conversion factor. digest / full
36 chi_in_psf_fitting_s7 numeric(5,3) Chi. PSF fit parameter for S7. The parameter X increases with the difference in shape between the source and the PSF profile. The value NULL is assigned when the aperture photometry is employed. digest / full
37 sharpness_in_psf_fitting_s7 numeric(5,3) PSF fit parameter, Sharpness for S7. A positive (negative) sharpness indicates that the source is more (less) extended than the PSF-profile, suggesting that the source may be a galaxy, an unresolved multi-star system, a cosmic ray, or image defect. The value NULL is assigned when the aperture photometry is employed. digest / full
38 observation_start_time_s7 timestamp without timezone UTC Observing datetime for S7 in UTC. digest / full
39 observation_start_time_mjd_s7 double precision MJD Observing datetime for S7 in MJD. full
40 observation_id_s7 character varying(9) Observation identifier. "target_id" + "-" + "observation_count_of_each_target" (all three digits with leading 0) full
41 exposure_sec_s7 numeric(6,2) ksec Exposure time for S7. At each position in pointing observation, both short- and long-exposure data are taken. The net integration times for a longer-exposure image are typically 133, 147, and 147 seconds for the NIR, MIR-S, and MIR-L channels, respectively, and that for a short-exposure image is 14.0, 1.75 and 1.75 seconds, respectively. (Kato et al. 2012, AJ, 144, 179) digest / full
42 exposure_s7 numeric(6,5) ksec Exposure time for S7 in Kiro-seconds. At each position in pointing observation, both short- and long-exposure data are taken. The net integration times for a longer-exposure image are typically 133, 147, and 147 seconds for the NIR, MIR-S, and MIR-L channels, respectively, and that for a short-exposure image is 14.0, 1.75 and 1.75 seconds, respectively. (Kato et al. 2012, AJ, 144, 179) full
43 photometory_method_s7 character varying(8) Method that identifies sources in the periphery area, for S7. [aperture(=aperture photometry) or PSF(=PSF fitting)] Blank means that sources undetected in this band. full
44 is_saturated_s7 character varying(1) Saturation flag, for S7. [Y (=saturated sources or their nearby sources) or N (=unsaturated sources)] Blank means that sources undetected in this band. digest / full
45 is_affected_by_artifacts_s7 character varying(1) Artifact flag, only for S7 and S11. [Y (=sources affected by artifacts) or N(=sources without artifacts)] Blank means that sources undetected in this band. digest / full
46 is_multiple_detection_s7 character varying(1) Multiple detection flag for existence of the adjacent sources, for S7. [Y (=sources with adjacent sources) or N (=sources without adjacent sources)] Blank means that sources undetected in this band. digest / full
47 number_of_matched_sources_n3_s7_s11 smallint The number of the matched sources (MAT) between N3, S7 and S11. digest / full
48 distance_from_the_nearest_source_n3_s7_s11 numeric(4,2) arcsec The distance from the nearest matched source (DR) between N3, S7 and S11. digest / full
49 object_coordinate_x_axis_s11 numeric(6,3) pix Pixel X-Coordinate for S11. The NIR and MIR-S channels share the same FoV by means of the beam splitter, and thus N3, NP, S7, and S11 images are taken at the same region simultaneously. L15 and L24 images of the same region are taken at a different pointing observation since their FoV is located 20' away from that of the NIR/MIR-S in the direction perpendicular to the AKARI orbit (Onaka et al. 2007). full
50 object_coordinate_y_axis_s11 numeric(6,3) pix Pixel Y-Coordinate for S11. The NIR and MIR-S channels share the same FoV by means of the beam splitter, and thus N3, NP, S7, and S11 images are taken at the same region simultaneously. L15 and L24 images of the same region are taken at a different pointing observation since their FoV is located 20' away from that of the NIR/MIR-S in the direction perpendicular to the AKARI orbit (Onaka et al. 2007). full
51 magnitude_s11 numeric(5,3) mag Magnitude in the Vega system uncorrected for extinction, for S11. digest / full
52 magnitude_error_in_calculate_s11 numeric(5,3) mag Magnitude error; photometric uncertainty from ALLSTAR for S11. full
53 magnitude_error_in_total_s11 numeric(5,3) mag Magnitude error; total photometric uncertainty for S11. Including errors in the aperture correction, read-out noise, and conversion factor. digest / full
54 chi_in_psf_fitting_s11 numeric(5,3) Chi. PSF fit parameter for S11. The parameter X increases with the difference in shape between the source and the PSF profile. The value NULL is assigned when the aperture photometry is employed. digest / full
55 sharpness_in_psf_fitting_s11 numeric(5,3) PSF fit parameter, Sharpness for S11. A positive (negative) sharpness indicates that the source is more (less) extended than the PSF-profile, suggesting that the source may be a galaxy, an unresolved multi-star system, a cosmic ray, or image defect. The value NULL is assigned when the aperture photometry is employed. digest / full
56 observation_start_time_s11 timestamp without timezone UTC Observing datetime for S11 in UTC. digest / full
57 observation_start_time_mjd_s11 double precision MJD Observing datetime for S11 in MJD. full
58 observation_id_s11 character varying(9) Observation identifier. "target_id" + "-" + "observation_count_of_each_target" (all three digits with leading 0) full
59 exposure_sec_s11 numeric(6,2) sec Exposure time for S11. At each position in pointing observation, both short- and long-exposure data are taken. The net integration times for a longer-exposure image are typically 133, 147, and 147 seconds for the NIR, MIR-S, and MIR-L channels, respectively, and that for a short-exposure image is 14.0, 1.75 and 1.75 seconds, respectively. (Kato et al. 2012, AJ, 144, 179) digest / full
60 exposure_s11 numeric(6,5) ksec Exposure time for S11 in Kiro-seconds. At each position in pointing observation, both short- and long-exposure data are taken. The net integration times for a longer-exposure image are typically 133, 147, and 147 seconds for the NIR, MIR-S, and MIR-L channels, respectively, and that for a short-exposure image is 14.0, 1.75 and 1.75 seconds, respectively. (Kato et al. 2012, AJ, 144, 179) full
61 photometory_method_s11 character varying(8) Method that identifies sources in the periphery area, for S11. [aperture(=aperture photometry) or PSF(=PSF fitting)] Blank means that sources undetected in this band. full
62 is_saturated_s11 character varying(1) Saturation flag, for S11. [Y (=saturated sources or their nearby sources) or N (=unsaturated sources)] Blank means that sources undetected in this band. digest / full
63 is_affected_by_artifacts_s11 character varying(1) Artifact flag, only for S7 and S11. [Y (=sources affected by artifacts) or N(=sources without artifacts)] Blank means that sources undetected in this band. digest / full
64 is_multiple_detection_s11 character varying(1) Multiple detection flag for existence of the adjacent sources, for S11. [Y (=sources with adjacent sources) or N (=sources without adjacent sources)] Blank means that sources undetected in this band. digest / full
65 number_of_matched_sources_n3_s7_s11_l15 smallint The number of the matched sources (MAT) between N3, S7, S11 and L15. digest / full
66 distance_from_the_nearest_source_n3_s7_s11_l15 numeric(4,2) arcsec The distance from the nearest matched source (DR) between N3, S7, S11 and L15. digest / full
67 object_coordinate_x_axis_l15 numeric(6,3) pix Pixel X-Coordinate for L15. The NIR and MIR-S channels share the same FoV by means of the beam splitter, and thus N3, NP, S7, and S11 images are taken at the same region simultaneously. L15 and L24 images of the same region are taken at a different pointing observation since their FoV is located 20' away from that of the NIR/MIR-S in the direction perpendicular to the AKARI orbit (Onaka et al. 2007). full
68 object_coordinate_y_axis_l15 numeric(6,3) pix Pixel Y-Coordinate for L15. The NIR and MIR-S channels share the same FoV by means of the beam splitter, and thus N3, NP, S7, and S11 images are taken at the same region simultaneously. L15 and L24 images of the same region are taken at a different pointing observation since their FoV is located 20' away from that of the NIR/MIR-S in the direction perpendicular to the AKARI orbit (Onaka et al. 2007). full
69 magnitude_l15 numeric(5,3) mag Magnitude in the Vega system uncorrected for extinction, for L15. digest / full
70 magnitude_error_in_calculate_l15 numeric(5,3) mag Magnitude error; photometric uncertainty from ALLSTAR for L15. full
71 magnitude_error_in_total_l15 numeric(5,3) mag Magnitude error; total photometric uncertainty for L15. Including errors in the aperture correction, read-out noise, and conversion factor. digest / full
72 chi_in_psf_fitting_l15 numeric(5,3) Chi. PSF fit parameter for L15. The parameter X increases with the difference in shape between the source and the PSF profile. The value NULL is assigned when the aperture photometry is employed. digest / full
73 sharpness_in_psf_fitting_l15 numeric(5,3) PSF fit parameter, Sharpness for L15. A positive (negative) sharpness indicates that the source is more (less) extended than the PSF-profile, suggesting that the source may be a galaxy, an unresolved multi-star system, a cosmic ray, or image defect. The value NULL is assigned when the aperture photometry is employed. digest / full
74 observation_start_time_l15 timestamp without timezone UTC Observing datetime for L15 in UTC. digest / full
75 observation_start_time_mjd_ｌ15 double precision MJD Observing datetime for L15 in MJD. full
76 observation_id_l15 character varying(9) Observation identifier. "target_id" + "-" + "observation_count_of_each_target" (all three digits with leading 0) full
77 exposure_sec_l15 numeric(6,2) sec Exposure time for L15. At each position in pointing observation, both short- and long-exposure data are taken. The net integration times for a longer-exposure image are typically 133, 147, and 147 seconds for the NIR, MIR-S, and MIR-L channels, respectively, and that for a short-exposure image is 14.0, 1.75 and 1.75 seconds, respectively. (Kato et al. 2012, AJ, 144, 179) digest / full
78 exposure_l15 numeric(6,5) ksec Exposure time for L15 in Kiro-seconds. At each position in pointing observation, both short- and long-exposure data are taken. The net integration times for a longer-exposure image are typically 133, 147, and 147 seconds for the NIR, MIR-S, and MIR-L channels, respectively, and that for a short-exposure image is 14.0, 1.75 and 1.75 seconds, respectively. (Kato et al. 2012, AJ, 144, 179) full
79 photometory_method_l15 character varying(8) Method that identifies sources in the periphery area, for L15. [aperture(=aperture photometry) or PSF(=PSF fitting)] Blank means that sources undetected in this band. full
80 is_saturated_l15 character varying(1) Saturation flag, for L15. [Y (=saturated sources or their nearby sources) or N (=unsaturated sources)] Blank means that sources undetected in this band. digest / full
81 is_multiple_detection_l15 character varying(1) Multiple detection flag for existence of the adjacent sources, for L15. [Y (=sources with adjacent sources) or N (=sources without adjacent sources)] Blank means that sources undetected in this band. digest / full
82 number_of_matched_sources_n3_s7_s11_l15_l24 smallint The number of the matched sources (MAT) between N3, S7, S11, L15 and L24. digest / full
83 distance_from_the_nearest_source_n3_s7_s11_l15_l24 numeric(4,2) arcsec The distance from the nearest matched source (DR) between N3, S7, S11, L15 and L24. digest / full
84 object_coordinate_x_axis_l24 numeric(6,3) pix Pixel X-Coordinate for L24. The NIR and MIR-S channels share the same FoV by means of the beam splitter, and thus N3, NP, S7, and S11 images are taken at the same region simultaneously. L15 and L24 images of the same region are taken at a different pointing observation since their FoV is located 20' away from that of the NIR/MIR-S in the direction perpendicular to the AKARI orbit (Onaka et al. 2007). full
85 object_coordinate_y_axis_l24 numeric(6,3) pix Pixel Y-Coordinate for L24. The NIR and MIR-S channels share the same FoV by means of the beam splitter, and thus N3, NP, S7, and S11 images are taken at the same region simultaneously. L15 and L24 images of the same region are taken at a different pointing observation since their FoV is located 20' away from that of the NIR/MIR-S in the direction perpendicular to the AKARI orbit (Onaka et al. 2007). full
86 magnitude_l24 numeric(5,3) mag Magnitude in the Vega system uncorrected for extinction, for L24. digest / full
87 magnitude_error_in_calculate_l24 numeric(5,3) mag Magnitude error; photometric uncertainty from ALLSTAR for L24. full
88 magnitude_error_in_total_l24 numeric(5,3) mag Magnitude error; total photometric uncertainty for L24. Including errors in the aperture correction, read-out noise, and conversion factor. digest / full
89 chi_in_psf_fitting_l24 numeric(5,3) Chi. PSF fit parameter for L24. The parameter X increases with the difference in shape between the source and the PSF profile. The value NULL is assigned when the aperture photometry is employed. digest / full
90 sharpness_in_psf_fitting_l24 numeric(5,3) PSF fit parameter, Sharpness for L24. A positive (negative) sharpness indicates that the source is more (less) extended than the PSF-profile, suggesting that the source may be a galaxy, an unresolved multi-star system, a cosmic ray, or image defect. The value NULL is assigned when the aperture photometry is employed. digest / full
91 observation_start_time_l24 timestamp without timezone UTC Observing datetime for L24 in UTC. digest / full
92 observation_start_time_mjd_ｌ24 double precision MJD Observing datetime for L24 in MJD. full
93 observation_id_l24 character varying(9) Observation identifier. "target_id" + "-" + "observation_count_of_each_target" (all three digits with leading 0) full
94 exposure_sec_l24 numeric(6,2) sec Exposure time for L24. At each position in pointing observation, both short- and long-exposure data are taken. The net integration times for a longer-exposure image are typically 133, 147, and 147 seconds for the NIR, MIR-S, and MIR-L channels, respectively, and that for a short-exposure image is 14.0, 1.75 and 1.75 seconds, respectively. (Kato et al. 2012, AJ, 144, 179) digest / full
95 exposure_l24 numeric(6,5) ksec Exposure time for L24 in Kiro-seconds. At each position in pointing observation, both short- and long-exposure data are taken. The net integration times for a longer-exposure image are typically 133, 147, and 147 seconds for the NIR, MIR-S, and MIR-L channels, respectively, and that for a short-exposure image is 14.0, 1.75 and 1.75 seconds, respectively. (Kato et al. 2012, AJ, 144, 179) full
96 photometory_method_l24 character varying(8) Method that identifies sources in the periphery area, for L24. [aperture(=aperture photometry) or PSF(=PSF fitting)] Blank means that sources undetected in this band. full
97 is_saturatied_l24 character varying(1) Saturation flag, for L24. [Y (=saturated sources or their nearby sources) or N (=unsaturated sources)] Blank means that sources undetected in this band. digest / full
98 is_multiple_detection_l24 character varying(1) Multiple detection flag for existence of the adjacent sources, for L24. [Y (=sources with adjacent sources) or N (=sources without adjacent sources)] Blank means that sources undetected in this band. digest / full
99 data_access_url character varying(255) URL used to access dataset

Scroll Back to Top ⏏

akari_pointed_rawdata_package_info

  • Columns to display in the Basic Search can be chosen either "digest" or "full" in the "Display" menu.
  • (*) means that the same coordinates as specified in the Basic Search "Coordinate" are displayed in the "digest" mode. If you use TargetName, Equatorial J2000 will be displayed.
  • On SQL Search and ADQL Search, all the columns are available, including columns marked "no output" in this table.
No. Column Name Type Unit Description Output with Basic Search Former Column Name Former Type Former Unit
1 observation_start_time timestamp without timezone UTC Start Time of the Observation in UTC. digest / full DATE date UTC
TIME time
2 observation_start_time_mjd double precision MJD Start Time of the Observation in MJD. no output ― ― ―
3 observation_end_time timestamp without timezone UTC End Time of the Observation in UTC. This data file was integrated multiple observations and it is difficult to clearly indicate observation end time. Therefore, the same time as the observation_start_time is registered in this data item. digest / full UTC
4 observation_end_time_mjd double precision MJD End Time of the Observation in MJD. This data file was integrated multiple observations and it is difficult to clearly indicate observation end time. Therefore, the same time as the observation_start_time_mjd is registered in this data item. no output ― ― ―
5 observation_id character varying(11) The sequence number of the observation. 'observation_id' = 'target_id' + '-' + 'observation_count_of_each_target'(Add 0 to the head and align 3 digits) digest / full OBSID varchar(11)
6 target_name character varying(63) Object name digest / full OBJECT varchar(63)
7 pi_name character varying(35) PI Name (Observer's ID) full OBSERVER varchar(35)
8 proposal_code character varying(7) Proposal Code named by PI full PROPOSAL varchar(7)
9 object_ra double precision degree Target position, Right Ascenstion J2000. digest (*) / full OBJ_RA double degree
10 object_dec double precision degree Target position, Declinatoion J2000. OBJ_DEC double degree
11 object_ra_b1950 double precision degree Target position, Right Ascenstion B1950. Calculated from (object_ra, object_dec) ― ― ―
12 object_dec_b1950 double precision degree Target position, Declinatoion B1950. Calculated from (object_ra, object_dec) ― ― ―
13 object_galactic_lon double precision degree Target position, Galactic Longitude. Calculated from (object_ra, object_dec) OBJ_LII double degree
14 object_galactic_lat double precision degree Target position, Galactic Latitude. Calculated from (object_ra, object_dec) OBJ_BII double degree
15 object_ecliptic_lon double precision degree Target position, Ecliptic Longitude. Calculated from (object_ra, object_dec) OBJ_ECL_LONG double degree
16 object_ecliptic_lat double precision degree Target position, Ecriptic Latitude. Calculated from (object_ra, object_dec) OBJ_ECL_LATI double degree
17 aot_name character varying(11) Astronomical Observation Template digest / full AOT varchar(11)
18 aot_param character varying(15) AOT Parameters. Multiple parameters are connected with ';'. full AOTPARAM varchar(15)
19 aot_type character varying(15) AOT Type [ ENGINEERING, NORMAL, or SPECIAL ] full AOT_TYPE varchar(15)
20 observation_status character varying(31) Observation Status [ CRYO trouble, Data lost, IRC Det off, Observed, PV2, SH, or STT WDT error ] digest / full STATUS varchar(31)
21 observation_mode character varying(11) Observation Mode [ MAIN or PARALLEL ] full OBS_MODE varchar(11)
22 target_id bigint Target ID. 'observation_id' = 'target_id' + '-' + 'observation_count_of_each_target'(Add 0 to the head and align 3 digits) full TARGETID int(11)
23 observation_count_of_each_target bigint Ordinal number at observations for the same target. 'observation_id' = 'target_id' + '-' + 'observation_count_of_each_target'(Add 0 to the head and align 3 digits) full SUBID int(11)
24 pointing_id bigint Pointing ID full PNTNG_ID int(11)
25 remark_id character varying(31) Related remark IDs. [ 1, 2, 3, ..., 7, or combination of those connected with '/' ] full REMIDS varchar(31)
26 remark_title character varying(255) Remark Name full REMNAMES varchar(255)
27 public_date timestamp without timezone UTC Public Date full PUBLIC_DATE date UTC
28 public_date_mjd double precision MJD no output
29 data_file_create_time timestamp without timezone UTC Data package created time full PKGMTIME datetime UTC
30 data_file_size bigint MB Package File Size full PKGFSIZE int(11) Byte
31 data_access_url character varying(63) URL used to access dataset digest / full PKGPATH varchar(63)

Scroll Back to Top ⏏

Last Modified: 20 October 2020