DARTS Astrophysical Data Search

[ English | Japanese ]


Schema of Tables about GINGA

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
GINGA LAC observation log. ginga_observation_log 7,318 OBS

ginga_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 Sequence number of the observation. The number begins with [yymm] where yy and mm is two-digit year and month, respectively, of the observation start. Last digit of the sequence number is 0 for a target observation and 9 for a background observation. digest / full SEQ_NO bigint(11)
2 target_name character varying(80) Target name. digest / full TARGET_NAME char(80)
3 center_ra_b1950 double precision degree The average coordinate of pointing direction, Right Ascension B1950. digest / full (*) AVE_ALPHA double degree
4 center_dec_b1950 double precision degree The average coordinate of pointing direction, Declination B1950. AVE_DELTA double degree
5 center_ra double precision degree The average coordinate of pointing direction, Right Ascension J2000. Calculated from (center_ra_b1950, center_dec_b1950).
6 center_dec double precision degree The average coordinate of pointing direction, Declination J2000. Calculated from (center_ra_b1950, center_dec_b1950).
7 center_ecliptic_lon double precision degree The average coordinate of pointing direction, Ecliptic Longitude. Calculated from (center_ra_b1950, center_dec_b1950).
8 center_ecliptic_lat double precision degree The average coordinate of pointing direction, Ecliptic Latitude. Calculated from (center_ra_b1950, center_dec_b1950).
9 center_galactic_lon double precision degree The average coordinate of pointing direction, Galactic Longitude. Calculated from (center_ra_b1950, center_dec_b1950).
10 center_galactic_lat double precision degree The average coordinate of pointing direction, Galactic Latitude. Calculated from (center_ra_b1950, center_dec_b1950).
11 max_ra_b1950 double precision degree Maximum coordinate of the pointing direction, Right Ascension B1950. digest / full (*) MAX_ALPHA double degree
12 max_dec_b1950 double precision degree Maximum coordinate of the pointing direction, Declination B1950. MAX_DELTA double degree
13 max_ra_J2000 double precision degree Maximum coordinate of the pointing direction, Right Ascension J2000. Calculated from (max_ra_b1950, max_dec_b1950).
14 max_dec_J2000 double precision degree Maximum coordinate of the pointing direction, Declination J2000. Calculated from (max_ra_b1950, max_dec_b1950).
15 max_ecliptic_lon double precision degree Maximum coordinate of the pointing direction, Ecliptic Longitude. Calculated from (max_ra_b1950, max_dec_b1950).
16 max_ecliptic_lat double precision degree Maximum coordinate of the pointing direction, Ecliptic Latitude. Calculated from (max_ra_b1950, max_dec_b1950).
17 max_galactic_lon double precision degree Maximum coordinate of the pointing direction, Galactic Longitude. Calculated from (max_ra_b1950, max_dec_b1950).
18 max_galactic_lat double precision degree Maximum coordinate of the pointing direction, Galactic Latitude. Calculated from (max_ra_b1950, max_dec_b1950).
19 min_ra_b1950 double precision degree Minimum coordinate of the pointing direction, Right Ascension B1950. digest / full (*) MIN_ALPHA double degree
20 min_dec_b1950 double precision degree Minimum coordinate of the pointing direction, Declination B1950. MIN_DELTA double degree
21 min_ra_J2000 double precision degree Minimum coordinate of the pointing direction, Right Ascension J2000. Calculated from (min_ra_b1950, min_dec_b1950).
22 min_dec_J2000 double precision degree Minimum coordinate of the pointing direction, Declination J2000. Calculated from (min_ra_b1950, min_dec_b1950).
23 min_ecliptic_lon double precision degree Minimum coordinate of the pointing direction, Ecliptic Longitude. Calculated from (min_ra_b1950, min_dec_b1950).
24 min_ecliptic_lat double precision degree Minimum coordinate of the pointing direction, Ecliptic Latitude. Calculated from (min_ra_b1950, min_dec_b1950).
25 min_galactic_lon double precision degree Minimum coordinate of the pointing direction, Galactic Longitude. Calculated from (min_ra_b1950, min_dec_b1950).
26 min_galactic_lat double precision degree Minimum coordinate of the pointing direction, Galactic Latitude. Calculated from (min_ra_b1950, min_dec_b1950).
27 elongation double precision degree Distance between the target and the poiting directions. digest / full RIKAKU double degree
28 observation_start_time timestamp without timezone UTC The start date of the observation in UTC. digest / full STARTTIME date UTC
29 observation_start_time_mjd double precision MJD The start date of the observation in MJD.
30 observation_end_time timestamp without timezone UTC The end date of the observation in UTC. digest / full ENDTIME date UTC
31 observation_end_time_mjd double precision MJD The end date of the observation in MJD.
32 exposure double precision ks The duration of the pointing. digest / full POINTING double hour
33 orbit_pass_name character varying(255) Orbit pass name. full PASSNAME char(80)
34 pi_name character varying(27) All records have ""GINGA"" in this column. full PI_NAME char(27)
35 metadata_create_date double precision UTC UTC date when this database table was created. All records have ""2004-06-25"" in this column. ENTRY_DATE date UTC
36 metadata_create_date_mjd double precision MJD MJD date when this database table was created. All records have ""53181"" (=""2004-06-25 in UTC"") in this column.
37 data_access_url character varying(255) URL used to access dataset digest / full

Go to top of this page ⏏

Last Modified: 19 November 2018