Stormwater_reference2010

Metadata also available as - [Outline] - [Parseable text] - [XML]

Frequently-anticipated questions:


What does this data set describe?

Title: Stormwater_reference2010
Abstract:
The NC Center for Geographic Information and Analysis (CGIA) collaborated with the NC Division of Water Quality (DWQ) to develop a geospatial representation of stormwater permitting responsibility across the state. This reference layer represents permitting authority (local, state, multiple, or none) based on Phase II stormwater legislation, as well as other state and local programs that impose stormwater requirements. This dataset is based on the best available datasets as of the publication. This dataset uses mapped boundaries of all of North Carolina's counties as a base layer.
Supplemental_Information:
The delineation and classification of stormwater areas is based on the following description of North Carolina stormwater programs.
Post-Construction? requirements are a piece of the Phase II stormwater requirements for development projects in designated municipalities, their ETJs, urbanizing areas, and ?municipal sphere of influence? (MSI) boundaries around all Phase II municipalities. Either the State (DWQ) or the local government (city or county, depending) will implement Post-Construction requirements. There are other existing Stormwater Programs that, in some cases, satisfy the Phase II Post-Construction requirements. These do not change the areas where Phase II applies, but these other programs may dictate what the developer must do and/or from whom he/she gets approval for a plan. The following is a summary of how these programs interact:
Phase II Municipalities: Phase II Post-Construction is implemented in all Phase II municipalities and corresponding ETJs (with a few exceptions), even inside cities that were ?exempted? from a permit to run their own program either 1) because of population or 2) because they do not own or operate a municipal separate storm sewer system (MS4). If the municipality has an MS4 permit, it will implement the requirements. For ?exempted? entities, DWQ (or another delegated authority) implements Post-Construction within those jurisdictions instead. Other stormwater programs also still apply (and some may be ?deemed compliant? with Phase II). Therefore, in jurisdictions of exempted municipalities, the State (DWQ) implements Phase II, unless another program satisfies the requirement. For exempted Phase II municipalities where no other program is in place, the Central Office DWQ is the contact in non-coastal counties, and the DWQ Regional Office is the contact in coastal counties.
State Stormwater (State SW) Program: This program affects all 20 Coastal Counties, as well as watersheds draining to High Quality Waters (HQW) and Outstanding Resource Waters (ORW). It is specific to development in these areas and, for the most part, this program is implemented by the DWQ Regional Offices (ROs). Since the Coastal Stormwater Rules were revised in October 2008, it is no longer necessary to distinguish whether HQW and ORW waters are fresh- or saltwater because the rules are now more consistent with Phase II requirements. Where HQW or ORW watersheds overlap Phase II areas, the existing State Stormwater Program (Coastal, HQW, or ORW) satisfies Phase II, and the contact is the DWQ Regional Office (except in some coastal jurisdictions like Wilmington, where the city implements the coastal rules). It is important to note here that by definition, waters classified as WS-I, WS-II, and Shellfishing (SA) waters are all HQW. However, WS-I & WS-II are covered by the Water Supply Protection Program, implemented by the local governments and are not included in this sub-set of HQWs. In WS-I/II areas, the local government is the contact. The State SW Program affects:
 Development "within a half mile and draining to" SA waters; a half mile buffer should delineate all possible areas.  Very stringent density thresholds apply here.
 Development "within one mile of and draining to" HQW waters.  However, this criterion does not apply to WS-I, WS-II, and coastal (where many HQW are SA).
 Development "draining to" ORW waters (statewide).  These areas may be smaller than 14-digit hydrologic units.  Note that some watersheds have special management strategies tantamount to ORW requirements.
As of October 2008, the State Stormwater Program (Coastal and non-Coastal) requirements satisfy Phase II requirements.
Water Supply Watershed Protection Program: There are different tiers of Water Supply classifications, and each carries specific stormwater requirements. WS Protection Program stormwater requirements satisfy Phase II Post-Construction, the requirements are implemented by local governments. The breakdown of WS watersheds and requirements follows:
 WS-I & WS-II: Technically, these are subject to the State SW Program above, but the Water Supply Program at the local government level satisfies the HQW requirement (i.e., there is no need to get a State SW permit from the Regional Office).  Requirements will also vary based on whether the watershed is a Critical Area (CA) or Protected Area (PA).  However, where WS-I & WS-II areas overlap ORWs, both the DWQ Regional Office and the Local Government should be contacted (this is a correction from previous years, verified by J. Ventaloro of DWQ.)
 WS-III & WS-IV: These areas are different from the State SW program above but do have stormwater requirements at the local government level.  Where WS-III & WS-IV areas overlap HQWs, ORWs, or coastal counties, both the DWQ Regional Office and the Local Government should be contacted.
WS-I through WS-IV requirements in the WS Protection Program satisfy Phase II requirements. Where WS-I and WS-II overlap ORWs, both State SW Program and Local Program requirements apply. Where WS-III and WS-IV overlap HQW/ORW/Coastal Counties, both State SW Program and Local Program requirements apply.
Lake Randleman Water Supply Protection Stormwater Requirements: This is essentially a ?special? subset of the WS Watershed Protection Program. All local governments ?that have land use authority within the Randleman Lake watershed? must comply with the stormwater management rules for this program. Both Guilford and Randolph counties implement this program; therefore, a project anywhere in the watershed is subject to this program (and some jurisdictions may implement it within ETJ even beyond the watershed). The stormwater requirements differ based on whether the project is in the upper portion (part of Deep River watershed draining to Oakdale-Cotton Mill Dam) or lower portion (Deep River watershed upstream and draining to Randleman Lake Dam, from Oakdale-Cotton Mill Dam). The local governments that implement this program are: Guilford & Randolph counties; and the towns of Archdale, Greensboro, High Point, Jamestown, and Randleman. The Lake Randleman WS Protection requirements satisfy Phase II.
Neuse and Tar-Pamlico NSW Strategy Stormwater Management Programs:
The 15 largest local governments implement this program in the Neuse Basin (only portions within the basin):
Cary, Smithfield, Durham, Wilson, Garner, Goldsboro, Havelock, Kinston, New Bern, Raleigh, as well as Orange County*, Durham County*, Johnston County*, Wake County*, and Wayne County*.
Six municipalities and five counties implement this in the Tar-Pamlico Basin (only portions within the basin):
Greenville, Henderson, Oxford, Rocky Mount, Tarboro, and Washington. The counties are: Beaufort*, Edgecombe*, Franklin*, Nash*, and Pitt*. *Only applicable to areas under jurisdiction of respective county (i.e., unincorporated areas). Both the Neuse and Tar-Pamlico NSW strategy programs satisfy Phase II requirements. However, these programs do not satisfy State SW or WS requirements.
Lake Jordan Water Supply NSW Stormwater Management: These rules were finalized in August 2009 as Session Law 2009-484. Ultimately, stormwater management requirements for new development will apply to local governments in the Jordan watershed. For more information on which local governments currently do what, go to www.jordanlake.org. Right now, DWQ continues to administer Phase II requirements in parts of this watershed.
Falls Lake Water Supply NSW Stormwater Management: Draft rules on this strategy went out to public comment in March 2010. Ultimately, stormwater management requirements for new development will apply to local governments in the Jordan watershed. Right now, DWQ continues to administer Phase II requirements in parts of this watershed.
It is important to remember that a local government may choose to pass ordinances, etc. that are above and beyond what existing stormwater programs or Phase II Post-Construction. This is even a possibility in areas outside of Phase II areas. Therefore, it is important to remind the user to check for specific local government requirements no matter where they are.
  1. How should this data set be cited?

    NC Division of Water Quality with Assistance from the NC Center for Geographic Information and Analysis, 20090715, Stormwater_reference2010.

    Online Links:

    • www.nconemap.com

    Other_Citation_Details: This layer published 20100715 with the assistance of CGIA

  2. What geographic area does the data set cover?

    West_Bounding_Coordinate: -84.422111
    East_Bounding_Coordinate: -75.416034
    North_Bounding_Coordinate: 36.617257
    South_Bounding_Coordinate: 33.730557

  3. What does it look like?

  4. Does the data set describe conditions during a particular time period?

    Calendar_Date: 15-Jul-2010
    Time_of_Day: unknown
    Currentness_Reference: publication date

  5. What is the general form of this data set?

    Geospatial_Data_Presentation_Form: vector digital data

  6. How does the data set represent geographic features?

    1. How are geographic features stored in the data set?

      This is a Vector data set. It contains the following vector data types (SDTS terminology):

      • G-polygon (1979)

    2. What coordinate system is used to represent geographic features?

      Grid_Coordinate_System_Name: State Plane Coordinate System 1983
      State_Plane_Coordinate_System:
      SPCS_Zone_Identifier: 3200
      Lambert_Conformal_Conic:
      Standard_Parallel: 34.333333
      Standard_Parallel: 36.166667
      Longitude_of_Central_Meridian: -79.000000
      Latitude_of_Projection_Origin: 33.750000
      False_Easting: 609601.220000
      False_Northing: 0.000000

      Planar coordinates are encoded using coordinate pair
      Abscissae (x-coordinates) are specified to the nearest 0.002048
      Ordinates (y-coordinates) are specified to the nearest 0.002048
      Planar coordinates are specified in meters

      The horizontal datum used is North American Datum of 1983.
      The ellipsoid used is Geodetic Reference System 80.
      The semi-major axis of the ellipsoid used is 6378137.000000.
      The flattening of the ellipsoid used is 1/298.257222.

  7. How does the data set describe geographic features?

    Stormwater_reference2010
    Stormwater permitting responsibility in North Carolina (Source: CGIA and NC Division of Water Quality)

    FID
    Internal feature number. (Source: ESRI)

    Sequential unique whole numbers that are automatically generated.

    Shape
    Feature geometry. (Source: ESRI)

    Coordinates defining the features.

    JURISDIC
    Jurisdiction of area (Source: NC CGIA)

    Varies by location based on jurisdicational boundaries available at time of processing.

    PERMITTING
    Responsibility for stormwater permitting (Source: NC Division of Water Quality)

    ValueDefinition
    LocalCounty or municipal responsibility in the area based on Phase II and other programs; may be multiple local programs.
    StateState responsibility for stormwater permitting in the area
    NoneNo stormwater permitting responsibility in the area (still must check locally)
    MultipleLocal and state permits may apply in the area

    TYPE
    Type of stormwater permit (Source: NC Division of Water Quality)

    ValueDefinition
    Coastal county or communityStormwater permitting responsibility is based on location in a coastal (CAMA) county
    Coastal county, Coast GuardStormwater permitting responsibility is based on location in a coastal (CAMA) county
    Coastal county, military areaStormwater permitting responsibility is based on location in a coastal (CAMA) county and whether military area is subject Phase II
    Entity in Phase II tipped countyStormwater permitting responsibility is based on location in a tipped Phase II county
    None, Unincorporated area, CountyNo stormwater programs apply in the unincorporated area of county
    None, Muncipality BoundariesNo stormwater program applies in an incorporated area that may be all or part of a city or town
    None, ETJ BoundariesNo stormwater program applies in extraterritorial jurisdiction that may be all or part of an ETJ
    High Quality or Outstanding WatersArea is within 1-mile buffer of a high quality water or within an outstanding resource water watershed
    Water Supply WatershedStormwater permitting responsibility is based on water supply watershed area
    Water Supply I/II AreaStormwater permitting responsibility is based on WS-I/II classification (HQW by definition, but local program satisfies)
    Water Supply AND coastal co.Stormwater permitting responsibility is based on WS watershed and Coastal SW Program
    HQW/ORW Area AND Water SupplyStormwater permitting responsibility is based on overlapping HQW/ORW and WS-III/IV/V watersheds, or WS-I/II and ORW watersheds
    HQW/ORW, Water Supply, AND NSWStormwater permitting responsibility is based on overlapping HQW/ORW, WS-III/IV (or WS-I/II and ORW), and NSW watersheds
    Phase II EntityStormwater permitting responsibility is based on NPDES Stormwater Phase II Program implemented by an entity (may be military) in NC under the US EPA, National Pollution Discharge Elimination System MS4 regulations
    Phase II entity, coastal co.Stormwater permitting responsibility is based on NPDES Stormwater Phase II Program implemented by an entity (may be military) in NC in a coastal county
    Phase II city or ETJStormwater permitting responsibility is based on NPDES Stormwater Phase II Program implemented by a city in NC
    Phase II city or ETJ, coastal co.Stormwater permitting responsibility is based on NPDES Stormwater Phase II Program implemented by a city in NC in a coastal county
    Phase II tipped countyArea is unincorporated area of a county that is "tipped in" to Phase II stormwater permitting requirements by Session Law 2006-246
    Phase II MSI or UAArea is within a municipal buffer defined by a 1-mile buffer for cities under 10,000 population (2000 Census), by a 2-mile buffer for cities with 10,000 to 24,999 population, and by a 3-mile for cities with 25,000 or more residents; or within an Urbanizing Area (based on 2000 census).
    Military, Phase II MS4In NPDES-permitted military MS4 area; stormwater permitting responsibility currently defaults to State (unlike other permitted MS4s)
    Military, Phase II MS4 (coastal)Area in NPDES-permitted military MS4 area in coastal county; stormwater permitting responsibility currently defaults to State (unlike other permitted MS4s)
    NSW city or countyStormwater permitting responsibility is based on local NSW Strategy Program entity
    NSW city or county, military areaIn military area; Stormwater permitting responsibility is based on local NSW Strategy Program entity
    NSW community AND HQW/ORWStormwater permitting responsibility is based on local NSW Strategy Program entity and HQW/ORW watershed area
    NSW community AND Water SupplyStormwater permitting responsibility is based on local NSW Strategy Program entity and water supply watershed area
    NSW community AND coastal co.Stormwater permitting responsibility is based on local NSW Strategy Program entity and Coastal SW Program
    Unincorporated area, CountyStormwater permitting responsibility in unincorporated areas of Jordan Lake Watershed depend on Jordan Rules timeline
    Municipality BoundariesStormwater permitting responsibility in municipalities of Jordan Lake Watershed depend on Jordan Rules timeline

    BASIS
    Basis or criteria for stormwater permitting (Source: NC Division of Water Quality)

    Varies from city or county name to watershed type to state program type

    NOTE
    Notes about the location or permitting responsibility, or other relevant information (Source: NC Division of Water Quality)

    Notes vary by location.

    CONTACT
    Contact information for stormwater permitting (Source: NC Division of Water Quality)

    Contacts vary by program and jurisdiction

    COUNTY
    County in which the jurisdiction is located (Source: CGIA)

    Formal codeset
    Codeset Name:100 counties of North Carolina
    Codeset Source:CGIA

    DENR_RGN
    Regional office of the Department of Environment and Natural Resources (Source: CGIA)

    Formal codeset
    Codeset Name:8 regions served by DENR regional offices
    Codeset Source:CGIA

    CATEGORY
    Category of permitting responsibility for purpose of grouping cases of unique and overlapping stormwater programs (Source: NC DWQ Stormwater Planning and CGIA)

    ValueDefinition
    No Stormwater ProgramTYPE of Permitting is "None, ETJ Boundaries" OR "None, Federally Managed Lands" OR "None, Municpality Boundaries" OR "None, Unincorporated area, County"
    Overlapping ProgramsTYPE of permitting is "HQW/ORW Area AND Water Supply" OR "NSW community AND HQW/ORW" OR "NSW community AND Water Supply" OR "NSW community AND coastal co." OR "Water Supply AND coastal co." OR "HQW/ORW, Water Supply, AND NSW"
    Local ProgramPERMITTING Authority is "Local"
    SA watersBASIS of permitting is "SA Waters, Coastal State SW Programm" OR "SA Waters, Coastal State SW Program" OR "SA is HQW by definition/State SW Prog" OR "ORW/SA Watershed" OR "ORW/SA Watershed, State SW Prog"
    Coastal State SW ProgramTYPE of permitting "Coastal county or community" OR "Coastal county, military area" OR "Coastal county, Coast Guard"
    State Stormwater ProgramTYPE of permitting is "High Quality or Outstanding Waters"
    Phase II AreaTYPE of permitting is "Entity in Phase II tipped county" OR "Military, Phase II MS4 (coastal)" OR "Military, Phase II MS4" OR "Phase II Entity" OR "Phase II MSI or UA" OR "Phase II city or ETJ" OR "Phase II city or ETJ, coastal co." OR "Phase II entity, coastal co." OR "Phase II tipped county"

    PH2_INFO
    Indicator for Phase II area and whether existing programs satisfy that requirement (Source: NC Division of Water Quality)

    ValueDefinition
    Not a Phase II areaArea not subject to Phase II requirements of Session Law 2006-246
    Local program satisfies Phase II rqmtsPERMITTING Authority is "Local" and area is subject to Phase II
    Local prog eventually satisfies Phase II rqmtsDesignated Phase II city areas where the city will ultimately implment its own program (but may not be doing it yet).
    Coastal/State SW Prog satisfies Ph IICOUNTY is a coastal county, PERMITTING Authority is "State" and area is subject to Phase II
    Coastal/Local SW Progs satisfy Ph IICOUNTY is a coastal county, PERMITTING Authority is "Multiple" and area is subject to Phase II
    State SW Program satisfies Phase IICOUNTY is not a coastal county, area is in HQW or ORW watershed and is subject to Phase II
    Subject to Phase II Post-ConstructionAll other areas subject to Phase II requirements of Session Law 2006-246

    SW_ID
    Unique identifier for stormwater reference (Source: NC CGIA)

    Sequential unique whole numbers calculated as FID+1

    Entity_and_Attribute_Overview:
    Descriptors relating to stormwater permitting responsibility, stormwater programs, contact information, county and region.
    Entity_and_Attribute_Detail_Citation:
    North Carolina Center for Geographic Information and Analysis in collaboration with the Division of Water Quality in the NC Department of Environment and Natural Resources.


Who produced the data set?

  1. Who are the originators of the data set? (may include formal authors, digital compilers, and editors)

  2. Who also contributed to the data set?

    NC Department of Environment and Natural Resources, Division of Water Quality, Stormwater Permitting Unit NC Department of Environment and Natural Resources, Center for Geographic Information and Analysis

  3. To whom should users address questions about the data?

    CGIA
    c/o David Giordano
    20322 Mail Service Center
    Raleigh, NC 27699-0322
    USA

    919-754-6580 (voice)
    919-715-8551 (FAX)
    dataq@its.nc.gov

    Hours_of_Service: 8:00 AM to 5:00 PM
    Contact_Instructions: Phone and electronic mail preferred


Why was the data set created?

These data are intended to assist government agencies and their constituents in identifying which stormwater permitting requirements, if any, apply to a given location in North Carolina. This data set includes attributes relating to stormwater programs (nutrient management strategy areas/local governments, water supply watersheds, high quality and outstanding waters areas, etc.) and jurisdictions, including federally managed areas (e.g., military bases).


How was the data set created?

  1. From what previous works were the data drawn?

    NC OneMap Database (source 1 of 1)
    CGIA, NC, 2010, NC OneMap Database.

    Online Links:

    • www.nconemap.com

    Type_of_Source_Media: online
    Source_Scale_Denominator: 24000
    Source_Contribution:
    Source layers were processed in the model to produce polygons representing stormwater permitting responsibility across the state.

  2. How were the data generated, processed, and modified?

    Date: 15-Jul-2010 (process 1 of 4)
    Using the ArcGIS Spatial Analyst Extension and Model Builder, a model was constructed to process 9 source layers and produce output representing stormwater permitting responsibility. The first model input feature is a jurisdictional boundary layer (a GIS layer that combines NC county boundaries with municipalities, ETJs (provided by NC CGIA), military boundaries, and NPDES-permitted county areas, and which was created with a smaller model constructed out of those 4 source layers). That feature contains information about the Phase II status of municipalities, ETJs, and counties; identifies coastal counties under Coastal Area Management Act (state); and identifies areas that are federally managed (military and Coast Guard). The first identity feature is the urbanizing areas (according to the most recent US Census). The first function is an identity that computes the geometric intersection of the input feature and the identity feature; the input feature or portions thereof that overlap the identity feature will get the attributes of the identity feature. In a series of 8 identity functions, the output from the previous identity becomes the input feature for the next identity. The identity features, in sequence, are: Urbanizing areas (as defined by the US Bureau of the Census); municipal buffers around Phase II cities representing municipal sphere of influence (pre-processed buffers of 1-mile (municipalities with Census 2000 population below 10,000), 2-miles (population 10,000 to 24,999) and 3-mile (population 25,000 and over)); High Quality Water Outstanding Resource Water (HQW/ORW) watersheds excepting Water Supply Watersheds WS-I and WS-II; NSW Strategy areas including the Neuse and Tar-Pamlico Programs; Water Supply Watersheds; Special Watersheds including areas like Goose Creek and Jordan Reservoir, which dictate specific stormwater requirements; SA areas defined by 1/2-mile around all SA waters; and finally all areas subject to "Phase II" per Session Law 2006-246. Further editing of special cases are necessary to accurately address all areas of the state (for example, changing contacts where local governments are delegated authority to implement Phase II stormwater requirements).

    Person who carried out this activity:

    Bethany Georgoulias
    NC DENR/DWQ
    Environmental Engineer
    1617 Mail Service Center
    Raleigh, NC 27699-1617
    USA

    919-807-6372 (voice)
    919-807-6494 (FAX)
    bethany.georgoulias@ncdenr.gov

    Hours_of_Service: 8:00 AM to 5:00 PM
    Date: 15-Jul-2010 (process 2 of 4)
    The output shapefile from the model contained fields from all of the source files. The desired output needed a set of 8 meaningful fields that retain the appropriate values from the series of identities.
    ModelBuilder: Set up 8 identities in sequence
    Validate Entire Model
    Run Entire Model
    Identity_8_phase2area.shp has 4,545 polygons
    Export copy of data set to SWref2010mmdd_final_identity.shp
    Add new fields:
    PERMITTING (10), TYPE (35), BASIS (40), NOTE (40), CONTACT (45), CATEGORY (50), DENR_RGN (30), and PH2_INFO (40).
    Carry these exisiting fields through:
    COUNTY (15), JURISDIC (150) >> shortened to JURISDIC (40) in final layer
    Some text revisions necessary depending on input file records and have been documented by the Stormwater Permitting Unit.
    Calculate values of the new fields in the output shapefile by using Pre-logic VBA code scripts for specific fields. For SWref2010mmdd_final_identity.shp, the following script describes how each field was calculated for each scenario. (Note some fields used in the calculations will be dropped in the final reference layer):
    /*No program applies*/
    IF ( [FID_urbani] = -1 AND [FID_phase2] = -1 AND [FID_hqworw] = -1 AND [FID_nsw_st] = -1 AND [FID_wsws] = -1 AND [CAMA] = "no" AND [TIP_STATUS] = "Not Tipped" AND NOT([WHAT_KIND] = "Designated Phase II city") AND NOT([WHAT_KIND] = "ETJ of exempt Phase II city") AND NOT([WHAT_KIND] = "NPDES Permitted Phase I MS4") AND NOT([WHAT_KIND] = "NPDES Permitted Phase II MS4") AND NOT([WHAT_KIND] = "Phase II city (Exempt)") AND NOT([WHAT_KIND] = "Phase II city ETJ") AND NOT([WHAT_KIND] = "Phase II city, exempt ETJ") AND NOT([WHAT_KIND] = "NPDES Permitted Ph II MS4/Co")) THEN PERMIT = "None" AUTH = [JURISDIC] REAS = "No Program Identified" DESC = "None, " & [INSIDE] INFO = "Verify with local authority"
    /*NSW Program only, non-coastal co.*/
    ELSEIF ( [FID_hqworw] = -1 AND NOT([FID_nsw_st] = -1) AND [FID_wsws] = -1 AND [CAMA] = "no" ) THEN PERMIT = "Local" AUTH = [COMMUNITY] REAS = [NSW_PROG] DESC = "NSW city or county" INFO = "Ref. 15A NCAC 2B .0200 Rules"
    /*NSW Program only, coastal co.*/
    ELSEIF ( [FID_hqworw] = -1 AND NOT([FID_nsw_st] = -1) AND [FID_wsws] = -1 AND NOT([CAMA] = "no") ) THEN PERMIT = "Multiple" AUTH = [COMMUNITY] & " and DWQ Regional Office" REAS = [NSW_PROG] & " and CAMA Co." DESC = "NSW community AND coastal co." INFO = "Coastal SW Rules also apply"
    /*WS Program only, non-coastal co.*/
    ELSEIF ( [FID_hqworw] = -1 AND [FID_nsw_st] = -1 AND NOT([FID_wsws] = -1) AND [CAMA] = "no" ) THEN PERMIT = "Local" AUTH = "Local Water Supply Protection Program" REAS = [CLASS_1] & " Watershed" DESC = "Water Supply Watershed" INFO = "<http://portal.ncdenr.org/web/wq/swp/ws/wswp>"
    /*WS-III/IV and coastal co.*/
    ELSEIF ( [FID_hqworw] = -1 AND [FID_nsw_st] = -1 AND NOT([FID_wsws] = -1) AND NOT([CAMA] = "no") AND ([CLASS_1] LIKE "*WS-III*" OR [CLASS_1] LIKE "*WS-IV*") ) THEN PERMIT = "Multiple" AUTH = "Local WS Program and DWQ Regional Office" REAS = [CLASS_1] & " Watershed" & " and CAMA Co." DESC = "Water Supply AND coastal co." INFO = "Coastal SW Rules also apply"
    /*WS-I/II and coastal co.*/
    ELSEIF ( [FID_hqworw] = -1 AND [FID_nsw_st] = -1 AND NOT([FID_wsws] = -1) AND NOT([CAMA] = "no") AND ([CLASS_1] LIKE "*WS-I*" OR [CLASS_1] LIKE "*WS-II*") ) THEN PERMIT = "Local" AUTH = "Local Water Supply Protection Program" REAS = [CLASS_1] & " Watershed" DESC = "Water Supply I/II in coastal co." INFO = "<http://portal.ncdenr.org/web/wq/swp/ws/wswp>"
    /*HQW/ORW State Program only*/
    ELSEIF ( NOT([FID_hqworw] = -1) AND [FID_nsw_st] = -1 AND [FID_wsws] = -1) THEN PERMIT = "State" AUTH = "DWQ Regional Office" REAS = [CLASS] & " Watershed" DESC = "High Quality or Outstanding Waters" INFO = "State Stormwater Permitting Program"
    /*HQW/ORW State Program & NSW Program, non-coastal*/
    ELSEIF ( NOT([FID_hqworw] = -1) AND NOT([FID_nsw_st] = -1) AND [FID_wsws] = -1 AND [CAMA] = "no") THEN PERMIT = "Multiple" AUTH = "DWQ Regional Office and " & [COMMUNITY] REAS = [CLASS] & " and " & [NSW_PROG] DESC = "NSW community AND HQW/ORW" INFO = "Contact includes NSW Prog. Local Gov."
    /*HQW/ORW State Program & WS Program, non-coastal*/
    ELSEIF ( NOT([FID_hqworw] = -1) AND [FID_nsw_st] = -1 AND NOT([FID_wsws] = -1) AND [CAMA] = "no" AND ([CLASS_1] LIKE "*WS-III*" OR [CLASS_1] LIKE "*WS-IV*" OR [CLASS_1] = "WS" OR [CLASS] LIKE "*ORW*") ) THEN PERMIT = "Multiple" AUTH = "DWQ Regional Office and Local WS Program" REAS = [CLASS] & " and " & [CLASS_1] & " Watershed" DESC = "HQW/ORW Area AND Water Supply" INFO = "<http://portal.ncdenr.org/web/wq/swp/ws/wswp>"
    ELSEIF ( NOT([FID_hqworw] = -1) AND [FID_nsw_st] = -1 AND NOT([FID_wsws] = -1) AND [CAMA] = "no" AND ([CLASS_1] LIKE "*WS-I*" OR [CLASS_1] LIKE "*WS-II*") ) THEN PERMIT = "Local" AUTH = "Local Water Supply Protection Program" REAS = [CLASS] & " and " & [CLASS_1] & " Watershed" DESC = "Water Supply I/II Area" INFO = "<http://portal.ncdenr.org/web/wq/swp/ws/wswp>"
    /*HQW/ORW State Program & NSW Program, coastal*/
    ELSEIF ( NOT([FID_hqworw] = -1) AND NOT([FID_nsw_st] = -1) AND [FID_wsws] = -1 AND NOT([CAMA] = "no") ) THEN PERMIT = "Multiple" AUTH = "DWQ Regional Office and " & [COMMUNITY] REAS = "Coastal " & [CLASS] & " and " & [NSW_PROG] DESC = "NSW community AND HQW/ORW, coastal" INFO = "Contact includes NSW Prog. Local Gov."
    /*HQW/ORW State Program & WS Program, coastal*/
    ELSEIF ( NOT([FID_hqworw] = -1) AND [FID_nsw_st] = -1 AND NOT([FID_wsws] = -1) AND NOT([CAMA] = "no") AND ([CLASS_1] LIKE "*WS-III*" OR [CLASS_1] LIKE "*WS-IV*" OR [CLASS_1] = "WS" OR [CLASS] LIKE "*ORW*") ) THEN PERMIT = "Multiple" AUTH = "DWQ Regional Office and Local WS Program" REAS = "Coastal " & [CLASS] & " and " & [CLASS_1] & " Watershed" DESC = "HQW/ORW AND Water Supply, coastal" INFO = "<http://portal.ncdenr.org/web/wq/swp/ws/wswp>"
    ELSEIF ( NOT([FID_hqworw] = -1) AND [FID_nsw_st] = -1 AND NOT([FID_wsws] = -1) AND NOT([CAMA] = "no") AND ([CLASS_1] LIKE "*WS-I*" OR [CLASS_1] LIKE "*WS-II*") ) THEN PERMIT = "Local" AUTH = "Water Supply Protection Program" REAS = "Coastal " & [CLASS] & " and " & [CLASS_1] & " Watershed" DESC = "Water Supply I/II Area, coastal" INFO = "<http://portal.ncdenr.org/web/wq/swp/ws/wswp>"
    /*NSW and WS Programs, non-coastal co.*/
    ELSEIF ( [FID_hqworw] = -1 AND NOT([FID_nsw_st] = -1) AND NOT([FID_wsws] = -1) AND [CAMA] = "no" ) THEN PERMIT = "Local" AUTH = [COMMUNITY] & " and Local WS Program" REAS = [NSW_PROG] & " and " & [CLASS_1] DESC = "NSW community AND Water Supply" INFO = "<http://portal.ncdenr.org/web/wq/swp/ws/wswp>"
    /*NSW and WS Programs, coastal co.*/
    /*There are currently no cases of this overlap in CAMA counties.*/
    /*NSW and WS Programs and HQW/ORW, coastal and non-coastal*/
    ELSEIF ( NOT([FID_hqworw] = -1) AND NOT([FID_nsw_st] = -1) AND NOT([FID_wsws] = -1) AND [CAMA] = "no" AND ([CLASS_1] LIKE "*WS-III*" OR [CLASS_1] LIKE "*WS-IV*" OR [CLASS_1] = "WS" OR [CLASS] LIKE "*ORW*") ) THEN PERMIT = "Multiple" AUTH = [COMMUNITY] & ", Local WS Prog, and" & " DWQ Reg Office" REAS = [CLASS] & " " & [CLASS_1] & " and " & [NSW_PROG] DESC = "HQW/ORW, Water Supply, AND NSW" INFO = "<http://portal.ncdenr.org/web/wq/swp/ws/wswp>"
    ELSEIF ( NOT([FID_hqworw] = -1) AND NOT([FID_nsw_st] = -1) AND NOT([FID_wsws] = -1) AND [CAMA] = "no" AND ([CLASS_1] LIKE "*WS-I*" OR [CLASS_1] LIKE "*WS-II*") ) THEN PERMIT = "Local" AUTH = [COMMUNITY] & " and Local WS Program" REAS = [CLASS] & " " & [CLASS_1] & " and " & [NSW_PROG] DESC = "Water Supply I/II Area AND NSW" INFO = "<http://portal.ncdenr.org/web/wq/swp/ws/wswp>"
    /*Coastal SW Program only*/
    ELSEIF ([FID_hqworw] = -1 AND [FID_nsw_st] = -1 AND [FID_wsws] = -1 AND NOT([CAMA] = "no") AND NOT([WHAT_KIND] = "Designated Phase II city") AND NOT([WHAT_KIND] = "ETJ of exempt Phase II city") AND NOT([WHAT_KIND] = "NPDES Permitted Phase I MS4") AND NOT ([WHAT_KIND] = "NPDES Permitted Phase II MS4") AND NOT([WHAT_KIND] = "Phase II city (Exempt)") AND NOT([WHAT_KIND] = "Phase II city ETJ") AND NOT([WHAT_KIND] = "Phase II city, exempt ETJ") AND NOT([WHAT_KIND] = "NPDES Permitted Ph II MS4/Co") ) THEN PERMIT = "State" AUTH = "DWQ Regional Office" REAS = "Coastal State SW Permitting Program" DESC = "Coastal county or community" INFO = "Coastal SW Rules apply"
    /*Phase I/II Military Areas, coastal co. - State DWQ implements Coastal SW Rules*/
    ELSEIF ([FID_hqworw] = -1 AND [FID_nsw_st] = -1 AND [FID_wsws] = -1 AND NOT([CAMA] = "no") AND ([WHAT_KIND] = "NPDES Permitted Phase I MS4" OR [WHAT_KIND] = "NPDES Permitted Phase II MS4") AND [INSIDE] = "Federally Managed Lands" ) THEN PERMIT = "State" AUTH = "DWQ Regional Office/" & [JURISDIC] REAS = "Coastal State SW Permitting Program" DESC = "Military, Phase II MS4 (coastal)" INFO = "In " & [JURISDIC]
    /*Phase I/II Military Areas, non-coastal co. - State DWQ implements Post-Construction*/
    ELSEIF ([FID_hqworw] = -1 AND [FID_nsw_st] = -1 AND [FID_wsws] = -1 AND [CAMA] = "no" AND ([WHAT_KIND] = "NPDES Permitted Phase I MS4" OR [WHAT_KIND] = "NPDES Permitted Phase II MS4") AND [INSIDE] = "Federally Managed Lands" ) THEN PERMIT = "State" AUTH = "DWQ Central Office/" & [JURISDIC] REAS = "State reviews post-construction projects" DESC = "Military, Phase II MS4" INFO = "In " & [JURISDIC]
    /*Phase I/II Tipped County unincorp. areas, coastal co.: already captured by Coastal SW Prog only*/
    /*Phase I/II Tipped County unincorp. areas (as well as in RDU's 'ETJ', spec. case), non-coastal co.*/
    ELSEIF ( [FID_urbani] = -1 AND [FID_phase2] = -1 AND [FID_hqworw] = -1 AND [FID_nsw_st] = -1 AND [FID_wsws] = -1 AND [CAMA] = "no" AND [TIP_STATUS] = "Phase II Tipped" AND ([INSIDE] = "Unincorporated area, County" OR [JURISDIC] = "RDU") AND NOT([WHAT_KIND] = "NPDES Permitted Ph II MS4/Co") ) THEN PERMIT = "State" AUTH = "DWQ Central Office" REAS = "Unincorp. area of Phase II Tipped Co." DESC = "Phase II tipped county" INFO = "Inside " & [JURISDIC]
    /*Non-Phase I/II cities, ETJs, and military areas in Tipped Counties, non-coastal co.*/
    ELSEIF ( [FID_urbani] = -1 AND [FID_phase2] = -1 AND [FID_hqworw] = -1 AND [FID_nsw_st] = -1 AND [FID_wsws] = -1 AND [CAMA] = "no" AND [TIP_STATUS] = "Phase II Tipped" AND NOT([WHAT_KIND] = "Designated Phase II city") AND NOT([WHAT_KIND] = "ETJ of exempt Phase II city") AND NOT([WHAT_KIND] = "NPDES Permitted Phase I MS4") AND NOT([WHAT_KIND] = "NPDES Permitted Phase II MS4") AND NOT([WHAT_KIND] = "Phase II city (Exempt)") AND NOT([WHAT_KIND] = "Phase II city ETJ") AND NOT([WHAT_KIND] = "Phase II city, exempt ETJ") AND NOT([WHAT_KIND] = "NPDES Permitted Ph II MS4/Co") ) THEN PERMIT = "State" AUTH = "DWQ Central Office" REAS = "Phase II Tipped County" DESC = "Entity in Phase II tipped county" INFO = "Inside " & [JURISDIC]
    /*Non-Phase I/II cities, ETJs, military areas, and counties in coastal co.*/
    ELSEIF ( [FID_urbani] = -1 AND [FID_phase2] = -1 AND [FID_hqworw] = -1 AND [FID_nsw_st] = -1 AND [FID_wsws] = -1 AND NOT([CAMA] = "no") AND NOT([WHAT_KIND] = "Designated Phase II city") AND NOT([WHAT_KIND] = "ETJ of exempt Phase II city") AND NOT([WHAT_KIND] = "NPDES Permitted Phase I MS4") AND NOT([WHAT_KIND] = "NPDES Permitted Phase II MS4") AND NOT([WHAT_KIND] = "Phase II city (Exempt)") AND NOT([WHAT_KIND] = "Phase II city ETJ") AND NOT([WHAT_KIND] = "Phase II city, exempt ETJ") AND NOT([WHAT_KIND] = "NPDES Permitted Ph II MS4/Co") ) THEN PERMIT = "State" AUTH = "DWQ Regional Office" REAS = "Coastal State SW Permitting Program" DESC = "Entity in coastal county" INFO = "Inside " & [JURISDIC]
    /*Phase I/II-Exempt cities/ETJs, coastal co.*/
    ELSEIF ( [FID_hqworw] = -1 AND [FID_nsw_st] = -1 AND [FID_wsws] = -1 AND NOT([CAMA] = "no") AND ([WHAT_KIND] = "ETJ of exempt Phase II city" OR [WHAT_KIND] = "Phase II city (Exempt)" OR [WHAT_KIND] = "Phase II city, exempt ETJ") ) THEN PERMIT = "State" AUTH = "DWQ Regional Office" REAS = "Coastal State SW Permitting Program" DESC = "Phase II city or ETJ, coastal co." INFO = "Inside " & [JURISDIC]
    /*Phase I/II-Exempt cities/ETJs, non-coastal co.*/
    ELSEIF ( [FID_hqworw] = -1 AND [FID_nsw_st] = -1 AND [FID_wsws] = -1 AND [CAMA] = "no" AND ([WHAT_KIND] = "ETJ of exempt Phase II city" OR [WHAT_KIND] = "Phase II city (Exempt)" OR [WHAT_KIND] = "Phase II city, exempt ETJ") ) THEN PERMIT = "State" AUTH = "DWQ Central Office" REAS = "Phase II City or ETJ" DESC = "Phase II city or ETJ" INFO = "Inside " & [JURISDIC]
    /*Phase I/II MSIs and UAs, outside Phase II Jurisdictions, non-coastal co.*/
    ELSEIF ( (NOT([FID_urbani] = -1) OR NOT([FID_phase2] = -1)) AND [FID_hqworw] = -1 AND [FID_nsw_st] = -1 AND [FID_wsws] = -1 AND [CAMA] = "no" AND NOT([WHAT_KIND] = "Designated Phase II city") AND NOT([WHAT_KIND] = "ETJ of exempt Phase II city") AND NOT([WHAT_KIND] = "NPDES Permitted Phase I MS4") AND NOT([WHAT_KIND] = "NPDES Permitted Phase II MS4") AND NOT([WHAT_KIND] = "Phase II city (Exempt)") AND NOT([WHAT_KIND] = "Phase II city ETJ") AND NOT([WHAT_KIND] = "Phase II city, exempt ETJ") AND NOT([WHAT_KIND] = "NPDES Permitted Ph II MS4/Co") ) THEN PERMIT = "State" AUTH = "DWQ Central Office" REAS = "In Urbanizing Area or Phase II MSI" DESC = "Phase II MSI or UA" INFO = "Inside " & [JURISDIC]
    /*Phase I/II MSIs and UAs, coastal co.: already captured by Coastal SW Prog only*/
    /*Designated Phase I/II cities (non-military), in TIPPED non-coastal co.*/
    /*FOR DESIGNATED PH II CITIES IN TIPPED COUNTIES, INFO SHOULD SPECIFY DWQ WILL PERMIT IF LOCAL PROGRAM HAS NOT YET BEGUN (SIMILAR TO COASTAL COUNTY CASE). NOTE - CATCH FEW ETJs ASSOCIATED WITH THAT GROUP THAT MAY NOT HAVE MS4 PERMIT YET.*/
    ELSEIF ( [FID_hqworw] = -1 AND [FID_nsw_st] = -1 AND [FID_wsws] = -1 AND [CAMA] = "no" AND [TIP_STATUS] = "Tipped" AND ([WHAT_KIND] = "Designated Phase II city" OR ([WHAT_KIND] = "Phase II city ETJ" AND ([JURISDIC] = "Clayton" OR [JURISDIC] = "Wendell" OR [JURISDIC] = "Zebulon"))) AND NOT([INSIDE] = "Federally Managed Lands") ) THEN AUTH = [JURISDIC] REAS = "In Permitted Phase II Jurisdiction" DESC = "Designated Phase II city, tipped co" INFO = "If not local, DWQ must permit"
    /*Phase I/II cities and counties (non-military), non-coastal co.*/
    ELSEIF ( [FID_hqworw] = -1 AND [FID_nsw_st] = -1 AND [FID_wsws] = -1 AND [CAMA] = "no" AND ([WHAT_KIND] = "Designated Phase II city" OR [WHAT_KIND] = "NPDES Permitted Phase I MS4" OR [WHAT_KIND] = "NPDES Permitted Phase II MS4" OR [WHAT_KIND] = "Phase II city ETJ" OR [WHAT_KIND] = "NPDES Permitted Ph II MS4/Co") AND NOT([INSIDE] = "Federally Managed Lands") ) THEN PERMIT = "Local" AUTH = [JURISDIC] REAS = "In Permitted Phase II Jurisdiction" DESC = "Phase II Entity" INFO = "Inside " & [JURISDIC]
    /*Phase I/II cities and counties (non-military), coastal co.*/
    ELSEIF ( [FID_hqworw] = -1 AND [FID_nsw_st] = -1 AND [FID_wsws] = -1 AND NOT([CAMA] = "no") AND ([WHAT_KIND] = "Designated Phase II city" OR [WHAT_KIND] = "NPDES Permitted Phase I MS4" OR [WHAT_KIND] = "NPDES Permitted Phase II MS4" OR [WHAT_KIND] = "Phase II city ETJ" OR [WHAT_KIND] = "NPDES Permitted Ph II MS4/Co") AND NOT([INSIDE] = "Federally Managed Lands") ) THEN PERMIT = "Local" AUTH = [JURISDIC] REAS = "In Permitted Phase II Jurisdiction" DESC = "Phase II entity, coastal co." INFO = "If not local, DWQ must permit"
    /*Set remaining cases to "Not done yet" as a check*/
    ELSE PERMIT = "Not done yet" END IF
    -*-*-*-*-*-*-*-*-*-* [PERMITTING] = PERMIT [TYPE] = DESC [BASIS] = REAS [NOTE] = INFO [CONTACT] = AUTH [DENR_RGN] = [DWQ_REGION]
    NOTES:
     Some CONTACT field records that include military base names need to be shortened to avoid truncated text in the info.
     Some records for ORW watersheds on the coast that are also in Phase II cities (e.g., Wilmington) need revision to send user to local authority
    
    who will permit through Post-construction prog.
    Populate [PH2_INFO] field with appropriate info., depending on permitting, etc. (NOTE: Some of these will be revised for delegated authorities): IF [DESCRIPT_3] = " " THEN PH2 = "Not a Phase II area" ELSEIF NOT([DESCRIPT_3] = " ") AND [PERMITTING] = "Local" THEN PH2 = "Local program satisfies Phase II rqmts" ELSEIF NOT([DESCRIPT_3] = " ") AND NOT([CAMA] = "no") AND [PERMITTING] = "State" THEN PH2 = "Coastal/State SW Prog satisfies Ph II" ELSEIF NOT([DESCRIPT_3] = " ") AND NOT([CAMA] = "no") AND [PERMITTING] = "Multiple" THEN PH2 = "Coastal/Local SW Progs satisfy Ph II" ELSEIF NOT([DESCRIPT_3] = " ") AND [CAMA] = "no" AND NOT([FID_hqworw] = -1) THEN PH2 = "State SW Program satisfies Phase II" ELSE PH2 = "Subject to Phase II Post-Construction" END IF [PH2_INFO] = PH2
    Integrate Special Watershed Info.(SA waters, Goose creek, etc.): Select records: WHERE(NOT("DESCRIPT_1" = ' ')) and set NOTE to: [NOTE] = [NOTE] & "/" & [DESCRIPT_1],
    and WHERE("DESCRIPT_2" = '1/2-mile buffer around SA Waters') and set NOTE to: [NOTE] = "Near SA waters/" & [NOTE]
    Editing:
     Some [NOTE] field records need to be shortened to avoid truncated text in the info.  This includes changing WS contact URL to just 'WS Prog' before making edits so that watershed name fits.
     Reconcile any records where SA buffers extend into non-CAMA county (e.g., Jones Co.) and revise fields appropriately.
     Select and note USMP cities in [NOTE] field; verify with Regional Office who permits in coastal areas.
     Screen areas within federally managed lands to ensure some indication to contact military where needed.  Modified TYPE, NOTE, and/or CONTACT where appropriate.
    
    /*New Jordan Lake Watershed SW Rules*/
    Jordan Watershed areas that direct to State b/c of Phase II may need to be changed to redirect to Local Program after PERMITTING field calculated, but this may not be appropriate until future updates ~ 2012 to time with local ordinances. Right now, just identify watershed in Step 7. and direct user to URL: www.jordanlake.org (map). A similar scenario may hold for Falls Lake Watershed.
    Select records: WHERE("DESCRIPT_1" = "Jordan Reservoir Watershed" AND ("PERMITTING" = "None" OR "TYPE" = "Water Supply Watershed")) and set the [NOTE] field to: [NOTE] = "Jordan Rules apply - www.jordanlake.org"
    Select records: WHERE("DESCRIPT_1" = "Jordan Reservoir Watershed" AND "PERMITTING" = "None") and set these fields to: [PERMITTING] = "Local" [BASIS] = "Jordan Reservior Watershed" [CONTACT] = [JURISDIC] (Should already be set to this - just double-check) [TYPE] = (Just remove "None, " from beginning of text in this field)
    Finally, Select records: WHERE ("DESCRIPT_1" = 'Jordan Reservoir Watershed' AND NOT("NOTE"= 'Jordan Rules apply - www.jordanlake.org')) and set [CONTACT] field to: [CONTACT] = [CONTACT] & ", check www.jordanlake.org"
    /*Pending Falls Lake Watershed SW Rules*/
    Select records: WHERE([DESCRIPT_1] = "Falls Lake Watershed") and incorporate this text into the [NOTE] field: "Falls Lake Rules Pending"
    Modify some fields for Designated Phase II cities. Add designation status info, and note that DWQ will permit projects in Phase II areas (tipped, UA, MSI, etc.) until local program begins. (Where non-Phase II, non-coastal, Post-Construction begins when local government impelments its program.)
    Select records (omits areas where a local prog like Water Supply already in place): WHERE("WHAT_KIND" = "Designated Phase II city" AND "BASIS" = "In Permitted Phase II Jurisdiction") and set these fields to: [BASIS] = "In Designated Phase II City"
    Select records: WHERE("WHAT_KIND" = 'Designated Phase II city' AND ( "TIP_STATUS"= 'Phase II Tipped' OR "TYPE_P" = 'Urbanized area' OR "DESCRIPT" = '"Municipal Sphere of Influence" around Phase II cities') AND "BASIS" = 'In Designated Phase II City') and set these fields to: [NOTE] = [NOTE] & " , if not local DWQ must permit" (might need to change 'Inside...' to 'In...') [CONTACT] = [CONTACT] & " and DWQ Central Office" [PH2_INFO] = "Local prog eventually to satisfy Ph II"
    Also select records for Designated Cities where local WS or NSW programs (for example) are not currently satisfying the Phase II requirement and set this field to: [PH2_INFO] = "Local prog eventually to satisfy Ph II"
    Also select records for Designated Cities on the coast where the [CONTACT] should include the Regional Office until the local post-consruction program begins and set this field to: [CONTACT] = [CONTACT] & " and DWQ Regional Office"
    Make ETJs of these cities consistent. In 2010, only affects Clayton, Zebulon, and Wendell.
    Select records: WHERE("WHAT_KIND" = 'Phase II city ETJ' AND "JURISDIC" IN ('Clayton','Zebulon','Wendell' AND NOT("TYPE" = 'Water Supply Watershed')) and set these fields to: [BASIS] = "In Designated Phase II City" [PH2_INFO] = "Local prog eventually to satisfy Ph II"
    Screen areas that are ocean or sound and note: Select records: WHERE "CO_CLASS" = 'OceanOrSound') and set NOTE to: [NOTE] = "Ocean or sound area, verify location"
    Go back and populate the DENR_RGN for those records because they were left blank in source file wherever CAMA = 'n/a'.
    Identify special cases where local governments have been delegated authority. Several fields need to be changed for specific records. Includes areas in: GASTON, GUILFORD, MECKLENBURG, DURHAM, BUNCOMBE, CHATHAM, AND WAKE counties. Also address implmentation issue in CALDWELL COUNTY (DWQ/Lenoir current contacts). Note - delegations do NOT necessarily extend into areas that are HQW/ORW (and remain state-permitting) or change local Water Supply program contacts.
    Revise contact fields for ORW areas on coast where user should go to local Phase II jurisdiction (like in Wilminton), instead of regional office.
    Populate [CATEGORY] field with appropriate info., depending on [TYPE] field: IF [TYPE] = "None, ETJ Boundaries" OR [TYPE] = "None, Federally Managed Lands" OR [TYPE] = "None, Municipality Boundaries" OR [TYPE] = "None, Unincorporated area, County" THEN CATEG = "No Stormwater Program" ELSEIF [TYPE] = "HQW/ORW Area AND Water Supply" OR [TYPE] = "NSW community AND HQW/ORW" OR [TYPE] = "NSW community AND Water Supply" OR [TYPE] = "NSW community AND coastal co." OR [TYPE] = "Water Supply AND coastal co." OR [TYPE] = "HQW/ORW, Water Supply, AND NSW" THEN CATEG = "Overlapping Programs" ELSEIF [PERMITTING] = "Local" THEN CATEG = "Local Program" ELSEIF [BASIS] = "SA Waters, Coastal State SW Programm" OR [BASIS] = "SA Waters, Coastal State SW Program" OR [BASIS] = "SA is HQW by definition/State SW Prog" OR [BASIS] = "ORW/SA Watershed" OR [BASIS] = "ORW/SA Watershed, State SW Prog" THEN CATEG = "SA Waters" ELSEIF [TYPE] = "Coastal county or community" OR [TYPE] = "Coastal county, military area" OR [TYPE] = "Coastal county, Coast Guard" THEN CATEG = "Coastal State SW Program" ELSEIF [TYPE] = "High Quality or Outstanding Waters" THEN CATEG = "State Stormwater Program" ELSEIF [TYPE] = "Entity in Phase II tipped county" OR [TYPE] = "Military, Phase II MS4 (coastal)" OR [TYPE] = "Military, Phase II MS4" OR [TYPE] = "Phase II Entity" OR [TYPE] = "Phase II MSI or UA" OR [TYPE] = "Phase II city or ETJ" OR [TYPE] = "Phase II city or ETJ, coastal co." OR [TYPE] = "Phase II entity, coastal co." OR [Type] = "Phase II tipped county" THEN CATEG = "Phase II Area" ELSE CATEG = "Not done yet" END IF [CATEGORY] = CATEG
    Export all records into 'stormwater_reference20090626.shp' and dissolve on following fields: COUNTY (15) JURISDIC (150) PERMITTING (10), TYPE (35), BASIS (40), NOTE (40), CONTACT (45), DENR_RGN (30), CATEGORY (50), and PH2_INFO (40)
    Dissolved to 1,979 polygons
    Final editing steps for 2010 update to drop and re-add fields so [JURISDIC] is 40 characters in length instead of 150. Also corrected CONTACT and JURISDIC fields where erroneous 'slivers' of Durham and Raleigh ETJ boundaries overlapped in Wake and Durham counties.

    Person who carried out this activity:

    Bethany Georgoulias
    NC DENR/DWQ
    Environmental Engineer
    1617 Mail Service Center
    Raleigh, NC 27699-1617
    USA

    919-807-6372 (voice)
    919-807-6494 (FAX)
    bethany.georgoulias@ncdenr.gov

    Hours_of_Service: 9:00 to 5:00
    Contact_Instructions: email or phone preferred
    Date: 15-Jul-2010 (process 3 of 4)
    Polygons were dissolved to combine polygons of the same type, program, and contact (1,979 records).

    Person who carried out this activity:

    Bethany Georgoulias
    NC DENR/DWQ
    Environmental Engineer
    1617 Mail Service Center
    Raleigh, NC 27699-1617
    USA

    919-807-6372 (voice)
    919-807-6494 (FAX)
    bethany.georgoulias@ncdenr.gov

    Hours_of_Service: 9:00-5:00
    Contact_Instructions: email or phone preferred
    Date: 22-Jul-2010 (process 4 of 4)
    Reference layer was reviewed for quality control

    Person who carried out this activity:

    Jeffrey Brown
    NC CGIA
    Project Manager
    20322 Mail Service Center
    Raleigh, NC 27699-0322
    USA

    919-754-6580 (voice)
    919-715-8551 (FAX)
    dataq@nc.gov

  3. What similar or related data should the user be aware of?

    NC Department of Transportation GIS Unit, 2010, County boundaries in North Carolina.


How reliable are the data; what problems remain in the data set?

  1. How well have the observations been checked?

    The attributes for the base geospatial layers used in the model have beeen checked for accuracy in terms of watershed identifiers, county names, municipal names, municipal population, urbanized area names, and Phase II status of jurisdictions.

  2. How accurate are the geographic locations?

    Base layers used in the model were mapped at a scale of 1:24,000 or better to be consistent with National Map Accuracy Standards. The digital files were plotted and overlayed to the originals and needed line corrections were made to within one line width.

  3. How accurate are the heights or depths?

    There is no vertical dimension to this data layer.

  4. Where are the gaps in the data? What is missing?

    This data layer represents stormwater jurisdiction within North Caroilna based on the best available geospatial data relating to Stormwater Phase II municipal boundaries, planning jurisdictions, municipal spheres of influence represented by urbanized areas (Census 2000) and buffers of municipal boundaries based on US EPA criteria, and other local and state stormwater programs related to nutrient sensitive waters, water supply watersheds, high quality water and outstanding resource water watersheds, the NC Coastal Area Management Act, and other watersheds where special stormwater requirements apply. The only base geospatial layer that is incomplete is the planning jurisdiction (extra territorial jurisdiction or ETJ) layer that lacks digital representations for municipalities in New Hanover and Henderson Counties (not available in digital format).

  5. How consistent are the relationships among the observations, including topology?

    Original processing: using ESRI's ARC/INFO GIS software, the dataset was developed using Model Builder and the Spatial Analyst extension. The model processed statewide datasets or subsets of statewide datasets to represent stormwater jurisdiction within the boundaries of North Carolina.


How can someone get a copy of the data set?

Are there legal restrictions on access or use of the data?

Access_Constraints: None.
Use_Constraints:
It is important to remember that a local government may choose to pass ordinances that are above and beyond what existing stormwater programs or Phase II requires. A local government may choose to pass ordiinances in areas outside of Phase II areas. Also, city limits and extraterritorial jurisdictions (ETJ) may have changed since this dataset was created. Also, water supply watersheds or other water quality delineations may have changed between updates of this dataset. Therefore, users of this dataset should check for specific local government requirements to verify the information represented in this dataset. Acknowledgement of products derived form this data set should cite the following: The sources of the stormwater reference data are mapped at a scale of 1:24,000 or better, implying horizontal error plus or minus 40 feet. This representation is intended as a guide to persons seeking stormwater permits and to permitting authorities. While efforts have been made to ensure that these data are accurate and reliable within the state of the art, CGIA cannot assume liability for any damages or misrepresentation caused by any inaccuracies in the data or as a result of changes to the data caused by system transfers.

  1. Who distributes the data set? (Distributor 1 of 1)

    NC CGIA
    20322 Mail Service Center
    Raleigh, NC 27699-0322
    USA

    919-965-6584 (voice)
    919-715-8551 (FAX)
    jeff.brown@its.nc.gov

    Hours_of_Service: 9:00 to 5:00
    Contact_Instructions: Phone and email preferred.
  2. What's the catalog number I need to order this data set?

    Stormwater permitting reference for North Carolina with selected stormwater program characteristics.

  3. What legal disclaimers am I supposed to read?

    NCCGIA is charged with the development and maintenance of NC OneMap and, in cooperation with other mapping organizations, is committed to offering its users accurate, useful, and current information. Although every effort has been made to ensure the accuracy of information, errors and conditions originating from physical sources used to develop this dataset may be reflected in the data supplied. The user must be aware of possible conditions and bear responsibility for the appropriate use of the information with respect to possible errors, original map scale, collection methodology, currency of data, and other conditions specific to certain data. NCCGIA does not support secondary distribution of this dataset without its current, compliant metadata record. The use of trade names or commercial products does not constitute their endorsement by NCCGIA or North Carolina State Government.

  4. How can I download or order the data?

  5. Is there some other way to get the data?

    Data can be customized on a cost-recovery basis. Contact dataq@ncmail.net or 919-733-2090 for more information.

  6. What hardware or software do I need in order to use the data set?

    All formats available from www.nconemap.com are in ESRI shapefile. Other formats are available on a cost-recovery basis - contact dataq@ncmail.net or 919.733.2090 for more information. Format compatibility is the user's responsibility.


Who wrote the metadata?

Dates:
Last modified: 27-Jul-2010
Last Reviewed: 16-Jul-2010
Metadata author:
CGIA
c/o Jeffrey P. Brown
Project Manager
20322 Mail Service Center
Raleigh, NC 27699-0322
USA

919-754-6580 (voice)
919-715-8551 (FAX)
jeff.brown@nc.gov

Hours_of_Service: 8:00 AM to 5:00 PM
Metadata standard:
FGDC Content Standards for Digital Geospatial Metadata (FGDC-STD-001-1998)
Metadata extensions used:


Generated by mp version 2.9.5 on Mon Aug 16 12:48:34 2010