Description

more
Sewer - Laterals

Dataset Attributes

  • OBJECTID
    Number
  • ENABLED
    Number
    {"value"=>"True", "count"=>154816, "code"=>1} ()
  • SEWERID
    Number
  • ASSETID
    Text
    {"value"=>" ", "count"=>63} (), {"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} (), {"value"=>"C-99909", "count"=>1} (), {"value"=>"C-99908", "count"=>1} (), {"value"=>"C-99907", "count"=>1} (), {"value"=>"C-99906", "count"=>1} ()
  • BASINID
    Text
    {"value"=>"Honouliuli", "count"=>60793, "code"=>"HN"} (), {"value"=>"Sand Island", "count"=>52581, "code"=>"SI"} (), {"value"=>"Kailua", "count"=>23017, "code"=>"KK"} (), {"value"=>"Waianae", "count"=>9027, "code"=>"WN"} (), {"value"=>"Wahiawa", "count"=>4718, "code"=>"WH"} (), {"value"=>"Waimanalo", "count"=>1550, "code"=>"WM"} (), {"value"=>"Laie", "count"=>1383, "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"=>154694, "code"=>"ACT"} (), {"value"=>"Inactive", "count"=>117, "code"=>"INAC"} (), {"value"=>"Proposed", "count"=>4, "code"=>"PROP"} (), {"value"=>"Abandoned", "count"=>1, "code"=>"ABAN"} ()
  • OWNER
    Text
    {"value"=>"City & County of Honolulu", "count"=>138601, "code"=>"CITY"} (), {"value"=>"Private", "count"=>6996, "code"=>"PVT"} (), {"value"=>"Pending Dedication to City & County of Honolulu", "count"=>4695, "code"=>"PDCC"} (), {"value"=>"Hawaiian Home Land", "count"=>3726, "code"=>"HHL"} (), {"value"=>"Licensed for City Maintenance", "count"=>678, "code"=>"LIC"} (), {"value"=>"Military", "count"=>119, "code"=>"MIL"} (), {"value"=>"Unknown", "count"=>1, "code"=>"UNK"} ()
  • MATERIAL
    Text
    {"value"=>"Vitrified Clay Pipe", "count"=>101327, "code"=>"VCP"} (), {"value"=>"Polyvinyl Chloride Pipe", "count"=>16911, "code"=>"PVC"} (), {"value"=>"Unknown", "count"=>16862, "code"=>"UNK"} (), {"value"=>"Terra Cotta Pipe", "count"=>14200, "code"=>"TCP"} (), {"value"=>"CAS", "count"=>2566, "code"=>"CAS"} (), {"value"=>"Reinforced Concrete Pipe", "count"=>1550, "code"=>"RCP"} (), {"value"=>"High Density Polyethylene", "count"=>817, "code"=>"HDPE"} (), {"value"=>" ", "count"=>191, "code"=>" "} (), {"value"=>"HUM", "count"=>7, "code"=>"HUM"} (), {"value"=>"Ductile Iron Pipe", "count"=>7, "code"=>"DIP"} ()
  • Date Built
    Date
    -2288044800000 to 1519776000000
  • Date Dig
    Date
    654652800000 to 1525872567000
  • Date Mod
    Date
    1348531200000 to 1525931968000
  • SEWERLATERALSUBTYPE
    Number
    1 to 2
  • DIAMETER
    Number
    0 to 24
  • NEIGHBORHOOD
    Text
    {"value"=>"Waipahu", "count"=>12564} (), {"value"=>"Ewa", "count"=>11764} (), {"value"=>"Kailua", "count"=>11662} (), {"value"=>"Kaneohe", "count"=>9287} (), {"value"=>"Makakilo-Kapolei-Honokai Hale", "count"=>8195} (), {"value"=>"Pearl City", "count"=>7694} (), {"value"=>"Mililani-Waipio-Melemanu", "count"=>7630} (), {"value"=>"Aiea", "count"=>7487} (), {"value"=>"Kaimuki", "count"=>5268} (), {"value"=>"Kuliouou-Kalani Iki", "count"=>4888} ()
  • TMK
    Text
    {"value"=>"99", "count"=>243} (), {"value"=>"91012058", "count"=>214} (), {"value"=>"15001001", "count"=>186} (), {"value"=>"91017110", "count"=>162} (), {"value"=>" ", "count"=>158} (), {"value"=>"92019062", "count"=>118} (), {"value"=>"92003075", "count"=>108} (), {"value"=>"95002036", "count"=>102} (), {"value"=>"87010022", "count"=>99} (), {"value"=>"84002064", "count"=>78} ()
  • 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"=>2857, "code"=>1} (), {"value"=>6, "count"=>1, "code"=>6} ()
  • CONFIDENCE
    Text
    {"value"=>"As-Built - Inspector Copy", "count"=>1967, "code"=>"REC"} (), {"value"=>"Design Plans", "count"=>1203, "code"=>"DES"} (), {"value"=>"WO", "count"=>188, "code"=>"WO"} (), {"value"=>"Field Verified", "count"=>37, "code"=>"FIELD"} (), {"value"=>"Other", "count"=>24, "code"=>"OTHER"} ()
  • NOTES
    Text
    {"value"=>"Chimney lateral", "count"=>152} (), {"value"=>"Plan and profile not available", "count"=>108} (), {"value"=>"Dry Sewer", "count"=>58} (), {"value"=>"Warning: leade contaminated soil", "count"=>19} (), {"value"=>"project 7178", "count"=>19} (), {"value"=>"Lateral info from Project 7285", "count"=>14} (), {"value"=>"Added per CSM request", "count"=>8} (), {"value"=>"located by 7197", "count"=>6} (), {"value"=>"Large TMK", "count"=>6} (), {"value"=>"Lateral from CCTV", "count"=>5} ()
  • REHAB
    Text
    {"value"=>"None", "count"=>154161, "code"=>"NONE"} (), {"value"=>"Cured In Place Pipe", "count"=>620, "code"=>"CIPP"} (), {"value"=>"Spot Repair", "count"=>24, "code"=>"SPOT"} ()
  • LTPL
    Number
    0 to 999.9
  • RTPL
    Number
    0 to 995
  • YR_REHAB
    Date
    1308096000000 to 1499817600000
  • REHAB_ID
    Number
    0 to 7404
  • PIPELENGTH
    Number
    0 to 797.15
  • GLOBALID
    Number
  • SHAPE.STLength()
    Number

About

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

Related Datasets