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: comma-delimitted Field name Type Description GwSiteID Number Primary key SiteType String Type of site (Spring or Well) SiteName String Site Name per OWRD Groundwater Section SourceOrg String Source of well data (Organization) SourceOWRD String Source of Data at OWRD Owner String Owner of well LogCounty String First 4 characters of county as identified by driller on well log LogNum Number Sequential well log number from OWRD well log database Logid String 10-character Well Log ID used as a database key for many related parameters WellTagWell Integer Well tag on well as verified in field WellTagLog Integer Well tag on well Log noted by driller SowNum Integer State observation well number UsgsSiteIdOwrd String U.S. Geological Survey Site ID as determined by OWRD MaxDepth Number Maximum depth of well (includes all alterations and deepenings) MaxCsgDiam Number Diameter, in inches, of largest casing installed in well State String State that well occurs in County String County that well occurs in as determined by OWRD location Basin String Primary draingage basin (OWRD administrative basin) 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 (A = NE, B = NW, C = SW, D = SE) LocNum Integer Sequential well location number for wells with the same TRSAbcd Taxlot String Taxlot map & tax lot number LongitudeWgs1984 Number Longitude, decimal degrees, WGS1984 LatitudeWgs1984 Number Latitude, decimal degrees, WGS1984 HorizErr Number Horizontal location error, in feet XySource String Method of location LsdElev Number Land surface datum elevation, in feet LsdAccuracy Number Accruacy of LSD elevation, in feet LsdElevDatum String Reference datum for land surface elevation Use String Use of well WlFreqAll Integer Water level frequency (number of water level measurements) RecorderWell String Recorder well (automatic water-level measuring instrument installed) (C = current, N = non-current, 9 = not a recorder well) AquiferTest String Well used for aquifer test (Y = Yes) GeophyLogs String Geophysical logs available (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 some time in the past (Y = Yes) Saline String Saline water encountered (Y = Yes) AquiferStatewide String Statewide aquifer unit per OWRD AquiferLocal String Local aquifer unit WellAddress String Well address WellComments String Well comments 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 exists 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 Township Township TwnshpChar Township Character Range Range RngChar Range Character Section Section 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 Waypoint String GPS waypoint or USGS Siteid if from USGS 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 Latitude Number Latitude, decimal degrees, WGS1984 Longitude Number Longitude, decimal degrees, WGS1984