[ English | Japanese ]
Searchable Data with the DARTS/Astro Query System
Schema of Tables about IRTS
| Satelite/Project | Abstract of the data product | Database table name | Number of entries in the database | Searhcable with Basic Search | Searchable with SQL/ADQL Search |
|---|---|---|---|---|---|
| IRTS | Descriptions of the invidual image files composing "IRTS Spatial Intensity Map". | irts_map | 305 | Yes | Yes |
| IRTS | "IRTS MIRS Point Source Catalogue version 2.1". | irts_mirs_psc_2_1 | 536 | Yes | Yes |
| IRTS | "IRTS NIRS Point Source Catalogue version 1.3". | irts_nirs_psc_1_3 | 14,223 | Yes | Yes |
irts_map
| No. | Column Name | Type | Unit | Description |
|---|---|---|---|---|
| 1 | region_id | character varying(4) | Scan-path No. | |
| 2 | ql_image_url | character varying(255) | URL of the quick look image | |
| 3 | ql_access_url | character varying(255) | URL of the quick look page | |
| 4 | center_ra | numeric(8,5) | degree | Right Ascension (J2000) of the center position of the scan area, calculated from the object_galactic_lon and object_galactic_dec. |
| 5 | center_dec | numeric(8,5) | degree | Declination (J2000) of the center position of the scan area, calculated from the object_galactic_lon and object_galactic_dec. |
| 6 | center_ra_b1950 | numeric(8,5) | degree | Right Ascension (B1950) of the center position of the scan area, calculated from the object_galactic_lon and object_galactic_dec. |
| 7 | center_dec_b1950 | numeric(8,5) | degree | Declination (B1950) of the center position of the scan area, calculated from the object_galactic_lon and object_galactic_dec. |
| 8 | center_ecliptic_lon | numeric(8,5) | degree | Ecliptic Longitude of the center position of the scan area, calculated from the object_galactic_lon and object_galactic_dec. |
| 9 | center_ecliptic_lat | numeric(8,5) | degree | Ecliptic Latitude of the center position of the scan area, calculated from the object_galactic_lon and object_galactic_dec. |
| 10 | center_galactic_lon | numeric(5,2) | degree | Galactic Longitude of the center position of the scan area |
| 11 | center_galactic_lat | numeric(5,2) | degree | Galactic Latitude of the center position of the scan area |
| 12 | instrument | character varying(4) | Instrument [FILM or FIRM] | |
| 13 | band | smallint | μm | Wavelength [155, 158(CII), 250, 400, 700] |
| 14 | data_access_url | character varying(255) | URL to data directory | |
| 15 | corner1_ra | numeric(8,5) | degree | Right Ascension (J2000) of the vertex1 of the scan area |
| 16 | corner1_dec | numeric(8,5) | degree | Declination (J2000) of the vertex1 of the scan area |
| 17 | corner2_ra | numeric(8,5) | degree | Right Ascension (J2000) of the vertex2 of the scan area |
| 18 | corner2_dec | numeric(8,5) | degree | Declination (J2000) of the vertex2 of the scan area |
| 19 | corner3_ra | numeric(8,5) | degree | Right Ascension (J2000) of the vertex3 of the scan area |
| 20 | corner3_dec | numeric(8,5) | degree | Declination (J2000) of the vertex3 of the scan area |
| 21 | corner4_ra | numeric(8,5) | degree | Right Ascension (J2000) of the vertex4 of the scan area |
| 22 | corner4_dec | numeric(8,5) | degree | Declination (J2000) of the vertex4 of the scan area |
| 23 | corner1_ra_b1950 | numeric(8,5) | degree | Right Ascension (B1950) of the vertex1 of the scan area |
| 24 | corner1_dec_b1950 | numeric(8,5) | degree | Declination (B1950) of the vertex1 of the scan area |
| 25 | corner2_ra_b1950 | numeric(8,5) | degree | Right Ascension (B1950) of the vertex2 of the scan area |
| 26 | corner2_dec_b1950 | numeric(8,5) | degree | Declination (B1950) of the vertex2 of the scan area |
| 27 | corner3_ra_b1950 | numeric(8,5) | degree | Right Ascension (B1950) of the vertex3 of the scan area |
| 28 | corner3_dec_b1950 | numeric(8,5) | degree | Declination (B1950) of the vertex3 of the scan area |
| 29 | corner4_ra_b1950 | numeric(8,5) | degree | Right Ascension (B1950) of the vertex4 of the scan area |
| 30 | corner4_dec_b1950 | numeric(8,5) | degree | Declination (B1950) of the vertex4 of the scan area |
| 31 | corner1_ecliptic_lon | numeric(8,5) | degree | Ecliptic Longitude of the vertex1 of the scan area |
| 32 | corner1_ecliptic_lat | numeric(8,5) | degree | Ecliptic Latitude of the vertex1 of the scan area |
| 33 | corner2_ecliptic_lon | numeric(8,5) | degree | Ecliptic Longitude of the vertex2 of the scan area |
| 34 | corner2_ecliptic_lat | numeric(8,5) | degree | Ecliptic Latitude of the vertex2 of the scan area |
| 35 | corner3_ecliptic_lon | numeric(8,5) | degree | Ecliptic Longitude of the vertex3 of the scan area |
| 36 | corner3_ecliptic_lat | numeric(8,5) | degree | Ecliptic Latitude of the vertex3 of the scan area |
| 37 | corner4_ecliptic_lon | numeric(8,5) | degree | Ecliptic Longitude of the vertex4 of the scan area |
| 38 | corner4_ecliptic_lat | numeric(8,5) | degree | Ecliptic Latitude of the vertex4 of the scan area |
| 39 | corner1_galactic_lon | numeric(5,2) | degree | Galactic Longitude of the vertex1 of the scan area |
| 40 | corner1_galactic_lat | numeric(5,2) | degree | Galactic Latitude of the vertex1 of the scan area |
| 41 | corner2_galactic_lon | numeric(5,2) | degree | Galactic Longitude of the vertex2 of the scan area |
| 42 | corner2_galactic_lat | numeric(5,2) | degree | Galactic Latitude of the vertex2 of the scan area |
| 43 | corner3_galactic_lon | numeric(5,2) | degree | Galactic Longitude of the vertex3 of the scan area |
| 44 | corner3_galactic_lat | numeric(5,2) | degree | Galactic Latitude of the vertex3 of the scan area |
| 45 | corner4_galactic_lon | numeric(5,2) | degree | Galactic Longitude of the vertex4 of the scan area |
| 46 | corner4_galactic_lat | numeric(5,2) | degree | Galactic Latitude of the vertex4 of the scan area |
irts_mirs_psc_2_1
"IRTS MIRS Point Source Catalogue version 2.1"
| No. | Column Name | Type | Unit | Description |
|---|---|---|---|---|
| 1 | object_id | character varying(10) | Object name defined based on the MIRS detection position (B1950) to allow direct comparison with the IRAS names. RA.(5 bytes) and Dec (5 bytes). | |
| 2 | ql_image_url | character varying(255) | URL of the spectrum image for a quick look | |
| 3 | ql_access_url | character varying(255) | URL of the spectrum data | |
| 4 | object_ra_hms | character varying(8) | Right Ascension (J2000) of source position, format of 00h03.0m | |
| 5 | objet_dec_dms | character varying(7) | Declination (J2000) of source position, format of +74d04' | |
| 6 | object_ra | numeric(5,2) | degree | Right Ascension (J2000) of source position |
| 7 | object_dec | numeric(5,2) | degree | Declination (J2000) of source position |
| 8 | object_ra_1950 | numeric(8,5) | degree | Right Ascension (B1950) of source position, calculated from the object_ra and object_dec. |
| 9 | object_dec_1950 | numeric(8,5) | degree | Declination (B1950) of source position, calculated from the object_ra and object_dec. |
| 10 | object_ecliptic_lon | numeric(8,5) | degree | Ecliptic Longitude of source position, calculated from the object_ra and object_dec. |
| 11 | object_ecliptic_lat | numeric(8,5) | degree | Ecliptic Latitude of source position, calculated from the object_ra and object_dec. |
| 12 | object_galactic_lon | numeric(8,5) | degree | Galactic Longitude of source position, calculated from the object_ra and object_dec. |
| 13 | object_galactic_lat | numeric(8,5) | degree | Galactic Latitude of source position, calculated from the object_ra and object_dec. |
| 14 | quantity_of_observation | smallint | Number of MIRS data used for the final spectrum. | |
| 15 | spectral_type | character varying(1) | Spectral classification. See Yamamura et al. 1996, PASJ 48, L65 | |
| 16 | position_accuracy | character varying(1) | Position accuracy. [g: <~ 2 arcmin, m: <~ 5arcmin, u: <~ 30 arcmin, b: > 30 arcmin] | |
| 17 | flux_density_b1 | numeric(6,2) | Jy | Averaged flux of chanels 1 to 8 in Jy. |
| 18 | flux_density_b2 | numeric(6,2) | Jy | Averaged flux of chanels 9 to 16 in Jy. |
| 19 | flux_density_b3 | numeric(6,2) | Jy | Averaged flux of chanels 17 to 24 in Jy. |
| 20 | flux_density_b4 | numeric(6,2) | Jy | Averaged flux of chanels 25 to 32 in Jy. |
| 21 | flux_quality_b1 | smallint | Quality of chanels 1 to 8. [3: good, 2: usable, 1: bad, 0: no data] | |
| 22 | flux_quality_b2 | smallint | Quality of chanels 9 to 16. [3: good, 2: usable, 1: bad, 0: no data] | |
| 23 | flux_quality_b3 | smallint | Quality of chanels 17 to 24. [3: good, 2: usable, 1: bad, 0: no data] | |
| 24 | flux_quality_b4 | smallint | Quality of chanels 25 to 32. [3: good, 2: usable, 1: bad, 0: no data] | |
| 25 | quantity_of_counterpart_in_iras | smallint | Number of nearby IRAS PSC brighter than 5 Jy at 12 micrometers within 8 arcmin. | |
| 26 | object_id_in_iras | character varying(10) | Object name in IRAS PSC | |
| 27 | flux_density_in_iras_12 | numeric(5,1) | Jy | IRAS 12 micron flux (Jy). |
| 28 | distance_from_iras_arcmin | numeric(3,2) | arcmin | Distance to the brightest nearby IRAS source from the MIRS position (arcmin). |
| 29 | distance_from_iras | numeric(4,1) | arcsec | Distance to the brightest nearby IRAS source from the MIRS position (arcsec). |
| 30 | spectral_class_in_iras_lrs | smallint | Characterization of the IRAS LRS Spectrum. See Olnon et al. 1986, A&AS 65, 607. | |
| 31 | data_access_url | character varying(255) | URL of the catalog data |
irts_nirs_psc_1_3
"IRTS NIRS Point Source Catalog version 1.3"
| No. | Column Name | Type | Unit | Description |
|---|---|---|---|---|
| 1 | object_id | character varying(10) | Object Name in NIRS PSC (IRAS conventions) | |
| 2 | scan_path | character varying(1) | Scan-path. N: North-scan or S: South-scan | |
| 3 | object_ra_hms | character varying(8) | hms | Right Ascension (J2000) of source position, format of 00h03.0m |
| 4 | object_dec_dms | character varying(7) | dms | Declination (J2000) of source position, format of +74d04' |
| 5 | object_ra | numeric(5,2) | degree | Right Ascension (J2000) of source position |
| 6 | object_dec | numeric(5,2) | degree | Declination (J2000) of source position |
| 7 | object_ra_1950 | numeric(8,5) | degree | Right Ascension (B1950) of source position, calculated from the object_ra and object_dec. |
| 8 | object_dec_1950 | numeric(8,5) | degree | Declination (B1950) of source position, calculated from the object_ra and object_dec. |
| 9 | object_ecliptic_lon | numeric(8,5) | degree | Ecliptic Longitude of source position, calculated from the object_ra and object_dec. |
| 10 | object_ecliptic_lat | numeric(8,5) | degree | Ecliptic Latitude of source position, calculated from the object_ra and object_dec. |
| 11 | object_galactic_lon | numeric(5,2) | degree | Galactic Longitude of source position, calculated from the object_ra and object_dec. |
| 12 | object_galactic_lat | numeric(5,2) | degree | Galactic Latitude of source position, calculated from the object_ra and object_dec. |
| 13 | position_angle | numeric(4,1) | degree | Position angle (degree) to the scan direction. |
| 14 | object_lon_in_irts_coord | numeric(5,2) | degree | Longitude of the IRTS coordinate. The 'IRTS coordinate' was defined for the north- and south-scan respectively, so that IRTS scan paths are close to its equator. To convert B1950 coordinate to the IRTS coordinate, you rotate around the Z axis by A and then rotate by D around the Y axis. (pbject_ra_b1950,object_dec_b1950)=(182.25,-73.75) and (25.0,-64.0) (degrees) are converted to (object_lon_in_irts_coord,object_lat_in_irts_coord)=(0,0) in the IRTS north-scan and south-scan coordinate, respectively. |
| 15 | object_lat_in_irts_coord | numeric(4,2) | degree | Latitude of the IRTS coordinate. The 'IRTS coordinate' was defined for the north- and south-scan respectively, so that IRTS scan paths are close to its equator. To convert B1950 coordinate to the IRTS coordinate, you rotate around the Z axis by A and then rotate by D around the Y axis. (pbject_ra_b1950,object_dec_b1950)=(182.25,-73.75) and (25.0,-64.0) (degrees) are converted to (object_lon_in_irts_coord,object_lat_in_irts_coord)=(0,0) in the IRTS north-scan and south-scan coordinate, respectively. |
| 16 | position_err_in_irts_coord_lon | numeric(3,1) | arcmin | Position error in longitude of the IRTS coordinate. |
| 17 | position_err_in_irts_coord_lat | numeric(3,1) | arcmin | Position error in latitude of the IRTS coordinate. |
| 18 | magnitude_nirs_h | numeric(6,3) | Magnitude in NIRS H band | |
| 19 | magnitude_nirs_k | numeric(6,3) | Magnitude in NIRS K band | |
| 20 | magnitude_nirs_l | numeric(6,3) | Magnitude in NIRS L band | |
| 21 | magnitude_err_nirs_h | numeric(5,3) | Magnitude error in NIRS H band | |
| 22 | magnitude_err_nirs_k | numeric(5,3) | Magnitude error in NIRS K band | |
| 23 | magnitude_err_nirs_l | numeric(5,3) | Magnitude error in NIRS L band | |
| 24 | flux_density_24 | double precision | Jy | Flux of channel 24 (lambda=1.4 μｍ) |
| 25 | flux_density_23 | double precision | Jy | Flux of channel 23 |
| 26 | flux_density_22 | double precision | Jy | Flux of channel 22 |
| 27 | flux_density_21 | double precision | Jy | Flux of channel 21 |
| 28 | flux_density_20 | double precision | Jy | Flux of channel 20 |
| 29 | flux_density_19 | double precision | Jy | Flux of channel 19 |
| 30 | flux_density_18 | double precision | Jy | Flux of channel 18 |
| 31 | flux_density_17 | double precision | Jy | Flux of channel 17 |
| 32 | flux_density_16 | double precision | Jy | Flux of channel 16 |
| 33 | flux_density_15 | double precision | Jy | Flux of channel 15 |
| 34 | flux_density_14 | double precision | Jy | Flux of channel 14 |
| 35 | flux_density_13 | double precision | Jy | Flux of channel 13 |
| 36 | flux_density_12 | double precision | Jy | Flux of channel 12 |
| 37 | flux_density_11 | double precision | Jy | Flux of channel 11 |
| 38 | flux_density_10 | double precision | Jy | Flux of channel 10 |
| 39 | flux_density_09 | double precision | Jy | Flux of channel 9 |
| 40 | flux_density_08 | double precision | Jy | Flux of channel 8 |
| 41 | flux_density_07 | double precision | Jy | Flux of channel 7 |
| 42 | flux_density_06 | double precision | Jy | Flux of channel 6 |
| 43 | flux_density_05 | double precision | Jy | Flux of channel 5 |
| 44 | flux_density_04 | double precision | Jy | Flux of channel 4 |
| 45 | flux_density_03 | double precision | Jy | Flux of channel 3 |
| 46 | flux_density_02 | double precision | Jy | Flux of channel 2 |
| 47 | flux_density_01 | double precision | Jy | Flux of channel 1 (lambda=4.0 micron) |
| 48 | flux_err_24 | double precision | Jy | Flux error of channel 24, come from the signal noise and the fluctuation of baseline. |
| 49 | flux_err_23 | double precision | Jy | Flux error of channel 23, come from the signal noise and the fluctuation of baseline. |
| 50 | flux_err_22 | double precision | Jy | Flux error of channel 22, come from the signal noise and the fluctuation of baseline. |
| 51 | flux_err_21 | double precision | Jy | Flux error of channel 21, come from the signal noise and the fluctuation of baseline. |
| 52 | flux_err_20 | double precision | Jy | Flux error of channel 20, come from the signal noise and the fluctuation of baseline. |
| 53 | flux_err_19 | double precision | Jy | Flux error of channel 19, come from the signal noise and the fluctuation of baseline. |
| 54 | flux_err_18 | double precision | Jy | Flux error of channel 18, come from the signal noise and the fluctuation of baseline. |
| 55 | flux_err_17 | double precision | Jy | Flux error of channel 17, come from the signal noise and the fluctuation of baseline. |
| 56 | flux_err_16 | double precision | Jy | Flux error of channel 16, come from the signal noise and the fluctuation of baseline. |
| 57 | flux_err_15 | double precision | Jy | Flux error of channel 15, come from the signal noise and the fluctuation of baseline. |
| 58 | flux_err_14 | double precision | Jy | Flux error of channel 14, come from the signal noise and the fluctuation of baseline. |
| 59 | flux_err_13 | double precision | Jy | Flux error of channel 13, come from the signal noise and the fluctuation of baseline. |
| 60 | flux_err_12 | double precision | Jy | Flux error of channel 12, come from the signal noise and the fluctuation of baseline. |
| 61 | flux_err_11 | double precision | Jy | Flux error of channel 11, come from the signal noise and the fluctuation of baseline. |
| 62 | flux_err_10 | double precision | Jy | Flux error of channel 10, come from the signal noise and the fluctuation of baseline. |
| 63 | flux_err_09 | double precision | Jy | Flux error of channel 9, come from the signal noise and the fluctuation of baseline. |
| 64 | flux_err_08 | double precision | Jy | Flux error of channel 8, come from the signal noise and the fluctuation of baseline. |
| 65 | flux_err_07 | double precision | Jy | Flux error of channel 7, come from the signal noise and the fluctuation of baseline. |
| 66 | flux_err_06 | double precision | Jy | Flux error of channel 6, come from the signal noise and the fluctuation of baseline. |
| 67 | flux_err_05 | double precision | Jy | Flux error of channel 5, come from the signal noise and the fluctuation of baseline. |
| 68 | flux_err_04 | double precision | Jy | Flux error of channel 4, come from the signal noise and the fluctuation of baseline. |
| 69 | flux_err_03 | double precision | Jy | Flux error of channel 3, come from the signal noise and the fluctuation of baseline. |
| 70 | flux_err_02 | double precision | Jy | Flux error of channel 2, come from the signal noise and the fluctuation of baseline. |
| 71 | flux_err_01 | double precision | Jy | Flux error of channel 1, come from the signal noise and the fluctuation of baseline. |
| 72 | quantity_of_events_24 | smallint | Num of Event data for ch24 | |
| 73 | quantity_of_events_23 | smallint | Num of Event data for ch23 | |
| 74 | quantity_of_events_22 | smallint | Num of Event data for ch22 | |
| 75 | quantity_of_events_21 | smallint | Num of Event data for ch21 | |
| 76 | quantity_of_events_20 | smallint | Num of Event data for ch20 | |
| 77 | quantity_of_events_19 | smallint | Num of Event data for ch19 | |
| 78 | quantity_of_events_18 | smallint | Num of Event data for ch18 | |
| 79 | quantity_of_events_17 | smallint | Num of Event data for ch17 | |
| 80 | quantity_of_events_16 | smallint | Num of Event data for ch16 | |
| 81 | quantity_of_events_15 | smallint | Num of Event data for ch15 | |
| 82 | quantity_of_events_14 | smallint | Num of Event data for ch14 | |
| 83 | quantity_of_events_13 | smallint | Num of Event data for ch13 | |
| 84 | quantity_of_events_12 | smallint | Num of Event data for ch12 | |
| 85 | quantity_of_events_11 | smallint | Num of Event data for ch11 | |
| 86 | quantity_of_events_10 | smallint | Num of Event data for ch10 | |
| 87 | quantity_of_events_09 | smallint | Num of Event data for ch9 | |
| 88 | quantity_of_events_08 | smallint | Num of Event data for ch8 | |
| 89 | quantity_of_events_07 | smallint | Num of Event data for ch7 | |
| 90 | quantity_of_events_06 | smallint | Num of Event data for ch6 | |
| 91 | quantity_of_events_05 | smallint | Num of Event data for ch5 | |
| 92 | quantity_of_events_04 | smallint | Num of Event data for ch4 | |
| 93 | quantity_of_events_03 | smallint | Num of Event data for ch3 | |
| 94 | quantity_of_events_02 | smallint | Num of Event data for ch2 | |
| 95 | quantity_of_events_01 | smallint | Num of Event data for ch1 | |
| 96 | quantity_of_events | smallint | Number of Events used in this source | |
| 97 | quantity_of_neaby_events | smallint | Number of nearby event groups | |
| 98 | quantity_of_counterpart_in_iras | smallint | Number of associations with IRAS PSC | |
| 99 | quantity_of_counterpart_in_2mass | smallint | Number of associations with 2MASS catalog | |
| 100 | quantity_of_counterpart_in_tycho | smallint | Number of associations with Tycho catalog | |
| 101 | quantity_of_counterpart_in_hipparcos | smallint | Number of associations with Hipparcos catalog | |
| 102 | object_id_in_other_scan | character varying(10) | NIRS name of associated PS in the other scan | |
| 103 | spectral_type | character varying(1) | Classified Type [C, S, M, U, r, p, n]------------------------------------ Char # description ------------------------------------ M 851 M-type C 91 C-type S 62 S-type U 6 3.3um UIR r 82 red with H2O at 3um p 1081 red without H2O at 3um n 1829 other earlier stars ------------------------------------ total 4002 (objects of good quality) |
|
| 104 | object_name_in_iras | character varying(10) | IRAS PSC name | |
| 105 | object_id_in_tycho | character varying(12) | Identifier in Tycho catalog | |
| 106 | reset_mode | smallint | Reset mode [0 = 1 minute, 1 = 1 second, 2 = mix] | |
| 107 | data_access_url | character varying(255) | URL of the catalog data |