Description

more
Sewer - Mains

Dataset Attributes

  • Object Id
    Number
  • SEWERID
    Number
  • ASSETID
    Text
    {"value"=>" ", "count"=>331} (), {"value"=>"C-99914", "count"=>1} (), {"value"=>"C-99911", "count"=>1} (), {"value"=>"C-99508", "count"=>1} (), {"value"=>"C-99507", "count"=>1} (), {"value"=>"C-99506", "count"=>1} (), {"value"=>"C-99505", "count"=>1} (), {"value"=>"C-99491", "count"=>1} (), {"value"=>"C-99488", "count"=>1} (), {"value"=>"C-99480", "count"=>1} ()
  • BASINID
    Text
    {"value"=>"Sand Island", "count"=>20519, "code"=>"SI"} (), {"value"=>"Honouliuli", "count"=>18145, "code"=>"HN"} (), {"value"=>"Kailua", "count"=>7338, "code"=>"KK"} (), {"value"=>"Waianae", "count"=>2318, "code"=>"WN"} (), {"value"=>"Wahiawa", "count"=>1369, "code"=>"WH"} (), {"value"=>"Waimanalo", "count"=>481, "code"=>"WM"} (), {"value"=>"Hawaii Kai", "count"=>265, "code"=>"HK"} (), {"value"=>"Kahuku", "count"=>169, "code"=>"KH"} (), {"value"=>"Laie", "count"=>103, "code"=>"LA"} (), {"value"=>"Paalaa Kai", "count"=>88, "code"=>"PK"} ()
  • STATUS
    Text
    {"value"=>"Active", "count"=>50733, "code"=>"ACT"} (), {"value"=>"Inactive", "count"=>62, "code"=>"INAC"} ()
  • OWNER
    Text
    {"value"=>"City & County of Honolulu", "count"=>46062, "code"=>"CITY"} (), {"value"=>"Private", "count"=>2045, "code"=>"PVT"} (), {"value"=>"Pending Dedication to City & County of Honolulu", "count"=>1390, "code"=>"PDCC"} (), {"value"=>"Hawaiian Home Land", "count"=>980, "code"=>"HHL"} (), {"value"=>"Military", "count"=>233, "code"=>"MIL"} (), {"value"=>"Licensed for City Maintenance", "count"=>85, "code"=>"LIC"} ()
  • Material
    Text
    {"value"=>"Vitrified Clay Pipe", "count"=>37999, "code"=>"VCP"} (), {"value"=>"Terra Cotta Pipe", "count"=>4364, "code"=>"TCP"} (), {"value"=>"Polyvinyl Chloride Pipe", "count"=>3488, "code"=>"PVC"} (), {"value"=>"Reinforced Concrete Pipe", "count"=>2345, "code"=>"RCP"} (), {"value"=>"CAS", "count"=>925, "code"=>"CAS"} (), {"value"=>"Unknown", "count"=>712, "code"=>"UNK"} (), {"value"=>"High Density Polyethylene", "count"=>190, "code"=>"HDPE"} (), {"value"=>" ", "count"=>181, "code"=>" "} (), {"value"=>"FRPM", "count"=>168, "code"=>"FRPM"} (), {"value"=>"Ductile Iron Pipe", "count"=>159, "code"=>"DIP"} ()
  • Date Built
    Date
    -2288044800000 to 1503360000000
  • PIPELENGTH
    Number
    0 to 14600.68
  • SLOPE
    Number
    -71.87418 to 11.03
  • UPINVERT
    Number
    -39.76 to 1284.01
  • DOWNINVERT
    Number
    -240 to 5119.23
  • WATERTABLE
    Text
    {"value"=>"Above Groundwater", "count"=>44194, "code"=>"ABV"} (), {"value"=>"Below Groundwater", "count"=>6360, "code"=>"BLW"} (), {"value"=>" ", "count"=>221, "code"=>" "} ()
  • PIPESHAPE
    Text
    {"value"=>"Circular", "count"=>50733, "code"=>"CIRC"} (), {"value"=>"Rectangular", "count"=>62, "code"=>"RECT"} ()
  • REHAB
    Text
    {"value"=>"None", "count"=>46342, "code"=>"NONE"} (), {"value"=>"Cured In Place Pipe", "count"=>3918, "code"=>"CIPP"} (), {"value"=>"Spot Repair", "count"=>441, "code"=>"SPOT"} (), {"value"=>"Spiral Wound", "count"=>48, "code"=>"SW"} (), {"value"=>"Slip-lined", "count"=>31, "code"=>"SLIP"} (), {"value"=>"Unknown", "count"=>7, "code"=>"UNK"} (), {"value"=>"Fold & Form", "count"=>2, "code"=>"FF"} ()
  • HEIGHT
    Number
    0 to 7264
  • SewerMainSubtype
    Number
    1 to 7
  • NEIGHBORHOOD
    Text
    {"value"=>"KANEOHE", "count"=>3215} (), {"value"=>"PEARL CITY", "count"=>2994} (), {"value"=>"MILILANI", "count"=>2886} (), {"value"=>"KAILUA", "count"=>2799} (), {"value"=>"EWA", "count"=>2743} (), {"value"=>"WAIPAHU", "count"=>2658} (), {"value"=>"AIEA", "count"=>2374} (), {"value"=>"KAIMUKI", "count"=>1935} (), {"value"=>"MANOA", "count"=>1859} (), {"value"=>"KALIHI", "count"=>1758} ()
  • DIAMETER
    Number
    0 to 84
  • YR_REHAB
    Date
    355363200000 to 32930409600000
  • shape
    Number
  • UPSTRMID
    Number
  • DOWNSTRMID
    Number
  • CONFIDENCE
    Text
    {"value"=>"As-Built - Inspector Copy", "count"=>770, "code"=>"REC"} (), {"value"=>"Design Plans", "count"=>113, "code"=>"DES"} (), {"value"=>"Field Verified", "count"=>23, "code"=>"FIELD"} (), {"value"=>"WO", "count"=>5, "code"=>"WO"} (), {"value"=>"Other", "count"=>3, "code"=>"OTHER"} (), {"value"=>"Calculated", "count"=>2, "code"=>"CALC"} ()
  • GLOBALID
    Number
  • SHAPE.STLength()
    Number

About

Related Datasets