OHD/HL - RFCDEV AppendixG OB82

HOME

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

OWP RSS Feed