Description

more
Storm Water inventoried pipes in Mecklenburg County

Dataset Attributes

  • OBJECTID
    Number
  • Pipe/Stub ID
    Text
    {"value"=>"-P", "count"=>2329} (), {"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 1498003200000
  • UserID for Creation/Edit
    Text
    {"value"=>"Woods, David", "count"=>30617, "code"=>"Woods, David"} (), {"value"=>"Mamar, Salifou", "count"=>18308, "code"=>"smamar"} (), {"value"=>"Unknown", "count"=>15817, "code"=>"Unknown"} (), {"value"=>"Bright, Paul", "count"=>11057, "code"=>"pbright"} (), {"value"=>"Woods, David", "count"=>9953, "code"=>"dwoods"} (), {"value"=>"Bright, Paul", "count"=>7524, "code"=>"Bright, Paul"} (), {"value"=>"Mamar, Salifou", "count"=>6656, "code"=>"Mamar, Salifou"} (), {"value"=>"Washington, Michael", "count"=>6093, "code"=>"mwashington"} (), {"value"=>"aweddle", "count"=>5324, "code"=>"aweddle"} (), {"value"=>"Bright", "count"=>3155, "code"=>"Bright"} ()
  • Pipe Type
    Text
    {"value"=>"Pipe", "count"=>131357, "code"=>"Pipe"} (), {"value"=>"Pipestub", "count"=>4087, "code"=>"Pipestub"} (), {"value"=>" ", "count"=>7, "code"=>" "} ()
  • Pipe Shape
    Text
    {"value"=>"Circular", "count"=>129959, "code"=>"Circular"} (), {"value"=>"Box", "count"=>1672, "code"=>"Box"} (), {"value"=>"CIRC", "count"=>1097, "code"=>"CIRC"} (), {"value"=>"Elliptical", "count"=>689, "code"=>"Elliptical"} (), {"value"=>"Unknown", "count"=>502, "code"=>"Unknown"} (), {"value"=>"Arch", "count"=>267, "code"=>"Arch"} (), {"value"=>"Other", "count"=>125, "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"=>107363} (), {"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"=>53124, "code"=>1.25} (), {"value"=>"1.50 (18\")", "count"=>21710, "code"=>1.5} (), {"value"=>"2.00 (24\")", "count"=>18889, "code"=>2} (), {"value"=>"2.50 (30\")", "count"=>8958, "code"=>2.5} (), {"value"=>"1.00 (12\")", "count"=>8598, "code"=>1} (), {"value"=>"3.00 (36\")", "count"=>7501, "code"=>3} (), {"value"=>"4.00 (48\")", "count"=>3186, "code"=>4} (), {"value"=>"3.50 (42\")", "count"=>2875, "code"=>3.5} (), {"value"=>"5.00 (60\")", "count"=>1260, "code"=>5} (), {"value"=>"4.50 (54\")", "count"=>1219, "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"=>111061, "code"=>"Concrete"} (), {"value"=>"Metal or Steel", "count"=>9441, "code"=>"Metal or Steel"} (), {"value"=>"Plastic", "count"=>6310, "code"=>"Plastic"} (), {"value"=>"RCP", "count"=>4096, "code"=>"RCP"} (), {"value"=>"Unknown", "count"=>1638, "code"=>"Unknown"} (), {"value"=>"Clay", "count"=>527, "code"=>"Clay"} (), {"value"=>"CMP", "count"=>321, "code"=>"CMP"} (), {"value"=>"HDPE", "count"=>178, "code"=>"HDPE"} (), {"value"=>" ", "count"=>82, "code"=>" "} (), {"value"=>"Other", "count"=>55, "code"=>"Other"} ()
  • Other Material
    Text
    {"value"=>" ", "count"=>107991} (), {"value"=>"Null", "count"=>1010} (), {"value"=>"asphalt coated", "count"=>72} (), {"value"=>"Brick", "count"=>21} (), {"value"=>"wood", "count"=>16} (), {"value"=>"ductile iron", "count"=>8} (), {"value"=>"asphalt-coated", "count"=>5} (), {"value"=>"CMP", "count"=>5} (), {"value"=>"stone", "count"=>4} (), {"value"=>"concrete-lined", "count"=>3} ()
  • US Structure ID
    Text
    {"value"=>" ", "count"=>1861} (), {"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"=>113899, "code"=>"Yes"} (), {"value"=>" ", "count"=>11800, "code"=>" "} (), {"value"=>"Unknown", "count"=>6308, "code"=>"UNK"} (), {"value"=>"Unknown", "count"=>660, "code"=>"Unknown"} (), {"value"=>"No", "count"=>456, "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"=>112389, "code"=>"Yes"} (), {"value"=>"Unknown", "count"=>7225, "code"=>"UNK"} (), {"value"=>"Unknown", "count"=>711, "code"=>"Unknown"} (), {"value"=>" ", "count"=>356, "code"=>" "} (), {"value"=>"No", "count"=>320, "code"=>"No"} ()
  • Slope (%)
    Number
    -9999 to 1689.9945928
  • Standard Comments
    Text
    {"value"=>" ", "count"=>81407, "code"=>" "} (), {"value"=>"DS point is assumed (minimal attributes)", "count"=>3382, "code"=>"Pipe-DS point is assumed"} (), {"value"=>"US point is assumed (minimal attributes)", "count"=>2010, "code"=>"Pipe-US point is assumed"} (), {"value"=>"Null", "count"=>931, "code"=>"Null"} (), {"value"=>"Next structure not found", "count"=>722, "code"=>"Pipestub-Next structure not found"} (), {"value"=>"System not followed", "count"=>334, "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"=>"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"=>61} (), {"value"=>"Pipe data derived from Meck County info (SSM 10/12/2011) ", "count"=>53} ()
  • Path to photos/media
    Text
    {"value"=>" ", "count"=>70928} (), {"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