{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Version","Request Details","AqResources","Validation","Rules","Ref_Help","Format"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":64,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Version","index":0,"n_rows":87,"n_cols":5,"rows_kept":87,"cut":false,"hidden":false,"merged":[[19,0,19,2],[23,0,23,2],[1,3,3,8],[70,0,70,2],[79,0,79,17],[17,0,17,1],[12,0,14,8],[73,0,73,17],[76,0,76,17],[9,0,10,8],[72,0,72,17],[71,0,71,17],[47,0,47,2],[48,0,48,17],[33,0,33,2],[44,0,44,2],[41,0,41,17],[42,0,42,17],[83,0,83,17],[85,0,85,17],[86,0,86,17],[80,0,80,17],[81,0,81,17],[82,0,82,17],[29,0,29,2],[31,0,31,17],[39,0,39,17],[40,0,40,17],[37,0,37,2],[34,0,34,17],[35,0,35,17],[38,0,38,17]]}
[]
[null,null,null,"OMBIL Regulatory Module (ORM)\nProject Upload Template"]
[]
[]
[]
[null,null,null,"Version Date: ","2019-04-28"]
[]
[]
[]
["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"]
[]
["28-Apr-2019 Current Version"]
["● AqResources Worksheet - If Aquatic Resources shapefile specified, Latitude / Longitude not required "]
["● Request Details Worksheet - Added validation: a DA# must be provided"]
[]
["10-Dec-2018 Version "]
["● NWP and RGP_PGP Worksheets - Replaced EVALCKLST_Historic_Properties column with EVALCKLST_S106_NHPA"]
["● 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."]
[]
["19-Sep-2018 Current Version "]
["● VBA Code - Corrected Validation VBA code throwing \"Object variable or With block variable not set\""]
["● AqResources worksheet - Removed Waters Type 'TNWRPW' from the Waters_Type dropdown menu."]
[]
["2018-05-22"]
["● NWP worksheet - Added 'CD_Date_App_First_Received'"]
["● PGP/RGP worksheet - Added 'CD_Date_App_First_Received'"]
[]
["11-Jan-2018 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"]
["● 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"]
["● Format worksheet - Updated the Closure_Method_JD column values"]
["● VBA - Updated VerifyValues calls in ValidateNWP() and ValidateRGP_PGP() to reference the new Closure_Method_GP list of values"]
[]
["30-OCT-2017 Version "]
["● Mitigation worksheet - Added check to allow \"0\"s in Proposed_Amount and Required_Amount"]
[]
["20-APR-2017 Version "]
["● AqResources worksheet -  Limited list of Cowardin Code options to second and third tiers only"]
["● Impacts worksheet - Added Length and Width columns for Initially Proposed, Proposed and Authorized"]
["● Impacts worksheet - Removed Linear columns"]
["● Impacts worksheet - Changed \"Area\" labels to \"Amount\""]
["● 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 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"]
["● Mit-PermitteeResp worksheet - Added Length and Width columns for Proposed and Required"]
["● Mit-PermitteeResp worksheet - Removed linear columns"]
["● Mit-PermitteeResp worksheet - Changed \"Area\" labels to \"Amount\""]
["● 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"]
["● NWP worksheet - Updated NWP_ID list and associated Permit_Authority list with the 2017 data"]
["● 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"]
[]
["02-JUN-2016 Version"]
["● 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"]
["● added a validation to check for garbage characters in the Waters Name column values of all worksheets"]
[]
["21-APR-2016 Version"]
["● 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"]
["● added a Version worksheet"]
["● General - removed the dropdowns from the header cells on all user input worksheets"]
["● General - standardized user functionality across all user input worksheets"]
["● 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 "]
["● 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"]

{"sheet":"Request Details","index":1,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[[20,0,20,4],[8,0,8,4],[0,0,0,4],[2,0,2,4],[3,0,3,4],[4,1,4,2],[1,1,1,2],[15,1,15,3],[19,0,19,4],[9,0,9,4],[11,0,11,4],[12,0,12,4],[13,0,13,4],[14,1,14,3],[16,1,16,3]]}
["PROJECT  UPLOAD  REQUEST  DETAILS"]
["DA #"]
["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."]
["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."]
[]
[null,"Load","Finalize","                                                                                 Additional Information Needed","Required Additional Information"]
["Aquatic Resources",null,null,"Loaded at District?"]
[]
["Required Additional Information explanation:"]
["Loaded at District?  For ARs, please indicate  whether the data has been already loaded by the District Administrators."]
[]
["SHAPEFILE UPLOAD REQUEST DETAILS*"]
["Specify the Filenames that contain geometry data for the ARs to be loaded into ORM.  \nOnly the root filename (without extension) should be listed below.  \n"]
[]
[null,"Filename(s)",null,null,"Notes"]
["Aquatic Resources"]
["Project Boundary"]
[]
["NOTE:  Please be aware that the  .shp, .shx, .dbf, and .prj files at a minimum must be received in order to be a complete submission."]
["*For Aquatic Resources, ORM must receive both an AR worksheet and a shapefile in the submission.\n- In the Shapefile, each geometry must include an attribute for WatersName and each WatersName MUST be unique within and across all files.  \n- Furthermore, there must be a one to one relationship between the WaterName in the AR Worksheet and the WatersName in the Shapefile.\n- 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."]

{"sheet":"AqResources","index":2,"n_rows":1,"n_cols":11,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Waters_Name","State","Cowardin_Code","HGM_Code","Meas_Type","Amount","Units","Waters_Type","Latitude","Longitude","Local_Waterway"]

{"sheet":"Validation","index":3,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Worksheet","Column","Cell","Warning"]

{"sheet":"Rules","index":4,"n_rows":33,"n_cols":1,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["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."]
["\"Amount\" must be greater than zero"]
["\"Units\" is required"]
["\"Waters Type\" is required"]
["\"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"]
["\"Waters_Name\" must correspond to \"Waters_Name\" provided within the NWP, Impact and Mitigation fields when also uploaded."]
["\"Cowardin Code\" of U (Uplands) must have associated \"Waters Type\" of Upland"]
[]
["OTHER VALIDATIONS"]
["\"Waters_Name\" is required."]
["\"Waters_Name\" must contain unique values."]
["\"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 or Linear \"Amounts\" (initialy proposed, proposed, authorized) are required"]
["\"Area Type\" is required when Area Amounts are entered"]
["\"Area Type\" can only be structure when Activity = Structure."]
["\"Units of Measure\" is required"]
["When Impact data present, either NWP data or RGP_PGP data or Action ID must be provided  "]
["Aquatic Resources Filename must be provided (Request Details Worksheet, B16). Otherwise, All Lat/Long must be provided"]

{"sheet":"Ref_Help","index":5,"n_rows":117,"n_cols":4,"rows_kept":117,"cut":false,"hidden":false,"merged":[]}
["Waters_Type",null,"Description"]
["DELINEATE",null,"Delineation Only - PJD or No JD Required"]
["IMPNDMNT",null,"Impoundments"]
["ISOLATE",null,"Isolated (interstate or intrastate) waters, including isolated wetlands"]
["NRPW",null,"Non-RPWs that flow directly or indirectly into TNWs"]
["NRPWW",null,"Wetlands adjacent to non-RPWs that flow directly or indirectly into TNWs"]
["RPW",null,"Relatively Permanent Waters (RPWs) that flow directly or indirectly into TNWs"]
["RPWWD",null,"Wetlands directly abutting RPWs that flow directly or indirectly into TNWs"]
["RPWWN",null,"Wetlands adjacent to but not directly abutting RPWs that flow directly or indirectly into TNWs"]
["TNW",null,"TNWs, including territorial seas"]
["TNWRPW",null,"Tributary consisting of both RPWs and non-RPWs"]
["TNWW",null,"Wetlands adjacent to TNWs"]
["UPLAND",null,"Uplands"]
[]
["HGM_Code","Name","Description"]
["DEPRESS","Depressional","Depressional is characterized by a water source consisting of return flow from groundwater and interflow with primarily vertical hydrodynamics."]
["ESTUARINEF","Estuarine Fringed","The water source of the estuarine fringe consists of overbank flow from estuaries, with bidirectional and horizontal hydrodynamics being dominant."]
["LACUSTRINF","Lacustrine Fringe","A Lacustrine fringe has a dominant water source of lake overbank flow, and the dominant hydrodynamics are bidirectional and horizontal."]
["MINSOILFLT","Mineral Soil Flats","Mineral soil flats have a water source of precipitation, and vertical hydrodynamics are dominant."]
["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 predominantly unidirectional and horizontal."]
["SLOPE","Slope","The Slope wetland class is characterized by a water source of return flow from groundwater, with principally unidirectional and horizontal hydrodynamics."]
[]
["Cowardin_Code","Category","Description","Name"]
["E1","Estuarine","Subtidal, Estuarine","E1-ESTUARINE, SUBTIDAL"]
["E1AB","Estuarine","Aquatic Bed, Estuarine","E1AB-ESTUARINE, SUBTIDAL, AQUATIC BED"]
["E1OW","Estuarine","Open Water, Subtidal, Estuarine (used on older maps)","E1OW-ESTUARINE, SUBTIDAL, OPEN WATER"]
["E1RB","Estuarine","Rock Bottom, Subtidal, Estuarine","E1RB-ESTUARINE, SUBTIDAL, ROCK BOTTOM"]
["E1RF","Estuarine","Reef, Subtidal, Estuarine","E1RF-ESTUARINE, SUBTIDAL, REEF"]
["E1UB","Estuarine","Unconsolidated Bottom, Subtidal, Estuarine","E1UB-ESTUARINE, SUBTIDAL UNCONSOLIDATED BOTTM"]
["E2","Estuarine","Intertidal, Estuarine","E2-ESTUARINE, INTERTIDAL"]
["E2AB","Estuarine","Aquatic Bed, Intertidal, Estuarine","E2AB-ESTUARINE, INTERTIDAL, AQUATIC BED"]
["E2EM","Estuarine","Emergent, Intertidal, Estuarine","E2EM-ESTUARINE, INTERTIDAL, EMERGENT"]
["E2FO","Estuarine","Forested, Intertidal, Estuarine","E2FO-ESTUARINE, INTERTIDAL, FORESTED"]
["E2RF","Estuarine","Reef, Intertidal, Estuarine","E2RF-ESTUARINE, INTERTIDAL, REEF"]
["E2RS","Estuarine","Rocky Shore, Intertidal, Estuarine","E2RS-ESTUARINE, INTERTIDAL, ROCKY SHORE"]
["E2SB","Estuarine","Stream Bed, Intertidal, Estuarine","E2SB-ESTUARINE, INTERTIDAL, STREAM BED"]
["E2SS","Estuarine","Scrub-Shrub, Intertidal, Estuarine","E2SS-ESTUARINE, INTERTIDAL, SCRUB-SHRUB"]
["E2US","Estuarine","Unconsolidated Shore, Intertidal, Estuarine","E2US-ESTUARINE, INTERTIDAL, UNCONSOL SHORE"]
["L1","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"]
["L1AB","Lacustrine","Aquatic Bed, Limnetic, Lacustrine","L1AB-LACUSTRINE, LIMNETIC, AQUA BED"]
["L1OW","Lacustrine","Open Water/Unknown Bottom, Limnetic, Lacustrine (used on older maps)","L1OW-LACUSTRINE, LIMNETIC, OPEN WATER/UNK BOT"]
["L1RB","Lacustrine","Rock Bottom, Limnetic, Lacustrine","L1RB-LACUSTRINE, LIMNETIC, ROCK BOTTOM"]
["L1UB","Lacustrine","Unconsolidated Bottom, Limnetic, Lacustrine","L1UB-LACUSTRINE, LIMNETIC, UNCONSOL BOTTOM"]
["L2","Lacustrine","Littoral, Lacustrine","L2-LACUSTRINE, LITTORAL"]
["L2AB","Lacustrine","Aquatic Bed, Littoral, Lacustrine","L2AB-LACUSTRINE, LITTORAL, AQUA BED"]
["L2EM","Lacustrine","Emergent, Littoral, Lacustrine","L2EM-LACUSTRINE, LITTORAL, EMERGENT"]
["L2OW","Lacustrine","Open Water/Unknown Bottom, Littoral, Lacustrine","L2OW-LACUSTRINE, LITTORAL, OPEN WATER"]
["L2RB","Lacustrine","Rock Bottom, Littoral, Lacustrine","L2RB-LACUSTRINE, LITTORAL, ROCK BOTTOM"]
["L2RS","Lacustrine","Rocky Shore, Littoral, Lacustrine","L2RS-LACUSTRINE, LITTORAL, ROCKY SHORE"]
["L2UB","Lacustrine","Unconsolidated Bottom, Littoral, Lacustrine","L2UB-LACUSTRINE, LITTORAL, UNCONSOL BOT"]
["L2US","Lacustrine","Unconsolidated Shore, Littoral, Lacustrine","L2US-LACUSTRINE, LITTORAL, UNCONSOL SHORE"]
["M1","Marine","Subtidal Marine","M1-MARINE, SUBTIDAL"]
["M1AB","Marine","Aquatic Bed, Subtidal, Marine","M1AB-MARINE, SUBTIDAL, AQUATIC BED"]
["M1OW","Marine","Open Water, Subtidal, Marine (Used on older maps)","M1OW-MARINE, SUBTIDAL, OPEN WATER"]
["M1RB","Marine","Rock Bottom Subtidal Marine","M1RB-MARINE, SUBTIDAL, ROCK BOTTOM"]
["M1RF","Marine","Reef, Subtidal, Marine","M1RF-MARINE, SUBTIDAL, REEF"]
["M1UB","Marine","Unconsolidated Bottom, Subtidal, Marine","M1UB-MARINE, SUBTIDAL, UNCONSOLIDATED BOTTOM"]
["M2","Marine","Intertidal, Marine","M2-MARINE, INTERTIDAL"]
["M2AB","Marine","Aquatic Bed, Intertidal, Marine","M2AB-MARINE, INTERTIDAL, AQUATIC BED"]
["M2RF","Marine","Reef, Intertidal, Marine","M2RF-MARINE, INTERTIDAL, REEF"]
["M2RS","Marine","Rocky Shore, Intertidal, Marine","M2RS-MARINE, INTERTIDAL, ROCKY SHORE"]
["M2US","Marine","Unconsolidated Shore, Intertidal, Marine","M2US-MARINE, INTERTIDAL, UNCONSOLIDATED SHORE"]
["PAB","Palustrine","Aquatic Bed, Palustrine","PAB-PALUSTRINE, AQUA BED"]
["PAB1","Palustrine","Algal, Aquatic Bed, Palustrine","PAB1-PALUSTRINE, AQUA BED, ALGAL"]
["PAB2","Palustrine","Aquatic Moss, Aquatic Bed, Palustrine","PAB2-PALUSTRINE, AQUA BED, AQUATIC MOSS"]
["PAB3","Palustrine","Rooted Vascular, Aquatic Bed, Palustrine","PAB3-PALUSTRINE, AQUA BED, ROOTED VASC"]
["PAB4","Palustrine","Floating Vascular, Aquatic Bed, Palustrine","PAB4-PALUSTRINE, AQUA BED, FLOAT VASC"]
["PAB5","Palustrine","Unknown Submergent, Aquatic Bed, Palustrine","PAB5-PALUSTRINE, AQUA BED, UNK SUB"]
["PAB6","Palustrine","Unknown Surface, Aquatic Bed, Palustrine","PAB6-PALUSTRINE, AQUA BED, UNK SURF"]
["PEM","Palustrine","Emergent, Palustrine","PEM-PALUSTRINE, EMERGENT"]
["PFO","Palustrine","Forested, Palustrine","PFO-PALUSTRINE, FORESTED"]
["PML","Palustrine","Moss-Lichens, Palustrine","PML-PALUSTRINE, MOSS-LICHENS"]
["POW","Palustrine","POW-PALUSTRINE, OPEN WATER","POW-PALUSTRINE, OPEN WATER"]
["PRB","Palustrine","Rock Bottom, Palustrine","PRB-PALUSTRINE, ROCK BOTTOM"]
["PSS","Palustrine","Scrub-Shrub, Palustrine","PSS-PALUSTRINE, SCRUB-SHRUB"]
["PUB","Palustrine","Unconsolidated Bottom, Palustrine","PUB-PALUSTRINE, UNCONSOL BOT"]
["R1","Riverine","Tidal, Riverine","R1-RIVERINE, TIDAL"]
["R1AB","Riverine","Aquatic Bed, Tidal, Riverine","R1AB-RIVERINE, TIDAL, AQUATIC BED"]
["R1EM","Riverine","Emergent, Tidal, Riverine","R1EM-RIVERINE, TIDAL, EMERGENT"]
["R1RB","Riverine","Rock Bottom, Tidal, Riverine","R1RB-RIVERINE, TIDAL, ROCK BOTTOM"]
["R1RS","Riverine","Rocky Shore, Tidal, Riverine","R1RS-RIVERINE, TIDAL, ROCKY SHORE"]
["R1SB","Riverine","Streambed, Tidal, Riverine","R1SB-RIVERINE, TIDAL, STREAMBED"]
["R1UB","Riverine","Unconsolidated Bottom, Tidal, Riverine","R1UB-RIVERINE, TIDAL, UNCONSOLIDATED BOTTOM"]
["R1US","Riverine","Unconsolidated Shore, Tidal, Riverine","R1US-RIVERINE, TIDAL, UNCONSOL SHORE"]
["R2","Riverine","Lower Perennial, Riverine","R2-RIVERINE, LOWER PERENNIAL"]
["R2AB","Riverine","Aquatic Bed, Lower Tidal, Riverine","R2AB-RIVERINE, LOWER PEREN, AQUA BED"]
["R2EM","Riverine","Emergent, Lower Tidal, Riverine","R2EM-RIVERINE, LOWER PEREN, EMERGENT"]
["R2RB","Riverine","Rock Bottom, Lower Perennial, Riverine","R2RB-RIVERINE, LOWER PEREN, ROCK BOTTOM"]
["R2RS","Riverine","Rocky Shore, Lower Tidal, Riverine","R2RS-RIVERINE, LOWER PEREN, ROCKY SHORE"]
["R2UB","Riverine","Unconcolidated Bottom, Lower Perennial, Riverine","R2UB-RIVERINE, LOWER PEREN, UNCONSOL BOT"]
["R2US","Riverine","Unconsolidated Shore, Lower Tidal, Riverine","R2US-RIVERINE, LOWER PEREN, UNCONSOL SHORE"]
["R3","Riverine","Upper Perennial, Riverine","R3-RIVERINE, UPPER PERENNIAL"]
["R3AB","Riverine","Aquatic Bed, Upper Perennial, Riverine","R3AB-RIVERINE, UPPER PEREN, AQUA BED"]
["R3RB","Riverine","Rock Bottom, Upper Perennial, Riverine","R3RB-RIVERINE, UPPER PEREN, ROCK BOTTOM"]
["R3RS","Riverine","Rocky Shore, Upper Perennial, Riverine","R3RS-RIVERINE, UPPER PEREN, ROCKY SHORE"]
["R3UB","Riverine","Unconsolidated Bottom, Upper Perennial, Riverine","R3UB-RIVERINE, UPPER PEREN, UNCONSOL BOT"]
["R3US","Riverine","Unconsolidated Shore, Upper Perennial, Riverine","R3US-RIVERINE, UPPER PEREN, UNCONSOL SHR"]
["R4","Riverine","Intermittent, Riverine","R4-RIVERINE, INTERMIT"]
["R4SB","Riverine","Streambed, Intermittent, Riverine","R4SB-RIVERINE, INTERMIT, STREAMBED"]
["R5","Riverine","Unknown Perennial, Riverine","R5-RIVERINE, UNKNOWN PERENNIAL"]
["R5AB","Riverine","Aquatic Bed, Unknown Perennial, Riverine","R5AB-RIVERINE, UNK PEREN, AQUA BED"]
["R5RB","Riverine","Rock Bottom, Unknown Perennial, Riverine","R5RB-RIVERINE, UNK PEREN, ROCK BOTTOM"]
["R5RS","Riverine","Rocky Shore, Unknown Perennial, Riverine","R5RS-RIVERINE, UNK PEREN, ROCKY SHORE"]
["R5UB","Riverine","Unconsolidated Bottom, Unknown Perennial, Riverine","R5UB-RIVERINE, UNK PEREN, UNCONSOLIDATED BOTTOM"]
["R5US","Riverine","Unconsolidated Shore, Unknown Perennial, Riverine","R5US-RIVERINE, UNK PEREN, UNCONCOL SHORE"]
["R6","Riverine","A wetland, spring, stream, river, pond or lake that only exists for a short period","R6 - RIVERINE, EPHEMERAL"]
["RP","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"]
["RP1","Riparian","Lotic, Riparian","RP1-RIPARIAN, LOTIC"]
["RP1EM","Riparian","Emergent, Lotic, Riparian","RP1EM-RIPARIAN, LOTIC, EMERGENT"]
["RP1FO","Riparian","Forested, Lotic, Riparian","RP1FO-RIPARIAN, LOTIC, FORESTED"]
["RP1SS","Riparian","Scrub-Shrub, Lotic, Riparian","RP1SS-RIPARIAN, LOTIC, SCRUB-SHRUB"]
["RP2","Riparian","Lentic, Riparian","RP2-RIPARIAN, LENTIC"]
["RP2EM","Riparian","Emergent, Lentic, Riparian","RP2EM-RIPARIAN, LENTIC, EMERGENT"]
["RP2FO","Riparian","Forested, Lentic. Riparian","RP2FO-RIPARIAN, LENTIC, FORESTED"]
["RP2SS","Riparian","Scrub-Shrub, Lentic, Riparian","RP2SS-RIPARIAN, LENTIC, SCRUB-SHRUB"]
["U","Uplands","Upland - Not a wetland or deepwater habitat of the United States as described by Cowardin.","U-UPLANDS"]

{"sheet":"Format","index":6,"n_rows":142,"n_cols":56,"rows_kept":142,"cut":false,"hidden":false,"merged":[]}
["Cowardin_Code","HGM_Code","Meas_Type","Units_Area","Units_Linear","Waters_Type","Activity","Resource_Type","YES_NO","Impact_Duration","Amount_Type","Fill_Area","Removal_Area","Structure_Area","Fill_Volume","Removal_Volume","Mitigation_Type_P","Mitigation_Type_M","Permittee_Responsible_Type","Mitigation_Kind","Coordination","Consultation","NWP_ID","NWP_Permit_Authority","Permit_Authority","Closure_Method_GP","WorkType","Authority","Closure_Method_JD","Permit_Type","Issued_By","Units_Area2","Units_Linear2","Recapture","Credit_Unit_ILF","Credit_Unit_MB","State","IAT Fill","IAT Removal","IAT Structure","IAT Fill Volume","IAT Dredging","IAT Other","Conversion of waters type (forested wetland to emergent wetland, stream to lake)","Discharge of dredged material","Discharge of fill material","Dredging (Section 10)","Ecological restoration","Removal (Sec 10 structures)","Structure (Sec 10 only)","Transport of dredged material (Sec 103)","Other (Aquaculture, Work, Aerial or Submarine cable crossings)","Section_10","Section_10ss404","Section_404","Coordination_Consultation"]
["E1","DEPRESS","Area","ACRE","FOOT","DELINEATE","Conversion of waters type (forested wetland to emergent wetland, stream to lake)","Harbor/Ocean","YES","Permanent","Fill Area","Acres","Acres","Acres","Cubic Yards","Cubic Yards","Permittee Responsible (off-site)","In-Lieu Fee","Establishment","In Kind","No Resources Present","Required","NWP 1","Section 10","Section 10","Denied Without Prejudice","AGRICULTURE \\ CONVERSION","None","Approved JD That Did Not Require A Field/Site Visit","RGP","CORPS","Acres","Feet","Applies","Acre Based","Acre Based","ALABAMA","Fill Area","Removal Area","Structure Area","Fill Volume","Removal Area","Structure Area","Fill Area","Fill Area","Fill Area","Removal Area","Fill Area","Removal Area","Structure Area","Fill Volume","Fill Area","NWP 1","NWP 3","NWP 3","Coordination/Consultation Required"]
["E1AB","ESTUARINEF","Linear","SQ_FT",null,"IMPNDMNT","Discharge of dredged material","Lake","NO","Temporary","Removal Area","Square Feet","Square Feet","Square Feet",null,null,"Permittee Responsible (on-site)","Mitigation Bank","Re-establishment","Out of Kind","Resources Present/No Effect","Not Required","NWP 2","Section 10/404","Section 10/103","Discretionary Authority","AGRICULTURE \\ NON-EXEMPT ","Section 10/404","Approved JD That Did Require A Field/Site Visit","PGP","LOCAL","Square Feet",null,"Does Not Apply","Linear Feet Based","Linear Feet Based","ALASKA",null,null,null,null,"Removal Volume","Fill Area",null,null,null,"Removal Volume",null,null,null,null,"Removal Area","NWP 2","NWP 4","NWP 4","Coordination/Consultation Not Required"]
["E1OW","LACUSTRINF",null,null,null,"ISOLATE","Discharge of fill material","Non-Tidal Wetland",null,null,"Structure Area",null,null,null,null,null,null,null,"Enhancement",null,"Resources Present/Consultation Required",null,"NWP 3","Section 404","Section 10/404","Exceeded Corps Review Time Limit, Verified By Default","AQUACULTURE \\ FINFISH","Section 404","Delineation Concurrence",null,"OTHER",null,null,null,"Advanced Credit","Assessment Based","AMERICAN SAMOA",null,null,null,null,null,"Removal Area",null,null,null,null,null,null,null,null,"Structure Area","NWP 3","NWP 5","NWP 5"]
["E1RB","MINSOILFLT",null,null,null,"NRPW","Dredging (Section 10)","Pond",null,null,"Fill Volume",null,null,null,null,null,null,null,"Rehabilitation",null,null,null,"NWP 4",null,"Section 10/404/103","Provisional Verification","AQUACULTURE \\ PLANTS",null,"No JD Required",null,"STATE",null,null,null,"Assessment Based",null,"ARIZONA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 4","NWP 6","NWP 6"]
["E1RF","ORGSOILFLT",null,null,null,"NRPWW","Ecological restoration","River/Stream",null,null,"Removal Volume",null,null,null,null,null,null,null,"Preservation",null,null,null,"NWP 5",null,"Section 103","Verified With Special Conditions ","AQUACULTURE \\ SHELLFISH",null,"Preliminary JD That Did Not Require A Field/Site Visit",null,null,null,null,null,null,null,"ARKANSAS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 5","NWP 7","NWP 7"]
["E1UB","RIVERINE",null,null,null,"RPW","Removal (Sec 10 structures)","Tidal Wetland",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 6",null,"Section 404","Verified Without Special Conditions","DEVELOPMENT \\ ASSOCIATED INFRASTRUCTURE",null,"Preliminary JD That Did Require A Field/Site Visit",null,null,null,null,null,null,null,"CALIFORNIA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 6","NWP 12","NWP 12"]
["E2","SLOPE",null,null,null,"RPWWD","Structure (Sec 10 only)","Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 7",null,"Section 404/103","Withdrawn","DEVELOPMENT \\ COMMERCIAL",null,"Withdrawn",null,null,null,null,null,null,null,"COLORADO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 7","NWP 13","NWP 13"]
["E2AB",null,null,null,null,"RPWWN","Transport of dredged material (Sec 103)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 8",null,"Section 9","Withdrawn By Applicant","DEVELOPMENT \\ INDUSTRIAL ",null,"Withdrawn By Applicant",null,null,null,null,null,null,null,"COMMONWEALTH OF THE NORTHERN MARIANA ISLANDS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 8","NWP 14","NWP 14"]
["E2EM",null,null,null,null,"TNW","Other (Aquaculture, Work, Aerial or Submarine cable crossings)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 9",null,null,"Withdrawn Due To No Permit Required (NPR)","DEVELOPMENT \\ RECREATIONAL",null,null,null,null,null,null,null,null,null,"CONNECTICUT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 9","NWP 15","NWP 15"]
["E2FO",null,null,null,null,"TNWW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 10",null,null,"Withdrawn For Enforcement Action","DEVELOPMENT \\ RESIDENTIAL \\ MULTI- FAMILY",null,null,null,null,null,null,null,null,null,"DELAWARE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 10","NWP 16","NWP 16"]
["E2RF",null,null,null,null,"UPLAND",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 11",null,null,"Withdrawn For Lack Of Applicant Response ","DEVELOPMENT \\ RESIDENTIAL \\ SINGLE FAMILY",null,null,null,null,null,null,null,null,null,"DISTRICT OF COLUMBIA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 11","NWP 17","NWP 17"]
["E2RS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 12",null,null,"Withdrawn To Become A General Permit ","DREDGING \\ BOAT SLIP",null,null,null,null,null,null,null,null,null,"FLORIDA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 12","NWP 18","NWP 18"]
["E2SB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 13",null,null,"Withdrawn To Become A Letter of Permission (LOP) ","DREDGING \\ CHANNELIZATION",null,null,null,null,null,null,null,null,null,"GEORGIA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 13","NWP 19","NWP 19"]
["E2SS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 14",null,null,"Withdrawn To Become A Standard Permit","DREDGING \\ DISPOSAL",null,null,null,null,null,null,null,null,null,"GUAM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 14","NWP 20","NWP 20"]
["E2US",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 15",null,null,null,"DREDGING \\ GENERAL",null,null,null,null,null,null,null,null,null,"HAWAII",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 15","NWP 21","NWP 21"]
["L1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 16",null,null,null,"DREDGING \\ MAINTENANCE",null,null,null,null,null,null,null,null,null,"IDAHO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 18","NWP 22","NWP 22"]
["L1AB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 17",null,null,null,"DREDGING \\ NAVIGATION \\ FEDERAL SPONSOR",null,null,null,null,null,null,null,null,null,"ILLINOIS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 19","NWP 23","NWP 23"]
["L1OW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 18",null,null,null,"DREDGING \\ NAVIGATION \\ PRIVATE",null,null,null,null,null,null,null,null,null,"INDIANA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 20","NWP 25","NWP 25"]
["L1RB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 19",null,null,null,"ENERGY GENERATION \\ COAL",null,null,null,null,null,null,null,null,null,"IOWA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 21","NWP 27","NWP 27"]
["L1UB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 20",null,null,null,"ENERGY GENERATION \\ COGEN",null,null,null,null,null,null,null,null,null,"KANSAS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 22","NWP 29","NWP 29"]
["L2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 21",null,null,null,"ENERGY GENERATION \\ GEOTHERMAL",null,null,null,null,null,null,null,null,null,"KENTUCKY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 23","NWP 30","NWP 30"]
["L2AB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 22",null,null,null,"ENERGY GENERATION \\ HYDROPOWER ",null,null,null,null,null,null,null,null,null,"LOUISIANA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 24","NWP 31","NWP 31"]
["L2EM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 23",null,null,null,"ENERGY GENERATION \\ KINETIC",null,null,null,null,null,null,null,null,null,"MAINE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 27","NWP 32","NWP 32"]
["L2OW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 24",null,null,null,"ENERGY GENERATION \\ NATURAL GAS",null,null,null,null,null,null,null,null,null,"MARYLAND",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 28","NWP 33","NWP 33"]
["L2RB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 25",null,null,null,"ENERGY GENERATION \\ NUCLEAR",null,null,null,null,null,null,null,null,null,"MASSACHUSETTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 29","NWP 34","NWP 34"]
["L2RS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 27",null,null,null,"ENERGY GENERATION \\ OIL",null,null,null,null,null,null,null,null,null,"MICHIGAN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 31","NWP 36","NWP 36"]
["L2UB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 28",null,null,null,"ENERGY GENERATION \\ SOLAR",null,null,null,null,null,null,null,null,null,"MINNESOTA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 32","NWP 37","NWP 37"]
["L2US",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 29",null,null,null,"ENERGY GENERATION \\ WIND ",null,null,null,null,null,null,null,null,null,"MISSISSIPPI",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 33","NWP 38","NWP 38"]
["M1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 30",null,null,null,"MINING AND DRILLING \\ DRILLING \\ ACCESS ",null,null,null,null,null,null,null,null,null,"MISSOURI",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 35","NWP 39","NWP 39"]
["M1AB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 31",null,null,null,"MINING AND DRILLING \\ DRILLING \\ FACILITIES",null,null,null,null,null,null,null,null,null,"MONTANA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 36","NWP 40","NWP 40"]
["M1OW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 32",null,null,null,"MINING AND DRILLING \\ DRILLING \\ GAS",null,null,null,null,null,null,null,null,null,"NEBRASKA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 37","NWP 41","NWP 41"]
["M1RB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 33",null,null,null,"MINING AND DRILLING \\ DRILLING \\ OIL",null,null,null,null,null,null,null,null,null,"NEVADA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 38","NWP 42","NWP 42"]
["M1RF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 34",null,null,null,"MINING AND DRILLING \\ DRILLING \\ SHALE GAS",null,null,null,null,null,null,null,null,null,"NEW HAMPSHIRE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 39","NWP 43","NWP 43"]
["M1UB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 35",null,null,null,"MINING AND DRILLING \\ MINING \\ ACCESS",null,null,null,null,null,null,null,null,null,"NEW JERSEY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 44","NWP 44","NWP 44"]
["M2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 36",null,null,null,"MINING AND DRILLING \\ MINING \\ COAL \\ MINE THROUGH",null,null,null,null,null,null,null,null,null,"NEW MEXICO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 45","NWP 45","NWP 45"]
["M2AB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 37",null,null,null,"MINING AND DRILLING \\ MINING \\ COAL \\ REFUSE FILL",null,null,null,null,null,null,null,null,null,"NEW YORK",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 48","NWP 46","NWP 46"]
["M2RF",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 38",null,null,null,"MINING AND DRILLING \\ MINING \\ COAL \\ REMINING",null,null,null,null,null,null,null,null,null,"NORTH CAROLINA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 49","NWP 48","NWP 48"]
["M2RS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 39",null,null,null,"MINING AND DRILLING \\ MINING \\ COAL \\ UNDERGROUND",null,null,null,null,null,null,null,null,null,"NORTH DAKOTA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 50","NWP 49","NWP 49"]
["M2US",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 40",null,null,null,"MINING AND DRILLING \\ MINING \\ COAL \\ VALLEY FILL",null,null,null,null,null,null,null,null,null,"OHIO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 51","NWP 50","NWP 50"]
["PAB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 41",null,null,null,"MINING AND DRILLING \\ MINING \\ FACILITES",null,null,null,null,null,null,null,null,null,"OKLAHOMA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 52","NWP 51","NWP 51"]
["PAB1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 42",null,null,null,"MINING AND DRILLING \\ MINING \\ GRAVEL",null,null,null,null,null,null,null,null,null,"OREGON",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 53","NWP 52","NWP 52"]
["PAB2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 43",null,null,null,"MINING AND DRILLING \\ MINING \\ OTHER MINERAL",null,null,null,null,null,null,null,null,null,"PENNSYLVANIA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 54","NWP 53","NWP 53"]
["PAB3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 44",null,null,null,"MINING AND DRILLING \\ MINING \\ PEAT",null,null,null,null,null,null,null,null,null,"PUERTO RICO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 54","NWP 54"]
["PAB4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 45",null,null,null,"MINING AND DRILLING \\ MINING \\ PHOSPHATE",null,null,null,null,null,null,null,null,null,"RHODE ISLAND"]
["PAB5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 46",null,null,null,"MINING AND DRILLING \\ MINING \\ ROCK",null,null,null,null,null,null,null,null,null,"SOUTH CAROLINA"]
["PAB6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 48",null,null,null,"MINING AND DRILLING \\ MINING \\ SAND",null,null,null,null,null,null,null,null,null,"SOUTH DAKOTA"]
["PEM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 49",null,null,null,"MITIGATION \\ CREATION",null,null,null,null,null,null,null,null,null,"TENNESSEE"]
["PFO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 50",null,null,null,"MITIGATION \\ ENHANCEMENT",null,null,null,null,null,null,null,null,null,"TEXAS"]
["PML",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 51",null,null,null,"MITIGATION \\ FISH/WILDLIFE \\ CREATION",null,null,null,null,null,null,null,null,null,"UNITED STATES VIRGIN ISLANDS"]
["POW",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 52",null,null,null,"MITIGATION \\ FISH/WILDLIFE \\ ENHANCEMENT",null,null,null,null,null,null,null,null,null,"UTAH"]
["PRB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 53",null,null,null,"MITIGATION \\ FISH/WILDLIFE \\ PLANTING",null,null,null,null,null,null,null,null,null,"VERMONT"]
["PSS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NWP 54",null,null,null,"MITIGATION \\ FISH/WILDLIFE \\ PRESERVATION",null,null,null,null,null,null,null,null,null,"VIRGINIA"]
["PUB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MITIGATION \\ FISH/WILDLIFE \\ RESTORATION",null,null,null,null,null,null,null,null,null,"WASHINGTON"]
["R1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MITIGATION \\ FISH/WILDLIFE \\ SEEDING",null,null,null,null,null,null,null,null,null,"WEST VIRGINIA"]
["R1AB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MITIGATION \\ MITIGATION BANK",null,null,null,null,null,null,null,null,null,"WISCONSIN"]
["R1EM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MITIGATION \\ PRESERVATION",null,null,null,null,null,null,null,null,null,"WYOMING"]
["R1RB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MITIGATION \\ RESTORATION \\ STREAM"]
["R1RS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MITIGATION \\ RESTORATION \\ WETLAND"]
["R1SB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MITIGATION \\ WETLAND RECLAMATION"]
["R1UB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OTHER \\ BANK STABILIZATION"]
["R1US",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OTHER \\ CLEANUP HAZARDOUS OR TOXIC WASTES"]
["R2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OTHER \\ DAMS \\ COFFER"]
["R2AB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OTHER \\ DAMS \\ GENERAL"]
["R2EM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OTHER \\ DAMS \\ LOW WATER"]
["R2RB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OTHER \\ DAMS \\ MAINTENANCE"]
["R2RS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OTHER \\ DAMS \\ REMOVAL"]
["R2UB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OTHER \\ DAMS \\ RESERVOIR"]
["R2US",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OTHER \\ DAMS \\ WEIR"]
["R3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OTHER \\ INDIAN TRIBE OR STATE 404 PROGRAM"]
["R3AB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OTHER \\ MOSQUITO DITCHING"]
["R3RB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OTHER \\ OCEAN DISPOSAL"]
["R3RS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OTHER \\ RESTRICTED AREAS"]
["R3UB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OTHER \\ SURVEY ACTIVITIES"]
["R3US",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OTHER \\ TREASURE HUNTING"]
["R4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STRUCTURE \\ AIDS TO NAVIGATION"]
["R4SB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STRUCTURE \\ BOAT HOUSE"]
["R5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STRUCTURE \\ BOAT LIFT"]
["R5AB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STRUCTURE \\ BOAT RAMP"]
["R5RB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STRUCTURE \\ BREAKWATER"]
["R5RS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STRUCTURE \\ BRIDGE/RELATED WORK"]
["R5UB",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STRUCTURE \\ BULKHEAD "]
["R5US",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STRUCTURE \\ CRIB"]
["R6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STRUCTURE \\ DOCK \\ FIXED"]
["RP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STRUCTURE \\ DOCK \\ FLOATING"]
["RP1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STRUCTURE \\ DOLPHINS"]
["RP1EM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STRUCTURE \\ ELEV REC DECK"]
["RP1FO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STRUCTURE \\ GABION"]
["RP1SS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STRUCTURE \\ GROIN"]
["RP2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STRUCTURE \\ INTAKE/OUTFALL"]
["RP2EM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STRUCTURE \\ MAINTENANCE"]
["RP2FO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STRUCTURE \\ MARINA"]
["RP2SS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STRUCTURE \\ MARINE RAIL"]
["U",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STRUCTURE \\ MISCELLANEOUS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STRUCTURE \\ MOORED BARGE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STRUCTURE \\ MOORED VESSELS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STRUCTURE \\ MOORING BOUY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STRUCTURE \\ MOORING PILING"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STRUCTURE \\ NAVIGATION BUOY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STRUCTURE \\ PIER \\ NON-RESIDENTIAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STRUCTURE \\ PIER \\ RESIDENTIAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STRUCTURE \\ PILE/DOLPHIN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STRUCTURE \\ RAMP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STRUCTURE \\ RECREATIONAL "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STRUCTURE \\ REMOVAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STRUCTURE \\ SCIENTIFIC DEVICE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STRUCTURE \\ UNSPECIFIED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STRUCTURE \\ UTILITY LINE OR STRUCTURE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STRUCTURE \\ WATER CONTROL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STRUCTURE \\ WEIR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRANSPORTATION \\ AIRPORT \\ FACILITY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRANSPORTATION \\ AIRPORT \\ MAINTENANCE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRANSPORTATION \\ AIRPORT \\ RUNWAY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRANSPORTATION \\ BRIDGE \\ CONSTRUCTION (NEW)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRANSPORTATION \\ BRIDGE \\ MAINTENANCE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRANSPORTATION \\ BRIDGE \\ PIER"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRANSPORTATION \\ BRIDGE \\ PROTECTION"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRANSPORTATION \\ BRIDGE \\ REMOVAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRANSPORTATION \\ BRIDGE \\ REPLACEMENT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRANSPORTATION \\ PIPELINE \\ ACCESS ROAD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRANSPORTATION \\ PIPELINE \\ AERIAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRANSPORTATION \\ PIPELINE \\ BURIED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRANSPORTATION \\ PIPELINE \\ MAINTENANCE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRANSPORTATION \\ PIPELINE \\ STRUCTURE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRANSPORTATION \\ PIPELINE \\ SUBMERGED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRANSPORTATION \\ RAIL \\ BRIDGE "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRANSPORTATION \\ RAIL \\ FACILITY"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRANSPORTATION \\ RAIL \\ MAINTENANCE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRANSPORTATION \\ RAIL \\ REMOVAL "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRANSPORTATION \\ RAIL \\ TRACK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRANSPORTATION \\ ROADS \\ AGRICULTURE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRANSPORTATION \\ ROADS \\ CROSSING (NON BRIDGE)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRANSPORTATION \\ ROADS \\ CULVERT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRANSPORTATION \\ ROADS \\ IMPROVEMENTS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRANSPORTATION \\ ROADS \\ LOGGING"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRANSPORTATION \\ ROADS \\ MAINTENANCE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRANSPORTATION \\ UTILITY \\ ACCESS ROAD"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRANSPORTATION \\ UTILITY \\ AERIAL"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRANSPORTATION \\ UTILITY \\ BURIED"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRANSPORTATION \\ UTILITY \\ MAINTENANCE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRANSPORTATION \\ UTILITY \\ STRUCTURE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TRANSPORTATION \\ UTILITY \\ SUBMERGED"]