WellMain file from Water Supply Inventory

Number of Records In File: 91469
Number of Data Fields In File: 72

Data That Is Stored Within This File
Comments  =  Comments    
Town  =  Town    
WellReportNumber  =  Well Report Number    
Tag  =  Well Tag Number    
MapCell  =  Map Cell (Map Area)    
TaxMap  =  Tax Map    
SubDivision  =  Sub Division    
LotNumber  =  Lot Number    
DrillerLicenseNumber  =  Well Driller LIcense Number    
OwnersFirstName  =  Owner's First Name    expanded to 30 characters on 09/16/2003 for RN 821
OwnersLastName  =  Owner's Last Name    expanded to 50 characters on 09/16/2003 for RN 821
DateCompleted  =  Date Well Was Completed    
DateReceived  =  Date Report Received    
PurchaserFirstName  =  Purchaser's First Name    
PurchaserLastName  =  Purchaser's Last Name    
WellDepth  =  Total Depth of Well (in feet)    
YieldGPM  =  Yield Tested at (GPM)    
StaticWaterLevel  =  Static Water Level (in feet)    
OverBurdenThickness  =  Over Burden Thickness (in feet)    
CasingLength  =  Total Casing Length (in feet)    
CasingDiameter  =  Casing Diameter (in inches)    
CasingLengthBelowLandSurface  =  Casing Length Below (L.S.) Land Surface (in feet)    
CasingMaterial  =  Casing Material Code    
CasingWeight  =  Casing Weight (in lbs/foot):    
LinerLength  =  Length of Liner used (in feet):    
LinerDiameter  =  Liner Diameter (in inches):    
LinerMaterial  =  Liner Material code    
LinerWeight  =  Liner Weight (in lbs/foot):    
GroutType  =  Grout Type Code    
DiameterDrilledInBedrock  =  Diameter Drilled In Bedrock (in inches)    
DepthDrilledinBedrock  =  Depth Drilledin Bedrock (in feet)    
ScreenMakeType  =  Screen Make and Type Code    
ScreenMaterial  =  Screen Material Code    
ScreenLength  =  Screen Length (in feet)    
ScreenDiameter  =  Screen Diameter (in inches)    
ScreenSlotSize  =  Screen Slot Size (in inches)    
DepthofScreen  =  Depth to top of Screen below land surface (in feet)    
GravelSizeType  =  Gravel Size or Type    
WellUseCode  =  Proposed Use of Well Code    
WellReasonCode  =  Reason for Drilling Well Code    
DrillingMethodCode  =  Drilling Equipment Code    
CasingFinishCode  =  Casing Finish Code    
CasingSealingMethodCode  =  Method of Sealing Casing Code    
YieldTestMethodCode  =  Yield Test Method Code    
WellDevelopmentCode  =  Well Development Code    
NotSteelCasing  =  Not Steel Casing (if field is 1, it is true)    
OverFlowing  =  Well is OverFlowing (if field is 1, it is true)    
WaterAnalysis  =  Has Water been Analyzed (if field is 1, it is true)    
WellScreen  =  Well Has Screen (if field is 1, it is true)    
AWPartial  =  No Report Filed by A&W. Data from their partial files.    
UniqueGISName  =  Unique Location Name for GIS    
LatDegree  =  Latitude Degree    
LatMinutes  =  Latitude Minutes    
LatSeconds  =  Latitude Seconds    
LongDegree  =  Longitude Degree:    
LongMinutes  =  Longitude Minutes:    
LongSeconds  =  Longitude Seconds:    
LocationDeterminationMethod  =  Location Determination Method Code    
E911Address  =  E-911 Address    
WellType  =  Well Type Code    
CasingLengthExposed  =  Casing Length Exposed    
DepthToLinerTop  =  Depth To Liner Top    
HydroFractured  =  Hydro Fractured (if field is 1, answer is true)    
HydroFracturedResultingFlow  =  Hydro Fractured Resulting Flow (GPM)    
DOE  =  date of entry of record    
UOE  =  user who entered record    changed to 20 characters on 09/16/2003 for RN 826
DOC  =  date of last change of record    
UOC  =  user of last change of record    changed to 20 characters on 09/16/2003 for RN 826
WellLocationSubmittedAsADotOnAMap  =      
SealType  =      
YieldTestTestedForHours  =      
RecordNumber  =      

Related Files and Return To Hyperlinks
 Rolodex To Relate information between files, find records where DrillerLicenseNumber here = WellDrillerID there
 VCasingFinishCode To Relate information between files, find records where CasingFinishCode here = CasingFinishCode there
 VCasingMaterial To Relate information between files, find records where CasingMaterial here = CasingMaterialCode there
 VCasingSealingCode To Relate information between files, find records where CasingSealingMethodCode here = CasingSealingMethodCode there
 VDrillingMethodCode To Relate information between files, find records where DrillingMethodCode here = DrillingMethodCode there
 VGravelSizeType To Relate information between files, find records where GravelSizeType here = GravelSizeTypeCode there
 VGroutType To Relate information between files, find records where GroutType here = GroutTypeCode there
 VLatLongDetermination To Relate information between files, find records where LocationDeterminationMethod here = Code there
 VLinerMaterial To Relate information between files, find records where LinerMaterial here = LinerMaterialCode there
 VScreenMakeType To Relate information between files, find records where ScreenMakeType here = ScreenMakeTypeCode there
 VScreenMaterial To Relate information between files, find records where ScreenMaterial here = ScreenMaterialCode there
 VWellDevelopmentCode To Relate information between files, find records where WellDevelopmentCode here = WellDevelopmentCode there
 VWellReasonCode To Relate information between files, find records where WellReasonCode here = WellReasonCode there
 VWellUseCode To Relate information between files, find records where WellUseCode here = WellUseCode there
 VYieldTestMethodCode To Relate information between files, find records where YieldTestMethodCode here = YieldTestMethodCode there
 WellLithology To Relate information between files, find records where Town here = Town there and WellReportNumber here = WellReportNumber there
 WellTownCodes To Relate information between files, find records where TownName here = Town there

 Return To Index
 Return To Compact List of All Files/All Variables