APPENDIX E.   SHIMS DATABASE STRUCTURE

This appendix provides a listing of the underlying data structure used for storing the information
in SHIMS.  Fields that were changed or that are new are printed in italics; tables that are new are
also printed in italics.  Some of these fields use the same field names as defined in the Cooperative
Station Service Accountability (CSSA) database.

Each of these tables has key fields and, unless all fields are key fields, also have accompanying
data fields.  Every table has the location identifier (Lid) as a key field, as all information is
associated with a station.  The order of the fields for the tables is defined so that the key fields are
first; the remaining fields follow thereafter.

Tbl     Field Name   Type       Description

Bm
        Lid          Alnum 8    Location ID
        Bnum         Alnum 6    Benchmark number
        Belev        Number     Benchmark elevation
        Bench        Alnum 255  Benchmark description

Contact
        Lid          Alnum 8    Location ID
        Seq          Number     Contact priority number 
        Contact      Alnum 24   Name of the contact
        Cphone       Alnum 17   Phone number of the contact
        Remarks      Alnum 255  Remarks

Crest
        Lid          Alnum 8    Location ID
        Datcrst      Date       Date of crest
        Cremark      Alnum 80   Comments about this crest
        Hw           Alnum 1    Based on high water marks
        Jam          Alnum 1    Caused by an ice jam
        Old          Alnum 1    Based on old datum
        Q            Number     Flow of the crest
        Stgcrst      Number     Stage of crest
        Suppress     Alnum 1    Crest printed on staff picture
        Timcrst      Alnum 5    Time of crest
        Prelim       Alnum 1    Preliminary crest
  
Damage
        Lid          Alnum 8    Location ID
        Stage        Number     Stage height
        Damage       Alnum 255  Damage at the stage height
        Damage2      Alnum 255  Further details of damage 
        Damagescr    Alnum 60   Summary of damage for summary screen

Datum
        Lid          Alnum 8    Location ID
        Ddate        Date       Date of datum
        Delev        Number     Elevation of datum

Dcp
        Lid          Alnum 8    Location ID
        Criteria     Alnum 50   Random reporting criteria
        Downer       Alnum 10   Owner of DCP
        Goes         Alnum 8    NESS ID
        Rptfreq      Alnum 4    How often the DCP reports
        Rptime       Alnum 8    Time DCP first reports 

Descrip
        Lid          Alnum 8    Location ID
        Bed          Alnum 60   Stream bed
        Divert       Alnum 60   Why is water diverted around gage
        Dremark      Alnum 255  Comments about this forecast point
        Ice          Alnum 80   Winter freezing problems
        Prox         Alnum 6    Proximity of gage to location
        Reach        Alnum 80   Reach limits
        Res          Alnum 255  Reservoir regulation
        Topo         Alnum 255  Description of topography
  
Extcoop
        Lid          Alnum 8    Location ID
        Agency       Alnum 8    External Agency
        Office       Alnum 20   Location of Office 

Floodcat
        Lid          Alnum 8    Location ID
        Minor        Number     Minor flood level
        Moderate     Number     Moderate flood level
        Major        Number     Major flood level

Gage
        Lid          Alnum 8    Location ID
        Gbegin       Date       Began service date
        Eqc          Alnum 10   Type of gage
        Gend         Date       Ended service date
        Gloc         Alnum 255  Gage location
        Maint        Alnum 10   Agency which maintains gage
        Owc          Alnum 10   Owner of gage

Impact
        Lid          Alnum 8    Location ID
        Impstage     Number     Level for flood statements
        Rf           Alnum 1    Rising or Falling statements
        Datestart    Alnum 5    Date to start using statements
        Dateend      Alnum 5    Date to stop using statement
        Impstmt1     Alnum 255  First flood statement
        Impstmt2     Alnum 255  Second flood statement
  
Loc
        Lid          Alnum 8    Location ID
        Co           Alnum 20   County name
        Detail       Alnum 10   Direction and distance to station
        Elev         Number     Elevation of station
        Hsa          Alnum 3    Hydrologic service area
        Hu           Alnum 8    Hydrologic unit number
        Lat          Alnum 9    Station latitude
        Lon          Alnum 9    Station longitude
        Lremark      Alnum 255  Comments about the location
        Lrevise      Date       Date location data was last changed
        Name         Alnum 25   Location name
        Net          Alnum 3    Network
        Rb           Alnum 30   River basin
        Rfc          Alnum 5    River forecast center
        Sbd          Date       Station beginning date
        Sn           Alnum 10   Station number
        St           Alnum 2    State
        Type         Alnum 4    Type of location
        Wfo          Alnum 3    Warning forecast office

Lw
        Lid          Alnum 8    Location ID
        Lwdat        Date       Low water date
        Lwq          Number     Low water flow
        Lwrem        Alnum 80   Comments about the low water
        Lwstg        Number     Low water stage
Obs
        Lid          Alnum 8    Location ID
        A1           Alnum 30   Observer's mailing address line 1
        A2           Alnum 30   Observer's mailing address line 2
        A3           Alnum 30   Observer's mailing address line 3
        City         Alnum 30   Observer's mailing address city
        St           Alnum 2    Observer's mailing address state
        Zip          Alnum 10   Observer's zip code         
        Comm         Alnum 10   Form of observer's communications
        Dos          Date       First date of service
        Gn           Alnum 1    Gender
        Hphone       Alnum 12   Home phone number
        Lname        Alnum 28   Observer's surname
        Fname        Alnum 12   Observer's first name
        Ophone       Alnum 18   Office phone number
        Ornr         Alnum 4    CD 404 order number
        Rate         Dollar     Monthly fee
        Reci         Alnum 15   First recipient of observation
        Rprt         Alnum 60   Observer's instructions
        Spon         Alnum 7    Sponsor appropriation
        Ssn          Alnum 11   Social security number
        Tsk          Alnum 13   Task code

Parm
        Lid          Alnum 8    Location ID
        Type         Alnum 1    Type of report
        Parm         Almun 2    SHEF code of parameter observed        

Pub
        Lid          Alnum 8    Location ID
        Pbegin       Date       Beginning date of records
        Ppub         Alnum 25   Location of records
        Pend         Date       Ending date of records

Rating
        Lid          Alnum 8    Location ID
        Stage        Number     A stage
        Discharge    Number     Flow at that stage

Refer
        Lid          Alnum 8    Location ID
        Reference    Alnum 7    Reference used for this gage

Rescap
        Lid          Alnum 8    Location ID
        Elev         Number     An elevation of the water level
        Storage      Number     Amount of storage at that elevation

Reservr 
        Lid          Alnum 8    Location ID
        Name         Alnum 20   The name of the reservoir
        Type         Alnum 10   The type of dam
        Owner        Alnum 10   Owner of the reservoir
        Uses         Alnum 8    What the reservoir is used for
        Gates        Number     Total number of gates on the dam
        Deadpool     Number     Elevation of the dead pool
        Conserpool   Number     Elevation of the conservation pool
        Floodpool    Number     Elevation of the flood pool
        Spillway     Number     Elevation of the bottom of the spillway
        Sill         Number     Elevation of the sill of the dam
        Top          Number     Elevation of the top of the dam
        Relev        Number     Elevation of the bottom of the reservoir
        Surchg       Number     Surcharge of the reservoir
        Impounded    Date       Date the reservoir was impounded
          
Rvrsta
        Lid          Alnum 8    Location ID
        Bf           Number     Bankfull stage
        Cb           Number     Checkbar stage
        Da           Number     Drainage area
        Fcstype      Alnum 9    Forecast type
        Fq           Number     Flood flow
        Fs           Number     Flood stage
        Gsno         Alnum 10   USGS gage number
        Level        Alnum 20   Agency and date last leveling was done
        Mile         Number     River mile
        Pool         Number     Normal Pool
        Por          Alnum 30   Period of record
        Rated        Alnum 20   Agency which last rated gage
        Ratedat      Date       Date gage was last rated
        Rlat         Alnum 9    River gage latitude
        Rlon         Alnum 9    River gage longitude
        Rremark      Alnum 255  Comments about river gage
        Rrevise      Date       Date river station was last changed
        Rsource      Alnum 20   Source of latitude and longitude  
        Stream       Alnum 32   Name of river or stream
        Tide         Alnum 8    Tidal effects
        Uhgdur       Number     Unit hydrograph duration
        Vdatum       Alnum 20   Vertical datum
        Astg         Number     Action stage
        Zd           Number     Zero level for gage
        Backwater    Alnum 8    Backwater effects

Telm
        Lid          Alnum 8    Location ID
        Device       Alnum 10   Telemetry device
        Payor        Alnum 10   Agency which pays for phone line
        Tcost        Dollar     Monthly cost
        Tcriteria    Alnum 50   Random reporting criteria
        Towner       Alnum 10   Agency which owns device
        Tphone       Alnum 12   Phone number of device
        Sensorid     Alnum 10   Sensor ID of device
        Rptfreq      Alnum 4    Frequency of routine reports

Ugc
        Lid          Alnum 8    Location ID
        St           Alnum 2    Postal ID for state
        Fips         Alnum 4    FIPS code for county

Ugz
        Lid          Alnum 8    Location ID
        St           Alnum 2    Postal ID for state
        Zone         Alnum 3    Zone number for county

Uhg
        Lid          Alnum 8    Location ID
        Timinit      Number     Time interval
        Q            Number     Flow at that time