DARTS Astrophysical Data Search

[ English | Japanese ]


Schema of Tables about ASCA

Satelite/Project Abstract of the data product Database table name Number of entries in the database Searhcable with Basic Search Searchable with SQL/ADQL Search Name in the previous query system
ASCA Observation log.
This was created based on ASCA Observation List prodived by the ASCA team. There was no change since 2000-10-26.
asca_observation_log 3,079 OBS
ASCA Processing version of each sequence data file. asca_processing_info 3,079 PUBD
ASCA Information about each proposal. asca_proposal 3,497 PROPOSAL

asca_observation_log

The basic information of the sequence observation is recorded.

No. Column Name Type Unit Description Output with Basic Search Old Column Name Old Type Old Unit
1 observation_id bigint The sequence number of the observation. digest / full SEQ_NO bigint(11)
2 target_name character varying(25) The name of the target provided by the Principal Investigator (PI) of the observation. digest / full TARGET_NAME char(25)
3 proposal_ra double precision degree The target position provided by the PI for observation, Right Ascension J2000. digest / full TARGET_RA double degree
4 proposal_dec double precision degree The target position provided by the PI for observation, Declination J2000. digest / full TARGET_DEC double degree
5 euler1 double precision degree The 1st euler angles of the observation. digest / full EULER_1 double degree
6 euler2 double precision degree The 2nd euler angles of the observation. digest / full EULER_2 double degree
7 euler3 double precision degree The 3rd euler angles of the observation. digest / full 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. digest / full (*) 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. digest / full 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. digest / full OFFSET_Y double mm
18 observation_start_time timestamp without timezone UTC The start time of the observation (FRF start time) in UTC. digest / full 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. full 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 ks The exposure times of the GIS. digest / full EXPT_GIS double ks
23 sis_exposure double precision ks The exposure times of the SIS. digest / full EXPT_SIS double ks
24 pi_name character varying(255) The last name of the PI of the observation. digest / full 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 digest / full

Go to top of this page ⏏

asca_processing_info

Processing version of each sequence data file.

No. Column Name Type Unit Description Output with Basic Search Old Column Name Old Type Old 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

Go to top of this page ⏏

asca_proposal

No. Column Name Type Unit Description Output with Basic Search Old Column Name Old Type Old Unit
1 observation_id bigint The sequence number of the observation. digest / full SEQ_NO bigint(11)
2 proposal_id integer The proposal number. digest / full 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) ] full TYPE smallint(3)
4 proposal_ra double precision degree The target position provided by the PI for observation, Right Ascension J2000. digest / full (*) 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. digest / full TAR_NAME char(20)
13 proposal_exposure double precision ks The total accepted observation time. full 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) ] full TIMCR char(1)
15 has_special_request_flag character(1) Whether the observation has special request or not. [ Y (=yes) or N (=no) ] full SPEC_REQ char(1)
16 is_offset_flag character(1) Whether the observation is off-set poing or nor. [ Y (=yes) or N (=no) ] full OFFSET char(1)
17 target_category smallint The target category of the observations. full SUB_CAT smallint(2)
18 proposal_priority smallint The priority of the selection. full INT_PRIOR smallint(2)
19 pi_name_jpn character varying(255) The names of the PI of the observation at Japan side. digest / full 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. digest / full US_PI_LNAME char(27)
US_PI_FNAME char(12)
21 pi_nationality character varying(10) The nationallity of the PI. full JAPAN_COUNTRY char(10)
22 gis_observation_mode character varying(4) The GIS mode proposed by the PI. full GIS_MODE char(4)
23 sis0_observation_mode character varying(11) The SIS (S0) observation mode proposed by the PI. full SIS0_DATA char(11)
24 sis0_clock_mode smallint The SIS (S0) read-out mode proposed by the PI. full SIS0_CLOCK smallint(2)
25 sis1_observation_mode character varying(11) The SIS (S1) observation mode proposed by the PI. full SIS1_DATA char(11)
26 sis1_clock_mode smallint The SIS (S1) read-out mode proposed by the PI. full SIS1_CLOCK smallint(2)
27 recorder_bit_rate character(1) The bit-rate of the data recorder proposed by the PI. full BIT_RATE char(1)
28 predicted_sis_count_rate double precision The predicted SIS count rate in (c/s/SIS). full 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 digest / full

Go to top of this page ⏏

Last Modified: 19 November 2018