DARTS/Astro Query System User Guide

[ English | Japanese ]


Transistion from the previous DARTS Astro query systems

Previously in DARTS/Astro, we were operating different query systems for individual satellites and/or instruments, so that instrument specific data queries were made possible . On the other hand, we do not provide satellite/instrument specific pages or menus in the new DARTS/Astro Query System, so that various data can be searched in a uniform platform. All the instrument specific queries on the old search systems are made possble in the new DARTS/Astro Query System, as we explain below.

The following screenshots show the initial screens of previous search systems:

Also, please refer to How to use Basic Search and How to use SQL Search and ADQL Search .

Other search conditions can be specified both in SQL Search and ADQL Search. We show slightly tecnical examples of using SQL "WHERE" clause below:

To the Top of the Page⏏


AKARI Pointing Observation

Data Proprietary SQL WHERE sentence query
public aot_type = 'NORMAL' AND public_date is NOT NULL execute
not public public_date is NULL execute
AOT Type SQL WHERE sentence query
NOMAL aot_type in ('NORMAL') execute
SPECIAL aot_type in ('SPECIAL') execute
ENGINEERING aot_type in ('ENGINEERING') execute

»Narrowing down under the condition 'AOT Type = NOMAL'

If the following conditions are used alone, non-observational data may be found in addition to the observation data. If you want to search for only the observation data, please use these conditions together with 'AOT Type = NOMAL'.
The following conditions should be combined with 'AOT Type = NOMAL' using AND.

Processing Statue SQL WHERE sentence query
processed data_file_size is NOT NULL execute
not processed data_file_size is NULL execute
Observation Statue SQL WHERE sentence query
Observed observation_status in ('Observed') execute
STT WDT error observation_status in ('STT WDT error') execute
PV2 observation_status in ('PV2') execute
IRC Det off observation_status in ('IRC Det off') execute
Data lost observation_status in ('Data lost') execute
SH observation_status in ('SH') execute
AOT SQL WHERE sentence query
FIS01 aot_name in ('FIS01') execute
FIS02 aot_name in ('FIS02') execute
FIS03 aot_name in ('FIS03') execute
FIS04 aot_name in ('FIS04') execute
IRC00 aot_name in ('IRC00') execute
IRC02 aot_name in ('IRC02') execute
IRC03 aot_name in ('IRC03') execute
IRC04 aot_name in ('IRC04') execute
IRC05 aot_name in ('IRC05') execute
IRCZ0 aot_name in ('IRCZ0') execute
IRCZ2 aot_name in ('IRCZ2') execute
IRCZ3 aot_name in ('IRCZ3') execute
IRCZ4 aot_name in ('IRCZ4') execute

To the Top of the Page⏏


SUZAKU MASTER

Observation Phase SQL WHERE sentence query
SWG SUBSTRING(observation_id,2,2) in ('00') execute
AO1 SUBSTRING(observation_id,2,2) in ('01') execute
AOn SUBSTRING(observation_id,2,2) in ('0n')
AO10 SUBSTRING(observation_id,2,2) in ('10') execute
Category SQL WHERE sentence query
Calibration SUBSTRING(observation_id,1,1) in ('1') execute
Galactic Point Sources SUBSTRING(observation_id,1,1) in ('4') execute
Galctic Diffuse Emission SUBSTRING(observation_id,1,1) in ('5') execute
Extragalactic Compact Sources SUBSTRING(observation_id,1,1) in ('7') execute
Extragalactic DIffuse Sources SUBSTRING(observation_id,1,1) in ('8') execute
Gamma-Ray Burst and other non-proposal TOO SUBSTRING(observation_id,1,1) in ('9') execute
Proposal Type SQL WHERE sentence query
JPN SUBSTRING(proposal_id,3,1) in ('0') execute
USA SUBSTRING(proposal_id,3,1) in ('1') execute
ESA SUBSTRING(proposal_id,3,1) in ('2') execute
merged(JPN/ESA PI . USA CoPI) SUBSTRING(proposal_id,3,1) in ('3') execute
merged(USA PI . JPN/ESA CoPI) SUBSTRING(proposal_id,3,1) in ('4') execute
Calibration SUBSTRING(proposal_id,3,1) in ('5') execute
Key Project SUBSTRING(proposal_id,3,1) in ('6') execute
TOO SUBSTRING(proposal_id,3,1) in ('7') execute
merged(ESA PI . USA CoPI) SUBSTRING(proposal_id,3,1) in ('8') execute

To the Top of the Page⏏


SUZAKU XISLOG

Search conditions for Observation Phase are the same as Observation Phase of SUZAKU MASTER. Similarly, search conditions for Category are the same as Category of SUZAKU MASTER.

Sensor SQL WHERE sentence query
XIS0 xis_id in ('xi0') execute
XIS1 xis_id in ('xi1') execute
XIS2 xis_id in ('xi2') execute
XIS3 xis_id in ('xi3') execute
Psum SQL WHERE sentence query
on xis_clock_mode = 'psum' execute
off xis_clock_mode != 'psum' execute

To the Top of the Page⏏

» Narrowing down under the condition 'Psum = off'

The following conditions become effective only when 'Psum = off'. Please combine xis_clock_mode != 'psum' and the following conditions using AND.

Window Option SQL WHERE sentence query
on xis_window_option = '0' execute
off xis_window_option != '0' execute
Burst Option SQL WHERE sentence query
on xis_clock_mode = 'burst' execute
off xis_clock_mode = 'normal' execute
Edit Mode SQL WHERE sentence query
5 x 5 xis_edit_mode in ('5x5') execute
3 x 3 xis_edit_mode in ('3x3') execute
2 x 2 xis_edit_mode in ('2x2') execute
SCI SQL WHERE sentence query
on has_xis_injection_flag in ('Y') execute
off has_xis_injection_flag in ('N') execute
Area Descri SQL WHERE sentence query
on is_event_discriminated_in_frame_flag != '0,0,0,0' execute
off is_event_discriminated_in_frame_flag = '0,0,0,0' execute
Event th. Lowern SQL WHERE sentence query
20 left(min_bound_of_event_discriminator, 3) in ('20,') execute
50 left(min_bound_of_event_discriminator, 3) in ('50,') execute
60 left(min_bound_of_event_discriminator, 3) in ('60,') execute
100 left(min_bound_of_event_discriminator, 3) in ('100') execute

To the Top of the Page⏏

» Narrowing down under the condition of both 'Psum = off' and 'Window Option = off'

The following conditions become effective only when both 'Psum = off' and 'Window Option = off'. Please conbine the following conditions with xis_clock_mode != 'psum' AND xis_window_option != '0' using AND.

Window size SQL WHERE sentence query
1/4 xis_window_option = '1' execute
1/8 xis_window_option = '2' execute
Window position SQL WHERE sentence query
XIS ((xis_id='xi0' AND (xis_window_start_address+xis_window_pixel_size/2)=500) OR (xis_id='xi1' AND (xis_window_start_address+xis_window_pixel_size/2)=508) OR (xis_id='xi2' and (xis_window_start_address+xis_window_pixel_size/2)=512) OR (xis_id='xi3' AND (xis_window_start_address+xis_window_pixel_size/2)=508)) execute
HXD ((xis_id='xi0' AND (xis_window_start_address+xis_window_pixel_size/2)=500) OR (xis_id='xi1' AND (xis_window_start_address+xis_window_pixel_size/2)=307) OR (xis_id='xi2' AND (xis_window_start_address+xis_window_pixel_size/2)=713) OR (xis_id='xi3' AND (xis_window_start_address+xis_window_pixel_size/2)=508)) execute
Others NOT((xis_id='xi0' AND (xis_window_start_address+xis_window_pixel_size/2)=500) OR (xis_id='xi1' AND (xis_window_start_address+xis_window_pixel_size/2)=307) OR (xis_id='xi1' AND (xis_window_start_address+xis_window_pixel_size/2)=508) OR (xis_id='xi2' AND (xis_window_start_address+xis_window_pixel_size/2)=512) OR (xis_id='xi2' AND (xis_window_start_address+xis_window_pixel_size/2)=713) OR (xis_id='xi3' AND (xis_window_start_address+xis_window_pixel_size/2)=508)) execute

» Narrowing down under the condition 'Psum = off' AND 'Burst Option = on'

The following conditions become effective only when both 'Psum = off' and 'Burst Option = on'. Please combine the following conditions with xis_clock_mode != 'psum' AND xis_clock_mode = 'burst' using AND.

Window size SQL WHERE sentence query
0.1 (0.15 > xis_integration_time and xis_integration_time >= 0.05) execute
0.3 (0.35 > xis_integration_time and xis_integration_time >= 0.25) execute
n (n+0.05 > xis_integration_time and xis_integration_time >= n-0.05)
4.0 (4.05 > xis_integration_time and xis_integration_time >= 3.95) execute

To the Top of the Page⏏

Last Modified: 28 August 2018