SurveyPump file from Water Supply Inventory
Number of Records In File: 705
Number of Data Fields In File: 29
Data That Is Stored Within This File
GeneralConditionDescription  =  General Condition Description   
WSID  =  Water Supply Identification Number   
PumpStationName  =  Pump Station Name   
PumpStationNumber  =  Pump Station Number   
YearBuilt  =  Year Built   
Purpose  =  Purpose (g=to gravity storage,d=to distribution system,GD=both)   
NumberServiceConnections  =  Number of Service Connections   
IncomingPressure  =  Incoming Pressure (PSI)   
LowOutGoingPressure  =  Low Out Going Pressure (PSI)   
HighOutGoingPressure  =  High Out Going Pressure (PSI)   
StandbyPower  =  Standby Power Available (Y,N,NA)   
StandbyPowerRequired  =  StandBy Power Required (Y,N,NA)   
PumpStationCapacity  =  Pump Station Capacity (GPM)   
NumberofPumps  =  Number of Pumps   
DualPumpsAvailableAndOnLine  =  Dual Pumps Available And On Line (Y,N,NA)   
TotalTankVolume  =  Total Tank Volume   
NumberofTanks  =  Number of Tanks (per station)   
AirVolumeControlType  =  Air Volume Control Type (1=bladder tank,2=air compressor,3=manual,4=none)   
PressureGaugeAvailable  =  Pressure Guage Available (Y,N,NA)   
SecurityOkay  =  Security OK (Y,N,NA)   
GeneralCondition  =  Pump station and equipment general condition (1= good,2=adequate,3=repair needed)   
DOE  =  Date of Entry of Record   
UOE  =  User of Entry of Record   
DOC  =  Date of Change of Record   
UOC  =  User of Change of Record   
DosHydropneumaticTankFloatOnSystem  =  Dos Hydropneumatic Tank Float On System (Y,N,NA)   
PumpStationType  =  Pump Station Type (BP=booster pump station,HP=Hydropneumatic,BO=both)   
IsPressureControlVesselInGoodWorkingOrder  =  Is Pressure Control Vessel In Good Working Order (Y/N)   
RecordNumber  =  Record Number   
Related Files and Return To Hyperlinks
Return To Index
Return To Compact List of All Files/All Variables