[ English | Japanese ]
Searchable Data with the DARTS/Astro Query System
Schema of Tables about AKARI
akari_fis_allskymap_2_1
Descriptions of the invidual image files composing "AKARI Far-infrared All-Sky Survey Maps Version 2.1 (Public release version 1)".
| No. | Column Name | Type | Unit | Description | Former Column Name | Former Type | Former Unit |
|---|---|---|---|---|---|---|---|
| 1 | file_id | integer | ― | Data file ID | fits_id | INTEGER | ― |
| 2 | reference_lon | double precision | ― | Coordinate Longitude of the reference point | crval1 | DOUBLE | ― |
| 3 | reference_lat | double precision | ― | Coordinate Latitude of the reference point | crval2 | DOUBLE | ― |
| 4 | coordinate_system | character varying(8) | ― | Coordinate system of the data files. | ― | ― | ― |
| 5 | reference_pixel_x | double precision | ― | Pixel x coordinate of reference point | crpix1 | DOUBLE | ― |
| 6 | reference_pixel_y | double precision | ― | Pixel y coordinate of reference point | crpix2 | DOUBLE | ― |
| 7 | center_ra | double precision | degree | Image center, Right Ascenstion J2000. | 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 | band | character varying(8) | ― | Observation wavelength | band | VARCHAR(8) | ― |
| 16 | quantity_of_pixel_x | integer | ― | Number of x pixels | naxis1 | INTEGER | ― |
| 17 | quantity_of_pixel_y | integer | ― | Number of y pixels | naxis2 | INTEGER | ― |
| 18 | rotation_1_1 | double precision | ― | Rotation factor of the pixel counter electrode point near the reference point | cd1_1 | DOUBLE | ― |
| 19 | rotation_1_2 | double precision | ― | Rotation factor of the pixel counter electrode point near the reference point | cd1_2 | DOUBLE | ― |
| 20 | rotation_2_1 | double precision | ― | Rotation factor of the pixel counter electrode point near the reference point | cd2_1 | DOUBLE | ― |
| 21 | rotation_2_2 | double precision | ― | Rotation factor of the pixel counter electrode point near the reference point | cd2_2 | DOUBLE | ― |
| 22 | file_create_date | character varying(64) | UTC | Data file created time | create_date | VARCHAR(64) | UTC |
| 23 | data_access_url | character varying(255) | ― | URL to the dataset | fits_name | VARCHAR(64) | ― |
| 24 | ql_access_url | character varying(255) | ― | URL to the quick look image (Mode 90% scale, Log scale) page | ― | ― | ― |
| 25 | ql_image_url | character varying(255) | ― | URL to the quick look image (Mode 90% scale) | ― | ― | ― |
| 26 | corner1_ra | double precision | degree | Coordinate of the vertex1 of the observation field of view, Right Ascension J2000. | ― | ― | ― |
| 27 | corner1_dec | double precision | degree | Coordinate of the vertex1 of the observation field of view, Declinationn J2000. | ― | ― | ― |
| 28 | corner2_ra | double precision | degree | Coordinate of the vertex2 of the observation field of view, Right Ascension J2000. | ― | ― | ― |
| 29 | corner2_dec | double precision | degree | Coordinate of the vertex2 of the observation field of view, Declinationn J2000. | ― | ― | ― |
| 30 | corner3_ra | double precision | degree | Coordinate of the vertex3 of the observation field of view, Right Ascension J2000. | ― | ― | ― |
| 31 | corner3_dec | double precision | degree | Coordinate of the vertex3 of the observation field of view, Declinationn J2000. | ― | ― | ― |
| 32 | corner4_ra | double precision | degree | Coordinate of the vertex4 of the observation field of view, Right Ascension J2000. | ― | ― | ― |
| 33 | corner4_dec | double precision | degree | Coordinate of the vertex4 of the observation field of view, Declinationn J2000. | ― | ― | ― |
| 34 | corner1_ra_b1950 | double precision | degree | Coordinate of the vertex1 of the observation field of view, Right Ascension B1950. | ― | ― | ― |
| 35 | corner1_dec_b1950 | double precision | degree | Coordinate of the vertex1 of the observation field of view, Declinationn B1950. | ― | ― | ― |
| 36 | corner2_ra_b1950 | double precision | degree | Coordinate of the vertex2 of the observation field of view, Right Ascension B1950. | ― | ― | ― |
| 37 | corner2_dec_b1950 | double precision | degree | Coordinate of the vertex2 of the observation field of view, Declinationn B1950. | ― | ― | ― |
| 38 | corner3_ra_b1950 | double precision | degree | Coordinate of the vertex3 of the observation field of view, Right Ascension B1950. | ― | ― | ― |
| 39 | corner3_dec_b1950 | double precision | degree | Coordinate of the vertex3 of the observation field of view, Declinationn B1950. | ― | ― | ― |
| 40 | corner4_ra_b1950 | double precision | degree | Coordinate of the vertex4 of the observation field of view, Right Ascension B1950. | ― | ― | ― |
| 41 | corner4_dec_b1950 | double precision | degree | Coordinate of the vertex4 of the observation field of view, Declinationn B1950. | ― | ― | ― |
| 42 | corner1_ecliptic_lon | double precision | degree | Coordinate of the vertex1 of the observation field of view, Ecliptic Longitude. | ― | ― | ― |
| 43 | corner1_ecliptic_lat | double precision | degree | Coordinate of the vertex1 of the observation field of view, Ecliptic Latitude. | ― | ― | ― |
| 44 | corner2_ecliptic_lon | double precision | degree | Coordinate of the vertex2 of the observation field of view, Ecliptic Longitude. | ― | ― | ― |
| 45 | corner2_ecliptic_lat | double precision | degree | Coordinate of the vertex2 of the observation field of view, Ecliptic Latitude. | ― | ― | ― |
| 46 | corner3_ecliptic_lon | double precision | degree | Coordinate of the vertex3 of the observation field of view, Ecliptic Longitude. | ― | ― | ― |
| 47 | corner3_ecliptic_lat | double precision | degree | Coordinate of the vertex3 of the observation field of view, Ecliptic Latitude. | ― | ― | ― |
| 48 | corner4_ecliptic_lon | double precision | degree | Coordinate of the vertex4 of the observation field of view, Ecliptic Longitude. | ― | ― | ― |
| 49 | corner4_ecliptic_lat | double precision | degree | Coordinate of the vertex4 of the observation field of view, Ecliptic Latitude. | ― | ― | ― |
| 50 | corner1_galactic_lon | double precision | degree | Coordinate of the vertex1 of the observation field of view, Galactic Longitude. | ― | ― | ― |
| 51 | corner1_galactic_lat | double precision | degree | Coordinate of the vertex1 of the observation field of view, Galactic Latitude. | ― | ― | ― |
| 52 | corner2_galactic_lon | double precision | degree | Coordinate of the vertex2 of the observation field of view, Galactic Longitude. | ― | ― | ― |
| 53 | corner2_galactic_lat | double precision | degree | Coordinate of the vertex2 of the observation field of view, Galactic Latitude. | ― | ― | ― |
| 54 | corner3_galactic_lon | double precision | degree | Coordinate of the vertex3 of the observation field of view, Galactic Longitude. | ― | ― | ― |
| 55 | corner3_galactic_lat | double precision | degree | Coordinate of the vertex3 of the observation field of view, Galactic Latitude. | ― | ― | ― |
| 56 | corner4_galactic_lon | double precision | degree | Coordinate of the vertex4 of the observation field of view, Galactic Longitude. | ― | ― | ― |
| 57 | corner4_galactic_lat | double precision | degree | Coordinate of the vertex4 of the observation field of view, Galactic Latitude. | ― | ― | ― |
akari_irc_poi_phase1and2_1
Descriptions of the invidual image files composing "AKARI/IRC Pointed Observation Images (Phase 1&2)".
| No. | Column Name | Type | Unit | Description |
|---|---|---|---|---|
| 1 | object_id | integer | ― | Target ID. 'observation_id' = 'object_id' + '-' + 'observation_count'(Add 0 to the head and align 3 digits) |
| 2 | observation_count | integer | ― | Ordinal number at observations for the same target. 'observation_id' = 'object_id' + '-' + 'observation_count'(Add 0 to the head and align 3 digits) |
| 3 | aot_name | character varying(5) | Astronomical Observation Template | |
| 4 | aot_param | character varying(4) | AOT Parameters. Multiple parameters are connected with ';'. | |
| 5 | irc_operation_mode | character varying(4) | IRC operation mode. MAIN or PARA (Parallel). | |
| 6 | observation_start_time | timestamp without time zone | UTC | Date and Time of observation start [UTC] |
| 7 | observation_start_time_mjd | double precision | MJD | Date and Time of observation start [MJD] |
| 8 | observation_end_time | timestamp without time zone | UTC | Date and Time of observation end [UTC] |
| 9 | observation_end_time_mjd | double precision | MJD | Date and Time of observation end [MJD] |
| 10 | object_name | character varying(25) | Object Name | |
| 11 | object_ra | numeric(6,3) | degree | Right Ascension(J2000) of object position |
| 12 | object_dec | numeric(6,3) | degree | Declination(J2000) of object position |
| 13 | object_ra_b1950 | numeric(6,3) | degree | Right Ascension(B1950) of object position. Calculated from (object_ra, object_dec) |
| 14 | object_dec_b1950 | numeric(6,3) | degree | Declination(B1950) of object position. Calculated from (object_ra, object_dec) |
| 15 | object_ecliptic_lon | numeric(6,3) | degree | Ecliptic Longitude of object position. Calculated from (object_ra, object_dec) |
| 16 | object_ecliptic_lat | numeric(6,3) | degree | Ecliptic Latitude of object position. Calculated from (object_ra, object_dec) |
| 17 | object_galactic_lon | numeric(6,3) | degree | Galactic Longitude of object position. Calculated from (object_ra, object_dec) |
| 18 | object_galactic_lat | numeric(6,3) | degree | Galactic Latitude of object position. Calculated from (object_ra, object_dec) |
| 19 | is_affected_by_ghost_mir_s | character varying(1) | Warnings for MIR-S ghost. Y (data may suffer the issue) or N (data may not suffer the issue) | |
| 20 | is_affected_by_memory_effect_mir_s | character varying(1) | Warnings for MIR-S memory effect. Y (data may suffer the issue) or N (data may not suffer the issue) | |
| 21 | is_affected_by_memory_effect_mir_l | character varying(1) | Warnings for MIR-L memory effect. Y (data may suffer the issue) or N (data may not suffer the issue) | |
| 22 | quantity_of_frame_n2 | smallint | Number of all frames for N2 | |
| 23 | quantity_of_combined_frame_n2 | smallint | Number of combined frames for N2 | |
| 24 | catalogue_to_decide_position_n2 | character varying(5) | Source of WCS information. One of AOCS/2MASS/WISE/WRONG | |
| 25 | position_err_n2 | numeric(3,2) | arcsec | WCS error for N2 |
| 26 | quantity_of_object_in_n2 | integer | Number of stars in 1.5 arcsec for WCS matching for N2 | |
| 27 | center_ra_n2 | numeric(7,4) | degree | Right Ascension(J2000) at FITS center for N2 |
| 28 | center_dec_n2 | numeric(7,4) | degree | Declination(J2000) at FITS center for N2 |
| 29 | center_ra_b1950_n2 | numeric(7,4) | degree | Right Ascension(B1950) at FITS center for N2 |
| 30 | center_dec_b1950_n2 | numeric(7,4) | degree | Declination(B1950) at FITS center for N2 |
| 31 | center_ecliptic_lon_n2 | numeric(7,4) | degree | Ecliptic Longitude at FITS center for N2 |
| 32 | center_ecliptic_lat_n2 | numeric(7,4) | degree | Ecliptic Latitude at FITS center for N2 |
| 33 | center_galactic_lon_n2 | numeric(7,4) | degree | Galactic Longitude at FITS center for N2 |
| 34 | center_galactic_lat_n2 | numeric(7,4) | degree | Galactic Latitude at FITS center for N2 |
| 35 | quantity_of_frame_n3 | smallint | Number of all frames for N3 | |
| 36 | quantity_of_combined_frame_n3 | smallint | Number of combined frames for N3 | |
| 37 | catalogue_to_decide_position_n3 | character varying(5) | Source of WCS information. One of AOCS/2MASS/WISE/WRONG | |
| 38 | position_err_n3 | numeric(3,2) | arcsec | WCS error for N3 |
| 39 | quantity_of_object_in_n3 | integer | Number of stars in 1.5 arcsec for WCS matching for N3 | |
| 40 | center_ra_n3 | numeric(7,4) | degree | Right Ascension(J2000) at FITS center for N3 |
| 41 | center_dec_n3 | numeric(7,4) | degree | Declination(J2000) at FITS center for N3 |
| 42 | center_ra_b1950_n3 | numeric(7,4) | degree | Right Ascension(B1950) at FITS center for N3 |
| 43 | center_dec_b1950_n3 | numeric(7,4) | degree | Declination(B1950) at FITS center for N3 |
| 44 | center_ecliptic_lon_n3 | numeric(7,4) | degree | Ecliptic Longitude at FITS center for N3 |
| 45 | center_ecliptic_lat_n3 | numeric(7,4) | degree | Ecliptic Latitude at FITS center for N3 |
| 46 | center_galactic_lon_n3 | numeric(7,4) | degree | Galactic Longitude at FITS center for N3 |
| 47 | center_galactic_lat_n3 | numeric(7,4) | degree | Galactic Latitude at FITS center for N3 |
| 48 | quantity_of_frame_n4 | smallint | Number of all frames for N4 | |
| 49 | quantity_of_combined_frame_n4 | smallint | Number of combined frames for N4 | |
| 50 | catalogue_to_decide_position_n4 | character varying(5) | Source of WCS information. One of AOCS/2MASS/WISE/WRONG | |
| 51 | position_err_n4 | numeric(3,2) | arcsec | WCS error for N4 |
| 52 | quantity_of_object_in_n4 | integer | Number of stars in 1.5 arcsec for WCS matching for N4 | |
| 53 | center_ra_n4 | numeric(7,4) | degree | Right Ascension(J2000) at FITS center for N4 |
| 54 | center_dec_n4 | numeric(7,4) | degree | Declination(J2000) at FITS center for N4 |
| 55 | center_ra_b1950_n4 | numeric(7,4) | degree | Right Ascension(B1950) at FITS center for N4 |
| 56 | center_dec_b1950_n4 | numeric(7,4) | degree | Declination(B1950) at FITS center for N4 |
| 57 | center_ecliptic_lon_n4 | numeric(7,4) | degree | Ecliptic Longitude at FITS center for N4 |
| 58 | center_ecliptic_lat_n4 | numeric(7,4) | degree | Ecliptic Latitude at FITS center for N4 |
| 59 | center_galactic_lon_n4 | numeric(7,4) | degree | Galactic Longitude at FITS center for N4 |
| 60 | center_galactic_lat_n4 | numeric(7,4) | degree | Galactic Latitude at FITS center for N4 |
| 61 | quantity_of_frame_s7 | smallint | Number of all frames for S7 | |
| 62 | quantity_of_combined_frame_s7 | smallint | Number of combined frames for S7 | |
| 63 | catalogue_to_decide_position_s7 | character varying(5) | Source of WCS information. One of AOCS/2MASS/WISE/WRONG | |
| 64 | position_err_s7 | numeric(3,2) | arcsec | WCS error for S7 |
| 65 | quantity_of_object_in_s7 | integer | Number of stars in 1.5 arcsec for WCS matching for S7 | |
| 66 | center_ra_s7 | numeric(7,4) | degree | Right Ascension(J2000) at FITS center for S7 |
| 67 | center_dec_s7 | numeric(7,4) | degree | Declination(J2000) at FITS center for S7 |
| 68 | center_ra_b1950_s7 | numeric(7,4) | degree | Right Ascension(B1950) at FITS center for S7 |
| 69 | center_dec_b1950_s7 | numeric(7,4) | degree | Declination(B1950) at FITS center for S7 |
| 70 | center_ecliptic_lon_s7 | numeric(7,4) | degree | Ecliptic Longitude at FITS center for S7 |
| 71 | center_ecliptic_lat_s7 | numeric(7,4) | degree | Ecliptic Latitude at FITS center for S7 |
| 72 | center_galactic_lon_s7 | numeric(7,4) | degree | Galactic Longitude at FITS center for S7 |
| 73 | center_galactic_lat_s7 | numeric(7,4) | degree | Galactic Latitude at FITS center for S7 |
| 74 | quantity_of_frame_s9w | smallint | Number of all frames for S9W | |
| 75 | quantity_of_combined_frame_s9w | smallint | Number of combined frames for S9W | |
| 76 | catalogue_to_decide_position_s9w | character varying(5) | Source of WCS information. One of AOCS/2MASS/WISE/WRONG | |
| 77 | position_err_s9w | numeric(3,2) | arcsec | WCS error for S9W |
| 78 | quantity_of_object_in_s9w | integer | Number of stars in 1.5 arcsec for WCS matching for S9W | |
| 79 | center_ra_s9w | numeric(7,4) | degree | Right Ascension(J2000) at FITS center for S9W |
| 80 | center_dec_s9w | numeric(7,4) | degree | Declination(J2000) at FITS center for S9W |
| 81 | center_ra_b1950_s9w | numeric(7,4) | degree | Right Ascension(B1950) at FITS center for S9W |
| 82 | center_dec_b1950_s9w | numeric(7,4) | degree | Declination(B1950) at FITS center for S9W |
| 83 | center_ecliptic_lon_s9w | numeric(7,4) | degree | Ecliptic Longitude at FITS center for S9W |
| 84 | center_ecliptic_lat_s9w | numeric(7,4) | degree | Ecliptic Latitude at FITS center for S9W |
| 85 | center_galactic_lon_s9w | numeric(7,4) | degree | Galactic Longitude at FITS center for S9W |
| 86 | center_galactic_lat_s9w | numeric(7,4) | degree | Galactic Latitude at FITS center for S9W |
| 87 | quantity_of_frame_s11 | smallint | Number of all frames for S11 | |
| 88 | quantity_of_combined_frame_s11 | smallint | Number of combined frames for S11 | |
| 89 | catalogue_to_decide_position_s11 | character varying(5) | Source of WCS information. One of AOCS/2MASS/WISE/WRONG | |
| 90 | position_err_s11 | numeric(3,2) | arcsec | WCS error for S11 |
| 91 | quantity_of_object_in_s11 | integer | Number of stars in 1.5 arcsec for WCS matching for S11 | |
| 92 | center_ra_s11 | numeric(7,4) | degree | Right Ascension(J2000) at FITS center for S11 |
| 93 | center_dec_s11 | numeric(7,4) | degree | Declination(J2000) at FITS center for S11 |
| 94 | center_ra_b1950_s11 | numeric(7,4) | degree | Right Ascension(B1950) at FITS center for S11 |
| 95 | center_dec_b1950_s11 | numeric(7,4) | degree | Declination(B1950) at FITS center for S11 |
| 96 | center_ecliptic_lon_s11 | numeric(7,4) | degree | Ecliptic Longitude at FITS center for S11 |
| 97 | center_ecliptic_lat_s11 | numeric(7,4) | degree | Ecliptic Latitude at FITS center for S11 |
| 98 | center_galactic_lon_s11 | numeric(7,4) | degree | Galactic Longitude at FITS center for S11 |
| 99 | center_galactic_lat_s11 | numeric(7,4) | degree | Galactic Latitude at FITS center for S11 |
| 100 | quantity_of_frame_l15 | smallint | Number of all frames for L15 | |
| 101 | quantity_of_combined_frame_l15 | smallint | Number of combined frames for L15 | |
| 102 | catalogue_to_decide_position_l15 | character varying(5) | Source of WCS information. One of AOCS/2MASS/WISE/WRONG | |
| 103 | position_err_l15 | numeric(3,2) | arcsec | WCS error for L15 |
| 104 | quantity_of_object_in_l15 | integer | Number of stars in 1.5 arcsec for WCS matching for L15 | |
| 105 | center_ra_l15 | numeric(7,4) | degree | Right Ascension(J2000) at FITS center for L15 |
| 106 | center_dec_l15 | numeric(7,4) | degree | Declination(J2000) at FITS center for L15 |
| 107 | center_ra_b1950_l15 | numeric(7,4) | degree | Right Ascension(B1950) at FITS center for L15 |
| 108 | center_dec_b1950_l15 | numeric(7,4) | degree | Declination(B1950) at FITS center for L15 |
| 109 | center_ecliptic_lon_l15 | numeric(7,4) | degree | Ecliptic Longitude at FITS center for L15 |
| 110 | center_ecliptic_lat_l15 | numeric(7,4) | degree | Ecliptic Latitude at FITS center for L15 |
| 111 | center_galactic_lon_l15 | numeric(7,4) | degree | Galactic Longitude at FITS center for L15 |
| 112 | center_galactic_lat_l15 | numeric(7,4) | degree | Galactic Latitude at FITS center for L15 |
| 113 | frame_shift_method_l15 | character varying(7) | Image shift type used for MIR-L stacking. COADD or LusingS | |
| 114 | quantity_of_frame_l18w | smallint | Number of all frames for L18W | |
| 115 | quantity_of_combined_frame_l18w | smallint | Number of combined frames for L18W | |
| 116 | catalogue_to_decide_position_l18w | character varying(5) | Source of WCS information. One of AOCS/2MASS/WISE/WRONG | |
| 117 | position_err_l18w | numeric(3,2) | arcsec | WCS error for L18W |
| 118 | quantity_of_object_in_l18w | integer | Number of stars in 1.5 arcsec for WCS matching for L18W | |
| 119 | center_ra_l18w | numeric(7,4) | degree | Right Ascension(J2000) at FITS center for L18W |
| 120 | center_dec_l18w | numeric(7,4) | degree | Declination(J2000) at FITS center for L18W |
| 121 | center_ra_b1950_l18w | numeric(7,4) | degree | Right Ascension(B1950) at FITS center for L18W |
| 122 | center_dec_b1950_l18w | numeric(7,4) | degree | Declination(B1950) at FITS center for L18W |
| 123 | center_ecliptic_lon_l18w | numeric(7,4) | degree | Ecliptic Longitude at FITS center for L18W |
| 124 | center_ecliptic_lat_l18w | numeric(7,4) | degree | Ecliptic Latitude at FITS center for L18W |
| 125 | center_galactic_lon_l18w | numeric(7,4) | degree | Galactic Longitude at FITS center for L18W |
| 126 | center_galactic_lat_l18w | numeric(7,4) | degree | Galactic Latitude at FITS center for L18W |
| 127 | frame_shift_method_l18w | character varying(7) | Image shift type used for MIR-L stacking. COADD or LusingS | |
| 128 | quantity_of_frame_l24 | smallint | Number of all frames for L24 | |
| 129 | quantity_of_combined_frame_l24 | smallint | Number of combined frames for L24 | |
| 130 | catalogue_to_decide_position_l24 | character varying(5) | Source of WCS information. One of AOCS/2MASS/WISE/WRONG | |
| 131 | position_err_l24 | numeric(3,2) | arcsec | WCS error for L24 |
| 132 | quantity_of_object_in_l24 | integer | Number of stars in 1.5 arcsec for WCS matching for L24 | |
| 133 | center_ra_l24 | numeric(7,4) | degree | Right Ascension(J2000) at FITS center for L24 |
| 134 | center_dec_l24 | numeric(7,4) | degree | Declination(J2000) at FITS center for L24 |
| 135 | center_ra_b1950_l24 | numeric(7,4) | degree | Right Ascension(B1950) at FITS center for L24 |
| 136 | center_dec_b1950_l24 | numeric(7,4) | degree | Declination(B1950) at FITS center for L24 |
| 137 | center_ecliptic_lon_l24 | numeric(7,4) | degree | Ecliptic Longitude at FITS center for L24 |
| 138 | center_ecliptic_lat_l24 | numeric(7,4) | degree | Ecliptic Latitude at FITS center for L24 |
| 139 | center_galactic_lon_l24 | numeric(7,4) | degree | Galactic Longitude at FITS center for L24 |
| 140 | center_galactic_lat_l24 | numeric(7,4) | degree | Galactic Latitude at FITS center for L24 |
| 141 | frame_shift_method_l24 | character varying(7) | Image shift type used for MIR-L stacking. COADD or LusingS | |
| 142 | data_access_url | character varying(255) | URL to access dataset | |
| 143 | band_of_thumbnail_image | character varying(4) | Band name of the thumbnail image | |
| 144 | ql_image_url | character varying(255) | URL used to access dataset | |
| 145 | ql_access_url | character varying(255) | URL to access quick look page | |
| 146 | instrument_of_fov | character varying(9) | Instrument whose corner coordinates are registered in this data | |
| 147 | corner1_ra | numeric(8,5) | degree | Coordinate of the vertex1 of the observation field of view, Right Ascension J2000. |
| 148 | coner1_dec | numeric(8,5) | degree | Coordinate of the vertex1 of the observation field of view, Declinationn J2000. |
| 149 | corner2_ra | numeric(8,5) | degree | Coordinate of the vertex2 of the observation field of view, Right Ascension J2000. |
| 150 | corner2_dec | numeric(8,5) | degree | Coordinate of the vertex2 of the observation field of view, Declinationn J2000. |
| 151 | corner3_ra | numeric(8,5) | degree | Coordinate of the vertex3 of the observation field of view, Right Ascension J2000. |
| 152 | corner3_dec | numeric(8,5) | degree | Coordinate of the vertex3 of the observation field of view, Declinationn J2000. |
| 153 | corner4_ra | numeric(8,5) | degree | Coordinate of the vertex4 of the observation field of view, Right Ascension J2000. |
| 154 | corner4_dec | numeric(8,5) | degree | Coordinate of the vertex4 of the observation field of view, Declinationn J2000. |
| 155 | corner1_ra_b1950 | numeric(8,5) | degree | Coordinate of the vertex1 of the observation field of view, Right Ascension B1950. |
| 156 | corner1_dec_b1950 | numeric(8,5) | degree | Coordinate of the vertex1 of the observation field of view, Declinationn B1950. |
| 157 | corner2_ra_b1950 | numeric(8,5) | degree | Coordinate of the vertex2 of the observation field of view, Right Ascension B1950. |
| 158 | corner2_dec_b1950 | numeric(8,5) | degree | Coordinate of the vertex2 of the observation field of view, Declinationn B1950. |
| 159 | corner3_ra_b1950 | numeric(8,5) | degree | Coordinate of the vertex3 of the observation field of view, Right Ascension B1950. |
| 160 | corner3_dec_b1950 | numeric(8,5) | degree | Coordinate of the vertex3 of the observation field of view, Declinationn B1950. |
| 161 | corner4_ra_b1950 | numeric(8,5) | degree | Coordinate of the vertex4 of the observation field of view, Right Ascension B1950. |
| 162 | corner4_dec_b1950 | numeric(8,5) | degree | Coordinate of the vertex4 of the observation field of view, Declinationn B1950. |
| 163 | corner1_ecliptic_lon | numeric(8,5) | degree | Coordinate of the vertex1 of the observation field of view, Ecliptic Longitude. |
| 164 | corner1_ecliptic_lat | numeric(8,5) | degree | Coordinate of the vertex1 of the observation field of view, Ecliptic Latitude. |
| 165 | corner2_ecliptic_lon | numeric(8,5) | degree | Coordinate of the vertex2 of the observation field of view, Ecliptic Longitude. |
| 166 | corner2_ecliptic_lat | numeric(8,5) | degree | Coordinate of the vertex2 of the observation field of view, Ecliptic Latitude. |
| 167 | corner3_ecliptic_lon | numeric(8,5) | degree | Coordinate of the vertex3 of the observation field of view, Ecliptic Longitude. |
| 168 | corner3_ecliptic_lat | numeric(8,5) | degree | Coordinate of the vertex3 of the observation field of view, Ecliptic Latitude. |
| 169 | corner4_ecliptic_lon | numeric(8,5) | degree | Coordinate of the vertex4 of the observation field of view, Ecliptic Longitude. |
| 170 | corner4_ecliptic_lat | numeric(8,5) | degree | Coordinate of the vertex4 of the observation field of view, Ecliptic Latitude. |
| 171 | corner1_galactic_lon | numeric(8,5) | degree | Coordinate of the vertex1 of the observation field of view, Galactic Longitude. |
| 172 | corner1_galactic_lat | numeric(8,5) | degree | Coordinate of the vertex1 of the observation field of view, Galactic Latitude. |
| 173 | corner2_galactic_lon | numeric(8,5) | degree | Coordinate of the vertex2 of the observation field of view, Galactic Longitude. |
| 174 | corner2_galactic_lat | numeric(8,5) | degree | Coordinate of the vertex2 of the observation field of view, Galactic Latitude. |
| 175 | corner3_galactic_lon | numeric(8,5) | degree | Coordinate of the vertex3 of the observation field of view, Galactic Longitude. |
| 176 | corner3_galactic_lat | numeric(8,5) | degree | Coordinate of the vertex3 of the observation field of view, Galactic Latitude. |
| 177 | corner4_galactic_lon | numeric(8,5) | degree | Coordinate of the vertex4 of the observation field of view, Galactic Longitude. |
| 178 | corner4_galactic_lat | numeric(8,5) | degree | Coordinate of the vertex4 of the observation field of view, Galactic Latitude. |
akari_fis_bsc_1
"AKARI FIS All-Sky Survey Bright Source Catalogue Version 1.0".
| No. | Column Name | Type | Unit | Description | 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.
|
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. | objName | CHAR(14) | ― |
| 3 | object_ra | double precision | degree | J2000 Right Ascension of the source position. | ra | FLOAT8 | degree |
| 4 | object_dec | double precision | degree | J2000 Declination of the source position. | dec | FLOAT8 | degree |
| 5 | object_ra_b1950 | double precision | degree | Right Ascension (B1950) | ra1950 | FLOAT8 | degree |
| 6 | object_dec_b1950 | double precision | degree | Declination (B1950) | dec1950 | FLOAT8 | degree |
| 7 | object_ecliptic_lon | double precision | degree | Ecliptic longitude | lambda | FLOAT8 | degree |
| 8 | object_ecliptic_lat | double precision | degree | Ecliptic latitude | beta | FLOAT8 | degree |
| 9 | object_galactic_lon | double precision | degree | Galactic longitude | l | FLOAT8 | degree |
| 10 | object_galactic_lat | double precision | degree | Galactic latitude | b | FLOAT8 | degree |
| 11 | object_x | double precision | ― | Unit vector for ra+dec | cx | FLOAT8 | ― |
| 12 | object_y | double precision | ― | Unit vector for ra+dec | cy | FLOAT8 | ― |
| 13 | object_z | double precision | ― | Unit vector for ra+dec | cz | FLOAT8 | ― |
| 14 | position_err_on_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 . | posErrMj | FLOAT4 | arcsec |
| 15 | position_err_on_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 . | posErrMi | FLOAT4 | arcsec |
| 16 | position_err_on_roll_angle | double precision | degree | 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 . | posErrPA | FLOAT4 | degree |
| 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. |
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. |
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. |
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. |
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 quantity_of_scan_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. |
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 quantity_of_scan_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. |
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 quantity_of_scan_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. |
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 quantity_of_scan_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. |
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_flag_65) 1: The source is not confirmed 0: Not observed (no scan data available) |
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_flag_90) 1: The source is not confirmed 0: Not observed (no scan data available) |
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_flag_140) 1: The source is not confirmed 0: Not observed (no scan data available) |
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_flag_160) 1: The source is not confirmed 0: Not observed (no scan data available) |
fQual_160 | INT2 | ― |
| 29 | data_condition_flag_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).
|
flags_65 | INT2 | ― |
| 30 | data_condition_flag_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).
|
flags_90 | INT2 | ― |
| 31 | data_condition_flag_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).
|
flags_140 | INT2 | ― |
| 32 | data_condition_flag_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).
|
flags_160 | INT2 | ― |
| 33 | quantity_of_scan_with_evidence_65 | smallint | ― | Number of scans on which the source is properly detected with logEvidence larger than the threshold. | nScanC_65 | INT2 | ― |
| 34 | quantity_of_scan_with_evidence_90 | smallint | ― | Number of scans on which the source is properly detected with logEvidence larger than the threshold. | nScanC_90 | INT2 | ― |
| 35 | quantity_of_scan_with_evidence_140 | smallint | ― | Number of scans on which the source is properly detected with logEvidence larger than the threshold. | nScanC_140 | INT2 | ― |
| 36 | quantity_of_scan_with_evidence_160 | smallint | ― | Number of scans on which the source is properly detected with logEvidence larger than the threshold. | nScanC_160 | INT2 | ― |
| 37 | quantity_of_scan_65 | smallint | ― | Total number of scans that passed on the source (that possibly observed the source) | nScanP_65 | INT2 | ― |
| 38 | quantity_of_scan_90 | smallint | ― | Total number of scans that passed on the source (that possibly observed the source) | nScanP_90 | INT2 | ― |
| 39 | quantity_of_scan_140 | smallint | ― | Total number of scans that passed on the source (that possibly observed the source) | nScanP_140 | INT2 | ― |
| 40 | quantity_of_scan_160 | smallint | ― | Total number of scans that passed on the source (that possibly observed the source) | 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. |
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. |
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. |
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. |
mConf_160 | INT2 | ― |
| 45 | quantity_of_object_in_5arcmin | 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. | nDens | INT2 | ― |
| 46 | data_access_url | character varying(255) | ― | URL to the dataset | ― | ― | ― |
akari_irc_psc_1
"AKARI IRC All-Sky Survey Point Source Catalogue Version 1.0".
| No. | Column Name | Type | Unit | Description | 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.
|
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. | objName | CHAR(14) | ― |
| 3 | object_ra | double precision | degree | J2000 Right Ascension of the source position. | ra | FLOAT8 | degree |
| 4 | object_dec | double precision | degree | J2000 Declination of the source position. | dec | FLOAT8 | degree |
| object_ra_b1950 | double precision | degree | Right Ascension (B1950) | ra1950 | FLOAT8 | degree | |
| 6 | object_dec_b1950 | double precision | degree | Declination (B1950) | dec1950 | FLOAT8 | degree |
| 7 | object_ecliptic_lon | double precision | degree | Ecliptic longitude | lambda | FLOAT8 | degree |
| 8 | object_ecliptic_lat | double precision | degree | Ecliptic latitude | beta | FLOAT8 | degree |
| 9 | object_galactic_lon | double precision | degree | Galactic longitude | l | FLOAT8 | degree |
| 10 | object_galactic_lat | double precision | degree | Galactic latitude | b | FLOAT8 | degree |
| 11 | object_x | double precision | ― | Unit vector for ra+dec | cx | FLOAT8 | ― |
| 12 | object_y | double precision | ― | Unit vector for ra+dec | cy | FLOAT8 | ― |
| 13 | object_z | double precision | ― | Unit vector for ra+dec | cz | FLOAT8 | ― |
| 14 | position_err_on_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_on_major_axis is calculated from the distance of the two events and position_err_on_minor_axis is set to the same as position_err_on_major_axis. | posErrMj | double precision | arcsec |
| 15 | position_err_on_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_on_major_axis is calculated from the distance of the two events and position_err_on_minor_axis is set to the same as position_err_on_major_axis. | posErrMi | FLOAT4 | arcsec |
| 16 | position_err_on_roll_angle | double precision | degree | 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_on_major_axis is calculated from the distance of the two events and position_err_on_minor_axis is set to the same as position_err_on_major_axis. | posErrPA | FLOAT4 | degree |
| 17 | flux_density_09 | double precision | Jy | Flux density of the source in S9W in Jansky. | flux_09 | FLOAT4 | Jy |
| 18 | flux_density_18 | double precision | Jy | Flux density of the source in L18W in Jansky. | flux_18 | FLOAT4 | Jy |
| 19 | flux_err_09 | double precision | Jy | Flux error in S9W. | fErr_09 | FLOAT4 | Jy |
| 20 | flux_err_18 | double precision | Jy | Flux error in L18W. | 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. | 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. | fQual_18 | INT2 | ― |
| 23 | data_condition_flag_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. |
flags_09 | INT2 | ― |
| 24 | data_condition_flag_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. |
flags_18 | INT2 | ― |
| 25 | quantity_of_scan_with_evidence_09 | smallint | ― | Number of scans on which the source is detected. Normally, quantity_of_scan_with_evidence is less or equal to quantity_of_scan. In some exceptional case, resultant position of the source drops out from the image stripe boundary and quantity_of_scan_with_evidence is larger than quantity_of_scan. | nScanC_09 | INT2 | ― |
| 26 | quantity_of_scan_with_evidence_18 | smallint | ― | Number of scans on which the source is detected. Normally, quantity_of_scan_with_evidence is less or equal to quantity_of_scan. In some exceptional case, resultant position of the source drops out from the image stripe boundary and quantity_of_scan_with_evidence is larger than quantity_of_scan. | nScanC_18 | INT2 | ― |
| 27 | quantity_of_scan_09 | smallint | ― | The number of times the source position has been scanned during the survey. | nScanP_09 | INT2 | ― |
| 28 | quantity_of_scan_18 | smallint | ― | The number of times the source position has been scanned during the survey. | nScanP_18 | INT2 | ― |
| 29 | month_confirmation_flag_09 | smallint | ― | 1 is month confirmed and 0 is not. Inverted value of LSB of data_condition_flag_09 | mConf_09 | INT2 | ― |
| 30 | month_confirmation_flag_18 | smallint | ― | 1 is month confirmed and 0 is not. Inverted value of LSB of data_condition_flag_18 | mConf_18 | INT2 | ― |
| 31 | quantity_of_object_in_45arcsec_09 | smallint | ― | The number of sources in 45 arcsec radius. | nDens_09 | INT2 | ― |
| 32 | quantity_of_object_in_45arcsec_18 | smallint | ― | The number of sources in 45 arcsec radius. | nDens_18 | INT2 | ― |
| 33 | is_extended_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]. | extended_09 | INT2 | ― |
| 34 | is_extended_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]. | extended_18 | INT2 | ― |
| 35 | spread_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. | meanAB_09 | FLOAT4 | ― |
| 36 | spread_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. | meanAB_18 | FLOAT4 | ― |
| 37 | quantity_of_observation_to_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. quantity_of_observation_to_decide_position = quantity_of_scan_with_evidence_09 for quantity_of_scan_with_evidence_09 ≥ 2 quantity_of_observation_to_decide_position = quantity_of_scan_with_evidence_18 for quantity_of_scan_with_evidence_09 < 2 |
nDataPos | INT2 | ― |
| 38 | quantity_of_observation_to_measure_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. | nData_09 | INT2 | ― |
| 39 | quantity_of_observation_to_measure_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. | nData_18 | INT2 | ― |
| 40 | data_access_url | character varying(255) | ― | URL to the dataset | ― | ― | ― |
akari_irc_nep_deep_psc_2
"AKARI NEP-Deep Mid-Infrared Source Catalogue Version 2".
| No. | Column Name | type | Unit | Description |
|---|---|---|---|---|
| 1 | object_id | integer | ― | Source ID |
| 2 | object_name | character varying(19) | ― | Source name [Jnnnnnn.nn+nnnnnn.n] |
| 3 | object_ra | numeric(8,5) | degree | 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. |
| 4 | object_dec | numeric(8,5) | degree | 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) | degree | Source position in Right Ascension (B1950). It is calculated from object_ra and object_dec. |
| 6 | object_dec_b1950 | numeric(8,5) | degree | Source position in Declination (B1950). It is calculated from object_ra and object_dec. |
| 7 | object_ecliptic_lon | numeric(8,5) | degree | Source position in Ecliptic longitude. It is calculated from object_ra and object_dec. |
| 8 | object_ecliptic_lat | numeric(8,5) | degree | Source position in Ecliptic Latitude. It is calculated from object_ra and object_dec. |
| 9 | object_galactic_lon | numeric(8,5) | degree | Source position in Galactic longitude. It is calculated from object_ra and object_dec. |
| 10 | object_galactic_lat | numeric(8,5) | degree | 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. |
| 12 | object_id_in_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) |
| 13 | object_id_in_akari_mir | 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. |
| 14 | object_ra_in_akari_mir | numeric(8,5) | degree | 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). |
| 15 | object_dec_in_akari_mir | numeric(7,5) | degree | 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). |
| 16 | magnitude_cfht_megacam_u_aster | numeric(4,2) | mag | u* magnitude [CFHT/MegaCam] |
| 17 | magnitude_err_cfht_megacam_u_aster | numeric(3,2) | mag | u* magnitude error |
| 18 | magnitude_flg_cfht_megacam_u_aster | smallint | ― | u* magnitude flag. Flag is from the ground-based catalogue as follows:
|
| 19 | magnitude_cfht_megacam_g_dash | numeric(4,2) | mag | g' magnitude [CFHT/MegaCam] |
| 20 | magnitude_err_cfht_megacam_g_dash | numeric(3,2) | mag | g' magnitude error |
| 21 | magnitude_flg_cfht_megacam_g_dash | smallint | ― | g' magnitude flag. Flag is from the ground-based catalogue as follows:
|
| 22 | magnitude_cfht_megacam_r_dash | numeric(4,2) | mag | r' magnitude [CFHT/MegaCam] |
| 23 | magnitude_err_cfht_megacam_r_dash | numeric(3,2) | mag | r' magnitude error |
| 24 | magnitude_flg_cfht_megacam_r_dash | smallint | ― | r' magnitude flag. Flag is from the ground-based catalogue as follows:
|
| 25 | magnitude_cfht_megacam_i_dash | numeric(4,2) | mag | i' magnitude [CFHT/MegaCam] |
| 26 | magnitude_err_cfht_megacam_i_dash | numeric(3,2) | mag | i' magnitude error |
| 27 | magnitude_flg_cfht_megacam_i_dash | smallint | ― | i' magnitude flag. Flag is from the ground-based catalogue as follows:
|
| 28 | magnitude_cfht_megacam_z_dash | numeric(4,2) | mag | z' magnitude [CFHT/MegaCam] |
| 29 | magnitude_err_cfht_megacam_z_dash | numeric(3,2) | mag | z' magnitude error |
| 30 | magnitude_flg_cfht_megacam_z_dash | smallint | ― | z' magnitude flag . Flag is from the ground-based catalogue as follows:
|
| 31 | magnitude_cfht_wircam_y | numeric(4,2) | mag | Y magnitude [CFHT/WIRCam] |
| 32 | magnitude_err_cfht_wircam_y | numeric(3,2) | mag | Y magnitude error |
| 33 | magnitude_flg_cfht_wircam_y | smallint | ― | Y magnitude flag. Flag is from the ground-based catalogue as follows:
|
| 34 | magnitude_cfht_wircam_j | numeric(4,2) | mag | J magnitude [CFHT/WIRCam] |
| 35 | magnitude_err_cfht_wircam_j | numeric(3,2) | mag | J magnitude error |
| 36 | magnitude_flg_cfht_wircam_j | smallint | ― | J magnitude flag. Flag is from the ground-based catalogue as follows:
|
| 37 | magnitude_cfht_wircam_ks | numeric(4,2) | mag | Ks magnitude [CFHT/WIRCam] |
| 38 | magnitude_err_cfht_wircam_ks | numeric(3,2) | mag | Ks magnitude error |
| 39 | magnitude_flg_cfht_wircam_ks | smallint | ― | Ks magnitude flag. Flag is from the ground-based catalogue as follows:
|
| 40 | magnitude_subaru_scam_b | numeric(4,2) | mag | B magnitude [Subaru/S-Cam] |
| 41 | magnitude_err_subaru_scam_b | numeric(5,2) | mag | B magnitude error. |
| 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. |
| 43 | magnitude_subaru_scam_v | numeric(4,2) | mag | V magnitude [Subaru/S-Cam]. |
| 44 | magnitude_err_subaru_scam_v | numeric(4,2) | mag | V magnitude error. |
| 45 | magnitude_flg_subaru_scam_v | smallint | ― | V magnitude flag. S-cam catalogue is created using SExtractor's dual mode, based on z' band. |
| 46 | magnitude_subaru_scam_rs | numeric(4,2) | mag | Rs magnitude [Subaru/S-Cam]. |
| 47 | magnitude_err_subaru_scam_rs | numeric(3,2) | mag | Rs magnitude error. |
| 48 | magnitude_flg_subaru_scam_rs | smallint | ― | Rs magnitude flag. S-cam catalogue is created using SExtractor's dual mode, based on z' band. |
| 49 | magnitude_subaru_scam_i_dash | numeric(4,2) | mag | i' magnitude [Subaru/S-Cam] . |
| 50 | magnitude_err_subaru_scam_i_dash | numeric(3,2) | mag | i' magnitude error. |
| 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. |
| 52 | magnitude_subaru_scam_z_dash | numeric(4,2) | mag | z' magnitude [Subaru/S-Cam]. |
| 53 | magnitude_err_subaru_scam_z_dash | numeric(3,2) | mag | z' magnitude error. |
| 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. |
| 55 | magnitude_subaru_scam_nb711 | numeric(4,2) | mag | NB711 mag. [Subaru/S-Cam]. |
| 56 | magnitude_err_subaru_scam_nb711 | numeric(3,2) | mag | NB711 mag. error . |
| 57 | magnitude_flg_subaru_scam_nb711 | smallint | ― | NB711 mag. flag. S-cam catalogue is created using SExtractor's dual mode, based on z' band. |
| 58 | flux_density_n2 | numeric(9,8) | Jy | Flux in N2 band |
| 59 | flux_err_n2 | numeric(9,8) | Jy | Flux error in N2 band |
| 60 | flux_unreliability_n2 | smallint | ― | Flux flag in N2 band. Flag indicates whether the object is blended or not as follows:
|
| 61 | flux_density_n3 | numeric(9,8) | Jy | Flux in N3 band |
| 62 | flux_err_n3 | numeric(9,8) | Jy | Flux error in N3 band |
| 63 | flux_unreliability_n3 | smallint | ― | Flux flag in N3 band. Flag indicates whether the object is blended or not as follows:
|
| 64 | flux_density_n4 | numeric(9,8) | Jy | Flux in N4 band |
| 65 | flux_err_n4 | numeric(9,8) | Jy | Flux error in N4 band |
| 66 | flux_unreliability_n4 | smallint | ― | Flux flag in N4 band |
| 67 | flux_density_s7 | numeric(9,8) | Jy | Flux in S7 band |
| 68 | flux_err_s7 | numeric(9,8) | Jy | Flux error in S7 band |
| 69 | flux_unreliability_s7 | smallint | ― | Flux flag in S7 band. Flag indicates whether the object is blended or not as follows:
|
| 70 | flux_density_s9w | numeric(9,8) | Jy | Flux in S9W band |
| 71 | flux_err_s9w | numeric(9,8) | Jy | Flux error in S9W band |
| 72 | flux_unreliability_s9w | smallint | ― | Flux flag in S9W band. Flag indicates whether the object is blended or not as follows:
|
| 73 | flux_density_s11 | numeric(9,8) | Jy | Flux in S11 band |
| 74 | flux_err_s11 | numeric(9,8) | Jy | Flux error in S11 band |
| 75 | flux_unreliability_s11 | smallint | ― | Flux flag in S11 band. Flag indicates whether the object is blended or not as follows:
|
| 76 | flux_density_l15 | numeric(9,8) | Jy | Flux in L15 band |
| 77 | flux_err_l15 | numeric(9,8) | Jy | Flux error in L15 band |
| 78 | flux_unreliability_l15 | smallint | ― | Flux flag in L15 band. Flag indicates whether the object is blended or not as follows:
|
| 79 | flux_density_l18w | numeric(9,8) | Jy | Flux in L18W band |
| 80 | flux_err_l18w | numeric(9,8) | Jy | Flux error in L18W band |
| 81 | flux_unreliability_l18w | smallint | ― | Flux flag in L18W band. Flag indicates whether the object is blended or not as follows:
|
| 82 | flux_density_l24 | numeric(9,8) | Jy | Flux in L24 band |
| 83 | flux_err_l24 | numeric(9,8) | Jy | Flux error in L24 band |
| 84 | flux_unreliability_l24 | smallint | ― | Flux flag in L24 band. Flag indicates whether the object is blended or not as follows:
|
| 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. |
| 86 | distance_from_counterpart | 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. |
| 87 | data_access_url | character varying(255) | URL to the dataset |
akari_irc_nep_wide_psc_1
"AKARI NEP-Wide IR Source Catalogue Version 1".
| No. | Column Name | type | Unit | Description |
|---|---|---|---|---|
| 1 | object_id | integer | ― | Internal Source ID |
| 2 | object_name | character varying(20) | ― | Source name [Jnnnnnn.nn+nnnnnn.n] |
| 3 | object_ra | numeric(8,5) | degree | 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. |
| 4 | object_dec | numeric(8,5) | degree | 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) | degree | Source position in Right Ascension (B1950). It is calculated from object_ra and object_dec. |
| 6 | object_dec_b1950 | numeric(8,5) | degree | Source position in Declination (B1950). It is calculated from object_ra and object_dec. |
| 7 | object_ecliptic_lon | numeric(8,5) | degree | Source position in Ecliptic longitude. It is calculated from object_ra and object_dec. |
| 8 | object_ecliptic_lat | numeric(8,5) | degree | Source position in Ecliptic Latitude. It is calculated from object_ra and object_dec. |
| 9 | object_galactic_lon | numeric(8,5) | degree | Source position in Galactic longitude. It is calculated from object_ra and object_dec. |
| 10 | object_galactic_lat | numeric(8,5) | degree | Source position in Galactic Latitude. It is calculated from object_ra and object_dec. |
| 11 | flux_density_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. |
| 12 | flux_err_n2 | numeric(9,8) | Jy | RMSFlux error in N2 band |
| 13 | flux_unreliability_n2 | smallint | ― | Flag for the Flux in N2 band. Photometric flag derived by SExtractor as follows:
|
| 14 | flux_density_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'. |
| 15 | flux_err_n3 | numeric(9,8) | Jy | RMSFlux error in N3 band |
| 16 | flux_unreliability_n3 | smallint | ― | Flag for the Flux in N3 band. Photometric flag derived by SExtractor as follows:
|
| 17 | flux_density_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'. |
| 18 | flux_err_n4 | numeric(9,8) | Jy | RMSFlux error in N4 band |
| 19 | flux_unreliability_n4 | smallint | ― | Flag for the Flux in N4 band. Photometric flag derived by SExtractor as follows:
|
| 20 | flux_density_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'. |
| 21 | flux_err_s7 | numeric(9,8) | Jy | RMSFlux error in S7 band |
| 22 | flux_unreliability_s7 | smallint | ― | Flag for the Flux in S7 band. Photometric flag derived by SExtractor as follows:
|
| 23 | flux_density_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'. |
| 24 | flux_err_s9w | numeric(9,8) | Jy | RMSFlux error in S9W band |
| 25 | flux_unreliability_s9w | smallint | ― | Flag for the Flux in S9W band. Photometric flag derived by SExtractor as follows:
|
| 26 | flux_density_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'. |
| 27 | flux_err_s11 | numeric(9,8) | Jy | RMSFlux error in S11 band |
| 28 | flux_unreliability_s11 | smallint | ― | Flag for the Flux in S11 band. Photometric flag derived by SExtractor as follows:
|
| 29 | flux_density_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'. |
| 30 | flux_err_l15 | numeric(8,7) | Jy | RMSFlux error in L15 band |
| 31 | flux_unreliability_l15 | smallint | ― | Flag for the Flux in L15 band. Photometric flag derived by SExtractor as follows:
|
| 32 | flux_density_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'. |
| 33 | flux_err_l18w | numeric(8,7) | Jy | RMSFlux error in L18W band |
| 34 | flux_unreliability_l18w | smallint | ― | Flag for the Flux in L18W band. Photometric flag derived by SExtractor as follows:
|
| 35 | flux_density_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'. |
| 36 | flux_err_l24 | numeric(8,7) | Jy | RMSFlux error in L24 band |
| 37 | flux_unreliability_l24 | smallint | ― | Flag for the Flux in L24 band. Photometric flag derived by SExtractor as follows:
|
| 38 | damaged_band_nir | 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:
|
| 39 | magnitude_cfht_u_aster | numeric(4,2) | mag | Flux in CFHT/u* band in ABmag |
| 40 | magnitude_err_cfht_u_aster | numeric(4,2) | mag | Flux error in u* band |
| 41 | magnitude_cfht_g_dash | numeric(4,2) | mag | Flux in CFHT/g' band in ABmag |
| 42 | magnitude_err_cfht_g_dash | numeric(4,2) | mag | Flux error in g' band |
| 43 | magnitude_cfht_r_dash | numeric(4,2) | mag | Flux in CFHT/r' band in ABmag |
| 44 | magnitude_err_cfht_r_dash | numeric(4,2) | mag | Flux error in r' band |
| 45 | magnitude_cfht_i_dash | numeric(4,2) | mag | Flux in CFHT/i' band in ABmag |
| 46 | magnitude_err_cfht_i_dash | numeric(4,2) | mag | Flux error in i' band |
| 47 | magnitude_cfht_z_dash | numeric(4,2) | mag | Flux in CFHT/z' band in ABmag |
| 48 | magnitude_err_cfht_z_dash | numeric(5,2) | mag | Flux error in z' band |
| 49 | magnitude_maidanak_b | numeric(4,2) | mag | Flux in Maidanak/B band in ABmag |
| 50 | magnitude_err_maidanak_b | numeric(4,2) | mag | Flux error in B band |
| 51 | magnitude_maidanak_r | numeric(4,2) | mag | Flux in Maidanak/R band in ABmag |
| 52 | magnitude_err_maidanak_r | numeric(4,2) | mag | Flux error in R band |
| 53 | magnitude_maidanak_i | numeric(4,2) | mag | Flux in Maidanak/I band in ABmag |
| 54 | magnitude_err_maidanak_i | numeric(4,2) | mag | Flux error in I band |
| 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. |
| 56 | quantity_of_object_in_3arcsec | smallint | ― | Number of optical sources found within 3 arcsec |
| 57 | distance_from_counterpart | numeric(3,2) | arcsec | Angular separation between AKARI source and the nearest optical counterpart. |
| 58 | data_access_url | character varying(255) | URL to the dataset |
akari_irc_lmc_psc_1_all, akari_irc_lmc_psc_1_sage
"AKARI-LMC
Point Source Catalogue Version 1".
The table "akari_irc_lmc_psc_1_all" contains all the detected sources
by "AKARI" observations, named "Archive" by the author.
The table "akari_lmc_psc_1_sage" is subset catalogue,
including only the sources that have counterparts in the
"Spitzer SAGE point-source catalog". It is named "Catalog" by the author.
Both tables have the same column structure.
| No. | Column Name | type | Unit | Description | |
|---|---|---|---|---|---|
| 1 | object_id | character varying(8) | Internal Object ID. 56****** for Catalog and 51****** for Archive. | ||
| 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". | ||
| 3 | object_ra | numeric(9,6) | degree | Source position in Right Ascension (J2000). | |
| 4 | object_dec | numeric(9,6) | degree | 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) | degree | Source position in Declination (B1950). It is calculated from object_ra and object_dec. | |
| 7 | object_ecliptic_lon | numeric(9,6) | degree | Source position in Ecliptic longitude. It is calculated from object_ra and object_dec. | |
| 8 | object_ecliptic_lat | numeric(9,6) | degree | Source position in Ecliptic Latitude. It is calculated from object_ra and object_dec. | |
| 9 | object_galactic_lon | numeric(9,6) | degree | Source position in Galactic longitude. It is calculated from object_ra and object_dec. | |
| 10 | object_galactic_lat | numeric(9,6) | degree | Source position in Galactic Latitude. It is calculated from object_ra and object_dec. | |
| 11 | band_to_decide_position | character varying(3) | Band at which the position is derived. The band at which the coordinates are determined [N3, S7, S11, L15, L24] | ||
| 12 | object_pixel_x_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). | |
| 13 | object_pixcel_y_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). | |
| 14 | magnitude_n3 | numeric(5,3) | mag | Magnitude in the Vega system uncorrected for extinction, for N3. | |
| 15 | magnitude_calculate_err_n3 | numeric(5,3) | mag | Magnitude error; photometric uncertainty from ALLSTAR for N3. | |
| 16 | magnitude_total_err_n3 | numeric(5,3) | mag | Magnitude error; total photometric uncertainty for N3. Including errors in the aperture correction, read-out noise, and conversion factor. | |
| 17 | chi_in_psf_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. | ||
| 18 | sharpness_in_psf_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. | ||
| 19 | observation_start_time_n3 | timestamp without timezone | UTC | Observing datetime for N3 in UTC. | |
| 20 | observation_start_time_mjd_n3 | double precision | MJD | Observing datetime for N3 in MJD. | |
| 21 | observation_id_n3 | character varying(9) | Observation identifier. "object_id" + "-" + "observation_count" (all three digits with leading 0) | ||
| 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) | |
| 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) | |
| 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. | ||
| 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. | ||
| 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. | ||
| 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. | ||
| 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. | ||
| 29 | quantity_of_object_in_3arcsec_between_n3_s7 | smallint | The number of the matched sources (MAT) between N3 and S7. | ||
| 30 | distance_from_nearest_object_between_n3_s7 | numeric(4,2) | arcsec | The distance from the nearest matched source (DR) between N3 and S7. | |
| 31 | object_pixel_x_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). | |
| 32 | object_pixel_y_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). | |
| 33 | magnitude_s7 | numeric(5,3) | mag | Magnitude in the Vega system uncorrected for extinction, for S7. | |
| 34 | magnitude_calculate_err_s7 | numeric(5,3) | mag | Magnitude error; photometric uncertainty from ALLSTAR for S7. | |
| 35 | magnitude_total_err_s7 | numeric(5,3) | mag | Magnitude error; total photometric uncertainty for S7. Including errors in the aperture correction, read-out noise, and conversion factor. | |
| 36 | chi_in_psf_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. | ||
| 37 | sharpness_in_psf_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. | ||
| 38 | observation_start_time_s7 | timestamp without timezone | UTC | Observing datetime for S7 in UTC. | |
| 39 | observation_start_time_mjd_s7 | double precision | MJD | Observing datetime for S7 in MJD. | |
| 40 | observation_id_s7 | character varying(9) | Observation identifier. "object_id" + "-" + "observation_count" (all three digits with leading 0) | ||
| 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) | |
| 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) | |
| 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. | ||
| 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. | ||
| 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. | ||
| 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. | ||
| 47 | quantity_of_object_in_3arcsec_between_n3_s7_s11 | smallint | The number of the matched sources (MAT) between N3, S7 and S11. | ||
| 48 | distance_from_nearest_object_between_n3_s7_s11 | numeric(4,2) | arcsec | The distance from the nearest matched source (DR) between N3, S7 and S11. | |
| 49 | object_pixel_x_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). | |
| 50 | object_pixel_y_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). | |
| 51 | magnitude_s11 | numeric(5,3) | mag | Magnitude in the Vega system uncorrected for extinction, for S11. | |
| 52 | magnitude_calculate_err_s11 | numeric(5,3) | mag | Magnitude error; photometric uncertainty from ALLSTAR for S11. | |
| 53 | magnitude_total_err_s11 | numeric(5,3) | mag | Magnitude error; total photometric uncertainty for S11. Including errors in the aperture correction, read-out noise, and conversion factor. | |
| 54 | chi_in_psf_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. | ||
| 55 | sharpness_in_psf_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. | ||
| 56 | observation_start_time_s11 | timestamp without timezone | UTC | Observing datetime for S11 in UTC. | |
| 57 | observation_start_time_mjd_s11 | double precision | MJD | Observing datetime for S11 in MJD. | |
| 58 | observation_id_s11 | character varying(9) | Observation identifier. "object_id" + "-" + "observation_count" (all three digits with leading 0) | ||
| 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) | |
| 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) | |
| 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. | ||
| 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. | ||
| 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. | ||
| 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. | ||
| 65 | quantity_of_object_in_5arcsec_between_n3_s7_s11_l15 | smallint | The number of the matched sources (MAT) between N3, S7, S11 and L15. | ||
| 66 | distance_from_nearest_object_between_n3_s7_s11_l15 | numeric(4,2) | arcsec | The distance from the nearest matched source (DR) between N3, S7, S11 and L15. | |
| 67 | object_pixel_x_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). | |
| 68 | object_pixel_y_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). | |
| 69 | magnitude_l15 | numeric(5,3) | mag | Magnitude in the Vega system uncorrected for extinction, for L15. | |
| 70 | magnitude_calculate_err_l15 | numeric(5,3) | mag | Magnitude error; photometric uncertainty from ALLSTAR for L15. | |
| 71 | magnitude_total_err_l15 | numeric(5,3) | mag | Magnitude error; total photometric uncertainty for L15. Including errors in the aperture correction, read-out noise, and conversion factor. | |
| 72 | chi_in_psf_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. | ||
| 73 | sharpness_in_psf_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. | ||
| 74 | observation_start_time_l15 | timestamp without timezone | UTC | Observing datetime for L15 in UTC. | |
| 75 | observation_start_time_mjd_ｌ15 | double precision | MJD | Observing datetime for L15 in MJD. | |
| 76 | observation_id_l15 | character varying(9) | Observation identifier. "object_id" + "-" + "observation_count" (all three digits with leading 0) | ||
| 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) | |
| 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) | |
| 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. | ||
| 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. | ||
| 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. | ||
| 82 | quantity_of_object_in_5arcsec_between_n3_s7_s11_l15_l24 | smallint | The number of the matched sources (MAT) between N3, S7, S11, L15 and L24. | ||
| 83 | distance_from_nearest_object_between_n3_s7_s11_l15_l24 | numeric(4,2) | arcsec | The distance from the nearest matched source (DR) between N3, S7, S11, L15 and L24. | |
| 84 | object_pixel_x_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). | |
| 85 | object_pixel_y_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). | |
| 86 | magnitude_l24 | numeric(5,3) | mag | Magnitude in the Vega system uncorrected for extinction, for L24. | |
| 87 | magnitude_calculate_err_l24 | numeric(5,3) | mag | Magnitude error; photometric uncertainty from ALLSTAR for L24. | |
| 88 | magnitude_total_err_l24 | numeric(5,3) | mag | Magnitude error; total photometric uncertainty for L24. Including errors in the aperture correction, read-out noise, and conversion factor. | |
| 89 | chi_in_psf_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. | ||
| 90 | sharpness_in_psf_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. | ||
| 91 | observation_start_time_l24 | timestamp without timezone | UTC | Observing datetime for L24 in UTC. | |
| 92 | observation_start_time_mjd_ｌ24 | double precision | MJD | Observing datetime for L24 in MJD. | |
| 93 | observation_id_l24 | character varying(9) | Observation identifier. "object_id" + "-" + "observation_count" (all three digits with leading 0) | ||
| 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) | |
| 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) | |
| 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. | ||
| 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. | ||
| 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. | ||
| 99 | data_access_url | character varying(255) | URL to the dataset |
akari_irc_acua_psc_1
"Asteroid catalog using AKARI (AcuA)".
| No. | Column Name | Type | Unit | Description |
|---|---|---|---|---|
| 1 | minor_planet_number | integer | Asteroid's number | |
| 2 | object_name | character varying(18) | Asteroid's name | |
| 3 | provisional_designation | character varying(10) | Asteroid's provisional designation | |
| 4 | magunitude | numeric(4,2) | mag | Absolute magnitude |
| 5 | slope_parameter | numeric(4,2) | Slope parameter | |
| 6 | quantity_of_detection | smallint | Number of detections by AKARI | |
| 7 | diameter | numeric(6,2) | km | Mean diameter |
| 8 | diameter_err | numeric(4,2) | km | Uncertainty in diameter |
| 9 | albedo | numeric(4,3) | Mean geometric albedo | |
| 10 | albedo_err | numeric(4,3) | Uncertainty in albedo | |
| 11 | data_access_url | character varying(255) | URL to the dataset |
akari_irc_acua_iss_psc_1
"The Asteroid Catalog Using AKARI IRC Slow-Scan Observation".
| No. | Column Name | Type | Unit | Description |
|---|---|---|---|---|
| 1 | minor_planet_number | integer | Asteroid's number | |
| 2 | object_name | character varying(18) | Asteroid's name | |
| 3 | provisional_designation | character varying(10) | Asteroid's provisional designation | |
| 4 | magunitude | numeric(4,2) | mag | Absolute magnitude |
| 5 | slope_parameter | numeric(4,2) | Slope parameter | |
| 6 | quantity_of_detection | smallint | Number of detections by AKARI | |
| 7 | diameter | numeric(6,2) | km | Mean diameter |
| 8 | diameter_err | numeric(4,2) | km | Uncertainty in diameter |
| 9 | albedo | numeric(4,3) | Mean geometric albedo | |
| 10 | albedo_err | numeric(4,3) | Uncertainty in albedo | |
| 11 | data_access_url | character varying(255) | URL to the dataset |
akari_irc_astflux_psc_1
"AKARI Asteroid Flux Catalog Ver.1".
| No. | Column Name | Type | Unit | Description |
|---|---|---|---|---|
| 1 | minor_planet_number | integer | Asteroid's number | |
| 2 | object_name | character varying(16) | Asteroid's name | |
| 3 | provisional_designation | character varying(10) | Asteroid's provisional designation | |
| 4 | observation_start_time | timestamp without time zone | UTC | Observation start datetime [UTC] |
| 5 | observation_start_time_mjd | double precision | MJD | Observation start datetime [MJD] |
| 6 | object_ra | numeric(9,6) | deg | Source position in Right Ascension (J2000). |
| 7 | object_dec | numeric(9,6) | deg | Source position in Declination (J2000). |
| 8 | object_ra_b1950 | numeric(9,6) | deg | Source position in Right Ascension (B1950). It is calculated from object_ra and object_dec. |
| 9 | object_dec_b1950 | numeric(9,6) | deg | Source position in Declination (B1950). It is calculated from object_ra and object_dec. |
| 10 | object_ecliptic_lon | numeric(9,6) | deg | Source position in Ecliptic longitude. It is calculated from object_ra and object_dec. |
| 11 | object_ecliptic_lat | numeric(9,6) | deg | Source position in Ecliptic Latitude. It is calculated from object_ra and object_dec. |
| 12 | object_galactic_lon | numeric(9,6) | deg | Source position in Galactic longitude. It is calculated from object_ra and object_dec. |
| 13 | object_galactic_lat | numeric(9,6) | deg | Source position in Galactic Latitude. It is calculated from object_ra and object_dec. |
| 14 | flux_density_09 | numeric(9,6) | Jy | 9 μm flux density |
| 15 | flux_density_18 | numeric(9,6) | Jy | 18 μm flux density |
| 16 | flux_err_09 | numeric(8,6) | Jy | Error of flux_density_09_jy |
| 17 | flux_err_18 | numeric(8,6) | Jy | Error of flux_density_18_jy |
| 18 | flux_density_09_color_corrected | numeric(9,6) | Jy | Color-corrected flux density on 9 μm |
| 19 | flux_density_18_color_corretced | numeric(9,6) | Jy | Color-corrected flux density on 18 μm |
| 20 | flux_err_09_color_corrected | numeric(8,6) | Jy | Color-corrected 9μm flux density uncertainty [Jy]. To obtain color-corrected monochromatic flux density, color corrections were applied which is expressed as a polynomial function of the heliocentric distance of the object. See Usui et al. (2011) for details. |
| 21 | flux_err_18_color_corrected | numeric(8,6) | Jy | Color-corrected 18μm flux density uncertainty[Jy] To obtain color-corrected monochromatic flux density, color corrections were applied which is expressed as a polynomial function of the heliocentric distance of the object. See Usui et al. (2011) for details. |
| 22 | band | smallint | μm | Observed band |
| 23 | heliocentric_distance | numeric(7,6) | AU | Heliocentric distance |
| 24 | akari_centric_distance | numeric(7,6) | AU | "AKARI-centric" distance |
| 25 | phase_angle | numeric(4,2) | degree | Phase angle (Sun-Target-Observer angle) |
| 26 | elongation_angle | numeric(4,2) | degree | Elongation angle (Sun-Observer-Target angle) |
| 27 | aot_name | character varying(6) | Astronomical Observation Template | |
| 28 | paper_access_url | character varying(255) | Reference URL | |
| 29 | data_access_url | character varying(255) | URL to the dataset |
akari_irc_acua_spectrum_1
"AKARI Near Infrared Asteroid Spectral Catalog Version 1".
| No. | Column Name | type | Unit | Description |
|---|---|---|---|---|
| 1 | minor_planet_number | character varying(4) | ― | Asteroid's number |
| 2 | object_name | character varying(17) | ― | Asteroid's name |
| 3 | observation_id | character varying(11) | ― | Observation ID |
| 4 | observation_start_time | timestamp without time zone | ― | Observation datetime (UT) |
| 5 | observation_start_time_mjd | double precision | ― | Observation datetime (MJD) |
| 6 | object_ra | numeric(9,6) | degree | Source position in Right Ascension (J2000). |
| 7 | object_dec | numeric(9,6) | degree | Source position in Declination (J2000). |
| 8 | object_ra_b1950 | numeric(9,6) | degree | Source position in Right Ascension (B1950). It is calculated from object_ra and object_dec. |
| 9 | object_dec_b1950 | numeric(9,6) | degree | Source position in Declination (B1950). It is calculated from object_ra and object_dec. |
| 10 | object_ecliptic_lon | numeric(9,6) | degree | Source position in Ecliptic longitude. It is calculated from object_ra and object_dec. |
| 11 | object_ecliptic_lat | numeric(9,6) | degree | Source position in Ecliptic Latitude. It is calculated from object_ra and object_dec. |
| 12 | object_galactic_lon | numeric(9,6) | degree | Source position in Galactic longitude. It is calculated from object_ra and object_dec. |
| 13 | object_galactic_lat | numeric(9,6) | degree | Source position in Galactic Latitude. It is calculated from object_ra and object_dec. |
| 14 | data_access_url | character varying(255) | ― | URL to the dataset |
| 15 | ql_access_url | character varying(255) | ― | URL used to spectra text |
akari_irc_slitless_mir_spectrum_1
"AKARI/IRC MIR-S slit-less spectroscopic catalogue".
| No. | Column Name | type | Unit | Description |
|---|---|---|---|---|
| 1 | serial_number | character varying(3) | ― | Serial Number |
| 2 | observation_id | character varying(11) | ― | The sequence number of the observation. 'observation_id' = 'object_id' + '-' + 'observation_count'(Add 0 to the head and align 3 digits) |
| 3 | object_id_in_observation | character varying(3) | ― | Source ID defined in each observation |
| 4 | exposure_mode | character varying(1) | ― | source is detected in long (L) or short (S) exposure image. |
| 5 | object_id | character varying(19) | ― | Object name in the 9 µm point source catalogue, "the AKARI MIR-S slit-less PSC ver. 1.0". |
| 6 | spectrum_quality | character varying(2) | ― | Quality flag of the spectrum [S, A, B1, B2]. See Yamagishi et al., 2019,Yamagishi et al., 2019 Fig2. |
| 7 | object_ra | numeric(8,5) | degree | Object position, Right Ascension (J2000) in ”the AKARI MIR-S slit-less PSC ver. 1.0” |
| 8 | object_dec | numeric(8,5) | degree | Object position, Declination (J2000) in the AKARI MIR-S slit-less PSC ver. 1.0 |
| 9 | object_ra_b1950 | numeric(8,5) | degree | Object position, Right Ascension (B1950) in the AKARI MIR-S slit-less PSC ver. 1.0. Calculated from object_ra, object_dec. |
| 10 | object_dec_b1950 | numeric(8,5) | degree | Object position, Declination (B1950) in the AKARI MIR-S slit-less PSC ver. 1.0. Calculated from object_ra, object_dec. |
| 11 | object_ecliptic_lon | numeric(8,5) | degree | Object position, Ecliptic Longitude in the AKARI MIR-S slit-less PSC ver. 1.0. Calculated from object_ra, object_dec. |
| 12 | object_ecliptic_lat | numeric(8,5) | degree | Object position, Ecliptic Latitude in the AKARI MIR-S slit-less PSC ver. 1.0. Calculated from object_ra, object_dec. |
| 13 | object_galactic_lon | numeric(8,5) | degree | Object position, Galactic Longitude in the AKARI MIR-S slit-less PSC ver. 1.0. Calculated from object_ra, object_dec. |
| 14 | object_galactic_lat | numeric(8,5) | degree | Object position, Galactic Latitude in the AKARI MIR-S slit-less PSC ver. 1.0. Calculated from object_ra, object_dec. |
| 15 | flux_density_09_mjy | double precision | mJy | Photometric flux density at 9 micron (Flux_ape) retrieved from the
"AKARI MIR-S slit-less PSC ver.1.0" 9 µm flux measured with the aperture photometry for each reference image |
| 16 | flux_density_09 | double precision | Jy | Photometric flux density at 9 micron [Jy](Flux_ape) retrieved from the
"AKARI MIR-S slit-less PSC ver.1.0" 9 µm flux measured with the aperture photometry for each reference image |
| 17 | flux_err_09_mjy | double precision | mJy | Error of flux_density_09_mjy. Error of F assuming the calibration error of 6% (Tanabé et al. 2008) |
| 18 | flux_err_09 | double precision | Jy | Error of flux_density_09_jy. Error of F assuming the calibration error of 6% (Tanabé et al. 2008) |
| 19 | calibration_factor_sg1 | numeric(4,3) | ― | Absolute flux calibration factor applied for the toolkit-output SG1 spectrum. |
| 20 | calibration_factor_err_sg1 | numeric(4,3) | ― | Error of calibration_factor_sg1 |
| 21 | calibration_factor_sg2 | numeric(4,3) | ― | Absolute flux calibration factor applied for the toolkit-output SG2 spectrum. |
| 22 | calibration_factor_err_sg2 | numeric(4,3) | ― | Error of calibration_factor_sg2 |
| 23 | observation_start_time | timestamp without time zone | UTC | Observation start datetime [UTC] |
| 24 | observation_start_time_mjd | double precision | MJD | Observation start datetime [MJD] |
| 25 | data_access_url | character varying(255) | ― | URL to the dataset |
| 26 | ql_access_url | character varying(255) | ― | URL of summary and quick look page. |
| 27 | ql_image_url | character varying(255) | ― | URL of quick look image. |
akari_irc_slitless_mir_psc_1
9 µm point source catalogue, generated as a by-product of "AKARI/IRC MIR-S slit-less spectroscopic catalogue".
| No. | Column Name | type | Unit | Description |
|---|---|---|---|---|
| 1 | object_id | character varying(19) | ― | Object ID in this catalogue. |
| 2 | object_ra | numeric(8,5) | degree | Object position, Right Ascension (J2000) |
| 3 | object_dec | numeric(8,5) | degree | Object position, Declination (J2000) |
| 4 | object_ra_b1950 | numeric(11,8) | degree | Object position, Right Ascension (B1950). Calculated from object_ra, object_dec. |
| 5 | object_dec_b1950 | numeric(11,8) | degree | Object position, Declination (B1950). Calculated from object_ra, object_dec. |
| 6 | object_ecliptic_lon | numeric(8,5) | degree | Object position, Ecliptic Longitude. Calculated from object_ra, object_dec. |
| 7 | object_ecliptic_lat | numeric(8,5) | degree | Object position, Ecliptic Latitude. Calculated from object_ra, object_dec. |
| 8 | object_galactic_lon | numeric(8,5) | degree | Object position, Galactic Longitude. Calculated from object_ra, object_dec. |
| 9 | object_galactic_lat | numeric(8,5) | degree | Object position, Galactic Latitude. Calculated from object_ra, object_dec. |
| 10 | flux_density_09_ujy | double precision | µJy | Flux density measured by aperture photometry [µJy] |
| 11 | flux_density_09 | double precision | Jy | Flux density measured by aperture photometry [Jy] |
| 12 | flux_stat_err_09_ujy | double precision | µJy | Statistical error of flux_density_09_ujy [µJy] |
| 13 | flux_stat_err_09 | double precision | Jy | Statistical error of flux_density_09_ujy [Jy] |
| 14 | flux_systematic_err_09_ujy | double precision | µJy | Systematic calibration error of flux_density_09_ujy [µJy] |
| 15 | flux_systematic_err_09 | double precision | Jy | Systematic calibration error of flux_density_09_ujy [Jy] |
| 16 | flux_density_09_in_psf_ujy | double precision | µJy | Flux density measured by PSF photometry [µJy] |
| 17 | flux_density_09_in_psf | double precision | Jy | Flux density measured by PSF photometry [Jy] |
| 18 | flux_stat_err_09_in_psf_ujy | double precision | µJy | Statistical error of flux_density_09_in_psf_ujy [µJy] |
| 19 | flux_stat_err_09_in_psf | double precision | Jy | Statistical error of flux_density_09_in_psf_ujy [Jy] |
| 20 | flux_systematic_err_09_in_psf_ujy | double precision | µJy | Systematic calibration error of flux_density_09_in_psf_ujy [µJy] |
| 21 | flux_systematic_err_09_in_psf | double precision | Jy | Systematic calibration error of flux_density_09_in_psf_ujy [Jy] |
| 22 | quantity_of_detection | smallint | ― | Number of detections |
| 23 | quantity_of_object_in_3arcsec | smallint | ― | Number of nearby objects within a radius of 1 FWHM (3."0) |
| 24 | quantity_of_object_in_23arcsec | smallint | ― | Number of nearby objects within a radius of 20 pixels (23."4) |
| 25 | object_id_in_twomass | character varying(19) | ― | Designation of 2MASS PSC source |
| 26 | object_id_in_wise | character varying(19) | ― | Designation of WISE PSC source |
| 27 | is_available_slitless_mir_spectrum | character varying(1) | ― | Availability of MIR-S slit-less spectrum. [Y=available N=unavailable] |
| 28 | data_access_url | character varying(255) | ― | URL to the dataset |
akari_irc_gal_pn_spectrum_1
"AKARI/IRC NIR Spectral Atlas of Galactic Planetary Nebulae".
| No. | Column Name | type | Unit | Description | |
|---|---|---|---|---|---|
| 1 | object_id | character varying(10) | ― | Source ID in PNG format | |
| 2 | object_id_in_akari | character varying(7) | ― | Target ID | |
| 3 | object_ra_hms | character varying(10) | hh:mm:ss.s | Source position in Right Ascension J2000 (hh:mm:ss.s). | |
| 4 | object_dec_dms | character varying(11) | ±dd:mm:ss.s | Source position in Declination J2000 (±dd:mm:ss.s). | |
| 5 | object_ra | numeric(9,6) | degree | Source position in Right Ascension J2000 (deg). This is calculated from object_ra_hms and object_dec_dms. | |
| 6 | object_dec | numeric(9,6) | degree | Source position in Declination J2000 (deg). This is calculated from object_ra_hms and object_dec_dms. | |
| 7 | object_ra_b1950 | numeric(9,6) | degree | Source position in Right Ascension B1950 (deg). This is calculated from object_ra and object_dec. | |
| 8 | object_dec_b1950 | numeric(9,6) | degree | Source position in Declination B1950 (deg). This is calculated from object_ra and object_dec. | |
| 9 | object_ecliptic_lon | numeric(9,6) | degree | Source position in Ecliptic longitude (deg). This is calculated from object_ra and object_dec. | |
| 10 | object_ecliptic_lat | numeric(9,6) | degree | Source position in Ecliptic longitude (deg). This is calculated from object_ra and object_dec. | |
| 11 | object_galactic_lon | numeric(9,6) | degree | Source position in Galactic longitude (deg). This is calculated from object_ra and object_dec. | |
| 12 | object_galactic_lat | numeric(9,6) | degree | Source position in Galactic longitude (deg). This is calculated from object_ra and object_dec. | |
| 13 | quantity_of_observation | smallint | ― | Number of pointings used to create the spectrum | |
| 14 | integration_time | numeric(5,2) | sec | Net integration time | |
| 15 | fwhm_4micron | numeric(4,3) | ― | Spectral FWHM at 4.05 micron | |
| 16 | is_saturated | character varying(1) | ― | Saturation Flag for long exposure. This flag indicates whether the spectrum is (partly) saturated in a long-exposure image or not. [N = not saturated, Y = saturated] | |
| 17 | is_decomposition | character varying(1) | ― | Decomposition Flag. This flag indicates whether the decomposition process is required to extract the spectrum or not (see Ohsawa et al. 2016, AJ, 151, 93, Figure2, for details). [N = not used, Y = the decomposition process is used] | |
| 18 | is_decontamination | character varying(1) | ― | Contamination Flag. This flag indicates whether the decontamination process is required to extract the spectrum or not (see Ohsawa et al. 2016, AJ, 151, 93, Figure3, for details). [N = not used, Y = the decontamination process is used] | |
| 19 | data_access_url | character varying(255) | ― | The access url of the AKARI/IRC Spectrum | |
| 20 | magunitude_v | numeric(4,1) | mag | Magnitude in the V-band | |
| 21 | is_upper_limit_magunitude_v | character varying(1) | ― | Upper Limit Flag of magunitude_v [Y=uppper limmit, N=not upper limit] | |
| 22 | magunitude_ks | numeric(4,1) | mag | Magnitude in the 2MASS Ks-band | |
| 23 | is_upper_limit_magunitude_ks | character varying(1) | ― | Upper Limit Flag of magunitude_ks [Y=uppper limmit, N=not upper limit] | |
| 24 | av_hb | numeric(4,2) | mag | Extinction (H{beta}/Br{alpha} ratio). The 68% confidence interval of av_hb is given by (lower_confidence_limit_av_hb, upper_confidence_limit_av_hb). (see Ohsawa et al. 2016, AJ, 151, 93, equation 3, for details) | |
| 25 | lower_confidence_limit_av_hb | numeric(4,2) | mag | Lower Confidence Limit of av_hb (1-sigma) | |
| 26 | upper_confidence_limit_av_hb | numeric(4,2) | mag | Upper Confidence Limit of av_hb (1-sigma) | |
| 27 | av_fit | numeric(4,2) | mag | Extinction (SED Fitting). The 68% confidence interval of av_fit is given by (ower_confidence_bound_av_fit, upper_confidence_limit_av_fit). | |
| 28 | lower_confidence_limit_av_fit | numeric(4,2) | mag | Lower Confidence Limit of av_fit (1-sigma) | |
| 29 | upper_confidence_limit_av_fit | numeric(4,2) | mag | Upper Confidence Limit of av_fit (1-sigma) | |
| 30 | effective_temperature | smallint | kelvin | Effective Temperature collected from the literature. If multiple sources are available, the weighted mean temperature is allocated. A NULL value is allocated when no temperature is available in the literature. See Ohsawa et al. 2016, AJ, 151, 93, for details. | |
| 31 | paper_about_effective_templeture | character varying(100) | ― | References for the effective temperatures given as a comma-separated list. A NULL value (blank) is allocated when no temperature is available. | |
| 32 | intensity_br_alpha | numeric(5,2) | 10-15 W/m2 | Intensity of Brackett-{alpha}. A NULL value is allocated when the spectral feature is not detected or only an upper limit is obtained. | |
| 33 | lower_confidence_limit_intensity_br_alpha | numeric(5,2) | 10-15 W/m2 | Lower Confidence Limit of intensity_br_alpha. A NULL value is allocated when the spectral feature is not detected or only an upper limit is obtained. | |
| 34 | upper_confidence_limit_intensity_br_alpha | numeric(5,2) | 10-15 W/m2 | Upper Confidence Limit of intensity_br_alpha. A NULL value is allocated when the spectral feature is not detected. A 3-sigma upper limit is allocated when the feature is marginally detected. | |
| 35 | is_upper_limit_intensity_br_alpha | character varying(1) | ― | Upper Limit Flag of intensity_br_alpha. The flag means that upper_confidence_limit_intensity_br_alpha indicates a 3-sigma upper limit. [Y=uppper limmit, N=not upper limit] | このフラグは、upper_confidence_limit_intensity_br_alpha の値が3σの上限を示すことを意味します。 [Y=上限である, N=上限ではない] |
| 36 | intensity_he_ii | numeric(5,2) | 10-15 W/m2 | Intensity of He II. A NULL value is allocated when the spectral feature is not detected or only an upper limit is obtained. | |
| 37 | lower_confidence_limit_intensity_he_ii | numeric(5,2) | 10-15 W/m2 | Lower Confidence Limit of intensity_he_ii. A NULL value is allocated when the spectral feature is not detected or only an upper limit is obtained. | |
| 38 | upper_confidence_limit_intensity_he_ii | numeric(5,2) | 10-15 W/m2 | Upper Confidence Limit of intensity_he_ii. A NULL value is allocated when the spectral feature is not detected. A 3-sigma upper limit is allocated when the feature is marginally detected. | |
| 39 | is_upper_limit_intensity_he_ii | character varying(1) | ― | Upper Limit Flag of intensity_he_ii. The flag means that upper_confidence_limit_intensity_he_ii indicates a 3-sigma upper limit. [Y=uppper limmit, N=not upper limit] | |
| 40 | intensity_he_i | numeric(5,2) | 10-15 W/m2 | Intensity of He1. A NULL value is allocated when the spectral feature is not detected or only an upper limit is obtained. | |
| 41 | lower_confidence_limit_intensity_he_i | numeric(5,2) | 10-15 W/m2 | Lower Confidence Limit of intensity_he_i. A NULL value is allocated when the spectral feature is not detected or only an upper limit is obtained. | |
| 42 | upper_confidence_limit_intensity_he_i | numeric(5,2) | 10-15 W/m2 | Upper Confidence Limit of intensity_he_i. A NULL value is allocated when the spectral feature is not detected. A 3-sigma upper limit is allocated when the feature is marginally detected. | |
| 43 | is_upper_limit_intensity_he_i | character varying(1) | ― | Upper Limit Flag of intensity_he_i. The flag means that upper_confidence_limit_intensity_he_i indicates a 3-sigma upper limit. [Y=uppper limmit, N=not upper limit] | |
| 44 | intensity_pah | numeric(5,2) | 10-15 W/m2 | Intensity of PAH. A NULL value is allocated when the spectral feature is not detected or only an upper limit is obtained. | |
| 45 | lower_confidence_limit_intensity_pah | numeric(5,2) | 10-15 W/m2 | Lower Confidence Limit of intensity_pah. A NULL value is allocated when the spectral feature is not detected or only an upper limit is obtained. | |
| 46 | upper_confidence_limit_intensity_pah | numeric(5,2) | 10-15 W/m2 | Upper Confidence Limit of intensity_pah. A NULL value is allocated when the spectral feature is not detected. A 3-sigma upper limit is allocated when the feature is marginally detected. | |
| 47 | is_upper_limit_intensity_pah | character varying(1) | ― | Upper Limit Flag of intensity_pah. The flag means that upper_confidence_limit_intensity_pah indicates a 3-sigma upper limit. [Y=uppper limmit, N=not upper limit] | |
| 48 | intensity_c_h | numeric(5,2) | 10-15 W/m2 | Intensity of C-H. A NULL value is allocated when the spectral feature is not detected or only an upper limit is obtained. | |
| 49 | lower_confidence_limit_intensity_c_h | numeric(5,2) | 10-15 W/m2 | Lower Confidence Limit of intensity_c_h. A NULL value is allocated when the spectral feature is not detected or only an upper limit is obtained. | |
| 50 | upper_confidence_limit_intensity_c_h | numeric(5,2) | 10-15 W/m2 | Upper Confidence Limit of intensity_c_h. A NULL value is allocated when the spectral feature is not detected. A 3-sigma upper limit is allocated when the feature is marginally detected. | |
| 51 | is_upper_limit_intensity_c_h | character varying(1) | ― | Upper Limit Flag of intensity_c_h. The flag means that upper_confidence_limit_intensity_c_h indicates a 3-sigma upper limit. [Y=uppper limmit, N=not upper limit] | |
| 52 | intensity_mg_iv | numeric(5,2) | 10-15 W/m2 | Intensity of Mg IV. A NULL value is allocated when the spectral feature is not detected or only an upper limit is obtained. | |
| 53 | lower_confidence_limit_intensity_mg_iv | numeric(5,2) | 10-15 W/m2 | Lower Confidence Limit of intensity_mg_iv. A NULL value is allocated when the spectral feature is not detected or only an upper limit is obtained. | |
| 54 | upper_confidence_limit_intensity_mg_iv | numeric(5,2) | 10-15 W/m2 | Upper Confidence Limit of intensity_mg_iv. A NULL value is allocated when the spectral feature is not detected. A 3-sigma upper limit is allocated when the feature is marginally detected. | |
| 55 | is_upper_limit_intensity_mg_iv | character varying(1) | ― | Upper Limit Flag of intensity_mg_iv. The flag means that upper_confidence_limit_intensity_mg_iv indicates a 3-sigma upper limit. [Y=uppper limmit, N=not upper limit] | |
| 56 | intensity_ar_vi | numeric(5,2) | 10-15 W/m2 | Intensity of Ar VI. A NULL value is allocated when the spectral feature is not detected or only an upper limit is obtained. | |
| 57 | lower_confidence_limit_intensity_ar_vi | numeric(5,2) | 10-15 W/m2 | Lower Confidence Limit of intensity_ar_vi. A NULL value is allocated when the spectral feature is not detected or only an upper limit is obtained. | |
| 58 | upper_confidence_limit_intensity_ar_vi | numeric(5,2) | 10-15 W/m2 | Upper Confidence Limit of intensity_ar_vi. A NULL value is allocated when the spectral feature is not detected. A 3-sigma upper limit is allocated when the feature is marginally detected. | |
| 59 | is_upper_limit_intensity_ar_vi | character varying(1) | ― | Upper Limit Flag of intensity_ar_vi. The flag means that upper_confidence_limit_intensity_ar_vi indicates a 3-sigma upper limit. [Y=uppper limmit, N=not upper limit] | |
| 60 | equivalent_width_br_alpha | numeric(6,2) | nm | Equivalent width of Brackett-{alpha}. A NULL value is allocated when the spectral feature is not detected or only an upper limit is obtained. | |
| 61 | lower_confidence_limit_equivalent_width_br_alpha | numeric(6,2) | nm | Lower Confidence Limit of equivalent_width_br_alpha. A NULL value is allocated when the spectral feature is not detected or only an upper limit is obtained. | |
| 62 | upper_confidence_limit_equivalent_width_br_alpha | numeric(6,2) | nm | Upper Confidence Limit of equivalent_width_br_alpha. A NULL value is allocated when the spectral feature is not detected. A 3-sigma upper limit is allocated when the feature is marginally detected. | |
| 63 | is_upper_limit_equivalent_width_br_alpha | character varying(1) | ― | Upper Limit Flag of equivalent_width_br_alpha. The flag means that upper_confidence_limit_equivalent_width_br_alpha indicates a 3-sigma upper limit. [Y=uppper limmit, N=not upper limit] | |
| 64 | equivalent_width_he_ii | numeric(6,2) | nm | Equivalent width of He II. A NULL value is allocated when the spectral feature is not detected or only an upper limit is obtained. | |
| 65 | lower_confidence_limit_equivalent_width_he_ii | numeric(6,2) | nm | Lower Confidence Limit of equivalent_width_he_ii. A NULL value is allocated when the spectral feature is not detected or only an upper limit is obtained. | |
| 66 | upper_confidence_limit_equivalent_width_he_ii | numeric(6,2) | nm | Upper Confidence Limit of equivalent_width_he_ii. A NULL value is allocated when the spectral feature is not detected. A 3-sigma upper limit is allocated when the feature is marginally detected. | |
| 67 | is_upper_limit_equivalent_width_he_ii | character varying(1) | ― | Upper Limit Flag of equivalent_width_he_ii. The flag means that upper_confidence_limit_equivalent_width_he_ii indicates a 3-sigma upper limit. [Y=uppper limmit, N=not upper limit] | |
| 68 | equivalent_width_he_i | numeric(6,2) | nm | Equivalent width of He I. A NULL value is allocated when the spectral feature is not detected or only an upper limit is obtained. | |
| 69 | lower_confidence_limit_equivalent_width_he_i | numeric(6,2) | nm | Lower Confidence Limit of equivalent_width_he_i. A NULL value is allocated when the spectral feature is not detected or only an upper limit is obtained. | |
| 70 | upper_confidence_limit_equivalent_width_he_i | numeric(6,2) | nm | Upper Confidence Limit of equivalent_width_he_i. A NULL value is allocated when the spectral feature is not detected. A 3-sigma upper limit is allocated when the feature is marginally detected. | |
| 71 | is_upper_limit_equivalent_width_he_i | character varying(1) | ― | Upper Limit Flag of equivalent_width_he_i. The flag means that upper_confidence_limit_equivalent_width_he_i indicates a 3-sigma upper limit. [Y=uppper limmit, N=not upper limit] | |
| 72 | equivalent_width_pah | numeric(6,2) | nm | Equivalent width of PAH. A NULL value is allocated when the spectral feature is not detected or only an upper limit is obtained. | |
| 73 | lower_confidence_limit_equivalent_width_pah | numeric(6,2) | nm | Lower Confidence Limit of equivalent_width_pah. A NULL value is allocated when the spectral feature is not detected or only an upper limit is obtained. | |
| 74 | upper_confidence_limit_equivalent_width_pah | numeric(6,2) | nm | Upper Confidence Limit of equivalent_width_pah. A NULL value is allocated when the spectral feature is not detected. A 3-sigma upper limit is allocated when the feature is marginally detected. | |
| 75 | is_upper_limit_equivalent_width_pah | character varying(1) | ― | Upper Limit Flag of equivalent_width_pah. The flag means that upper_confidence_limit_equivalent_width_pah indicates a 3-sigma upper limit. [Y=uppper limmit, N=not upper limit] | |
| 76 | equivalent_width_c_h | numeric(6,2) | nm | Equivalent width of C-H. A NULL value is allocated when the spectral feature is not detected or only an upper limit is obtained. | |
| 77 | lower_confidence_limit_equivalent_width_c_h | numeric(6,2) | nm | Lower Confidence Limit of equivalent_width_c_h. A NULL value is allocated when the spectral feature is not detected or only an upper limit is obtained. | |
| 78 | upper_confidence_limit_equivalent_width_c_h | numeric(6,2) | nm | Upper Confidence Limit of equivalent_width_c_h. A NULL value is allocated when the spectral feature is not detected. A 3-sigma upper limit is allocated when the feature is marginally detected. | |
| 79 | is_upper_limit_equivalent_width_c_h | character varying(1) | ― | Upper Limit Flag of equivalent_width_c_h. The flag means that upper_confidence_limit_equivalent_width_c_h indicates a 3-sigma upper limit. [Y=uppper limmit, N=not upper limit] | |
| 80 | equivalent_width_mg_iv | numeric(6,2) | nm | Equivalent width of Mg IV. A NULL value is allocated when the spectral feature is not detected or only an upper limit is obtained. | |
| 81 | lower_confidence_limit_equivalent_width_mg_iv | numeric(6,2) | nm | Lower Confidence Limit of equivalent_width_mg_iv. A NULL value is allocated when the spectral feature is not detected or only an upper limit is obtained. | |
| 82 | upper_confidence_limit_equivalent_width_mg_iv | numeric(6,2) | nm | Upper Confidence Limit of equivalent_width_mg_iv. A NULL value is allocated when the spectral feature is not detected. A 3-sigma upper limit is allocated when the feature is marginally detected. | |
| 83 | is_upper_limit_equivalent_width_mg_iv | character varying(1) | ― | Upper Limit Flag of equivalent_width_mg_iv. The flag means that upper_confidence_limit_equivalent_width_mg_iv indicates a 3-sigma upper limit. [Y=uppper limmit, N=not upper limit] | |
| 84 | equivalent_width_ar_vi | numeric(6,2) | nm | Equivalent width of Ar VI. A NULL value is allocated when the spectral feature is not detected or only an upper limit is obtained. | |
| 85 | lower_confidence_limit_equivalent_width_ar_vi | numeric(6,2) | nm | Lower Confidence Limit of equivalent_width_ar_vi. A NULL value is allocated when the spectral feature is not detected or only an upper limit is obtained. | |
| 86 | upper_confidence_limit_equivalent_width_ar_vi | numeric(6,2) | nm | Upper Confidence Limit of equivalent_width_ar_vi. A NULL value is allocated when the spectral feature is not detected. A 3-sigma upper limit is allocated when the feature is marginally detected. | |
| 87 | is_upper_limit_equivalent_width_ar_vi | character varying(1) | ― | Upper Limit Flag of equivalent_width_ar_vi. The flag means that upper_confidence_limit_equivalent_width_ar_vi indicates a 3-sigma upper limit. [Y=uppper limmit, N=not upper limit] | |
| 88 | ql_image_url | character varying(255) | ― | The url of the AKARI/IRC Spectrum QL image |
akari_irc_gal_hii_spectrum_1
"AKARI Near-infrared Spectral Atlas of Galactic HII regions Version 1".
| No. | Column Name | type | Unit | Description |
|---|---|---|---|---|
| 1 | object_name | character varying(15) | ― | Source name |
| 2 | observation_id | character varying(11) | ― | Observation ID |
| 3 | used_slit | character varying(2) | ― | Used Slit (Ns or Nh). "Ns" slit is 0.8 arcmin length 5 arcsec width, "Nh" slit is 1 arcmin length 3 arcsec width. |
| 4 | center_ra | numeric(9,6) | degree | Right ascension (J2000) for the slit center |
| 5 | center_dec | numeric(9,6) | degree | Declination (J2000) for the slit center |
| 6 | center_ra_b1950 | numeric(9,6) | degree | Right Ascension (B1950) for the slit center. It is calculated from center_ra and center_dec. |
| 7 | center_dec_b1950 | numeric(9,6) | degree | Declination (B1950) for the slit center. It is calculated from center_ra and center_dec. |
| 8 | center_ecliptic_lon | numeric(9,6) | degree | Ecliptic longitude for the slit center. It is calculated from center_ra and center_dec. |
| 9 | center_ecliptic_lat | numeric(9,6) | degree | Ecliptic Latitude for the slit center. It is calculated from center_ra and center_dec. |
| 10 | center_galactic_lon | numeric(9,6) | degree | Galactic longitude for the slit center. It is calculated from center_ra and center_dec. |
| 11 | center_galactic_lat | numeric(9,6) | degree | Galactic Latitude for the slit center. It is calculated from center_ra and center_dec. |
| 12 | data_access_url | character varying(255) | ― | URL to the dataset |
akari_irc_diffuse_skypatch_spectrum_1
"AKARI IRC NIR Low-resolution Spectral Catalogue of Diffuse Sky Patches Version 1".
| No. | Column Name | type | Unit | Description |
|---|---|---|---|---|
| 1 | observation_id | character varying(11) | ― | The sequence number of the observation. 'observation_id' = 'object_id' + '-' + 'observation_count'(Add 0 to the head and align 3 digits) |
| 2 | observation_start_time | timestamp without time zone | UTC | Observation start datetime [UTC] |
| 3 | observation_start_time_mjd | double precision | MJD | Observation start datetime [MJD] |
| 4 | center_ra | numeric(6,3) | degree | Right Ascension (J2000). Calculated coordinate at the center position of the Ns slit referring to the header information in the original FITS file. |
| 5 | center_dec | numeric(6,3) | degree | Declination (J2000). Calculated coordinate at the center position of the Ns slit referring to the header information in the original FITS file. |
| 6 | center_ra_b1950 | numeric(9,6) | degree | Right Ascension (B1950). Calculated from center_ra, center_dec. |
| 7 | center_dec_b1950 | numeric(9,6) | degree | Declination (B1950). Calculated from center_ra, center_dec. |
| 8 | center_ecliptic_lon | numeric(9,6) | degree | Ecliptic Longitude. Calculated from center_ra, center_dec. |
| 9 | center_ecliptic_lat | numeric(9,6) | degree | Ecliptic Latitude. Calculated from center_ra, center_dec. |
| 10 | center_galactic_lon | numeric(9,6) | degree | Galactic Longitude. Calculated from center_ra, center_dec. |
| 11 | center_galactic_lat | numeric(9,6) | degree | Galactic Latitude. Calculated from center_ra, center_dec. |
| 12 | data_access_url | character varying(255) | ― | URL to the dataset |
| 13 | ql_access_url | character varying(255) | ― | URL used to spectra text |
| 14 | ql_image_url | character varying(255) | ― | URL to the quick look image |
akari_irc_lmc_spectrum_1
"AKARI-LMC Near-Infrared Spectroscopic Catalogue Version 1".
| No. | Column Name | type | Unit | Description |
|---|---|---|---|---|
| 1 | object_name | character varying(30) | ― | Source identifier, correspond with ID2 in the "AKARI/IRC LMC point source catalog" (Kato et al. 2012) (Jhhmmss.ss-ddmmss.s) |
| 2 | frame_id | character varying(7) | ― | Frame-ID. These IDs correspond to the position of the observed ?eld of view within the LMC. |
| 3 | object_id_in_frame | character varying(3) | ― | Source-ID. These IDs are determined arbitrary depending on the position of the sources within the ?eld of view. |
| 4 | object_ra | numeric(9,6) | degree | Object position, Right Ascension (J2000) |
| 5 | object_dec | numeric(9,6) | degree | Object position, Declination (J2000) |
| 6 | object_ra_b1950 | numeric(9,6) | degree | Object position, Right Ascension (B1950). Calculated from object_ra, object_dec. |
| 7 | object_dec_b1950 | numeric(9,6) | degree | Object position, Declination (B1950). Calculated from object_ra, object_dec. |
| 8 | object_ecliptic_lon | numeric(9,6) | degree | Object position, Ecliptic Longitude. Calculated from object_ra, object_dec. |
| 9 | object_ecliptic_lat | numeric(9,6) | degree | Object position, Ecliptic Latitude. Calculated from object_ra, object_dec. |
| 10 | object_galactic_lon | numeric(9,6) | degree | Object position, Galactic Longitude. Calculated from object_ra, object_dec. |
| 11 | object_galactic_lat | numeric(9,6) | degree | Object position, Galactic Latitude. Calculated from object_ra, object_dec. |
| 12 | observation_start_time | timestamp without time zone | UTC | Observation start date [UTC]. No time information is on file. |
| 13 | observation_start_time_mjd | double precision | MJD | Observation start date [MJD]. No time information is on file. |
| 14 | spectrum_type | character varying(2) | ― |
Spectrum type. [FS＝full spectrum, SS＝short spectrum]
Due to contamination, the longer spectrum (4-5.5 µm) was removed
and only the shorter spectrum (2-4 µm) was extracted,
which is stored as short spectrum (SS). FS sources: full 2.0-5.0 micron spectra are available without contamination. SS sources: only short wavelength side (typically 2-4 micron) spectra are available due to partial spectral contamination. |
| 15 | ssid_in_sage_spec | integer | ― | Matched Spitzer SAGE-Spec source ID |
| 16 | magnitude_2mass_j | numeric(5,3) | mag | Magnitude in 2MASS J band |
| 17 | magnitude_err_2mass_j | numeric(5,3) | mag | Magnitude error of 2MASS J band |
| 18 | magnitude_2mass_h | numeric(5,3) | mag | Magnitude in 2MASS H band |
| 19 | magnitude_err_2mass_h | numeric(5,3) | mag | Magnitude error of 2MASS H band |
| 20 | magnitude_2mass_ks | numeric(5,3) | mag | Magnitude in 2MASS Ks band |
| 21 | magnitude_err_2mass_ks | numeric(5,3) | mag | Magnitude error of 2MASS Ks band |
| 22 | magnitude_spitzer_irac_1 | numeric(5,3) | mag | Magnitude in Spitzer SAGE/IRAC 3.6µm band |
| 23 | magnitude_err_spitzer_irac_1 | numeric(5,3) | mag | Magnitude error of Spitzer SAGE/IRAC 3.6µm band |
| 24 | magnitude_spitzer_irac_2 | numeric(5,3) | mag | Magnitude in Spitzer SAGE/IRAC 4.5µm band |
| 25 | magnitude_err_spitzer_irac_2 | numeric(5,3) | mag | Magnitude error of Spitzer SAGE/IRAC 4.5µm band |
| 26 | magnitude_spitzer_irac_3 | numeric(5,3) | mag | Magnitude in Spitzer SAGE/IRAC 5.8µm band |
| 27 | magnitude_err_spitzer_irac_3 | numeric(5,3) | mag | Magnitude error of Spitzer SAGE/IRAC 5.8µm band |
| 28 | magnitude_spitzer_irac_4 | numeric(5,3) | mag | Magnitude in Spitzer SAGE/IRAC 8.0µm band |
| 29 | magnitude_err_spitzer_irac_4 | numeric(5,3) | mag | Magnitude error of Spitzer SAGE/IRAC 8.0µm band |
| 30 | magnitude_spitzer_mips_24 | numeric(5,3) | mag | Magnitude in Spitzer SAGE/MIPS 24µm band |
| 31 | magnitude_err_spitzer_mips_24 | numeric(5,3) | mag | Magnitude error of Spitzer SAGE/MIPS 24µm band |
| 32 | magnitude_spitzer_mips_70 | numeric(5,3) | mag | Magnitude in Spitzer SAGE/MIPS 70µm band |
| 33 | magnitude_err_spitzer_mips_70 | numeric(5,3) | mag | Magnitude error of Spitzer SAGE/MIPS 70µm band |
| 34 | magnitude_spitzer_mips_160 | numeric(5,3) | mag | Magnitude in Spitzer SAGE/MIPS 160µm band |
| 35 | magnitude_err_spitzer_mips_160 | numeric(5,3) | mag | Magnitude error of Spitzer SAGE/MIPS 160µm band |
| 36 | magnitude_n3 | numeric(5,3) | mag | Magnitude in AKARI/IRC N3 band |
| 37 | magnitude_err_n3 | numeric(5,3) | mag | Magnitude error of AKARI/IRC N3 band |
| 38 | magnitude_s7 | numeric(5,3) | mag | Magnitude in AKARI/IRC S7 band |
| 39 | magnitude_err_s7 | numeric(5,3) | mag | Magnitude error of AKARI/IRC S7 band |
| 40 | magnitude_s11 | numeric(5,3) | mag | Magnitude in AKARI/IRC S11 band |
| 41 | magnitude_err_s11 | numeric(5,3) | mag | Magnitude error of AKARI/IRC S11 band |
| 42 | magnitude_l15 | numeric(5,3) | mag | Magnitude in AKARI/IRC L15 band |
| 43 | magnitude_err_l15 | numeric(5,3) | mag | Magnitude error of AKARI/IRC L15 band |
| 44 | magnitude_l24 | numeric(5,3) | mag | Magnitude in AKARI/IRC L24 band |
| 45 | magnitude_err_l24 | numeric(5,3) | mag | Magnitude error of AKARI/IRC L24 band |
| 46 | data_access_url | character varying(255) | ― | URL to the dataset |
| 47 | ql_image_url | character varying(255) | ― | URL to the quick look image |
akari_pointed_rawdata_package_info
Description of each distribution package of "AKARI Pointed Observation Raw Data Version 1 (Phase 1&2) and Version 2 (Phase 3)".
| No. | Column Name | Type | Unit | Description | Former Column Name | Former Type | Former Unit | |
|---|---|---|---|---|---|---|---|---|
| 1 | observation_start_time | timestamp without timezone | UTC | Start Time of the Observation in UTC. | DATE | date | UTC | |
| ― | ― | ― | TIME | time | ― | |||
| 2 | observation_start_time_mjd | double precision | MJD | Start Time of the Observation in MJD. | ― | ― | ― | |
| 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. | 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. | ― | ― | ― | |
| 5 | observation_id | character varying(11) | ― | The sequence number of the observation. 'observation_id' = 'object_id' + '-' + 'observation_count'(Add 0 to the head and align 3 digits) | OBSID | varchar(11) | ― | |
| 6 | object_name | character varying(63) | ― | Object name | OBJECT | varchar(63) | ― | |
| 7 | pi_name | character varying(35) | ― | PI Name (Observer's ID) | OBSERVER | varchar(35) | ― | |
| 8 | proposal_code | character varying(7) | ― | Proposal Code named by PI | PROPOSAL | varchar(7) | ― | |
| 9 | object_ra | double precision | degree | Target position, Right Ascenstion J2000. | 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. | OBJ_LII | double | degree | |
| 14 | object_galactic_lat | double precision | degree | Target position, Galactic Latitude. | OBJ_BII | double | degree | |
| 15 | object_ecliptic_lon | double precision | degree | Target position, Ecliptic Longitude. | OBJ_ECL_LONG | double | degree | |
| 16 | object_ecliptic_lat | double precision | degree | Target position, Ecriptic Latitude. | OBJ_ECL_LATI | double | degree | |
| 17 | aot_name | character varying(11) | ― | Astronomical Observation Template | AOT | varchar(11) | ― | |
| 18 | aot_param | character varying(15) | ― | AOT Parameters. Multiple parameters are connected with ';'. | AOTPARAM | varchar(15) | ― | |
| 19 | aot_type | character varying(15) | ― | AOT Type [ ENGINEERING, NORMAL, or SPECIAL ] | 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 ] | STATUS | varchar(31) | ― | |
| 21 | observation_mode | character varying(11) | ― | Observation Mode [ MAIN or PARALLEL ] | OBS_MODE | varchar(11) | ― | |
| 22 | object_id | bigint | ― | Target ID. 'observation_id' = 'object_id' + '-' + 'observation_count'(Add 0 to the head and align 3 digits) | TARGETID | int(11) | ― | |
| 23 | observation_count | bigint | ― | Ordinal number at observations for the same target. 'observation_id' = 'object_id' + '-' + 'observation_count'(Add 0 to the head and align 3 digits) | SUBID | int(11) | ― | |
| 24 | pointing_id | bigint | ― | Pointing ID | PNTNG_ID | int(11) | ― | |
| 25 | remark_id | character varying(31) | ― | Related remark IDs. [ 1, 2, 3, ..., 7, or combination of those connected with '/' ] | REMIDS | varchar(31) | ― | |
| 26 | remark_title | character varying(255) | ― | Remark Name | REMNAMES | varchar(255) | ― | |
| 27 | public_date | timestamp without timezone | UTC | Public Date | PUBLIC_DATE | date | UTC | |
| 28 | public_date_mjd | double precision | MJD | ― | ||||
| 29 | file_create_date | timestamp without timezone | UTC | Data package created time | PKGMTIME | datetime | UTC | |
| 30 | data_size | bigint | MB | Package File Size | PKGFSIZE | int(11) | Byte | |
| 31 | data_access_url | character varying(63) | ― | URL to the dataset | PKGPATH | varchar(63) | ― |
akari_proposal
"AKARI" Proposals information.
| No. | Column Name | type | Unit | Description |
|---|---|---|---|---|
| 1 | proposal_id | smallint | ― | Proposal ID |
| 2 | proposal_code | character varying(7) | ― | Proposal Code named by PI |
| 3 | proposal_code_with_pi_name | character varying(23) | ― | Proposal Code with PI name. {proposal_code}_{pi_name} |
| 4 | pi_name | text | ― | PI Name (Observer's ID) |
| 5 | observation_category | character varying(7) | ― | Observation Category [ LS(=Large Area Servey), MP(=Mission Program), OT(=Open Time), DT(=Directors Time), or PV(=Performance Verification) ] |
| 6 | observation_phase | character varying(4) | ― |
Observation Phase [ 1&2, 3, or 3-II ] Phase1, Phase2: Cooling with refrigerator + liquid helium Phase3, Phase3-II: Cooling only with the refrigerator |
| 7 | proposal_title | character varying(120) | ― | Title of the proposal |
| 8 | proposal_abstruct | text | ― | Abstruct of the proposal |
| 9 | proposal_access_url | character varying(255) | ― | URL to the proposal data file. |