DARTS/Astro Query System - SQL Search -

All the tables available for SQL Search and information on each table are listed in the Available Data page. Please see the User Guide for the usage of "SQL Search".

Call example

【Basic Syntax】

 SELECT {*|column, column, column,..}
 FROM table name
 [ WHERE conditions ]
 [ ORDER BY column, column,... ]
 [ LIMIT {ALL|number} ] [ OFFSET number ]
 ;

---------------------------------------------------------

This is an example query to obtain the first 10 rows of 
akari_fis_bsc_1 using radial search.

The akari_fis_bsc_1 is an catalogue, and each data has 
the coorinate position of the object. So, search the objects 
contained in the circle area you specify there.

Columns to display -> all
  Table name -> akari_fis_bsc_1
  Search condition -> radial search, 
   center position is (266.0, -28,0) and radius is 10 arcmin
  Displayed results -> from 1st to 10th

---------------------------------------------------------
Point:
  You can use functions of PgSphere(https://pgsphere.github.io/)
  on this system.

Data types:
    Point   ... spoint(coordinate, coordinate)
    Path    ... spath(spoint(), spoint(), ...)
    Circle  ... scircle(spoint(), radius)
    Polygon ... spoly(spoint(), spoint(), ...)

Operators:
    a @ b = '1' ... a contained by b
    a !@ b = '1' ... a is not contained by b
    a && b = '1' ... overlaped each other
    a !&& b = '1' ... do not overlaped each other

Ths function radians needs a parameter in degree.
  Operator '/' means division. 
  Note: integer division truncates the result.
   10.0 / 60.0 = 0.16666...
   10 / 60 = 0

---------------------------------------------------------

This is an example query to obtain the first 10 rows of 
ginga_observation_log using radial search.

The ginga_observation_log has pointing observations and 
scan observation. Each data has the coorinate of the 
observation start point and the end point, and the 
average point. So, search the pointing position contained 
in the circle area you specified, or the scan-path crossed 
over the area.

Columns to display -> all
  Table name -> ginga_observation_log
  Search condition -> radial search,
  center position is M31(10.7, 41.2) and radius is 1 degree
  Displayed results -> from 1st to 10th

---------------------------------------------------------
Point:
  You can use functions of PgSphere(https://pgsphere.github.io/)
  on this system.

Data types:
    Point   ... spoint(coordinate, coordinate)
    Path    ... spath(spoint(), spoint(), ...)
    Circle  ... scircle(spoint(), radius)
    Polygon ... spoly(spoint(), spoint(), ...)

Operators:
    a @ b  ... a contained by b
    a !@ b ... a is not contained by b
    a && b ... overlaped each other
    a !&& b ... do not overlaped each other

---------------------------------------------------------

This is an example query to obtain the data near the 
galactic center of suzaku_xis_observation_log using radial search.

The SUZAKU XIS has rectanglar field of view with 18 arcmin 
x 18 arcmin. Each data of suzaku_xis_observation_log has 
the coorinate of each corner position about field of view.
So, search the rectanglar area overlapd the circle area 
you specified.

Columns to display -> all
  Table name -> suzaku_xis_observation_log
  Search condition -> radial search,
    center position is (0.0, 0.0) with Galactic coordinates
    and radius is 1 arcmin
  Displayed results -> from 1st to 200th

---------------------------------------------------------
Point:

1. Use the column of Galactic coordinates.

2. You can use functions of PgSphere(https://pgsphere.github.io/)
   on this system.

Data types:
    Point   ... spoint(coordinate, coordinate)
    Path    ... spath(spoint(), spoint(), ...)
    Circle  ... scircle(spoint(), radius)
    Polygon ... spoly(spoint(), spoint(), ...)

Operators:
    a @ b  ... a contained by b
    a !@ b ... a is not contained by b
    a && b ... overlaped each other
    a !&& b ... do not overlaped each other

---------------------------------------------------------

This is an example query to obtain the data nearthe 
galactic center of suzaku_xis_observation_log using radial search.

The SUZAKU XIS has rectanglar field of view with 18 arcmin 
x 18 arcmin. Each data of suzaku_xis_observation_log has the 
coorinate of each corner position about field of view. 
So, search the rectanglar area overlapd the rectanglar area 
you specified.

Columns to display -> object_name, center_galactic_lon, 
   center_galactic_lat, data_access_url
  Table name -> suzaku_xis_observation_log
  Search condition -> rectanglar search,
    0.1(deg) <= Galactic Latitude <= .0.1(deg)
    and 0.1(deg) <= Galactic Latitude <= 0.1(deg)
  Displayed results -> from 1st to 100th

---------------------------------------------------------
Point:
  You can use functions of PgSphere(https://pgsphere.github.io/)
  on this system.

Data types:
    Point   ... spoint(coordinate, coordinate)
    Path    ... spath(spoint(), spoint(), ...)
    Circle  ... scircle(spoint(), radius)
    Polygon ... spoly(spoint(), spoint(), ...)

Operators:
    a @ b  ... a contained by b
    a !@ b ... a is not contained by b
    a && b ... overlaped each other
    a !&& b ... do not overlaped each other

---------------------------------------------------------

This is an example query to obtain the first 10 rows of 
akari_fis_bsc_1 using radial search.

The akari_fis_bsc_1 is an catalogue, and each data has 
the coorinate position of the object. So, search the objects 
contained in the circle area you specify there.

Columns to display -> all
  Table name -> akari_fis_bsc_1
  Search condition -> radial search, 
   center position is (266.0, -28,0) and radius is 10 arcmin
  Displayed results -> from 1st to 10th

---------------------------------------------------------
Point:
  You can use functions of PgSphere(https://pgsphere.github.io/)
  on this system.

Data types:
    Point   ... spoint(coordinate, coordinate)
    Path    ... spath(spoint(), spoint(), ...)
    Circle  ... scircle(spoint(), radius)
    Polygon ... spoly(spoint(), spoint(), ...)

Operators:
    a @ b = '1' ... a contained by b
    a !@ b = '1' ... a is not contained by b
    a && b = '1' ... overlaped each other
    a !&& b = '1' ... do not overlaped each other

Ths function radians needs a parameter in degree.
  Operator '/' means division. 
  Note: integer division truncates the result.
   10.0 / 60.0 = 0.16666...
   10 / 60 = 0

---------------------------------------------------------

This is an example query to obtain the first 10 rows of 
ginga_observation_log using radial search.

---------------------------------------------------------
Point:
  You can use functions of PgSphere(https://pgsphere.github.io/)
  on this system.

Data types:
    Point   ... spoint(coordinate, coordinate)
    Path    ... spath(spoint(), spoint(), ...)
    Circle  ... scircle(spoint(), radius)
    Polygon ... spoly(spoint(), spoint(), ...)

Operators:
    a @ b  ... a contained by b
    a !@ b ... a is not contained by b
    a && b ... overlaped each other
    a !&& b ... do not overlaped each other

---------------------------------------------------------

This is an example query to obtain the data near the 
galactic center of suzaku_xis_observation_log using radial search.

---------------------------------------------------------
Point:

1. Use the column of Galactic coordinates.

2. You can use functions of PgSphere(https://pgsphere.github.io/)
   on this system.

Data types:
    Point   ... spoint(coordinate, coordinate)
    Path    ... spath(spoint(), spoint(), ...)
    Circle  ... scircle(spoint(), radius)
    Polygon ... spoly(spoint(), spoint(), ...)

Operators:
    a @ b  ... a contained by b
    a !@ b ... a is not contained by b
    a && b ... overlaped each other
    a !&& b ... do not overlaped each other

---------------------------------------------------------

This is an example query to obtain the data nearthe 
galactic center of suzaku_xis_observation_log using radial search.

The SUZAKU XIS has rectanglar field of view with 18 arcmin 
x 18 arcmin. Each data of suzaku_xis_observation_log has the 
coorinate of each corner position about field of view. 
So, search the rectanglar area overlapd the rectanglar area 
you specified.

---------------------------------------------------------
Point:
  You can use functions of PgSphere(https://pgsphere.github.io/)
  on this system.

Data types:
    Point   ... spoint(coordinate, coordinate)
    Path    ... spath(spoint(), spoint(), ...)
    Circle  ... scircle(spoint(), radius)
    Polygon ... spoly(spoint(), spoint(), ...)

Operators:
    a @ b  ... a contained by b
    a !@ b ... a is not contained by b
    a && b ... overlaped each other
    a !&& b ... do not overlaped each other

---------------------------------------------------------

SQL query

Format

total 1

Download WgetScript

No.	observation_id	object_name	center_ra	center_dec	center_ra_b1950	center_dec_b1950	center_ecliptic_lon	center_ecliptic_lat	center_galactic_lon	center_galactic_lat	roll_angle	observation_start_time_mjd	observation_start_time	observation_end_time_mjd	observation_end_time	exposure	awarded_exposure	resolve_exposure	resolve_data_mode	resolve_with_filter_be	resolve_with_filter_fe55	resolve_with_filter_nd	resolve_with_filter_poly	resolve_with_filter_open	resolve_with_filter_undef	is_resolve_gatevalve_closed	is_resolve_mxs1	is_resolve_mxs2	is_resolve_mxs3	is_resolve_mxs4	resolve_code	gen_code	processing_status	processing_date	public_date	distribution_date	processing_version	caldb_version	processing_software	proposal_id	proposal_abstract	proposal_category	proposal_category_code	proposal_priority	pi_name	co_pi_name	proposal_affiliated_country	proposal_cycle	proposal_type	proposal_title	observation_status	data_access_url	ql_access_url	ql_image_url	corner1_ra	corner1_dec	corner2_ra	corner2_dec	corner3_ra	corner3_dec	corner4_ra	corner4_dec	corner5_ra	corner5_dec	corner6_ra	corner6_dec	corner1_ra_b1950	corner1_dec_b1950	corner2_ra_b1950	corner2_dec_b1950	corner3_ra_b1950	corner3_dec_b1950	corner4_ra_b1950	corner4_dec_b1950	corner5_ra_b1950	corner5_dec_b1950	corner6_ra_b1950	corner6_dec_b1950	corner1_ecliptic_lon	corner1_ecliptic_lat	corner2_ecliptic_lon	corner2_ecliptic_lat	corner3_ecliptic_lon	corner3_ecliptic_lat	corner4_ecliptic_lon	corner4_ecliptic_lat	corner5_ecliptic_lon	corner5_ecliptic_lat	corner6_ecliptic_lon	corner6_ecliptic_lat	corner1_galactic_lon	corner1_galactic_lat	corner2_galactic_lon	corner2_galactic_lat	corner3_galactic_lon	corner3_galactic_lat	corner4_galactic_lon	corner4_galactic_lat	corner5_galactic_lon	corner5_galactic_lat	corner6_galactic_lon	corner6_galactic_lat	resolve_adr_mode	resolve_thr_name	resolve_shp_date
1	201018010	GX1+4	263.00753	-24.74524	262.23961	-24.70949	263.65029	-1.45994	1.93662	4.79626	93.08029	60759.21671	2025-03-25 05:12:04	60760.57644	2025-03-26 13:50:04	47.379	40.000	47.379	PX_NORMAL	N	Y	N	N	Y	Y	Y	OFF	OFF	OFF	OFF	313430	11310	PROCESSED	2025-04-11 10:44:48	2026-04-16 00:00:00	2025-04-12 10:44:48	03.00.013.010	gen20241115_xtd20241115_rsl20241115	Hea_21Aug2024_V6.34_XRISM_21Aug2024_V001	000011098	One of the big questions in neutron stars is how the strong magnetic field is formed and evolved. We propose a 40 ks observation of a low-mass X-ray binary pulsar GX 1+4, which has long been suspected to have a very high magnetic field strength, perhaps ~ 1e14 G. Thanks to the excellent energy resolution of the Resolve, the proposed observation enables us for the first time to resolve the profile of the Fe K alpha lines and to measure the magnetic field strength above 1e13 G, which is impossible to probe using the cyclotron resonance scattering feature (CRSF). From this observation we can determine whether or not the source is the first magnetar binary ever detected. Moreover, Resolve may provide a unique opportunity to search for the proton CRSF.	BH AND NS BINARIES	2	B	TOSHIHIRO TAKAGI		JAP	1	NOR	DETERMINING THE MAGNETIC FIELD STRENGTH OF THE LOW MASS X-RAY BINARY PULSAR GX 1+4: A UNIQUE MAGNETAR BINARY?	archived	https://data.darts.isas.jaxa.jp/pub/xrism/data/obs/rev3/2/201018010/	Quick Look		263.03582	-24.72218	262.97923	-24.71938	262.97677	-24.76205	262.98612	-24.76247	262.98555	-24.77092	263.03271	-24.77334	262.26802	-24.68657	262.21147	-24.6835	262.20876	-24.72616	262.21811	-24.72662	262.21749	-24.73507	262.26461	-24.73772	263.67486	-1.43567	263.62336	-1.43537	263.6232	-1.47809	263.63171	-1.4781	263.6316	-1.48656	263.6745	-1.48691	1.97004	4.78717	1.94442	4.83187	1.90723	4.81059	1.91151	4.80323	1.9041	4.79908	1.92537	4.7618	HELIUM	A75A	2021-12-13 00:00:00

Used SQL

SELECT * FROM xrism_resolve_data WHERE observation_id = '201018010'

Your request has been accepted.
The download will start soon automatically.

Go to top of this page ⏏