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.
| 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 | ― | ― | ― |
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 | ― | ― | ― |
asca_proposal
Proposal list of ASCA observations.
| 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 | ― | ― | ― |