Description

more
Inventoried structures in Mecklenburg County 

Dataset Attributes

  • OBJECTID
    Number
  • Structure/Junction ID
    Text
    {"value"=>"MCM505-9019", "count"=>10} (), {"value"=>"INVEN.96922", "count"=>4} (), {"value"=>"MCA434-9217", "count"=>4} (), {"value"=>"MCM504-0001", "count"=>3} (), {"value"=>"INVEN.96918", "count"=>3} (), {"value"=>"INVEN.96896", "count"=>3} (), {"value"=>"INVEN.11460", "count"=>3} (), {"value"=>"CHARX.26941", "count"=>3} (), {"value"=>"INVEN.96924", "count"=>3} (), {"value"=>"INVEN.96892", "count"=>3} ()
  • Date of Creation/Edit
    Date
    -189388800000 to 1495065600000
  • User ID for Creation/Edit
    Text
    {"value"=>"Woods, David", "count"=>37297, "code"=>"Woods, David"} (), {"value"=>"Unknown", "count"=>24976, "code"=>"Unknown"} (), {"value"=>"Mamar, Salifou", "count"=>20865, "code"=>"smamar"} (), {"value"=>"Bright, Paul", "count"=>12901, "code"=>"pbright"} (), {"value"=>"Woods, David", "count"=>11887, "code"=>"dwoods"} (), {"value"=>"Washington, Michael", "count"=>7940, "code"=>"mwashington"} (), {"value"=>"Bright, Paul", "count"=>7869, "code"=>"Bright, Paul"} (), {"value"=>"Mamar, Salifou", "count"=>7633, "code"=>"Mamar, Salifou"} (), {"value"=>"aweddle", "count"=>7030, "code"=>"aweddle"} (), {"value"=>"Washington, Michael", "count"=>3685, "code"=>"Washington, Michael"} ()
  • Source of Data
    Text
    {"value"=>"Submeter GPS", "count"=>61103, "code"=>"Submeter GPS"} (), {"value"=>"Record Drawing", "count"=>44130, "code"=>"Record Drawing"} (), {"value"=>"Original Inventory Data", "count"=>29660, "code"=>"Original Inventory Data"} (), {"value"=>"Aerial Photography", "count"=>13883, "code"=>"Aerial Photography"} (), {"value"=>"SubGPS", "count"=>6011, "code"=>"SubGPS"} (), {"value"=>"Other", "count"=>5069, "code"=>"Other"} (), {"value"=>"Meck County Data", "count"=>3473, "code"=>"Meck County Data"} (), {"value"=>"Survey AsBuilt", "count"=>2231, "code"=>"Survey AsBuilt"} (), {"value"=>"Aerial", "count"=>414, "code"=>"Aerial"} (), {"value"=>"Offset distance from known feature", "count"=>325, "code"=>"Offset"} ()
  • Apprx Construction Date
    Date
    -2208988800000 to 1491350400000
  • Structure Function
    Text
    {"value"=>"Inlet", "count"=>110158, "code"=>"Inlet"} (), {"value"=>"Junction", "count"=>32669, "code"=>"Junction"} (), {"value"=>"Outlet", "count"=>23046, "code"=>"Outlet"} (), {"value"=>" ", "count"=>309, "code"=>" "} ()
  • Structure/Junction Type
    Text
    {"value"=>"Catch Basin", "count"=>36156, "code"=>"Catch Basin"} (), {"value"=>"Catch Basin", "count"=>27354, "code"=>"CB"} (), {"value"=>"Drop Inlet", "count"=>16156, "code"=>"Drop Inlet"} (), {"value"=>"Drop Inlet", "count"=>11784, "code"=>"DI"} (), {"value"=>"Endsection-Exposed Pipe", "count"=>8646, "code"=>"Exp Pipe"} (), {"value"=>"Junction Box", "count"=>8181, "code"=>"Junction Box"} (), {"value"=>"Endsection-Flared", "count"=>7301, "code"=>"FES"} (), {"value"=>"Junction Box", "count"=>6086, "code"=>"JB"} (), {"value"=>"Endsection-Wall", "count"=>6039, "code"=>"Endwall"} (), {"value"=>"ChJunct-Intersection", "count"=>5435, "code"=>"ChannelX"} ()
  • Other Structure Type
    Text
    {"value"=>" ", "count"=>114717} (), {"value"=>"manhole", "count"=>4824} (), {"value"=>"FES", "count"=>4007} (), {"value"=>"Wall", "count"=>3051} (), {"value"=>"Exposed Pipe", "count"=>2830} (), {"value"=>"Null", "count"=>1116} (), {"value"=>"RISER", "count"=>344} (), {"value"=>"Unknown", "count"=>134} (), {"value"=>"double grate", "count"=>99} (), {"value"=>"Vertical headwall", "count"=>81} ()
  • Interior Size/Shape
    Text
    {"value"=>"Standard", "count"=>85420, "code"=>"Standard"} (), {"value"=>"Not applicable", "count"=>19146, "code"=>"Not applicable"} (), {"value"=>"Unknown", "count"=>15802, "code"=>"Unknown"} (), {"value"=>"Not Applicable", "count"=>12980, "code"=>"N/A"} (), {"value"=>"Circular", "count"=>9541, "code"=>"Circular"} (), {"value"=>"Offset", "count"=>417, "code"=>"Offset"} (), {"value"=>"Other", "count"=>256, "code"=>"Other"} (), {"value"=>" ", "count"=>221, "code"=>" "} (), {"value"=>"Null", "count"=>17, "code"=>"Null"} (), {"value"=>"Box", "count"=>9, "code"=>"Box"} ()
  • Structure Material
    Text
    {"value"=>"Unknown", "count"=>35393, "code"=>"Unknown"} (), {"value"=>"Concrete block", "count"=>34556, "code"=>"ConcBlock"} (), {"value"=>"Brick", "count"=>32999, "code"=>"Brick"} (), {"value"=>"Concrete reinforced", "count"=>10277, "code"=>"ConcReinf"} (), {"value"=>"Concrete pipe", "count"=>8435, "code"=>"ConcPipe"} (), {"value"=>"Concrete block", "count"=>6177, "code"=>"Concrete block"} (), {"value"=>"Concrete reinforced", "count"=>3032, "code"=>"Concrete reinforced"} (), {"value"=>"Metal or Steel", "count"=>2667, "code"=>"Metal or Steel"} (), {"value"=>"Block", "count"=>2156, "code"=>"Block"} (), {"value"=>"Earthen", "count"=>1820, "code"=>"Earthen"} ()
  • Other Material
    Text
    {"value"=>" ", "count"=>128821} (), {"value"=>"Null", "count"=>1127} (), {"value"=>"PipeMat = Concrete", "count"=>1087} (), {"value"=>"PipeMat = Not applicable", "count"=>439} (), {"value"=>"<Null>", "count"=>354} (), {"value"=>"PipeMat = Metal or Steel", "count"=>201} (), {"value"=>"RCP", "count"=>181} (), {"value"=>"PipeMat = Plastic", "count"=>157} (), {"value"=>"Concrete - reinforced", "count"=>81} (), {"value"=>"Open Channel", "count"=>71} ()
  • Depth (ft)
    Number
    -9999 to 40000
  • Easting (X)
    Number
    0 to 6901448144.16712
  • Northing (Y)
    Number
    0 to 1474470.78404822
  • Elevation-Top
    Number
    -9999 to 627628
  • Invert-Out
    Number
    -9999 to 10757
  • Is structure functioning?
    Text
    {"value"=>"Yes", "count"=>150689, "code"=>"Yes"} (), {"value"=>"Unknown", "count"=>7813, "code"=>"Unknown"} (), {"value"=>"Unknown", "count"=>3540, "code"=>"UNK"} (), {"value"=>" ", "count"=>2459, "code"=>" "} (), {"value"=>"No", "count"=>776, "code"=>"No"} ()
  • Standard Comments
    Text
    {"value"=>" ", "count"=>104077, "code"=>" "} (), {"value"=>"Assumed location of blind box (minimal attributes)", "count"=>2111, "code"=>"Structure-Assumed location of blind box"} (), {"value"=>"Null", "count"=>1112, "code"=>"Null"} (), {"value"=>"Structure-Located in roadway and inaccessible due to heavy traffic", "count"=>415, "code"=>"Structure-Located in roadway and inaccessible due to heavy traffic"} (), {"value"=>"Structure-Located on heavily vegetated bank and inaccessible", "count"=>404, "code"=>"Structure-Located on heavily vegetated bank and inaccessible"} (), {"value"=>"Located on inaccessible/private property (minimal attributes)", "count"=>392, "code"=>"Structure-Located on inaccessible/private property"} (), {"value"=>"No access to structure", "count"=>90, "code"=>"No access to structure"} (), {"value"=>"1", "count"=>62, "code"=>"1"} (), {"value"=>"Structure-No physical access", "count"=>60, "code"=>"Structure-No physical access"} (), {"value"=>"Located on inaccessible/private property (minimal attributes)", "count"=>20, "code"=>"Located on inaccessible/private property (minimal attributes)"} ()
  • Other Comments
    Text
    {"value"=>"LOCATION AND DATA FROM 1985 STORM DRAIN TOPOS", "count"=>2933} (), {"value"=>"Data derived from David Woods' DRAIN line coverage - (CLC 4/12/12)", "count"=>2504} (), {"value"=>"Data derived from 2012 Airport outfall drawings", "count"=>1028} (), {"value"=>"Null", "count"=>1002} (), {"value"=>"Data derived from 1985 Storm Drain Topo Maps", "count"=>984} (), {"value"=>"Updated per Sunnyvale Chadworth existing conditions survey dated 2/1/2013", "count"=>608} (), {"value"=>"assuming pipe junction", "count"=>144} (), {"value"=>"Diam = ", "count"=>138} (), {"value"=>"10% sediment", "count"=>135} (), {"value"=>"construction basket on top", "count"=>117} ()
  • Path to Photos or Other Media
    Text
    {"value"=>" ", "count"=>114761} (), {"value"=>"null", "count"=>998} (), {"value"=>"0", "count"=>679} (), {"value"=>"P:\\Inventory\\Country_Club2_WRA\\", "count"=>276} (), {"value"=>"-", "count"=>263} (), {"value"=>"Original Attachment ID=", "count"=>63} (), {"value"=>"Original Attachment ID =", "count"=>25} (), {"value"=>"T:\\inventory\\WQ_Team\\FY12_CountyOutfalls\\SWOs FY1112\\Outfall Pictures\\.jpg", "count"=>10} (), {"value"=>"P:\\Inventory\\20151221-BRI052\\20160209_HTDetSysA.jpg", "count"=>6} (), {"value"=>"P:\\Inventory\\20151221-BRI052\\20160209_HTDetSysB.jpg", "count"=>5} ()
  • SIC Code (Water Quality)
    Text
    {"value"=>" ", "count"=>87941} ()
  • ANCILLARYROLE
    Text
    {"value"=>" ", "count"=>104558} (), {"value"=>"0", "count"=>231} (), {"value"=>"<Null>", "count"=>1} (), {"value"=>"4073", "count"=>1} (), {"value"=>"687.5", "count"=>1} ()
  • ENABLED
    Number
    0 to 1
  • OUTFALL_ID
    Text
    {"value"=>" ", "count"=>14903} (), {"value"=>"ARDRY-0011", "count"=>4} (), {"value"=>"SXM663-SWO261586", "count"=>2} (), {"value"=>"LLS278-SWO257560", "count"=>2} (), {"value"=>"MCDOP-0005", "count"=>2} (), {"value"=>"LLS276-SWO257605", "count"=>2} (), {"value"=>"IRW215-SWO117333", "count"=>1} (), {"value"=>"BRI060-SWO258724", "count"=>1} (), {"value"=>"PAW538-SWO1125", "count"=>1} (), {"value"=>"MCA401-SWO260895", "count"=>1} ()
  • MapStatus
    Number
    0 to 1
  • Active
    Text
    {"value"=>"Active", "count"=>102440, "code"=>"Active"} (), {"value"=>"Active", "count"=>64505, "code"=>"1"} ()
  • Other Data Source
    Text
    {"value"=>"Right Bank", "count"=>1463} (), {"value"=>"Left Bank", "count"=>1409} (), {"value"=>"Outfall drawings", "count"=>1018} (), {"value"=>"Original Inventory ", "count"=>680} (), {"value"=>"Record Drawing", "count"=>470} (), {"value"=>"NA", "count"=>183} (), {"value"=>"County location = Left Bank", "count"=>156} (), {"value"=>"County location = Right Bank", "count"=>149} (), {"value"=>"Survey AsBuilt", "count"=>111} (), {"value"=>"Original Inventory Dated 5/21/1997", "count"=>56} ()
  • Other Size/Shape
    Text
    {"value"=>"PiShape = Circular", "count"=>1675} (), {"value"=>"PiShape = Not applicable", "count"=>566} (), {"value"=>"PipeShp=Circular", "count"=>315} (), {"value"=>"Circular", "count"=>288} (), {"value"=>"PipeMat = Circular", "count"=>53} (), {"value"=>"Long, narrow DI", "count"=>31} (), {"value"=>"PiShape = Unknown", "count"=>10} (), {"value"=>"PiShape = Elliptical", "count"=>6} (), {"value"=>"Other", "count"=>6} (), {"value"=>"PipeShp=", "count"=>6} ()
  • SHAPE
    Number

About

Related Datasets