This paper describes the organization of the database and the catalog data products from the Pan-STARRS1 $3\pi$ Steradian Survey. The catalog data products are available in the form of an SQL-based relational database from MAST, the Mikulski Archive for Space Telescopes at STScI. The database is described in detail, including the construction of the database, the provenance of the data, the schema, and how the database tables are related. Examples of queries for a range of science goals are included. The catalog data products are available in the form of an SQL-based relational database from MAST, the Mikulski Archive for Space Telescopes at STScI.

Pan-STARRS1 has carried out a set of distinct synoptic imaging sky surveys including the $3\pi$ Steradian Survey and the Medium Deep Survey in 5 bands ($grizy_{P1}$). The mean 5$\sigma$ point source limiting sensitivities in the stacked 3$\pi$ Steradian Survey in $grizy_{P1}$ are (23.3, 23.2, 23.1, 22.3, 21.4) respectively. The upper bound on the systematic uncertainty in the photometric calibration across the sky is 7-12 millimag depending on the bandpass. The systematic uncertainty of the astrometric calibration using the Gaia frame comes from a comparison of the results with Gaia: the standard deviation of the mean and median residuals ($ \Delta ra, \Delta dec $) are (2.3, 1.7) milliarcsec, and (3.1, 4.8) milliarcsec respectively. The Pan-STARRS system and the design of the PS1 surveys are described and an overview of the resulting image and catalog data products and their basic characteristics are described together with a summary of important results. The images, reduced data products, and derived data products from the Pan-STARRS1 surveys are available to the community from the Mikulski Archive for Space Telescopes (MAST) at STScI.

This document describes the Astronomical Data Query Language (ADQL). ADQL has been developed based on SQL92. This document describes the subset of the SQL grammar supported by ADQL. Special restrictions and extensions to SQL92 have been defined in order to support generic and astronomy specific operations.

We present a detailed study of the Galaxy Evolution Explorer's photometric catalogs with special focus on the statistical properties of the All-sky and Medium Imaging Surveys. We introduce the concept of primaries to resolve the issue of multiple detections and follow a geometric approach to define clean catalogs with well-understood selection functions. We cross-identify the GALEX sources (GR2+3) with Sloan Digital Sky Survey (DR6) observations, which indirectly provides an invaluable insight about the astrometric model of the UV sources and allows us to revise the band merging strategy. We derive the formal description of the GALEX footprints as well as their intersections with the SDSS coverage along with analytic calculations of their areal coverage. The crossmatch catalogs are made available for the public. We conclude by illustrating the implementation of typical selection criteria in SQL for catalog subsets geared toward statistical analyses, e.g., correlation and luminosity function studies.

We examine cosmic ray rejection methodology on data collected from InSb and Si:As detectors. The application of an Up-the-Ramp sampling technique with cosmic ray identification and mitigation is the focus of this study. This technique is valuable for space-based observatories which are exposed to high-radiation environments. We validate the Up-the-Ramp approach on radiation-test data sets with InSb and Si:As detectors which were generated for SIRTF. The Up-the-Ramp sampling method studied in this paper is over 99.9% effective at removing cosmic rays and preserves the structure and photometric quality of the image to well within the measurement error.

We present an algorithm to optimally process uniformly sampled array image data obtained with a nondestructive readout. The algorithm discards full wells, removes cosmic ray (particle) hits and other glitches, and makes a nearly optimum estimate of the signal on each pixel. The algorithm also compresses the data. The computer requirements are modest, and the results are robust. The results are shown and compared to results of Fowler sampled and processed data. Non-ideal detector performance may require some additional code, but this is not expected to cost much processing time. Known types of detector faults are addressed.

We present a data simulation package designed to create a series of simulated data samples for a detector with non-destructive sampling capability. The original intent of this software was to provide a method for generating simulated images for the Next Generation Space Telescope, but it is general enough to apply to almost any non-destructive detector or instrument. MultiDataSim can be used to generate "practice" sampling strategies for an instrument or field-of-view, and thus can be used to identify optimal observation strategies.

The NASA Yardstick design for the Integrated Science Instrument Module (ISIM) utilizes 64 1k x 1k InSb imagers. Since multiple readouts per image are required to remove cosmic ray events and to reduce the readout noise, the implied downlink rates can approach 0.7 Tbytes per day. These would exceed the downlink capabilities of RF links from L2 or more distant orbits. Some form of on-board data analysis and compression is mandatory: a factor of 100 compression for an L2 orbit, factors of 1000-10000 for a 1 AU drift-away or 1 x 3 AU elliptical orbit. Supported by funding from JPL to study the uses of low-cost, on- board parallel processors, we are studying algorithms and architectures to perform cosmic-ray rejection and lossless compression of the NIR images, while optimizing the resulting signal- to-noise.