Description

more
A gravity main is a type of main line that is unpressurized and relies on gravity to move the water through the main.

Dataset Attributes

  • OBJECTID
    Number
  • AssetID
    Text
    {"value"=>"11018", "count"=>1} (), {"value"=>"11017", "count"=>1} (), {"value"=>"11016", "count"=>1} (), {"value"=>"11015", "count"=>1} (), {"value"=>"11014", "count"=>1} (), {"value"=>"11013", "count"=>1} (), {"value"=>"11012", "count"=>1} (), {"value"=>"11011", "count"=>1} (), {"value"=>"11010", "count"=>1} (), {"value"=>"11009", "count"=>1} ()
  • FacilityID
    Number
    5430 to 11239
  • LegacyID
    Text
  • LifeCycleStatus
    Text
    {"value"=>"Active", "count"=>5733, "code"=>"ACT"} (), {"value"=>"Proposed", "count"=>2, "code"=>"PRP"} (), {"value"=>"Abandoned", "count"=>2, "code"=>"ABN"} (), {"value"=>"Removed", "count"=>1, "code"=>"RMV"} ()
  • SubType
    Number
    1 to 12
  • Enabled
    Number
    {"value"=>"True", "count"=>5738, "code"=>1} ()
  • AdministrativeArea
    Text
  • Owner of the Asset
    Number
    {"value"=>"CPG", "count"=>5723, "code"=>1} (), {"value"=>"Private", "count"=>8, "code"=>-2} ()
  • Manager of the Asset
    Number
    {"value"=>"Utilities", "count"=>5723, "code"=>21} (), {"value"=>"Private", "count"=>8, "code"=>-2} ()
  • Location
    Text
    {"value"=>"5354 Shellburn Rd", "count"=>4} (), {"value"=>"6267 Monterey Rd", "count"=>3} (), {"value"=>"8499 Domagala Rd", "count"=>3} (), {"value"=>"3330 22nd Ave", "count"=>3} (), {"value"=>"5531 Hartway Dr", "count"=>2} (), {"value"=>"4089 1st Ave", "count"=>2} (), {"value"=>"1198 Victoria St", "count"=>2} (), {"value"=>"7141 Dagg Rd", "count"=>2} (), {"value"=>"1547 Irwin St", "count"=>2} (), {"value"=>"499 North Nechako Rd", "count"=>2} ()
  • InstallDate
    Date
    -441849600000 to 1538611200000
  • OperationalArea
    Text
    {"value"=>"Oth", "count"=>1, "code"=>"Oth"} ()
  • SubBasin
    Text
  • WarrantyDate
    Date
  • RecordedLength
    Number
  • InstallContractor
    Text
    {"value"=>"L&M Engineering", "count"=>52} (), {"value"=>"L&M Engineering Ltd", "count"=>12} (), {"value"=>"L&M", "count"=>7} (), {"value"=>"L&M Enginnering LTD", "count"=>7} (), {"value"=>"OPUS DaytonKnight", "count"=>5} (), {"value"=>"McElhanney", "count"=>4} (), {"value"=>"Radloff", "count"=>4} (), {"value"=>"L&M Engineering Limited", "count"=>2} (), {"value"=>"IDL", "count"=>1} (), {"value"=>"Opus", "count"=>1} ()
  • PrimaryImage
    Text
  • Material
    Text
    {"value"=>"Poly Vinyl Chloride", "count"=>2865, "code"=>"PVC"} (), {"value"=>"Concrete", "count"=>1195, "code"=>"CON"} (), {"value"=>"Asbestos Concrete", "count"=>1136, "code"=>"AC"} (), {"value"=>"Vitrified Clay", "count"=>466, "code"=>"VIT"} (), {"value"=>"Ductile Iron", "count"=>52, "code"=>"DI"} (), {"value"=>"Polyethylene", "count"=>6, "code"=>"PE"} (), {"value"=>"Steel", "count"=>5, "code"=>"ST"} (), {"value"=>"Unknown", "count"=>5, "code"=>"UNK"} (), {"value"=>"Asbestos Cement", "count"=>3, "code"=>"Asbestos Cement"} (), {"value"=>"Corrugated Metal Pipe", "count"=>1, "code"=>"CMP"} ()
  • GroundType
    Text
    {"value"=>"Asphalt", "count"=>30, "code"=>"A"} ()
  • ExteriorCoating
    Text
  • JointType1
    Text
    {"value"=>"Unk", "count"=>5523, "code"=>"Unk"} ()
  • JointType2
    Text
    {"value"=>"Unk", "count"=>5523, "code"=>"Unk"} ()
  • LiningType
    Text
    {"value"=>"CIPP", "count"=>21, "code"=>"CIPP"} (), {"value"=>"Other", "count"=>15, "code"=>"OTH"} (), {"value"=>"Fiberglass", "count"=>15, "code"=>"Fiberglass"} ()
  • PipeClass
    Text
  • Roughness
    Number
    0 to 0
  • Name
    Text
  • CrossSectionShape
    Text
    {"value"=>"Circular", "count"=>5522, "code"=>"Circular"} (), {"value"=>"Round", "count"=>1, "code"=>"RND"} ()
  • WidthTop
    Number
  • UpstreamInvert
    Number
    0 to 1969.62
  • DownstreamInvert
    Number
    0 to 611363
  • Measurement1
    Number
  • Measurement2
    Number
  • NominalSize
    Number
    {"value"=>"200 mm", "count"=>4176, "code"=>200} (), {"value"=>"250 mm", "count"=>394, "code"=>250} (), {"value"=>"300 mm", "count"=>336, "code"=>300} (), {"value"=>"150 mm", "count"=>210, "code"=>150} (), {"value"=>"600 mm", "count"=>140, "code"=>600} (), {"value"=>"525 mm", "count"=>129, "code"=>525} (), {"value"=>"750 mm", "count"=>86, "code"=>750} (), {"value"=>"450 mm", "count"=>78, "code"=>450} (), {"value"=>"375 mm", "count"=>72, "code"=>375} (), {"value"=>"400 mm", "count"=>36, "code"=>400} ()
  • Slope
    Number
    0 to 48.2
  • DepthUpstream
    Number
    1.2 to 722.5
  • DepthDownstream
    Number
    1.2 to 722
  • DesignFlow
    Number
  • HiLowPointElevation
    Number
  • BarrelCount
    Number
  • StructuralSupport
    Text
  • ConditionDate
    Date
    1452556800000 to 1544449948000
  • AcquisitionCost
    Number
  • DeprecationMethod
    Text
  • ExpectedLife
    Number
  • ResidualValue
    Number
  • created_user
    Text
    {"value"=>"SATHERTON", "count"=>115} (), {"value"=>"LMCKERSIE", "count"=>73} (), {"value"=>"MLEMORVAN", "count"=>42} (), {"value"=>"GMULLIGAN", "count"=>5} ()
  • created_date
    Date
    1396547718000 to 1544573332000
  • last_edited_user
    Text
    {"value"=>"GISADMIN", "count"=>2838} (), {"value"=>" ", "count"=>2408} (), {"value"=>"LMCKERSIE", "count"=>230} (), {"value"=>"SATHERTON", "count"=>140} (), {"value"=>"MLEMORVAN", "count"=>96} (), {"value"=>"CTELFORD", "count"=>26} ()
  • last_edited_date
    Date
    1407371524000 to 1544605380000
  • SubType_TEXT
    Text
    {"value"=>"sanCollector", "count"=>4677} (), {"value"=>"sanTrunk", "count"=>1009} (), {"value"=>"sanInvertedSiphon", "count"=>15} (), {"value"=>"sanOutfall", "count"=>6} ()
  • Condition
    Number
    0 to 0
  • CoFScore
    Number
  • CoFDate
    Date
  • RiskScore
    Number
  • Link
    Text
  • DF
    Text
  • Shape__Length
    Number
    1.35972662685272 to 732.883142485635

Related Datasets