Description

more
A lateral line is a small-diameter pipe that runs from the main line to the customer premises. Sometimes referred to as a Service Connection

Dataset Attributes

  • OBJECTID
    Number
  • AssetID
    Text
    {"value"=>"10961", "count"=>1} (), {"value"=>"10960", "count"=>1} (), {"value"=>"1096", "count"=>1} (), {"value"=>"10959", "count"=>1} (), {"value"=>"10958", "count"=>1} (), {"value"=>"10957", "count"=>1} (), {"value"=>"10956", "count"=>1} (), {"value"=>"10955", "count"=>1} (), {"value"=>"10954", "count"=>1} (), {"value"=>"10953", "count"=>1} ()
  • FacilityID
    Number
    1 to 24369
  • LegacyID
    Text
  • LifeCycleStatus
    Text
    {"value"=>"Active", "count"=>20800, "code"=>"ACT"} (), {"value"=>"Abandoned", "count"=>32, "code"=>"ABN"} (), {"value"=>"Removed", "count"=>19, "code"=>"RMV"} (), {"value"=>"Proposed", "count"=>2, "code"=>"PRP"} ()
  • SubType
    Number
    1 to 5
  • Enabled
    Number
    {"value"=>"True", "count"=>20853, "code"=>1} ()
  • AdministrativeArea
    Text
  • Owner of the Asset
    Number
    {"value"=>"CPG", "count"=>20835, "code"=>1} (), {"value"=>"Private", "count"=>5, "code"=>-2} ()
  • Manager of the Asset
    Number
    {"value"=>"Utilities", "count"=>20835, "code"=>21} (), {"value"=>"Private", "count"=>5, "code"=>-2} ()
  • ParcelID
    Text
  • Location
    Text
    {"value"=>"1151 Commercial Cres", "count"=>5} (), {"value"=>"1144 4th Ave", "count"=>5} (), {"value"=>"1251 1st Ave", "count"=>4} (), {"value"=>"1141 4th Ave", "count"=>4} (), {"value"=>"1117 Limestone Cres", "count"=>4} (), {"value"=>"1277 Babine Cres", "count"=>3} (), {"value"=>"1247 1st Ave", "count"=>3} (), {"value"=>"1227 Elkhorn Cres", "count"=>3} (), {"value"=>"121 McDougal Pl", "count"=>3} (), {"value"=>"1199 Jarvis St", "count"=>3} ()
  • InstallDate
    Date
    -473385600000 to 1538352000000
  • OperationalArea
    Text
  • SubBasin
    Text
  • WarrantyDate
    Date
  • RecordedLength
    Number
    31.3 to 33.56
  • InstallContractor
    Text
    {"value"=>"L&M Engineering", "count"=>237} (), {"value"=>"L&M Engineering Ltd", "count"=>64} (), {"value"=>"McElhanney", "count"=>7} (), {"value"=>"L&M Engineering Limited", "count"=>6} (), {"value"=>"L&M Enginnering LTD", "count"=>5} (), {"value"=>"Radloff", "count"=>5} (), {"value"=>"Western Industrial", "count"=>2} (), {"value"=>"IDL", "count"=>2} ()
  • PrimaryImage
    Text
  • Material
    Text
    {"value"=>"Poly Vinyl Chloride", "count"=>1693, "code"=>"PVC"} (), {"value"=>"Asbestos Concrete", "count"=>393, "code"=>"AC"} (), {"value"=>"Unknown", "count"=>19, "code"=>"UNK"} (), {"value"=>"Vitrified Clay", "count"=>5, "code"=>"VIT"} (), {"value"=>"Copper", "count"=>4, "code"=>"CU"} ()
  • Diameter
    Number
    {"value"=>"100 mm", "count"=>1995, "code"=>100} (), {"value"=>"150 mm", "count"=>94, "code"=>150} (), {"value"=>"200 mm", "count"=>37, "code"=>200} (), {"value"=>"30 mm", "count"=>11, "code"=>30} (), {"value"=>"20 mm", "count"=>9, "code"=>20} (), {"value"=>"40 mm", "count"=>5, "code"=>40} (), {"value"=>"300 mm", "count"=>3, "code"=>300} (), {"value"=>"250 mm", "count"=>3, "code"=>250} (), {"value"=>"50 mm", "count"=>1, "code"=>50} ()
  • GroundType
    Text
    {"value"=>"Asphalt", "count"=>106, "code"=>"A"} (), {"value"=>"Other", "count"=>1, "code"=>"OTH"} ()
  • ConnectionType
    Text
    {"value"=>"Tee", "count"=>6, "code"=>"TEE"} (), {"value"=>"Unknown", "count"=>1, "code"=>"UNK"} ()
  • CustomerType
    Text
  • Project
    Text
  • AccountNumber
    Text
  • DepthBuried
    Number
    1.24 to 4.89
  • BuildingNumber
    Text
  • Municipality
    Text
    {"value"=>"City of Prince George", "count"=>99, "code"=>"CPG"} ()
  • PostalCode
    Text
  • PositionAtMain
    Number
  • CriticalCustomer
    Number
  • ConditionDate
    Date
    1410184936000 to 1544430565000
  • AcquisitionCost
    Number
  • DeprecationMethod
    Text
    {"value"=>"lcc", "count"=>1} ()
  • ExpectedLife
    Number
  • ResidualValue
    Number
  • created_user
    Text
    {"value"=>"SATHERTON", "count"=>564} (), {"value"=>"LMCKERSIE", "count"=>234} (), {"value"=>"MLEMORVAN", "count"=>108} (), {"value"=>"GMULLIGAN", "count"=>28} ()
  • created_date
    Date
    1396549279000 to 1544573647000
  • last_edited_user
    Text
    {"value"=>"GISADMIN", "count"=>20168} (), {"value"=>"LMCKERSIE", "count"=>293} (), {"value"=>"SATHERTON", "count"=>174} (), {"value"=>"MLEMORVAN", "count"=>134} (), {"value"=>" ", "count"=>82} (), {"value"=>"GMULLIGAN", "count"=>2} ()
  • last_edited_date
    Date
    1407375174000 to 1544605388000
  • SubType_TEXT
    Text
    {"value"=>"sanDomestic", "count"=>19359} (), {"value"=>"sanCommercial", "count"=>726} (), {"value"=>"sanIndustrial", "count"=>668} (), {"value"=>"sanIrrigation", "count"=>1} ()
  • Condition
    Number
    0 to 0
  • CoFScore
    Number
  • CoFDate
    Date
  • RiskScore
    Number
  • Link
    Text
  • DF
    Text
  • Shape__Length
    Number
    0.00575543227001016 to 475.274136201636

Related Datasets