National Weather Service United States Department of Commerce

Appendix G - Database Column Look-up Table


A B C D E F G
H I J K L M N
O P Q R S T U
V W XYZ Abbreviations


Column Data Type Used By Description
A
action numeric(10,2) rivercrit action stage (ft)
actionf float rivercrit flow at action stage (cfs)
actionq char(1) rivercrit source of action/actionf, valid values:
E=e-19
M=memo
P=personal communication (i.e. phone)
I=internal (i.e. RFC determined)
U=unknown
active char(1) ingestfilter active sensor? Y/N
active char(1) swsmail still active? Y/N
active char(1) vfyruninfo 'Y'es if the location is considered active when considering the IVP Batch Program command ACTIVE_STATUS.
adder float adjustfactor additive factor in formula to change raw value to adjusted value for posting
address1 varchar(40) swsmail street address, line 1
address2 varchar(35) swsmail street address, line 2
adimc float statessacsma additional impervious contents (L)
adimp float opersacsma additional impervious area (%/100)
adjdur char(1) qadjust SHEF Duration code of adjuster
adje char(1) qadjust SHEF Extremum code of adjuster
adjid varchar(5) qadjust location identifier of adjuster
adjp char(1) qadjust SHEF Probability code of adjuster
adjpe1 char(1) qadjust 1st char SHEF PE of adjuster
adjpe2 char(1) qadjust 2nd char SHEF PE of adjuster
adjs char(1) qadjust SHEF Source code of adjuster
adjt char(1) qadjust SHEF Type code of adjuster
adjustment float vaddadjust additive adjustment to be performed on data prior to verification
aeadj float statessnow17 areal extent of snow cover adjustment factor
aei float statesapicont antecedent evapotranspiration index
aeik float operapicont daily aei recession rate
aeix float operapicont maximum aei value
ag varchar(6) aliasid agency/organization (see agency table)
agcode varchar(6) agency
sensok
abbreviation for agency
agloc varchar(3) agency
aliasid
sensok
location of agency
aiadj float operapicont antecedent index adjustment factor
aicr float operapicont critical antecedent index value
aixd float operapicont dry curve intercept
aixw float operapicont wet curve intercept
alarm_limit float datalimits
locdatalimits
threshold data value for issuing forecaster alarms
alarm_roc_limit float datalimits
locdatalimits
threshold rate-of-change for issuing forecaster alarms
alert numeric(10,2) rivercrit alert stage (ft)
alert_limit float datalimits
locdatalimits
threshold data value for issuing forecaster alerts
alert_roc_limit float datalimits
locdatalimits
threshold rate-of-change for issuing forecaster alerts
alertf float rivercrit flow for alert stage (cfs)
alertq char(1) rivercrit source of alert/alertf, valid values:
E=e-19
M=memo
P=personal communication (i.e. phone)
I=internal (i.e. RFC determined)
U=unknown
allowstg float rating minimum allowable stage to which a rating curve may be extended
altid varchar(16) aliasid other agency location identifier
api float statesapicont antecedent precipitation index
apik float operapicont daily api recession rate
apiks float operapicont daily api recession rate when 100% snowcover
apix float operapicont maximum api value
apr float avg
pempsep
pemrsep
monthly value for April
aprmf float opersnow17 melt factor for April
aprmn float wshistorical reasonable min for April
aprmp float wshistorical most probable for April
aprmx float wshistorical reasonable max for April
aprq char(1) pempsep
pemrsep
SHEF Qualifier code for April
ati float statesapicont antecedent temperature index
atin float operapicont minimum ati value
atir float operapicont temperature weighting factor
atix float operapicont maximum ati value
aug float avg
pempsep
pemrsep
monthly value for August
augmf float opersnow17 melt factor for August
augmn float wshistorical reasonable min for August
augmp float wshistorical most probable for August
augmx float wshistorical reasonable max for August
augq char(1) pempsep
pemrsep
SHEF Qualifier code for August
avg25 float wsperstats 25-year average (kaf) (time period determined by the RFC)
avg30 float wsperstats 30-year average (kaf) (time period determined by the RFC)
avgpor float wsperstats period of record average (kaf)
B
b_date date qadjust begin date
backwater varchar(8) rivercrit indicator of any backwater effects at a river gage site, valid values: NONE, MINOR, MODERATE, MAJOR
bank numeric(10,2) rivercrit bankful stage (ft)
bankf float rivercrit flow at bankful stage (cfs)
bankq char(1) rivercrit source of bank/bankf, valid values:
E=e-19
M=memo
P=personal communication (i.e. phone)
I=internal (i.e. RFC determined)
U=unknown
base float adjustfactor base factor in formula to change from raw value to adjusted value
basistime timestamp
w/o time zone
commentvalue
pairedvalues
pedcsep
pedfsep
pehfsep
peqfsep
unkstnvalue
vfypairs
vfyprocpairs
SHEF creation date and time
begdate date slopeprofile begin date for the slope profile
begin_date timestamp
w/o time zone
adjustfactor
ratingshift
begin date of adjustment
begin date & time of shift
begintime timestamp
w/o time zone
flashflood beginning date and time of the flash flood event
bfi float statesapicont baseflow index
bfik float operapicont daily baseflow index recession rate
bfim float operapicont baseflow weighting factor
bfpk float operapicont daily primary baseflow recession rate
bfsc float statesapicont baseflow storage contents
bkw_time_window real ofsdatatrans backward timeliness window (decimal hours) for accepting data into OFS through OFS_DE
bper integer wsequation
wshistorical
wsperstats
beginning Water Year month of forecast period
bsource char(3) location for local RFC use
C
cal_yr integer pemrsep calendar year (ccyy)
calcdate date avg date monthly values were calculated
calcdate date avg date monthly values were calculated
cb float rivercrit checkbar stage or the stage at which a wire-weight gage is set for gage calibration purposes at a river station (ft)
cd float operapicont dry curve curvature constant
cf float operapicont frost efficiency index freezing constant
cg float operapicont groundwater inflow curvature constant
cgroup_abbr char(1) cgroup carryover group abbreviation
cgroupid varchar(8) cgroup
fgroup
carryover group id in NWSRFS
cgroupnum integer cgroup order number of cgroup
city varchar(35) swsmail city name
code_position char(1) shefpetrans position of code within value sent with certain SHEF PE codes (specifically IR and SR), valid values are " " (space), 1, 2, 3,and 4 (depending on the SHEF PE code)
code12 char(2) huc2
huc4
huc6
huc8
USGS region code
code2 char(2) huc2 USGS region code
code34 char(2) huc4
huc6
huc8
last 2 char of USGS sub-region code
code4 char(4) huc4 USGS sub-region code
code56 char(2) huc6
huc8
last 2 char of USGS accounting unit
code6 char(6) huc6
huc8
USGS accounting unit
code78 char(2) huc8 last 2 char of USGS cataloging unit
code8 char(8) huc8 USGS cataloging unit
coded_value integer shefpetrans integer code used by SHEF PEs (AF, AM, GR, GS, HI, IR, NC, PE, PT, SR, XP, and XW) that are not data values but rather translate into English phrases (see the V1.3 SHEF Manual)
comment varchar(30) sensok notification comment (optional)
comments varchar(512) flashflood additional information about the flash flood event
compint integer seg
segoper
operapicont
opersacsma
opersnow17
operunithg
computational interval (default value is 6)
conserpool float reservoir the minimum water level of a reservoir to be conserved in order to serve the needs of downstream water users during non-rainy times of the year (ft MSL)
country varchar(20) country name of country (mixed case)
countryfips char(2) counties
country
location
state
2 char country FIPS code (for "counties" table the default value is ‘US’) (upper case)
county varchar(20) counties county name (mixed case)
county_name varchar(20) flashflood county name (mixed case)
countyfips char(3) counties
location
3 char county FIPS code
cover float statessnow17 areal extent of snow cover (areal fraction)
cover0 - cover10 float opersnow17 areal depletion curve values (default value for cover0 is 0.0500000000000000) default value for cover10 is 1.0000000000000000)
cp float operapicont frost efficiency index precipitation constant
crstdatetime varchar(5) crest time of crest
cs float operapicont seasonal curvature
cse float wsequation coordinated std error
csnow float operapicont insulating effect of snow cover for frost index
ct float operapicont frost efficiency index thaw coefficient
cw float operapicont wet curve curvature constant
D
da float rivercrit drainage area (sq. miles)
dailyet char(7) opersacsma daily ET, always set to null by get_params application
damage_dollars float flashflood total dollar damage of flash flood event
damscreen float rivercrit max stage during dam break
damscreenf float rivercrit max flow during dam break
damscreenq char(1) rivercrit source of damscreen/damscreenf
E=e-19
M=memo
P=personal communication (i.e. phone)
I=internal (i.e. RFC determined)
U=unknown
darea float operunithg drainage area the unit hydrograph represents (square miles)
dat integer wsequation calibration date (mmddyy)
datatype varchar(5) modsetmsng
modtsadd
modtschng
modtsmult
modtsrepl
OFS datatype the mod is being applied to
datavalue float commentvalue
pairedvalues
pedcsep
pedfsep
pedrsep
peoosep
unkstnvalue
data value
datecrst date crest date of crest
datum_adj float ratingshift datum adjustment
daygm float opersnow17 daily melt at snow-soil interface (mm)
deadpool float reservoir lowest water level allowed for a reservoir through normal operations (ft MSL)
deaths integer flashflood number of people killed in flashflood event
dec float avg
pempsep
pemrsep
monthly value for December
decmf float opersnow17 melt factor for December
decmn float wshistorical reasonable min for December
decmp float wshistorical most probable for December
decmx float wshistorical reasonable max for December
decq char(1) pempsep
pemrsep
SHEF Qualifier code for December
defined char(1) areasens defined as an area in NWSRFS? Y/N
derived char(1) areasens elevation derivation, valid values:
C=calibration, D=default, E=estimated, - =none
des varchar(20) agency description
desacct char(60) huc6 description
descat varchar(60) huc8 description
descr varchar(20) area
areasens
cgroup
fgroup
operapicont
opersacsma
opersnow17
opertype
operunithg
seg
segoper
description
descr varchar(30) drain
pos
description
desreg varchar(60) huc2 description
dessubreg varchar(60) huc4 description
det varchar(40) ingestfilter
location
descriptive detail
dgf integer wsequation degrees of freedom in equation (total)
distance_dir varchar(10) flashflood distance and direction (whole miles) from the location to the nearest Post Office
distance01 -
distance30
real slopeprofile slope distances (ft and tenths of ft) measured from specified marker to the waters edge
divisor float adjustfactor divisor factor in formula to change from raw value to adjusted value
drain char(1) drain watershed drainage, valid values:
H=headwater, L=local
dt_mass integer opersnow17 time interval for precip, rain, and %snow (defalut value is 6)
dt_temp integer opersnow17 time interval for temperature (default value is 6)
dur char(1) adjustfactor
areasens
SHEF Duration code
dur char(1) adjustfactor
areasens
avg
commentvalue
datalimits
ingestfilter
locdatalimits
ofsdatatrans
pairedvalues
pecrsep
pedcsep
pedfsep
pedpsep
pedrsep
pehfsep
pehpsep
pempsep
pemrsep
peoosep
peqfsep
peqpsep
qadjust
sensok
shefdur
unkstnvalue
vaddadjust
vfypairs
vfyprocpairs
vfyruninfo
wsequation
wsfcst
wshistorical
wsperstats
SHEF Duration code
E
e char(1) adjustfactor
areasens
avg
commentvalue
ingestfilter
pairedvalues
pecrsep
pedcsep
pedfsep
pedpsep
pedrsep
pehfsep
pehpsep
pempsep
pemrsep
peoosep
peqfsep
peqpsep
qadjust
sensok
shefex
unkstnvalue
vaddadjust
vfypairs
vfyprocpairs
wsequation
wsfcst
wshistorical
wsperstats
SHEF Extreme code
(Note: areasens default value is ‘Z’)
e_date date qadjust end date
edate timestamp
w/o time zone
modbublshft
modignorets
modqcshift
modqpshift
modrainsnow
modromult
modrrimult
modsetmsng
modswitchts
modtsadd
modtsmult
modtsrepl
moduadj
ending date for changes, must be less than or equal to "e;vdate"e; except when "e;sdate"e; is greater than "e;vdate"e;. (minutes and seconds are always ‘00:00’)
efa float operapicont effective frost area
efc float opersacsma effective forest cover (%/100)
efc float opersacsma effective forest cover
elev integer location elevation (ft MSL)
elev float opersnow17
reservoir
elevation (ft MSL)
elev_brk1 integer areasens elevation break #1 (lower) (default value is -9999)
elev_brk2 float opersnow17 elevations of area-elevation curve (units given in column elevunit)
elevation integer flashflood elevation (ft MSL rounded to nearest ft) at location of flashflood
elevation01 -
elevation30
real slopeprofile stage height corresponding to slope distance (distance01 - distance 30) (ft)
elevunit char(4) opersnow17 units of the elevations in the area-elevation curve
enddate date slopeprofile end date for slope profile
endtime timestamp
w/o time zone
flashflood ending date and time of flash flood event
eng_unit varchar(8) shefpe abbreviation of the English unit for the specified SHEF PE. (eg, ft for feet)
eper integer wsequation
wshistorical
wsperstats
end Water Year month of forecast period
err integer prod parse & post error print flag: -1=no, 0=yes if errors, 1=yes
etapr float opersacsma ET demand or PE adjustment for April
etaug float opersacsma ET demand or PE adjustment for August
etdec float opersacsma ET demand or PE adjustment for December
etfeb float opersacsma ET demand or PE adjustment for February
etjan float opersacsma ET demand or PE adjustment for January
etjul float opersacsma ET demand or PE adjustment for July
etjun float opersacsma ET demand or PE adjustment for June
etmar float opersacsma ET demand or PE adjustment for March
etmay float opersacsma ET demand or PE adjustment for May
etnov float opersacsma ET demand or PE adjustment for November
etoct float opersacsma ET demand or PE adjustment for October
etsep float opersacsma ET demand or PE adjustment for September
extremum char(1) ofsdatatrans
vfyruninfo
SHEF Extremum code
F
fax varchar(12) swsmail fax telephone # (xxx-xxx-xxxx)
fcst_s char(1) vfypairs
vfyprocpairs
forecast SHEF Source code
fcst_t char(1) vfypairs
vfyprocpairs
forecast SHEF Type code
fcstts1 char(1) vfyruninfo forecast SHEF Type code
fcstts2 char(1) vfyruninfo forecast SHEF Source code
fcstvalue float vfypairs
vfyprocpairs
forecast data value
feb float avg
pempsep
pemrsep
monthly value for February
febmf float opersnow17 melt factor for February
febmn float wshistorical reasonable min for February
febmp float wshistorical most probable for February
febmx float wshistorical reasonable max for February
febq char(1) pempsep
pemrsep
SHEF Qualifier code for February
fei float statesapicont frost efficiency index
fetch_oper integer modctrl fetch mod during operational runs (1=yes, 0=no)
fetch_spin float statesapicont fetch mod during spin runs (1=yes, 0=no)
ffg_1_hr smallint flashflood 1-hour flash flood guidance value at the beginning the event
ffg_3_hr smallint flashflood 3-hour flash flood guidance value at the beginning the event
ffg_6_hr smallint flashflood 6-hour flash flood guidance value at the beginning the event
fgix float statessacsma frozen ground index (T)
fgroupid varchar(8) fgroup
fgroupseg
current forecast group id in NWSRFS
fgroupnum integer fgroup forecast group number in carryover group
fi float statesapicont frost index
ficr float operapicont critical frost index value
fis numeric(10,2) rivercrit forecast issuance stage (ft)
fisf numeric(10,2) rivercrit flow at forecast issuance stage (cfs)
fisq char(1) rivercrit source of fis/fisf, valid values:
E=e-19
M=memo
P=personal communication (i.e. phone)
I=internal (i.e. RFC determined)
U=unknown
flood numeric(10,2) rivercrit flood stage (ft)
floodf float rivercrit flow at flood stage (cfs)
floodpool float reservoir flood pool elevation (ft MSL)
floodq char(1) rivercrit source of flood/floodf, valid values:
E=e-19
M=memo
P=personal communication (i.e. phone)
I=internal (i.e. RFC determined)
U=unknown
flow float crest flow (cfs)
flow real flashflood flow (cfs)
flow float modbublshft flow (cfs)
flow float modbublshft
modqcshift
modqpshift
flow (cfs)
flow qual char(1) crest qualifier code
fract1 - fract12 float opersnow17 fractional areas for area-elevation curve
frsx float operapicont maximum percent runoff
fwd_time_window real ofsdatatrans the forward timeliness window (decimal hours) for accepting data into OFS through OFS_DE
G
gates integer reservoir number of gates
gbpub char(1) swsmail receives Great Basin pub? Y/N
gbsurvey char(1) swsmail receives Great Basin survey? Y/N
ghc float operapicont daily thaw rate due to ground heat
goes varchar(8) location data collection platform (DCP) identifier
gra char(1) prod product flag, Y/N
gross_range_max float datalimits
locdatalimits
upper end of gross range check
gross_range_min float datalimits
locdatalimits
lower end of gross range check
H
heatdef float statessnow17 heat deficit (L)
highscreen float rivercrit upper limit screen stage (ft)
highscreenf float rivercrit upper limit screen flow (cfs)
highscreenq char(1) rivercrit source of highscreen/highscreenf:
E=e-19
M=memo
P=personal communication (i.e. phone)
I=internal (i.e. RFC determined)
U=unknown
hsa char(3) location Hydrologic Service Area WFO identifier (upper case)
huc varchar(8) location USGS Hydrologic Unit Code
hw char(1) crest high water mark flag: X=true, Null=false
hyd char(3) wsequation initials of hydrologist doing development
I
id varchar(10) prod product identifier
id varchar(10) swsmail recipient identifier
id1 varchar(8) modaeicqn
modaescchng
modaiadj
modapicbasf
modapicco
modbublshft
modchgblend
modignorets
modmfc
modqcshift
modqpshift
modrainsnow
modrochng
modromult
modrrichng
modrrimult
modsacbasef
modsacco
modsetmsng
modsetqmean
modssarreg
modswitchts
modtsadd
modtschng
modtsmult
modtsrepl
moduadj
moduhgadj
moduhgchng
modweadd
modwechng
modxinco
modzerodiff
segment identifier
id2 varchar(8) modaeicqn
modaescchng
modaiadj
modapicbasf
modapicco
modbublshft
modchgblend modignorets
modmfc
modqcshift
modqpshift
modrainsnow
modrochng
modromult
modrrichng
modrrimult
modsacbasef
modsacco
modsetmsng
modsetqmean
modssarreg
modswitchts
modtsadd
modtschng
modtsmult
modtsrepl
moduadj
moduhgadj
moduhgchng
modweadd
modwechng
modxinco
modzerodiff
time series identifier (default value is 'NONE')
idur smallint adjustfactor
areasens
avg
commentvalue
datalimits
ingestfilter
locdatalimits
ofsdatatrans
pairedvalues
pecrsep
pedcsep
pedfsep
pedpsep
pedrsep
pehfsep
pehpsep
pempsep
pemrsep
peoosep
peqfsep
peqpsep
qadjust
sensok
shefdur
unkstnvalue
vaddadjust
vfypairs
vfyprocpairs
wsequation
wsfcst
wshistorical
wsperstats
numeric value of SHEF Duration code
(This duration code specifies the units of time and the number of units as follows {where XXX is the number of units, i.e., eight days would be 2008}:
0 - instantaneous
7XXX - seconds
0XXX - minutes
1XXX - hours
2XXX - days
3XXX - months
4XXX - years
5000 - unspecified
5001 - seasonal
5002 - entire period of record
5003 - variable period
5004 - time period beginning at 7am local time prior to the observation time and ending at the observation time
5005 - unknown
6XXX - months - end of month)
impounded date reservoir the date that water was initially impounded by this reservoir
ingest char(1) ingestfilter post data to database: 0=no, 1=yes
init char(3) sensok initials of person making the entry
interpolate char(3) rating method of interpolation/extrapolation used, LIN or LOG
J
jam char(3) crest ice jam affect flag: X=true, Null=false
jan float avg
pempsep
pemrsep
monthly value for January
janmf float opersnow17 melt factor for January
janmn float wshistorical reasonable min for January
janmp float wshistorical most probable for January
janmx float wshistorical reasonable max for January
janq char(1) pempsep
pemrsep
SHEF Qualifier code for January
jr2 float wsequation equation jackknife r2 (correlation coefficient**2)
jul float avg
pempsep
pemrsep
monthly value for July
julmf float opersnow17 melt factor for July
julmn float wshistorical reasonable min for July
julmp float wshistorical most probable for July
julmx float wshistorical reasonable max for July
julq char(1) pempsep
pemrsep
SHEF Qualifier code for July
jun float avg
pempsep
pemrsep
monthly value for June
junmf float opersnow17 melt factor for June
junmn float wshistorical reasonable min for June
junmp float wshistorical most probable for June
junmx float wshistorical reasonable max for June
junq char(1) pempsep SHEF Qualifier code for June
junq char(1) pempsep
pemrsep
SHEF Qualifier code for June
K
keyword varchar(5) modapicco
modignorets
modrainsnow
modsacco
modssarreg
modswitchts
moduhgadj
modxinco
for modswitchts default value = 'PCPN' for moduhgadj default value = 'HADJ' for modxinco default value = 'WUC')
L
lat float location
opersnow17
rivercrit
latitude (degrees decimal)
latitude real flashflood latitude (degrees decimal)
lcpub char(1) swsmail receives Lower Colorado pub? Y/N
lcsurvey char(1) swsmail receives Lower Colorado survey? Y/N
liquid float statessnow17 liquid fraction of swe (decimal fraction)
load integer modctrl save mod to database: 1=yes, 0=no
location_detail varchar(30) flashflood location information
lon float location
rivercrit
longitude (degrees decimal)
longitude real flashflood longitude (degrees decimal)
lowscreen float rivercrit lower screen stage (ft)
lowscreenf float rivercrit lower screen flow (cfs)
lowscreenq char(1) rivercrit source of lowscreen/lowscreenf
E=e-19
M=memo
P=personal communication (i.e. phone)
I=internal (i.e. RFC determined)
U=unknown
lwrstage float modbublshft lower stage at which bublshft mod is applied
lzfpc float statessacsma lower zone free primary contents (L)
lzfpm float opersacsma lower zone free primary capacity (mm)
lzfsc float statessacsma lower zone free supplemental contents (L)
lzfsm float opersacsma lower zone free supplemental capacity (mm)
lzpk float opersacsma fractional daily primary withdrawal rate
lzsk float opersacsma fractional daily supplemental withdrawal rate
lztwc float statessacsma lower zone tension water contents (L)
lztwd float statessacsma lower zone tension water deficit (L)
lztwm float opersacsma lower zone tension water capacity (mm)
M
majflood numeric(10,2) rivercrit major floodcat stage (ft)
majfloodf float rivercrit flow of major floodcat stage (cfs)
majfloodq char(1) rivercrit source of majflood/majfloodf
E=e-19
M=memo
P=personal communication (i.e. phone)
I=internal (i.e. RFC determined)
U=unknown
mar float avg
pempsep
pemrsep
monthly value for March
marker char(1) slopeprofile marker used to measure distance to water in slope profile (eg. marker a)
marmf float opersnow17 melt factor for March
marmn float wshistorical reasonable min for March
marmp float wshistorical most probable for March
marmx float wshistorical reasonable max for March
marq char(1) pempsep
pemrsep
SHEF Qualifier code for March
maxelev float opersnow17 max elevation (100% area) of area-elevation curve (ft MSL)
maxlapse float opersnow17 lapse rate at time of max temperature (default value is 0.9000000000000000)
maxswe float statessnow17 seasonal maximum snow water equivalent to date (L)
may float avg
pempsep
pemrsep
monthly value for May
maymf float opersnow17 melt factor for May
maymn float wshistorical reasonable min for May
maymp float wshistorical most probable for May
maymx float wshistorical reasonable max for May
mayq char(1) pempsep
pemrsep
SHEF Qualifier code for May
mbase float opersnow17 base temperature for non-rain melt factor (deg C)
med25 float wsperstats 25-year median (kaf) (time period determined by the RFC)
med30 float wsperstats 30-year median (kaf) (time period determined by the RFC)
medpor float wsperstats period of record median (kaf)
met_unit varchar(8) shefpe abbreviation of the Metric unit for the specified SHEF PE (eg, deg C)
mfmax float opersnow17 maximum non-rain melt factor
mfmin float opersnow17 minimum non-rain melt factor
mile float rivercrit river mile
minelev float opersnow17 minimum elevation (0% area) of area-elevation curve (ft MSL)
minlapse float opersnow17 lapse rate at time of min temperature (default value is 0.4000000000000000)
mn float wsperstats historical minimum (kaf)
mod_name varchar(30) modctrl mod name
modflood numeric(10,2) rivercrit moderate floodcat stage (ft)
modfloodf float rivercrit flow for moderate floodcat stage (cfs)
modfloodq char(1) rivercrit source of modflood/modfloodq
E=e-19
M=memo
P=personal communication (i.e. phone)
I=internal (i.e. RFC determined)
U=unknown
modvalue float modaeicqn
modaescchng
modaiadj
modapicbasf
modapicco
modchgblend
modmfc
modrochng
modromult
modrrichng
modrrimult
modsacbasef
modsacco
modsetqmean
modssarreg
modtsadd
modtschng
modtsmult
modtsrepl
moduadj
moduhgadj
moduhgchng
modweadd
modwechng
modxinco
modzerodiff
Modified data value
monthdayend varchar(5) datalimits
locdatalimits
the ending month-day (MM-DD) for a range of days in the year
monthdaystart varchar(5) datalimits
locdatalimits
the starting month-day (MM-DD) for a range of days in the year
mpe_input char(1) ingestfilter feed data to mpe: 0=no, 1=yes
multiplier float adjustfactor multiplier in formula to change from raw value to adjusted value
mx float wsperstats historical max (kaf)
N
name varchar(60) location station name (city name with distance and direction, mixed case)
name varchar(20) state name of state (mixed case)
name varchar(20) reservoir name of reservoir (mixed case)
name varchar(20) shefdur
hefex
shefpe1
shefprob
shefqc
shefts
description (mixed case)
name varchar(30) shefpe description (mixed case)
name varchar(40) swsmail name
name_city_location varchar(25) flashflood city name (mixed case)
name_river_stream varchar(25) flashflood river/stream name (mixed case)
national char(1) vfyruninfo 'Y'es if the location is part of the national statistics program, meaning that it is to be included in computations done as part of an NATLSTATS action in the IVP Batch Program.
ncdc char(2) state NCDC number for state
net char(1) prod internet disseminatior flag, Y/N
new_report char(1) ingestfilter new entry? Y/N
nmf float opersnow17 maximum negative melt factor (mm/deg C/6hr)
no_timeperiods integer modmatchng
modrochng
modrrichng
modsetqmean
modssarreg
modtschng
moduhgchng
number of time periods to apply the mod value
note1 char(50) seg temporary note/comment field
note2 char(50) seg temporary note/comment field
note3 char(50) seg temporary note/comment field
note4 char(50) seg temporary note/comment field
nov float avg
pempsep
pemrsep
monthly value for November
novmf float opersnow17 melt factor for November
novmn float wshistorical reasonable min for November
novmp float wshistorical most probable for November
novmx float wshistorical reasonable max for November
novq char(1) pempsep
pemrsep
SHEF Qualifier code for November
numfgroups integer cgroup number of forecast groups in the carryover group
numoper integer seg number of operations
numpts integer opersnow17 number of points in the area-elevation curve
numsegs integer fgroup number of segments in the forecast group
O
obs_s char(1) vfypairs
vfyprocpairs
observed SHEF Source code
obs_t char(1) vfypairs
vfyprocpairs
observed SHEF Type code
obstime time
w/o time zone
ingestfilter
pedcsep
pedfsep
pedrsep
peoosep
statesapicont
statessacsma
statessnow17
vfypairs
vfyprocpairs
observation date and time
obstime date pecrsep
pehfsep
pehpsep
peqfsep
peqpsep
observation date
obstime date pedpsep observation date, where day is always the first of the month, i.e. ‘01’
obsvalue float vfypairs
vfyprocpairs
observed data value
oct float avg
pempsep
pemrsep
monthly value for October
octmf float opersnow17 melt factor for October
octmn float wshistorical reasonable min for October
octmp float wshistorical most probable for October
octmx float wshistorical reasonable max for October
octq char(1) pempsep
pemrsep
SHEF Qualifier code for October
offsets float[ ] rating array of stage, offset pairs
ofs_data_type char(4) ofsdatatrans
ofsstntrans
data type identifiers used in OFS Version 5 (e.g., PP06, TWEL, TN24, etc.)
ofs_input char(1) ingestfilter feed data to OFS: 0=no, 1=yes
ofs_lid varchar(8) ofsstntrans the unique identifier used by OFS for a station location
ok char(1) sensok N=bad, Y=good
oktime timestamp
w/o time zone
sensok date and time of change in status
olddatum char(1) crest true/false flag where X=true (entry is based on old datum), Null=false
operid varchar(8) modaeicqn
odaescchng
modaiadj
modapicbasf
modapicco
modbublshft
modchgblend
modignorets
modmfc
modqcshift
modqpshift
modrainsnow
modrochng
modromult
modrrichng
modrrimult
modsacbasef
modsacco
modsetqmean
modssarreg
modswitchts
modtsadd
modtschng
modtsmult
modtsrepl
moduadj
moduhgadj
moduhgchng
modweadd
modwechng
modxinco
modzerodiff
segoper
NWSRFS operation identifier within a segment (default value is ‘ALL’)
opertype varchar(10) modtsadd
modtsmult
modtsrepl
opertype
segoper
NWSRFS operation type within a segment (default value is ‘ALL’)
opid varchar(8) operapicont
opersacsma
opersnow17
operunithg
statesapicont
statessacsma
statessnow17
current operation id in NWSRFS segment
othagid varchar(16) rating other agency identifier
ownag varchar(6) ingestfilter owner agency
owner varchar(10) reservoir owner of dam
ownloc char(3) ingestfilter owner agency location
P
p char(1) areasens
avg
commentvalue
pairedvalues
pecrsep
pedcsep
pedfsep
pedpsep
pedrsep
pehfsep
pehpsep
pempsep
pemrsep
peoosep
peqfsep
peqpsep
qadjust
sensok
shefprob
unkstnvalue
vfypairs
vfyprocpairs
wsequation
wsfcst
wshistorical
wsperstats
owner agency location
pap integer prod parse & post flag: 0=no, 1=yes
pbase float opersacsma primary baseflow (cms)
pctimp float opersacsma minimum impervious area (%/100)
pe1 char(1) adjustfactor
areasens
avg
commentvalue
datalimits
ingestfilter
locdatalimits
ofsdatatrans
pairedvalues
pecrsep
pedcsep
pedfsep
pedpsep
pedrsep
pehfsep
pehpsep
pempsep
pemrsep
peoosep
peqfsep
peqpsep
qadjust
rating
ratingshift
rivercrit
sensok
shefpe
shefpe1
shefpetrans
unkstnvalue
vaddadjust
vfypairs
vfyprocpairs
vfyruninfo
wsequation
wsfcst
wshistorical
wsperstats
1st char SHEF PE code
pe2 char(1) adjustfactor
areasens
avg
commentvalue
datalimits
ingestfilter
locdatalimits
ofsdatatrans
pairedvalues
pecrsep
pedcsep
pedfsep
pedpsep
pedrsep
pehfsep
pehpsep
pempsep
pemrsep
peoosep
peqfsep
peqpsep
qadjust
rating
ratingshift
rivercrit
sensok
shefpe
shefpetrans
unkstnvalue
vaddadjust
vfypairs
vfyprocpairs
vfyruninfo
wsequation
wsfcst
wshistorical
wsperstats
2nd char SHEF PE code
peadj float operapicont
opersacsma
ET demand adjustment factor
peakpub char(1) swsmail receives Peak Flow pub? Y/N
peaksurvey float opersacsma receives Peak Flow survey? Y/N
peaktime timestamp
w/o time zone
flashflood date and time peak stage/flow occurred for the flash flood event
pen float operapicont minimum daily PE rate
pex float operapicont maximum daily PE rate
pfree float opersacsma percolated water which always goes directly to lower zone free water storages (%/100)
pimpv float operapicont percent impervious area
plwhc float opersnow17 maximum amount of liquid-water held against gravity drainage (decimal fraction)
pmax integer prod number of versions to store
pool float rivercrit normal pool elevation (ft MSL) at a river station (desired elevation for water supply purposes, is really the same as conserpool in the Reservoir table)
por varchar(30) rivercrit period of record
pos char(1) pos area position within watershed: G=glacial, U=upper, L=lower, M=middle, 0=only
post smallint location post code,valid values: 0=no post, 1=post everything, 2=check ingestfilter table ingest flag
postingtime timestamp
w/o time zone
commentvalue
pairedvalues
pedcsep
pedfsep
pedrsep
peoosep
unkstnvalue
date and time data was posted to the database
power integer shefqc ranking order of quality codes
pr1 char(1) prod print flag for device 1: Y/N
prc integer wsequation number of principal components
postingtime timestamp
w/o time zone
commentvalue
pairedvalues
pedcsep
pedfsep
pedrsep
peoosep
unkstnvalue
date and time data was posted to the database
power integer shefqc ranking order of quality codes
pr1 char(1) prod print flag for device 1: Y/N
prc integer wsequation number of principal components
precip_gage1_amt real flashflood storm total at precip gage #1 (inches)
precip_gage2_amt real flashflood storm total at precip gage #2 (inches)
precip_gage3_amt real flashflood storm total at precip gage #3 (inches)
precip_gage1_idur smallint flashflood storm total duration at gage #1 (hours)
precip_gage2_idur smallint flashflood storm total duration at gage #2 (hours)
precip_gage3_idur smallint flashflood storm total duration at gage #3 (hours)
precip_gage1_name varchar(20) flashflood location of precip gage #1
precip_gage2_name varchar(20) flashflood location of precip gage #2
precip_gage3_name varchar(20) flashflood location of precip gage #3
prelim char(1) crest preliminary value flag: X=true, Null=false
printout char(4) opersnow17 printer output control
probability real shefprob numerical value of forecast probability as defined in Table 6 of the SHEF manual (two codes do not have assigned probability values in the SHEF Manual, M (mean) and Z (filler); the SHEF Parser program assigns values of M = -0.5, Z = 1.0)
product_id char(10) commentvalue
pairedvalues
pedcsep
pedfsep
pedrsep
peoosep
unkstnvalue
product identifier
producttime timestamp
w/o time zone
commentvalue
pairedvalues
pedcsep
pedfsep
pedrsep
peoosep
unkstnvalue
product date and time
pub1 char(4) wsequation publication code, mmdd (mm is the month, dd is the day and is always 01)
pub2 char(1) wsequation publication code, valid values are P (official/published equation) and a-z
pxadj float operapicont
opersacsma
opersnow17
precipitation adjustment factor (default is 1.0000000000000000)
pxtemp float opersnow17 temperature that separates rain from snow (deg C)
Q
q float operunithg unit hydrograph ordinates (cms/mm or cfs/in)
quality_code integer commentvalue
pairedvalues
pedcsep
pedfsep
pedrsep
peoosep
unkstnvalue
vfypairs
vfyprocpairs
A single integer number that holds all results of Q/C testing performed on the data value. The results of the Q/C tests are bit-packed into this number.
Summary of Q/C Bits
Bit 31: sign bit, always 0
Bit 30: Value-Not-Bad summary indicator
Bit 29: Value-Not-Questionable summary indicator
Bit 28: post data ingest tests performed indicator
Bits 24-27: reserved for future use
Bit 23: external Q/C Not-Bad indicator
Bit 22: manual Q/C Good indicator
Bit 21: gross range test result
Bit 20: external Q/C Not-Questionable indicator
Bit 19: reasonableness range test result
Bit 18: rate-of-change test result
Bits 08-17: reserved for future national tests
Bits 00-07: available for local tests
qz00,qz06,qz12,qz18 char(1) peqfsep
peqpsep
pseudo array, SHEF Qualifier codes for 6-hrly time step data
qz0000 - qz2345 char(1) pecrsep pseudo array, SHEF Qualifier codes for 15-min time step data
qzday01 - qzday31 char(1) pecrsep pseudo array, SHEF Qualifier codes for daily time step data
qzhr00 - qzhr23 char(1) pehfsep
pehpsep
pseudo array, SHEF Qualifier codes for hourly data
R
rdate timestamp
w/o time zone
modaeicqn
modaescchng
modaiadj
modapicbasf
modapicco
modbublshft
modchgblend
modignorets
modmfc
modqcshift
modqpshift
modrainsnow
modrochng
modromult
modrrichng
modrrimult
modsacbasef
modsacco
modsetmsng
modsetqmean
modssarreg
modswitchts
modtsadd
modtschng
modtsmult
modtsrepl
moduadj
moduhgadj
moduhgchng
modweadd
modwechng
modxinco
modzerodiff
date mod was deleted from NWSRFS

date and time (minutes and seconds are always '00:00')
reason varchar(80) sensok reason for change in status (optional)
reason_range_max float datalimits
locdatalimits
largest reasonable data value for a particular data type (eg, 120 deg F), used for automated Q/C control by the SHEF Decoder ingest process (expected to be more restrictive than a gross_range_max data limit)
reason_range_min float datalimits
locdatalimits
smallest reasonable data value for a particular data type (eg, 29.00 in Hg), used for automated data Q/C by the SHEF Decoder ingest process (expected to be more restrictive than a gross_range_min data limit)
record numeric(10,2) rivercrit stage of record (ft)
recordf float rivercrit flow of record (cfs)
recordq char(1) rivercrit source of record/recordf, valid values:
E=e-19
M=memo
P=personal communication (i.e. phone)
I=internal (i.e. RFC determined)
U=unknown
ref_value integer pairedvalues second independent variable for use in prime key
regional char(1) areasens regionalized MAP/MAP delineation? Y/N (default value is ‘N’)
remark varchar(255) rivercrit stores any type of documentation or commentary in a free text format
response_time float rivercrit typical or average response time (hours) for flooding to occur at this river station from a precipitation event
resptime varchar(8) vfyruninfo FAST - < 24 hours response time
MEDIUM - >= 24 hours and < 60 hours
SLOW - >= 60 hours
revision char(1) commentvalue
pairedvalues
pedcsep
pedfsep
pedrsep
peoosep
unkstnvalue
SHEF revision flag
rexp float opersacsma exponent for the percolation equation
rfc char(2) location
rfc
first 2 characters of the RFC acronym (upper case) (eg, MB for MBRFC)
rfs_id varchar(8) areasens NWSRFS area id
rfs_input char(1) rating used by OFS, Y/N
riva float opersacsma riparian vegetation area (%/100)
riva float operapicont riparian vegetation coverage
roc_max float datalimits
locdatalimits
the largest possible rate-of-change for a particular data type (in data type units per hour; eg, 3.0 ft/hr for a river stage)
rrevise date rivercrit the date when E-19 data was last updated for a river station
rserv float opersacsma lower zone free water which cannot be transferred to lower zone tension water (%/100)
rval float operapicont critical antecedent index value for riparian vegetation
S
s char(1) adjustfactor
areasens
avg
commentvalue
ingestfilter
pairedvalues
pecrsep
pedcsep
pedfsep
pedpsep
pedrsep
pehfsep
pehpsep
pempsep
pemrsep
peoosep
peqfsep
peqpsep
qadjust
sensok
shefts
unkstnvalue
vaddadjust
wsequation
wsfcst
wshistorical
wsperstats
SHEF Source code
s_or_f char(1) modaeicqn
modaescchng
modaiadj
modapicbasf
modapicco
modchgblend
modignorets
modmfc
modrainsnow
modrochng
modromult
modrrichng
modrrimult
modsacbasef
modsacco
modswitchts
moduadj
moduhgadj
modweadd
modwechng
modxinco
apply mod to segment or forecast group, S or F (default value is ‘S’)
sbd date location
reservoir
begin date (mm/dd/ccyy)
screenrate float rivercrit max rise (rate of change) allowed for stage (ft)
screenratef float rivercrit max rise (rate of change) allowed for flow (cfs)
screenrateq char(1) rivercrit source for screenrate/screenratef
E=e-19
M=memo
P=personal communication (i.e. phone)
I=internal (i.e. RFC determined)
U=unknown
sdate timestamp
w/o time zone
modaeicqn
modaescchng
modaiadj
modapicbasf
modapicco
modbublshft
modchgblend
modignorets
modmfc
modqcshift
modqpshift
modrainsnow
modrochng
modromult
modrrichng
modrrimult
modsacbasef
modsacco
modsetmsng
modsetqmean
modssarreg
modswitchts
modtsadd
modtschng
modtsmult
modtsrepl
moduadj
moduhgadj
moduhgchng
modweadd
modwechng
modxinco
modzerodiff
date for which the data value applies, must be greater than or equal to the Technique STARTRUN start date and time (minutes and seconds are always ‘00:00’)
screenratet float rivercrit time interval for screenrate/screenratef (hours or fractional hours)
seas_mf integer opersnow17 seasonal melt-factor variation (default value is 0)
sed date location
reservoir
end date (mm/dd/ccyy) (Note: for Location table, sed must be null for most current sbd, or data will not post)
segid varchar(8) fgroupseg
operapicont
opersacsma
opersnow17
operunithg
seg
segoper
statesapicont
statessacsma
statessnow17
segment id
segnum integer ffgroupseg order number of segment within forecast group
senrk smallint vfyruninfo sensor rank, i.e. 1, 2 or 3
sents1 char(1) ffgroupseg the SHEF Type code of the observed type source corresponding to the sensor
sents2 char(1) ffgroupseg the SHEF Source code of the observed type source corresponding to the sensor
sep float avg
pempsep
pemrsep
monthly value for September
sepmf float opersnow17 melt factor for September
sepmn float wshistorical reasonable min for September
sepmp float wshistorical most probable for September
sepmx float wshistorical reasonable max for September
sepq char(1) pempsep
pemrsep
SHEF Qualifier code for September
sh_a float ratingshift first shift
sh_b float ratingshift second shift
sh_c float ratingshift third shift
sh_d float ratingshift fourth shift
shef_comment varchar(80) commentvalue a comment about a piece of data (i.e., a forecast value or an observed value) sent with a SHEF encoded message
shef_qualifier_code char(1) commentvalue
pairedvalues
pedcsep
pedfsep
pedrsep
peoosep
shefqc
unkstnvalue
SHEF Qualifier code
shef_source_code char(1) ofsstntrans SHEF Source code
si float opersnow17 areal water-equivalent above which there is always 100% snow cover (mm)
side float opersacsma ratio of non-channel baseflow to channel baseflow
sign char(1) qadjust addition (+) or subtraction (-)
sigrate float rivercrit significant rise (rate of change) value for stage (ft)
sigratef float rivercrit significant rise (rate of change) value for flow (cfs)
sigrateq char(1) rivercrit source for sigrate/sigratf, valid values:
E=e-19
M=memo
P=personal communication (i.e. phone)
I=internal (i.e. RFC determined)
U=unknown
sigratet float rivercrit time interval for sigrate/sgratef (hours or fractional hours)
sill float reservoir elevation of the sill structure of the dam that holds a reservoir (ft MSL)
size_mi2 integer areasens watershed size (drainage area) (sq. miles)
slot integer modmatchng
modrochng
modrrichng
modsetqmean
modssarreg
modtschng
moduhgchng
operunithg
qadjust
order number
smi float statesapicont surface moisture index
smix float operapicont maximum value for smi
source varchar(25) flashflood source of the flash flood information
spillway float reservoir elevation of the dam spillway structure
sr2 float wsequation equation r2 (correlation coefficient**2)
src varchar(10) ratingshift
rating
source of rating table, for example: USGS, ALERT, CODWR, USBR, USACE, OFS, etc.
sse float wsequation equation std error
stage float crest stage value (ft)
stage real flashflood peak stage (ft) for the flash flood event
stage float modbublshft
modqcshift
modqpshift
stage value of stage/discharge pair given in mod (ft)
state char(2) counties
flashflood
location
state
2-char Post Office state code (upper case)
state varchar(10) swsmail can be state name but recommend use 2-char Post Office state code
statefips char(2) state state FIPS code
std25 float wsperstats 25-year std deviation (kaf) (time period determined by the RFC)
std30 float wsperstats 30-year std deviation (kaf) (time period determined by the RFC)
std30 float wsperstats 30-year std deviation (kaf) (time period determined by the RFC)
stdpor float wsperstats period of record std deviation (kaf)
stg_qual char(1) crest quality code
stgflow float[ ] rating array of stage and flow pairs
stream varchar(32) rivercrit name of river/stream (mixed case)
subarea integer modxinco sub-area number to which the change applies
sums_sc char(4) opersnow17 option to store sums of snow cover water balance variables (default value is SUMS)
surchg float reservoir maximum elevation (ft MSL) for water stored in a reservoir before release is required
swe float statessnow17 current snow water equivalent (L)
T
t char(1) adjustfactor
areasens
avg
commentvalue
ingestfilter
pairedvalues
pecrsep
pedcsep
pedfsep
pedpsep
pedrsep
pehfsep
pehpsep
pempsep
pemrsep
peoosep
peqfsep
peqpsep
qadjust
sensok
shefts
unkstnvalue
vaddadjust
wsequation
wsfcst
wshistorical
wsperstats
SHEF Type code
taelev float opersnow17 elevation of temperature time series
tbl numeric(6,2) rating number of rating table
tbl_ver numeric(6,2) ratingshift number of rating table
threshold_runoff float rivercrit threshold runoff value (inches) for a site (used by the Site-Specific Model)
tide varchar(8) rivercrit indicator of tidal effects applicable to a river station, valid values: NONE, MINOR, MODERATE, MAJOR
timeint integer modsetmsng
modssarreg
modtsadd
modtschng
modtsmult
modtsrepl
time interval
tindex float statessnow17 antecedent temperature index factor (T)
tipm float opersnow17 antecedent snow temperature index parameter
top float reservoir elevation (ft MSL) of the top of dam
ts_rank smallint ingestfilter numerical ranking of alternate SHEF Type Source codes for the same location and parameter
type varchar(10) reservoir type of dam construction (eg, earthen, concrete, levee, gravity, arch)
U
uadj float opersnow17 average value of the wind function during rain-on-snow events (mm/mb)
ucpub char(1) swsmail receives Upper Colorado pub? Y/N
ucsurvey char(1) swsmail receives Upper Colorado survey? Y/N
uhgdur integer rivercrit unit hydrograph duration (hours)
units char(4) rating ENGL or METR
units char(1) operapicont
opersacsma
opersnow17
operunithg
statesapicont
statessacsma
statessnow17
E=English, M=Metric
update char(6) opersnow17 update option (only used for Calibration System programs)
updtcov float opersnow17 tolerance used when updating areal extent of snow cover (default value is 0.0000000000000000)
updtwe float opersnow17 tolerance used when updating water equivalent (decimal fraction) (default value is 0.0000000000000000)
uprstage float modbublshft upper stage at which bublshft mod is applied
use_avse char(4) opersnow17 rain-snow elevation option
use_carry char(4) opersnow17 read carryover option
uses varchar(8) reservoir designator of the uses made of a reservoir
uzfwc float statessacsma upper zone free water contents (L)
uzfwm float opersacsma upper zone free water capacity (mm)
uzk float opersacsma fractional daily upper zone free water withdrawal rate
uztwc float statessacsma upper zone tension water contents (L)
uztwd float statessacsma upper zone tension water deficit (L)
uztwm float statessacsma upper zone tension water capacity (mm)
V
val_a float ratingshift stage value for first shift
val_b float ratingshift stage value for second shift
val_c float ratingshift stage value for third shift
val_d float ratingshift stage value for fourth shift
valid_date timestamp
w/o time zone
rating valid date and time of rating curve
validtime date pehfsep
peqfsep
date when forecast value is valid
validtime date pedcsep
pedfsep
vfypairs
vfyprocpairs
date-time when a forecast value is valid
validtime timestamp
w/o time zone
commentvalue
pairedvalues
unkstnvalue
date-time of an observation or date-time when a value is valid if forecast data
value_trans varchar(80) shefpetrans description of what the coded value translates to
vcal varchar(5) wsequation begin WYR month for variables 1 thru 15
vbm1 - vbm15 integer wsequation calibration period (yy-yy)
vcf1 - vcf15 float wsequation coefficient (wgt) for variables 1 thru 15
vdate timestamp
w/o time zone
modmatchng
modrochng
modromult
modrrichng
modrrimult
modsetqmean
modssarreg
modswitchts
modtsadd
modtschng
modtsmult
modtsrepl
the date after which the MOD is no longer valid, usually less than or equal to Technique LSTCMPDY valid date and time (minutes and seconds are always ‘00:00’)
vdatum varchar(20) rivercrit Reference value on which the gage zero (zd) is based. This generally is the National Geodetic Vertical Datum of 1929 (NGVD 1929) or the North American Vertical Datum of 1988 (NAVD 88). Not all locations use these datums (for example, river gages on the Ohio River use NGVD 1913, also referred to as the Ohio River Datum).
vdtime date rivercrit valid date of entry, information is valid from this point in time forward
vem1 - vem15 integer wsequation end WYR month for variables 1 thru 15
vid1 - vid15 varchar(5) wsequation 5-char lid of variables 1 thru 15
voice varchar(12) swsmail voice telephone # (xxx-xxx-xxxx)
vpd1 - vpd15 varchar(7) wsequation SHEF codes of variables 1 thru 15
W
wfo char(3) counties
flashflood
location
WFO identifier (upper case)
wfo_hsa char(3) wfo_hsa WFO identifier (upper case)
wkd float operapicont climatologically driest week number (1-52)
wkw float operapicont climatologically wettest week number (1-52)
wyr integer wshistorical water year (ccyy)
XYZ
ymn integer wsperstats year of historical minimum (ccyy)
ymx integer wsperstats year of historical maximum (ccyy)
ytrans char(2) wsequation Y transmission where: nl=natural log, sr=square root, cr=cube root
z00,z06,z12,z18 float peqfsep
peqpsep
6-hrly time step data values
z0000 - z2345 float pecrsep 15-min time step data values
zd float rivercrit elevation of the gage zero (i.e. when the gage reads zero) (ft MSL) (usually reported to the nearest 0.01 ft)
zday01-zday31 float pedpsep daily data values
zhr00 - zhr23 float pehfsep
pehpsep
hourly data values
zip varchar(11) swsmail Zip Code
zon char(4) counties
location
NWS zone code
zperc float opersacsma maximum percolation rate



Abbreviations


cfs cubic feet per second
cms cubic meters per second
kcfs thousand cubic feet per second
ET evapotranspiration
FIPS Federal Information Processing Standards
kaf thousand acre-feet
MSL mean sea level
PE potential evapotranspiration
SHEF Hydrometeorological Exchange Format
SHEF PE SHEF Physical Element