Description

more
Pipe segments running from the sewer main to the residential connection point.

Dataset Attributes

  • OBJECTID
    Number
  • ENABLED
    Number
    {"value"=>"True", "count"=>156781, "code"=>1} ()
  • SEWERID
    Number
  • ASSETID
    Text
    {"value"=>" ", "count"=>63} (), {"value"=>"C-2035740", "count"=>2} (), {"value"=>"C-2035739", "count"=>2} (), {"value"=>"C-2035495", "count"=>2} (), {"value"=>"C-2035494", "count"=>2} (), {"value"=>"C-99918", "count"=>1} (), {"value"=>"C-99917", "count"=>1} (), {"value"=>"C-99913", "count"=>1} (), {"value"=>"C-99912", "count"=>1} (), {"value"=>"C-99910", "count"=>1} ()
  • BASINID
    Text
    {"value"=>"Honouliuli", "count"=>62362, "code"=>"HN"} (), {"value"=>"Sand Island", "count"=>52674, "code"=>"SI"} (), {"value"=>"Kailua", "count"=>23225, "code"=>"KK"} (), {"value"=>"Waianae", "count"=>9073, "code"=>"WN"} (), {"value"=>"Wahiawa", "count"=>4718, "code"=>"WH"} (), {"value"=>"Waimanalo", "count"=>1550, "code"=>"WM"} (), {"value"=>"Laie", "count"=>1432, "code"=>"LA"} (), {"value"=>"Hawaii Kai", "count"=>901, "code"=>"HK"} (), {"value"=>"Kahuku", "count"=>537, "code"=>"KH"} (), {"value"=>"Paalaa Kai", "count"=>309, "code"=>"PK"} ()
  • PROJECTID
    Number
    0 to 69007
  • STATUS
    Text
    {"value"=>"Active", "count"=>156664, "code"=>"ACT"} (), {"value"=>"Inactive", "count"=>117, "code"=>"INAC"} ()
  • OWNER
    Text
    {"value"=>"City & County of Honolulu", "count"=>138344, "code"=>"CITY"} (), {"value"=>"Private", "count"=>9035, "code"=>"PVT"} (), {"value"=>"Pending Dedication to City & County of Honolulu", "count"=>4914, "code"=>"PDCC"} (), {"value"=>"Hawaiian Home Land", "count"=>3698, "code"=>"HHL"} (), {"value"=>"Licensed for City Maintenance", "count"=>668, "code"=>"LIC"} (), {"value"=>"Military", "count"=>119, "code"=>"MIL"} (), {"value"=>"Unknown", "count"=>1, "code"=>"UNK"} ()
  • MATERIAL
    Text
    {"value"=>"Vitrified Clay", "count"=>102198, "code"=>"VCP"} (), {"value"=>"Polyvinyl Chloride", "count"=>17956, "code"=>"PVC"} (), {"value"=>"Unknown", "count"=>17239, "code"=>"UNK"} (), {"value"=>"Terra Cotta", "count"=>14195, "code"=>"TCP"} (), {"value"=>"Cast Iron", "count"=>2586, "code"=>"CAS"} (), {"value"=>"Reinforced Concrete", "count"=>1546, "code"=>"RCP"} (), {"value"=>"High Density Polyethylene", "count"=>847, "code"=>"HDPE"} (), {"value"=>" ", "count"=>51, "code"=>" "} (), {"value"=>"Ductile Iron Pipe", "count"=>8, "code"=>"DIP"} (), {"value"=>"HUM", "count"=>7, "code"=>"HUM"} ()
  • Date Built
    Date
    -2288044800000 to 1751241600000
  • Date Dig
    Date
    654652800000 to 1546009150000
  • Date Mod
    Date
    1348531200000 to 1547123728000
  • SEWERLATERALSUBTYPE
    Number
    1 to 2
  • DIAMETER
    Number
    0 to 24
  • NEIGHBORHOOD
    Text
    {"value"=>"Waipahu", "count"=>12638} (), {"value"=>"Ewa", "count"=>11988} (), {"value"=>"Kailua", "count"=>11658} (), {"value"=>"Kaneohe", "count"=>9303} (), {"value"=>"Makakilo-Kapolei-Honokai Hale", "count"=>8847} (), {"value"=>"Pearl City", "count"=>7705} (), {"value"=>"Aiea", "count"=>7503} (), {"value"=>"Mililani-Waipio-Melemanu", "count"=>7407} (), {"value"=>"Kaimuki", "count"=>5269} (), {"value"=>"Nanakuli-Maili", "count"=>4903} ()
  • TMK
    Text
    {"value"=>"91012058", "count"=>214} (), {"value"=>"15001001", "count"=>186} (), {"value"=>"91017110", "count"=>162} (), {"value"=>"91160052", "count"=>134} (), {"value"=>"47004027", "count"=>134} (), {"value"=>"91016041", "count"=>129} (), {"value"=>"92019062", "count"=>118} (), {"value"=>"92003075", "count"=>108} (), {"value"=>" ", "count"=>103} (), {"value"=>"95002036", "count"=>102} ()
  • shape
    Number
  • SEWERMAINID
    Number
  • SML
    Number
    0 to 240
  • LATL
    Number
    0 to 795
  • LATCUT
    Number
    0 to 747
  • SLOPELATERAL
    Number
    0 to 208
  • MAINDISTTOLAT
    Number
    0 to 356
  • MAINDISTTOWYE
    Number
    0 to 123
  • UPDISTTOLAT
    Number
    0 to 596
  • UPDISTTOWYE
    Number
    -4 to 460
  • DNDISTTOLAT
    Number
    0 to 505
  • DNDISTTOWYE
    Number
    0 to 350
  • ADDSML
    Number
    {"value"=>"True", "count"=>2873, "code"=>1} ()
  • CONFIDENCE
    Text
    {"value"=>"As-Built - Inspector Copy", "count"=>9631, "code"=>"REC"} (), {"value"=>"Design Plans", "count"=>2131, "code"=>"DES"} (), {"value"=>"Work Order", "count"=>333, "code"=>"WO"} (), {"value"=>"Other", "count"=>73, "code"=>"OTHER"} (), {"value"=>"Field Verified", "count"=>36, "code"=>"FIELD"} (), {"value"=>"Calculated", "count"=>3, "code"=>"CALC"} ()
  • NOTES
    Text
    {"value"=>"Estimated lateral location. No information on construction plan.", "count"=>292} (), {"value"=>"Chimney lateral", "count"=>155} (), {"value"=>"Plan and profile not available", "count"=>108} (), {"value"=>"Dry Sewer", "count"=>58} (), {"value"=>"project 7178", "count"=>19} (), {"value"=>"Warning: leade contaminated soil", "count"=>19} (), {"value"=>"Lateral info from project 7285", "count"=>14} (), {"value"=>"City owned to street property line only", "count"=>13} (), {"value"=>"Per rehab project 6995", "count"=>12} (), {"value"=>"DPP Counter Book", "count"=>9} ()
  • REHAB
    Text
    {"value"=>"None", "count"=>156117, "code"=>"NONE"} (), {"value"=>"Cured In Place Pipe", "count"=>620, "code"=>"CIPP"} (), {"value"=>"Spot Repair", "count"=>33, "code"=>"SPOT"} ()
  • LTPL
    Number
    0 to 999.9
  • RTPL
    Number
    0 to 995
  • YR_REHAB
    Date
    1308096000000 to 1525046400000
  • REHAB_ID
    Number
    0 to 7509
  • PIPELENGTH
    Number
    0 to 798.24
  • GLOBALID
    Number
  • SHAPE.STLength()
    Number

Related Datasets