Description

more
Storm Water inventoried pipes in Mecklenburg County

Dataset Attributes

  • OBJECTID
    Number
  • Pipe/Stub ID
    Text
    {"value"=>"-P", "count"=>2307} (), {"value"=>" ", "count"=>82} (), {"value"=>"P", "count"=>59} (), {"value"=>"-PS", "count"=>52} (), {"value"=>"INVEN.69759-P", "count"=>11} (), {"value"=>"-C", "count"=>11} (), {"value"=>"CHARX.49098-P", "count"=>9} (), {"value"=>"MCM505-9019-P", "count"=>9} (), {"value"=>"ULS018-0619-P", "count"=>5} (), {"value"=>"CMPDBea.0008-P", "count"=>5} ()
  • Date of Creation/Edit
    Date
    -2209161600000 to 1495065600000
  • UserID for Creation/Edit
    Text
    {"value"=>"Woods, David", "count"=>30630, "code"=>"Woods, David"} (), {"value"=>"Mamar, Salifou", "count"=>17673, "code"=>"smamar"} (), {"value"=>"Unknown", "count"=>16319, "code"=>"Unknown"} (), {"value"=>"Bright, Paul", "count"=>11073, "code"=>"pbright"} (), {"value"=>"Woods, David", "count"=>9953, "code"=>"dwoods"} (), {"value"=>"Bright, Paul", "count"=>7538, "code"=>"Bright, Paul"} (), {"value"=>"Mamar, Salifou", "count"=>6680, "code"=>"Mamar, Salifou"} (), {"value"=>"Washington, Michael", "count"=>5714, "code"=>"mwashington"} (), {"value"=>"aweddle", "count"=>5348, "code"=>"aweddle"} (), {"value"=>"Bright", "count"=>3154, "code"=>"Bright"} ()
  • Pipe Type
    Text
    {"value"=>"Pipe", "count"=>130015, "code"=>"Pipe"} (), {"value"=>"Pipestub", "count"=>4096, "code"=>"Pipestub"} (), {"value"=>" ", "count"=>5, "code"=>" "} ()
  • Pipe Shape
    Text
    {"value"=>"Circular", "count"=>128642, "code"=>"Circular"} (), {"value"=>"Box", "count"=>1676, "code"=>"Box"} (), {"value"=>"CIRC", "count"=>1097, "code"=>"CIRC"} (), {"value"=>"Elliptical", "count"=>688, "code"=>"Elliptical"} (), {"value"=>"Unknown", "count"=>489, "code"=>"Unknown"} (), {"value"=>"Arch", "count"=>261, "code"=>"Arch"} (), {"value"=>"Other", "count"=>124, "code"=>"Other"} (), {"value"=>" ", "count"=>5, "code"=>" "} (), {"value"=>"UNK", "count"=>2, "code"=>"UNK"} (), {"value"=>"Not applicable", "count"=>1, "code"=>"Not applicable"} ()
  • Other Shape
    Text
    {"value"=>" ", "count"=>105970} (), {"value"=>"bridge", "count"=>47} (), {"value"=>"Road bridge", "count"=>35} (), {"value"=>"culvert", "count"=>11} (), {"value"=>"footbridge", "count"=>9} (), {"value"=>"foot bridge", "count"=>9} (), {"value"=>"Double box culvert", "count"=>7} (), {"value"=>"golf cart bridge", "count"=>5} (), {"value"=>"DOUBLE PIPE", "count"=>4} (), {"value"=>"RR bridge", "count"=>3} ()
  • Diameter
    Number
    {"value"=>"1.25 (15\")", "count"=>52471, "code"=>1.25} (), {"value"=>"1.50 (18\")", "count"=>21474, "code"=>1.5} (), {"value"=>"2.00 (24\")", "count"=>18730, "code"=>2} (), {"value"=>"2.50 (30\")", "count"=>8863, "code"=>2.5} (), {"value"=>"1.00 (12\")", "count"=>8547, "code"=>1} (), {"value"=>"3.00 (36\")", "count"=>7440, "code"=>3} (), {"value"=>"4.00 (48\")", "count"=>3163, "code"=>4} (), {"value"=>"3.50 (42\")", "count"=>2846, "code"=>3.5} (), {"value"=>"5.00 (60\")", "count"=>1251, "code"=>5} (), {"value"=>"4.50 (54\")", "count"=>1214, "code"=>4.5} ()
  • Other Diameter
    Number
    0 to 108
  • Rise (ft)
    Number
    0 to 70
  • Span (ft)
    Number
    0 to 200
  • Pipe Material
    Text
    {"value"=>"Concrete", "count"=>109999, "code"=>"Concrete"} (), {"value"=>"Metal or Steel", "count"=>9341, "code"=>"Metal or Steel"} (), {"value"=>"Plastic", "count"=>6156, "code"=>"Plastic"} (), {"value"=>"RCP", "count"=>4096, "code"=>"RCP"} (), {"value"=>"Unknown", "count"=>1625, "code"=>"Unknown"} (), {"value"=>"Clay", "count"=>525, "code"=>"Clay"} (), {"value"=>"CMP", "count"=>321, "code"=>"CMP"} (), {"value"=>"HDPE", "count"=>178, "code"=>"HDPE"} (), {"value"=>" ", "count"=>81, "code"=>" "} (), {"value"=>"Other", "count"=>54, "code"=>"Other"} ()
  • Other Material
    Text
    {"value"=>" ", "count"=>106598} (), {"value"=>"Null", "count"=>1010} (), {"value"=>"asphalt coated", "count"=>72} (), {"value"=>"Brick", "count"=>21} (), {"value"=>"wood", "count"=>16} (), {"value"=>"DUCTILE IRON", "count"=>6} (), {"value"=>"asphalt-coated", "count"=>5} (), {"value"=>"CMP", "count"=>5} (), {"value"=>"Stone", "count"=>4} (), {"value"=>"concrete-lined", "count"=>3} ()
  • US Structure ID
    Text
    {"value"=>" ", "count"=>1821} (), {"value"=>"9999", "count"=>35} (), {"value"=>"INVEN.69759", "count"=>11} (), {"value"=>"BalCmStr.0006", "count"=>10} (), {"value"=>"INVEN.80781", "count"=>9} (), {"value"=>"CHARX.36549", "count"=>9} (), {"value"=>"MCM505-9019", "count"=>9} (), {"value"=>"Dogwood.0010", "count"=>9} (), {"value"=>"CHARX.49098", "count"=>9} (), {"value"=>"CHARX.93570", "count"=>7} ()
  • US Depth
    Number
    -9999 to 40000
  • US Invert
    Number
    -9999 to 10772
  • US Elevation
    Number
    0 to 69214
  • US functions?
    Text
    {"value"=>"Yes", "count"=>112121, "code"=>"Yes"} (), {"value"=>" ", "count"=>12331, "code"=>" "} (), {"value"=>"Unknown", "count"=>6202, "code"=>"UNK"} (), {"value"=>"Unknown", "count"=>660, "code"=>"Unknown"} (), {"value"=>"No", "count"=>442, "code"=>"No"} ()
  • DS Structure ID
    Text
    {"value"=>" ", "count"=>688} (), {"value"=>"INVEN.69763", "count"=>12} (), {"value"=>"MCA421-0038", "count"=>11} (), {"value"=>"IRW196-0201", "count"=>11} (), {"value"=>"BalCmStr.0013", "count"=>11} (), {"value"=>"STSVL08.64", "count"=>9} (), {"value"=>"9999", "count"=>9} (), {"value"=>"INVEN.70149", "count"=>9} (), {"value"=>"INVEN.11454", "count"=>9} (), {"value"=>"MCM505-9019", "count"=>8} ()
  • DS Depth
    Number
    -9999 to 664.9
  • DS Invert
    Number
    -9999 to 66025
  • DS Elevation
    Number
    -9999 to 65525
  • DS functions?
    Text
    {"value"=>"Yes", "count"=>110641, "code"=>"Yes"} (), {"value"=>"Unknown", "count"=>7037, "code"=>"UNK"} (), {"value"=>"Unknown", "count"=>711, "code"=>"Unknown"} (), {"value"=>" ", "count"=>353, "code"=>" "} (), {"value"=>"No", "count"=>311, "code"=>"No"} ()
  • Slope (%)
    Number
    -9999 to 1689.9945928
  • Standard Comments
    Text
    {"value"=>" ", "count"=>81181, "code"=>" "} (), {"value"=>"DS point is assumed (minimal attributes)", "count"=>3279, "code"=>"Pipe-DS point is assumed"} (), {"value"=>"US point is assumed (minimal attributes)", "count"=>1960, "code"=>"Pipe-US point is assumed"} (), {"value"=>"Null", "count"=>931, "code"=>"Null"} (), {"value"=>"Next structure not found", "count"=>679, "code"=>"Pipestub-Next structure not found"} (), {"value"=>"System not followed", "count"=>328, "code"=>"Pipestub-System not followed"} (), {"value"=>"Next structure not found", "count"=>95, "code"=>"Next structure not found"} (), {"value"=>"1", "count"=>50, "code"=>"1"} (), {"value"=>"DS point is assumed (minimal attributes)", "count"=>46, "code"=>"DS point is assumed (minimal attributes)"} (), {"value"=>"3", "count"=>30, "code"=>"3"} ()
  • Other Comments
    Text
    {"value"=>" ", "count"=>39435} (), {"value"=>"LOCATION AND DATA FROM 1985 STORM DRAIN TOPOS", "count"=>2530} (), {"value"=>"Data derived from 2012 Airport outfall drawings", "count"=>901} (), {"value"=>"Data derived from 1985 Storm Drain Topo Maps", "count"=>735} (), {"value"=>"Updated per Sunnyvale Chadworth existing conditions survey dated 2/1/2013", "count"=>591} (), {"value"=>"Data derived from CIP plans", "count"=>111} (), {"value"=>"single box culvert", "count"=>70} (), {"value"=>"Pipe data derived from Meck County info (SSM 10/18/2011) ", "count"=>68} (), {"value"=>"single barrel culvert ", "count"=>63} (), {"value"=>"abandoned", "count"=>58} ()
  • Path to photos/media
    Text
    {"value"=>" ", "count"=>70983} (), {"value"=>"Null", "count"=>1001} (), {"value"=>"<Null>", "count"=>19} (), {"value"=>"P:\\Inventory\\LLS271_20140501\\IMG_3403.jpg", "count"=>4} (), {"value"=>"P:\\Inventory\\BRI058_20140318\\IMG_2880.jpg", "count"=>4} (), {"value"=>"p:\\Inventory\\ULS11_photos_mar08\\IMG_1735.jpg", "count"=>4} (), {"value"=>"P:\\Inventory\\ULS015_photos_jan09\\IMG_4140.jpg", "count"=>3} (), {"value"=>"p:\\Inventory\\Grove_Park\\6217_lakeside_headwall.JPG", "count"=>3} (), {"value"=>"P:\\Inventory\\BRI039_20140228\\IMG_2528.jpg", "count"=>3} (), {"value"=>"P:\\Inventory\\ULS015_photos_jan09\\IMG_4041.jpg", "count"=>2} ()
  • ENABLED
    Number
    0 to 1
  • len_1
    Number
    0 to 578.22174025
  • MapStatus
    Number
    1 to 1
  • Apprx Construction Date
    Date
    -2209161600000 to 1546300800000
  • Active
    Text
  • SHAPE
    Number
  • SHAPE.STLength()
    Number

About

Related Datasets