DARTS Astrophysical Data Search

[ English | Japanese ]


Schema of Tables about HALCA

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
HALCA Observation log. halca_observation_log 45 OBS

halca_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 character(10) The sequence number of the observation. The first charactor is v or w. The second character is t, s or numerical value, they means the category of proposal. "t" is TEST, "s" is SURVEY, and numerical value is Guest Observer Time. The category of proposal has also been recorded at the column proposal_category in this table. digest / full OBS_CODE char(10)
2 target_name character varying(25) The target name 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. full TARGET_RA double
4 proposal_dec double precision degree The target position provided by the PI for observation, Declination J2000. full TARGET_DEC double
5 center_ra double precision degree Nominal satellite pointing direction, Right Ascension J2000. digest / full (*) RA double
6 center_dec double precision degree Nominal satellite pointing direction, Declination J2000. DEC double
7 center_ra_b1950 double precision degree Nominal satellite pointing direction, Right Ascension B1950. Calculated from (center_ra, center_dec)
8 center_dec_b1950 double precision degree Nominal satellite pointing direction, Declination B1950. Calculated from (center_ra, center_dec).
9 center_ecliptic_lon double precision degree Nominal satellite pointing direction, Ecliptic Longitude. Calculated from (center_ra, center_dec)
10 center_ecliptic_lat double precision degree Nominal satellite pointing direction, Ecliptic Latitude. Calculated from (center_ra, center_dec).
11 center_galactic_lon double precision degree Nominal satellite pointing direction, Galactic Longitude. Calculated from (center_ra, center_dec)
12 center_galactic_lat double precision degree Nominal satellite pointing direction, Galactic Latitude. Calculated from (center_ra, center_dec).
13 coordinate_system character varying(8) Reference coordinate system of the data files. full REF_COORD_FRAME char(8)
14 frequentry double precision Observed frequentry. digest / full FREQUENCY double
15 pi_name character varying(50) The names of the PI of the observation. full PI_NAME char(50)
16 exposure double precision ks Effective Total Observation Exposure. digest / full ELAPSED_TIME double ksec
17 correlator character varying(25) Correlator digest / full CORRELATOR char(25)
18 integration_time double precision sec Integration time. Sampling interval of received signal. full INTEGR_TIME double sec
19 channel_quantity double precision Number of spectral channels. full NUMBER_CHANNELS double
20 ground_radio_telescope character varying(255) Graund Radio Telescope digest / full GRT char(50)
21 correlate_date date The finish date of correlation. full COR_DATE date
22 observation_start_time date UTC Start Time of the Observation in UTC. digest / full START_TIME date UTC
23 observation_start_time_mjd double precision MJD Start Time of the Observation in MJD.
24 observation_end_time date UTC End Time of the Observation in UTC. digest / full END_TIME date UTC
25 observation_end_time_mjd double precision MJD End Time of the Observation in MJD.
26 proposal_category character varying(15) Category of the proposal. [ TEST, SURVEY, GOT (= Guest Observer Time) ] full OBS_CATEGORY char(15)
27 remarks text remarks of the satellite/instruments operation, if any. digest / full
28 data_access_url character varying(255) URL used to access dataset digest / full

Go to top of this page ⏏

Last Modified: 28 August 2018