DARTS/Akari at ISAS/JAXA

FAQ

Index:

How can I match-up FIS catalog with IRC catalog?

How can I match-up FIS catalog with IRC catalog?

`IRC Cross ID' or `IRC Cross ID2' button of SQL Search page will show an example SQL statement to match-up FIS with IRC objects.

Less than 1 minute will be required to match-up all objects, when search radius is less than 1.0 arcmin. Here is an example:

SELECT p.*, q.*
FROM
(
  SELECT o.*
  FROM FisObj o
) p
LEFT JOIN
  IrcObj q
ON
  fGetNearestObjIDEq('irc', p.ra, p.dec, 0.5) = q.objID

The above SQL statement will show FIS objects without found IRC object. Replace `LEFT JOIN' with `JOIN', if you want to eliminate such FIS objects.

The query timeout is 90 seconds for Web browser interface. Therefore, if you want to obtain the whole result with large search radius using your Web browser, you have to divide your query into more than 4 parts like this:

SELECT p.*, q.*
FROM
(
  SELECT o.*
  FROM FisObj o
  WHERE 0.0 <= o.ra AND o.ra < 90.0
) p
LEFT JOIN
  IrcObj q
ON
  fGetNearestObjIDEq('irc', p.ra, p.dec, 0.5) = q.objID

Longer timeout is set for Command Line Tools. If you use them, such division might not be required.

IRAS, IRAS FSC and RC3 catalogs were also registered into our database. Cross-identification between AKARI catalogs and them is also possible. We show an example:

SELECT p.*, q.*
FROM
(
  SELECT o.*
  FROM FisObj o
  WHERE 0.0 <= o.ra AND o.ra < 90.0
) p
LEFT JOIN
  Iras q
ON
  fGetNearestObjIDEq('iras', p.ra, p.dec, 0.5) = q.objID