DARTS Astrophysical Data Search

[ English | Japanese ]


Schema of Tables about ASCA

Satelite/Project Abstract of the data product Database table name
(Jump to description of table columns)
Number of entries in the database Searhcable with Basic Search Searchable with SQL/ADQL Search Name in the previous query system
ASCA Observation log based on the observation list provided by the ASCA team. Last updated on 2000-10-26. asca_observation_log 3,079 Yes Yes OBS
ASCA Processing version of each sequence of ASCA observations. asca_processing_info 3,079 No Yes PUBD
ASCA Abstracts of ASCA proposals. asca_proposal 3,497 Yes Yes PROPOSAL

asca_observation_log

Observation log based on the observation list provided by the ASCA team. Last updated on 2000-10-26.

No. Column Name Type Unit Description Former Column Name Former Type Former Unit
1 observation_id bigint The sequence number of the observation. SEQ_NO bigint(11)
2 target_name character varying(25) The name of the target provided by the Principal Investigator (PI) of the observation. TARGET_NAME char(25)
3 proposal_ra double precision degree The target position provided by the PI for observation, Right Ascension J2000. TARGET_RA double degree
4 proposal_dec double precision degree The target position provided by the PI for observation, Declination J2000. TARGET_DEC double degree
5 euler1 double precision degree The 1st euler angles of the observation. EULER_1 double degree
6 euler2 double precision degree The 2nd euler angles of the observation. EULER_2 double degree
7 euler3 double precision degree The 3rd euler angles of the observation. EULER_3 double degree
8 center_ra double precision degree The center of the field of view, Right Ascension J2000. (0,0) in the operational coordinate. FOV_RA double degree
9 center_dec double precision degree The center of the field of view, Declination J2000. (0,0) in the operational coordinate. FOV_DEC double degree
10 center_ra_b1950 double precision degree The center of the field of view, Right Ascension B1950. Calculated from (center_ra, center_dec).
11 center_dec_b1950 double precision degree The center of the field of view, Declination B1950. Calculated from (center_ra, center_dec).
12 center_ecliptic_lon double precision degree The center of the field of view, Ecliptic Longitude. Calculated from (center_ra, center_dec).
13 center_ecliptic_lat double precision degree The center of the field of view, Ecliptic Latitude. Calculated from (center_ra, center_dec).
14 center_galactic_lon double precision degree The center of the field of view, Galactic Longitude. Calculated from (center_ra, center_dec).
15 center_galactic_lat double precision degree The center of the field of view, Galactic Latitude. Calculated from (center_ra, center_dec).
16 offset_x_axis double precision mm The offset distance of the target position from the the center of the field of view. (X,Y) are the satellite axis. OFFSET_X double mm
17 offset_y_axis double precision mm The offset distance of the target position from the the center of the field of view. (X,Y) are the satellite axis. OFFSET_Y double mm
18 observation_start_time timestamp without timezone UTC The start time of the observation (FRF start time) in UTC. STARTTIME date UTC
19 observation_start_time_mjd double precision MJD The start time of the observation (FRF start time) in MJD.
20 observation_end_time timestamp without timezone UTC The end time of the observation (FRF stop time) in UTC. ENDTIME date UTC
21 observation_end_time_mjd double precision MJD The end time of the observation (FRF stop time) in MJD.
22 gis_exposure double precision ksec The exposure times of the GIS. EXPT_GIS double ks
23 sis_exposure double precision ksec The exposure times of the SIS. EXPT_SIS double ks
24 pi_name character varying(255) The last name of the PI of the observation. PI_NAME char(27)
25 metadata_create_date timestamp without timezone UTC The registration date to this table. (UTC) ENTRY_DATE date UTC
26 metadata_create_date_mjd double precision MJD The registration date to this table. (MJD)
27 data_access_url character varying(255) URL used to access dataset

Scroll Back to Top ⏏

asca_processing_info

Processing version of each sequence of ASCA observations.

No. Column Name Type Unit Description Former Column Name Former Type Former Unit
1 observation_id bigint The sequence number of the observation. SEQ_NO bigint(11)
2 product_revision smallint Product Revision REVISION double
3 processing_version smallint Latest processing version LATEST_PROC_VER double
4 expect_public_date timestamp without timezone UTC Expected Public Date in UTC EXPECT_DATE date UTC
5 expect_public_date_mjd double precision MJD Expected Public Date in MJD
6 public_date timestamp without timezone UTC Public Date in UTC ACTUAL_PUBLIC_DATE date UTC
7 public_date double precision MJD Public Date in MJD
8 metadata_create_date timestamp without timezone UTC The registration date to this table. (UTC) ENTRY_DATE date
9 metadata_create_date_mjd double precision MJD The registration date to this table. (MJD)
10 data_access_url character varying(255) URL used to access dataset

Scroll Back to Top ⏏

asca_proposal

Abstracts of ASCA proposals.

No. Column Name Type Unit Description Former Column Name Former Type Former Unit
1 observation_id bigint The sequence number of the observation. SEQ_NO bigint(11)
2 proposal_id integer The proposal number. PRNB int(7)
3 collabo_type smallint The type of the collaboration of the observation. [ 0(=no setting), 1(=JPN), 2(=US), 3(=Joint Japan/US, ie Japan PI with US cois), 4(=Joint US/Japan, ie US PI with Japan cois), 7(=Merged Japan/US, ie Japan PPI and US co-PI), 8(=Merged US/Japan, ie US PPI and Japan co-PI), 11(=ESA/Japan) ] TYPE smallint(3)
4 proposal_ra double precision degree The target position provided by the PI for observation, Right Ascension J2000. RA double degree
5 proposal_dec double precision degree The target position provided by the PI for observation, Declination J2000. DEC double degree
6 proposal_ra_b1950 double precision degree The target position provided by the PI for observation, Right Ascension B1950. Calculated from (proposal_ra, proposal_dec).
7 proposal_dec_b1950 double precision degree The target position provided by the PI for observation, Declination B1950. Calculated from (proposal_ra, proposal_dec).
8 proposal_ecliptic_lon double precision degree The target position provided by the PI for observation, Ecliptic Longitude. Calculated from (proposal_ra, proposal_dec).
9 proposal_ecliptic_lat double precision degree The target position provided by the PI for observation, Ecliptic Latitude. Calculated from (proposal_ra, proposal_dec).
10 proposal_galactic_lon double precision degree The target position provided by the PI for observation, Galactic Longitude. Calculated from (proposal_ra, proposal_dec).
11 proposal_galactic_lat double precision degree The target position provided by the PI for observation, Galactic Latitude. Calculated from (proposal_ra, proposal_dec).
12 target_name character varying(20) The name of the target provided by the PI of the observation. TAR_NAME char(20)
13 proposal_exposure double precision ksec The total accepted observation time. TOT_OBS_TIME double(8,2) ks
14 is_time_critical_flag character(1) Whether the observation is time-critical or not. [ Y (=yes) or N (=no) ] TIMCR char(1)
15 has_special_request_flag character(1) Whether the observation has special request or not. [ Y (=yes) or N (=no) ] SPEC_REQ char(1)
16 is_offset_flag character(1) Whether the observation is off-set poing or nor. [ Y (=yes) or N (=no) ] OFFSET char(1)
17 target_category smallint The target category of the observations. SUB_CAT smallint(2)
18 proposal_priority smallint The priority of the selection. INT_PRIOR smallint(2)
19 pi_name_jpn character varying(255) The names of the PI of the observation at Japan side. JAPAN_PI_LNAME char(27)
JAPAN_PI_FNAME char(12)
20 pi_name_us character varying(255) The names of the PI of the observation at U.S. side. US_PI_LNAME char(27)
US_PI_FNAME char(12)
21 pi_nationality character varying(10) The nationallity of the PI. JAPAN_COUNTRY char(10)
22 gis_observation_mode character varying(4) The GIS mode proposed by the PI. GIS_MODE char(4)
23 sis0_observation_mode character varying(11) The SIS (S0) observation mode proposed by the PI. SIS0_DATA char(11)
24 sis0_clock_mode smallint The SIS (S0) read-out mode proposed by the PI. SIS0_CLOCK smallint(2)
25 sis1_observation_mode character varying(11) The SIS (S1) observation mode proposed by the PI. SIS1_DATA char(11)
26 sis1_clock_mode smallint The SIS (S1) read-out mode proposed by the PI. SIS1_CLOCK smallint(2)
27 recorder_bit_rate character(1) The bit-rate of the data recorder proposed by the PI. BIT_RATE char(1)
28 predicted_sis_count_rate double precision The predicted SIS count rate in (c/s/SIS). PRED_SIS_CTS double
29 metadata_create_date timestamp without timezone UTC The registration date to the ODB(Observation Data Base) which was managed by X-ray group. ENTRY_DATE date
30 metadata_create_date_mjd double precision MJD The registration date to the ODB(Observation Data Base) which was managed by X-ray group.
31 data_access_url character varying(255) URL used to access dataset

Scroll Back to Top ⏏

Last Modified: 22 April 2021