Description

more
Sewer - Manhole

Dataset Attributes

  • OBJECTID
    Number
  • ANCILLARYROLE
    Number
  • ENABLED
    Number
    {"value"=>"True", "count"=>49587, "code"=>1} ()
  • SEWERID
    Number
  • BASINID
    Text
    {"value"=>"Sand Island", "count"=>20063, "code"=>"SI"} (), {"value"=>"Honouliuli", "count"=>17819, "code"=>"HN"} (), {"value"=>"Kailua", "count"=>7171, "code"=>"KK"} (), {"value"=>"Waianae", "count"=>2294, "code"=>"WN"} (), {"value"=>"Wahiawa", "count"=>1329, "code"=>"WH"} (), {"value"=>"Waimanalo", "count"=>438, "code"=>"WM"} (), {"value"=>"Hawaii Kai", "count"=>262, "code"=>"HK"} (), {"value"=>"Kahuku", "count"=>139, "code"=>"KH"} (), {"value"=>"Paalaa Kai", "count"=>53, "code"=>"PK"} (), {"value"=>"Laie", "count"=>19, "code"=>"LA"} ()
  • PROJECTID
    Number
    0 to 7426
  • STATUS
    Text
    {"value"=>"Active", "count"=>49557, "code"=>"ACT"} (), {"value"=>"Inactive", "count"=>29, "code"=>"INAC"} (), {"value"=>"Proposed", "count"=>1, "code"=>"PROP"} ()
  • OWNER
    Text
    {"value"=>"City & County of Honolulu", "count"=>45033, "code"=>"CITY"} (), {"value"=>"Private", "count"=>2142, "code"=>"PVT"} (), {"value"=>"Pending Dedication to City & County of Honolulu", "count"=>1260, "code"=>"PDCC"} (), {"value"=>"Hawaiian Home Land", "count"=>924, "code"=>"HHL"} (), {"value"=>"Military", "count"=>224, "code"=>"MIL"} (), {"value"=>"Licensed for City Maintenance", "count"=>3, "code"=>"LIC"} (), {"value"=>"Unknown", "count"=>1, "code"=>"UNK"} ()
  • GROUNDELEV
    Number
    -50 to 1294
  • Date Built
    Date
    -3393878400000 to 1503532800000
  • Date Dig
    Date
    654652800000 to 1509112910000
  • Date Mod
    Date
    1048118400000 to 1509445401000
  • ASSETID
    Text
    {"value"=>" ", "count"=>215} (), {"value"=>"C-608809", "count"=>2} (), {"value"=>"C-9999", "count"=>1} (), {"value"=>"C-9990", "count"=>1} (), {"value"=>"C-99895", "count"=>1} (), {"value"=>"C-99894", "count"=>1} (), {"value"=>"C-99890", "count"=>1} (), {"value"=>"C-99870", "count"=>1} (), {"value"=>"C-9976", "count"=>1} (), {"value"=>"C-9969", "count"=>1} ()
  • ManholeType
    Text
    {"value"=>"Plain", "count"=>48279, "code"=>"PLN"} (), {"value"=>"Shallow Drop", "count"=>751, "code"=>"SHDP"} (), {"value"=>"Drop", "count"=>437, "code"=>"DROP"} (), {"value"=>"Transition MH", "count"=>74, "code"=>"TRAN"} (), {"value"=>"Pressure", "count"=>22, "code"=>"PRES"} (), {"value"=>"Junction Box", "count"=>17, "code"=>"JBOX"} (), {"value"=>"CO", "count"=>7, "code"=>"CO"} ()
  • DEPTH
    Number
    0 to 106.7
  • WEIR
    Text
    {"value"=>"None", "count"=>49580, "code"=>"NONE"} (), {"value"=>"Fixed", "count"=>6, "code"=>"FIXED"} (), {"value"=>"Removable", "count"=>1, "code"=>"REMV"} ()
  • MATERIAL
    Text
    {"value"=>"Unknown", "count"=>40540, "code"=>"UNK"} (), {"value"=>"Pre-Cast Concrete", "count"=>6299, "code"=>"CONC"} (), {"value"=>"Cast in Place Concrete", "count"=>2066, "code"=>"CIPC"} (), {"value"=>"Brick", "count"=>412, "code"=>"BRIC"} (), {"value"=>"Concrete With Liner", "count"=>246, "code"=>"CONL"} (), {"value"=>" ", "count"=>1, "code"=>" "} ()
  • REHAB
    Text
    {"value"=>"None", "count"=>48557, "code"=>"NONE"} (), {"value"=>"Cementious Epoxy", "count"=>822, "code"=>"EPOX"} (), {"value"=>"Spot Repairs", "count"=>114, "code"=>"SPOT"} (), {"value"=>"Unknown", "count"=>52, "code"=>"UNK"} (), {"value"=>"Fiberglass", "count"=>24, "code"=>"FIBG"} (), {"value"=>"Plastic Liner", "count"=>11, "code"=>"PLAS"} ()
  • MANHOLESUBTYPE
    Number
    1 to 1
  • ADDRESS
    Text
    {"value"=>" ", "count"=>3417} (), {"value"=>"45-680 LULUKU RD", "count"=>67} (), {"value"=>"87-194 LAIKU ST", "count"=>57} (), {"value"=>"2540 DOLE ST", "count"=>56} (), {"value"=>"92-7049 ELELE ST", "count"=>44} (), {"value"=>"900 KAMOKILA BLVD", "count"=>39} (), {"value"=>"319 KAPAHULU AVE", "count"=>34} (), {"value"=>"95-1127 KIHENE STREET", "count"=>34} (), {"value"=>"1450 ALA MOANA", "count"=>33} (), {"value"=>"1959 LAUKAHI ST", "count"=>33} ()
  • OLDID
    Text
    {"value"=>" ", "count"=>9077} (), {"value"=>"PRIVATE", "count"=>29} (), {"value"=>"KK30", "count"=>5} (), {"value"=>"WN02AV0001", "count"=>2} (), {"value"=>"SI84KE2000", "count"=>2} (), {"value"=>"SI21AK1015", "count"=>2} (), {"value"=>"SI05NE2000", "count"=>2} (), {"value"=>"WW15XG0083", "count"=>1} (), {"value"=>"WW15XG0082", "count"=>1} (), {"value"=>"WW15XG0081", "count"=>1} ()
  • YR_REHAB
    Date
    718502400000 to 1471824000000
  • REHAB_ID
    Number
    0 to 7417
  • shape
    Number
  • XCOORD
    Number
    -158.174603 to 0
  • YCOORD
    Number
    0 to 21.510306
  • CONFIDENCE
    Text
    {"value"=>"As-Built - Inspector Copy", "count"=>584, "code"=>"REC"} (), {"value"=>"Design Plans", "count"=>106, "code"=>"DES"} (), {"value"=>"Field Verified", "count"=>19, "code"=>"FIELD"} (), {"value"=>"Other", "count"=>1, "code"=>"OTHER"} (), {"value"=>"WO", "count"=>1, "code"=>"WO"} ()
  • NOTES
    Text
    {"value"=>"Dry Sewer", "count"=>15} (), {"value"=>"Top elevation updated per project 6717", "count"=>8} (), {"value"=>"Invert and top elevations are per DDC Land Division survey", "count"=>7} (), {"value"=>"Top elevation from contour data", "count"=>4} (), {"value"=>"Inverts updated per Land Division survey OAS\\GIS\\Sewers\\Misc Notes", "count"=>3} (), {"value"=>"Invert from project 7390", "count"=>2} (), {"value"=>"Warning: lead contaminated soil", "count"=>2} (), {"value"=>"Location adjusted based on 2012 CCTV", "count"=>2} (), {"value"=>"Invert and top elevations are per DDC Land Divsion survey", "count"=>2} (), {"value"=>"Ownership changed per Land Division", "count"=>2} ()
  • INSIDEDROP
    Text
    {"value"=>"No", "count"=>654, "code"=>"NO"} (), {"value"=>"Yes", "count"=>1, "code"=>"YES"} ()
  • COVERDIAM
    Number
  • LINER
    Text
    {"value"=>"None", "count"=>49262, "code"=>"NONE"} (), {"value"=>"Epoxy Coating", "count"=>201, "code"=>"EPOX"} (), {"value"=>"T-Lock", "count"=>115, "code"=>"TLOCK"} (), {"value"=>"T-Liner", "count"=>2, "code"=>"TLINE"} (), {"value"=>"Unknown", "count"=>1, "code"=>"UNK"} ()
  • LOWESTINVERT
    Number
    -55.8 to 1284.01
  • GLOBALID
    Number

About

  • By on March 24, 2016
  • Updated 7 months ago

Related Datasets