2MASS Catalog Server Kit

Install Small Catalogs


Page Index:
HOME / Install Huge Catalogs / Install Small Catalogs / Information about table columns / Hard Drive Copy Service

Index of Current Page:
Tycho-2 Catalogue / AKARI IRC PSC / AKARI FIS BSC / IRAS PSC


Before Installing Catalogs

Before installing catalogs, you have to setup OS, PostgreSQL and 2MASS Kit following the installation procedure.

Tycho-2 Catalogue Official Site

Number of rows: 2,539,913.

Enter `small_catalogs' directory, and run make.

$ cd small_catalogs
$ make

Use the script mk_tycho2_dbdata.php that downloads Tycho-2 Catalogue from ftp://cdsarc.u-strasbg.fr/pub/cats/I/259/ and creates a file for database registration:

$ wget http://darts.jaxa.jp/pub/ir/2masskit/v2/small_catalogs/tycho2_all.db.txt.gz
$ gunzip tycho2_all.db.txt.gz

Confirm the number of rows in data file `tycho2_all.db.txt':

$ wc -l tycho2_all.db.txt
2539913 tycho2_all.db.txt

As a normal user in UNIX log in to the database "2MASS" as 'admin' to register a table:

$ psql -U admin 2MASS
Password for user admin: xxxxxx
psql (8.4.5)
Type "help" for help.

2MASS=> \i tycho2_create_table.sql

Register data, and create index and functions as follows:

2MASS=> \i tycho2_copy.sql
2MASS=> \i tycho2_update.sql
2MASS=> \i tycho2_create_function.sql
2MASS=> \i tycho2_create_index.sql
2MASS=> \i tycho2_grant.sql
2MASS=> VACUUM ANALYZE tycho2;

The main table is tycho2. Stored functions for positional searches of Tycho-2 Catalogue are registered:

Stored FunctionsDescription
fTycho2GetNearbyObjEq() Radial Search for (ra, dec).
fTycho2GetNearbyObjCel() Radial Search for (ra, dec). A position in J2000, B1950, Ecliptic or Galactic is set to arguments.
fTycho2GetNearestObjIDEq() CrossID for (ra, dec).
fTycho2GetNearbyObjFromBoxCel() Box Search for (ra, dec). A position in J2000, B1950, Ecliptic or Galactic is set to arguments.
fTycho2GetObjFromRectEq() Rectangular Search for (ra, dec).
fTycho2mGetNearbyObjEq() Radial Search for (ra_m, dec_m).
fTycho2mGetNearbyObjCel() Radial Search for (ra_m, dec_m). A position in J2000, B1950, Ecliptic or Galactic is set to arguments.
fTycho2mGetNearestObjIDEq() CrossID for (ra_m, dec_m).
fTycho2mGetNearbyObjFromBoxCel() Box Search for (ra_m, dec_m). A position in J2000, B1950, Ecliptic or Galactic is set to arguments.
fTycho2mGetObjFromRectEq() Rectangular Search for (ra_m, dec_m).

The usage of functions is same to 2MASS PSC. See Usage for `twomass' table.


AKARI IRC PSC v1 Official Site

Number of rows: 870,973.

Enter `small_catalogs' directory, and run make.

$ cd small_catalogs
$ make

Download a file for database registration:

$ wget http://darts.jaxa.jp/pub/ir/2masskit/v2/small_catalogs/akariirc_all.db.txt.gz
$ gunzip akariirc_all.db.txt.gz

Confirm the number of rows in data file `akariirc_all.db.txt':

$ wc -l akariirc_all.db.txt
870973 akariirc_all.db.txt

As a normal user in UNIX log in to the database "2MASS" as 'admin' to register a table:

$ psql -U admin 2MASS
Password for user admin: xxxxxx
psql (8.4.5)
Type "help" for help.

2MASS=> \i akariirc_create_table.sql

Register data, and create index and functions as follows:

2MASS=> \i akariirc_copy.sql
2MASS=> \i akariirc_update.sql
2MASS=> \i akariirc_create_function.sql
2MASS=> \i akariirc_create_index.sql
2MASS=> \i akariirc_grant.sql
2MASS=> VACUUM ANALYZE akariirc;

The main table is akariirc. Stored functions for positional searches of AKARI IRC PSC are registered:

Stored FunctionsDescription
fAkariIrcGetNearbyObjEq() Radial Search for (ra, dec).
fAkariIrcGetNearbyObjCel() Radial Search for (ra, dec). A position in J2000, B1950, Ecliptic or Galactic is set to arguments.
fAkariIrcGetNearestObjIDEq() CrossID for (ra, dec).
fAkariIrcGetNearbyObjFromBoxCel() Box Search for (ra, dec). A position in J2000, B1950, Ecliptic or Galactic is set to arguments.
fAkariIrcGetObjFromRectEq() Rectangular Search for (ra, dec).

The usage of functions is same to 2MASS PSC. See Usage for `twomass' table.


AKARI FIS BSC v1 Official Site

Number of rows: 427,071.

Enter `small_catalogs' directory, and run make.

$ cd small_catalogs
$ make

Download a file for database registration:

$ wget http://darts.jaxa.jp/pub/ir/2masskit/v2/small_catalogs/akarifis_all.db.txt.gz
$ gunzip akarifis_all.db.txt.gz

Confirm the number of rows in data file `akarifis_all.db.txt':

$ wc -l akarifis_all.db.txt
427071 akarifis_all.db.txt

As a normal user in UNIX log in to the database "2MASS" as 'admin' to register a table:

$ psql -U admin 2MASS
Password for user admin: xxxxxx
psql (8.4.5)
Type "help" for help.

2MASS=> \i akarifis_create_table.sql

Register data, and create index and functions as follows:

2MASS=> \i akarifis_copy.sql
2MASS=> \i akarifis_update.sql
2MASS=> \i akarifis_create_function.sql
2MASS=> \i akarifis_create_index.sql
2MASS=> \i akarifis_grant.sql
2MASS=> VACUUM ANALYZE akarifis;

The main table is akarifis. Stored functions for positional searches of AKARI FIS BSC are registered:

Stored FunctionsDescription
fAkariFisGetNearbyObjEq() Radial Search for (ra, dec).
fAkariFisGetNearbyObjCel() Radial Search for (ra, dec). A position in J2000, B1950, Ecliptic or Galactic is set to arguments.
fAkariFisGetNearestObjIDEq() CrossID for (ra, dec).
fAkariFisGetNearbyObjFromBoxCel() Box Search for (ra, dec). A position in J2000, B1950, Ecliptic or Galactic is set to arguments.
fAkariFisGetObjFromRectEq() Rectangular Search for (ra, dec).

The usage of functions is same to 2MASS PSC. See Usage for `twomass' table.


IRAS PSC v2.1 Official Site

Number of rows: 245,889.

Enter `small_catalogs' directory, and run make.

$ cd small_catalogs
$ make

Use the script mk_iras_dbdata.sh that downloads IRAS PSC from IRSA and creates a file for database registration:

$ wget http://darts.jaxa.jp/pub/ir/2masskit/v2/small_catalogs/iras_all.db.txt.gz
$ gunzip iras_all.db.txt.gz

Confirm the number of rows in data file `iras_all.db.txt':

$ wc -l iras_all.db.txt 
245889 iras_all.db.txt

As a normal user in UNIX log in to the database "2MASS" as 'admin' to register a table:

$ psql -U admin 2MASS
Password for user admin: xxxxxx
psql (8.4.5)
Type "help" for help.

2MASS=> \i iras_create_table.sql

Register data, and create index and functions as follows:

2MASS=> \i iras_copy.sql
2MASS=> \i iras_update.sql
2MASS=> \i iras_create_function.sql
2MASS=> \i iras_create_index.sql
2MASS=> \i iras_grant.sql
2MASS=> VACUUM ANALYZE iras;

The main table is iras. Stored functions for positional searches of IRAS PSC are registered:

Stored FunctionsDescription
fIrasGetNearbyObjEq() Radial Search for (ra, dec).
fIrasGetNearbyObjCel() Radial Search for (ra, dec). A position in J2000, B1950, Ecliptic or Galactic is set to arguments.
fIrasGetNearestObjIDEq() CrossID for (ra, dec).
fIrasGetNearbyObjFromBoxCel() Box Search for (ra, dec). A position in J2000, B1950, Ecliptic or Galactic is set to arguments.
fIrasGetObjFromRectEq() Rectangular Search for (ra, dec).

The usage of functions is same to 2MASS PSC. See Usage for `twomass' table.