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.
| 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 quick look page of the proposal | digest / full | |
| 39 | proposal_access_url | character varying(255) | URL to the proposal data file | digest / full |
halca_got_proposal
Proposals for the VSOP Guest Observer Time observation.
| 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. |
halca_survey_observation
Observation log and correrated data information of the VSOP 5 GHz AGN Survey.
| 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 ｔｈｅ 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 |
halca_survey_analysis
The analysis results of the VSOP 5 GHz AGN Survey.
| 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 ｔｈｅ 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 |
halca_test_observation
Observation log and correrated data information of the VSOP test observation.
| 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 |