This file describes the structure and contents of text files which contain well and water level data maintained by the Ground Water Section of the Oregon Water Resources Department. 1. owrd_master.txt Primary well data file 2. owrd_wls.txt Water level data file 3. owrd_redrills.txt Well history file 4. wells.shp GIS coverage of field-located wells File descriptions: 1. owrd_master.txt Master file for field-located wells. Format: Tab-delimited Field name Type Description Logid String 10-character Well Log ID SowNum Integer State Observation Well Number SowStatus String State Obs Well Status UsgsSiteID String U.S. Geological Survey Site ID Trsqqqabc String Township/Range/Section/quarter location Trs String Township/Range/Section location SiteName String Site Name Owner String Owner of Well AquiferPrimary String Primary Aquifer Unit MaxDepth Number Maximum Depth of Well CsgDiamField Number Surface Casing Diameter (inches) noted in field WellTagWell Integer Well Tag on Well as verified in field WellTagLog Integer Well Tag on Well Log WaterLevFreq Integer Water Level Frequency SourceOrg String Source of Well Data (Organization) SourceOWRD String Source of Data at OWRD Basin String Primary Draingage Basin County String County of Well TaxlotNbr String Taxlot of Well Quad24 String U.S. Geol. Survey 1:24,000 Quad of Well Township Number Township (Willamette Meridian) TwpChar String Township Character (N or S) Range Number Range (Willamette Meridian) RngChar String Range Character (E or W) Section Integer Section Abcd String Qtr_160_acres, qtr_40_acres, qtr_10_acres, qtr_2.5_acres LocNum Integer Sequential Number LsdElev Number Land Surface Elevation, in feet LsdElevSource Integer Source for Land Surface Elevation LsdAccuracy Number Accruacy of LSD Elevation, in feet WellComments String Well Comments Use String Use of Well ObsWell String Observation Well (>2 water levels) C = Current N = Noncurrent 9 = Not an observation well ObsFlagAll String Observation Well Flag SC = State Obs Well, Current SC = State Obs Well, Noncurrent OC = Other Obs Well, Current ON = Other Obs Well, Noncurrent RecorderWell String Recorder Well (automatic water-level measuring instrument installed) AquiferTest String Well used for aquifer test (Y = Yes) GeophyLogs String Geophysical Logs Run (Y = Yes) WaterChem String Water Chemistry Available (Y = Yes) Cuttings String Drill Cuttings Available (Y = Yes) VideoLog String Video Log Available (Y = Yes) FlowingWell String Flows or flowed at one time (Y = Yes) Saline String Saline Water Encountered (Y = Yes) WellAddress String Well Address 2. owrd_wls.txt Water level file. Format: Tab-delimited Field name Type Description Logid String 10-character Well Log ID SowNum Integer State Observation Well Number Date Date Date of measurement Time Time Time of measurement (Pacific Std Time) DateTime String Date & Time (provided for convenience) WLBLS Number Water Level Below Land Surface, in feet WLElev Number Water Level Elevation, in feet (only available if LSDElev has been determined in owrd_master.txt file) Method String Method of Measurement Status String Status of Measurement MethodCode String Measurement Method Code StatusCode String Measurement Status Code MeasBy String Measured By SourceOrg String Source of Well Data (Organization) SourceOWRD String Source of Data at OWRD Comments String Water Level Comments MPHeight Number Measuring Point Height, in feet + = above land surface - = below land surface MPDescription String Description of Measuring Point 3. owrd_redrills.txt Well history file Format: Tab-delimited Field name Type Description Logid String 10-character Well Log ID OtherLogid String 10-character Well Log ID for deepenings, alterations, reconditionings, etc. TypeWork String Type of Work Reported on Well Log StartCard Integer Startcard Number Reported on Well Log FirstWater Number First Water Reported on Well Log CompleteDepth Number Completed Depth Reported on Well Log CompleteDate Date Completed Date Reported on Well Log LogOwner String Owner as Reported on Well Log Comment String Comments 4. wells.shp GIS coverage of field-located wells Format: ESRI shape file Projection: Oregon Lambert Field name Type Description Logid String 10-character Well Log ID LastUpdate String Date of last revision of location EstablBy String Source of field location (Person) XySource String Method of location HorizErr Number Horizontal Error of Location SourceOrg String Source of Well Data (Organization) SourceOWRD String Source of Data at OWRD WellTag Integer Well Tag (OWRD Well ID) on Well Log SowNum Integer State Observation Well Number ObsWell String Observation Well (>2 water levels) C = Current N = Noncurrent 9 = Not an observation well RecWell String Recorder Well (automatic water-level measuring instrument installed) ObsFlagAll String Observation Well Flag SC = State Obs Well, Current SC = State Obs Well, Noncurrent OC = Other Obs Well, Current ON = Other Obs Well, Noncurrent LsdElev Integer Land surface elevation at well