FAQ

Important announcements

The database for AKARI CAS was restructured into multiple databases. The 'cas' database is available as a new database instead of 'DR1'.
Due to the reconfiguration of the database, the name of some tables and views had changed. If you keep the previously created SQL and want to use again, please do substitution of the name. And also, the usage of some functions had changed.
The correspondence between the new name and the old name is written in Tables and Views. In Functions, please specify the catalogue names ('akari_fis_bsc_1' or 'akari_irc_psc_1') instead of the instrument ('Fis' or 'Irc'). We appreciate in your inconvenience.

The summary is below:

Index:


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

`IRC PSC 1.0 Cross ID' or `IRC PSC 1.0 Cross ID2' button of SQL Search page will show an example SQL statement to match-up FIS BSC 1.0 with IRC PSC 1.0 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 akari_fis_bsc_1_digest o
) p
LEFT JOIN
  akari_irc_psc_1_digest q
ON
  fGetNearestObjIDEq('akari_irc_psc_1', p.ra, p.dec, 0.5) = q.objID

The above SQL statement will show FIS BSC 1.0 objects without found IRC PSC 1.0 object. Replace `LEFT JOIN' with `JOIN', if you want to eliminate such FIS BSC 1.0 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 akari_fis_bsc_1_digest o
  WHERE 0.0 <= o.ra AND o.ra < 90.0
) p
LEFT JOIN
  akari_irc_psc_1_digest q
ON
  fGetNearestObjIDEq('akari_irc_psc_1', 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 akari_fis_bsc_1_digest 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

Last Modified: 01 July 2020