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 | object_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 | euler_angle_1 | double precision | degree | The 1st euler angles of the observation. | EULER_1 | double | degree |
6 | euler_angle_2 | double precision | degree | The 2nd euler angles of the observation. | EULER_2 | double | degree |
7 | euler_angle_3 | 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 | 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 | 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 | db_create_date | timestamp without timezone | UTC | The registration date to this table. (UTC) | ENTRY_DATE | date | UTC |
26 | db_create_date_mjd | double precision | MJD | The registration date to this table. (MJD) | ― | ― | ― |
27 | data_access_url | character varying(255) | URL to the dataset | ― | ― | ― |
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 | db_create_date | timestamp without timezone | UTC | The registration date to this table. (UTC) | ENTRY_DATE | date | |
9 | db_create_date_mjd | double precision | MJD | The registration date to this table. (MJD) | ― | ― | ― |
10 | data_access_url | character varying(255) | URL to the dataset | ― | ― | ― |
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 | object_name | character varying(20) | The name of the target provided by the PI of the observation. | TAR_NAME | char(20) | ||
13 | awarded_exposure | double precision | ksec | The total accepted observation time. | TOT_OBS_TIME | double(8,2) | ks |
14 | is_time_critical | character(1) | Whether the observation is time-critical or not. [ Y (=yes) or N (=no) ] | TIMCR | char(1) | ||
15 | has_special_request | character(1) | Whether the observation has special request or not. [ Y (=yes) or N (=no) ] | SPEC_REQ | char(1) | ||
16 | is_offset | character(1) | Whether the observation is off-set poing or nor. [ Y (=yes) or N (=no) ] | OFFSET | char(1) | ||
17 | object_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 | proposal_affiliated_country | 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 | db_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 | db_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 to the dataset | ― | ― | ― |