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 22

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	2006-04-23 10:39:57	53848.4444097222	2006-04-23 10:39:57	53848.4444097222	5030407-001	IRC_NEP_PV_chk_00c_N	IRC Team	PVIRC	268.7625	66.6224	268.765594	66.628383	96.46129	30.30238	172.28031	89.50452	IRC00	c;N	NORMAL	Observed	MAIN	5030407	1	5030407	/1/2/	Earth shine, No dithering	2008-03-07 00:00:00	54532	2007-02-28 17:58:13	45968357	https://data.darts.isas.jaxa.jp/pub/akari/AKARI__Pointed_RawDataPack_1.0/PV/PVIRC/AKARI_IRC_5030407_001.tar.gz
2	2006-04-30 09:20:51	53855.3894791667	2006-04-30 09:20:51	53855.3894791667	5020054-003	NEP CVZ deep-imag	IRC Team	PVIRC	268.85	66.6256	268.853206	66.631157	96.46418	30.26761	171.38829	89.53858	IRC00	b;N	NORMAL	Observed	MAIN	5020054	3	5020054	/1/2/	Earth shine, No dithering	2008-03-07 00:00:00	54532	2007-02-28 17:52:51	42657607	https://data.darts.isas.jaxa.jp/pub/akari/AKARI__Pointed_RawDataPack_1.0/PV/PVIRC/AKARI_IRC_5020054_003.tar.gz
3	2006-05-03 03:21:44	53858.1400925926	2006-05-03 03:21:44	53858.1400925926	5020053-001	NEP CVZ deep-imag	IRC Team	PVIRC	268.85	66.6256	268.853206	66.631157	96.46418	30.26761	171.38829	89.53858	IRC00	b;N	NORMAL	Observed	MAIN	5020053	1	5020053	/1/2/	Earth shine, No dithering	2008-03-07 00:00:00	54532	2007-02-28 17:49:01	42596205	https://data.darts.isas.jaxa.jp/pub/akari/AKARI__Pointed_RawDataPack_1.0/PV/PVIRC/AKARI_IRC_5020053_001.tar.gz
4	2006-05-03 06:39:47	53858.2776273148	2006-05-03 06:39:47	53858.2776273148	5020053-002	NEP CVZ deep-imag	IRC Team	PVIRC	268.85	66.6256	268.853206	66.631157	96.46418	30.26761	171.38829	89.53858	IRC00	b;N	NORMAL	Observed	MAIN	5020053	2	5020053	/1/2/	Earth shine, No dithering	2008-03-07 00:00:00	54532	2007-02-28 17:49:27	42617949	https://data.darts.isas.jaxa.jp/pub/akari/AKARI__Pointed_RawDataPack_1.0/PV/PVIRC/AKARI_IRC_5020053_002.tar.gz
5	2006-05-03 19:51:58	53858.8277546296	2006-05-03 19:51:58	53858.8277546296	5020053-003	NEP CVZ deep-imag	IRC Team	PVIRC	268.85	66.6256	268.853206	66.631157	96.46418	30.26761	171.38829	89.53858	IRC00	b;N	NORMAL	Observed	MAIN	5020053	3	5020053	/1/2/	Earth shine, No dithering	2008-03-07 00:00:00	54532	2007-02-28 17:49:51	42692375	https://data.darts.isas.jaxa.jp/pub/akari/AKARI__Pointed_RawDataPack_1.0/PV/PVIRC/AKARI_IRC_5020053_003.tar.gz
6	2006-05-03 21:31:00	53858.8965277778	2006-05-03 21:31:00	53858.8965277778	5020053-004	NEP CVZ deep-imag	IRC Team	PVIRC	268.85	66.6256	268.853206	66.631157	96.46418	30.26761	171.38829	89.53858	IRC00	b;N	NORMAL	Observed	MAIN	5020053	4	5020053	/1/2/	Earth shine, No dithering	2008-03-07 00:00:00	54532	2007-02-28 17:49:57	11473096	https://data.darts.isas.jaxa.jp/pub/akari/AKARI__Pointed_RawDataPack_1.0/PV/PVIRC/AKARI_IRC_5020053_004.tar.gz
7	2006-05-06 05:38:18	53861.2349305556	2006-05-06 05:38:18	53861.2349305556	5020055-002	NEP CVZ deep-imag	IRC Team	PVIRC	268.85	66.6256	268.853206	66.631157	96.46418	30.26761	171.38829	89.53858	IRC00	b;N	NORMAL	Observed	MAIN	5020055	2	5020055	/1/2/	Earth shine, No dithering	2008-03-07 00:00:00	54532	2007-02-28 17:53:29	42612060	https://data.darts.isas.jaxa.jp/pub/akari/AKARI__Pointed_RawDataPack_1.0/PV/PVIRC/AKARI_IRC_5020055_002.tar.gz
8	2007-05-01 17:56:57	54221.7478819444	2007-05-01 17:56:57	54221.7478819444	1651029-001	(parallel)HD222259	Ueno Munetaka	AFSAS									IRC00	a;N	NORMAL	Observed	PARALLEL	1651029	1		/1/2/	Earth shine, No dithering
9	2007-04-13 19:11:33	54203.7996875	2007-04-13 19:11:33	54203.7996875	1651021-001	(parallel)HD195961	Ueno Munetaka	AFSAS									IRC00	b;N	NORMAL	Observed	PARALLEL	1651021	1		/1/2/	Earth shine, No dithering
10	2007-03-27 18:06:50	54186.7547453704	2007-03-27 18:06:50	54186.7547453704	1651019-001	(parallel)HD 172555	Ueno Munetaka	AFSAS									IRC00	c;N	NORMAL	Observed	PARALLEL	1651019	1		/2/	No dithering
11	2007-04-06 21:33:32	54196.898287037	2007-04-06 21:33:32	54196.898287037	1651017-001	(parallel)HD186602	Ueno Munetaka	AFSAS									IRC00	a;N	NORMAL	Observed	PARALLEL	1651017	1		/1/2/	Earth shine, No dithering
12	2007-04-09 00:04:36	54199.0031944444	2007-04-09 00:04:36	54199.0031944444	1651033-001	(parallel)mbm26-03	Ueno Munetaka	AFSAS									IRC00	b;N	NORMAL	Observed	PARALLEL	1651033	1		/1/2/	Earth shine, No dithering
13	2007-04-16 18:26:50	54206.7686342593	2007-04-16 18:26:50	54206.7686342593	1651027-001	(parallel)HD202746	Ueno Munetaka	AFSAS									IRC00	b;N	NORMAL	Observed	PARALLEL	1651027	1		/1/2/	Earth shine, No dithering
14	2007-04-24 18:34:29	54214.7739467593	2007-04-24 18:34:29	54214.7739467593	1651023-001	(parallel)BRM 14269	Ueno Munetaka	AFSAS									IRC00	a;N	NORMAL	Observed	PARALLEL	1651023	1		/1/2/	Earth shine, No dithering
15	2007-04-25 19:25:42	54215.8095138889	2007-04-25 19:25:42	54215.8095138889	1651025-001	(parallel)HD207964	Ueno Munetaka	AFSAS									IRC00	c;N	NORMAL	Observed	PARALLEL	1651025	1		/1/2/	Earth shine, No dithering
16	2007-05-10 22:16:38	54230.9282175926	2007-05-10 22:16:38	54230.9282175926	1652665-001	(parallel)HD224392	Ueno Munetaka	AFSAS									IRC00	a;N	NORMAL	Observed	PARALLEL	1652665	1		/1/2/	Earth shine, No dithering
17	2006-05-03 23:10:01	53858.9652893519	2006-05-03 23:10:01	53858.9652893519	5020053-005	NEP CVZ deep-imag	IRC Team	PVIRC	268.85	66.6256	268.853206	66.631157	96.46418	30.26761	171.38829	89.53858	IRC00	b;N	NORMAL	Observed	MAIN	5020053	5	5020053	/1/2/	Earth shine, No dithering	2008-03-07 00:00:00	54532	2007-02-28 17:50:36	42613343	https://data.darts.isas.jaxa.jp/pub/akari/AKARI__Pointed_RawDataPack_1.0/PV/PVIRC/AKARI_IRC_5020053_005.tar.gz
18	2006-04-29 20:08:41	53854.8393634259	2006-04-29 20:08:41	53854.8393634259	5020054-001	NEP CVZ deep-imag	IRC Team	PVIRC	268.85	66.6256	268.853206	66.631157	96.46418	30.26761	171.38829	89.53858	IRC00	b;N	NORMAL	Observed	MAIN	5020054	1	5020054	/1/2/	Earth shine, No dithering	2008-03-07 00:00:00	54532	2007-02-28 17:51:30	45829777	https://data.darts.isas.jaxa.jp/pub/akari/AKARI__Pointed_RawDataPack_1.0/PV/PVIRC/AKARI_IRC_5020054_001.tar.gz
19	2006-04-30 07:41:49	53855.3207060185	2006-04-30 07:41:49	53855.3207060185	5020054-002	NEP CVZ deep-imag	IRC Team	PVIRC	268.85	66.6256	268.853206	66.631157	96.46418	30.26761	171.38829	89.53858	IRC00	b;N	NORMAL	Observed	MAIN	5020054	2	5020054	/1/2/	Earth shine, No dithering	2008-03-07 00:00:00	54532	2007-02-28 17:52:15	42625832	https://data.darts.isas.jaxa.jp/pub/akari/AKARI__Pointed_RawDataPack_1.0/PV/PVIRC/AKARI_IRC_5020054_002.tar.gz
20	2006-05-06 00:41:13	53861.0286226852	2006-05-06 00:41:13	53861.0286226852	5020055-001	NEP CVZ deep-imag	IRC Team	PVIRC	268.85	66.6256	268.853206	66.631157	96.46418	30.26761	171.38829	89.53858	IRC00	b;N	NORMAL	Observed	MAIN	5020055	1	5020055	/1/2/	Earth shine, No dithering	2008-03-07 00:00:00	54532	2007-02-28 17:53:12	42650689	https://data.darts.isas.jaxa.jp/pub/akari/AKARI__Pointed_RawDataPack_1.0/PV/PVIRC/AKARI_IRC_5020055_001.tar.gz
21	2006-04-23 15:37:00	53848.6506944444	2006-04-23 15:37:00	53848.6506944444	5030401-001	IRC_NEP_PV_chk_00a_N	IRC Team	PVIRC	268.7625	66.6224	268.765594	66.628383	96.46129	30.30238	172.28031	89.50452	IRC00	a;N	NORMAL	IRC Det off	MAIN	5030401	1	5030401					2007-02-28 21:29:24	20516522	https://data.darts.isas.jaxa.jp/pub/akari/AKARI__Pointed_RawDataPack_1.0/PV/PVIRC/AKARI_IRC_5030401_001.tar.gpg
22	2006-04-23 05:42:54	53848.238125	2006-04-23 05:42:54	53848.238125	5030404-001	IRC_NEP_PV_chk_00b_N	IRC Team	PVIRC	268.7625	66.6224	268.765594	66.628383	96.46129	30.30238	172.28031	89.50452	IRC00	b;N	NORMAL	Observed	MAIN	5030404	1	5030404	/1/2/	Earth shine, No dithering	2008-03-07 00:00:00	54532	2007-02-28 17:57:33	46591332	https://data.darts.isas.jaxa.jp/pub/akari/AKARI__Pointed_RawDataPack_1.0/PV/PVIRC/AKARI_IRC_5030404_001.tar.gz

Used SQL

SELECT * FROM akari_pointed_rawdata_package_info WHERE aot_type = 'NORMAL' AND aot_name = 'IRC00'

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

Go to top of this page ⏏