Fields in File for SOURCES

SOURCES file from Water Supply Inventory

Number of Records In File: 3727
Number of Data Fields In File: 92

Data That Is Stored Within This File
WSID  =  Water System Identification Number
SourceNumber  =  Source Identification Number
SourceName  =  Source Name
SourceOtherName  =  Other Name for the Source
EPASourceType  =  EPA Source Type
HasSourceBeenConnectedInViolationOfWSRule  =
LatDegree  =  Latitude of Source (degrees)
LatMinutes  =  Latitude of Source (minutes)
LatSeconds  =  Latitude of Source (seconds)
LongDegree  =  Longitude of Source (degrees)
LongMinutes  =  Longitude of Source (minutes)
LongSeconds  =  Longitude of Source (seconds)
LatLongDetMethod  =  Latitude-Longitude Determination Method Code
LatLongDetDate  =  Latitude-Longitude Determination Date
GWUDIStatus  =  GWUDI Status Code
GWUDIDeterminationLetterSent  =  GWUDI Determination Letter Sent
WHPA_SPAStatus  =  Well Head Protection Area, Source Protection Area Status (1=Delineated area,2=default area,3=unknown)
AverageDailyYield  =  Average Daily Yield (gallons per day)
MaximumDailyYield  =  Maximum Daily Yield (gallons per minute)
AverageYieldBasisCode  =  Average Yield Basis Code
MaxYieldBasisCode  =  Maximum Yield Basis Code
SourceMetered  =  Source Metered (Y=Individually,C=with other sources,N=not metered)
CorrosionControl  =  old field. should be removed
DisinfectionContactTimeGT20minutes  =  Disinfection Contact Time greater than 20 minutes
VTSourceType  =  Vermont Source Type
GW_w_SWContam  =  GW, could there be SW contamination?
RecordType  =  old field. should be deleted
SourceUse  =  Source Use Code
ComplianceStatus  =  old field. should be deleted
SellerID  =  WSID water is purchased from
SPPApprovedDate  =  Source Protection Plan Approved Date
SourceProtectionAreaActivitiesReport  =  Source Protection Area Activities Report Submitted
SourceProtectionPlanReceivedDate  =  Source Protection Plan Received Date
SourceProtectionPlanReviewer  =  Source Protection Plan Received
ANRWellReportNumber  =  ANR Well Report Number
ANRTagNumber  =  ANR Well Tag Number
SourceDiameter  =  Source Diameter
SourceDepth  =  Source Depth
CasingLength  =  Casing Length
CasingSpringBoxType  =  Casing Spring Box Type (1=steel,2=concrete,3=galvanized,4=aluminum,5=plastic,6=stone/block/fieldstone,7=wood,8=welltiles,9=other)
YearConstructed  =  YearConstructed
YearofRepairConstr  =  Year of Repair/Construction
DescriptionofRepairConstr  =  Description of Repair Construction
CleaningRedevelopedDate  =  Cleaning Redeveloped Date
Grouted  =  Grouted (Y,N,U=Unknown)
SourceCoverCapAdequate  =  Source Cover/Cap Adequate (Y,N,NA)
ScreenMeetsStandards  =  Screened vent meets Standards (Y,N,NA)
DrainageDitches  =  Site Drainage and Diversion Ditches OK (Y,N,NA)
ScreenOverflows  =  Screened overflows okay (Y,N,NA)
SurfaceWaterIntakeStructureAdequate  =  Surface Water Intake Structure Adequate (Y,N,NA)
StaticWaterLevel  =  Static Water Level
SourcePumpDepth  =  Source Pump Depth
SourcePumpControls  =  Source Pump Controls (1=timeclock,2=manual,3=probe,4=Pressure Guage,5=other)
SourceCapacity  =  Source pump or gravity pipe capacity (GPM)
StandbyPower  =  Standby Power Available (Y,N,NA)
SourceSecurityAdequate  =  Source Security Adequate (Y,N,NA)
TestedFailedWillBeReconstructedTested  =  If Source Tested Failed, Will Source Be Reconstructed Tested (Y,N,NA)
SystemAppliedForAvoidanceOfFiltration  =  Has System Applied For Avoidance Of Filtration for this source (Y,N,NA)
HasAvoidanceOfFiltrationWaiverBeenGranted  =  Has Avoidance Of Filtration Waiver Been Granted (Y,N,NA)
HasAvoidanceOfFiltrationWaiverBeenDenied  =  Has Avoidance Of Filtration Waiver Been Denied (Y,N,NA)
DoesDisinfectionContactTimemeetSWTRForSWGWUDI  =  Does Disinfection Contact Timemeet SWTRF or SWGWUDI (Y,N,NA)
TreatmentRequiredForIron  =  Treatment Required For Iron (Y,N,NA)
TreatmentRequiredForMaganese  =  Treatment Required For Maganese (Y,N,NA)
InComplianceForIronMaganeseTreatment  =  In Compliance For Iron Maganese Treatment (Y,N,NA)
IsContinuousChlorinationRequired  =  Is Continuous Chlorination Required (Y,N,NA)
IsCorrosionControlRequired  =  Is Corrosion Control Required (Y,N,NA)
HasCorrosionControlBeenOptimized  =  Has Corrosion Control Been Optimized (Y,N,NA)
InComplianceWiththeSWTRFiltrationRequirements  =  In Compliance Withthe SWTR Filtration Requirements (Y,N,NA)
InComplianceWithMonitoringForAvoidanceOfFiltrationWater  =  In Compliance With Monitoring For Avoidance Of Filtration Water (Y,N,NA)
IsChemicalSpillContainmentAdequate  =  Is Chemical Spill Containment Adequate (Y,N,NA)
IsAppropriateSafetyEquipmentAdequate  =  Is Appropriate Safety Equipment Adequate (Y,N,NA)
RequiredRadioChemTreatmentInCompliance  =  Required Radio Chem Treatment In Compliance (Y,N,NA)
RequiredFluoridationInCompliance  =  Required Fluoridation In Compliance (Y,N,NA)
RequiredVOCTreatmentInCompliance  =  Required VOC Treatment In Compliance(Y,N,NA)
IsolationZoneSize  =  Isolation Zone Size
IsolationZoneCompromised  =  Isolation Zone Compromised (community systems) (Y,N,NA)
IsolationZoneControl  =  Isolation Zone Control (community systems) (Y,N,NA)
VOCsWithin200feet  =  VOCs stored, used or transported within 200 feet
Viruses200feet  =  Viruses (wastewater stored, transported or treated within 200 feet)
Pestacides200feet  =  Pestacides/herbicides stored, transported, used within 200 feet
DateSourceApproved  =  Date Source Approved
YieldApprovedForSource  =  Yield Approved For Source (GPM)
RequiredTreatmentForArsenicIsInCompliance  =  Required Treatment For Arsenic Is In Compliance (Y,N,NA)
DOE  =  Date of Entry
UOE  =  User of Entry
DOC  =  Date of Change
UOC  =  User of Change
RecordNumber  =  Record Number
BasinNumber  =  Basin Number
WellDrillerReportUniqueGISName  =  Unique GIS Name of the Well Driller report that list information for the well that is this source
SeasonalDisinfection  =  Does this Source get Disinfected Seasonally?
WSIDSN  =

Related Files and Return To Hyperlinks
INVENTRY To Relate information between files, find records where WSID here = WSID there
SourceFilterMedia To Relate information between files, find records where WSID here = WSID there and SourceNumber here = SourceNumber there
SourceProtectionPlanUpdate To Relate information between files, find records where WSID here = WSID there and SourceNumber here = SourceNumber there
SourceTNCGWUDI To Relate information between files, find records where RecordNumber here = SourcesID there
SourceTreatments To Relate information between files, find records where WSID here = WSID there and SourceNumber here = SourceNumber there
SurveyContamination To Relate information between files, find records where WSID here = WSID there and SourceNumber here = SourceNumber there
VBasins To Relate information between files, find records where BasinNumber here = BasinNumber there
VEPASourceType To Relate information between files, find records where EPASourceType here = SourceTypeCode there
VGWUDIStatus To Relate information between files, find records where GWUDIStatus here = GWUDIStatusCode there
VSourceUse To Relate information between files, find records where SourceUse here = SourceUseCode there
VVtSourceType To Relate information between files, find records where VTSourceType here = SourceTypeCode there

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