User Guide for DARTS Astrophysical Data Search
[ 英語 | 日本語 ]
検索システム移行ガイド
~ 旧システムをご利用いただいていた皆様へ ~
平素より DARTS をご活用いただきありがとうございます。
DARTS/Astro ではこれまで、データごとに検索システムを設け、
そのシステム固有のデータ項目による絞り込み検索の入力項目を設けておりましたが、
DARTS/Astro 統合検索システムにおいてはさまざまなデータを横断的に検索することが主な目的となるため、
個々のデータ項目についての入力項目は設けておりません。
しかしこれまで実行できていた絞込み検索は DARTS/Astro 統合検索システムにおいても実行可能です。
その実行方法を以下に記載いたします。
以前の検索システムの検索条件入力画面です。
Basic Search の使い方 や
SQL Search, ADQL Search の使い方
の記載もあわせてご参照ください。
その他の検索条件入力画面で指定していた検索条件も、
SQL Search や ADQL Search において指定できます。
やや技巧的な指定が必要な部分もありますので、SQL WHERE 句の例を示します。
このページの先頭へ ⏏
旧 AKARI Pointing Observation 検索システムからの移行ガイド
Data Proprietary |
SQL WHERE sentence |
query |
Number of search results |
public |
aot_type = 'NORMAL' AND public_date is NOT NULL |
execute |
17,141 |
not public |
public_date is NULL |
execute |
7,294 |
AOT Type |
SQL WHERE sentence |
query |
Number of search results |
NORMAL |
aot_type = 'NORMAL' |
execute |
20,282 |
SPECIAL |
aot_type = 'SPECIAL' |
execute |
6 |
ENGINEERING |
aot_type = 'ENGINEERING' |
execute |
4,148 |
» 'AOT Type = NORMAL' 条件下での絞込み
以下の絞込み条件は、単独で使用すると、観測機器の調整を行った際のデータなども検出される可能性があります。
研究に有用なデータのみに対して絞込みをかけたい場合には、'AOT Type = NORMAL' の条件とセットで使用してください。
具体的には、aot_type = 'NORMAL'
の後に以下の SQL WHERE sentence を
AND
でつないでください。
Processing Statue |
SQL WHERE sentence |
query |
Number of search results |
processed |
data_file_size is NOT NULL |
execute |
17,666 |
not processed |
data_file_size is NULL |
execute |
2,616 |
Observation Statue |
SQL WHERE sentence |
query |
Number of search results |
Observed |
observation_status = 'Observed' |
execute |
18,189 |
STT WDT error |
observation_status = 'STT WDT error' |
execute |
114 |
PV2 |
observation_status = 'PV2' |
execute |
83 |
IRC Det off |
observation_status = 'IRC Det off' |
execute |
564 |
Data lost |
observation_status = 'Data lost' |
execute |
161 |
SH |
observation_status = 'SH' |
execute |
98 |
AOT |
SQL WHERE sentence |
query |
Number of search results |
FIS01 |
aot_name = 'FIS01' |
execute |
726 |
FIS02 |
aot_name = 'FIS02' |
execute |
413 |
FIS03 |
aot_name = 'FIS03' |
execute |
135 |
FIS04 |
aot_name = 'FIS04' |
execute |
450 |
IRC00 |
aot_name = 'IRC00' |
execute |
22 |
IRC02 |
aot_name = 'IRC02' |
execute |
1,626 |
IRC03 |
aot_name = 'IRC03' |
execute |
717 |
IRC04 |
aot_name = 'IRC04' |
execute |
939 |
IRC05 |
aot_name = 'IRC05' |
execute |
783 |
IRCZ0 |
aot_name = 'IRCZ0' |
execute |
471 |
IRCZ2 |
aot_name = 'IRCZ2' |
execute |
656 |
IRCZ3 |
aot_name = 'IRCZ3' |
execute |
2,994 |
IRCZ4 |
aot_name = 'IRCZ4' |
execute |
10,350 |
このページの先頭へ ⏏
旧 SUZAKU MASTER 検索システムからの移行ガイド
Observation Phase |
SQL WHERE sentence |
query |
Number of search results |
SWG |
SUBSTRING(observation_id,2,2) = '00' |
execute |
229 |
AO1 |
SUBSTRING(observation_id,2,2) = '01' |
execute |
337 |
AOn |
SUBSTRING(observation_id,2,2) = '0n' |
|
|
AO10 |
SUBSTRING(observation_id,2,2) = '10' |
execute |
16 |
Category |
SQL WHERE sentence |
query |
Number of search results |
Calibration |
SUBSTRING(observation_id,1,1) = '1' |
execute |
356 |
Galactic Point Sources |
SUBSTRING(observation_id,1,1) = '4' |
execute |
503 |
Galctic Diffuse Emission |
SUBSTRING(observation_id,1,1) = '5' |
execute |
766 |
Extragalactic Compact Sources |
SUBSTRING(observation_id,1,1) = '7' |
execute |
518 |
Extragalactic DIffuse Sources |
SUBSTRING(observation_id,1,1) = '8' |
execute |
858 |
Gamma-Ray Burst and other non-proposal TOO |
SUBSTRING(observation_id,1,1) = '9' |
execute |
54 |
Proposal Type |
SQL WHERE sentence |
query |
Number of search results |
JPN |
SUBSTRING(proposal_id,3,1) = '0' |
execute |
1,259 |
USA |
SUBSTRING(proposal_id,3,1) = '1' |
execute |
998 |
ESA |
SUBSTRING(proposal_id,3,1) = '2' |
execute |
181 |
merged(JPN/ESA PI . USA CoPI) |
SUBSTRING(proposal_id,3,1) = '3' |
execute |
38 |
merged(USA PI . JPN/ESA CoPI) |
SUBSTRING(proposal_id,3,1) = '4' |
execute |
37 |
Calibration |
SUBSTRING(proposal_id,3,1) = '5' |
execute |
247 |
Key Project |
SUBSTRING(proposal_id,3,1) = '6' |
execute |
241 |
TOO |
SUBSTRING(proposal_id,3,1) = '7' |
execute |
53 |
merged(ESA PI . USA CoPI) |
SUBSTRING(proposal_id,3,1) = '8' |
execute |
1 |
このページの先頭へ ⏏
旧 SUZAKU XISLOG 検索システムからの移行ガイド
Observation Phase に関する検索条件は、SUZAKU MASTER の Observation Phase と同様に指定できます。
また Category に関する検索条件は、SUZAKU MASTER の Category と同様に指定できます。
Sensor |
SQL WHERE sentence |
query |
Number of search results |
XIS0 |
xis_active_unit = 'xi0' |
execute |
5,597 |
XIS1 |
xis_active_unit = 'xi1' |
execute |
5,431 |
XIS2 |
xis_active_unit = 'xi2' |
execute |
786 |
XIS3 |
xis_active_unit = 'xi3' |
execute |
5,472 |
Psum |
SQL WHERE sentence |
query |
Number of search results |
on |
xis_clock_mode = 'psum' |
execute |
88 |
off |
xis_clock_mode != 'psum' |
execute |
17,198 |
このページの先頭へ ⏏
» 'Psum = off' 条件付下での絞込み
以下の絞込み条件は、'Psum = off' の時のみ有効になります。xis_clock_mode != 'psum'
の後に以下の SQL WHERE sentence を
AND
でつないでください。
Window Option |
SQL WHERE sentence |
query |
Number of search results |
on |
xis_window_option = '0' |
execute |
15,422 |
off |
xis_window_option != '0' |
execute |
1,776 |
Burst Option |
SQL WHERE sentence |
query |
Number of search results |
on |
xis_clock_mode = 'burst' |
execute |
964 |
off |
xis_clock_mode = 'normal' |
execute |
16,234 |
Edit Mode |
SQL WHERE sentence |
query |
Number of search results |
5 x 5 |
xis_edit_mode = '5x5' |
execute |
7,431 |
3 x 3 |
xis_edit_mode = '3x3' |
execute |
9,509 |
2 x 2 |
xis_edit_mode = '2x2' |
execute |
258 |
SCI |
SQL WHERE sentence |
query |
Number of search results |
on |
has_xis_injection = 'Y' |
execute |
14,237 |
off |
has_xis_injection = 'N' |
execute |
2,961 |
Area Descri |
SQL WHERE sentence |
query |
Number of search results |
on |
is_event_discriminated_in_frame != '0,0,0,0' |
execute |
3,273 |
off |
is_event_discriminated_in_frame = '0,0,0,0' |
execute |
13,925 |
Event th. Lowern |
SQL WHERE sentence |
query |
Number of search results |
20 |
left(lower_limit_of_event_discriminator, 3) = '20,' |
execute |
5,426 |
50 |
left(lower_limit_of_event_discriminator, 3) = '50,' |
execute |
708 |
60 |
left(lower_limit_of_event_discriminator, 3) = '60,' |
execute |
42 |
100 |
left(lower_limit_of_event_discriminator, 3) = '100' |
execute |
11,019 |
このページの先頭へ ⏏
» 'Psum = off' かつ 'Window Option = off' 条件下での絞込み
以下の絞込み条件は、'Psum = off' かつ 'Window Option = off' の時のみ有効になります。
xis_clock_mode != 'psum' AND xis_window_option != '0'
の後に
以下の SQL WHERE sentence を AND
でつないでください。
Window size |
SQL WHERE sentence |
query |
Number of search results |
1/4 |
xis_window_option = '1' |
execute |
1,560 |
1/8 |
xis_window_option = '2' |
execute |
216 |
Window position |
SQL WHERE sentence |
query |
Number of search results |
XIS |
((xis_active_unit='xi0' AND (xis_window_start_address+xis_window_pixel_size/2)=500) OR (xis_active_unit='xi1' AND (xis_window_start_address+xis_window_pixel_size/2)=508) OR (xis_active_unit='xi2' and (xis_window_start_address+xis_window_pixel_size/2)=512) OR (xis_active_unit='xi3' AND (xis_window_start_address+xis_window_pixel_size/2)=508)) |
execute |
1,494 |
HXD |
((xis_active_unit='xi0' AND (xis_window_start_address+xis_window_pixel_size/2)=500) OR (xis_active_unit='xi1' AND (xis_window_start_address+xis_window_pixel_size/2)=307) OR (xis_active_unit='xi2' AND (xis_window_start_address+xis_window_pixel_size/2)=713) OR (xis_active_unit='xi3' AND (xis_window_start_address+xis_window_pixel_size/2)=508)) |
execute |
1,296 |
Others |
NOT((xis_active_unit='xi0' AND (xis_window_start_address+xis_window_pixel_size/2)=500) OR (xis_active_unit='xi1' AND (xis_window_start_address+xis_window_pixel_size/2)=307) OR (xis_active_unit='xi1' AND (xis_window_start_address+xis_window_pixel_size/2)=508) OR (xis_active_unit='xi2' AND (xis_window_start_address+xis_window_pixel_size/2)=512) OR (xis_active_unit='xi2' AND (xis_window_start_address+xis_window_pixel_size/2)=713) OR (xis_active_unit='xi3' AND (xis_window_start_address+xis_window_pixel_size/2)=508))
|
execute |
100 |
» 'Psum = off' かつ 'Burst Option = on' 条件下での絞込み
以下の絞込み条件は、'Psum = off' かつ 'Burst Option == on' の時のみ有効になります。xis_clock_mode != 'psum' AND xis_clock_mode = 'burst'
の後に以下の SQL WHERE sentence を AND
でつないでください。
Window size |
SQL WHERE sentence |
query |
Number of search results |
0.1 |
(0.15 > xis_integration_time and xis_integration_time >= 0.05) |
execute |
361 |
0.3 |
(0.35 > xis_integration_time and xis_integration_time >= 0.25) |
execute |
87 |
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 |
19 |
このページの先頭へ ⏏