Asset_Class_and_Category_List.xlsx

XLSX spreadsheet 22 KB Posted

Attached to
Water Asset Condition Assessment Program Evaluation
Solicitation number
250129
Issued by
Pima County, Tucson City, Arizona

About this file

The file contains an Excel spreadsheet (Asset_Class_and_Category_List.xlsx) from the City of Tucson Water Department detailing a Water Asset Condition Assessment Program Evaluation for enterprise asset management. The project seeks a consultant to develop a comprehensive condition assessment program for water infrastructure assets, focusing on evaluating asset classes and categories, defining assessment survey questions, establishing equipment ranking in Hexagon EAM, and creating performance and condition scoring methodologies. The initiative aims to support Tucson Water's continuous improvement and operational asset reliability program, with specific objectives including a gap analysis of current EAM workflow documentation and full-scale implementation of an equipment ranking condition assessment program.

The project will support Tucson Water's strategic goals of advancing asset management practices to drive capital planning, failure analysis, and Reliability Centered Maintenance (RCM). The asset classes and categories span a wide range of infrastructure components, including motors, pumps, compressors, valves, generators, electrical systems, tanks, wells, piping, transformers, and various mechanical and structural assets. The Excel spreadsheet provides an extensive taxonomy of asset types across multiple categories, which will be crucial for developing a structured and comprehensive condition assessment approach. The consulting firm will need to work closely with Tucson Water to refine assessment methodologies, improve data quality, and establish a systematic approach to evaluating the condition and performance of the city's water infrastructure assets.

View the file

Other files

File Type Posted
Water_Asset_Condition_Assessment_Program_Evaluation.pdf PDF
Price_Proposal.xlsx XLSX spreadsheet
FTA_TERMS_AND_CONDITIONS.pdf PDF
COT_ARPA_Terms_and_Conditions.pdf PDF
Offer_and_Acceptance.pdf PDF
5369-B.PDF PDF

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Sheet1

TW Proof of Concept Asset Class & Categories
ClassDescriptionCategory DescriptionCategory DescriptionCategory DescriptionCategory DescriptionCategory DescriptionCategory Description
MOTORMOTORBOOSTER PUMP MOTORAIR COMPRESSOR MOTORVALVE ACTUATOR MOTORWELL PUMP MOTOR
PUMPPUMPSHORIZONTAL END SUCTION CENTRIFUGAL PUMPIN LINELINE SHAFT DRIVEN WELL PUMPSUBMERSIBLEVERTICAL TURBINE
WELLWELLMONITORINGPRODUCTIONREMEDIATION
Future Phases Asset Class & Categories
ClassDescriptionCategory DescriptionCategory DescriptionCategory DescriptionCategory DescriptionCategory DescriptionCategory Description
CMPRSSRCOMPRESSORAIR
DRIVEDRIVE UNIT (VFD OR SOFT START)SOFT STARTVFD
HYDROTNKHYDRO-PNEUMATIC TANKSDISCHSRGESUCTION
NPOTWELLNON-POTABLE WELLMONITORING NON-POTABLEPRODUCTION NON-POTABLEREMEDIATION NON-POTABLE
ACTUATORACTUATORELECTRICHYDRAULICPNUEMATICVAV_TU
BREAKERCIRCUIT BREAKERNONE IN EAM
CTHDCPRTCATHODIC PROTECTIONCORROSION CONTROL RECTIFIERCORROSION CONTROL REFERENCE ELECTRODECORROSION CONTROL REMOTE MONITORING UNITCORROSION CONTROL TEST STATIONCORROSION CONTROL TEST STATION WITH ANODE
ENDVALVEAIR RELEASEBLOWOFFDRAIN VALVE ASSEMBLY
ENGINEENGINENATURAL GAS
GEARHEADGEARBOXES AND GEARHEADSNONE IN EAM
MANHOLEMANHOLENONE IN EAM
MCCMOTOR CONTROL CENTERNONE IN EAM
NPOTBSTRNON-POTABLE BOOSTERNONE IN EAM
NPOTFVLVNON-POTABLE FLOW VALVESIZE SPECIFIC - NEED TO CATEGORIZE AS SUCH
NPOTSTFCNON-POTABLE STORAGE FACILITYNON-POTABLE PORTABLE TANKNON-POTABLE RESERVOIRNPOTStandpipeTankNON-POTABLE TANK
NPOTTRNVNON-POTABLE TRANSFER VALVENON-POTABLE FLOW CONTROLNON-POTABLE PRESSURE REDUCINGNON-POTABLE PRESSURE SUSTAINING
NPOTVLVNON-POTABLE END VALVENON-POTABLE AIR RELEASENON-POTABLE DRAIN VALVE ASSEMBLYNON-POTABLE BLOWOFFNPOT CHECK VALVE
PIPINGPIPING (EXCLUDING WATER MAINS AND WATER SERVICES)PIPING, ABOVE-GROUND
RESRVOIRRESERVOIRRESERVOIR, IN-GROUNDRESERVOIR, TANK, AT GROUND ELEVATION
TRNSFRMRTRANSFORMERSTATION SERVICE
TRNVTRANSFER VALVEFLOW CONTROLREDUCINGSUSTAININGNEEDS MORE CATEGORIES
UPSUPS (UNINTERRUPTIBLE POWER SUPPLY)NONE IN EAM
VALVEVALVESIZE SPECIFIC - NEED TO CATEGORIZE AS SUCH
VAULTVAULT (THESE HAVE GIS POINTS)NONE IN EAM
WTRMAINWATER MAINSNONE IN EAMSIZE SPECIFIC - NEED TO CATEGORIZE AS SUCH
WTRTANKWTRTANKNONE IN EAM
GENERATRGENERATORPORTABLESTATIONARY
METERMETERNEEDS MORE DISCUSSION…TONS OF CATEGORIES
NPOTMAINNON-POTABLE MAINSIZE SPECIFIC - NEED TO CATEGORIZE AS SUCH
PLCPLCNONE IN EAM
SWITCHSWITCHATSCONTROLDISCONNECT
TRNSDCERTRANSDUCERNONE IN EAM
*All classes
ACUAC UNIT
AHUAHU
AIRCRAFTAIRCRAFT
ANALYZERANALYZER
APPLNCEAPPLIANCE
AVEQPTA/V EQUIPMENT
AVIATIONAVIATION
BACKFLOWBACKFLOW PREVENTER ASSEMBLY
BADGEBADGE
BALERBALER
BASINBASIN
BATTERYBATTERIES
BLOWERBLOWER
BOILERBOILER
BUILDINGBUILDING
CAMPUSCAMPUS
CHILLERCHILLER
CISTERNCISTERN
CLNGTWRCOOLING TOWER
CNDUNITCONDENSING UNIT
COMPCTRCOMPACTOR (TRASH/RECYCLING)
COMPEQPTCOMPUTER EQUIPMENT
CONTAINRESD BINS/CONTAINERS
CRANECRANE (MOVES IN THREE DIMENSIONS)
DAMPERDAMPER
DISPATCHDISPATCH EQUIPMENT
DISPENSRDISPENSER
DOORDOOR
DRYERDRYER
DSNFCTNDISINFECTION
DYNMOMTRDYNAMOMETER (FTA)
ELEVATORELEVATOR
EMCSEMCS (ENERGY MANAGEMENT CONTROL SYSTEM)
ESAEnvironmental Site Assessment
EVAPBEDEVAPORATION BED
EVAPCLREVAPORATIVE COOLER
FANFAN
FENCEFENCE
FIBERFIBER OPTIC LINES
FILTERFILTER
FIREALRMFIRE ALARM
FIREALRTFIRE ALERT EQUIPMENT
FIRESPRNFIRE SUPPRESSION
FIRESRVCFIRE SERVICE
FIREXTNGFIRE EXTINGUISHER
FIRSTAIDFIRST AID
FITNESSHEALTH & FITNESS
FLOORINGFLOORING
FRNSHNGSFURNISHINGS
GASDTCTRGAS DETECTOR
GATEGATE (SLUICE & WEIR)
GATENTRYGATE (ENTRY)
GROUNDSGROUNDS
GSIGREEN STORMWATER INFRASTRUCTURE
HAZMATHAZMAT
HEATUNITHEATING UNIT
HEAVYEQHEAVY EQUIPMENT
HMIHMI
HOISTHOIST (LIFTS UP AND DOWN)
HYDRANTFIRE HYDRANT
INDUSTEQINDUSTRIAL EQUIPMENT
INLETINLET
INSTRMNTMUSICAL INSTRUMENT
IOCARDSCADA I/O CARDS
LANDFILLLANDFILL
LIFTLIFT
LIGHTINGLIGHTING FIXTURE
LUBRCTNLUBRICATION SYSTEM
MEDICALMEDICAL
MIXERMIXER
MWTEMOBILE WATER TREATMENT EQUIPMENT
NONARNON-ASSET
NPOTSRVNON-POTABLE SERVICE
NPOTSRVCNON-POTABLE SERVICE CONNECTION
NPTSRVLNNPOT SERVICE LINE
OPERATOROPERATOR
OUTLETOUTLET/OVERFLOW
OVERFLOWOVERFLOW STRUCTURE
PANELPANEL
PARKINGPARKING LOTS
PAVEMENTPAVEMENT
PLUMBINGPLUMBING FIXTURE
POWERSYSPOWER SYSTEMS
PPEPPE
PROBEPROBES
RADIORADIO
RADIOEQRADIO EQUIPMENT
RCVRYUNTRECOVERY UNIT
REELREEL (FTA)
RLPRPTYREAL PROPERTY
ROADSROADWAYS & DRIVEWAYS
ROBOTROBOT
ROOFROOF
SAFETYSAFETY
SAFETYEQSAFETY EQUIPMENT
SAMPLPNTWQ SAMPLE POINTS
SCALESCALE
SCRTYEQSECURITY EQUIPMENT
SEDMTRAPSEDIMENT TRAP
SENSORSENSORS
SERVICESERVICE
SIGNAGESIGNAGE
SLRARRAYSOLAR ARRAY
SLRNVRTRSOLAR INVERTER
SOLARPWRSOLAR POWER
SRVCANMLSERVICE ANIMAL
SRVCLINEWATER SERVICE LINE
STMCLNRSTEAM CLEANER (FTA)
STRAINERSTRAINERS
STRCTRSSTRUCTURES
SYSTEMSYSTEM, IRRIGATION
TABLETTABLET
TANKTANK
TELECMEQTELECOMMUNICATIONS EQUIPMENT
TESTEQTEST EQUIPMENT
TLMTRYUTTELEMETRY UNIT
TOWERTOWER
TRAININGTRAINING
TRNSMTTRTRANSMITTER
TRTTRT
TURNOUTTURNOUT
UASUAS
UNIFORMUNIFORM
USSUSS (UNIT SUBSTATION)
VACUUMVACUUM (FTA)
VEGNTREEVEGETATION, NON-TREE
VEGTREEVEGETATION, TREE
VEHICLESVEHICLES
VHCLELECVEHICLE ELECTRONICS
WEAPNSYSWEAPON SYSTEM
WINDOWWINDOW
WTRHEATRWATER HEATER
WTRSFTNRWATER SOFTENER (FTA)

File details come from the government source that posted it. Updated .