Table of Contents of 2MASS All-Sky Data Release FTP Site



1. DATA FILES

psc_aaa.gz through psc_ace.gz Point Source Catalog    (declination < 0.0°)
psc_baa.gz through psc_bbi.gz Point Source Catalog    (declination > 0.0°)
scn_aaa.gz Scan Information Table    
xsc_aaa.gz Extended Source Catalog    (declination < 0.0°)
xsc_baa.gz Extended Source Catalog    (declination > 0.0°)

Data files should be verified before being loaded into database server tables.

Command: #lines: #words: #char:
zcat psc_aaa.gz   |   wc 5144500102889901718317178
    All files psc_aaa.gz through psc_acd.gz have 5,144,500 lines (sources).
zcat psc_ace.gz   |   wc 5144074 10287736 1680458173
    All files psc_baa.gz through psc_bbh.gz have 5,100,000 lines (sources).
zcat psc_baa.gz   |   wc 5100000 10199684 1665533284
zcat psc_bbi.gz   |   wc 4356896 8713770 1446520107
zcat scn_aaa.gz   |   wc 59731 59731 23265489
zcat xsc_aaa.gz   |   wc 738782 1502713 1287154792
zcat xsc_baa.gz   |   wc 9088171832471 1573246390

Total number of lines in Point Source Catalog:470,992,970
Total number of lines in Scan Information Table:59,731
Total number of lines in Extended Source Catalog:1,647,599


2. SCHEMAS

twomass_psc_schema Postgres schema for loading point source data.
twomass_scn_schema Postgres schema for loading scan information table.
twomass_xsc_schema Postgres schema for loading extended source data.


3. PRACTICE DIRECTORY

test_psc The first 10 lines of the Point Source Catalog data (from psc_aaa).
test_xsc The first 10 lines of the Extended Source Catalog data (from xsc.aaa).
test_psc_query.html The result of a select(*) from test_psc query.
test_psc_query.txt The result of a select(*) from test_psc query.
test_xsc_query.html The result of a select(*) from test_xsc query.
test_xsc_query.txt The result of a select(*) from test_xsc query.
test_psc_schema Postgres schema for loading Test Point Source Catalog into a table named test_psc.
test_xsc_schema Postgres schema for loading Test Extended Source Catalog into a table named test_xsc.
format_psc.html Column description of the Point Source Catalog.
format_xsc.html Column description of the Extended Source Catalog.


4. DATA VALIDATION

verification_query_psc.html Sums of selected integer columns of the Point Source Catalog.
verification_query_psc.txt Sums of selected integer columns of the Point Source Catalog.
verification_query_scn.html Sums of selected integer columns of the Scan Information Table.
verification_query_scn.txt Sums of selected integer columns of the Scan Information Table.
verification_query_xsc.html Sums of selected integer columns of the Extended Source Catalog.
verification_query_xsc.txt Sums of selected integer columns of the Extended Source Catalog.


5. DOCUMENTS

contents.html This page.
README_ftp.html Instructions for loading data tables and data format description.
format_psc.html Column descriptions of the Point Source Catalog.
format_scn.html Column descriptions of the Scan Information Table.
format_xsc.html Column descriptions of the Extended Source Catalog.

Revision 5:   April 13, 2003:   R. Stiening