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 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. halca_observation_log 45 Yes Yes OBS
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: 19 November 2018