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, you have to setup OS, PostgreSQL and 2MASS Kit following the installation procedure.
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 Functions | Description |
---|---|
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.
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 Functions | Description |
---|---|
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.
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 Functions | Description |
---|---|
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.
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 Functions | Description |
---|---|
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.