Description

more
Storm Water inventoried pipes in Mecklenburg County

Dataset Attributes

  • OBJECTID
    Number
  • Pipe/Stub ID
    Text
    {"value"=>"-P", "count"=>2747} (), {"value"=>" ", "count"=>93} (), {"value"=>"P", "count"=>61} (), {"value"=>"-PS", "count"=>50} (), {"value"=>"INVEN.69759-P", "count"=>11} (), {"value"=>"-C", "count"=>11} (), {"value"=>"CHARX.49098-P", "count"=>9} (), {"value"=>"BRI054-9920-P", "count"=>6} (), {"value"=>"ULS018-0619-P", "count"=>5} (), {"value"=>"CMPDBea.0008-P", "count"=>5} ()
  • Date of Creation/Edit
    Date
    -2209161600000 to 1524614400000
  • UserID for Creation/Edit
    Text
    {"value"=>"Woods, David", "count"=>29351, "code"=>"Woods, David"} (), {"value"=>"Mamar, Salifou", "count"=>23237, "code"=>"smamar"} (), {"value"=>"Bright, Paul", "count"=>11844, "code"=>"pbright"} (), {"value"=>"Woods, David", "count"=>9541, "code"=>"dwoods"} (), {"value"=>"Unknown", "count"=>8779, "code"=>"Unknown"} (), {"value"=>"Bright, Paul", "count"=>7484, "code"=>"Bright, Paul"} (), {"value"=>"Washington, Michael", "count"=>7275, "code"=>"mwashington"} (), {"value"=>"Mamar, Salifou", "count"=>6323, "code"=>"Mamar, Salifou"} (), {"value"=>"Bright", "count"=>5721, "code"=>"Bright"} (), {"value"=>"92300", "count"=>5377, "code"=>"92300"} ()
  • Pipe Type
    Text
    {"value"=>"Pipe", "count"=>139579, "code"=>"Pipe"} (), {"value"=>"Pipestub", "count"=>4268, "code"=>"Pipestub"} (), {"value"=>" ", "count"=>22, "code"=>" "} (), {"value"=>"Pipe Stub", "count"=>2, "code"=>"Pipe Stub"} ()
  • Pipe Shape
    Text
    {"value"=>"Circular", "count"=>135150, "code"=>"Circular"} (), {"value"=>"CIRC", "count"=>4274, "code"=>"CIRC"} (), {"value"=>"Box", "count"=>1697, "code"=>"Box"} (), {"value"=>"Elliptical", "count"=>697, "code"=>"Elliptical"} (), {"value"=>"Unknown", "count"=>539, "code"=>"Unknown"} (), {"value"=>"Arch", "count"=>263, "code"=>"Arch"} (), {"value"=>"Other", "count"=>121, "code"=>"Other"} (), {"value"=>" ", "count"=>20, "code"=>" "} (), {"value"=>"ELPS", "count"=>3, "code"=>"ELPS"} (), {"value"=>"UNK", "count"=>3, "code"=>"UNK"} ()
  • Other Shape
    Text
    {"value"=>" ", "count"=>113725} (), {"value"=>"1x culvert", "count"=>1517} (), {"value"=>"2x culvert", "count"=>365} (), {"value"=>"3x culvert", "count"=>184} (), {"value"=>"bridge", "count"=>147} (), {"value"=>"4x culvert", "count"=>62} (), {"value"=>"road bridge", "count"=>51} (), {"value"=>"culvert", "count"=>23} (), {"value"=>"5x culvert", "count"=>16} (), {"value"=>"footbridge", "count"=>10} ()
  • Diameter
    Number
    {"value"=>"1.25 (15\")", "count"=>57831, "code"=>1.25} (), {"value"=>"1.50 (18\")", "count"=>23012, "code"=>1.5} (), {"value"=>"2.00 (24\")", "count"=>20103, "code"=>2} (), {"value"=>"2.50 (30\")", "count"=>9495, "code"=>2.5} (), {"value"=>"1.00 (12\")", "count"=>8666, "code"=>1} (), {"value"=>"3.00 (36\")", "count"=>7915, "code"=>3} (), {"value"=>"4.00 (48\")", "count"=>3323, "code"=>4} (), {"value"=>"3.50 (42\")", "count"=>2926, "code"=>3.5} (), {"value"=>"5.00 (60\")", "count"=>1307, "code"=>5} (), {"value"=>"4.50 (54\")", "count"=>1249, "code"=>4.5} ()
  • Other Diameter
    Number
    0 to 96
  • Rise (ft)
    Number
    0 to 70
  • Span (ft)
    Number
    0 to 200
  • Pipe Material
    Text
    {"value"=>"Concrete", "count"=>115850, "code"=>"Concrete"} (), {"value"=>"Metal or Steel", "count"=>9379, "code"=>"Metal or Steel"} (), {"value"=>"RCP", "count"=>6945, "code"=>"RCP"} (), {"value"=>"Plastic", "count"=>6679, "code"=>"Plastic"} (), {"value"=>"Unknown", "count"=>1765, "code"=>"Unknown"} (), {"value"=>"CMP", "count"=>479, "code"=>"CMP"} (), {"value"=>"Clay", "count"=>376, "code"=>"Clay"} (), {"value"=>"HDPE", "count"=>315, "code"=>"HDPE"} (), {"value"=>"VCP", "count"=>173, "code"=>"VCP"} (), {"value"=>" ", "count"=>96, "code"=>" "} ()
  • Other Material
    Text
    {"value"=>" ", "count"=>116536} (), {"value"=>"Null", "count"=>1010} (), {"value"=>"asphalt coated", "count"=>65} (), {"value"=>"Brickwork", "count"=>19} (), {"value"=>"wood", "count"=>17} (), {"value"=>"Brick", "count"=>14} (), {"value"=>"asphalt-coated", "count"=>5} (), {"value"=>"CMP", "count"=>5} (), {"value"=>"ductile iron", "count"=>5} (), {"value"=>"stone", "count"=>4} ()
  • US Structure ID
    Text
    {"value"=>"9999", "count"=>34} (), {"value"=>"INVEN.69759", "count"=>11} (), {"value"=>"BalCmStr.0006", "count"=>10} (), {"value"=>"CHARX.36549", "count"=>9} (), {"value"=>"INVEN.80781", "count"=>9} (), {"value"=>"Dogwood.0010", "count"=>9} (), {"value"=>"CHARX.49098", "count"=>9} (), {"value"=>"CHARX.93570", "count"=>7} (), {"value"=>"INVEN.82303", "count"=>7} (), {"value"=>"INVEN.82861", "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"=>125819, "code"=>"Yes"} (), {"value"=>"Unknown", "count"=>8166, "code"=>"UNK"} (), {"value"=>" ", "count"=>5996, "code"=>" "} (), {"value"=>"Unknown", "count"=>1045, "code"=>"Unknown"} (), {"value"=>"No", "count"=>611, "code"=>"No"} ()
  • DS Structure ID
    Text
    {"value"=>"INVEN.69763", "count"=>12} (), {"value"=>"MCA421-0038", "count"=>11} (), {"value"=>"BalCmStr.0013", "count"=>11} (), {"value"=>"IRW196-0201", "count"=>11} (), {"value"=>"INVEN.70149", "count"=>9} (), {"value"=>"INVEN.11454", "count"=>9} (), {"value"=>"CHARX.62704", "count"=>8} (), {"value"=>"9999", "count"=>8} (), {"value"=>"CHARX.32882", "count"=>8} (), {"value"=>"SBMKT08.494", "count"=>8} ()
  • DS Depth
    Number
    -9999 to 648753.75
  • DS Invert
    Number
    -9999 to 66025
  • DS Elevation
    Number
    -9999 to 649399
  • DS functions?
    Text
    {"value"=>"Yes", "count"=>124231, "code"=>"Yes"} (), {"value"=>"Unknown", "count"=>9493, "code"=>"UNK"} (), {"value"=>"Unknown", "count"=>1091, "code"=>"Unknown"} (), {"value"=>"No", "count"=>412, "code"=>"No"} (), {"value"=>" ", "count"=>296, "code"=>" "} ()
  • Slope (%)
    Number
    -10000 to 1689.9945928
  • Standard Comments
    Text
    {"value"=>" ", "count"=>81749, "code"=>" "} (), {"value"=>"DS point is assumed (minimal attributes)", "count"=>4674, "code"=>"Pipe-DS point is assumed"} (), {"value"=>"US point is assumed (minimal attributes)", "count"=>2945, "code"=>"Pipe-US point is assumed"} (), {"value"=>"Next structure not found", "count"=>1132, "code"=>"Pipestub-Next structure not found"} (), {"value"=>"Null", "count"=>931, "code"=>"Null"} (), {"value"=>"System not followed", "count"=>433, "code"=>"Pipestub-System not followed"} (), {"value"=>"Next structure not found", "count"=>195, "code"=>"Next structure not found"} (), {"value"=>"Pipe not followed", "count"=>59, "code"=>"Pipe not followed"} (), {"value"=>"Located on inaccessible/private property (minimal attributes)", "count"=>54, "code"=>"Structure-Located on inaccessible/private property"} (), {"value"=>"1", "count"=>50, "code"=>"1"} ()
  • Other Comments
    Text
    {"value"=>"LOCATION AND DATA FROM 1985 STORM DRAIN TOPOS", "count"=>2270} (), {"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 2012 Engineering Services project at Rea Rd. from NC Highway 51 to Colony Rd. (EMN)", "count"=>145} (), {"value"=>"100 % full pipe", "count"=>127} (), {"value"=>"Data derived from CIP plans", "count"=>111} (), {"value"=>"Brentwood Place SDIP Ph II 2013", "count"=>104} (), {"value"=>"going out of our basin area", "count"=>95} (), {"value"=>"roadside drainage; orginal data", "count"=>78} ()
  • Path to photos/media
    Text
    {"value"=>" ", "count"=>68271} (), {"value"=>"Null", "count"=>1001} (), {"value"=>"<Null>", "count"=>19} (), {"value"=>"\\\\MYRS-FILE-002\\engrstrmwat$\\Water Quality\\03 Post Construction\\SCM Data\\BMP Plans\\PCSO Project Plans\\McDonald's - Wendover Rd\\McDonalds wendover as-built.pdf", "count"=>8} (), {"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} ()
  • ENABLED
    Number
    0 to 1
  • len_1
    Number
    0 to 578.22174025
  • MapStatus
    Number
  • Apprx Construction Date
    Date
    -2209161600000 to 1546300800000
  • Active
    Text
    {"value"=>"Active", "count"=>143886, "code"=>"1"} ()
  • SHAPE
    Number
  • SHAPE.STLength()
    Number

About

Related Datasets