Description

more
Sewer - Mains

Dataset Attributes

  • Object Id
    Number
  • SEWERID
    Number
  • ASSETID
    Text
    {"value"=>" ", "count"=>330} (), {"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"=>20549, "code"=>"SI"} (), {"value"=>"Honouliuli", "count"=>18565, "code"=>"HN"} (), {"value"=>"Kailua", "count"=>7339, "code"=>"KK"} (), {"value"=>"Waianae", "count"=>2326, "code"=>"WN"} (), {"value"=>"Wahiawa", "count"=>1375, "code"=>"WH"} (), {"value"=>"Waimanalo", "count"=>481, "code"=>"WM"} (), {"value"=>"Hawaii Kai", "count"=>264, "code"=>"HK"} (), {"value"=>"Kahuku", "count"=>169, "code"=>"KH"} (), {"value"=>"Laie", "count"=>105, "code"=>"LA"} (), {"value"=>"Paalaa Kai", "count"=>88, "code"=>"PK"} ()
  • STATUS
    Text
    {"value"=>"Active", "count"=>51194, "code"=>"ACT"} (), {"value"=>"Inactive", "count"=>67, "code"=>"INAC"} ()
  • OWNER
    Text
    {"value"=>"City & County of Honolulu", "count"=>46422, "code"=>"CITY"} (), {"value"=>"Private", "count"=>2169, "code"=>"PVT"} (), {"value"=>"Pending Dedication to City & County of Honolulu", "count"=>1317, "code"=>"PDCC"} (), {"value"=>"Hawaiian Home Land", "count"=>1035, "code"=>"HHL"} (), {"value"=>"Military", "count"=>233, "code"=>"MIL"} (), {"value"=>"Licensed for City Maintenance", "count"=>85, "code"=>"LIC"} ()
  • Material
    Text
    {"value"=>"Vitrified Clay Pipe", "count"=>38042, "code"=>"VCP"} (), {"value"=>"Terra Cotta Pipe", "count"=>4357, "code"=>"TCP"} (), {"value"=>"Polyvinyl Chloride Pipe", "count"=>3839, "code"=>"PVC"} (), {"value"=>"Reinforced Concrete Pipe", "count"=>2324, "code"=>"RCP"} (), {"value"=>"CAS", "count"=>925, "code"=>"CAS"} (), {"value"=>"Unknown", "count"=>760, "code"=>"UNK"} (), {"value"=>"FRPM", "count"=>204, "code"=>"FRPM"} (), {"value"=>"High Density Polyethylene", "count"=>192, "code"=>"HDPE"} (), {"value"=>" ", "count"=>181, "code"=>" "} (), {"value"=>"Ductile Iron Pipe", "count"=>167, "code"=>"DIP"} ()
  • Date Built
    Date
    -2288044800000 to 1519171200000
  • 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"=>44583, "code"=>"ABV"} (), {"value"=>"Below Groundwater", "count"=>6421, "code"=>"BLW"} (), {"value"=>" ", "count"=>214, "code"=>" "} ()
  • PIPESHAPE
    Text
    {"value"=>"Circular", "count"=>51197, "code"=>"CIRC"} (), {"value"=>"Rectangular", "count"=>64, "code"=>"RECT"} ()
  • REHAB
    Text
    {"value"=>"None", "count"=>46557, "code"=>"NONE"} (), {"value"=>"Cured In Place Pipe", "count"=>4156, "code"=>"CIPP"} (), {"value"=>"Spot Repair", "count"=>452, "code"=>"SPOT"} (), {"value"=>"Spiral Wound", "count"=>50, "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"=>"Waipahu", "count"=>3594} (), {"value"=>"Makakilo-Kapolei-Honokai Hale", "count"=>3270} (), {"value"=>"Kailua", "count"=>3266} (), {"value"=>"Kaneohe", "count"=>3224} (), {"value"=>"Aiea", "count"=>3025} (), {"value"=>"Ewa", "count"=>2951} (), {"value"=>"Pearl City", "count"=>2316} (), {"value"=>"Kuliouou-Kalani Iki", "count"=>2185} (), {"value"=>"Mililani-Waipio-Melemanu", "count"=>1878} (), {"value"=>"Manoa", "count"=>1842} ()
  • DIAMETER
    Number
    0 to 84
  • YR_REHAB
    Date
    355363200000 to 33013699200000
  • shape
    Number
  • UPSTRMID
    Number
  • DOWNSTRMID
    Number
  • CONFIDENCE
    Text
    {"value"=>"As-Built - Inspector Copy", "count"=>1071, "code"=>"REC"} (), {"value"=>"Design Plans", "count"=>360, "code"=>"DES"} (), {"value"=>"Field Verified", "count"=>26, "code"=>"FIELD"} (), {"value"=>"Other", "count"=>5, "code"=>"OTHER"} (), {"value"=>"WO", "count"=>5, "code"=>"WO"} (), {"value"=>"Calculated", "count"=>2, "code"=>"CALC"} ()
  • GLOBALID
    Number
  • SHAPE.STLength()
    Number

About

  • By on March 24, 2016
  • Updated about 1 month ago

Related Datasets