DARTS/Astro Query System - ADQL 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 "ADQL Search".

Call example

【Basic Syntax】

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

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

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 (180.0, 60,0) and radius is 2 degree
  Displayed results -> from 1st to 10th

---------------------------------------------------------
Point:
  You can use functions of
  ADQL(http://www.ivoa.net/documents/latest/ADQL.html)
  on this system.

Data types:
    Point   ... POINT(coordinate, coordinate)
    Circle  ... CIRCLE(POINT(), radius)
    Polygon ... POLYGON(POINT(), POINT(), ...)

Operators:
    CONTAINS(a, b) = 1 ... a is contained by b
    CONTAINS(a, b) = 0 ... a is not contained by b
    INTERSECTS(a, b) = 1 ... overlaped each other
    INTERSECTS(a, b) = 0 ... do not overlaped each other

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

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

The ASCA GIS has circular field of view with 22 arcmins 
as radius. Each data of asca_observation_log has the coordinate 
position of the center of the field of view. So, search the 
data overlaped with the two circles, the field of view and 
your specified one.

Columns to display -> all
  Table name -> asca_observation_log
  Search condition -> radial search, 
  center position is (122.0, -37,5) and radius is 2 degree
  Displayed results -> from 1st to 10th

---------------------------------------------------------
Point:
  You can use functions of
  ADQL(http://www.ivoa.net/documents/latest/ADQL.html)
  at this system.

Data types:
    Point   ... POINT(coordinate, coordinate)
    Circle  ... CIRCLE(POINT(), radius)
    Polygon ... POLYGON(POINT(), POINT(), ...)

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

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 
  ADQL(http://www.ivoa.net/documents/latest/ADQL.html)
  at this system.

Data types:
    Point   ... POINT(coordinate, coordinate)
    Circle  ... CIRCLE(POINT(), radius)
    Polygon ... POLYGON(POINT(), POINT(), ...)

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

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 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:

1. Use the column of Galactic coordinates.

2. You can use functions of
   ADQL(http://www.ivoa.net/documents/latest/ADQL.html)
  at this system.

Data types:
	Point   ... POINT(coordinate, coordinate)
	Circle  ... CIRCLE(POINT(), radius)
	Polygon ... POLYGON(POINT(), POINT(), ...)

Operators:
	CONTAINS(a, b) = 1 ... a is contained by b
	CONTAINS(a, b) = 0 ... a is not contained by b
	INTERSECTS(a, b) = 1 ... overlaped each other
	INTERSECTS(a, b) = 0 ... 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 (180.0, 60,0) and radius is 2 degree
  Displayed results -> from 1st to 10th

---------------------------------------------------------
Point:
  You can use functions of
  ADQL(http://www.ivoa.net/documents/latest/ADQL.html)
  on this system.

Data types:
    Point   ... POINT(coordinate, coordinate)
    Circle  ... CIRCLE(POINT(), radius)
    Polygon ... POLYGON(POINT(), POINT(), ...)

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

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

Columns to display -> all
  Table name -> asca_observation_log
  Search condition -> radial search, 
  center position is (122.0, -37,5) and radius is 2 degree
  Displayed results -> from 1st to 10th

---------------------------------------------------------
Point:
  You can use functions of
  ADQL(http://www.ivoa.net/documents/latest/ADQL.html)
  at this system.

Data types:
    Point   ... POINT(coordinate, coordinate)
    Circle  ... CIRCLE(POINT(), radius)
    Polygon ... POLYGON(POINT(), POINT(), ...)

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

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

1. Use the column of Galactic coordinates.

2. You can use functions of 
  ADQL(http://www.ivoa.net/documents/latest/ADQL.html)
  at this system.

Data types:
    Point   ... POINT(coordinate, coordinate)
    Circle  ... CIRCLE(POINT(), radius)
    Polygon ... POLYGON(POINT(), POINT(), ...)

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

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
   ADQL(http://www.ivoa.net/documents/latest/ADQL.html)
  at this system.

Data types:
	Point   ... POINT(coordinate, coordinate)
	Circle  ... CIRCLE(POINT(), radius)
	Polygon ... POLYGON(POINT(), POINT(), ...)

Operators:
	CONTAINS(a, b) = 1 ... a is contained by b
	CONTAINS(a, b) = 0 ... a is not contained by b
	INTERSECTS(a, b) = 1 ... overlaped each other
	INTERSECTS(a, b) = 0 ... do not overlaped each other

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

ADQL query

Format

Used SQL

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

Go to top of this page ⏏