Description

more
Inventory of stormwater mains, laterals and culverts in unincorporated San Juan County WA.. This layer file is best used for map applications at a scale of 5,000 or less. Infrastructure in the Town of Friday Harbor are not included.

Dataset Attributes

  • OBJECTID
    Number
  • Shape
    Number
  • Pipe_ID
    Text
    {"value"=>"Pipe_OR835", "count"=>2} (), {"value"=>"Pipe_OR834", "count"=>2} (), {"value"=>"pipe_OR786", "count"=>2} (), {"value"=>"Pipe_OR519", "count"=>2} (), {"value"=>"Pipe_OR542", "count"=>2} (), {"value"=>"Pipe_OR517", "count"=>2} (), {"value"=>"Pipe_LZ055", "count"=>2} (), {"value"=>"Pipe_OR812", "count"=>2} (), {"value"=>"Pipe_OR548", "count"=>2} (), {"value"=>"Pipe_OR875", "count"=>1} ()
  • End1Strctr
    Text
    {"value"=>"Strctr_OR226", "count"=>3} (), {"value"=>"Strctr_OR274", "count"=>2} (), {"value"=>"Strctr_OR114", "count"=>2} (), {"value"=>"Strctr_OR078", "count"=>2} (), {"value"=>"Strctr_OR228", "count"=>2} (), {"value"=>"Strctr_OR227", "count"=>2} (), {"value"=>"Strctr_OR195", "count"=>2} (), {"value"=>"Strctr_LZ037", "count"=>2} (), {"value"=>"Strctr_LZ095", "count"=>2} (), {"value"=>"Strctr_OR001", "count"=>2} ()
  • End2Strctr
    Text
    {"value"=>"Strctr_OR230", "count"=>4} (), {"value"=>"Strctr_OR139", "count"=>4} (), {"value"=>"Strctr_OR196", "count"=>4} (), {"value"=>"Strctr_OR164", "count"=>4} (), {"value"=>"Strctr_OR104", "count"=>4} (), {"value"=>"Strctr_OR213", "count"=>4} (), {"value"=>"Strctr_LZ029", "count"=>4} (), {"value"=>"Strctr_OR195", "count"=>4} (), {"value"=>"Strctr_OR192", "count"=>4} (), {"value"=>"Strctr_OR282", "count"=>3} ()
  • End1_RteID
    Text
    {"value"=>"00004", "count"=>147} (), {"value"=>"00103", "count"=>70} (), {"value"=>"00001", "count"=>69} (), {"value"=>"00053", "count"=>62} (), {"value"=>"00018", "count"=>57} (), {"value"=>"00045", "count"=>49} (), {"value"=>"00051", "count"=>41} (), {"value"=>"00054", "count"=>39} (), {"value"=>"00002", "count"=>38} (), {"value"=>"00048", "count"=>36} ()
  • End1_MP
    Number
    0 to 16.284
  • End1Offset
    Number
    -82 to 67
  • End2_RteID
    Text
    {"value"=>"00004", "count"=>162} (), {"value"=>"00103", "count"=>72} (), {"value"=>"00053", "count"=>71} (), {"value"=>"00001", "count"=>68} (), {"value"=>"00018", "count"=>56} (), {"value"=>"00045", "count"=>54} (), {"value"=>"00051", "count"=>41} (), {"value"=>"00054", "count"=>41} (), {"value"=>"00002", "count"=>40} (), {"value"=>"00048", "count"=>37} ()
  • End2_MP
    Number
    0 to 16.283
  • End2Offset
    Number
    -69 to 69
  • Pipe_Class
    Text
    {"value"=>"Cross Culvert", "count"=>1062, "code"=>"Cross"} (), {"value"=>"Storm Main", "count"=>198, "code"=>"Main"} (), {"value"=>"Ditchline Culvert", "count"=>180, "code"=>"Ditchline"} (), {"value"=>"Storm Lateral", "count"=>146, "code"=>"Lateral"} (), {"value"=>"Other", "count"=>121, "code"=>"Other"} (), {"value"=>"French Drain", "count"=>51, "code"=>"French"} (), {"value"=>"Outfall", "count"=>17, "code"=>"Outfall"} (), {"value"=>"Abandoned or Removed", "count"=>10, "code"=>"Inactive"} ()
  • Diameter
    Number
    0 to 144
  • Material
    Text
    {"value"=>"Corrugated Metal Pipe", "count"=>652, "code"=>"CMP"} (), {"value"=>"Reinforced Concrete Pipe", "count"=>468, "code"=>"RCP"} (), {"value"=>"Double Wall Plastic", "count"=>360, "code"=>"DWP"} (), {"value"=>"Single Wall Plastic", "count"=>140, "code"=>"SWP"} (), {"value"=>"Unknown", "count"=>94, "code"=>"UNK"} (), {"value"=>"Other", "count"=>37, "code"=>"OTHER"} (), {"value"=>"Poured-In-Place Concrete", "count"=>19, "code"=>"PIP"} (), {"value"=>"Corrugated Metal Pipe with HDPE Liner", "count"=>6, "code"=>"CMP-L"} (), {"value"=>"Reinforced Concrete Pipe with HDPE Liner", "count"=>2, "code"=>"RCP-L"} ()
  • Length
    Number
    1 to 990
  • End1_Elev
    Number
    6.9 to 266.62
  • End2_Elev
    Number
    5.6 to 265.42
  • IE_Source
    Text
    {"value"=>"2014 Eastsound sw survey", "count"=>103} (), {"value"=>"2014 Eastsound SW survey", "count"=>52} (), {"value"=>"CRP plans", "count"=>39} (), {"value"=>"construction plans", "count"=>37} (), {"value"=>"as built", "count"=>11} (), {"value"=>"record drawings", "count"=>8} (), {"value"=>"final grading plans", "count"=>7} (), {"value"=>"as-built", "count"=>3} (), {"value"=>"2014 Eastound sw survey", "count"=>3} (), {"value"=>"E1 plans, E2 survey", "count"=>3} ()
  • End1_Type
    Text
    {"value"=>"standard", "count"=>1212, "code"=>"standard"} (), {"value"=>"structure", "count"=>458, "code"=>"structure"} (), {"value"=>"other", "count"=>9, "code"=>"other"} (), {"value"=>"beveled", "count"=>3, "code"=>"beveled"} (), {"value"=>"flared", "count"=>2, "code"=>"flared"} ()
  • End2_Type
    Text
    {"value"=>"standard", "count"=>1178, "code"=>"standard"} (), {"value"=>"structure", "count"=>550, "code"=>"structure"} (), {"value"=>"flared", "count"=>8, "code"=>"flared"} (), {"value"=>"other", "count"=>6, "code"=>"other"} (), {"value"=>"beveled", "count"=>1, "code"=>"beveled"} ()
  • End1_Equip
    Text
    {"value"=>"Trash Rack", "count"=>3, "code"=>"TRASH"} ()
  • End2_Equip
    Text
    {"value"=>"Trash Rack", "count"=>3, "code"=>"TRASH"} (), {"value"=>"Tide Gate", "count"=>1, "code"=>"TIDEGATE"} ()
  • Instl_Year
    Text
    {"value"=>"unknown", "count"=>1420} (), {"value"=>"2009", "count"=>50} (), {"value"=>"2005", "count"=>41} (), {"value"=>"1993?", "count"=>35} (), {"value"=>"1990?", "count"=>22} (), {"value"=>"2010", "count"=>19} (), {"value"=>"2013", "count"=>16} (), {"value"=>"pre-1999", "count"=>12} (), {"value"=>"1999", "count"=>12} (), {"value"=>"2008", "count"=>12} ()
  • History
    Text
    {"value"=>" ", "count"=>1417} (), {"value"=>"CRP 010181 2005", "count"=>33} (), {"value"=>"North Beach stromwater system installed 1993 CRP 020531?", "count"=>33} (), {"value"=>"installed Fisherman Bay CRP 2009", "count"=>17} (), {"value"=>"installed 2013 CRP020602", "count"=>10} (), {"value"=>"installed 2010 ST0805 - A St to Main Drainage Imp", "count"=>8} (), {"value"=>"installed 1999 CRP 020047", "count"=>7} (), {"value"=>"installed 2014 CRP? (A to Main phase 3B)", "count"=>6} (), {"value"=>"install 2010 CRP ST0804", "count"=>6} (), {"value"=>"installed Ench. Forest Rd Trail CRP020609", "count"=>6} ()
  • Notes
    Text
    {"value"=>" ", "count"=>975} (), {"value"=>"cross culvert/outfall", "count"=>26} (), {"value"=>"added per 2014 Eastsound sw survey", "count"=>9} (), {"value"=>"diameter per Nick T. drainage report for NBeach Rd", "count"=>9} (), {"value"=>"location adjusted per aerial photo", "count"=>9} (), {"value"=>"position adjusted per aerial photo", "count"=>9} (), {"value"=>"2014 added end1 elev & survey location", "count"=>7} (), {"value"=>"flow?", "count"=>7} (), {"value"=>"2014 confirmed pipe connections, size & flow direction per stormwater plans obtained from owner.", "count"=>6} (), {"value"=>"drain rock core, 5ft. width", "count"=>6} ()
  • File_Path
    Text
    {"value"=>" ", "count"=>84} (), {"value"=>"I:\\Assets\\Marine Facilities\\2_Orcas\\Orcas Island Ferry _WSF facility\\Drainage", "count"=>27} (), {"value"=>"I:\\Assets\\County Roads\\1_San Juan\\158\\0.00 _Golf Course Rd\\Drainage\\x_Other\\2008 Golf Course Basin drainage system", "count"=>17} (), {"value"=>"I:\\Assets\\County Roads\\1_San Juan\\007\\0.45 _Argyle Ave\\Drainage", "count"=>6} (), {"value"=>"I:\\Assets\\Trails and Paths\\2_Orcas\\TR086 _Enchanted Forest Roadside Path\\Drainage", "count"=>5} (), {"value"=>"W:\\Assets\\Easements and Infrastructure\\Orcas\\2 W_37 N\\Sec 14\\Mount to Main storm drain system\\Culverts\\Pipe_OR778", "count"=>2} (), {"value"=>"I:\\Assets\\County Roads\\2_Orcas\\004\\_8.12 _Main St\\Drainage\\Main St - Storm Mains\\Pipe_OR520", "count"=>2} (), {"value"=>"I:\\Assets\\County Roads\\2_Orcas\\053\\0.00 _North Beach Rd\\Drainage\\mile 0.0\\Culverts\\Pipe_OR565", "count"=>2} (), {"value"=>"I:\\Assets\\County Roads\\2_Orcas\\052\\0.00 _Lovers Ln\\Drainage\\Culverts\\Pipe_OR282", "count"=>2} (), {"value"=>"I:\\Assets\\County Roads\\2_Orcas\\266\\0.00 _Fern St\\Drainage\\Culverts\\Pipe_OR596", "count"=>2} ()
  • Island
    Text
    {"value"=>"Orcas", "count"=>870, "code"=>"Orcas"} (), {"value"=>"San Juan", "count"=>475, "code"=>"San Juan"} (), {"value"=>"Lopez", "count"=>378, "code"=>"Lopez"} (), {"value"=>"Shaw", "count"=>62, "code"=>"Shaw"} ()
  • Admin_Area
    Text
    {"value"=>"County (Roads)", "count"=>1563, "code"=>"COUNTY"} (), {"value"=>"Private", "count"=>163, "code"=>"PRIV"} (), {"value"=>"State", "count"=>27, "code"=>"STATE"} (), {"value"=>"County (Stormwater Utility)", "count"=>23, "code"=>"UTILITY"} (), {"value"=>"Port of Friday Harbor", "count"=>5, "code"=>"PORT-FH"} (), {"value"=>"County (Parks)", "count"=>3, "code"=>"PARKS"} (), {"value"=>"County Current Facilities", "count"=>1, "code"=>"FACILITIES"} ()
  • Systm_Name
    Text
    {"value"=>"Eastsound", "count"=>234, "code"=>"Eastsound"} (), {"value"=>"Olga", "count"=>23, "code"=>"Olga"} (), {"value"=>"Fairgrounds", "count"=>22, "code"=>"Fairgrounds"} (), {"value"=>"Mt Baker - North Beach", "count"=>18, "code"=>"MtBaker_NBeach"} (), {"value"=>"Lopez Village", "count"=>7, "code"=>"Lopez_Village"} ()
  • ID_Label
    Text
    {"value"=>"OR835", "count"=>2} (), {"value"=>"OR834", "count"=>2} (), {"value"=>"OR801", "count"=>2} (), {"value"=>"OR786", "count"=>2} (), {"value"=>"OR515", "count"=>2} (), {"value"=>"OR520", "count"=>2} (), {"value"=>"OR542", "count"=>2} (), {"value"=>"OR478", "count"=>2} (), {"value"=>"OR587", "count"=>2} (), {"value"=>"OR521", "count"=>2} ()
  • Type_Label
    Text
    {"value"=>"12\" x 40' CMP", "count"=>33} (), {"value"=>"12\" x 30' CMP", "count"=>23} (), {"value"=>"12\" x 32' RCP", "count"=>20} (), {"value"=>"4\" x ? French", "count"=>17} (), {"value"=>"12\" x 36' CMP", "count"=>16} (), {"value"=>"8\" x 30' CMP", "count"=>16} (), {"value"=>"12\" x 30' DWP", "count"=>16} (), {"value"=>"18\" x 40' CMP", "count"=>16} (), {"value"=>"12\" x 32' CMP", "count"=>16} (), {"value"=>"12\" x 30' RCP", "count"=>14} ()
  • LastUpdate
    Date
    1009843200000 to 1411507910000
  • DataSource
    Text
  • RuleID
    Number
  • Shape_Length
    Number
  • Status
    Text
  • Updated_By
    Text
  • CreateDate
    Date
  • Created_By
    Text

About

  • By on August 15, 2016
  • Updated 3 months ago

Related Datasets