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 Yes Yes OBS
ASCA Processing version of each sequence data file. asca_processing_info 3,079 No Yes PUBD
ASCA Information about each proposal. asca_proposal 3,497 Yes Yes PROPOSAL

asca_observation_log

The basic information of the sequence observation is recorded.

  • Columns to display in the Basic Search can be chosen either "digest" or "full" in the "Display" menu.
  • (*) means that the same coordinates as specified in the Basic Search "Coordinate" are displayed in the "digest" mode. If you use TargetName, Equatorial J2000 will be displayed.
  • On SQL Search and ADQL Search, all the columns are available, including columns marked "no output" in this table.
No. Column Name Type Unit Description Output with Basic Search Former Column Name Former Type Former 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. no output
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. no output
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) no output ENTRY_DATE date UTC
26 metadata_create_date_mjd double precision MJD The registration date to this table. (MJD) no output
27 data_access_url character varying(255) URL used to access dataset digest / full

Scroll Back to Top ⏏

asca_processing_info

Processing version of each sequence data file.

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

Proposal list of ASCA observations.

  • Columns to display in the Basic Search can be chosen either "digest" or "full" in the "Display" menu.
  • (*) means that the same coordinates as specified in the Basic Search "Coordinate" are displayed in the "digest" mode. If you use TargetName, Equatorial J2000 will be displayed.
  • On SQL Search and ADQL Search, all the columns are available, including columns marked "no output" in this table.
No. Column Name Type Unit Description Output with Basic Search Former Column Name Former Type Former 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. no output 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. no output
31 data_access_url character varying(255) URL used to access dataset digest / full

Scroll Back to Top ⏏

Last Modified: 01 February 2019