Description

more
Inventoried structures in Mecklenburg County 

Dataset Attributes

  • OBJECTID
    Number
  • Structure/Junction ID
    Text
    {"value"=>"MCA441-0002", "count"=>4} (), {"value"=>"INVEN.96922", "count"=>4} (), {"value"=>"MCM504-0001", "count"=>3} (), {"value"=>"ULS003-0844", "count"=>3} (), {"value"=>"INVEN.96918", "count"=>3} (), {"value"=>"ULS003-0847", "count"=>3} (), {"value"=>"INVEN.96896", "count"=>3} (), {"value"=>"INVEN.11460", "count"=>3} (), {"value"=>"INVEN.96924", "count"=>3} (), {"value"=>"INVEN.96892", "count"=>3} ()
  • Date of Creation/Edit
    Date
    -189388800000 to 1524614400000
  • User ID for Creation/Edit
    Text
    {"value"=>"Woods, David", "count"=>35892, "code"=>"Woods, David"} (), {"value"=>"Mamar, Salifou", "count"=>27174, "code"=>"smamar"} (), {"value"=>"Unknown", "count"=>16103, "code"=>"Unknown"} (), {"value"=>"Bright, Paul", "count"=>13793, "code"=>"pbright"} (), {"value"=>"Woods, David", "count"=>11388, "code"=>"dwoods"} (), {"value"=>"Washington, Michael", "count"=>9590, "code"=>"mwashington"} (), {"value"=>"Bright, Paul", "count"=>7788, "code"=>"Bright, Paul"} (), {"value"=>"Mamar, Salifou", "count"=>7232, "code"=>"Mamar, Salifou"} (), {"value"=>"aweddle", "count"=>6847, "code"=>"aweddle"} (), {"value"=>"Bright", "count"=>6424, "code"=>"Bright"} ()
  • Source of Data
    Text
    {"value"=>"Submeter GPS", "count"=>77888, "code"=>"Submeter GPS"} (), {"value"=>"Record Drawing", "count"=>43063, "code"=>"Record Drawing"} (), {"value"=>"Original Inventory Data", "count"=>20974, "code"=>"Original Inventory Data"} (), {"value"=>"Aerial Photography", "count"=>14371, "code"=>"Aerial Photography"} (), {"value"=>"SubGPS", "count"=>8042, "code"=>"SubGPS"} (), {"value"=>"Other", "count"=>4875, "code"=>"Other"} (), {"value"=>"Meck County Data", "count"=>3667, "code"=>"Meck County Data"} (), {"value"=>"Survey AsBuilt", "count"=>2504, "code"=>"Survey AsBuilt"} (), {"value"=>"Aerial", "count"=>1095, "code"=>"Aerial"} (), {"value"=>"Offset distance from known feature", "count"=>392, "code"=>"Offset"} ()
  • Apprx Construction Date
    Date
    -2208988800000 to 1527811200000
  • Structure Function
    Text
    {"value"=>"Inlet", "count"=>118546, "code"=>"Inlet"} (), {"value"=>"Junction", "count"=>34487, "code"=>"Junction"} (), {"value"=>"Outlet", "count"=>24168, "code"=>"Outlet"} (), {"value"=>" ", "count"=>243, "code"=>" "} (), {"value"=>" Inlet", "count"=>1, "code"=>" Inlet"} ()
  • Structure/Junction Type
    Text
    {"value"=>"Catch Basin", "count"=>36855, "code"=>"CB"} (), {"value"=>"Catch Basin", "count"=>31865, "code"=>"Catch Basin"} (), {"value"=>"Drop Inlet", "count"=>15215, "code"=>"DI"} (), {"value"=>"Drop Inlet", "count"=>14019, "code"=>"Drop Inlet"} (), {"value"=>"Endsection-Exposed Pipe", "count"=>9305, "code"=>"Exp Pipe"} (), {"value"=>"Junction Box", "count"=>8632, "code"=>"JB"} (), {"value"=>"Endsection-Flared", "count"=>8396, "code"=>"FES"} (), {"value"=>"Endsection-Wall", "count"=>7011, "code"=>"Endwall"} (), {"value"=>"Junction box", "count"=>6648, "code"=>"Junction box"} (), {"value"=>"ChJunct-Intersection", "count"=>6147, "code"=>"ChannelX"} ()
  • Other Structure Type
    Text
    {"value"=>" ", "count"=>126674} (), {"value"=>"manhole", "count"=>4417} (), {"value"=>"FES", "count"=>3625} (), {"value"=>"Wall", "count"=>2525} (), {"value"=>"Exposed Pipe", "count"=>2376} (), {"value"=>"Null", "count"=>1116} (), {"value"=>"Riser", "count"=>442} (), {"value"=>"Unknown", "count"=>133} (), {"value"=>"double grate", "count"=>98} (), {"value"=>"Vertical headwall", "count"=>97} ()
  • Interior Size/Shape
    Text
    {"value"=>"Standard", "count"=>93451, "code"=>"Standard"} (), {"value"=>"Not applicable", "count"=>17689, "code"=>"Not applicable"} (), {"value"=>"Not Applicable", "count"=>16789, "code"=>"N/A"} (), {"value"=>"Unknown", "count"=>16075, "code"=>"Unknown"} (), {"value"=>"Circular", "count"=>10138, "code"=>"Circular"} (), {"value"=>"Offset", "count"=>821, "code"=>"Offset"} (), {"value"=>"Other", "count"=>305, "code"=>"Other"} (), {"value"=>" ", "count"=>261, "code"=>" "} (), {"value"=>"Null", "count"=>17, "code"=>"Null"} (), {"value"=>"Box", "count"=>11, "code"=>"Box"} ()
  • Structure Material
    Text
    {"value"=>"Concrete block", "count"=>44492, "code"=>"ConcBlock"} (), {"value"=>"Unknown", "count"=>33325, "code"=>"Unknown"} (), {"value"=>"Brick", "count"=>29261, "code"=>"Brick"} (), {"value"=>"Concrete reinforced", "count"=>13641, "code"=>"ConcReinf"} (), {"value"=>"Concrete pipe", "count"=>9285, "code"=>"ConcPipe"} (), {"value"=>"Concrete block", "count"=>5972, "code"=>"Concrete block"} (), {"value"=>"Block", "count"=>3860, "code"=>"Block"} (), {"value"=>"Metal or Steel", "count"=>2799, "code"=>"Metal or Steel"} (), {"value"=>"Concrete reinforced", "count"=>2401, "code"=>"Concrete reinforced"} (), {"value"=>"Not Applicable", "count"=>2269, "code"=>"N/A"} ()
  • Other Material
    Text
    {"value"=>" ", "count"=>140218} (), {"value"=>"Null", "count"=>1127} (), {"value"=>"PipeMat = concrete", "count"=>988} (), {"value"=>"PipeMat = Not applicable", "count"=>410} (), {"value"=>"<Null>", "count"=>331} (), {"value"=>"PipeMat = Metal or Steel", "count"=>188} (), {"value"=>"RCP", "count"=>180} (), {"value"=>"PipeMat = Plastic", "count"=>150} (), {"value"=>"PipeMat = RCP", "count"=>105} (), {"value"=>"Concrete - reinforced", "count"=>81} ()
  • Depth (ft)
    Number
    -9999 to 40000
  • Easting (X)
    Number
    0 to 6901448144.16712
  • Northing (Y)
    Number
    0 to 1478043.637106
  • Elevation-Top
    Number
    -9999 to 627628
  • Invert-Out
    Number
    -9999 to 10813
  • Is structure functioning?
    Text
    {"value"=>"Yes", "count"=>162744, "code"=>"Yes"} (), {"value"=>"Unknown", "count"=>5380, "code"=>"UNK"} (), {"value"=>"Unknown", "count"=>5295, "code"=>"Unknown"} (), {"value"=>" ", "count"=>1722, "code"=>" "} (), {"value"=>"No", "count"=>1051, "code"=>"No"} ()
  • Standard Comments
    Text
    {"value"=>" ", "count"=>106130, "code"=>" "} (), {"value"=>"Assumed location of blind box (minimal attributes)", "count"=>2572, "code"=>"Structure-Assumed location of blind box"} (), {"value"=>"Null", "count"=>1114, "code"=>"Null"} (), {"value"=>"Located on inaccessible/private property (minimal attributes)", "count"=>612, "code"=>"Structure-Located on inaccessible/private property"} (), {"value"=>"Structure-Located on heavily vegetated bank and inaccessible", "count"=>555, "code"=>"Structure-Located on heavily vegetated bank and inaccessible"} (), {"value"=>"Structure-Located in roadway and inaccessible due to heavy traffic", "count"=>530, "code"=>"Structure-Located in roadway and inaccessible due to heavy traffic"} (), {"value"=>"No access to structure", "count"=>163, "code"=>"No access to structure"} (), {"value"=>"1", "count"=>82, "code"=>"1"} (), {"value"=>"Structure-No physical access", "count"=>72, "code"=>"Structure-No physical access"} (), {"value"=>"Unable to locate original feature", "count"=>26, "code"=>"Unable to locate original feature"} ()
  • Other Comments
    Text
    {"value"=>" ", "count"=>130397} (), {"value"=>"Data derived from David Woods' DRAIN line coverage - (CLC 4/12/12)", "count"=>2503} (), {"value"=>"LOCATION AND DATA FROM 1985 STORM DRAIN TOPOS", "count"=>2412} (), {"value"=>"Data derived from 2012 Airport outfall drawings", "count"=>1028} (), {"value"=>"Null", "count"=>1002} (), {"value"=>"Data derived from 1985 Storm Drain Topo Maps", "count"=>982} (), {"value"=>"Updated per Sunnyvale Chadworth existing conditions survey dated 2/1/2013", "count"=>608} (), {"value"=>"Not verified in the field yet", "count"=>368} (), {"value"=>"ASSUMING PIPE JUNCTION", "count"=>310} (), {"value"=>"could not locate", "count"=>193} ()
  • Path to Photos or Other Media
    Text
    {"value"=>" ", "count"=>122626} (), {"value"=>"Null", "count"=>998} (), {"value"=>"0", "count"=>662} (), {"value"=>"P:\\Inventory\\Country_Club2_WRA\\", "count"=>271} (), {"value"=>"-", "count"=>260} (), {"value"=>"Original Attachment ID = ", "count"=>109} (), {"value"=>"Original Attachment ID=", "count"=>63} (), {"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} ()
  • SIC Code (Water Quality)
    Text
  • ANCILLARYROLE
    Text
    {"value"=>" ", "count"=>106899} (), {"value"=>"0", "count"=>240} (), {"value"=>"1", "count"=>1} (), {"value"=>"<Null>", "count"=>1} (), {"value"=>"4073", "count"=>1} (), {"value"=>"687.5", "count"=>1} ()
  • ENABLED
    Number
    0 to 1
  • OUTFALL_ID
    Text
    {"value"=>" ", "count"=>16024} (), {"value"=>"ARDRY-0011", "count"=>4} (), {"value"=>"SXM663-SWO261585", "count"=>3} (), {"value"=>"SXM663-SWO261586", "count"=>2} (), {"value"=>"LLS278-SWO257560", "count"=>2} (), {"value"=>"LLS272-SWO258613", "count"=>2} (), {"value"=>"LLS274-SWO261192", "count"=>2} (), {"value"=>"LLS274-SWO261190", "count"=>2} (), {"value"=>"REE564-SWO261340", "count"=>2} (), {"value"=>"LLS273-SWO261000", "count"=>2} ()
  • MapStatus
    Number
  • Active
    Text
    {"value"=>"Active", "count"=>177957, "code"=>"1"} ()
  • Other Data Source
    Text
    {"value"=>" ", "count"=>1715} (), {"value"=>"Right Bank", "count"=>1512} (), {"value"=>"Left Bank", "count"=>1464} (), {"value"=>"Outfall drawings", "count"=>1018} (), {"value"=>"Original Inventory ", "count"=>768} (), {"value"=>"Record Drawing", "count"=>555} (), {"value"=>"NA", "count"=>176} (), {"value"=>"County location = Left Bank", "count"=>152} (), {"value"=>"County location = Right Bank", "count"=>148} (), {"value"=>"Survey AsBuilt", "count"=>130} ()
  • Other Size/Shape
    Text
    {"value"=>"PiShape = Circular", "count"=>1569} (), {"value"=>"PiShape = Not applicable", "count"=>538} (), {"value"=>"PipeShp=Circular", "count"=>312} (), {"value"=>"Circular", "count"=>287} (), {"value"=>"PipeMat = Circular", "count"=>53} (), {"value"=>"Long, narrow DI", "count"=>31} (), {"value"=>"PiShape = Unknown", "count"=>10} (), {"value"=>"PiShape = Elliptical", "count"=>6} (), {"value"=>"PipeShp= ", "count"=>6} (), {"value"=>"Other", "count"=>5} ()
  • SHAPE
    Number

About

  • By on March 5, 2015
  • Updated about 1 month ago

Related Datasets