The URL can be used to link to this page

Home My WebLink About2621Burton_ORM_Upload_Sheet_Consolidated_2023Rule_20230320.xlsm 3/20/2023 5/15/2022 2/25/2022 1/30/2022 11/24/2021 10/17/2021 3/12/2021 11/9/2020 5/22/2018 0.02 36.029077999999998 -78.819164999999998 0.01 36.028399999999998 -78.82038 4.0000000000000001E-3 36.026485999999998 -78.818951999999996 0.22 36.027422000000001 -78.818904000000003 0.45 36.027636999999999 -78.819764000000006 0.03 36.025359999999999 -78.818550000000002 0.05 36.025613999999997 -78.817856000000006 0.19 36.024707999999997 -78.816485 0.22 36.024469000000003 -78.815787999999998 0.11 36.023867000000003 -78.814746 0.02 36.023668000000001 -78.814924000000005 1.1200000000000001 36.029907999999999 -78.812695000000005 0.01 36.029907999999999 -78.812695000000005 0.08 36.029589999999999 -78.812095999999997 0.23 36.025579999999998 -78.814683000000002 0.06 36.026474 -78.814250000000001 1E-3 36.026673000000002 -78.814046000000005 0.91 36.032314 -78.812864000000005 0.53 36.031824 -78.814003 0.24 36.030838000000003 -78.816558000000001 0.18 36.029452999999997 -78.819968000000003 1E-3 36.029333999999999 -78.820025999999999 7.0000000000000007E-2 36.029007 -78.819747000000007 4.0000000000000001E-3 36.028725000000001 -78.820079000000007 8.0000000000000002E-3 36.029415 -78.818579999999997 5.0000000000000001E-3 36.029850000000003 -78.817947000000004 7.0000000000000007E-2 36.030411000000001 -78.817786999999996 0.03 36.029845999999999 -78.818423999999993 0.36 36.032651000000001 -78.813931999999994 8.0000000000000002E-3 36.033394999999999 -78.813098999999994 7.0000000000000007E-2 36.032705 -78.813246000000007 0.28000000000000003 36.031396999999998 -78.816950000000006 2E-3 36.030397999999998 -78.818389999999994 0.02 36.030478000000002 -78.818492000000006 0.48 36.032038999999997 -78.815647999999996 0.06 36.027586999999997 -78.814186000000007 804 36.028255999999999 -78.820330999999996 3055 36.029929000000003 -78.818734000000006 50 36.028601999999999 -78.820451000000006 1126 36.025139000000003 -78.817203000000006 730 36.025539000000002 -78.818866999999997 55 36.025590999999999 -78.818704999999994 468 36.027228000000001 -78.818314999999998 401 36.029179999999997 -78.819931999999994 70 36.029203000000003 -78.819680000000005 124 36.031441999999998 -78.816427000000004 558 36.032007999999998 -78.815370999999999 1784 36.031351000000001 -78.813598999999996 675 36.029725999999997 -78.812291999999999 192 36.028989000000003 -78.812089999999998 Waters_Name Cowardin_Code HGM_Code Waters_Type Units_Area Units_Linear DEPRESS Area ACRE FOOT E1 ESTUARINEF Linear E1AB LACUSTRINF SQ_FT MINSOILFLT ORGSOILFLT RIVERINE SLOPE E1OW E1RB E1RF E1UB E2 E2AB E2EM E2FO E2RF E2RS E2SB E2SS E2US L1 L1AB L1OW L1RB L1UB L2 L2AB L2EM L2OW L2RB L2RS L2UB L2US M1 M1AB M1OW M1RB M1RF M1UB M2 M2AB M2RF M2RS M2US PAB PAB1 PAB2 PAB3 PAB4 PAB5 PAB6 PEM PFO PML POW PRB PSS PUB RP RP1 RP1EM RP1FO RP1SS RP2 RP2EM RP2FO RP2SS R1 R1AB R1EM R1RB R1RS R1SB R1UB R1US R2 R2AB R2EM R2RB R2RS R2UB R2US R3 R3AB R3RB R3RS R3UB R3US R4 R4SB R5 R5AB R5RB R5RS R5UB R5US R6 U VALIDATION "Waters_Name" is required. "Waters_Name" must contain unique values. "Cowardin Code" is required. "Amount" is required. "Units" is required "Waters Type" is required AQUATIC RESOURCES VALIDATION Description Uplands Name Depressional Depressional is characterized by a water source consisting of return flow from groundwater and interflow with primarily vertical hydrodynamics. Estuarine Fringed The water source of the estuarine fringe consists of overbank flow from estuaries, with bidirectional and horizontal hydrodynamics being dominant. Lacustrine Fringe A Lacustrine fringe has a dominant water source of lake overbank flow, and the dominant hydrodynamics are bidirectional and horizontal. Mineral Soil Flats Mineral soil flats have a water source of precipitation, and vertical hydrodynamics are dominant. Organic Soil Flats Organic soil flats have precipitation as the water source, and its dominant hydrodynamic is vertical. Riverine Riverine is characterized by a water source of overbank flow from a channel, and hydrodynamics which are predominantly unidirectional and horizontal. Slope The Slope wetland class is characterized by a water source of return flow from groundwater, with principally unidirectional and horizontal hydrodynamics. Category Estuarine Subtidal, Estuarine E1-ESTUARINE, SUBTIDAL Aquatic Bed, Estuarine E1AB-ESTUARINE, SUBTIDAL, AQUATIC BED Open Water, Subtidal, Estuarine (used on older maps) E1OW-ESTUARINE, SUBTIDAL, OPEN WATER Rock Bottom, Subtidal, Estuarine E1RB-ESTUARINE, SUBTIDAL, ROCK BOTTOM Reef, Subtidal, Estuarine E1RF-ESTUARINE, SUBTIDAL, REEF Unconsolidated Bottom, Subtidal, Estuarine E1UB-ESTUARINE, SUBTIDAL UNCONSOLIDATED BOTTM Intertidal, Estuarine E2-ESTUARINE, INTERTIDAL Aquatic Bed, Intertidal, Estuarine E2AB-ESTUARINE, INTERTIDAL, AQUATIC BED Emergent, Intertidal, Estuarine E2EM-ESTUARINE, INTERTIDAL, EMERGENT Forested, Intertidal, Estuarine E2FO-ESTUARINE, INTERTIDAL, FORESTED Reef, Intertidal, Estuarine E2RF-ESTUARINE, INTERTIDAL, REEF Rocky Shore, Intertidal, Estuarine E2RS-ESTUARINE, INTERTIDAL, ROCKY SHORE Stream Bed, Intertidal, Estuarine E2SB-ESTUARINE, INTERTIDAL, STREAM BED Scrub-Shrub, Intertidal, Estuarine E2SS-ESTUARINE, INTERTIDAL, SCRUB-SHRUB Unconsolidated Shore, Intertidal, Estuarine E2US-ESTUARINE, INTERTIDAL, UNCONSOL SHORE Lacustrine Lacustrine - Includes wetlands and deepwater habitats with all of the following characteristics: (1) situated in a topographic depression or a dammed river channel; (2) lacking trees, shrubs, persistent emergents, emergent mosses or lichens with greater than 30% areal coverage; and (3) total area exceeds 8 ha (20 acres). Similar wetland and deepwater habitats totaling less than 8 ha are also included in the Lacustrine System if an active wave-formed or bedrock shoreline feature makes up all or part of the boundary, or if the water depth in the deepest part of the basin exceeds 2 m (6.6 feet) at low water. Lacustrine waters may be tidal or nontidal, but ocean-derived salinity is always less than 0.5%. L1-LACUSTRINE, LIMNETIC Aquatic Bed, Limnetic, Lacustrine L1AB-LACUSTRINE, LIMNETIC, AQUA BED Open Water/Unknown Bottom, Limnetic, Lacustrine (used on older maps) L1OW-LACUSTRINE, LIMNETIC, OPEN WATER/UNK BOT Rock Bottom, Limnetic, Lacustrine L1RB-LACUSTRINE, LIMNETIC, ROCK BOTTOM Unconsolidated Bottom, Limnetic, Lacustrine L1UB-LACUSTRINE, LIMNETIC, UNCONSOL BOTTOM Littoral, Lacustrine L2-LACUSTRINE, LITTORAL Aquatic Bed, Littoral, Lacustrine L2AB-LACUSTRINE, LITTORAL, AQUA BED Emergent, Littoral, Lacustrine L2EM-LACUSTRINE, LITTORAL, EMERGENT Open Water/Unknown Bottom, Littoral, Lacustrine L2OW-LACUSTRINE, LITTORAL, OPEN WATER Rock Bottom, Littoral, Lacustrine L2RB-LACUSTRINE, LITTORAL, ROCK BOTTOM Rocky Shore, Littoral, Lacustrine L2RS-LACUSTRINE, LITTORAL, ROCKY SHORE Unconsolidated Bottom, Littoral, Lacustrine L2UB-LACUSTRINE, LITTORAL, UNCONSOL BOT Unconsolidated Shore, Littoral, Lacustrine L2US-LACUSTRINE, LITTORAL, UNCONSOL SHORE Marine Subtidal Marine M1-MARINE, SUBTIDAL Aquatic Bed, Subtidal, Marine M1AB-MARINE, SUBTIDAL, AQUATIC BED Open Water, Subtidal, Marine (Used on older maps) M1OW-MARINE, SUBTIDAL, OPEN WATER Rock Bottom Subtidal Marine M1RB-MARINE, SUBTIDAL, ROCK BOTTOM M1RF-MARINE, SUBTIDAL, REEF Unconsolidated Bottom, Subtidal, Marine M1UB-MARINE, SUBTIDAL, UNCONSOLIDATED BOTTOM Intertidal, Marine M2-MARINE, INTERTIDAL Aquatic Bed, Intertidal, Marine M2AB-MARINE, INTERTIDAL, AQUATIC BED Reef, Intertidal, Marine M2RF-MARINE, INTERTIDAL, REEF Rocky Shore, Intertidal, Marine M2RS-MARINE, INTERTIDAL, ROCKY SHORE Unconsolidated Shore, Intertidal, Marine M2US-MARINE, INTERTIDAL, UNCONSOLIDATED SHORE Palustrine Aquatic Bed, Palustrine PAB-PALUSTRINE, AQUA BED Algal, Aquatic Bed, Palustrine PAB1-PALUSTRINE, AQUA BED, ALGAL Aquatic Moss, Aquatic Bed, Palustrine PAB2-PALUSTRINE, AQUA BED, AQUATIC MOSS Rooted Vascular, Aquatic Bed, Palustrine PAB3-PALUSTRINE, AQUA BED, ROOTED VASC Floating Vascular, Aquatic Bed, Palustrine PAB4-PALUSTRINE, AQUA BED, FLOAT VASC Unknown Submergent, Aquatic Bed, Palustrine PAB5-PALUSTRINE, 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, Palustrine PML-PALUSTRINE, MOSS-LICHENS POW-PALUSTRINE, OPEN WATER Rock Bottom, Palustrine PRB-PALUSTRINE, ROCK BOTTOM Scrub-Shrub, Palustrine PSS-PALUSTRINE, SCRUB-SHRUB Unconsolidated Bottom, Palustrine PUB-PALUSTRINE, UNCONSOL BOT Riparian Riparian - Plant communities contiguous to and affected by surface and subsurface hydrologic features of perennial or intermittent lotic and lentic water bodies (rivers, streams, lakes, or drainage ways). Riparian areas have one or both of the following characteristics: 1) distinctively different vegetative species than adjacent areas, and 2) species similar to adjacent areas but exhibiting more vigorous or robust growth forms. Riparian areas are usually transitional between wetland and upland. RP-RIPARIAN Lotic, Riparian RP1-RIPARIAN, LOTIC Emergent, Lotic, Riparian RP1EM-RIPARIAN, LOTIC, EMERGENT Forested, Lotic, Riparian RP1FO-RIPARIAN, LOTIC, FORESTED Scrub-Shrub, Lotic, Riparian RP1SS-RIPARIAN, LOTIC, SCRUB-SHRUB Lentic, Riparian RP2-RIPARIAN, LENTIC Emergent, Lentic, Riparian RP2EM-RIPARIAN, LENTIC, EMERGENT Forested, Lentic. Riparian RP2FO-RIPARIAN, LENTIC, FORESTED Scrub-Shrub, Lentic, Riparian RP2SS-RIPARIAN, LENTIC, SCRUB-SHRUB Tidal, Riverine R1-RIVERINE, TIDAL Aquatic Bed, Tidal, Riverine R1AB-RIVERINE, TIDAL, AQUATIC BED Emergent, Tidal, Riverine R1EM-RIVERINE, TIDAL, EMERGENT Rock Bottom, Tidal, Riverine R1RB-RIVERINE, TIDAL, ROCK BOTTOM Rocky Shore, Tidal, Riverine R1RS-RIVERINE, TIDAL, ROCKY SHORE Streambed, Tidal, Riverine R1SB-RIVERINE, TIDAL, STREAMBED Unconsolidated Bottom, Tidal, Riverine R1UB-RIVERINE, TIDAL, UNCONSOLIDATED BOTTOM Unconsolidated Shore, Tidal, Riverine R1US-RIVERINE, TIDAL, UNCONSOL SHORE Lower Perennial, Riverine R2-RIVERINE, LOWER PERENNIAL Aquatic Bed, Lower Tidal, Riverine R2AB-RIVERINE, LOWER PEREN, AQUA BED Emergent, Lower Tidal, Riverine R2EM-RIVERINE, LOWER PEREN, EMERGENT Rock Bottom, Lower Perennial, Riverine R2RB-RIVERINE, LOWER PEREN, ROCK BOTTOM Rocky Shore, Lower Tidal, Riverine R2RS-RIVERINE, LOWER PEREN, ROCKY SHORE Unconcolidated Bottom, Lower Perennial, Riverine R2UB-RIVERINE, LOWER PEREN, UNCONSOL BOT Unconsolidated Shore, Lower Tidal, Riverine R2US-RIVERINE, LOWER PEREN, UNCONSOL SHORE Upper Perennial, Riverine R3-RIVERINE, UPPER PERENNIAL Aquatic Bed, Upper Perennial, Riverine R3AB-RIVERINE, UPPER PEREN, AQUA BED Rock Bottom, Upper Perennial, Riverine R3RB-RIVERINE, UPPER PEREN, ROCK BOTTOM Rocky Shore, Upper Perennial, Riverine R3RS-RIVERINE, UPPER PEREN, ROCKY SHORE Unconsolidated Bottom, Upper Perennial, Riverine R3UB-RIVERINE, UPPER PEREN, UNCONSOL BOT Unconsolidated Shore, Upper Perennial, Riverine R3US-RIVERINE, UPPER PEREN, UNCONSOL SHR Intermittent, Riverine R4-RIVERINE, INTERMIT Streambed, Intermittent, Riverine R4SB-RIVERINE, INTERMIT, STREAMBED Unknown Perennial, Riverine R5-RIVERINE, UNKNOWN PERENNIAL Aquatic Bed, Unknown Perennial, Riverine R5AB-RIVERINE, UNK PEREN, AQUA BED Rock Bottom, Unknown Perennial, Riverine R5RB-RIVERINE, UNK PEREN, ROCK BOTTOM Rocky Shore, Unknown Perennial, Riverine R5RS-RIVERINE, UNK PEREN, ROCKY SHORE Unconsolidated Bottom, Unknown Perennial, Riverine R5UB-RIVERINE, UNK PEREN, UNCONSOLIDATED BOTTOM Unconsolidated Shore, Unknown Perennial, Riverine R5US-RIVERINE, UNK PEREN, UNCONCOL SHORE A wetland, spring, stream, river, pond or lake that only exists for a short period R6 - RIVERINE, EPHEMERAL Upland - Not a wetland or deepwater habitat of the United States as described by Cowardin. U-UPLANDS Activity Resource_Type Permanent_Loss Impact_Duration Debits Notes VALID MEASUREMENT SETS Conversion of waters type (forested wetland to emergent wetland, stream to lake) Discharge of dredged material Discharge of fill material Ecological restoration OTHER VALIDATIONS "Waters_Name" must correspond to "Waters_Name" provided within the aquatic resource shapefiles. "Waters_Name" must correspond to "nwp.xls"."Upload"."Waters_Name" when permits are also uploaded "Name" is required "Activity Type" is required "Resource Type" is required "Permanent Loss" is required "Impact Duration" is required "Area Type" is required when Area Amounts are entered "Area Type" can only be structure when Activity = Structure. "Units of Measure" is required IMPACT VALIDATION Dredging (Section 10) Lake YES Permanent Non-Tidal Wetland NO Temporary Other Pond River/Stream Tidal Wetland Harbor/Ocean Mitigation_Type Permittee_Responsible_Type Mitigation_Kind Comments VALIDATIONS "Waters_Name" must correspond to "nwp.xls"."Upload"."Waters_Name" when a permit is also uploaded "Mitigation Type" is required "Permittee Responsible Type" is required "Bank Name or Program Name" is required "Proposed Credits" is required "Required Credits" is required Mitigation_Type_P Mitigation_Type_M Permittee Responsible (off-site) Permittee Responsible (on-site) In-Lieu Fee Mitigation Bank Establishment Re-establishment Enhancement Rehabilitation Preservation In Kind Out of Kind Bank_OR_Program_Name Proposed_Credits Required_Credits Purchased_Credits "Waters_Name" must correspond to "impact.xls"."Upload"."Waters_Name" if impacts will also be uploaded. "Waters_Name" must correspond to "mitigation.xls"."Upload"."Waters_Name" if mitigation will also be uploaded. CD Receipt of Fed Complete Application is required. CD Determined Complete by PM is required. EVALCKLST ESA Coordination is required. EVALCKLST EFH Coordination is required. EVALCKLST Tribal Consulation is required. EVALCKLST Wild & Scenic River is required. EVALCKLST WQC is required. EVALCKLST CZM is required. NWP ID is required. Begin Date is required. Is this a Pre-Construction Notification? is required. Permit_Authority is required. Is Compensatory Mitigation Required? is required. Is the Mitigation Permittee Responsible? is required. Date Permit Expires is required. End Date is required. Closure Method is required. WRDA 214, Regulator Funded (Corps) is required. WorkType 1 is required. NWP VALIDATION No Resources Present Resources Present/No Effect Resources Present/Consultation Required Coordination Required Not Required Consultation NWP_ID Permit_Authority Section 10 Section 10/103 Section 10/404 Section 10/404/103 Section 103 Section 404 Section 404/103 Section 9 Closure_Method Denied Without Prejudice Discretionary Authority Exceeded Corps Review Time Limit, Verified By Default Verified Without Special Conditions Withdrawn Withdrawn By Applicant Withdrawn Due To No Permit Required (NPR) Withdrawn For Enforcement Action Withdrawn To Become A Standard Permit WorkType AGRICULTURE \ CONVERSION AGRICULTURE \ NON-EXEMPT AQUACULTURE \ FINFISH AQUACULTURE \ PLANTS AQUACULTURE \ SHELLFISH DEVELOPMENT \ ASSOCIATED INFRASTRUCTURE DEVELOPMENT \ COMMERCIAL DEVELOPMENT \ INDUSTRIAL DEVELOPMENT \ RECREATIONAL DEVELOPMENT \ RESIDENTIAL \ MULTI- FAMILY DEVELOPMENT \ RESIDENTIAL \ SINGLE FAMILY DREDGING \ BOAT SLIP DREDGING \ CHANNELIZATION DREDGING \ DISPOSAL DREDGING \ GENERAL DREDGING \ MAINTENANCE DREDGING \ NAVIGATION \ FEDERAL SPONSOR DREDGING \ NAVIGATION \ PRIVATE ENERGY GENERATION \ COAL ENERGY GENERATION \ COGEN ENERGY GENERATION \ GEOTHERMAL ENERGY GENERATION \ HYDROPOWER ENERGY GENERATION \ KINETIC ENERGY GENERATION \ NATURAL GAS ENERGY GENERATION \ NUCLEAR ENERGY GENERATION \ OIL ENERGY GENERATION \ SOLAR ENERGY GENERATION \ WIND MINING AND DRILLING \ DRILLING \ ACCESS MINING AND DRILLING \ DRILLING \ FACILITIES MINING AND DRILLING \ DRILLING \ GAS MINING AND DRILLING \ DRILLING \ OIL MINING AND DRILLING \ DRILLING \ SHALE GAS MINING AND DRILLING \ MINING \ ACCESS MINING AND DRILLING \ MINING \ COAL \ MINE THROUGH MINING AND DRILLING \ MINING \ COAL \ REFUSE FILL MINING AND DRILLING \ MINING \ COAL \ REMINING MINING AND DRILLING \ MINING \ COAL \ UNDERGROUND MINING AND DRILLING \ MINING \ COAL \ VALLEY FILL MINING AND DRILLING \ MINING \ FACILITES MINING AND DRILLING \ MINING \ GRAVEL MINING AND DRILLING \ MINING \ OTHER MINERAL MINING AND DRILLING \ MINING \ PEAT MINING AND DRILLING \ MINING \ PHOSPHATE MINING AND DRILLING \ MINING \ ROCK MINING AND DRILLING \ MINING \ SAND MITIGATION \ CREATION MITIGATION \ ENHANCEMENT MITIGATION \ FISH/WILDLIFE \ CREATION MITIGATION \ FISH/WILDLIFE \ ENHANCEMENT MITIGATION \ FISH/WILDLIFE \ PLANTING MITIGATION \ FISH/WILDLIFE \ PRESERVATION MITIGATION \ FISH/WILDLIFE \ RESTORATION MITIGATION \ FISH/WILDLIFE \ SEEDING MITIGATION \ MITIGATION BANK MITIGATION \ PRESERVATION MITIGATION \ RESTORATION \ STREAM MITIGATION \ RESTORATION \ WETLAND MITIGATION \ WETLAND RECLAMATION OTHER \ BANK STABILIZATION OTHER \ CLEANUP HAZARDOUS OR TOXIC WASTES OTHER \ DAMS \ COFFER OTHER \ DAMS \ GENERAL OTHER \ DAMS \ LOW WATER OTHER \ DAMS \ MAINTENANCE OTHER \ DAMS \ REMOVAL OTHER \ DAMS \ RESERVOIR OTHER \ DAMS \ WEIR OTHER \ INDIAN TRIBE OR STATE 404 PROGRAM OTHER \ MOSQUITO DITCHING OTHER \ OCEAN DISPOSAL OTHER \ RESTRICTED AREAS OTHER \ SURVEY ACTIVITIES OTHER \ TREASURE HUNTING STRUCTURE \ AIDS TO NAVIGATION STRUCTURE \ BOAT HOUSE STRUCTURE \ BOAT LIFT STRUCTURE \ BOAT RAMP STRUCTURE \ BREAKWATER STRUCTURE \ BRIDGE/RELATED WORK STRUCTURE \ BULKHEAD STRUCTURE \ CRIB STRUCTURE \ DOCK \ FIXED STRUCTURE \ DOCK \ FLOATING STRUCTURE \ DOLPHINS STRUCTURE \ ELEV REC DECK STRUCTURE \ GABION STRUCTURE \ GROIN STRUCTURE \ INTAKE/OUTFALL STRUCTURE \ MAINTENANCE STRUCTURE \ MARINA STRUCTURE \ MARINE RAIL STRUCTURE \ MISCELLANEOUS STRUCTURE \ MOORED BARGE STRUCTURE \ MOORED VESSELS STRUCTURE \ MOORING BOUY STRUCTURE \ MOORING PILING STRUCTURE \ NAVIGATION BUOY STRUCTURE \ PIER \ NON-RESIDENTIAL STRUCTURE \ PIER \ RESIDENTIAL STRUCTURE \ PILE/DOLPHIN STRUCTURE \ RAMP STRUCTURE \ RECREATIONAL STRUCTURE \ REMOVAL STRUCTURE \ SCIENTIFIC DEVICE STRUCTURE \ UNSPECIFIED STRUCTURE \ UTILITY LINE OR STRUCTURE STRUCTURE \ WATER CONTROL STRUCTURE \ WEIR TRANSPORTATION \ AIRPORT \ FACILITY TRANSPORTATION \ AIRPORT \ MAINTENANCE TRANSPORTATION \ AIRPORT \ RUNWAY TRANSPORTATION \ BRIDGE \ CONSTRUCTION (NEW) TRANSPORTATION \ BRIDGE \ MAINTENANCE TRANSPORTATION \ BRIDGE \ PIER TRANSPORTATION \ BRIDGE \ PROTECTION TRANSPORTATION \ BRIDGE \ REMOVAL TRANSPORTATION \ BRIDGE \ REPLACEMENT TRANSPORTATION \ PIPELINE \ ACCESS ROAD TRANSPORTATION \ PIPELINE \ AERIAL TRANSPORTATION \ PIPELINE \ BURIED TRANSPORTATION \ PIPELINE \ MAINTENANCE TRANSPORTATION \ PIPELINE \ STRUCTURE TRANSPORTATION \ PIPELINE \ SUBMERGED TRANSPORTATION \ RAIL \ BRIDGE TRANSPORTATION \ RAIL \ FACILITY TRANSPORTATION \ RAIL \ MAINTENANCE TRANSPORTATION \ RAIL \ REMOVAL TRANSPORTATION \ RAIL \ TRACK TRANSPORTATION \ ROADS \ AGRICULTURE TRANSPORTATION \ ROADS \ CROSSING (NON BRIDGE) TRANSPORTATION \ ROADS \ CULVERT TRANSPORTATION \ ROADS \ IMPROVEMENTS TRANSPORTATION \ ROADS \ LOGGING TRANSPORTATION \ ROADS \ MAINTENANCE TRANSPORTATION \ UTILITY \ ACCESS ROAD TRANSPORTATION \ UTILITY \ AERIAL TRANSPORTATION \ UTILITY \ BURIED TRANSPORTATION \ UTILITY \ MAINTENANCE TRANSPORTATION \ UTILITY \ STRUCTURE TRANSPORTATION \ UTILITY \ SUBMERGED CD_Rcpt_Fed_Complete_App CD_Determined_Complete_by_PM EVALCKLST_ESA_Coordination EVALCKLST_EFH_Coordination EVALCKLST_Tribal_Consult EVALCKLST_Wild_Scenic_River EVALCKLST_WQC EVALCKLST_CZM Project_Description Pre_Construction_Notification After_The_Fact_Permit Any_Work_Complete Compensatory_Mitigation_Reqd Mitigation_Permittee_Responsib WRDA_214_Funded_Corps WorkType_1 WorkType_2 WorkType_3 Begin_Date Authority End_Date None Closure_Method_JD Approved JD That Did Not Require A Field/Site Visit Approved JD That Did Require A Field/Site Visit No JD Required Preliminary JD That Did Not Require A Field/Site Visit Preliminary JD That Did Require A Field/Site Visit Only a single JD is expected for all aquatic resources - However if 1 JD is used per permit, enter a unique waters_name per row "Begin Date" is required. "Closure Method" is required. "End Date" is required. "WRDA 214, Regulator Funded (Corps)" is required. MITIGATION - PERMITTEE RESPONSIBLE VALIDATION MITIGATION - MITIGATION BANK/IN-LIEU FEE PROGRAM VALIDATION PERMIT_TYPE is required. PERMIT_NAME_NUMBER is required. Issued By is required. Date Permit Expires is required (but is based on the Permit Name Number selected). Date Verification Expires is required. RGP_PGP VALIDATION Permit_Type RGP PGP Issued_By CORPS LOCAL OTHER STATE Permit_Name_Number Acres Units_Area2 Units_Linear2 Square Feet Feet YES_NO Permit_Past_Use Date_Verification_Expires Date_Decision_Mailed Column Headers in GREEN on UPLOAD Tab are Required or are Required to Finalize Area or Linear "Amounts" (initialy proposed, proposed, authorized) are required Impacts NWP Mitigation-Permittee Responsible Mitigation Bank / ILF RGP / PGP Structure (Sec 10 only) Recapture Applies Does Not Apply EVALCKLST_Recapture Credit_Unit Credit_Unit_ILF Credit_Unit_MB Acre Based Linear Feet Based Assessment Based Advanced Credit Meas_Type "Meas_Type" is required. "Credit Unit" is required EVALCKLST Recapture is required Public_JD_URL State Amount Units Latitude Longitude Local_Waterway Aquatic Resources ALASKA ARIZONA ARKANSAS COLORADO IDAHO MISSOURI MONTANA NEBRASKA NEVADA NEW MEXICO NORTH DAKOTA SOUTH DAKOTA WYOMING "State" is required. "Waters_Name" must correspond to "Waters_Name" provided within the NWP, Impact and Mitigation fields when also uploaded. ALABAMA AMERICAN SAMOA CALIFORNIA COMMONWEALTH OF THE NORTHERN MARIANA ISLANDS CONNECTICUT DELAWARE DISTRICT OF COLUMBIA FLORIDA GEORGIA GUAM HAWAII ILLINOIS INDIANA IOWA KANSAS KENTUCKY LOUISIANA MAINE MARYLAND MASSACHUSETTS MICHIGAN MINNESOTA MISSISSIPPI NEW HAMPSHIRE NEW JERSEY NEW YORK NORTH CAROLINA OHIO OKLAHOMA OREGON PENNSYLVANIA PUERTO RICO RHODE ISLAND SOUTH CAROLINA TENNESSEE TEXAS UNITED STATES VIRGIN ISLANDS UTAH VERMONT VIRGINIA WASHINGTON WEST VIRGINIA WISCONSIN OMBIL Regulatory Module (ORM) Project Upload Template 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. Change Log ● added a Version worksheet 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. ● NWP worksheet - the Validation process will now verify whether Mitigations are present in the Mit-PermitteeResp or MitBank_ILF worksheets if cells in column S (Compensatory_Mitigation_Reqd) of the NWP worksheet are set to a value of YES ● RGP_PGP worksheet - the Validation process will now verify whether Mitigations are present in the Mit-PermitteeResp or MitBank_ILF worksheets if cells in columns U (Compensatory_Mitigation_Reqd) of the RGP_PGP worksheet are set to a value of YES ● General - standardized user functionality across all user input worksheets ● General - removed the dropdowns from the header cells on all user input worksheets ● AqResources worksheet - added a Validation check to ensure Amount > zero ● AqResources worksheet - changed the format of columns I (Latitude) and J (Longitude) to be decimal formatted numers with 8 significant digits of precision "Amount" must be greater than zero ● AqResources worksheet - add validation check requiring Water Type of Upland (Rapanos)/Dry Land (CWR) when Cowardin Code = U Version Date: ● removed 100K blank rows of data from the Aquatic Resources worksheet of the Consolidated Rapanos template, reducing its size from 9M to 180K. 31-MAR-2016 Version 21-APR-2016 Version ● added a validation to check for garbage characters in the Waters Name column values of all worksheets ● Mit-PermitteeResp worksheet - waters that exist on the Mit-PermitteeResp worksheet must also appear on either the NWP worksheet or on the PGP/RGP worksheet ● MitBank_ILF worksheet - waters that exist on the MitBank_ILF worksheet must also appear on either the NWP worksheet or on the PGP/RGP worksheet Removal (Sec 10 structures) Transport of dredged material (Sec 103) Other (Aquaculture, Work, Aerial or Submarine cable crossings) Initially_Proposed_Length Initially_Proposed_Width Proposed_Length Proposed_Width Authorized_Length Authorized_Width Required_Length Required_Width Fill Area Fill Volume Structure Area Removal Area Removal Area\Removal Volume Amount Type Amount_Type NWP_Permit_Authority Removal Volume Amount_Units Cubic Yards Initially_Proposed_Amount Proposed_Amount Authorized_Amount 02-JUN-2016 Version ● AqResources worksheet - Limited list of Cowardin Code options to second and third tiers only Reef, Subtidal, Marine IAT Fill IAT Removal IAT Structure IAT Fill Volume IAT Dredging IAT Other Fill Area\Removal Area\Structure Area Fill_Area Removal_Area Structure_Area Fill_Volume Removal_Volume ● Impacts worksheet - Removed Linear columns ● Impacts worksheet - Updated Amount_Type to include Fill Volume and Removal Volume ● Impacts worksheet - Updated Amount_Units to include Cubic Yards (volume) ● Impacts worksheet - Added Length and Width columns for Initially Proposed, Proposed and Authorized ● Impacts worksheet - Added check to ensure Amount_Units is specified if Amount is provided ● Impacts worksheet - Added check to ensure either Length/Width are provided OR Amount is provided but not both ● Impacts worksheet - Added check to ensure that if Length is provided, Width must also be provided (and vice versa) ● Impacts worksheet - Added check to ensure that if Amount_Type is Volume, then Amount must be entered, not Length and Width ● Impacts worksheet - Added check to ensure that if a value is provided for any Stage (IP/P/A), then a value must be provided for all Stages Required_Amount ● Mit-PermitteeResp worksheet - Added Length and Width columns for Proposed and Required ● Mit-PermitteeResp worksheet - Removed linear columns ● Mit-PermitteeResp worksheet - Added check to ensure Amount_Units is specified if Amount is provided ● Mit-PermitteeResp worksheet - Added check to ensure either Length/Width are provided OR Amount is provided but not both ● Mit-PermitteeResp worksheet - Added check to ensure that if Length is provided, Width must also be provided (and vice versa) ● Mit-PermitteeResp worksheet - Added check to ensure that if a value is provided for either Proposed or Required, then a value must be provided for both Stages ● Impacts worksheet - Changed "Area" labels to "Amount" ● Mit-PermitteeResp worksheet - Changed "Area" labels to "Amount" Section_10 Section_404 Section_10ss404 ● NWP worksheet - Moved the Permit_Authority column to the left of the NWP_ID column ● NWP worksheet - The NWP_ID values displayed are now dependent upon the selected Permit_Authority value ● NWP worksheet - Updated NWP_ID list and associated Permit_Authority list with the 2017 data 20-APR-2017 Version ● Mitigation worksheet - Added check to allow "0"s in Proposed_Amount and Required_Amount 30-OCT-2017 Version ● NWP worksheet - Updated Closure_Method column values ● RGP_PGP worksheet - Updated Closure_Method column values and removed cascading dependency upon the Permit Type column Verified With Special Conditions Withdrawn For Lack Of Applicant Response Withdrawn To Become A General Permit Withdrawn To Become A Letter of Permission (LOP) Closure_Method_GP ● Format worksheet - Consolidated the Closure_Method_NWP, Closure_Method_RGP, and Closure_Method_PGP columns into a single Closure_Method_GP column and updated the list of values ● VBA - Updated VerifyValues calls in ValidateNWP() and ValidateRGP_PGP() to reference the new Closure_Method_GP list of values Delineation Concurrence ● Format worksheet - Updated the Closure_Method_JD column values 11-Jan-2018 Version CD_Date_App_First_Received ● NWP worksheet - Added 'CD_Date_App_First_Received' ● PGP/RGP worksheet - Added 'CD_Date_App_First_Received' CD_Date_App_First_Received is required. CD_Date_App_First_Received <= Begin Date 19-Sep-2018 Current Version ● AqResources worksheet - Removed Waters Type 'TNWRPW' from the Waters_Type dropdown menu. ● VBA Code - Corrected Validation VBA code throwing "Object variable or With block variable not set" Coordination_Consultation Coordination/Consultation Required Coordination/Consultation Not Required EVALCKLST_S106_NHPA EVALCKLST_S106_NHPA is required. ● NWP and RGP_PGP Worksheets - Replaced EVALCKLST_Historic_Properties column with EVALCKLST_S106_NHPA Rapanos_JD Validation "Waters_Name" must contain unique values. "Waters_Name" must correspond to "Waters_Name" provided within the aquatic resource shapefiles. So that the ORM team may accurately understand the requirements for this project upload, please provide the details of how the included data is to be loaded. Load Finalize Loaded at District? Permit Action ID? Permit Action ID? JD ID? Reasons for Delay? Loaded at District? For ARs, please indicate whether the data has been already loaded by the District Administrators. Specify the Filenames that contain geometry data for the ARs and/or Project Location to be loaded into ORM. Only the root filename (without extension) should be listed below. Filename(s) Project Boundary ● VBA Code - Added validation of new EVALCKLST_S106_NHPA list selections ● Finalize Worksheet - Replaced tab with new 'Request Details'. Made requisite VBA code changes to enforce entry of Load and Finalize columns ● Mitigation Worksheet - Added validation to ensure that the Proposed and Required amounts are entered. "Proposed Length" and "Proposed Width" must both be entered if either is provided. "Required Length" and "Required Width" must both be entered if either is provided. Proposed must have either Length and Width values OR an Amount value Required must have either Length and Width values OR an Amount value "Amount_Units" must be specified when "Proposed Amount" is entered "Amount_Units" must be specified when "Required Amount" is entered "Latitude" is required, except when Aquatic Resource Shapefile Filename provided "Longitude" is required (negative value in western hemisphere), except when Aquatic Resource Shapefile Filename provided Begin_Date < CD_Rcpt_Fed_Complete_App CD_Rcpt_Fed_Complete_App < End_Date Permit Action ID? When Impact and/or Mitigation are provided, but not loading a Permit, you must provide the ACTION ID of one unfinalized Permit to which the data is to be tied. </ Additional Information Needed</t></si><si><t>Required Additional Information explanation:</t></si><si><t>Spec Required Additional Information explanation: Specify clearly which data needs to be uploaded to ORM, and which is to be finalized. Provide Required Additional Information as described in the explanation below. Required Additional Information Reasons For Delay? For NWP or RGP/PGP, if the Permit End Date is more than 60 days past the Date Received, then please specifiy the Delay Reason information. (Multiple Delay Reasons may be provided.) DA # JD ID? For NWP or RGP/PGP: if the permit is to be tied to a JD, but the JD information is not included for upload, please provide the ID of the JD to which the uploaded permits should be associated. (The id can be viewed by hovering over the specific JD in the JD lists.) Also consider including the Begin and End dates for the JD. When Impact data present, either NWP data or RGP_PGP data or Action ID must be provided When MitBank_ILF data present, either NWP data or RGP_PGP data or Action ID must be provided When Mit-PermitteeResp data present, either NWP data or RGP_PGP data or Action ID must be provided ● AqResources Worksheet - If Aquatic Resources shapefile specified, Latitude / Longitude not required 10-Dec-2018 Version ● NWP and RGP_PGP Worksheets - Added validation: Begin_Date must be before CD_Rcpt_Fed_Complete_App, CD_Rcpt_Fed_Complete_App must be before End_Date ● Request Details Worksheet - Added validation: a DA# must be provided ● Request Details Worksheet - Added validation: If Impacts or Mit-PermitteResp and MitBank_IF Worksheets contain data, NWP data or RGP_PGP data or a Permit Action ID must be provided Aquatic Resources Filename must be provided (Request Details Worksheet, B25). Otherwise, All Lat/Long must be provided ● Removed TNWRPW from the Waters_Type list on the Ref_Help worksheet 28-Apr-2019 Version The zip archive of upload template documents must first be downloaded and saved to your local disk. The template file(s) must then be extracted from the zip archive and also saved to your local disk before using them. If the template file is not first saved to your local disk, the data validation macros will not function. PROJECT UPLOAD REQUEST DETAILS * SHAPEFILE UPLOAD REQUEST DETAILS ** * The zip archive of upload template documents must first be downloaded and saved to your local disk. The template file(s) must then be extracted from the zip archive and also saved to your local disk before using them. If the template file is not first saved to your local disk, the data validation macros will not function. ** Please be aware that the .shp, .shx, .dbf, and .prj files at a minimum must be received in order to be a complete submission. ForFor Aquatic Resources, ORM must receive both an AR worksheet and a shapefile in the submission. - In the Shapefile, each geometry must include an attribute for WatersName and each WatersName MUST be unique within and across all files. - Furthermore, there must be a one to one relationship between the WaterName in the AR Worksheet and the WatersName in the Shapefile. - When uploading Aquatic Resources via shapefile, the Latitude / Longitude in the AqResources worksheet is not required. For Project Boundary, the submitted file must contain only one Geometry. 23-Dec-2019 Version ● Rapanos_JD Worksheet - Added two new JD Closure Methods to the Closure_Method list of values ● NWP, RGP_PGP Worksheets - Removed "Provisional Verification" Closure Method from the list of values Coordination_plus_blank Coordination_Consultation_plus_blank Consultation_plus_blank Recapture_plus_blank Section_10_ss_404_Combined YES_NO_plus_Blank ● When Closure_Method is "Not verified by the Corps - 401 process only", bypass validating: Compensatory Mitigation Required Impact must exist Mitigation Must Exist Issued By (only for RGP_PGP) Worktype_1 Date Permit Expires (only for RGP_PGP) Mitigation Permittee Responsible WRDA 214 Funded Corps Permit Name Number (for RGP_PGP) NWP_ID (only for NWP) Evaluation Checklist All columns beginning with "EVALCKLST_" ● When Closure_Method is "Denied Without Prejudice", bypass validating: ● Removed "Oil_Gas_Ind" column (from NWP) Approved JD That Did Require a Site Visit, Conducted Virtually Using Remote Tools ● Ensure that the value in the Worksheet column on the Validation worksheet displays "Request Details" instead of "RGP_PGP" when Impact and Mitigation data exists but there is no Permit data. ● Makes waters_name column header on the Rapanos_JD worksheet green. ● Throw message, "Finalize Not Specified for RGP_PGP sheet," if Finalize <> YES. ● Do not throw message, "info required to finalize," if end_date is blank on the RGP_PGP worksheet. ● If Load = YES and Finalize <> YES on Request Details don't throw this message: "Finalize Not Specified for AqResources sheet." ● Throw message if Load = YES but no data exists on corresponding worksheet. ● Only compare waters_names between (among) worksheets if Load = YES for both of them. ● If Load = YES but Finalize = NO (or is null), then throw user-friendly warning message asking user if they need to finalize or not. ● If Finalize = NO (or is null), then there is no need to verify that finalize fields are populated (function VerifyFinalizeFieldsPopulated) or throw a validation message. ● Remove "Date Permit Expires" from RGP_PGP worksheet and any references to it in the VBA code. ● Throw message reminding user to validate if they make a change(s). ● Change (correct) closure method value in dropdown on Rapanos_JD worksheet. ● Remove Critical_Habitat_Impacted from NWP and RGP_PGP worksheets and references to it in VBA code. ● Fix logic that prompts user to enter in an action id. Preliminary JD That Did Require a Site Visit, Conducted Virtually Using Remote Tools ● Workbook contains digitally signed data validation macros All_None_Some_mitt_resp All Some ● At least one Mitigation-Permittee Responsible must exist when any PermitSheet.Mitigation_Permittee_Responsib = "All" ● At least one Mit-PermitteeResp row AND at least one MB_ILF row must exist WHEN a PermitSheet.Mitigation_Permittee_Responsib = "Some" ● At least one MitBank/ILF row must exist WHEN a PermitSheet.Compensatory_Mitigation_Reqd = "YES" AND PermitSheet.Mitigation_Permittee_Responsib = "None" ● Change tooltip text on Waters_name on Rapanos_JD worksheet. ● Mit-PermitteeResp.Waters_Name must NOT exist WHEN a PermitSheet.Compensatory_Mitigation_Reqd = "YES" AND PermitSheet.Mitigation_Permittee_Responsib = "None" ● When PermitSheet.Compensatory_Mitigation_Reqd = "NO", PermitSheet.Mitigation_Permittee_Responsib MUST be "None" ● Removed "Not verified by the Corps - 401 process only" from Closure Method list ● MitBank/ILF row must NOT exist when a PermitSheet.Compensatory_Mitigation_Reqd = "YES" AND PermitSheet.Mitigation_Permittee_Responsib = "All" ● MitigationSheet.Waters_Name must NOT exist when a PermitSheet.Compensatory_Mitigation_Reqd = "NO" At least one Mitigation-Permittee Responsible must exist when any PermitSheet.Mitigation_Permittee_Responsib = "All" At least one Mit-PermitteeResp row AND at least one MB_ILF row must exist WHEN a PermitSheet.Mitigation_Permittee_Responsib = "Some" At least one MitBank/ILF row must exist WHEN a PermitSheet.Compensatory_Mitigation_Reqd = "YES" AND PermitSheet.Mitigation_Permittee_Responsib = "None" Mit-PermitteeResp.Waters_Name must NOT exist WHEN a PermitSheet.Compensatory_Mitigation_Reqd = "YES" AND PermitSheet.Mitigation_Permittee_Responsib = "None" MitBank/ILF row must NOT exist when a PermitSheet.Compensatory_Mitigation_Reqd = "YES" AND PermitSheet.Mitigation_Permittee_Responsib = "All" MitigationSheet.Waters_Name must NOT exist when a PermitSheet.Compensatory_Mitigation_Reqd = "NO" When PermitSheet.Compensatory_Mitigation_Reqd = "NO", PermitSheet.Mitigation_Permittee_Responsib MUST be "None" NWP 1 NWP 3 NWP 2 NWP 4 NWP 5 NWP 6 NWP 7 NWP 12 NWP 13 NWP 8 NWP 14 NWP 9 NWP 15 NWP 10 NWP 16 NWP 11 NWP 17 NWP 18 NWP 19 NWP 20 NWP 21 NWP 22 NWP 23 NWP 25 NWP 27 NWP 29 NWP 24 NWP 30 NWP 31 NWP 28 NWP 32 NWP 33 NWP 34 NWP 36 NWP 37 NWP 35 NWP 38 NWP 39 NWP 40 NWP 41 NWP 42 NWP 44 NWP 43 NWP 45 NWP 48 NWP 49 NWP 46 NWP 50 NWP 51 NWP 52 NWP 53 NWP 54 NWP 55 NWP 56 NWP 57 NWP 58 NWP 59 ● Added NWP 29 as a selectable NWP_ID ● Bypassed all 3rd Party Mitigation checks when Closure_Method = "Denied without Prejudice" Bypassed all 3rd Party Mitigation checks (Rule0 - Rule6) when Closure_Method = "Denied without Prejudice" ● Took off Red warning fill on waters_name column on Impacts worksheet ● Added yellow fill warning to Name column on Impacts worksheet Worksheet Column Cell Warning Request Details DA# DA# Not Entered A1-1.TNW-404 A1-1.TNW-404.10 A1-2.TERSEAS-404.10 A1-3.INTSTATE-404 A1-3.INTSTATE-404.10 A2.IMPDT-404 A3-1.TRIB.RPS-404 A4-1.ADJ.WET.A1-TNW-404 A4-1.ADJ.WET.A1-TERSEAS-404 A4-1.ADJ.WET.A1-INTSTATE-404 A4-2.ADJ.WET.RPS-404 B1-EXCL-WTS B2-EXCL-PCC B3-EXCL-DITCH B4-EXCL-ART.IRR B5-EXCL-ART.LK B6-EXCL-ART.REF B7-EXCL-WTF.DEP B8-EXCL-SWAL.EROS DELIN.CONC DRY.LAND MPRSA-OCEAN DELIN.NOJD-404 DELIN.NOJD-404.10 DELIN.PJD-404 DELIN.PJD-404.10 RHA-10NAV RHA-10TIDAL RHA-OUT.CON.SHLF (a)(1)(i) Traditional Navigable Water (Section 404 Only) (a)(1)(i) Traditional Navigable Water, also subject to Sections 9 or 10 of the Rivers and Harbors Act (Section 10/404) (a)(1)(ii) Territorial Seas, also subject to Sections 9 or 10 of the Rivers and Harbors Act (Section 10/404) (a)(1)(iii) Interstate Waters (Section 404 Only) (a)(1)(iii) Interstate Waters, also subject to Sections 9 or 10 of the Rivers and Harbors Act (Section 10/404) (a)(2) Jurisdictional Impoundment (Section 404 Only) (a)(3) Tributary, Meets Relatively Permanent Standard (Section 404 Only) (a)(4) Adjacent Wetland, Adjacent to (a)(1)(i) TNW (a)(4) Adjacent Wetland, Adjacent to (a)(1)(ii) Territorial Sea (a)(4) Adjacent Wetland, Adjacent to (a)(1))(iii) Interstate Water (a)(4) Adjacent Wetland, Meets Relatively Permanent Standard (Section 404 Only) (b)(1) Waste Treatment System (Excluded) (b)(2) Wetland, Excluded as PCC Designated by USDA (Excluded) (b)(3) Ditches (including roadside ditches) excavated wholly in and draining only dry land and that do not carry a relatively permanent flow of water (Excluded) (b)(4) Artificially irrigated areas that would revert to dry land if the irrigation ceased (Excluded) (b)(5) Artificial lakes or ponds created in dry land, used exclusively for such eligible purposes (Excluded) (b)(6) Artificial reflecting/swimming/ornamental pools; created by excavating or diking dry land to retain water for primarily aesthetic reasons (Excluded) (b)(7) Waterfilled depressions created in dry land incidental to construction activity and pits excavated in dry land, until abandoned (Excluded) (b)(8) Swales and erosional features (e.g., gullies, small washes) characterized by low volume, infrequent, or short duration flow (Excluded) Used for Delineation Concurrence - No determination of jurisdiction made The review area is comprised entirely of dry land (i.e. There are no waters or water features, including wetlands, of any kind in the entire review area) Waters of the open seas lying seaward of the base line, as provided for in the Convention on the Territorial Sea and the Contiguous Zone (Section 103 Only) Section 404 Used for No JD Required Section 10/404 Used for No JD Required Section 404 Used for PJD Section 10/404 Used for PJD RHA Non-tidal water is on the district's Section 10 waters list (Section 10 Only) RHA Tidal water is subject to the ebb and flow of the tide (Section 10 Only) Seabed on the Outer Continental Shelf (Not in Territoral Seas), to the seaward limit of the outer continental shelf - Section 4(f) of the OCSLA (as amended). RAPANOS_AJD RAPANOS_PJD RAPANOS_NOJD ● New waters type added to AqResources worksheet ● New rule: if cowardin_code = 'U', then waters_type must be 'DRY.LAND'. ● Remove columns, Does_Corps_Have_GA & Authority, on RAPANOS_JD worksheet and associated VB code ● New validation to RAPANOS_JD worksheet: The End Date must be On or After March 20th, 2023. ● New validation to RAPANOS_JD worksheet: The Begin Date must be On or After March 20th, 2023. ● New validation to RAPANOS_JD worksheet: Loop through water types. Figure out of their corresponding subtypes are the same. If not, throw a validation error. "Cowardin Code" of U (Uplands) must have associated "Waters Type" of DRY.LAND The jd subtype of the "Waters Type" must be unique. If not, throw a validation error. "Begin Date" cannot be on or after March 20, 2023. "End Date" cannot be on or after March 20, 2023. Presence_Absence_AJD? Activities_BIL_Funding_Confirmed_in_Writing BIL_Activities_NOT_BIL_Funded ● Added new column, 'Presence/Absence AJD?,' after the Closure_Method column on the Rapanos_JD worksheet. ● New validations for the RAPANOS_JD, NWP, RGP_PGP worksheets: If the following columns per row are all null, throw an error: WRDA_214_Funded_Corps, Activities_BIL_Funding_Confirmed_in_Writing, BIL_Activities_NOT_BIL_Funded. NO_DATA A3-2.TRIB.SNS-404 NON-WOTUS-TRIB.NEGATIVE.A3-2 A4-3.ADJ.WET.SNS-404 NON-WOTUS-ADJ.WET.NEGATIVE.A4-3 A5-1.RPS-404 A5-2.SNS-404 NON-WOTUS-OTH.NEGATIVE.A5-2-C NON-WOTUS-OTH.NEGATIVE.A5-2-OW NON-WOTUS-OTH.NEGATIVE.A5-2-W 2023Rule_JD 20-Mar-2023 Current Version B2 WA WB WD WE WI WJ WK WL WM WN WO WP WQ WR WS WT WU WV WX WY WZ WAA WBB WCC WDD WEE WFF WGG WHH WII WJJ WKK WLL WMM SA SB SC SO SI SJ SK SL SM SN SQ SR WF/H WW SE1, SE2, & SE3 SP1 & SP2