IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Ignore:
Timestamp:
Nov 9, 2015, 11:48:04 AM (11 years ago)
Author:
eugene
Message:

delete CameraConfig table; delete photoColor (FW and OB); add magnitude unites to zeropoint and extinction; add ObjectThin.epochMean; add Stack.DetEffMeta.nInjected, Diff.DetEffMeta.nInjected, Stack.DetEffMeta.nInjected; delete stackDetectRowID; add (grizy)Epoch

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/ippToPsps/config/tables.ST.vot

    r39067 r39081  
    66    <!-- StackMeta Table ************************************************** -->
    77    <TABLE name="StackMeta">
    8       <DESCRIPTION>Contains the metadata describing the stacked image produced from a set of single epoch exposures.  The astrometric and photometric calibration of the stacked image are listed.</DESCRIPTION>
     8      <DESCRIPTION>Contains the metadata describing the stacked image
     9      produced from the combination of a set of single epoch
     10      exposures.  The nature of the stack is given by the StackTypeID.
     11      The astrometric and photometric calibration of the stacked image
     12      are listed.</DESCRIPTION>
    913      <PARAM arraysize="1" datatype="char" ucd="meta.bib.author" name="Author" value="PSPS"></PARAM>             
    1014      <FIELD name="stackImageID" arraysize="1" datatype="long" unit="dimensionless" default="NA">
     
    9498      <FIELD name="photoZero" arraysize="1" datatype="float" unit="magnitudes" default="-999">
    9599        <DESCRIPTION>Locally derived photometric zero point for this stack.</DESCRIPTION>
    96       </FIELD>
    97       <FIELD name="photoColor" arraysize="1" datatype="float" unit="magnitudes" default="-999">
    98         <DESCRIPTION>Locally derived photometric color term for this stack.</DESCRIPTION>
    99100      </FIELD>
    100101      <FIELD name="ctype1" arraysize="100" datatype="char" unit="dimensionless" default="">
     
    170171        <DESCRIPTION>Random value drawn from the interval between zero and one.</DESCRIPTION>
    171172      </FIELD>
    172       <FIELD name="stackDetectRowID" arraysize="1" datatype="long" unit="dimensionless" default="NA">
    173         <DESCRIPTION>Identifies if this row is the primary detection, a secondary detection, and if it is the best detection.</DESCRIPTION>
    174       </FIELD>
    175173      <FIELD name="primaryDetection" arraysize="1" datatype="unsignedByte" unit="dimensionless" default="255">
    176174        <DESCRIPTION>Identifies if this row is the primary stack detection.</DESCRIPTION>
     
    207205        <DESCRIPTION>Declination error from g filter stack detection.</DESCRIPTION>
    208206      </FIELD>
     207      <FIELD name="gEpoch" arraysize="1" datatype="double" unit="days" default="-999">
     208        <DESCRIPTION>Modified Julian Date of the mean epoch of images contributing to the the g-band stack (equinox J2000).</DESCRIPTION>
     209      </FIELD>
    209210      <FIELD name="gPSFMag" arraysize="1" datatype="float" unit="AB magnitudes" default="-999">
    210211        <DESCRIPTION>PSF magnitude from g filter stack detection.</DESCRIPTION>
     
    260261        <DESCRIPTION>Declination error from r filter stack detection.</DESCRIPTION>
    261262      </FIELD>
     263      <FIELD name="rEpoch" arraysize="1" datatype="double" unit="days" default="-999">
     264        <DESCRIPTION>Modified Julian Date of the mean epoch of images contributing to the the r-band stack (equinox J2000).</DESCRIPTION>
     265      </FIELD>
    262266      <FIELD name="rPSFMag" arraysize="1" datatype="float" unit="AB magnitudes" default="-999">
    263267        <DESCRIPTION>PSF magnitude from r filter stack detection.</DESCRIPTION>
     
    313317        <DESCRIPTION>Declination error from i filter stack detection.</DESCRIPTION>
    314318      </FIELD>
     319      <FIELD name="iEpoch" arraysize="1" datatype="double" unit="days" default="-999">
     320        <DESCRIPTION>Modified Julian Date of the mean epoch of images contributing to the the i-band stack (equinox J2000).</DESCRIPTION>
     321      </FIELD>
    315322      <FIELD name="iPSFMag" arraysize="1" datatype="float" unit="AB magnitudes" default="-999">
    316323        <DESCRIPTION>PSF magnitude from i filter stack detection.</DESCRIPTION>
     
    366373        <DESCRIPTION>Declination error from z filter stack detection.</DESCRIPTION>
    367374      </FIELD>
     375      <FIELD name="zEpoch" arraysize="1" datatype="double" unit="days" default="-999">
     376        <DESCRIPTION>Modified Julian Date of the mean epoch of images contributing to the the z-band stack (equinox J2000).</DESCRIPTION>
     377      </FIELD>
    368378      <FIELD name="zPSFMag" arraysize="1" datatype="float" unit="AB magnitudes" default="-999">
    369379        <DESCRIPTION>PSF magnitude from z filter stack detection.</DESCRIPTION>
     
    418428      <FIELD name="ydecErr" arraysize="1" datatype="float" unit="arcsec" default="-999">
    419429        <DESCRIPTION>Declination error from y filter stack detection.</DESCRIPTION>
     430      </FIELD>
     431      <FIELD name="yEpoch" arraysize="1" datatype="double" unit="days" default="-999">
     432        <DESCRIPTION>Modified Julian Date of the mean epoch of images contributing to the the y-band stack (equinox J2000).</DESCRIPTION>
    420433      </FIELD>
    421434      <FIELD name="yPSFMag" arraysize="1" datatype="float" unit="AB magnitudes" default="-999">
     
    470483        <DESCRIPTION>Random value drawn from the interval between zero and one.</DESCRIPTION>
    471484      </FIELD>
    472       <FIELD name="stackDetectRowID" arraysize="1" datatype="long" unit="dimensionless" default="NA">
    473         <DESCRIPTION>Identifies if this row is the primary detection, a secondary detection, and if it is the best detection.</DESCRIPTION>
    474       </FIELD>
    475485      <FIELD name="primaryDetection" arraysize="1" datatype="unsignedByte" unit="dimensionless" default="255">
    476486        <DESCRIPTION>Identifies if this row is the primary stack detection.</DESCRIPTION>
     
    10211031    <!-- StackApFlx Table ************************************************** -->
    10221032    <TABLE name="StackApFlx">
    1023       <DESCRIPTION>Contains the unconvolved fluxes within the SDSS R5 (r = 3.00 arcsec), R6 (r = 4.63 arcsec), and R7 (r = 7.43 arcsec) apertures (Stoughton 2002).  Convolved fluxes within these same apertures are also provided for convolution targets of 6 sky pixels (1.5 arcsec) and 8 sky pixels (2.0 arcsec).  All filters are matched into a single row.  See StackObjectThin table for discussion of primary, secondary, and best detections.  References: Stoughton, C., Lupton, R. H., Bernardi, M., et al. 2002, AJ, 123, 485.</DESCRIPTION>
     1033      <DESCRIPTION>Contains the unconvolved fluxes within the SDSS R5 (r = 3.00 arcsec), R6 (r = 4.63 arcsec), and R7 (r = 7.43 arcsec) apertures (Stoughton 2002).  Convolved fluxes within these same apertures are also provided for images convolved to 6 sky pixels (1.5 arcsec) and 8 sky pixels (2.0 arcsec).  All filters are matched into a single row.  See StackObjectThin table for discussion of primary, secondary, and best detections.  References: Stoughton, C., Lupton, R. H., Bernardi, M., et al. 2002, AJ, 123, 485.</DESCRIPTION>
    10241034      <PARAM arraysize="1" datatype="char" ucd="meta.bib.author" name="Author" value="PSPS"></PARAM>
    10251035      <FIELD name="objID" arraysize="1" datatype="long" unit="dimensionless"  default="NA">
     
    10341044      <FIELD name="randomStackObjID" arraysize="1" datatype="double" unit="dimensionless" default="NA">
    10351045        <DESCRIPTION>Random value drawn from the interval between zero and one.</DESCRIPTION>
    1036       </FIELD>
    1037       <FIELD name="stackDetectRowID" arraysize="1" datatype="long" unit="dimensionless" default="NA">
    1038         <DESCRIPTION>Identifies if this row is the primary detection, a secondary detection, and if it is the best detection.</DESCRIPTION>
    10391046      </FIELD>
    10401047      <FIELD name="primaryDetection" arraysize="1" datatype="unsignedByte" unit="dimensionless" default="255">
     
    16601667        <DESCRIPTION>Random value drawn from the interval between zero and one.</DESCRIPTION>
    16611668      </FIELD>
    1662       <FIELD name="stackDetectRowID" arraysize="1" datatype="long" unit="dimensionless" default="NA">
    1663         <DESCRIPTION>Identifies if this row is the primary detection, a secondary detection, and if it is the best detection.</DESCRIPTION>
    1664       </FIELD>
    16651669      <FIELD name="primaryDetection" arraysize="1" datatype="unsignedByte" unit="dimensionless" default="255">
    16661670        <DESCRIPTION>Identifies if this row is the primary stack detection.</DESCRIPTION>
     
    18451849        <DESCRIPTION>Random value drawn from the interval between zero and one.</DESCRIPTION>
    18461850      </FIELD>
    1847       <FIELD name="stackDetectRowID" arraysize="1" datatype="long" unit="dimensionless" default="NA">
    1848         <DESCRIPTION>Identifies if this row is the primary detection, a secondary detection, and if it is the best detection.</DESCRIPTION>
    1849       </FIELD>
    18501851      <FIELD name="primaryDetection" arraysize="1" datatype="unsignedByte" unit="dimensionless" default="255">
    18511852        <DESCRIPTION>Identifies if this row is the primary stack detection.</DESCRIPTION>
     
    21262127        <DESCRIPTION>Random value drawn from the interval between zero and one.</DESCRIPTION>
    21272128      </FIELD>
    2128       <FIELD name="stackDetectRowID" arraysize="1" datatype="long" unit="dimensionless" default="NA">
    2129         <DESCRIPTION>Identifies if this row is the primary detection, a secondary detection, and if it is the best detection.</DESCRIPTION>
    2130       </FIELD>
    21312129      <FIELD name="primaryDetection" arraysize="1" datatype="unsignedByte" unit="dimensionless" default="255">
    21322130        <DESCRIPTION>Identifies if this row is the primary stack detection.</DESCRIPTION>
     
    24072405        <DESCRIPTION>Random value drawn from the interval between zero and one.</DESCRIPTION>
    24082406      </FIELD>
    2409       <FIELD name="stackDetectRowID" arraysize="1" datatype="long" unit="dimensionless" default="NA">
    2410         <DESCRIPTION>Identifies if this row is the primary detection, a secondary detection, and if it is the best detection.</DESCRIPTION>
    2411       </FIELD>
    24122407      <FIELD name="primaryDetection" arraysize="1" datatype="unsignedByte" unit="dimensionless" default="255">
    24132408        <DESCRIPTION>Identifies if this row is the primary stack detection.</DESCRIPTION>
     
    27042699    <!-- StackApFlxFull Table ************************************************** -->
    27052700    <TABLE name="StackApFlxExGalUnc">
    2706       <DESCRIPTION>Contains the unconvolved fluxes within the SDSS R3 (r = 1.03 arcsec), R4 (r = 1.76 arcsec), R5 (r = 3.00 arcsec), R6 (r = 4.63 arcsec), R7 (r = 7.43 arcsec), R8 (r = 11.42 arcsec), R9 (r = 18.20 arcsec), R10 (r = 28.20 arcsec), and R11 (r = 44.21 arcsec) apertures (Stoughton 2002) for extended sources.  See StackObjectThin table for discussion of primary, secondary, and best detections.  References:  Stoughton, C., Lupton, R. H., Bernardi, M., et al. 2002, AJ, 123, 485.</DESCRIPTION>
     2701
     2702      <DESCRIPTION>Contains the unconvolved fluxes within the SDSS R3
     2703      (r = 1.03 arcsec), R4 (r = 1.76 arcsec), R5 (r = 3.00 arcsec),
     2704      R6 (r = 4.63 arcsec), R7 (r = 7.43 arcsec), R8 (r = 11.42
     2705      arcsec), R9 (r = 18.20 arcsec), R10 (r = 28.20 arcsec), and R11
     2706      (r = 44.21 arcsec) apertures (Stoughton 2002) for extended
     2707      sources.  These measurements are only provided for objects in
     2708      the extragalactic sky, i.e., they are not provided for objects
     2709      in the Galactic plane because they are not useful in crowded
     2710      areas.  See StackObjectThin table for discussion of primary,
     2711      secondary, and best detections.  References: Stoughton, C.,
     2712      Lupton, R. H., Bernardi, M., et al. 2002, AJ, 123,
     2713      485.</DESCRIPTION>
     2714
    27072715      <PARAM arraysize="1" datatype="char" ucd="meta.bib.author" name="Author" value="PSPS"></PARAM>
    27082716      <FIELD name="objID" arraysize="1" datatype="long" unit="dimensionless" default="NA">
     
    27172725      <FIELD name="randomStackObjID" arraysize="1" datatype="double" unit="dimensionless" default="NA">
    27182726        <DESCRIPTION>Random value drawn from the interval between zero and one.</DESCRIPTION>
    2719       </FIELD>
    2720       <FIELD name="stackDetectRowID" arraysize="1" datatype="long" unit="dimensionless" default="NA">
    2721         <DESCRIPTION>Identifies if this row is the primary detection, a secondary detection, and if it is the best detection.</DESCRIPTION>
    27222727      </FIELD>
    27232728      <FIELD name="primaryDetection" arraysize="1" datatype="unsignedByte" unit="dimensionless" default="255">
     
    33293334    <!-- StackApFlxFullC6 Table ************************************************** -->
    33303335    <TABLE name="StackApFlxExGalCon6">
    3331       <DESCRIPTION>Contains the fluxes within the SDSS R3 (r = 1.03 arcsec), R4 (r = 1.76 arcsec), R5 (r = 3.00 arcsec), R6 (r = 4.63 arcsec), R7 (r = 7.43 arcsec), R8 (r = 11.42 arcsec), R9 (r = 18.20 arcsec), R10 (r = 28.20 arcsec), and R11 (r = 44.21 arcsec) apertures (Stoughton 2002) for extended sources after the images have been convolved to a target of 6 sky pixels (1.5 arcsec).  See StackObjectThin table for discussion of primary, secondary, and best detections.  References:  Stoughton, C., Lupton, R. H., Bernardi, M., et al. 2002, AJ, 123, 485.</DESCRIPTION>
     3336
     3337      <DESCRIPTION>Contains the fluxes within the SDSS R3 (r = 1.03
     3338      arcsec), R4 (r = 1.76 arcsec), R5 (r = 3.00 arcsec), R6 (r =
     3339      4.63 arcsec), R7 (r = 7.43 arcsec), R8 (r = 11.42 arcsec), R9 (r
     3340      = 18.20 arcsec), R10 (r = 28.20 arcsec), and R11 (r = 44.21
     3341      arcsec) apertures (Stoughton 2002) for extended sources after
     3342      the images have been convolved to a target of 6 sky pixels (1.5
     3343      arcsec).  These measurements are only provided for objects in
     3344      the extragalactic sky, i.e., they are not provided for objects
     3345      in the Galactic plane because they are not useful in crowded
     3346      areas.  See StackObjectThin table for discussion of primary,
     3347      secondary, and best detections.  References: Stoughton, C.,
     3348      Lupton, R. H., Bernardi, M., et al. 2002, AJ, 123,
     3349      485.</DESCRIPTION>
     3350
    33323351      <PARAM arraysize="1" datatype="char" ucd="meta.bib.author" name="Author" value="PSPS"></PARAM>
    33333352      <FIELD name="objID" arraysize="1" datatype="long" unit="dimensionless" default="NA">
     
    33423361      <FIELD name="randomStackObjID" arraysize="1" datatype="double" unit="dimensionless" default="NA">
    33433362        <DESCRIPTION>Random value drawn from the interval between zero and one.</DESCRIPTION>
    3344       </FIELD>
    3345       <FIELD name="stackDetectRowID" arraysize="1" datatype="long" unit="dimensionless" default="NA">
    3346         <DESCRIPTION>Identifies if this row is the primary detection, a secondary detection, and if it is the best detection.</DESCRIPTION>
    33473363      </FIELD>
    33483364      <FIELD name="primaryDetection" arraysize="1" datatype="unsignedByte" unit="dimensionless" default="255">
     
    39553971    <!-- StackApFlxFullC8 Table ************************************************** -->
    39563972    <TABLE name="StackApFlxExGalCon8">
    3957       <DESCRIPTION>Contains the fluxes within the SDSS R3 (r = 1.03 arcsec), R4 (r = 1.76 arcsec), R5 (r = 3.00 arcsec), R6 (r = 4.63 arcsec), R7 (r = 7.43 arcsec), R8 (r = 11.42 arcsec), R9 (r = 18.20 arcsec), R10 (r = 28.20 arcsec), and R11 (r = 44.21 arcsec) apertures (Stoughton 2002) for extended sources after the images have been convolved to a target of 8 sky pixels (2.0 arcsec).  See StackObjectThin table for discussion of primary, secondary, and best detections.  References:  Stoughton, C., Lupton, R. H., Bernardi, M., et al. 2002, AJ, 123, 485.</DESCRIPTION>
     3973
     3974      <DESCRIPTION>Contains the fluxes within the SDSS R3 (r = 1.03
     3975      arcsec), R4 (r = 1.76 arcsec), R5 (r = 3.00 arcsec), R6 (r =
     3976      4.63 arcsec), R7 (r = 7.43 arcsec), R8 (r = 11.42 arcsec), R9 (r
     3977      = 18.20 arcsec), R10 (r = 28.20 arcsec), and R11 (r = 44.21
     3978      arcsec) apertures (Stoughton 2002) for extended sources after
     3979      the images have been convolved to a target of 8 sky pixels (2.0
     3980      arcsec).  These measurements are only provided for objects in
     3981      the extragalactic sky, i.e., they are not provided for objects
     3982      in the Galactic plane because they are not useful in crowded
     3983      areas.  See StackObjectThin table for discussion of primary,
     3984      secondary, and best detections.  References: Stoughton, C.,
     3985      Lupton, R. H., Bernardi, M., et al. 2002, AJ, 123,
     3986      485.</DESCRIPTION>
     3987
    39583988      <PARAM arraysize="1" datatype="char" ucd="meta.bib.author" name="Author" value="PSPS"></PARAM>
    39593989      <FIELD name="objID" arraysize="1" datatype="long" unit="dimensionless" default="NA">
     
    39683998      <FIELD name="randomStackObjID" arraysize="1" datatype="double" unit="dimensionless" default="NA">
    39693999        <DESCRIPTION>Random value drawn from the interval between zero and one.</DESCRIPTION>
    3970       </FIELD>
    3971       <FIELD name="stackDetectRowID" arraysize="1" datatype="long" unit="dimensionless" default="NA">
    3972         <DESCRIPTION>Identifies if this row is the primary detection, a secondary detection, and if it is the best detection.</DESCRIPTION>
    39734000      </FIELD>
    39744001      <FIELD name="primaryDetection" arraysize="1" datatype="unsignedByte" unit="dimensionless" default="255">
     
    45954622        <DESCRIPTION>Random value drawn from the interval between zero and one.</DESCRIPTION>
    45964623      </FIELD>
    4597       <FIELD name="stackDetectRowID" arraysize="1" datatype="long" unit="dimensionless" default="NA">
    4598         <DESCRIPTION>Identifies if this row is the primary detection, a secondary detection, and if it is the best detection.</DESCRIPTION>
    4599       </FIELD>
    46004624      <FIELD name="primaryDetection" arraysize="1" datatype="unsignedByte" unit="dimensionless" default="255">
    46014625        <DESCRIPTION>Identifies if this row is the primary stack detection.</DESCRIPTION>
     
    48444868    <!-- StackDetEffMeta Table ************************************************** -->
    48454869    <TABLE name="StackDetEffMeta">
    4846       <DESCRIPTION>Contains the detection efficiency information for a given stacked image.  Provides the number of recovered sources out of 500 and statistics about the magnitudes of the recovered sources for a range of magnitude offsets.</DESCRIPTION>
     4870
     4871      <DESCRIPTION>Contains the detection efficiency information for a
     4872      given stacked image.  Provides the number of recovered sources
     4873      out of 500 injected sources for each magnitude bin and statistics about the magnitudes of the recovered
     4874      sources for a range of magnitude offsets.</DESCRIPTION>
     4875
    48474876      <PARAM arraysize="1" datatype="char" ucd="meta.bib.author" name="Author" value="PSPS"></PARAM>
    48484877      <FIELD name="stackImageID" arraysize="1" datatype="long" unit="dimensionless" default="NA">
     
    48514880      <FIELD name="magref" arraysize="1" datatype="float" unit="magnitudes" default="NA">
    48524881        <DESCRIPTION>Detection efficiency reference magnitude.</DESCRIPTION>
     4882      </FIELD>
     4883      <FIELD name="nInjected" arraysize="1" datatype="int" unit="dimensionless" default="NA">
     4884        <DESCRIPTION>Number of fake sources injected in each magnitude bin.</DESCRIPTION>
    48534885      </FIELD>
    48544886      <FIELD name="offset01" arraysize="1" datatype="float" unit="magnitudes" default="NA">
Note: See TracChangeset for help on using the changeset viewer.