[ English | Japanese ]

Searchable Data with the DARTS/Astro Query System

Schema of Tables about VSOP (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 Proposal, log, and correlated data information of the "VSOP (HALCA) Guest Observer Time" observations. halca_got_observation 622 Yes Yes
HALCA Log and correlated data information of the "VSOP (HALCA) 5 GHz AGN Survey" observations. halca_survey_observation 426 Yes Yes
HALCA Log and correlated data information of the VSOP (HALCA) test observations. halca_test_observation 75 Yes Yes
HALCA Analysis results of the "VSOP (HALCA) 5 GHz AGN Survey" observations. halca_survey_analysis 552 Yes Yes
HALCA Proposals for the "VSOP (HALCA) Guest Observer Time" observations. halca_got_proposal 261 No Yes

halca_got_observation

Log and correrated data information of the "VSOP (HALCA) Guest Observer Time" observations.
Some observations contain multiple radio sources. There are multiple correlated data, focused on each target or re-correlated.

No. Column Name Type Unit Description
1 observation_id character varying(16) Observation ID, created by DARTS.
The structure is observation_code + "_" + observation start date (YYYYMMDD format). This is not a unique ID in this table.
2 observation_code character varying(6) The observation code, created by VSOP project team.
The structure is <letter> <three digits> <letter> [<digit>].
Details is VSOP Observation codes.
3 ql_access_url character varying(255) URL to the observation information page
4 related_observation_code character varying(15) Related observation's observation_code
5 object_name character varying(10) The target source name in J2000 with the IAU standardized.
6 object_name_alternative character varying(200) The alternative name of the target source.
7 object_ra double precision degree Target position, Right Ascension J2000.
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
17 integration_time double precision sec Integration time.
18 quantity_of_if_channel smallint CH(count) Quantity of IF channels.
19 spectral_channel_quantity smallint CH(count) Quantity of spectrum channels per an IF channels.
20 observation_start_day_of_year smallint UTC Days of year about observation start date.
21 observation_start_date date UTC Start Date of the Observation in UTC.
22 observation_start_time timestamp without timezone UTC Start DateTime of the Observation in UTC.
23 observation_start_time_mjd double precision MJD Start DateTime of the Observation in MJD.
24 observation_end_time timestamp without timezone UTC Stop DateTime of the Observation in UTC.
25 observation_end_time_mjd double precision MJD Stop DateTime of the Observation in MJD.
26 exposure double precision ksec Estimated Total Observation Exposure. (ksec)
27 exposure_hour double precision Hour Estimated Total Observation Exposure. (hours)
28 quantity_of_ground_radio_telescope smallint Quantity of ground radio telescopes.
29 ground_radio_telescope character varying(100) Ground radio telescope. Each telescopes are separated with a space.
30 tracking_station character varying(100) Tracking stations. Each stations are separated with a space.
31 correlator character varying(10) Correlator
32 correlate_date date Correlated date
33 remarks text Remarks
34 data_access_url character varying(255) URL to the correlated data
35 proposal_id character varying(4) The proposal code, created by VSOP project team.
The structure is <letter> <three digits>.
Details is VSOP Observation codes.
36 proposal_title text Title of the proposal
37 pi_name character varying(255) Proposal Principal Investigator Name
38 proposal_ql_access_url character varying(255) URL to the quick look page of the proposal
39 proposal_access_url character varying(255) URL to the proposal data file

Scroll Back to Top ⏏

halca_survey_observation

Log and correrated data information of the "VSOP (HALCA) 5 GHz AGN Survey" observations.
Some observations contain multiple radio sources. There are multiple correlated data, focused on each target or re-correlated.

No. Column Name Type Unit Description
1 observation_id character varying(16) Observation ID, created by DARTS.
The structure is observation_code + "_" + observation start date (YYYYMMDD format). This is not a unique ID in this table.
2 observation_code character varying(6) The observation code, created by VSOP project team.
The structure is <letter> <three digits> <letter> [<digit>].
Details is VSOP Observation codes.
3 ql_access_url character varying(255) URL to the observation information page
4 related_observation_code character varying(15) Related General Observing Time(GOT) observation's observation_code
5 object_name character varying(10) The target source name in J2000 with the IAU standardized.
6 object_name_alternative character varying(200) The alternative name of the target source.
7 object_ra double precision degree Target position, Right Ascension J2000.
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 position_reference character varying(255) Reference about the target position.
17 frequency double precision GHz Frequency
18 integration_time double precision sec Integration time.
19 quantity_of_if_channel smallint CH(count) Quantity of IF channels.
20 spectral_channel_quantity smallint CH(count) Quantity of spectrum channels per an IF channels.
21 observation_start_year smallint UTC Start Year of the Observation in UTC.
22 observation_start_day_of_year smallint UTC Days of year about observation start date.
23 observation_start_date date UTC Start Date of the Observation in UTC.
24 observation_start_time timestamp without time zone UTC Start DateTime of the Observation in UTC.
25 observation_start_time_mjd double precision MJD Start DateTime of the Observation in MJD.
26 observation_end_time timestamp without time zone UTC Stop DateTime of the Observation in UTC.
27 observation_end_time_mjd double precision MJD Stop DateTime of the Observation in MJD.
28 exposure double precision ksec Estimated Total Observation Exposure. (ksec)
29 exposure_hour double precision Hour Estimated Total Observation Exposure. (hours)
30 flux_density double precision Jy Flux density
31 quantity_of_ground_radio_telescope smallint Quantity of ground radio telescopes.
32 ground_radio_telescope character varying(100) Ground radio telescope. Each telescopes are separated with a space.
33 tracking_station character varying(100) Tracking stations. Each stations are separated with a space.
34 correlator character varying(10) Correlator
35 correlate_date date Correlated date
36 remarks text Remarks
37 data_access_url character varying(255) URL to the correlated data

Scroll Back to Top ⏏

halca_test_observation

Log and correrated data information of the VSOP (HALCA) test observations.

No. Column Name Type Unit Description
1 observation_id character varying(16) Observation ID, created by DARTS.
The structure is observation_code + "_" + observation start date (YYYYMMDD format). This is not a unique ID in this table.
2 observation_code character varying(6) The observation code, created by VSOP project team.
The structure is <letter> <three digits> <letter> [<digit>].
Details is VSOP Observation codes.
3 ql_access_url character varying(255) URL to the observation information page
4 related_observation_code character varying(20) Related observation's observation_code
5 object_name character varying(10) The target source name in J2000 with the IAU standardized.
6 object_name_alternative character varying(200) The alternative name of the target source.
7 object_ra double precision degree Target position, Right Ascension J2000.
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
17 integration_time double precision sec Integration time.
18 quantity_of_if_channel smallint CH(count) Quantity of IF channels.
19 spectral_channel_quantity smallint CH(count) Quantity of spectrum channels per an IF channels.
20 observation_start_day_of_year smallint UTC Days of year about observation start date.
21 observation_start_date date UTC Start Date of the Observation in UTC.
22 observation_start_time timestamp without timezone UTC Start DateTime of the Observation in UTC.
23 observation_start_time_mjd double precision MJD Start DateTime of the Observation in MJD.
24 observation_end_time timestamp without timezone UTC Stop DateTime of the Observation in UTC.
25 observation_end_time_mjd double precision MJD Stop DateTime of the Observation in MJD.
26 exposure double precision ksec Estimated Total Observation Exposure. (ksec)
27 exposure_hour double precision Hour Estimated Total Observation Exposure. (hours)
28 quantity_of_ground_radio_telescope smallint Quantity of ground radio telescopes.
29 ground_radio_telescope character varying(100) Ground radio telescope. Each telescopes are separated with a space.
30 tracking_station character varying(100) Tracking stations. Each stations are separated with a space.
31 correlator character varying(10) Correlator
32 correlate_date date Correlated date
33 remarks text Remarks
34 data_access_url character varying(255) URL to the correlated data

Scroll Back to Top ⏏

halca_survey_analysis

Analysis results of the "VSOP (HALCA) 5 GHz AGN Survey" observations.
To complement its accuracy, the analysis was performed independently by multiple people and the results were collated.
Therefore, there may be multiple analysis results by multiple people for one observation data.

No. Column Name Type Unit Description
1 observation_code character varying(6) The observation code, created by VSOP project team.
The structure is <letter> <three digits> <letter> [<digit>].
Details is VSOP Observation codes.
2 observation_id character varying(16) Observation ID, created by DARTS.
The structure is observation_code + "_" + observation start date (YYYYMMDD format). This is not a unique ID in this table.
3 observation_status character varying(10) Observation status [Cancelled, Abandoned, Postponed] No special notes in the blank.
4 analyst character varying(16) Analyst name
5 analysis_status character varying(10) Analysis status. [Underway, Partially (=Analysis is partially complete but not all required results are available.) or Complete]
6 ql_image_url character varying(255) URL to the quick look image
7 ql_access_url character varying(255) URL to the quick look page of the analysis result
8 remarks text Remarks
9 related_observation_code character varying(15) Related General Observing Time(GOT) observation's observation_code
10 object_name character varying(10) The target source name in J2000 with the IAU standardized.
11 object_name_alternative character varying(200) The alternative name of the target source.
12 object_ra double precision degree Target position, Right Ascension J2000.
13 object_dec double precision degree Target position, Declinatoion J2000
14 object_ra_b1950 double precision degree Target position, Right Ascenstion B1950. Calculated from (object_ra, object_dec)
15 object_dec_b1950 double precision degree Target position, Declinatoion B1950. Calculated from (object_ra, object_dec)
16 object_ecliptic_lon double precision degree Target position, Ecliptic Longitude. Calculated from (object_ra, object_dec)
17 object_ecliptic_lat double precision degree Target position, Ecriptic Latitude. Calculated from (object_ra, object_dec)
18 object_galactic_lon double precision degree Target position, Galactic Longitude. Calculated from (object_ra, object_dec)
19 object_galactic_lat double precision degree Target position, Galactic Latitude. Calculated from (object_ra, object_dec)
20 coordinate_system character varying(8) Coordinate system of the data files.
21 position_reference character varying(255) Reference about the target position.
22 frequency double precision GHz Frequency
23 integration_time double precision sec Integration time.
24 quantity_of_if_channel smallint CH(count) Quantity of IF channels.
25 spectral_channel_quantity smallint CH(count) Quantity of spectrum channels per an IF channels.
26 observation_start_year smallint UTC Start Year of the Observation in UTC.
27 observation_start_day_of_year smallint UTC Days of year about observation start date.
28 observation_start_date date UTC Start Date of the Observation in UTC.
29 observation_start_time timestamp without time zone UTC Start DateTime of the Observation in UTC.
30 observation_start_time_mjd double precision MJD Start DateTime of the Observation in MJD.
31 observation_end_time timestamp without time zone UTC Stop DateTime of the Observation in UTC.
32 observation_end_time_mjd double precision MJD Stop DateTime of the Observation in MJD.
33 exposure double precision ksec Estimated Total Observation Exposure. (ksec)
34 exposure_hour double precision Hour Estimated Total Observation Exposure. (hours)
35 flux_density double precision Jy Flux density
36 quantity_of_ground_radio_telescope smallint Quantity of ground radio telescopes.
37 ground_radio_telescope character varying(100) Ground radio telescope. Each telescopes are separated with a space.
38 tracking_station character varying(100) Tracking stations. Each stations are separated with a space.
39 correlator character varying(10) Correlator
40 data_access_url character varying(255) URL to the analysis result data
41 is_tape_at_isas character varying(1) Indicates tape was at ISAS. Y(=Yes) or N (=No).

Scroll Back to Top ⏏

halca_got_proposal

Proposals for the "VSOP (HALCA) Guest Observer Time" observations.

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>.
Details is VSOP Observation codes.
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 ⏏

Last Modified: 15 June 2023