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.	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	observation_id	exposure	awarded_exposure	xis0_exposure	xis1_exposure	xis2_exposure	xis3_exposure	xis0_observation_mode	xis1_observation_mode	xis2_observation_mode	xis3_observation_mode	hxd_observation_mode	hxd_coarse_clock_rate_exposure	hxd_first_clock_rate_exposure	hxd_normal_clock_rate_exposure	hxd_all_clock_rate_exposure	hxd_wam_exposure	quantity_of_hxd_burst	processing_status	processing_date_mjd	processing_date	public_date_mjd	public_date	distribution_date_mjd	distribution_date	processing_version	processing_count	processing_software	proposal_id	proposal_abstract	proposal_category	proposal_category_code	proposal_priority	pi_name	co_pi_name	proposal_affiliated_country	proposal_cycle	observation_type	proposal_title	main_instrument	has_xis_injection	data_access_url	ql_access_url	ql_image_url
1	ABELL 1689 (OFFSET)	198.1818	-1.2687	197.539427	-1.003718	197.250185	5.956479	314.01056832	61.14428006	293.5484	56473.3751388889	2013-06-30 09:00:12	56475.3022916667	2013-07-02 07:15:18	808089020	67.8003	396	67.8083	67.8003	0	67.8083	2	2	0	2	1	0	0	60.9649	60.9649	166.4698	5	PROCESSED	57611.6944907407	2016-08-11 16:40:04	56383	2013-04-01 00:00:00	56491.6594675926	2013-07-18 15:49:38	3.0.22.44	2	Hea_08Feb2016_V6.18_Suzaku_14Nov2013_V22	081528	Recent Suzaku results suggest that the surface brightness in galaxy cluster outskirts is higher than the predictions by self-similar models, indicating that the gas may be clumpy or may not be in collisional equilibrium near and beyond the virial radius. If this is the case, gas emission near cosmological accretion shocks should readily be detected. We propose to search for emission near the accretion shock radius where it is the only region unexplored in galaxy cluster studies in X-ray. These data can place important constraints on accretion models and large-scale structure formation theory. Physical properties at the true virial radius (R100) will also be measured to the highest precision to date. A very deep exposure and the low Suzaku background allow this measurement.	EXTRAGALACTIC DIFFUSE SOURCES	8	B	KA-WAH WONG		USA	8	AO8	SEARCH FOR ACCRETION SHOCK IN A MASSIVE GALAXY CLUSTER	XIS	Y	https://data.darts.isas.jaxa.jp/pub/suzaku/ver3.0/808089020/	Quick Look

Used SQL

SELECT * FROM suzaku_master_data WHERE observation_id = '808089020'

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

Go to top of this page ⏏