Description

more
The Fitting class represents the facility found at the joint between two lines where a transition of some sort must occur. In order to cut down on the number of network feature classes and improve geometric network performance, we have chosen to rely on subtypes here to differentiate the different types of fitting-related classes. Fitting types include Bend, Cap, Cross, Coupling, ExpansionJoint, Offset, Reducer, Riser, Saddle, Sleeve, Tap, Tee, Wye, and Weld

Dataset Attributes

  • OBJECTID
    Number
  • AssetID
    Text
    {"value"=>"99", "count"=>1} (), {"value"=>"98", "count"=>1} (), {"value"=>"96", "count"=>1} (), {"value"=>"92", "count"=>1} (), {"value"=>"91", "count"=>1} (), {"value"=>"9", "count"=>1} (), {"value"=>"89", "count"=>1} (), {"value"=>"88", "count"=>1} (), {"value"=>"87", "count"=>1} (), {"value"=>"86", "count"=>1} ()
  • LegacyID
    Text
  • LifeCycleStatus
    Text
    {"value"=>"Active", "count"=>231, "code"=>"ACT"} (), {"value"=>"Removed", "count"=>21, "code"=>"RMV"} (), {"value"=>"Proposed", "count"=>3, "code"=>"PRP"} ()
  • SubType
    Number
    1 to 13
  • AncillaryRole
    Number
  • Enabled
    Number
    {"value"=>"True", "count"=>255, "code"=>1} ()
  • AdministrativeArea
    Text
  • Owner of the Asset
    Number
    {"value"=>"CPG", "count"=>247, "code"=>1} (), {"value"=>"Private", "count"=>3, "code"=>-2} ()
  • Manager of the Asset
    Number
    {"value"=>"Utilities", "count"=>246, "code"=>21} (), {"value"=>"Private", "count"=>4, "code"=>-2} ()
  • Location
    Text
    {"value"=>"6116 Monterey Rd", "count"=>4} (), {"value"=>"7749 Malaspina Ave", "count"=>2} (), {"value"=>"648 Dominion St", "count"=>2} (), {"value"=>"5567 Hartway Dr", "count"=>2} (), {"value"=>"5531 Hartway Dr", "count"=>2} (), {"value"=>"5354 Shellburn Rd", "count"=>2} (), {"value"=>"490 Carney St", "count"=>2} (), {"value"=>"4100 Brink Pl", "count"=>2} (), {"value"=>"3739 Winslow Dr", "count"=>2} (), {"value"=>"3062 Recplace Dr", "count"=>2} ()
  • InstallDate
    Date
  • OperationalArea
    Text
  • SubBasin
    Text
  • Rotation
    Number
    -90 to 359.7857
  • WarrantyDate
    Date
  • InstallContractor
    Text
    {"value"=>"L&M Engineering", "count"=>33} (), {"value"=>"McElhanney", "count"=>3} (), {"value"=>"L&M Engineering Ltd", "count"=>2} (), {"value"=>"L&M Engineering Limited", "count"=>2} (), {"value"=>"Opus", "count"=>1} (), {"value"=>"CPG", "count"=>1} ()
  • WaterType
    Text
    {"value"=>"Sanitary", "count"=>177, "code"=>"Sanitary"} (), {"value"=>"Sewage", "count"=>33, "code"=>"Sewage"} (), {"value"=>"Unknown", "count"=>6, "code"=>"Unknown"} (), {"value"=>"Potable", "count"=>1, "code"=>"Potable"} ()
  • PrimaryImage
    Text
  • Elevation
    Number
    568.4 to 760.043
  • BelowGrade
    Number
  • Manufacturer
    Text
  • GroundType
    Text
    {"value"=>"Asphalt", "count"=>12, "code"=>"A"} (), {"value"=>"Dirt", "count"=>1, "code"=>"D"} ()
  • JointType1
    Text
  • JointType2
    Text
  • Material
    Text
    {"value"=>"Poly Vinyl Chloride", "count"=>36, "code"=>"PVC"} (), {"value"=>"Asbestos Concrete", "count"=>1, "code"=>"AC"} ()
  • Angle
    Number
    {"value"=>"11 1/4 Degree", "count"=>1, "code"=>11.25} ()
  • Diameter1
    Number
    {"value"=>"200 mm", "count"=>68, "code"=>200} (), {"value"=>"150 mm", "count"=>38, "code"=>150} (), {"value"=>"250 mm", "count"=>9, "code"=>250} (), {"value"=>"600 mm", "count"=>6, "code"=>600} (), {"value"=>"300 mm", "count"=>5, "code"=>300} (), {"value"=>"100 mm", "count"=>5, "code"=>100} (), {"value"=>"525 mm", "count"=>3, "code"=>525} (), {"value"=>"450 mm", "count"=>2, "code"=>450} (), {"value"=>"900 mm", "count"=>1, "code"=>900} (), {"value"=>"750 mm", "count"=>1, "code"=>750} ()
  • Diameter2
    Number
    {"value"=>"200 mm", "count"=>9, "code"=>200} (), {"value"=>"100 mm", "count"=>2, "code"=>100} (), {"value"=>"250 mm", "count"=>1, "code"=>250} (), {"value"=>"80 mm", "count"=>1, "code"=>80} (), {"value"=>"50 mm", "count"=>1, "code"=>50} ()
  • Diameter3
    Number
    {"value"=>"750 mm", "count"=>1, "code"=>750} (), {"value"=>"200 mm", "count"=>1, "code"=>200} ()
  • Diameter4
    Number
  • DepthBuried
    Number
    2.75 to 4
  • ConditionDate
    Date
  • AcquisitionCost
    Number
  • DeprecationMethod
    Text
  • ExpectedLife
    Number
  • ResidualValue
    Number
  • created_user
    Text
    {"value"=>"LMCKERSIE", "count"=>40} (), {"value"=>"SATHERTON", "count"=>19} (), {"value"=>"MLEMORVAN", "count"=>10} (), {"value"=>"GMULLIGAN", "count"=>1} ()
  • created_date
    Date
    1403890078000 to 1541717024000
  • last_edited_user
    Text
    {"value"=>"GISADMIN", "count"=>194} (), {"value"=>"LMCKERSIE", "count"=>30} (), {"value"=>"SATHERTON", "count"=>18} (), {"value"=>"MLEMORVAN", "count"=>12} (), {"value"=>"GMULLIGAN", "count"=>1} ()
  • last_edited_date
    Date
    1407377444000 to 1543008378000
  • SubType_TEXT
    Text
    {"value"=>"sanCap", "count"=>183} (), {"value"=>"sanCoupling", "count"=>24} (), {"value"=>"sanBend", "count"=>24} (), {"value"=>"sanWeld", "count"=>2} (), {"value"=>"sanTee", "count"=>2} (), {"value"=>"sanReducer", "count"=>1} ()
  • Condition
    Number
  • CoFScore
    Number
  • CoFDate
    Date
  • RiskScore
    Number
  • Link
    Text
  • DF
    Text

Related Datasets