Go to the bottom.

!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
! SDDL Name:	FIT_CAT.SDDL
!
! Purpose:      This file defines the "fit_cat" relation. 
!
! Modification History:
!
!   Date       OPR      Who                       Reason
! --------   -------    ---   -------------------------------------------------
! 10/20/94   26036      SSS   Converted from DDL and changed "satellite" field
!                             from 2 to 7 characters.
!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!
!
INCLUDE   ZSPSS_USER_TYPES.SDDL
LANGUAGE  FORTRAN, SQL

RECORD   FITCAT_TYPE

    DESCRIPTION         "This relation contains HST and TDRS ephemeris 
                         least squares fit coefficients.  See the 
                         following document for a complete mathematical 
                         description of the fields in this relation:
                                    
                              SE-06-02 Appendix B : SPSS Algorithms
                              Section B.5

                         A 'fit' is a mathematical function which approximates
                         a given set of data points.  This function reduces
                         the data to a more managable form and allows 'new'
                         points 'between' the data points to be determined.
                         In this case, the 'fit' function approximates the 
                         HST or TDRS satellite ephemeris.  This relation 
                         contains the 'constant' coefficients for the 'fit' 
                         function.  

                         The fit coefficients are calculated by the 
                         PEFFIT program from HST and TDRS ephemeris
                         files received from PASS (after some initial
                         processing by the WEREADX program)."
                         


    FIELD  fit_name
        DESCRIPTION     "This is the unique fit name.  It is user assigned
                         through the /FITNAME qualifier on the PEFFIT/CREATE
                         program."
        TYPE            C*32
        FORM
            NAME         "DFI"
            LABEL        "FIT NAME"
        END_FORM
    END_FIELD


    FIELD  satellite
        DESCRIPTION     "This is the satellite type. 

                         There are 2 types of satellites:

                         ST       - HST ephemeris
                         TDRSaaa  - TDRS definitive ephemeris (aaa = west
                                    longitude of TDRS in DEGREES)."

        TYPE            C*7
        FORM
            NAME         "DFI"
            LABEL        "SATELLITE"
        END_FORM
    END_FIELD


    FIELD  create_date
        DESCRIPTION     "This is the creation time of the ephemeris fit.
                         Specifically, the time/data that PEFFIT/CREATE
                         was executed to create the fit coefficients."

        TYPE TIME_STAMP_TYPE
        FORM
            NAME         "DFI"
            LABEL        "CREATE DATE"
        END_FORM
    END_FIELD


    FIELD  fit_start
        DESCRIPTION     "This is the fit start time."
        TYPE SOGS_INT_TIME_TYPE
        FORM
            NAME         "DFI"
            LABEL        "FIT START"
        END_FORM
    END_FIELD


    FIELD  fit_end
        DESCRIPTION     "This is the fit end time."
        TYPE SOGS_INT_TIME_TYPE
        FORM
            NAME         "DFI"
            LABEL        "FIT END"
        END_FORM
    END_FIELD


    FIELD  sample_rate
        DESCRIPTION     "The sample_rate is the rate at which state vectors
                         were sampled from the ephemeris file.  The fit was 
                         calculated every nth point, where n = sample rate"
        TYPE            I*2
    END_FIELD


    FIELD  test_rate
        DESCRIPTION     "The test_rate is the rate (or interval) at which the 
                        fit coefficients were tested for accuracy."
        TYPE            I*2
    END_FIELD


    FIELD  d_p
        DESCRIPTION     "This is the ephemeris type code:  
                         
                          D = Definitive, 
                          P = Predictive"

        TYPE            C*1
        DISCRETE        "D", "P"
    END_FIELD


    FIELD  point_count
        DESCRIPTION     "This is the total number of ephemeris state vectors
                         used in calculating the fit"
        TYPE            I*4
    END_FIELD


    FIELD  filename
        DESCRIPTION     "This is the name of the ephemeris file fitted."
        TYPE EPHEMERIS_FILE_TYPE
        FORM
            NAME         "DFI"
            LABEL        "FILE NAME"
        END_FORM
    END_FIELD


    FIELD  version_num
        DESCRIPTION     "This is the version number of the ephemeris 
                         filename."
        TYPE EPHEMERIS_FILE_VER_TYPE
    END_FIELD


    FIELD  g1
        DESCRIPTION     "This is the g-term 1 longitude of the zero point."
        TYPE            R*8
    END_FIELD


    FIELD  g2
        DESCRIPTION     "This is the g-term 2 orbital period; model=l"
        TYPE            R*8
    END_FIELD


    FIELD  g3
        DESCRIPTION     "This is the g-term 3 g2s long-term rate of change;
                         model=q"
        TYPE            R*8
    END_FIELD


    FIELD  f1_1
        DESCRIPTION     "This is the Orbital longitude, 2nd order taylor 
                         term 1."
        TYPE            R*8
    END_FIELD


    FIELD  f1_2
        DESCRIPTION     "This is the Orbital longitude, 2nd order taylor 
                         term 2"
        TYPE            R*8
    END_FIELD


    FIELD  f1_3
        DESCRIPTION     "This is the Orbital longitude, 2nd order taylor 
                         term 3"
        TYPE            R*8
    END_FIELD


    FIELD  f1_4
        DESCRIPTION     "This is the Orbital longitude, 2nd order fourier 
                         term 1"
        TYPE            R*8
    END_FIELD


    FIELD  f1_5
        DESCRIPTION     "This is the Orbital longitude, 2nd order fourier 
                         term 2"
        TYPE            R*8
    END_FIELD


    FIELD  f1_6
        DESCRIPTION     "This is the Orbital longitude, 2nd order fourier 
                         term 3"
        TYPE            R*8
    END_FIELD


    FIELD  f1_7
        DESCRIPTION     "This is the Orbital longitude, 2nd order fourier 
                         term 4"
        TYPE            R*8
    END_FIELD


    FIELD  f2_1
        DESCRIPTION     "This is the Radius, 2nd order taylor term 1"
        TYPE            R*8
    END_FIELD


    FIELD  f2_2
        DESCRIPTION     "This is the Radius, 2nd order taylor term 2"
        TYPE            R*8
    END_FIELD


    FIELD  f2_3
        DESCRIPTION     "This is the Radius, 2nd order taylor term 3"
        TYPE            R*8
    END_FIELD


    FIELD  f2_4
        DESCRIPTION     "This is the Radius, 2nd order fourier term 1"
        TYPE            R*8
    END_FIELD


    FIELD  f2_5
        DESCRIPTION     "This is the Radius, 2nd order fourier term 2"
        TYPE            R*8
    END_FIELD


    FIELD  f2_6
        DESCRIPTION     "This is the Radius, 2nd order fourier term 3"
        TYPE            R*8
    END_FIELD


    FIELD  f2_7
        DESCRIPTION     "This is the Radius, 2nd order fourier term 4"
        TYPE            R*8
    END_FIELD


    FIELD  f3_1
        DESCRIPTION     "This is the Longitude of the ascending node, 
                         2nd order taylor term 1"
        TYPE            R*8
    END_FIELD


    FIELD  f3_2
        DESCRIPTION     "This is the Longitude of the ascending node, 
                         2nd order taylor term 2"
        TYPE            R*8
    END_FIELD


    FIELD  f3_3
        DESCRIPTION     "This is the Longitude of the ascending node, 
                         2nd order taylor term 3"
        TYPE            R*8
    END_FIELD


    FIELD  f3_4
        DESCRIPTION     "This is the Longitude of the ascending node, 
                         2nd order fourier term 1"
        TYPE            R*8
    END_FIELD


    FIELD  f3_5
        DESCRIPTION     "This is the Longitude of the ascending node, 
                         2nd order fourier term 2"
        TYPE            R*8
    END_FIELD


    FIELD  f3_6
        DESCRIPTION     "This is the Longitude of the ascending node, 
                         2nd order fourier term 3"
        TYPE            R*8
    END_FIELD


    FIELD  f3_7
        DESCRIPTION     "This is the Longitude of the ascending node, 
                         2nd order fourier term 4"
        TYPE            R*8
    END_FIELD


    FIELD  f4_1
        DESCRIPTION     "This is the Orbital inclination, 2nd order taylor 
                         term 1"
        TYPE            R*8
    END_FIELD


    FIELD  f4_2
        DESCRIPTION     "This is the Orbital inclination, 2nd order taylor 
                         term 2"
        TYPE            R*8
    END_FIELD


    FIELD  f4_3
        DESCRIPTION     "This is the Orbital inclination, 2nd order taylor 
                         term 3"
        TYPE            R*8
    END_FIELD


    FIELD  f4_4
        DESCRIPTION     "This is the Orbital inclination, 2nd order fourier 
                         term 1"
        TYPE            R*8
    END_FIELD


    FIELD  f4_5
        DESCRIPTION     "This is the Orbital inclination, 2nd order fourier 
                         term 2"
        TYPE            R*8
    END_FIELD


    FIELD  f4_6
        DESCRIPTION     "This is the Orbital inclination, 2nd order fourier 
                         term 3"
        TYPE            R*8
    END_FIELD


    FIELD  f4_7
        DESCRIPTION     "This is the Orbital inclination, 2nd order fourier 
                         term 4"
        TYPE            R*8
    END_FIELD


    FIELD  poserr_mean
        DESCRIPTION     "This is the Average position error"
        UNITS           "KILOMETER"
        TYPE            R*8
    END_FIELD


    FIELD  poserr_max
        DESCRIPTION     "This is the Maximum position error"
        TYPE            R*8
        UNITS           "KILOMETER"
    END_FIELD


    FIELD  poserr_min
        DESCRIPTION     "This is the Minimum position error"
        TYPE            R*8
        UNITS           "KILOMETER"
    END_FIELD


    FIELD  poserr_sd
        DESCRIPTION     "This is the Standard deviation of position error"
        TYPE            R*8
        UNITS           "KILOMETER"
    END_FIELD


    FIELD  velerr_mean
        DESCRIPTION     "This is the Average velocity error"
        TYPE            R*8
        UNITS           "KILOMETER/SECOND"
    END_FIELD


    FIELD  velerr_max
        DESCRIPTION     "This is the Maximum velocity error"
        TYPE            R*8
        UNITS           "KILOMETER/SECOND"
    END_FIELD


    FIELD  velerr_min
        DESCRIPTION     "This is the Minimum velocity error"
        TYPE            R*8
        UNITS           "KILOMETER/SECOND"
    END_FIELD


    FIELD  velerr_sd
        DESCRIPTION     "This is the Standard deviation of velocity error"
        TYPE            R*8
        UNITS           "KILOMETER/SECOND"
    END_FIELD


    FIELD  rngerr_mean
        DESCRIPTION     "This is the Average range error"
        TYPE            R*8
        UNITS           "KILOMETER"
    END_FIELD


    FIELD  rngerr_max
        DESCRIPTION     "This is the Maximum range error"
        TYPE            R*8
        UNITS           "KILOMETER"
    END_FIELD


    FIELD  rngerr_min
        DESCRIPTION     "This is the Minimum range error"
        TYPE            R*8
        UNITS           "KILOMETER"
    END_FIELD


    FIELD  rngerr_sd
        DESCRIPTION     "This is the Standard deviation of range error"
        TYPE            R*8
        UNITS           "KILOMETER"
    END_FIELD


    FIELD  itkerr_mean
        DESCRIPTION     "This is the Average intrack error"
        TYPE            R*8
        UNITS           "KILOMETER"
    END_FIELD


    FIELD  itkerr_max
        DESCRIPTION     "This is the Maximum intrack error"
        TYPE            R*8
        UNITS           "KILOMETER"
    END_FIELD


    FIELD  itkerr_min
        DESCRIPTION     "This is the Minimum intrack error"
        TYPE            R*8
        UNITS           "KILOMETER"
    END_FIELD


    FIELD  itkerr_sd
        DESCRIPTION     "This is the Standard deviation of intrack error"
        TYPE            R*8
        UNITS           "KILOMETER"
    END_FIELD


    FIELD  xtkerr_mean
        DESCRIPTION     "This is the Average cross track error"
        TYPE            R*8
        UNITS           "KILOMETER"
    END_FIELD


    FIELD  xtkerr_max
        DESCRIPTION     "This is the Maximum cross track error"
        TYPE            R*8
        UNITS           "KILOMETER"
    END_FIELD


    FIELD  xtkerr_min
        DESCRIPTION     "This is the Minimum cross track error"
        TYPE            R*8
        UNITS           "KILOMETER"
    END_FIELD


    FIELD  xtkerr_sd
        DESCRIPTION     "This is the Standard deviation of cross track error"
        TYPE            R*8
        UNITS           "KILOMETER"
    END_FIELD


    FIELD  f1_sd
        DESCRIPTION     "This is the Standard deviation of f1 (argument of 
                         latitude)"
        TYPE            R*8
        UNITS           "DEGREES"
    END_FIELD


    FIELD  f2_sd
        DESCRIPTION     "This is the Standard deviation of f2 (range)"
        TYPE            R*8
        UNITS           "KILOMETER"
    END_FIELD


    FIELD  f3_sd
        DESCRIPTION     "This is the Standard deviation of f3 (right ascension)"
        TYPE            R*8
        UNITS           "DEGREES"
    END_FIELD


    FIELD  f4_sd
        DESCRIPTION     "This is the Standard deviation of f4 (inclination)"
        TYPE            R*8
        UNITS           "DEGREES"
    END_FIELD

END_RECORD


RELATION  fit_cat

    TYPE             FITCAT_TYPE

    DESCRIPTION      "ST and TDRS Ephemeris Fit Catalog Relation"

    SUBSYSTEM_USING  "SPSS"
    FORM
        NAME         "DFI"
    END_FORM

    INDEX  fit_cat_1
        TYPE         unique, clustered
        FIELDS       fit_name
    END_INDEX

END_RELATION


INSTANCE  fit_cat

    GLOBAL

    TYPE        FITCAT_TYPE

END_INSTANCE

Go to the top.