Wisep for 2MASS Catalog Server Kit

This is an additional package which provides search functions of WISE (the Wide-field Infrared Survey Explorer) Preliminary Release Catalog for the 2MASS Catalog Server Kit (version 2). Note that this requires about 350 GB disk space.

Download

Additional package for `Wisep' is below.

• wisep_2masskit.tar.gz

Data files are available via HTTP.
You can donwload the entire data files using wget script.

• wget_script.sh

Installation

Before installing `Wisep', you have to setup OS, PostgreSQL and 2MASS Kit. Basic instruction of installing 2MASS Kit is shown in this page.

`Wisep' support can be enabled by following procedure:

• wget -nd http://www.ir.isas.jaxa.jp/~takita/wisep_2masskit.tar.gz
• tar zxvf wisep_2masskit.tar.gz
• mv wisep_2masskit/pg_module/* 2masskit-2.0b/pg_module/
• mv wisep_2masskit/wisep 2masskit-2.0b/
• cd 2masskit-2.0b
• make
• su

• make install

Next, re-register C stored functions to support `Wisep' as

• cd 2masskit-2.0b
• psql -U postgres 2MASS

• \i create_c_function.sql

Then, proceed to catalog installation. You can create the `Wisep' catalog server following the original installation page. Note that you need to replace `twomass' to `wisep'.

Example of Catalog Installation

Here is an example of commands.
I will show the required time with an Adaptec RAID 2405 + S-ATA HDD x 4 (RAID10). It will take 9 hours or more to complete registering the main table. In creating the dedicated positional search table, it will take about 10 and 15 minutes to register the table and create indexes, respectively.

• cd 2masskit-2.0b/wisep
• ln -s (somewhere)/wisep_data/*.db.txt .
• vi Makefile (Optional)
• make
• psql -U postgres 2MASS

• \i wisep_create_tablespace.sql
• \q

• psql -U admin 2MASS

• \i wisep_create_table.sql
• \i wisep_main_copy.sql
• \i wisep_eqi_create_table.sql
• \i wisep_eqi_copy.sql
• \i wisep_eqi_create_index.sql
• \i wisep_create_function.sql
• \i wisep_main_grant.sql
• \i wisep_eqi_grant.sql
• \i wisep_main_create_index.sql (Optional)
• VACUUM ANALYZE;
• \q

Functions

Stored functions for `Wisep' are as follows.

• fWisepGetNearestObjIDEq(ra, dec, radius[arcmin])
  CrossID for (ra, dec).
  • SELECT * FROM fWisepGetNearestObjIDEq(30, 30, 1);
• fWisepGetNearbyObjEq(ra, dec, radius[arcmin])
  Radial Search for (ra, dec).
  • SELECT * FROM fWisepGetNearbyObjEq(30, 30, 1);
• fWisepGetNearbyObjCel(wcs, lon, lat, radius[arcmin])
  Radial Search for (lon, lat).
  A position in J2000, B1950, Ecliptic or Galactic is set to arguments.
  • SELECT * FROM fWisepGetNearbyObjCel('j2000', 30, 30, 1);
• fWisepGetNearbyObjFromBoxCel(wcs, lon, lat, d_lon[arcmin], d_lat[arcmin])
  Box Search for (lon, lat).
  A position in J2000, B1950, Ecliptic or Galactic is set to arguments.
  • SELECT * FROM fWisepGetNearbyObjFromBoxCel('j2000', 30, 30, 1, 1);
• fWisepGetObjFromRectEq(ra1, ra2, dec1, dec2)
  Rectangular Search for (ra, dec).
  • SELECT * FROM fWisepGetObjFromRectEq(30, 30.1, 30, 30.1);