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
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 | ― | ― | ― |
akari_fis_bsc_1
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 | ― | ― | ― |
akari_irc_psc_1
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 | ― | ― | ― |
akari_irc_nep_deep_psc_2
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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 |
akari_irc_nep_wide_psc_1
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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:
|
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 |
akari_irc_lmc_psc_1_all, akari_irc_lmc_psc_1_sage
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_l15 | 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_l24 | 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 |
akari_pointed_rawdata_package_info
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) |