The URL can be used to link to this page

Home My WebLink AboutCopy of R3430_Waters_Upload_Sheet FINAL� _ � ,1 �� d OMBIL Regulatory Module (ORM) Project Upload Template Version Date: 11-Jan-2018 Please be aware: if older versions of Microsoft Office or Excel are utilized with this template, the user may experience issues with the functionality and features of this template. Reminder: when using copy/paste to transfer data from one template to another, you must not use the regular paste functionality. This will cause formatting issues. Instead, use the "paste values" functionality. Change Log Current Version . limited list of Cowardin Code options to second and third tiers only 02-JUN-2016 Version • added a validation to check for garbage characters in the Waters Name column values of all worksheets 31-MAR-2016 Version • added a Version worksheet • AqResources worksheet - removed the dropdowns from the header cells • AqResources worksheet - standardized user functionality with the worksheets from other templates • AqResources worksheet - changed the format of columns I(Latitude) and J(Longitude) to be decimal formatted numers with 8 significant digits of precision • AqResources worksheet - added a Validation check to ensure Amount > zero . AqResources worksheet - add validation check requiring Water Type of Upland (Rapanos)/Dry Land (CWR) when Cowardin Code = U FINALIZE Please denote if sheet should be finalized Yes/No Aquatic Resources Waters_Name Catawba River SA SB SC SD SF SG SH SI SJ WA WB WC WD WE WF WG WH BA State NORTH CAROLINA NORTH CAROLINA NORTH CAROLINA NORTH CAROLINA NORTH CAROLINA NORTH CAROLINA NORTH CAROLINA NORTH CAROLINA NORTH CAROLINA NORTH CAROLINA NORTH CAROLINA NORTH CAROLINA NORTH CAROLINA NORTH CAROLINA NORTH CAROLINA NORTH CAROLINA NORTH CAROLINA NORTH CAROLINA NORTH CAROLINA Cowardin_Code L1UB R4SB R5U6 R5U6 R5UB R5U6 R5U6 RSUB R5U6 R5U6 PEM PFO PFO PFO PFO PFO PFO PFO HGM_Code RIVERINE RIVERINE RIVERINE RIVERINE RIVERINE RIVERINE RIVERINE RIVERINE RIVERINE RIVERINE RIVERINE RIVERINE RIVERINE RIVERINE RIVERINE RIVERINE RIVERINE RIVERINE Meas_Type Linear Linear Linear Linear Linear Linear Linear Linear Linear Linear Area Area Area Area Area Area Area Area Area Amount Units 2,551 FOOT 73 FOOT 1,588 FOOT 220 FOOT 131 FOOT 76 FOOT 507 FOOT 641 FOOT 21 FOOT 407 FOOT 0.02 ACRE 0.01 ACRE 0.01 ACRE 0.01 ACRE 0.06 ACRE 0.03 ACRE 0.18 ACRE 0.13 ACRE 0.1 ACRE Waters_Type DELINEATE DELINEATE DELINEATE DELINEATE DELINEATE DELINEATE DELINEATE DELINEATE DELINEATE DELINEATE DELINEATE DELINEATE DELINEATE DELINEATE DELINEATE DELINEATE DELINEATE DELINEATE IMPNDMNT Latitude 35.781099 35.760803 35.785290 35.783221 35.806752 35.829061 35.862528 35.863315 35.868583 35.868831 35.782572 35.784457 35.784757 35.784995 35.785364 35.786142 35.828975 35.868726 35.74016200 Longitude Local_Waterway -81.525873 Catawba River -81.527980 Catawba River -81.529562 Catawba River -81.529665 Catawba River -81.533346 Catawba River -81.534188 Catawba River -81.539539 Catawba River -81.539216 Catawba River -81.539780 Catawba River -81.539147 Catawba River -81.528447 Catawba River -81.529536 Catawba River -81.529587 Catawba River -81.529501 Catawba River -81.529589 Catawba River -81.529791 Catawba River -81.534155 Catawba River -81.539204 Catawba River -81.52630500 Catawba River Worksheet Column Cell Warning Column Headers in GREEN on UPLOAD Tab are Required or are Required to Finalize AQUATIC RESOURCES VALIDATION "Waters_Name" is required. "Waters_Name" must contain unique values. "State" is required. "Cowardin Code" is required. "Meas_Type" is required. "Amount" is required. "AmounY' must be greater than zero "Units" is required "Waters Type" is required "Latitude" is required. "Longitude" is required (negative value in western hemisphere). "Cowardin Code" of U(Uplands) must have associated "Waters Type" of Upland waters_Type �ELINEATE IMPNDMNT ISOLATE NRPW NRPWW RPW RPWWD RPWWN TNW TNWRPW TNWW UPLAND Description Delinealion Only - PJD or No JD Requiretl Impoundments Isola[ed (interslate or inUastate) waters, Including isolated wellands Non-RPWs Ihal flow dlreclly or Indlrectly into TNWs Wetlands adjacenl lo non-RPWs lhat Flow tlirectly or indirectly into TN Ws Relatively Permanent Waters (RPWs) thal flow direclly or indirectly into TNWs Wetlands direclly a6utting RPWs that flow directty or indirectly inlo TNWs Wetlands atljacent to bul not direclly abulting RPWs that flow directly or indireclly inlo TNWs TNWs, including territoriai seas Tributary consisting of bolh RPWs and non-RPWs Wetlands adjacenl lo TNWs Uplands HGM Code Name Description DEPRESS Depressional Depressional is charactenzed by a water source consisting of retum flow from groundwater and interflow with primarily vertical hydrodynamics. ESTLIARINEF Es[uarine Fringed The water source of the esWarine fringe consists of overbank Flow from estuaries, with bidirectional and horizonlal hydrodynamics heing dominant LACUSTRINF Lacustrine Fringe A Lacustrine fringe has a dominanl water source of lake overbank Flow, and Ihe dominanl hydrodynamics are bidlrectional and horizontal. MINSDILFLT Mineral Soil Flats Mineral soil Flats have a water source of precipitation, and vertical hydrodynamics are dominan�. ORGSOILFLT Organic Soil Flats Organic soil flats have precipitation as the water source, and its dominant hydrodynamic Is vertical. RIVERINE Riverine Riverine is characterized by a water source of overbank flow from a channel, and hydrodynamics which are Uredominantly unidirec�ional and horizontal. SLOPE Slope The Slope welland class is characlerized by a water source of reWrn Flow from groundwater, with principally unidlrectional and horizon[al hydrodynamics. Cowardin Code E1 E1AB E1OW E1RB E1RF E1UB E2 E2A6 E2EM E2F0 E2RF E2RS E2SB E2S5 E2US L1 L1A6 L1 OW LiR6 L1U6 L2 L2A8 L2EM 120W L2RB L2ftS L2U6 L2US M1 M1A6 MiOW MiRB MiRF M1UB M2 M2AB M2RF M2RS M2US PAB PA61 PAB2 PAB3 PAB4 PAB5 PA66 PEM PFO PML POW PRB PSS P118 R1 R1AB R1EM RiRe RiRS RiS6 R1UB RiL1S R2 R2AB R2EM R2RB R2R5 R2UB R2US R3 R3AB R3RB R3RS R3U8 R3U5 R4 R4SB R5 RSAB R5R6 RSRS RSUB RSUS R6 RP RP1 RPIEM RPIFO RP1SS RP2 RP2EM RP2F0 RP2SS u Category Estuarine Es[uarine Estuarine Estuarine Esluarine Es[uarine Es[uarine Es[uanne ESNanne Estuarine Estuarine EsNarine Esluarine Estuarine Estuarine Lacustrine Lacustrine LacusVine Lacustrine Lacushine Lacustrine Lacustrine Lacustrine Lacusirine Lacustrine Lacustrine Lacustrine Lacustrine Marine Marine Mar Mar Marine Marine Mar Mar Marine Marine Mar Palustrine Palustrine Palustrine Palustrine Palustrine Palustrine Palustrine Palustrine Palustrine Palustrine Palustrine Palustrine Palus[rine Palustrine Riverine Rive Rive Riverine Riverine Rive Rive Riverine Riverine Riverine Rive Riverine Rivenne Rive Rive Riverine Riverine Riverine Riverine Riverine Riverine Riverine Riverine Riverine Riverine Rive Riverine Riverine Riverine Rive Ripari Riparian ftiparian Ripari Ripan Ripari Riparan Ripari Ripari uuia�as Description Name Subtitlal, Esluarine Ei-ESTUARINE, SUBTIDAL Aquatic Betl, Estuarine E1A&ESTUARINE, SUBTIDAL. AQUATIC BED Open Water, Subtidal, Esluarine (used on older maps) E10W-ESTUARINE, SUBTIDAL. OPEN WATER Rock Bot[om. Subtidal, Estuarine E1R6-ESTUARINE. SUBTIDAL, ROCK BOTTOM Reef, Sub�itlal, Estuarine E1RF-ESTUARINE, SUBTIOAL, REEF Unconsolidated Bot[om. Subtidal, Estuarine Ei UB-ESTUARINE, SUBTIDAL UNCONSOLIDATED BOTTM Interlidal, Esivarine E2-ESTUARINE, INTERTIDAL Aquatic Bed, Intertidal. Estuarine E2A6-ESTUARINE. INTERTIDAL, AQUATIC BED Emergen�, Infertidal, Esluarine E2EM-ESTUARINE, INTERTI�AL, EMERGENT Forested. Interfidal. ESWarine E2F0-ESTUARINE. INTERTIDAL, FORESTED Reef, Intertidal, Estuarine E2RF-ESTUARINE, INTERTIDAL, REEF Rocky Shore. Intertidal, Estuarine E2RS-ESTUARINE, INTERTIDAL, ROCKY SHORE Slream Bed, Inlerlidal, Estuarine E2S&ESTUARINE, INTERTIDAL STREAM BE� Scrub-Shrub. Inlertldal, ESWarine E255-ESTUARINE, INTERTIDAL. SCRUB-SHRUB Unconsolidated Shore. Intertidal. EsNarine E2U5-ESTUARINE. INTERTIDAL. UNCONSOL SHORE Lacustrine - Includes wetlantls and deepwater habitats with all of the following characteristics: (i ) situated in a tol Li-LACUSTRINE, LIMNETIC Aquatic 6etl. Limnelic, Lacustrine LiA&LACUSTRINE, LIMNETIC, A�UA BE� Open Water/Unknown Bottom, Limnetic. Lacustrine (used on older maps) L10W-LACUSTRINE. LIMNETIC, OPEN WATERIUNK BOT Rock Botrom. Limnetic, Lacustrine LiRB-LACUSTRINE. LIMNETIC, ROCK BOTTOM Unconsotidated Bottom. Limnetic, LacusUine L1UB-LACUSTRINE. LIMNETIC, UNCONSOL BOTTOM Littorel, Lacustrine L2LACUSTRINE, LITTORAI AquatiC Bed, Llltorel, LaCuStrine L2A&LACUSTRINE. LITTORA�. AQUA BED Emergent Littoral, Lacushine L2EM-LACUSTRINE. LITTORAL. EMERGENT Open Water/Unknown Bottom, Littoral, Lacustrine �20W-LACUSTRINE, LITTORAL, OPEN WATER Rock 8otlom, Litloral, Lacuslrine L2R&LACUSTRINE, LITTORAL, ROCK BOTTOM ROCky Shore. Litloral, Lacuslfine L2RS-LACUSTRINE. LITTORAL. ROCKV SHORE Unconsolidated Bottom. Littoral. Lacusirine L2U8-LACUSTRINE. LITTORAL UNCONSOL BOT Unconsolidated Shore, Littoral. Lacustrine L2US-LACUSTRINE. LITTORAL UNCONSOL SHORE Subtitlal Marine Mi-MARINE, SUBTIDAL Aquatic Bed, Sublidal, Marine M1AB-MARINE, SUBTIDAL. AQUATIC 8ED Open Water. Subtidal, Marine (Used on older maps) M10W-MARINE. SUBTIDAL, OPEN WATER Rock Bottom Su6titlal Marine MiRB-MARINE, SUBTIDAL, ROCK BOTTOM Reef, Sublitlal, Marine MiRF-MARINE, SUBTIDAL. REEF Unconsolidated Botlom. Sublidal. Marine M1UB-MARINE, SUBTIDAL. UNCONSOLIDATED BOTTOM Intertidal. Marine M2-MARINE, INTERTIDAL Aquatic Bed, Intertidal, Marine M2AB-MARINE, INTERTIDAL, AQUATIC BED Reef, InlertiAal, Marine M2RF-MARINE, INTERTIOAL, REEF Rocky Shore. Inlertidal, Marine M2RS-MARINE, INTERTIDAL. ROCKV SHORE Unconsolida[ed Shore. Inlertidal. Marine M2US-MARINE. INTERTIDAL. UNCONSOLIDATED SHORE Aquatic Bed, Palusirine PAB-PALUSTRINE, A�UA BED Algal, Aqualic Bed, Paluslrine PABi-PALUSTRINE, A�UA BED, ALGAL Aquatic Moss, Aquatic Bed, Palusirine PAB2-PALUSTRINE. A�UA BED. AQUATIC MO55 Rooted Vascular, Aqua[ic Bed, Palusirine PAB3-PALUSTRINE. AQUA BED, ROOTED VASC Floaling Vascular, Aqualic Bed, Palushine PA64-PALUSTRINE. A�UA BED, FLOAT VASC Unknown Submergent Aquatic Bed, Palustrine PABS-PALUSTRME. AQUA BED. UNK SUB Unknown Surface, Aquatic Bed, Palustrine PAB6-PALUSTRINE. AQUA BED, UNK SURF Emergent, Palustrine PEM-PALUSTRINE. EMERGENT Forested, Palustrine PFO-PALUSTRINE, FORESTED Moss-Lichens, PaWsirine PML-PALUSTRINE, MOSS-LIGHENS POW-PALUSTRINE.OPEN WATER POW-PALUSTRINE,OPEN WATER Rock Botlom. Palustrine PRB-PALUSTR�NE. ROCK BOTTOM Scrub-Shrub. Palustrine PSS-PALUSTRINE, SCRUB-SHRUB Unconsolidated Bottom, Palustrine PUB-PALUSTRINE, UNCONSO� BOT Tldal. Riverine R1-RIVERINE.7I�AL Aquatic 8ed, Tidal. Riverine R1A6-RNERINE. TIDAL, A�UATIC BED Emergenl, Tidal, Riverine R1EM-RIVERINE, T�DAL, EMERGENT Rock 8otlom, Titlal, Riverine R1R8-RIVERINE. TIDAL. ROCK BOTTOM Rocky Shore. Tidal. Riverine RiRS-RIVERINE. TIDAL. ROCKY SHORE Streambed. Tidal. Riverine R156-RIVERINE. TIDAL, STREAMBED Unconsolidated Bottom. Tidal, Riverine R1U6-RIVERINE, TIDAL, UNCONSOLIDATED BOTTOM Unconsolidated Shore, Tidal, Riverine R1US-RIVERINE, TIDAL, UNCONSOL SHORE Lower Perennial, Riverine R2-RIVERINE, LOWER PERENNIAL Aquatic Bed. LowerTidal. Riverine R2A6-RIVERINE. LOWER PEREN, AQUA BED Emergent, Lower Tidal, Riverine R2EM-RIVERINE, LOWER PEREN. EMERGENT Rock Botlom. Lower Perennial. Riverine R2R6-RIVERINE, LOWER PEREN, ROCK BOTTOM Rocky Shore. Lower Tidai, Riverine R2RS-RIVERINE. LOWER PEREN. ROCKV SHORE Unconcolidated Bottom, Lower Perennial. Riverine R2U8-RIVERINE, LOWER PEREN, UNCONSOL BOT Umm�solidated Shore, Lower Tidal. Riverine R2US-RIVERINE, LOWER PEREN. UNCONSOL SHORE Upper Perennial, Riverine R3-RIVERINE, UPPER PERENNIAL Aquatic Bed, Upper Perennial, Riverine R3A6-RIVERINE, UPPER PEREN. AQUA BED Rock Bottom. Upper Perennial. Riverine R3R6-RIVERINE, UPPER PEREN, ROCK BOTTOM Racky Shore. Upper Perennial, Riverine R3RS-RIVERINE, UPPER PEREN, ROCKY SHORE Unconsolitlatetl Botlom, Upper Perennial, Riverine R3U8-RIVERINE, UPPER PEREN, UNCONSOL BOT Unconsolidaled Shore, Upper Perennial, Riverine R3U5-RIVERINE, UPPER PEREN, UNCONSOL SHR Intermittenl, Riverine R4-RIVERINE, INTERMIT Sheam6ed. Intermittent, Riverine R450-RNERINE, INTERMIT, STREAMBED Unknown Perennial, Riverine RS-RIVERWE UNKNOWN PERENNIAL Aquatic Bed, Unknown Perennial, Riverine RSAB-RIVERINE. UNK PEREN. A�UA BED Rock Bottom. Unknown Perennial, Riverine RSRB-RNERINE. UNK PEREN. ROCK 80170M Rocky Shore. Unknown Perennial, Riverine RSRS-RiVERINE. UNK PEREN. ROCKY SHORE Unconsolidated Botlom. Unknown Perennial. Rivenne RSUB-RIVERINE. UNK PEREN. 11NCONSOLiDATEO BOTTOM Unconsolidated Shore. Unknown Perennial. Riverine RSUS-RNERINE. UNK PEREN. UNCONCOL SHORE A wetland. spring, stream, river. pond or lake that onty exists for a short penod R6 - RNERINE, EPHEMERAL Riparian - Plant communities contiguous to and affected 6y surtace and su6surface hydro�ogic features of perenn RP-RIPARIAN Lotic, Riparian RPi-RIPARIAN, LOTIC Emergenl. Lotic. Ripanan RP1EM-RIPARIAN. LOTIC. EMERGENT Forested, Lotic, Riparian RPiFO-RIPARIAN. LOTIC, FORESTED Scrub-Shrub, Lotic. Riparian RP1SS-RIPARIAN. LOTIC. SCRUB-SHRl16 Lentic, Rlparian RP2-RIPARIAN, LENTIC EmerqenL Lenlic, Riparian RP2EM-RIPARIAN. LENTIC, EMERGEN7 Forested, Lentic. Rlparian RP2F0-RIPARIAN. LENTIC, FORESTED Scrub-Shru6. Lentic, Rlparian RP2SS-RIPARIAN, LENTIC, SCRUB-SHRUB Upland - Not a wetland or deepwater habitat of the United Sta[es as described by Cowardin. U-UPLAN�S