DARTS/Akari at ISAS/JAXA

Cross Identifications

This page provides an interface for dynamic cross identifications of FIS or IRC objects with a user defined list of object positions. The positions (lon,lat) of user's list can be set by J2000, B1950, Ecliptic or Galactic coordinate.

For each position in your upload list, this tool can search not only a nearest object but also all nearby objects. If you want to obtain the list of all nearby objects, set "All nearby objects" at the Search scope selector.

Conditions:

Search scope
Search radius (Max 30.0 arcmin)
Coordinate system of Upload list

Upload list (Cut and paste your list here):	Or, upload list as text file:
name longitude latitude A1 195.1620 2.5028 A2 162.9899 3.7919 A3 12:55:15.26 +02:53:48.8 A4 02 52 20.38 -87 20 22.6

Note: Upload list including `[±]12:34:56.7' and `[±]12 34 56.7' styles is also accepted. Name column is automatically generated when omitting name column in your list. The upload file is limited to a size of 80kB. See also Query Limits page for details.

Selection of Table and Columns:

FIS simple result	Obtain the Result table only.
FIS digest	name_x, seqNo and distance of Result table and all columns of FisObj are selected.
FIS all	name_x, seqNo and distance of Result table and all columns of FisObjAll are selected.
FIS SQL	SELECT n.name_x, n.seqNo, n.objCount, n.distance, o.objID, o.objName, o.ra, o.dec, o.flux_65, o.flux_90, o.flux_140, o.flux_160 FROM #result n, FisObjAll o WHERE n.objID = o.objID ORDER BY n.id_x, n.objCount
IRC simple result	Obtain the Result table only.
IRC digest	name_x, seqNo and distance of Result table and all columns of IrcObj are selected.
IRC all	name_x, seqNo and distance of Result table and all columns of IrcObjAll are selected.
IRC SQL	SELECT n.name_x, n.seqNo, n.objCount, n.distance, o.objID, o.objName, o.ra, o.dec, o.flux_09, o.flux_18 FROM #result n, IrcObjAll o WHERE n.objID = o.objID ORDER BY n.id_x, n.objCount
FIS+IRC SQL	SELECT n.id_x, n.name_x, n.ra_x, n.dec_x, n.seqNo, n.objCount, n.distance, o., m.id_x, m.name_x, m.ra_x, m.dec_x, m.seqNo, m.objCount, m.distance, p. FROM #fis_result n LEFT JOIN FisObj o ON n.objID = o.objID FULL JOIN #irc_result m ON n.id_x = m.id_x LEFT JOIN IrcObj p ON m.objID = p.objID ORDER BY n.id_x, m.id_x, n.objCount, m.objCount

Note: Do not remove `#*result' and `n.objID = o.objID'.

Database:

Format:

HTML

TEXT delimiter: newline:

You can select version of FIS and IRC catalogs by Database selector. Default setting is for latest version of catalog set.

The `#result' argument in SQL statement is replaced with fGetCrossIdResultEq() function which will perform the cross identification and return a table of result. This table includes the following information.

Result table returned by fGetCrossIdResultEq():

name	type	description
id_x	INT4	Sequential ID of uploaded target position.
name_x	VARCHAR	Name of uploaded target position.
ra_x	FLOAT8	R.A.(J2000) of uploaded target position.
dec_x	FLOAT8	Dec.(J2000) of uploaded target position.
seqNo	INT4	Sequential number of uploaded target having found object(s). SeqNo of last row indicates total number of target positions which have found object(s).
objCount	INT4	Count of found object(s) for each uploaded target position.
distance	FLOAT8	Distance (arcmins) between (ra_x, dec_x) and found object.
objID	INT4	Object ID of found object.

See the SQL schema page to find out more about structure or function of the SQL.

Last Modified: 26 April 2011