Description

more
Lift stations, also called pumping stations, contain pumps, valves, and electrical equipment necessary to move liquids (usually water, wastewater, or sewage) from low to high elevation. They may be used to overcome inadequate head, to provide easy-to-install pumping solutions, or to provide economic alternatives to other pumping options

Dataset Attributes

  • OBJECTID
    Number
  • AssetID
    Text
    {"value"=>"9", "count"=>1} (), {"value"=>"8", "count"=>1} (), {"value"=>"7", "count"=>1} (), {"value"=>"6", "count"=>1} (), {"value"=>"5", "count"=>1} (), {"value"=>"46", "count"=>1} (), {"value"=>"45", "count"=>1} (), {"value"=>"42", "count"=>1} (), {"value"=>"40", "count"=>1} (), {"value"=>"4", "count"=>1} ()
  • LegacyID
    Text
  • LifeCycleStatus
    Text
    {"value"=>"Active", "count"=>32, "code"=>"ACT"} (), {"value"=>"Removed", "count"=>3, "code"=>"RMV"} ()
  • SubType
    Number
    1 to 1
  • AncillaryRole
    Number
  • Enabled
    Number
    {"value"=>"True", "count"=>34, "code"=>1} ()
  • AdministrativeArea
    Text
  • Owner of the Asset
    Number
    {"value"=>"CPG", "count"=>33, "code"=>1} (), {"value"=>"Private", "count"=>2, "code"=>-2} ()
  • Manager of the Asset
    Number
    {"value"=>"Utilities", "count"=>33, "code"=>21} (), {"value"=>"Private", "count"=>2, "code"=>-2} ()
  • Location
    Text
    {"value"=>"Recreation Ave", "count"=>1} (), {"value"=>"Malaspina Ave (Fraser River Benchlands)", "count"=>1} (), {"value"=>"End of Mackus Rd", "count"=>1} (), {"value"=>"East End of 4th Ave", "count"=>1} (), {"value"=>"Bowser Ave", "count"=>1} (), {"value"=>"9919 Milwaukee Way", "count"=>1} (), {"value"=>"960 Ospika Blvd", "count"=>1} (), {"value"=>"9163 Twinberry Dr", "count"=>1} (), {"value"=>"8377 Hwy 16", "count"=>1} (), {"value"=>"7th Ave and Dominion St", "count"=>1} ()
  • InstallDate
    Date
    -378691200000 to 1318809600000
  • OperationalArea
    Text
  • SubBasin
    Text
  • Rotation
    Number
    0 to 0
  • WarrantyDate
    Date
  • InstallContractor
    Text
  • WaterType
    Text
    {"value"=>"Sanitary", "count"=>35, "code"=>"Sanitary"} ()
  • PrimaryImage
    Text
  • Name
    Text
    {"value"=>"PW133", "count"=>1} (), {"value"=>"PW132", "count"=>1} (), {"value"=>"PW129", "count"=>1} (), {"value"=>"PW128", "count"=>1} (), {"value"=>"PW127", "count"=>1} (), {"value"=>"PW126", "count"=>1} (), {"value"=>"PW125", "count"=>1} (), {"value"=>"PW124", "count"=>1} (), {"value"=>"PW123", "count"=>1} (), {"value"=>"PW122", "count"=>1} ()
  • OperationalDate
    Date
  • Source
    Text
  • SewerStructureOID
    Number
  • Capacity
    Number
  • MaintenanceContractor
    Text
  • AutoLevelController
    Number
  • OverflowAlarm
    Number
  • ElevationAtBottom
    Number
  • LevelSensorType
    Text
  • Modem
    Number
  • AverageFlow
    Number
  • PeakFlow
    Number
  • WetWellCapacity
    Number
  • WetWellRimElevation
    Number
  • WetWellBarScreen
    Number
  • WetWellRingMaterial
    Text
  • WetWellFrameMaterial
    Text
  • WetWellDepth
    Number
  • WetWellMaterial
    Text
  • WetWellStepMaterial
    Text
  • WetWellAccessType
    Text
  • WetWellAccessMaterial
    Text
  • WetWellAccessDiameter
    Number
  • WetWellLiner
    Text
  • ConditionDate
    Date
  • AcquisitionCost
    Number
  • DeprecationMethod
    Text
  • ExpectedLife
    Number
  • ResidualValue
    Number
  • created_user
    Text
  • created_date
    Date
  • last_edited_user
    Text
    {"value"=>"MLEMORVAN", "count"=>34} (), {"value"=>"LMCKERSIE", "count"=>1} ()
  • last_edited_date
    Date
    1417125991000 to 1527032165000
  • SubType_TEXT
    Text
    {"value"=>"sanPumpStation", "count"=>35} ()
  • Condition
    Number
  • CoFScore
    Number
  • CoFDate
    Date
  • RiskScore
    Number
  • Link
    Text
  • DF
    Text

Related Datasets