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 6

Download WgetScript

No.	observation_start_time	observation_start_time_mjd	observation_end_time	observation_end_time_mjd	observation_id	object_name	pi_name	proposal_code	object_ra	object_dec	object_ra_b1950	object_dec_b1950	object_galactic_lon	object_galactic_lat	object_ecliptic_lon	object_ecliptic_lat	aot_name	aot_param	aot_type	observation_status	observation_mode	object_id	observation_count	pointing_id	remark_id	remark_title	public_date	public_date_mjd	file_create_date	data_size	data_access_url
1	2007-04-11 16:03:16	54201.6689351852	2007-04-11 16:03:16	54201.6689351852	3020001-001	N159/N160_1	Doi Yasuo	FISPL	84.9928304094591	-69.7012324927622	85.102784	-69.725294	280.15029	-31.49278	298.4	-86.35	FIS51	0.5;15;0	SPECIAL	Observed	MAIN	3020001	1	3020001	/1/3/	Earth shine, special mode			2007-05-18 06:05:25	34664334	https://data.darts.isas.jaxa.jp/pub/akari/AKARI__Pointed_RawDataPack_1.0/OT-ISAS/FISPL/AKARI_FIS_3020001_001.tar.gpg
2	2007-04-14 03:40:56	54204.1534259259	2007-04-14 03:40:56	54204.1534259259	3020004-001	N159/N160_S_1	Doi Yasuo	FISPL	84.8721400074322	-69.5277109822675	84.975031	-69.552374	279.95374	-31.55448	300.5117	-86.47	FIS51	0.5;15;0	SPECIAL	Observed	MAIN	3020004	1	3020004	/1/3/	Earth shine, special mode			2007-05-18 06:05:48	34666653	https://data.darts.isas.jaxa.jp/pub/akari/AKARI__Pointed_RawDataPack_1.0/OT-ISAS/FISPL/AKARI_FIS_3020004_001.tar.gpg
3	2007-04-23 06:19:39	54213.2636458333	2007-04-23 06:19:39	54213.2636458333	3020005-001	N159/N160_S_2	Doi Yasuo	FISPL	84.8721400074322	-69.5277109822675	84.975031	-69.552374	279.95374	-31.55448	300.5117	-86.47	FIS51	0.5;15;0	SPECIAL	Observed	MAIN	3020005	1	3020005	/1/3/	Earth shine, special mode			2007-05-18 06:05:56	34673182	https://data.darts.isas.jaxa.jp/pub/akari/AKARI__Pointed_RawDataPack_1.0/OT-ISAS/FISPL/AKARI_FIS_3020005_001.tar.gpg
4	2007-05-01 04:49:45	54221.2012152778	2007-05-01 04:49:45	54221.2012152778	3020006-001	N159/N160_S_3	Doi Yasuo	FISPL	84.8721400074322	-69.5277109822675	84.975031	-69.552374	279.95374	-31.55448	300.5117	-86.47	FIS51	0.5;15;0	SPECIAL	Observed	MAIN	3020006	1	3020006	/1/3/	Earth shine, special mode			2007-05-24 06:09:24	34617011	https://data.darts.isas.jaxa.jp/pub/akari/AKARI__Pointed_RawDataPack_1.0/OT-ISAS/FISPL/AKARI_FIS_3020006_001.tar.gpg
5	2007-04-20 03:47:12	54210.1577777778	2007-04-20 03:47:12	54210.1577777778	3020002-001	N159/N160_2	Doi Yasuo	FISPL	84.9928304094591	-69.7012324927622	85.102784	-69.725294	280.15029	-31.49278	298.4	-86.35	FIS51	0.5;15;0	SPECIAL	Observed	MAIN	3020002	1	3020002	/1/3/	Earth shine, special mode			2007-05-18 06:05:33	34653225	https://data.darts.isas.jaxa.jp/pub/akari/AKARI__Pointed_RawDataPack_1.0/OT-ISAS/FISPL/AKARI_FIS_3020002_001.tar.gpg
6	2007-04-30 13:55:09	54220.5799652778	2007-04-30 13:55:09	54220.5799652778	3020003-001	N159/N160_3	Doi Yasuo	FISPL	84.9928304094591	-69.7012324927622	85.102784	-69.725294	280.15029	-31.49278	298.4	-86.35	FIS51	0.5;15;0	SPECIAL	Observed	MAIN	3020003	1	3020003	/1/3/	Earth shine, special mode			2007-05-18 06:05:40	34617524	https://data.darts.isas.jaxa.jp/pub/akari/AKARI__Pointed_RawDataPack_1.0/OT-ISAS/FISPL/AKARI_FIS_3020003_001.tar.gpg

Used SQL

SELECT * FROM akari_pointed_rawdata_package_info WHERE aot_type = 'SPECIAL'

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

Go to top of this page ⏏