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 source catalogs documentation page.
Tip | ||||||
---|---|---|---|---|---|---|
| ||||||
|
ObjectThin
test lineThe starting point for the PS1 data archive is at Pan-STARRS1 data archive home page.
Tables included in DR1
ObjectThin
Excerpt Include | ||||||
---|---|---|---|---|---|---|
|
MeanObject
test lineExcerpt Include | ||||||
---|---|---|---|---|---|---|
|
AstrometryCorrection
Excerpt Include | ||||||
---|---|---|---|---|---|---|
|
StackObjectThin
test lineExcerpt Include | ||||||
---|---|---|---|---|---|---|
|
StackObjectAttributes
test lineExcerpt Include | ||||||
---|---|---|---|---|---|---|
|
StackApFlx
test line
Excerpt Include | ||||||
---|---|---|---|---|---|---|
|
StackApFlxExGalUnc
test line
Excerpt Include | ||||||
---|---|---|---|---|---|---|
|
StackApFlxExGalCon6
test line
Excerpt Include | ||||||
---|---|---|---|---|---|---|
|
StackApFlxExGalCon8
test line
Excerpt Include | ||||||
---|---|---|---|---|---|---|
|
StackModelFitExp
test lineExcerpt Include | ||||||
---|---|---|---|---|---|---|
|
StackModelFitDeV
test line
Excerpt Include | ||||||
---|---|---|---|---|---|---|
|
StackModelFitSer
test line
Excerpt Include | ||||||
---|---|---|---|---|---|---|
|
StackModelFitExtra
test lineStackPetrosian
Excerpt Include |
---|
|
|
ForcedMeanObject
test line
Excerpt Include |
---|
|
|
ForcedMeanLensing
Excerpt Include |
---|
|
|
DiffDetObject
Tables included in DR2
These tables were not included in DR1 but are in the DR2 database.
Detection
test lineExcerpt Include |
---|
|
|
ForcedWarpMeasurement
test lineExcerpt Include | ||||||
---|---|---|---|---|---|---|
|
ForcedWarpExtended
test line
Excerpt Include | ||||||
---|---|---|---|---|---|---|
|
ForcedWarpMasked
test line
Excerpt Include |
---|
|
|
ForcedGalaxyShape
test line
Excerpt Include |
---|
|
|
ForcedMeanLensing
test lineStackModelFitExtra
Excerpt Include |
---|
|
|
ForcedGalaxyShape
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
test lineExcerpt Include |
---|
|
|
ForcedWarpMasked
test lineDiffDetObject
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
test line
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 |