DARTS/Astro Query System

[ English| Japanese]


Searchable Data with the DARTS Astro Query System

DARTS/Astro Query System has description of each data product in the database, so that you can easily and quickly search the data you want by sending a specific query to the database. In this page, we explain all the data products searchable within DARTS/Astro Query System. Also, we explain auxiliary database items which we added to the original tables.

Database items of each table for every satelite/project:

We are going to register all the available data under the DARTS Astrophysics category onto the DARTS/Astro Query System, so that all the DARTS Astro data are searchable.


Stored data products and tables

DARTS/Astro Query System maintain various data products explained in the following tables. Detail of each table is shown in the linked page from each table name. Also, please find the "Additional data items", which make all the tables handled consistently.

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
AKARI Information about each file,
with "AKARI Far-infrared All-Sky Survey Maps Version 2.1 (Public release version 1)"
akari_fis_allskymap_2_1 6,688 Yes Yes akari_fis_allskymap_2_1 on DARTS/AKARI DAS
AKARI Catalogue data,
with "AKARI FIS All-Sky Survey Bright Source Catalogue Version 1.0"
akari_fis_bsc_1 427,071 Yes Yes akari_fis_bsc_1 on DARTS/AKARI CAS
AKARI Catalogue data,
with "AKARI IRC All-Sky Survey Point Source Catalogue Version 1.0"
akari_irc_psc_1 870,973 Yes Yes akari_irc_psc_1 on DARTS/AKARI CAS
AKARI Catalogue data,
with "AKARI NEP-Deep Mid-Infrared Source Catalogue Version 2"
akari_irc_nep_deep_psc_2 27,770 Yes Yes
AKARI Catalogue data,
with "AKARI NEP-Wide IR Source Catalogue Version 1"
akari_irc_nep_wide_psc_1 114,794 Yes Yes
AKARI Catalogue data,
with "AKARI-LMC Point Source Catalogue Version 1"
This contains all the detected sources by "AKARI" observations, named "Archive" by the author.
akari_irc_lmc_psc_1_all 802,285 Yes Yes
AKARI Catalogue data,
with "AKARI-LMC Point Source Catalogue Version 1"
This includes only the sources that have a counterpart in the Spitzer SAGE point-source catalog, named "Catalog" by the author.
akari_irc_lmc_psc_1_sage 660,286 Yes Yes
AKARI Information about each package file,
with "AKARI Pointed Observation Raw Data Version 1 (Phase 1&2) and Version 2 (Phase 3)"
akari_pointed_rawdata_package_info 24,436 Yes Yes PKGINFO
ASCA Observation log.
This was created based on ASCA Observation List prodived by the ASCA team. There was no change since 2000-10-26.
asca_observation_log 3,079 Yes Yes OBS
ASCA Processing version of each sequence data file. asca_processing_info 3,079 No Yes PUBD
ASCA Information about each proposal. asca_proposal 3,497 Yes Yes PROPOSAL
GINGA LAC observation log. ginga_observation_log 7,318 Yes Yes OBS
GINGA Light-curves of 208 point sources by ASM. ginga_asm_1_2 208 Yes Yes -
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
HITOMI Information for the observations obtained with HITOMI and provides access to the data archive. hitomi_master_data_1 42 Yes Yes
HITOMI Information for the observations including the coordinate of detector position obtained with HITOMI SXS, and provides access to the data archive. hitomi_sxs_data_1 42 Yes Yes
HITOMI Information for the observations including the coordinate of detector position obtained with HITOMI SXI, and provides access to the data archive. hitomi_sxi_data_1 28 Yes Yes
HITOMI Information for the observations including the coordinate of detector position obtained with HITOMI HXI, and provides access to the data archive. hitomi_hxi_data_1 40 Yes Yes
SUZAKU List of papers and authors written that. suzaku_author_in_paper 8,592 No Yes AUTHORS
SUZAKU Information of distribution data. suzaku_distribution_info 3,182 No Yes SEQ_DATA
SUZAKU Summary of observations and data calibration. It could be used as the master table.
Based on SUZAKU Archive which was shared with NASA/GSFC, this table was created by adding necessary data.
suzaku_master_data 3,055 Yes Yes MASTER
SUZAKU List of papers and observation data used in that. suzaku_observation_in_paper 4,187 No Yes REFOBS
SUZAKU Observation log.
The basic information of the sequence observation is recorded.
suzaku_observation_log 3,184 Yes Yes LOG
SUZAKU List of papers using SUZAKU data. suzaku_paper 910 No Yes TITLES
SUZAKU Processing version of each sequence data file. suzaku_processing_info 3,055 No Yes PROCVER
SUZAKU XIS operation log.
Based on SUZAKU Archive which was shared with NASA/GSFC, this table was created by adding necessary data.
suzaku_xis_observation_log 17,286 Yes Yes XISLOG

To the Top of the Page ⏏


Additional auxiliary database items

Below, we explain the auxiliary database items in the DARTS/Astro Query System which have been added to the original information of the data products.

Items on the coordinates

Data products are usually maintenanced based on a single coordinate system. However, when you search data, it is more convenient if you can use any coordinates depending on your needs. Accordingly, in the DARTS/Astro Query System, we register the four coordinate values; equatorial coordinates (both J2000 and B1950), ecliptic coordinates and galactic coordinates. These database items are distinguished by suffixes to tell the coordinates:

  • Equatorial coordinate (J2000) ・・・ _ra, _dec
  • Equatorial coordinate (B1950) ・・・ _ra_b1950, _dec_b1950
  • Ecliptic coordinate ・・・ _ecliptic_longitude, _ecliptic_latitude
  • Galactic coordinate ・・・ _galactic_longitude, _galactic_latitude

For example, if a data product has the observation center coordinates, the database has all the following items:

  • Equatorial coordinate (J2000) ・・・ center_ra, center_dec
  • Equatorial coordinate (B1950) ・・・ center_ra_b1950, center_dec_b1950
  • Ecliptic coordinate ・・・ center_ecliptic_longitude, center_ecliptic_latitude
  • Galactic coordinate ・・・ center_galactic_longitude, center_galactic_latitude
Items on the date and time

Most of the data products have information related to the date and time, such as observation date, data processing completion date, data release date etc. Representation of date and time are not uniform in genral. In DARTS/Astro Query System, we use both UTC and MJD, the former does not have suffix, and the latter has the suffix "_mjd".

For example, for starting dates of observations, we prepare the items "observation_start_time" and "observation_start_time_mjd".

Items on the public data location

Using DARTS/Astro Query System, you can tell if the data you want exist in DARTS or not. If exist, we provide the "data_access_url" for the URL to download the data.

To the Top of the Page ⏏

Last Modified: 06 March 2020