| 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 | 5144500 | 10288990 | 1718317178 |
| 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 | 908817 | 1832471 | 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 |
| 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. |
| 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. |
| 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. |
| 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