Page History
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 catalogs documentation page.
Tip | ||||||
---|---|---|---|---|---|---|
| ||||||
|
The starting point for the PS1 data archive is at Pan-STARRS1 data archive home page.
Tables included in DR1
ObjectThin
Excerpt Include | ||||||
---|---|---|---|---|---|---|
|
MeanObject
Excerpt Include | ||||||
---|---|---|---|---|---|---|
|
AstrometryCorrection
Excerpt Include | ||||||
---|---|---|---|---|---|---|
|
StackObjectThin
Excerpt Include | ||||||
---|---|---|---|---|---|---|
|
StackObjectAttributes
Excerpt Include | ||||||
---|---|---|---|---|---|---|
|
StackApFlx
Excerpt Include | ||||||
---|---|---|---|---|---|---|
|
StackApFlxExGalUnc
Excerpt Include | ||||||
---|---|---|---|---|---|---|
|
StackApFlxExGalCon6
Excerpt Include | ||||||
---|---|---|---|---|---|---|
|
StackApFlxExGalCon8
Excerpt Include | ||||||
---|---|---|---|---|---|---|
|
StackModelFitExp
Excerpt Include | ||||||
---|---|---|---|---|---|---|
|
StackModelFitDeV
Excerpt Include | ||||||
---|---|---|---|---|---|---|
|
StackModelFitSer
Excerpt Include | ||||||
---|---|---|---|---|---|---|
|
StackPetrosian
Excerpt Include | ||||||
---|---|---|---|---|---|---|
|
ForcedMeanObject
Excerpt Include | ||||||
---|---|---|---|---|---|---|
|
ForcedMeanLensing
Excerpt Include | ||||||
---|---|---|---|---|---|---|
|
Tables included in DR2
These tables were not included in DR1 but are in the DR2 database.
Detection
Excerpt Include | ||||||
---|---|---|---|---|---|---|
|
ForcedWarpMeasurement
Excerpt Include | ||||||
---|---|---|---|---|---|---|
|
ForcedWarpExtended
Excerpt Include | ||||||
---|---|---|---|---|---|---|
|
ForcedWarpMasked
Excerpt Include | ||||||
---|---|---|---|---|---|---|
|
ForcedGalaxyShape
Excerpt Include | ||||||
---|---|---|---|---|---|---|
|
StackModelFitExtra
Excerpt Include | ||||||
---|---|---|---|---|---|---|
|
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 | ||||||
---|---|---|---|---|---|---|
|
DiffDetObject
Excerpt Include | ||||||
---|---|---|---|---|---|---|
|
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 View | Joined tables | Notes |
---|---|---|
DetectionObjectView | ObjectThin, Detection | DR2 |
DiffDetObjectView | DiffDetObject, DiffDetection | Not populated in DR2 |
ForcedGalaxyModelView | ObjectThin, ForcedGalaxyShape | DR2 |
ForcedMeanObjectView | ObjectThin, ForcedMeanObject | Not yet in DR2 |
MeanObjectView | MeanObject, ObjectThin | |
StackApFlxExGalCon6ObjectView | ObjectThin, StackApFlxExGalCon6 | |
StackApFlxExGalCon8ObjectView | ObjectThin, StackApFlxExGalCon8 | |
StackApFlxExGalUncView | ObjectThin, StackApFlxExGalUnc | |
StackApFlxObjectView | ObjectThin, StackApFlx, StackModelFitSer | |
StackModelFitDeVObjectView | ObjectThin, StackModelFitDeV | |
StackModelFitExpObjectView | ObjectThin, StackModelFitExp | |
StackModelFitPetObjectView | ObjectThin, StackPetrosian | |
StackModelFitSerObjectView | ObjectThin, StackModelFitSer | |
StackModelObjectView | ObjectThin, StackModelFitExp, StackModelFitDeVm, StackModelFitSer, StackPetrosian | Note: User beware that this view contains a lot of columns and selecting all of them is not recommended. |
StackObjectView | ObjectThin, StackObjectThin, StackObjectAttributes |