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 1498003200000
  • User ID for Creation/Edit
    Text
    {"value"=>"Woods, David", "count"=>37286, "code"=>"Woods, David"} (), {"value"=>"Unknown", "count"=>24409, "code"=>"Unknown"} (), {"value"=>"Mamar, Salifou", "count"=>21510, "code"=>"smamar"} (), {"value"=>"Bright, Paul", "count"=>12889, "code"=>"pbright"} (), {"value"=>"Woods, David", "count"=>11887, "code"=>"dwoods"} (), {"value"=>"Washington, Michael", "count"=>8319, "code"=>"mwashington"} (), {"value"=>"Bright, Paul", "count"=>7856, "code"=>"Bright, Paul"} (), {"value"=>"Mamar, Salifou", "count"=>7629, "code"=>"Mamar, Salifou"} (), {"value"=>"aweddle", "count"=>7005, "code"=>"aweddle"} (), {"value"=>"Washington, Michael", "count"=>3685, "code"=>"Washington, Michael"} ()
  • Source of Data
    Text
    {"value"=>"Submeter GPS", "count"=>63129, "code"=>"Submeter GPS"} (), {"value"=>"Record Drawing", "count"=>44093, "code"=>"Record Drawing"} (), {"value"=>"Original Inventory Data", "count"=>29155, "code"=>"Original Inventory Data"} (), {"value"=>"Aerial Photography", "count"=>13923, "code"=>"Aerial Photography"} (), {"value"=>"SubGPS", "count"=>6015, "code"=>"SubGPS"} (), {"value"=>"Other", "count"=>5117, "code"=>"Other"} (), {"value"=>"Meck County Data", "count"=>3429, "code"=>"Meck County Data"} (), {"value"=>"Survey AsBuilt", "count"=>2218, "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 1491868800000
  • Structure Function
    Text
    {"value"=>"Inlet", "count"=>111221, "code"=>"Inlet"} (), {"value"=>"Junction", "count"=>32989, "code"=>"Junction"} (), {"value"=>"Outlet", "count"=>23198, "code"=>"Outlet"} (), {"value"=>" ", "count"=>305, "code"=>" "} ()
  • Structure/Junction Type
    Text
    {"value"=>"Catch Basin", "count"=>35920, "code"=>"Catch Basin"} (), {"value"=>"Catch Basin", "count"=>28224, "code"=>"CB"} (), {"value"=>"Drop Inlet", "count"=>15998, "code"=>"Drop Inlet"} (), {"value"=>"Drop Inlet", "count"=>12178, "code"=>"DI"} (), {"value"=>"Endsection-Exposed Pipe", "count"=>8753, "code"=>"Exp Pipe"} (), {"value"=>"Junction Box", "count"=>8085, "code"=>"Junction Box"} (), {"value"=>"Endsection-Flared", "count"=>7408, "code"=>"FES"} (), {"value"=>"Junction Box", "count"=>6381, "code"=>"JB"} (), {"value"=>"Endsection-Wall", "count"=>6137, "code"=>"Endwall"} (), {"value"=>"ChJunct-Intersection", "count"=>5522, "code"=>"ChannelX"} ()
  • Other Structure Type
    Text
    {"value"=>"manhole", "count"=>4817} (), {"value"=>"FES", "count"=>3998} (), {"value"=>"Wall", "count"=>3030} (), {"value"=>"Exposed Pipe", "count"=>2777} (), {"value"=>"Null", "count"=>1116} (), {"value"=>"RISER", "count"=>358} (), {"value"=>"Unknown", "count"=>129} (), {"value"=>"double grate", "count"=>99} (), {"value"=>"Vertical headwall", "count"=>84} (), {"value"=>"Flared", "count"=>79} ()
  • Interior Size/Shape
    Text
    {"value"=>"Standard", "count"=>86523, "code"=>"Standard"} (), {"value"=>"Not applicable", "count"=>19020, "code"=>"Not applicable"} (), {"value"=>"Unknown", "count"=>15795, "code"=>"Unknown"} (), {"value"=>"Not Applicable", "count"=>13370, "code"=>"N/A"} (), {"value"=>"Circular", "count"=>9713, "code"=>"Circular"} (), {"value"=>"Offset", "count"=>438, "code"=>"Offset"} (), {"value"=>"Other", "count"=>261, "code"=>"Other"} (), {"value"=>" ", "count"=>222, "code"=>" "} (), {"value"=>"Null", "count"=>17, "code"=>"Null"} (), {"value"=>"Box", "count"=>9, "code"=>"Box"} ()
  • Structure Material
    Text
    {"value"=>"Concrete block", "count"=>35750, "code"=>"ConcBlock"} (), {"value"=>"Unknown", "count"=>35290, "code"=>"Unknown"} (), {"value"=>"Brick", "count"=>32790, "code"=>"Brick"} (), {"value"=>"Concrete reinforced", "count"=>10699, "code"=>"ConcReinf"} (), {"value"=>"Concrete pipe", "count"=>8561, "code"=>"ConcPipe"} (), {"value"=>"Concrete block", "count"=>6158, "code"=>"Concrete block"} (), {"value"=>"Concrete reinforced", "count"=>3011, "code"=>"Concrete reinforced"} (), {"value"=>"Metal or Steel", "count"=>2700, "code"=>"Metal or Steel"} (), {"value"=>"Block", "count"=>2158, "code"=>"Block"} (), {"value"=>"Earthen", "count"=>1858, "code"=>"Earthen"} ()
  • Other Material
    Text
    {"value"=>"Null", "count"=>1127} (), {"value"=>"PipeMat = Concrete", "count"=>1089} (), {"value"=>"PipeMat = Not applicable", "count"=>439} (), {"value"=>"<Null>", "count"=>352} (), {"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} (), {"value"=>"PipeMat = RCP", "count"=>68} ()
  • 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"=>152378, "code"=>"Yes"} (), {"value"=>"Unknown", "count"=>7514, "code"=>"Unknown"} (), {"value"=>"Unknown", "count"=>3701, "code"=>"UNK"} (), {"value"=>" ", "count"=>2419, "code"=>" "} (), {"value"=>"No", "count"=>798, "code"=>"No"} ()
  • Standard Comments
    Text
    {"value"=>" ", "count"=>104409, "code"=>" "} (), {"value"=>"Assumed location of blind box (minimal attributes)", "count"=>2168, "code"=>"Structure-Assumed location of blind box"} (), {"value"=>"Null", "count"=>1112, "code"=>"Null"} (), {"value"=>"Structure-Located on heavily vegetated bank and inaccessible", "count"=>444, "code"=>"Structure-Located on heavily vegetated bank and inaccessible"} (), {"value"=>"Located on inaccessible/private property (minimal attributes)", "count"=>436, "code"=>"Structure-Located on inaccessible/private property"} (), {"value"=>"Structure-Located in roadway and inaccessible due to heavy traffic", "count"=>429, "code"=>"Structure-Located in roadway and inaccessible due to heavy traffic"} (), {"value"=>"No access to structure", "count"=>91, "code"=>"No access to structure"} (), {"value"=>"1", "count"=>62, "code"=>"1"} (), {"value"=>"Structure-No physical access", "count"=>62, "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"=>145} (), {"value"=>"Not verified in the field yet", "count"=>143} (), {"value"=>"Diam = ", "count"=>138} (), {"value"=>"10% sediment", "count"=>135} ()
  • Path to Photos or Other Media
    Text
    {"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"=>"1", "count"=>5} (), {"value"=>"P:\\Inventory\\20151221-BRI052\\20160209_HTDetSysB.jpg", "count"=>5} ()
  • SIC Code (Water Quality)
    Text
    {"value"=>" ", "count"=>87805} (), {"value"=>"2007", "count"=>71} (), {"value"=>"2013", "count"=>23} (), {"value"=>"2008", "count"=>16} (), {"value"=>"2005", "count"=>6} (), {"value"=>"2004", "count"=>6} (), {"value"=>"2001", "count"=>2} (), {"value"=>"1998", "count"=>2} ()
  • ANCILLARYROLE
    Text
    {"value"=>" ", "count"=>104959} (), {"value"=>"0", "count"=>242} (), {"value"=>"<Null>", "count"=>1} (), {"value"=>"4073", "count"=>1} (), {"value"=>"687.5", "count"=>1} ()
  • ENABLED
    Number
    0 to 1
  • OUTFALL_ID
    Text
    {"value"=>" ", "count"=>14882} (), {"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"=>101678, "code"=>"Active"} (), {"value"=>"Active", "count"=>66787, "code"=>"1"} ()
  • Other Data Source
    Text
    {"value"=>"Right Bank", "count"=>1464} (), {"value"=>"Left Bank", "count"=>1409} (), {"value"=>"Outfall drawings", "count"=>1018} (), {"value"=>"Original Inventory ", "count"=>695} (), {"value"=>"Record Drawing", "count"=>472} (), {"value"=>"NA", "count"=>183} (), {"value"=>"County location = Left Bank", "count"=>155} (), {"value"=>"County location = Right Bank", "count"=>148} (), {"value"=>"Survey AsBuilt", "count"=>111} (), {"value"=>"Original Inventory Dated 5/21/1997", "count"=>56} ()
  • Other Size/Shape
    Text
    {"value"=>"PiShape = Circular", "count"=>1677} (), {"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

  • By on March 5, 2015
  • Updated about 2 months ago

Related Datasets