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
HALCA Observation log and correrated data information of the VSOP Guest Observer Time observation. halca_got_observation 622 Yes Yes
HALCA Proposals for the VSOP Guest Observer Time observation. halca_got_proposal 261 No Yes
HALCA Observation log and correrated data information of the VSOP 5 GHz AGN Survey. halca_survey_observation 426 Yes Yes
HALCA The analysis results of the VSOP 5 GHz AGN Survey. halca_survey_analysis 866 Yes Yes
HALCA Observation log and correrated data information of the VSOP test observation. halca_test_observation 75 Yes Yes

halca_got_observation

Observation log and correrated data information of the VSOP Guest Observer Time observation.

  • 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
1 observation_id character varying(16) Unique Observation Number, created by DARTS.
The structure is observation_code + "_" + observation start date (YYYYMMDD format).
digest / full
2 observation_code character varying(6) The observation code, created by VSOP project team.
The structure is <letter> <three digits> <letter> [<digit>].
Details is https://darts.isas.jaxa.jp/astro/halca/vsop/obs/observation_codes.html
digest / full
3 ql_access_url character varying(255) URL to the observation information page digest / full
4 related_observation_code character varying(15) Related observation's observation_code digest / full
5 target_name character varying(10) The target source name in J2000 with the IAU standardized. digest / full
6 target_name_alternative character varying(200) The alternative name of the target source. digest / full
7 object_ra double precision degree Target position, Right Ascension J2000. digest (*) / full
8 object_dec double precision degree Target position, Declinatoion J2000
9 object_ra_b1950 double precision degree Target position, Right Ascenstion B1950. Calculated from (object_ra, object_dec)
10 object_dec_b1950 double precision degree Target position, Declinatoion B1950. Calculated from (object_ra, object_dec)
11 object_ecliptic_lon double precision degree Target position, Ecliptic Longitude. Calculated from (object_ra, object_dec)
12 object_ecliptic_lat double precision degree Target position, Ecriptic Latitude. Calculated from (object_ra, object_dec)
13 object_galactic_lon double precision degree Target position, Galactic Longitude. Calculated from (object_ra, object_dec)
14 object_galactic_lat double precision degree Target position, Galactic Latitude. Calculated from (object_ra, object_dec)
15 coordinate_system character varying(8) Coordinate system of the data files.
16 frequency double precision GHz Frequency digest / full
17 integration_time double precision sec Integration time. digest / full
18 if_channel_quantity smallint CH(個) Quantity of IF channels. digest / full
19 spectral_channel_quantity smallint CH(個) Quantity of spectrum channels per an IF channels. digest / full
20 observation_start_day_of_year smallint Days of year about observation start date. full
21 observation_start_date date Start Date of the Observation in UTC. full
22 observation_start_time timestamp without timezone Start Time of the Observation in UTC. digest / full
23 observation_start_time_mjd double precision MJD Start Time of the Observation in MJD. full
24 observation_end_time timestamp without timezone Stop Time of the Observation in UTC. digest / full
25 observation_end_time_mjd double precision MJD Stop Time of the Observation in MJD. full
26 exposure double precision ksec Estimated Total Observation Exposure. (ksec) digest / full
27 exposure_hours double precision Hour Estimated Total Observation Exposure. (hours) digest / full
28 ground_radio_telescope_quantity smallint Quantity of ground radio telescopes. digest / full
29 ground_radio_telescope character varying(100) Ground radio telescope. Each telescopes are separated with a space. digest / full
30 tracking_station character varying(100) Tracking stations. Each stations are separated with a space. digest / full
31 correlator character varying(10) Correlator digest / full
32 correlate_date date Correlated date digest / full
33 remarks text Remarks digest / full
34 data_access_url character varying(255) URL to the correlated data digest / full
35 proposal_id character varying(4) The proposal code, created by VSOP project team. The structure is . digest / full
36 proposal_title text Title of the proposal digest / full
37 pi_name character varying(255) Proposal Principal Investigator Name digest / full
38 proposal_ql_access_url character varying(255) URL to the observation information page digest / full
39 proposal_access_url character varying(255) URL to the correlated data digest / full

Scroll Back to Top ⏏

halca_got_proposal

Proposals for the VSOP Guest Observer Time observation.

  • 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
1 proposal_id character varying(4) The proposal code, created by VSOP project team.
The structure is <letter> <three digits>.
2 pi_name character varying(255) Proposal Principal Investigator Name
3 proposal_title text Title of the proposal
4 ql_access_url character varying(255) URL to the quick look page of the proposal.
5 data_access_url character varying(255) URL to the proposal data file.

Scroll Back to Top ⏏

halca_survey_observation

Observation log and correrated data information of the VSOP 5 GHz AGN Survey.

  • 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
1 observation_id character varying(16) Unique Observation Number, created by DARTS.
The structure is observation_code + "_" + observation start date (YYYYMMDD format).
digest / full
2 observation_code character varying(6) The observation code, created by VSOP project team.
The structure is <letter> <three digits> <letter> [<digit>].
Details is https://darts.isas.jaxa.jp/astro/halca/vsop/obs/observation_codes.html
digest / full
3 ql_access_url character varying(255) URL to the observation information page digest / full
4 related_observation_code character varying(15) Related General Observing Time(GOT) observation's observation_code digest / full
5 target_name character varying(10) The target source name in J2000 with the IAU standardized. digest / full
6 target_name_alternative character varying(200) The alternative name of the target source. digest / full
7 object_ra double precision degree Target position, Right Ascension J2000. digest (*) / full
8 object_dec double precision degree Target position, Declinatoion J2000
9 object_ra_b1950 double precision degree Target position, Right Ascenstion B1950. Calculated from (object_ra, object_dec)
10 object_dec_b1950 double precision degree Target position, Declinatoion B1950. Calculated from (object_ra, object_dec)
11 object_ecliptic_lon double precision degree Target position, Ecliptic Longitude. Calculated from (object_ra, object_dec)
12 object_ecliptic_lat double precision degree Target position, Ecriptic Latitude. Calculated from (object_ra, object_dec)
13 object_galactic_lon double precision degree Target position, Galactic Longitude. Calculated from (object_ra, object_dec)
14 object_galactic_lat double precision degree Target position, Galactic Latitude. Calculated from (object_ra, object_dec)
15 coordinate_system character varying(8) Coordinate system of the data files. digest / full
16 position_reference character varying(255) Reference about the target position. full
17 frequency double precision GHz Frequency digest / full
18 integration_time double precision sec Integration time. digest / full
19 if_channel_quantity smallint CH(個) Quantity of IF channels. digest / full
20 spectral_channel_quantity smallint CH(個) Quantity of spectrum channels per an IF channels. digest / full
21 observation_start_year smallint Start Year of the Observation in MJD. full
22 observation_start_day_of_year smallint Days of year about observation start date. full
23 observation_start_date date Start Date of the Observation in UTC. full
24 observation_start_time timestamp without time zone Start Time of the Observation in UTC. digest / full
25 observation_start_time_mjd double precision MJD Start Time of the Observation in MJD. full
26 observation_end_time timestamp without time zone Stop Time of the Observation in UTC. digest / full
27 observation_end_time_mjd double precision MJD Stop Time of the Observation in MJD. full
28 exposure double precision ksec Estimated Total Observation Exposure. (ksec) digest / full
29 exposure_hours double precision Hour Estimated Total Observation Exposure. (hours) digest / full
30 flux_density double precision Jy Flux density digest / full
31 ground_radio_telescope_quantity smallint Quantity of ground radio telescopes. digest / full
32 ground_radio_telescope character varying(100) Ground radio telescope. Each telescopes are separated with a space. digest / full
33 tracking_station character varying(100) Tracking stations. Each stations are separated with a space. digest / full
34 correlator character varying(10) Correlator digest / full
35 correlate_date date Correlated date digest / full
36 remarks text Remarks digest / full
37 data_access_url character varying(255) URL to the correlated data digest / full

Scroll Back to Top ⏏

halca_survey_analysis

The analysis results of the VSOP 5 GHz AGN Survey.

  • 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
1 observation_id character varying(16) Unique Observation Number, created by DARTS.
The structure is observation_code + "_" + observation start date (YYYYMMDD format).
digest / full
2 observation_code character varying(6) The observation code, created by VSOP project team.
The structure is <letter> <three digits> <letter> [<digit>].
Details is https://darts.isas.jaxa.jp/astro/halca/vsop/obs/observation_codes.html
digest / full
3 analyst character varying(16) Analyst name digest / full
4 analysis_status character varying(10) Analysis status. [Underway, Partially (=Analysis is partially complete but not all required results are available.) or Complete] digest / full
5 ql_access_url character varying(255) URL to the quick look page of the analysis result digest / full
6 related_observation_code character varying(15) Related General Observing Time(GOT) observation's observation_code digest / full
7 target_name character varying(10) The target source name in J2000 with the IAU standardized. digest / full
8 target_name_alternative character varying(200) The alternative name of the target source. digest / full
9 object_ra double precision degree Target position, Right Ascension J2000. digest (*) / full
10 object_dec double precision degree Target position, Declinatoion J2000
11 object_ra_b1950 double precision degree Target position, Right Ascenstion B1950. Calculated from (object_ra, object_dec)
12 object_dec_b1950 double precision degree Target position, Declinatoion B1950. Calculated from (object_ra, object_dec)
13 object_ecliptic_lon double precision degree Target position, Ecliptic Longitude. Calculated from (object_ra, object_dec)
14 object_ecliptic_lat double precision degree Target position, Ecriptic Latitude. Calculated from (object_ra, object_dec)
15 object_galactic_lon double precision degree Target position, Galactic Longitude. Calculated from (object_ra, object_dec)
16 object_galactic_lat double precision degree Target position, Galactic Latitude. Calculated from (object_ra, object_dec)
17 coordinate_system character varying(8) Coordinate system of the data files. digest / full
18 position_reference character varying(255) Reference about the target position. full
19 frequency double precision GHz Frequency digest / full
20 integration_time double precision sec Integration time. digest / full
21 if_channel_quantity smallint CH(個) Quantity of IF channels. digest / full
22 spectral_channel_quantity smallint CH(個) Quantity of spectrum channels per an IF channels. digest / full
23 observation_start_year smallint Start Year of the Observation in MJD. full
24 observation_start_day_of_year smallint Days of year about observation start date. full
25 observation_start_date date Start Date of the Observation in UTC. full
26 observation_start_time timestamp without time zone Start Time of the Observation in UTC. digest / full
27 observation_start_time_mjd double precision MJD Start Time of the Observation in MJD. full
28 observation_end_time timestamp without time zone Stop Time of the Observation in UTC. digest / full
29 observation_end_time_mjd double precision MJD Stop Time of the Observation in MJD. full
30 exposure double precision ksec Estimated Total Observation Exposure. (ksec) digest / full
31 exposure_hours double precision Hour Estimated Total Observation Exposure. (hours) digest / full
32 flux_density double precision Jy Flux density digest / full
33 ground_radio_telescope_quantity smallint Quantity of ground radio telescopes. digest / full
34 ground_radio_telescope character varying(100) Ground radio telescope. Each telescopes are separated with a space. digest / full
35 tracking_station character varying(100) Tracking stations. Each stations are separated with a space. digest / full
36 correlator character varying(10) Correlator digest / full
37 correlate_date date Correlated date digest / full
38 remarks text Remarks digest / full
39 data_access_url character varying(255) URL to the analysis result data digest / full
40 is_tape_at_isas character varying(1) Indicates tape was at ISAS. Y(=Yes) or N (=No). full

Scroll Back to Top ⏏

halca_test_observation

Observation log and correrated data information of the VSOP test observation.

  • 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
1 observation_id character varying(16) Unique Observation Number, created by DARTS.
The structure is observation_code + "_" + observation start date (YYYYMMDD format).
digest / full
2 observation_code character varying(6) The observation code, created by VSOP project team.
The structure is <letter> <three digits> <letter> [<digit>].
Details is https://darts.isas.jaxa.jp/astro/halca/vsop/obs/observation_codes.html
digest / full
3 ql_access_url character varying(255) URL to the observation information page digest / full
4 related_observation_code character varying(20) Related observation's observation_code digest / full
5 target_name character varying(10) The target source name in J2000 with the IAU standardized. digest / full
6 target_name_alternative character varying(200) The alternative name of the target source. digest / full
7 object_ra double precision degree Target position, Right Ascension J2000. digest (*) / full
8 object_dec double precision degree Target position, Declinatoion J2000
9 object_ra_b1950 double precision degree Target position, Right Ascenstion B1950. Calculated from (object_ra, object_dec)
10 object_dec_b1950 double precision degree Target position, Declinatoion B1950. Calculated from (object_ra, object_dec)
11 object_ecliptic_lon double precision degree Target position, Ecliptic Longitude. Calculated from (object_ra, object_dec)
12 object_ecliptic_lat double precision degree Target position, Ecriptic Latitude. Calculated from (object_ra, object_dec)
13 object_galactic_lon double precision degree Target position, Galactic Longitude. Calculated from (object_ra, object_dec)
14 object_galactic_lat double precision degree Target position, Galactic Latitude. Calculated from (object_ra, object_dec)
15 coordinate_system character varying(8) Coordinate system of the data files. digest / full
16 frequency double precision GHz Frequency digest / full
17 integration_time double precision sec Integration time. digest / full
18 if_channel_quantity smallint CH(個) Quantity of IF channels. digest / full
19 spectral_channel_quantity smallint CH(個) Quantity of spectrum channels per an IF channels. digest / full
20 observation_start_day_of_year smallint Days of year about observation start date. full
21 observation_start_date date Start Date of the Observation in UTC. full
22 observation_start_time timestamp without timezone Start Time of the Observation in UTC. digest / full
23 observation_start_time_mjd double precision MJD Start Time of the Observation in MJD. full
24 observation_end_time timestamp without timezone Stop Time of the Observation in UTC. digest / full
25 observation_end_time_mjd double precision MJD Stop Time of the Observation in MJD. full
26 exposure double precision ksec Estimated Total Observation Exposure. (ksec) digest / full
27 exposure_hours double precision Hour Estimated Total Observation Exposure. (hours) digest / full
28 ground_radio_telescope_quantity smallint Quantity of ground radio telescopes. digest / full
29 ground_radio_telescope character varying(100) Ground radio telescope. Each telescopes are separated with a space. digest / full
30 tracking_station character varying(100) Tracking stations. Each stations are separated with a space. digest / full
31 correlator character varying(10) Correlator digest / full
32 correlate_date date Correlated date digest / full
33 remarks text Remarks digest / full
34 data_access_url character varying(255) URL to the correlated data digest / full

Scroll Back to Top ⏏

Last Modified: 14 January 2020