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_sec	exposure	sxi_1st_mode_exposure_sec	sxi_1st_mode_exposure	sxi_2nd_mode_exposure_sec	sxi_2nd_mode_exposure	hxi1_exposure_sec	hxi1_exposure	hxi2_exposure_sec	hxi2_exposure	sgd1_exposure_sec	sgd1_exposure	sgd2_exposure_sec	sgd2_exposure	is_sxs_on	is_sxs_fovin	is_sxi_on	is_sxi_fovin	is_hxi1_on	is_hxi1_fovin	is_hxi2_on	is_hxi2_fovin	is_sgd1_on	is_sgd1_fovin	is_sgd2_on	is_sgd2_fovin	sxs_data_mode	is_sxs_adr_cycle	is_sxs_filter_fe55	is_sxs_filter_open	sxs_threshould_setting_code	sxi_1st_data_mode	sxi_1st_dataclass_threshold	sxi_2nd_data_mode	sxi_2nd_dataclass_threshold	hxi1_data_mode	hxi2_data_mode	sgd1_data_mode	sgd2_data_mode	sgd1_cc1_exposure_sec	sgd1_cc1_exposure	sgd1_cc2_exposure_sec	sgd1_cc2_exposure	sgd1_cc3_exposure_sec	sgd1_cc3_exposure	sgd2_cc1_exposure_sec	sgd2_cc1_exposure	sgd2_cc2_exposure_sec	sgd2_cc2_exposure	sgd2_cc3_exposure_sec	sgd2_cc3_exposure	hxi_code	sgd_code	sxi_code	sxs_code	gen_code	processing_date_mjd	processing_date	public_date_mjd	public_date	distribution_date_mjd	distribution_date	processing_version	caldb_version	processing_software	proposal_abstract	proposal_category	proposal_category_code	pi_name	proposal_affiliated_country	proposal_title	data_access_url	sxs_corner1_ra	sxs_corner1_dec	sxs_corner2_ra	sxs_corner2_dec	sxs_corner3_ra	sxs_corner3_dec	sxs_corner4_ra	sxs_corner4_dec	sxs_corner5_ra	sxs_corner5_dec	sxs_corner6_ra	sxs_corner6_dec	sxs_corner1_ra_b1950	sxs_corner1_dec_b1950	sxs_corner2_ra_b1950	sxs_corner2_dec_b1950	sxs_corner3_ra_b1950	sxs_corner3_dec_b1950	sxs_corner4_ra_b1950	sxs_corner4_dec_b1950	sxs_corner5_ra_b1950	sxs_corner5_dec_b1950	sxs_corner6_ra_b1950	sxs_corner6_dec_b1950	sxs_corner1_ecliptic_lon	sxs_corner1_ecliptic_lat	sxs_corner2_ecliptic_lon	sxs_corner2_ecliptic_lat	sxs_corner3_ecliptic_lon	sxs_corner3_ecliptic_lat	sxs_corner4_ecliptic_lon	sxs_corner4_ecliptic_lat	sxs_corner5_ecliptic_lon	sxs_corner5_ecliptic_lat	sxs_corner6_ecliptic_lon	sxs_corner6_ecliptic_lat	sxs_corner1_galactic_lon	sxs_corner1_galactic_lat	sxs_corner2_galactic_lon	sxs_corner2_galactic_lat	sxs_corner3_galactic_lon	sxs_corner3_galactic_lat	sxs_corner4_galactic_lon	sxs_corner4_galactic_lat	sxs_corner5_galactic_lon	sxs_corner5_galactic_lat	sxs_corner6_galactic_lon	sxs_corner6_galactic_lat	sxi_corner1_ra	sxi_corner1_dec	sxi_corner2_ra	sxi_corner2_dec	sxi_corner3_ra	sxi_corner3_dec	sxi_corner4_ra	sxi_corner4_dec	sxi_corner1_ra_b1950	sxi_corner1_dec_b1950	sxi_corner2_ra_b1950	sxi_corner2_dec_b1950	sxi_corner3_ra_b1950	sxi_corner3_dec_b1950	sxi_corner4_ra_b1950	sxi_corner4_dec_b1950	sxi_corner1_ecliptic_lon	sxi_corner1_ecliptic_lat	sxi_corner2_ecliptic_lon	sxi_corner2_ecliptic_lat	sxi_corner3_ecliptic_lon	sxi_corner3_ecliptic_lat	sxi_corner4_ecliptic_lon	sxi_corner4_ecliptic_lat	sxi_corner1_galactic_lon	sxi_corner1_galactic_lat	sxi_corner2_galactic_lon	sxi_corner2_galactic_lat	sxi_corner3_galactic_lon	sxi_corner3_galactic_lat	sxi_corner4_galactic_lon	sxi_corner4_galactic_lat	hxi1_corner1_ra	hxi1_corner1_dec	hxi1_corner2_ra	hxi1_corner2_dec	hxi1_corner3_ra	hxi1_corner3_dec	hxi1_corner4_ra	hxi1_corner4_dec	hxi1_corner1_ra_b1950	hxi1_corner1_dec_b1950	hxi1_corner2_ra_b1950	hxi1_corner2_dec_b1950	hxi1_corner3_ra_b1950	hxi1_corner3_dec_b1950	hxi1_corner4_ra_b1950	hxi1_corner4_dec_b1950	hxi1_corner1_ecliptic_lon	hxi1_corner1_ecliptic_lat	hxi1_corner2_ecliptic_lon	hxi1_corner2_ecliptic_lat	hxi1_corner3_ecliptic_lon	hxi1_corner3_ecliptic_lat	hxi1_corner4_ecliptic_lon	hxi1_corner4_ecliptic_lat	hxi1_corner1_galactic_lon	hxi1_corner1_galactic_lat	hxi1_corner2_galactic_lon	hxi1_corner2_galactic_lat	hxi1_corner3_galactic_lon	hxi1_corner3_galactic_lat	hxi1_corner4_galactic_lon	hxi1_corner4_galactic_lat	hxi2_corner1_ra	hxi2_corner1_dec	hxi2_corner2_ra	hxi2_corner2_dec	hxi2_corner3_ra	hxi2_corner3_dec	hxi2_corner4_ra	hxi2_corner4_dec	hxi2_corner1_ra_b1950	hxi2_corner1_dec_b1950	hxi2_corner2_ra_b1950	hxi2_corner2_dec_b1950	hxi2_corner3_ra_b1950	hxi2_corner3_dec_b1950	hxi2_corner4_ra_b1950	hxi2_corner4_dec_b1950	hxi2_corner1_ecliptic_lon	hxi2_corner1_ecliptic_lat	hxi2_corner2_ecliptic_lon	hxi2_corner2_ecliptic_lat	hxi2_corner3_ecliptic_lon	hxi2_corner3_ecliptic_lat	hxi2_corner4_ecliptic_lon	hxi2_corner4_ecliptic_lat	hxi2_corner1_galactic_lon	hxi2_corner1_galactic_lat	hxi2_corner2_galactic_lon	hxi2_corner2_galactic_lat	hxi2_corner3_galactic_lon	hxi2_corner3_galactic_lat	hxi2_corner4_galactic_lon	hxi2_corner4_galactic_lat
1	100050020	G21.5-0.9	278.3872398	-10.5687737	277.69494	-10.60773	278.44969	12.62484	21.49938518	-0.88319535	88.49613788	57467.61037	2016-03-20 14:38:55.788	57468.70831	2016-03-21 16:59:58.009	52536.07813	52.53607813	25993.17218	25.99317218	0	0	473237.6563	473.2376563	473237.6563	473.2376563	49819.125	49.819125	0	0	Y	Y	Y	Y	Y	Y	Y	Y	Y	Y	N	N	PX_NORMAL	N	N	Y	A75A	WINDOW1	100004b0-100;100004b1-2048			CAMERA_NORMAL1	CAMERA_NORMAL1	CC_NORMAL1		98836.875	98.836875	25324.75	25.32475	25295.75	25.29575	0	0	0	0	0	0	33300	40300	11110	31343	11310	57864.42683	2017-04-21 10:14:00	58027	2017-10-01 00:00:00	58023.24241	2017-09-27 05:49:00	03.01.006.008	gen20170208_hxi20161122_sgd170926_sxi20170405_sxs20161122	Hea_05Apr2017_V6.21_Hitomi_04Apr2017_V006	SXS-GVC/SXI/HXI effective area	Galactic Diffuse	1	Takahashi Tadayuki	SWG	COMMISSIONING PHASE OBSERVATION OF G21.5-0.9	https://data.darts.isas.jaxa.jp/pub/hitomi/data/obs/1/100050020/	278.4114	-10.5437	278.359	-10.5451	278.3602	-10.5878	278.3689	-10.5875	278.3691	-10.596	278.4127	-10.595	277.71923	-10.58277	277.66682	-10.58392	277.66781	-10.62662	277.67651	-10.62636	277.67667	-10.63486	277.72028	-10.63407	278.47552	12.64846	278.42273	12.65012	278.42134	12.60743	278.43011	12.60722	278.42979	12.59872	278.47369	12.59717	21.53259	-0.89271	21.50759	-0.84765	21.47024	-0.86838	21.47445	-0.87583	21.467	-0.87993	21.48765	-0.9175	278.7578	-10.1779	278.109	-10.1951	278.1261	-10.8362	278.777	-10.8189	278.06749	-10.21864	277.41853	-10.23272	277.43244	-10.87389	278.0835	-10.85972	278.84718	12.99283	278.19192	13.01389	278.17129	12.37289	278.82566	12.3519	22.01429	-1.02671	21.70462	-0.46796	21.1437	-0.77892	21.4537	-1.33834	278.425217	-10.464337	278.283064	-10.526562	278.346351	-10.666346	278.488556	-10.604092	277.73344	-10.50347	277.59097	-10.56501	277.65356	-10.7051	277.7961	-10.64353	278.49428	12.72687	278.34747	12.67303	278.40266	12.52983	278.54939	12.58363	21.60929	-0.86819	21.48961	-0.77285	21.39426	-0.89252	21.51394	-0.98786	278.481665	-10.521099	278.336389	-10.466288	278.280591	-10.609116	278.425925	-10.663953	277.78962	-10.56051	277.6446	-10.505	277.58808	-10.64755	277.73316	-10.70309	278.54758	12.66688	278.40476	12.73011	278.34001	12.59077	278.48277	12.52757	21.58449	-0.9436	21.56728	-0.79157	21.41523	-0.80878	21.43244	-0.96081

Used SQL

SELECT * FROM hitomi_master_data WHERE observation_id = '100050020'

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

Go to top of this page ⏏