Data_Dictionary_WaterRights

• Title: Water Rights Data Directory
• Decision Support - Doc Type: Report
• Date: 4/11/2008
• DSS: All
• Basin: Statewide
• Bill Number: SB92-87, HB93-1273, SB94-029, HB95-1155, SB96-153, SB97-008, HB98-1189, SB99-173, SB01-157, HB02-1152, SB03-110, HB04-1221, SB05-084, HB06-1313, SB07-122
• Prepared By: DWR

Water Rights
Data Dictionary
Column Name Description Datatype
Action Comment This comment describes any issues worth noting for the particular water Character
right action
Action Update The date the record was inserted/modified Datetime
Date the water right was settled by judicial procedure, i.e. date that the
Adj Date court awarded a water right Datetime
o Pre-1969 adjudications: The day the Judge signed the decree
o Post-1969 adjudications: The last day of the year of filing
Adjudication type coding.
AB -abandoned
AP -alternate point
C -conditional
Adj Type CA -conditional made absolute Character
EX -exchange
O -original
S -supplemental
TF -transfer from
TT -transfer to
A calculated number developed by the Division of Water Resources to
provide a simple and efficient method of ranking decrees in order of
seniority. Computed as follow:
• If the appropriation date is later than the previous adjudication
date, then the left side is the number of days between
Admin No 12/31/1849 and the appropriation date, and the right side is zero Numeric
(.00000)
• If the appropriation date is the same as, or earlier than, the
previous adjudication date, then the left side is the number of
days between 12/31/1849 and the previous adjudication date,
and the right side is the number of days between 12/31/1849 and
the appropriation date.
The date that can be proven in a court of law from which there was an
Appr Date open overt act upon the land to demonstrate an intent to apply water for Datetime
beneficial use and as awarded in the decree
Assoc ID The ID of the associated structure Integer
Assoc WD The water district of the associated structure Integer
Describes the amount as related to an augmentation plan, whereby the
structure is either Augmenting or Replacing; if applicable:
Aug Role Code Description Character
A Augment
R Recharge
Case No The case number of the Water Court action Character
County County in which the decreed structure is located Character
Div The water division in which the structure is decreed Integer
A unique number assigned to a structure to be used as an identification
number. The structure identification number and the water district are
ID combined (WDID) to create an ID number that is unique throughout the Integer
state. This combined number provides the ability to easily keep record
on water being exchanged or moved from one district to another or to