Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.



 

This page describes the contents of the PanSTARRS-1 database object and detection tables.  These tables have information such as positions, magnitudes, and morphological descriptions for the objects in the PS1 catalogs. They also include time-dependent measurements of those parameters.  Tables with multi-epoch measurements are not included in the DR1 data release and are listed separately.

These descriptions are extracted from the PSPS Schema Browser interface created by the University of Hawaii.  For a high-level overview of the tables, see the PS1 : Source extraction and source catalogs documentation page. 

Tip
iconfalse
titleContents

Table of Contents
maxLevel2
indent20px

The starting point for the PS1 data archive is at Pan-STARRS1 data archive home page.

Tables included in DR1

ObjectThin

Excerpt Include
PS1 ObjectThin table fields
PS1 ObjectThin table fields
nopaneltrue

MeanObject

Excerpt Include
PS1 MeanObject table fields
PS1 MeanObject table fields
nopaneltrue

AstrometryCorrection

Excerpt Include
PS1 AstrometryCorrection table fields
PS1 AstrometryCorrection table fields
nopaneltrue

StackObjectThin

Excerpt Include
PS1 StackObjectThin table fields
PS1 StackObjectThin table fields
nopaneltrue

StackObjectAttributes

Excerpt Include
PS1 StackObjectAttributes table fields
PS1 StackObjectAttributes table fields
nopaneltrue

StackApFlx

Excerpt Include
PS1 StackApFlx table fields
PS1 StackApFlx table fields
nopaneltrue

StackApFlxExGalUnc

Excerpt Include
PS1 StackApFlxExGalUnc table fields
PS1 StackApFlxExGalUnc table fields
nopaneltrue

StackApFlxExGalCon6

Excerpt Include
PS1 StackApFlxExGalCon6 table fields
PS1 StackApFlxExGalCon6 table fields
nopaneltrue

StackApFlxExGalCon8

Excerpt Include
PS1 StackApFlxExGalCon8 table fields
PS1 StackApFlxExGalCon8 table fields
nopaneltrue

StackModelFitExp

Excerpt Include
PS1 StackModelFitExp table fields
PS1 StackModelFitExp table fields
nopaneltrue

StackModelFitDeV

Excerpt Include
PS1 StackModelFitDeV table fields
PS1 StackModelFitDeV table fields
nopaneltrue

StackModelFitSer

Excerpt Include
PS1 StackModelFitSer table fields
PS1 StackModelFitSer table fields
nopaneltrue

StackModelFitExtra

StackPetrosian

Excerpt Include
StackModelFitExtraStackModelFitExtraPS1 StackPetrosian table fields
PS1 StackPetrosian table fields
nopaneltrue

StackPetrosian

ForcedMeanObject

Excerpt Include
StackPetrosianStackPetrosianPS1 ForcedMeanObject table fields
PS1 ForcedMeanObject table fields
nopaneltrue

ForcedMeanObject

ForcedMeanLensing

Excerpt Include
ForcedMeanObjectForcedMeanObjectPS1 ForcedMeanLensing table fields
PS1 ForcedMeanLensing table fields
nopaneltrue

Tables

not

included in

DR1

DR2

The These tables below are not part of the DR1 database, but their descriptions are included for completenesswere not included in DR1 but are in the DR2 database.

Detection

Excerpt Include
PS1 Detection table fields
PS1 Detection table fields
nopaneltrue

DiffDetection

ForcedWarpMeasurement

Excerpt Include
DiffDetectionDiffDetectionPS1 ForcedWarpMeasurement table fields
PS1 ForcedWarpMeasurement table fields
nopaneltrue

DiffDetObject

ForcedWarpExtended

Excerpt Include
DiffDetObjectDiffDetObjectPS1 ForcedWarpExtended table fields
PS1 ForcedWarpExtended table fields
nopaneltrue

ForcedWarpMeasurement

ForcedWarpMasked

Excerpt Include
ForcedWarpMeasurementForcedWarpMeasurementPS1 ForcedWarpMasked table fields
PS1 ForcedWarpMasked table fields
nopaneltrue

ForcedWarpExtended

ForcedGalaxyShape

Excerpt Include
ForcedWarpExtendedForcedWarpExtendedPS1 ForcedGalaxyShape table fields
PS1 ForcedGalaxyShape table fields
nopaneltrue

ForcedWarpMasked

StackModelFitExtra

Excerpt Include
ForcedWarpMaskedForcedWarpMaskedPS1 StackModelFitExtra table fields
PS1 StackModelFitExtra table fields
nopaneltrue

ForcedMeanLensing

Tables not included in DR1 or DR2

The tables below are not part of the DR1 or DR2 databases (yet), but their descriptions are included for completeness.

DiffDetection

Excerpt Include
ForcedMeanLensingForcedMeanLensingPS1 DiffDetection table fields
PS1 DiffDetection table fields
nopaneltrue

ForcedGalaxyShape

DiffDetObject

Excerpt Include
ForcedGalaxyShapeForcedGalaxyShapePS1 DiffDetObject table fields
PS1 DiffDetObject table fields
nopaneltrue

Alignalignleft

Views in DR1 and DR2

There are a number of views in the Pan-STARRS databases, which are generally cases where there are two related tables that are joined to make a wide table that includes columns from both tables.  Rather than make this page extremely long, we simply list the relevant views below with links to the individual pages that list the columns in those views.

There are also some views that are created because a very large table is broken up into multiple pieces for practical database implementation reasons.  The various chunks of rows are combined together into what looks like a single big table.  An example is the Detection table, which was simply too large to put into a single table.  Those "virtual" tables are listed above with the regular tables because they are never accessed by users as individual tables.  It is a confusing fact that they appear in the MyDB Views tab when exploring the database.

Name of ViewJoined tablesNotes
DetectionObjectViewObjectThin, DetectionDR2
DiffDetObjectViewDiffDetObject, DiffDetectionNot populated in DR2
ForcedGalaxyModelViewObjectThin, ForcedGalaxyShapeDR2
ForcedMeanObjectViewObjectThin, ForcedMeanObjectNot yet in DR2
MeanObjectViewMeanObject, ObjectThin
StackApFlxExGalCon6ObjectViewObjectThin, StackApFlxExGalCon6
StackApFlxExGalCon8ObjectViewObjectThin, StackApFlxExGalCon8
StackApFlxExGalUncViewObjectThin, StackApFlxExGalUnc
StackApFlxObjectView ObjectThin, StackApFlx, StackModelFitSer
StackModelFitDeVObjectViewObjectThin, StackModelFitDeV
StackModelFitExpObjectViewObjectThin, StackModelFitExp
StackModelFitPetObjectViewObjectThin, StackPetrosian
StackModelFitSerObjectViewObjectThin, StackModelFitSer
StackModelObjectViewObjectThin, StackModelFitExp, StackModelFitDeVm, StackModelFitSer, StackPetrosianNote: User beware that this view contains a lot of columns and selecting all of them is not recommended.
StackObjectViewObjectThin, StackObjectThin, StackObjectAttributes