Identification_Information: Citation: Citation_Information: Originator: Silvia Terziotti Publication_Date: 2009 Title: condgw Edition: Version 1.0, June 30, 2009 Geospatial_Data_Presentation_Form: raster digital data Publication_Information: Publication_Place: Raleigh, NC Publisher: U.S. Geological Survey Online_Linkage: \\Igsavbewfs001\Work\SWAP_updates\FinalLayers\GW\condgw Description: Abstract: Vertical series hydraulic conductance classes is one of 6 data sets updated for the North Carolina Public Water Supply, Source Water Assessment Program. These data are used to rate the susceptibility of public water supplies in North Carolina to contamination. The original dataset was produced in 2000. This version is updated to reflect new data sources. This data set represents the ratings applied to conductance classes for use in the rating of the unsaturated zone for public ground-water suppliers. The harmonic mean hydraulic conductance of a series of layers of unsaturated material provides a single value for the capacity of the entire sequence of the unsaturated zone to transmit water (with or without contaminants) from the land surface to the water table. For ground-water systems, the higher the conductance of the unsaturated zone, the higher the rating applied on a scale of 1 to 10. Purpose: This data set is to be used in a hydrologic analysis with other data sets to rate the unsaturated zone for public ground-water supplies and watershed characteristics for public surface-water supplies in North Carolina. For ground-water supplies, the factors used to rate susceptibility to contamination include vertical hydraulic conductance, land-surface slope, land cover, and land use. The selected factors used to devise ratings for surface-water supplies' susceptibility to contamination are average annual precipitation, land-surface slope, land cover, land use, and ground-water contribution. Supplemental_Information: The 1996 Amendments to the Safe Drinking Water Act require that each state prepare a source-water assessment for all public water supplies. States are required to (1) delineate source areas supplying wells and surface-water intakes, (2) inventory potential contaminant sources within the delineated source areas, and (3) determine the susceptibility of wells or intakes to the inventoried potential contaminant sources. In North Carolina, the lead agency charged with this task is the Public Water Supply Section (PWSS) of the Division of Environmental Health, Department of Environment and Natural Resources (DENR). North Carolina's Source Water Assessment Program (SWAP) provides assessments of each public drinking water intake in North Carolina. These assessments provide a relative susceptibility rating calculated using state-wide data. The U.S. Geological Survey (USGS) cooperated with the PWSS to provide components of the inherent vulnerability rating that was used with the contaminant rating to determine the overall susceptibility rating of source water supplies. To assist the PWSS with rating ground water inherent vulnerability, the USGS compiled the unsaturated zone rating based on the following characteristics: vertical hydraulic conductance, depth to water, land surface slope, land use and land cover. The watershed characteristic rating includes average annual precipitation, land surface slope, land use, land cover and groundwater contribution. The SWAP program has planned for updates to the initial ratings as conditions change and new data sources become available. The initial data used to calculate the unsaturated zone ratings and watershed characteristics ratings were compiled from sources from the late 1990's. Critical data layers have been updated since the ratings were calculated. These improved data layers need to be used in the ongoing update of the susceptibility ratings. Overlay and index methods for rating susceptibility to contamination of the unsaturated zone for ground-water suppplies, and watershed characteristics for surface-water supplies were derived for use by the State of North Carolina in assessing more than 11,000 public water-supply wells and approximately 245 public surface-water intakes. Factors that influence the inherent vulnerability of ground water and surface water were selected and assigned ratings on a scale of 1 to 10. These factors were then assigned weight to reflect their relative influence on inherent vulnerability and the reliability of the data. The values for each factor were obtained from geographic information system (GIS) data layers that were transformed into ARC/INFO raster data sets known as grids. These raster data sets have 30-meter by 30-meter cells, and each cell is assigned a weighted- factor value. Limitations -- The overlay and index methods of unsaturated zone and watershed characteristics ratings are broad-stroke methods that assess vulnerability on the basis of expert opinion. The methods aslo have limitations in the age and scale of the hydrologic and geographic data. But the most significant limitation of the methods used is that no statistical confirmation of the results have been performed. VERTICAL SERIES HYDRAULIC CONDUCTANCE: The vertical series hydraulic conductance (also referred to as conductance) layer is calculated for the entire thickness of the unsaturated zone. The entire thickness of the unsaturated zone includes a soil layer, and may include a saprolite and crystalline bedrock layer depending on the depth to water at any point. To calculate the conductance value, thickness of soils, depth to bedrock and soil conductance are necessary. The conductance of the saprolite and bedrock layers are also needed. County-level soil information from the Natural Resources Conservation Service (NRCS) Soil Survey Geographic Database (SSURGO) database for North Carolina was used where available. The SSURGO data provides an estimate for conductance of the soil layer, thickness of the soil layer, and depth to the bedrock of a soil layer. This was combined with the depth to water layer, and the conductance values for saprolite and bedrock that were created for the 2000 compilation of conductance. Detailed soils were available for 73 counties in the 2000 release of the data. For the update of the conductance layer, twenty additional detailed soil surveys were available to refine the conductance of the soil layer statewide. SSURGO data for Anson, Avery, Buncombe, Burke, Catawba, Chatham, Clay, Cleveland, Graham, Henderson, Lee, Lincoln, Madison, Montgomery, Stokes, Surry, Transylvania, Vance, Watauga, Yadkin and part of Haywood County were included in this update. The counties of Caswell, Cherokee, Iredell, Rowan, Rutherford, Swain, and Warren were not available at the time of processing. The less detailed State Soil Geographic (STATSGO) database was used in these counties. In 2004, NRCS implemented a new database and access system to the SSURGO spatial and tabular data. Because of this, methods developed in 2000 for the original compilation of unsaturated zone data were modified. The fields from the SSURGO soils database used in 2000 were no longer available. Permeability of soil fields, PERML and PERMH, have been replaced by Ksat in the SSURGO database. The SSURGO Metadata table column descriptions define Ksat as “the amount of water that would move vertically through a unit area of saturated soil in unit time under unit hydraulic gradient.” (http://soils.usda.gov/survey/geography/ssurgo/). Verbal communication with Soil Scientists at NRCS confirmed that the Ksat variable should be used as a substitute for perml and permh (cite, date). The NRCS also distributes software to calculate one Ksat value per soil type, as a weighted average over the soil layers. This value for each soil is multiplied by .1417 to convert it to an inch per hour ratio, comparable to the values used in 2000. Soil thickness and depth to bedrock were also updated from the SSURGO data for the 21 counties that were updated. New conductance values were calculated separately for the new county data, and merged with the 2000 layer. One additional change was made from the 2000 compilation. The categories were rescaled to better represent the conductance through a smaller area represented by a 30 by 30 foot cell size. The new categories and ratings for Vertical series hydraulic conductance are: >Table 1 -- Vertical series hydraulic conductance categories and rating values for unsaturated zone rating > Vertical series hydraulic Percent of area Rating > conductance categories in North Carolina > (feet-squared per day) > <= 50 33 1 > > 50 to <= 100 14 2 > >100 to <= 200 9 3 > >200 to <= 400 11 4 > >400 to <=800 8 5 > >800 to <= 1,600 3 6 > >1,600 to <= 3,200 3 7 > >3,200 to <= 6,400 5 8 > >6,400 to <= 12,800 2 9 > >12,800 12 10 SELECTED REFERENCES: Eimers, J. L., Weaver, J. C., Terziotti, S., and Midgette, R. W., 2000, Methods of rating unsaturated zone and watershed characteristics of public water supplies in North Carolina: U. S. Geological Survey Water-Resources Investigations Report 99-4283, 31 p. North Carolina Department of Environment and Natural Resources, 1999, North Carolina source water assessment program plan: Raleigh, North Carolina Department of Environment and Natural Resources, Division of Environmental Health, Public Water Supply Section, [variously paged]. O'Hara, C. G., 1994, Permeability of soils in Mississippi: U.S. Geological Survey Water-Resources Investigations Report 94-4088, 1 sheet. O'Hara, C.G., 1996, Susceptibility of ground water to surface and shallow sources of contamination in Mississippi: U.S. Geological Survey Hydrologic Investigations Atlas HA-739, 4 sheets. More information on STATSGO, SSURGO, and the MUIR database can be found at the USDA-NRCS, National Soils Survey Center, National Soil Data Access Facility website, http://soils.usda.gov/ STATSGO data can be accessed from: http://soils.usda.gov/survey/geography/statsgo/ Information on the SSURGO data available through NC Center for Geographic Information and Analysis can be viewed at: http://cgia.cgia.state.nc.us/corpmeta.dir/corplayer.html NRCS has all certified SSURGO data online at: http://soildatamart.nrcs.usda.gov/Default.aspx NRCS distributes a Soil Data Viewer for ArcGIS applications, used to display and aggregate soil properties by soil unit. http://soildataviewer.nrcs.usda.gov/download50.aspx Any use of trade, product, or firm names is for descriptive purposes only and does not imply endorsement by the U.S. Government. Although this Federal Geographic Data Committee-compliant metadata file is intended to document the data set in nonproprietary form, as well as in ARC/INFO format, this metadata file may include some ARC/INFO-specific terminology. Time_Period_of_Content: Time_Period_Information: Single_Date/Time: Calendar_Date: 1990 Currentness_Reference: ground condition Status: Progress: In work Maintenance_and_Update_Frequency: As needed Spatial_Domain: Bounding_Coordinates: West_Bounding_Coordinate: -84.901283 East_Bounding_Coordinate: -74.884006 North_Bounding_Coordinate: 36.982818 South_Bounding_Coordinate: 33.256483 Keywords: Theme: Theme_Keyword_Thesaurus: none Theme_Keyword: Vertical Series Hydraulic Conductance Theme_Keyword: Soils Theme_Keyword: Permeability Theme_Keyword: Vulnerability Place: Place_Keyword_Thesaurus: none Place_Keyword: North Carolina Access_Constraints: none Use_Constraints: Not to be used for site-specific analysis Point_of_Contact: Contact_Information: Contact_Person_Primary: Contact_Person: Silvia Terziotti Contact_Organization: U.S. Geological Survey Contact_Position: Computer Specialist Contact_Address: Address_Type: mailing address Address: 3916 Sunset Ridge Road City: Raleigh State_or_Province: NC Postal_Code: 27607 Country: USA Contact_Voice_Telephone: (919) 571-4000 Contact_Facsimile_Telephone: (919) 571-4041 Contact_Electronic_Mail_Address: (seterzio@usgs.gov) Data_Set_Credit: The authors are grateful to colleagues in the Public Water Supply Section of the Division of Environmental Health, North Carolina Department of Environment and Natural Resources (DENR) for their assistance in this collaborative project: thanks to Robert Midgette, Protection and Enforcement Branch Head; Amy Axon,hydrogeologist - Source Water Protection; and David Hammermann, Geographic Information Systems Specialist. The authors also thank the USGS report review team for their review of the update procedures: Jeanne Robbins, Surface-water Specialist; Melinda Chapman, Ground-water Specialist; Mary Giorgino, Water-quality Specialist; and Douglas Harned, ALBE-National Water Quality Assessment Project Chief Native_Data_Set_Environment: Microsoft Windows 2000 Version 5.2 (Build 3790) Service Pack 2; ESRI ArcCatalog 9.2.6.1500 Cross_Reference: Citation_Information: Originator: Silvia Terziotti and Jo Leslie Eimers Publication_Date: 2001 Title: Watershed Characteristics Rating for North Carolina Geospatial_Data_Presentation_Form: map Series_Information: Series_Name: USGS Open-File Report Issue_Identification: USGS OFR 01-490 Publication_Information: Publication_Place: Raleigh, NC Publisher: USGS Online_Linkage: http://nc.water.usgs.gov/reports/ofr01490/index.html Cross_Reference: Citation_Information: Originator: Silvia Terziotti and Jo Leslie Eimers Publication_Date: 2001 Title: Unsaturated Zone Characteristics Rating for North Carolina Geospatial_Data_Presentation_Form: map Series_Information: Series_Name: USGS Open-File Report Issue_Identification: USGS OFR 01-489 Publication_Information: Publication_Place: Raleigh, NC Publisher: USGS Online_Linkage: http://nc.water.usgs.gov/reports/ofr01489/index.html Cross_Reference: Citation_Information: Originator: Silvia Terziotti and Jo Leslie Eimers Publication_Date: 2001 Title: Land-Use Classes to Characterize Watersheds and the Unsaturated Zone in North Carolina Geospatial_Data_Presentation_Form: map Series_Information: Series_Name: USGS Open-File Report Issue_Identification: USGS OFR 01-493 Publication_Information: Publication_Place: Raleigh, NC Publisher: USGS Online_Linkage: http://nc.water.usgs.gov/reports/ofr01493/index.html Cross_Reference: Citation_Information: Originator: Silvia Terziotti and Jo Leslie Eimers Publication_Date: 2001 Title: Land-Cover Classes to Characterize the Unsaturated Zone in North Carolina Geospatial_Data_Presentation_Form: map Series_Information: Series_Name: USGS Open-File Report Issue_Identification: USGS OFR 01-491 Publication_Information: Publication_Place: Raleigh, NC Publisher: USGS Online_Linkage: http://nc.water.usgs.gov/reports/ofr01491/index.html Cross_Reference: Citation_Information: Originator: Silvia Terziotti and Jo Leslie Eimers Publication_Date: 2001 Title: Percent-Slope Classes to Characterize the Unsaturated Zone in North Carolina Geospatial_Data_Presentation_Form: map Series_Information: Series_Name: USGS Open-File Report Issue_Identification: USGS OFR 01-495 Publication_Information: Publication_Place: Raleigh, NC Publisher: USGS Online_Linkage: http://nc.water.usgs.gov/reports/ofr01495/index.html Cross_Reference: Citation_Information: Originator: Jo Leslie Eimers, Silvia Terziotti and Gloria Ferrell Publication_Date: 2001 Title: Vertical Series Hydraulic Conductance Classes to Characterize the Unsaturated Zone in North Carolina Geospatial_Data_Presentation_Form: map Series_Information: Series_Name: USGS Open-File Report Issue_Identification: USGS OFR 01-486 Publication_Information: Publication_Place: Raleigh, NC Publisher: USGS Online_Linkage: http://nc.water.usgs.gov/reports/ofr01486/index.html Cross_Reference: Citation_Information: Originator: Jo Leslie Eimers, Silvia Terziotti and Mary Giorgino Publication_Date: 2001 Title: Estimated Depth to Water, North Carolina Geospatial_Data_Presentation_Form: map Series_Information: Series_Name: USGS Open-File Report Issue_Identification: USGS OFR 01-487 Publication_Information: Publication_Place: Raleigh, NC Publisher: USGS Online_Linkage: http://nc.water.usgs.gov/reports/ofr01487/index.html Cross_Reference: Citation_Information: Originator: Silvia Terziotti and Jo Leslie Eimers Publication_Date: 2001 Title: Land-Cover Classes to Characterize Watersheds in North Carolina Geospatial_Data_Presentation_Form: map Series_Information: Series_Name: USGS Open-File Report Issue_Identification: USGS OFR 01-492 Publication_Information: Publication_Place: Raleigh, NC Publisher: USGS Online_Linkage: http://nc.water.usgs.gov/reports/ofr01492/index.html Cross_Reference: Citation_Information: Originator: Silvia Terziotti and Jo Leslie Eimers Publication_Date: 2001 Title: Average Annual Precipitation Classes to Characterize Watersheds in North Carolina Geospatial_Data_Presentation_Form: map Series_Information: Series_Name: USGS Open-File Report Issue_Identification: USGS OFR 01-494 Publication_Information: Publication_Place: Raleigh, NC Publisher: USGS Online_Linkage: http://nc.water.usgs.gov/reports/ofr01494/index.html Cross_Reference: Citation_Information: Originator: Silvia Terziotti and Jo Leslie Eimers Publication_Date: 2001 Title: Percent-Slope Classes to Characterize Watersheds in North Carolina Geospatial_Data_Presentation_Form: map Series_Information: Series_Name: USGS Open-File Report Issue_Identification: USGS OFR 01-496 Publication_Information: Publication_Place: Raleigh, NC Publisher: USGS Online_Linkage: http://nc.water.usgs.gov/reports/ofr01496/index.html Cross_Reference: Citation_Information: Originator: Silvia Terziotti and Jo Leslie Eimers Publication_Date: 2001 Title: Ground-Water Contribution Classes to Characterize Watersheds in North Carolina Geospatial_Data_Presentation_Form: map Series_Information: Series_Name: USGS Open-File Report Issue_Identification: USGS OFR 01-488 Publication_Information: Publication_Place: Raleigh, NC Publisher: USGS Online_Linkage: http://nc.water.usgs.gov/reports/ofr01488/index.html Data_Quality_Information: Attribute_Accuracy: Attribute_Accuracy_Report: Visually verified against original source Logical_Consistency_Report: Not applicable for raster data. Completeness_Report: Best scale available was used. 1:24,000 was used, and filled in with 1:250,000 scale soils. Positional_Accuracy: Horizontal_Positional_Accuracy: Horizontal_Positional_Accuracy_Report: Based on source data, 1:24,000 or 1:250,000 scale Lineage: Source_Information: Source_Citation: Citation_Information: Originator: NRCS Publication_Date: 1994 Title: State Soil Geographic (STATSGO) data base for North Carolina Geospatial_Data_Presentation_Form: map Publication_Information: Publication_Place: Fort Worth, TX Publisher: U.S. Department of Agriculture, NRCS Source_Scale_Denominator: 250,000 Type_of_Source_Media: stable-base material Source_Time_Period_of_Content: Time_Period_Information: Single_Date/Time: Calendar_Date: unknown Source_Currentness_Reference: Photography date Source_Citation_Abbreviation: None Source_Contribution: permeability and soil thickness Source_Information: Source_Citation: Citation_Information: Originator: NCCGIA Publication_Date: 1998 Title: Detailed County Soils- various counties, North Carolina Geospatial_Data_Presentation_Form: map Publication_Information: Publication_Place: Raleigh, NC Publisher: NCCGIA Source_Scale_Denominator: 24,000 Type_of_Source_Media: stable-base material Source_Time_Period_of_Content: Time_Period_Information: Single_Date/Time: Calendar_Date: 1950's to present Source_Currentness_Reference: Photography date Source_Citation_Abbreviation: None Source_Contribution: permeability and soil thickness Source_Information: Source_Citation: Citation_Information: Originator: NRCS Publication_Date: 2009 Title: Detailed County Soils- various counties, North Carolina Geospatial_Data_Presentation_Form: map Publication_Information: Publication_Place: Raleigh, NC Publisher: NRCS Source_Scale_Denominator: 24,000 Type_of_Source_Media: stable-base material Source_Time_Period_of_Content: Time_Period_Information: Single_Date/Time: Calendar_Date: 1950's to present Source_Currentness_Reference: Photography date Source_Citation_Abbreviation: None Source_Contribution: Ksat, soil thickness and depth to bedrock Source_Information: Source_Citation: Citation_Information: Originator: Amoozegar, A. Originator: Hoover, M. T. Originator: Kleiss, H. J. Originator: Guertal, W. R. Originator: Surbrugg, J. E. Publication_Date: 1993 Title: Evaluation of saprolite for on-site wastewater disposal Series_Information: Series_Name: Water Resources Research Institute Report Issue_Identification: No. 279 Type_of_Source_Media: paper Source_Time_Period_of_Content: Time_Period_Information: Single_Date/Time: Calendar_Date: 1993 Source_Currentness_Reference: publication date Source_Citation_Abbreviation: Amoozegar and others (1993) Source_Contribution: saprolite characteristics Source_Information: Source_Citation: Citation_Information: Originator: Amoozegar, A. Originator: Schoeneberger, P. J. Originator: Vepraskas, M. J. Publication_Date: 1991 Title: Characterization of soils and saprolites from the Piedmont region for waste disposal purposes Series_Information: Series_Name: Water Resources Research Institute Report Issue_Identification: No. 255 Type_of_Source_Media: paper Source_Time_Period_of_Content: Time_Period_Information: Single_Date/Time: Calendar_Date: 1991 Source_Currentness_Reference: publication date Source_Citation_Abbreviation: Amoozegar and others (1991) Source_Contribution: saprolite characteristics Source_Information: Source_Citation: Citation_Information: Originator: Ator, S.W. Originator: Denver, J.M. Originator: Hancock, T.C. Publication_Date: 2000 Title: Relating shallow Ground-water quality to surficial hydrogeology in the mid-Atlantic coastal plain Series_Information: Series_Name: National Water Quality Monitoring Conference, Monitoring for the Millennium Proceedings Issue_Identification: Proceedings, 2000 Type_of_Source_Media: paper Source_Time_Period_of_Content: Time_Period_Information: Single_Date/Time: Calendar_Date: 2000 Source_Currentness_Reference: publication date Source_Citation_Abbreviation: Ator and others (2000) Source_Contribution: p. 409-423 Source_Information: Source_Citation: Citation_Information: Originator: Hazen, Allen Publication_Date: 1911 Title: Discussion Series_Information: Series_Name: Dams on sand foundations. Transactions, American Society of Civil Engineers Issue_Identification: vol. 73 Type_of_Source_Media: paper Source_Time_Period_of_Content: Time_Period_Information: Single_Date/Time: Calendar_Date: 1911 Source_Currentness_Reference: publication date Source_Citation_Abbreviation: Hazen (1911) Source_Contribution: p. 199 Source_Information: Source_Citation: Citation_Information: Originator: Moench, A.F. Publication_Date: 1993 Title: Computation of type curves for flow to partially penetrating wells in water-table aquifers. Series_Information: Series_Name: Ground Water Issue_Identification: 34(4) Type_of_Source_Media: paper Source_Time_Period_of_Content: Time_Period_Information: Single_Date/Time: Calendar_Date: 1993 Source_Currentness_Reference: publication date Source_Citation_Abbreviation: Moench (1993) Source_Contribution: p. 593-96. Source_Information: Source_Citation: Citation_Information: Originator: Neuman, S.P. Publication_Date: 1997 Title: Flow to a well of finite diameter in a homogeneous, anisotropic water table aquifer. Series_Information: Series_Name: Water Resources Research Issue_Identification: 33(6) Type_of_Source_Media: paper Source_Time_Period_of_Content: Time_Period_Information: Single_Date/Time: Calendar_Date: 1997 Source_Currentness_Reference: publication date Source_Citation_Abbreviation: Neuman (1997) Source_Contribution: p. 1397-1407 Source_Information: Source_Citation: Citation_Information: Originator: O'Hara, C. G. Publication_Date: 1994 Title: Permeability of soils in Mississippi Series_Information: Series_Name: U.S. Geological Survey Water-Resources Investigations Issue_Identification: WRIR 94-4088 Type_of_Source_Media: paper Source_Time_Period_of_Content: Time_Period_Information: Single_Date/Time: Calendar_Date: 1994 Source_Currentness_Reference: publication date Source_Citation_Abbreviation: O'Hara (1994) Source_Contribution: methods Source_Information: Source_Citation: Citation_Information: Originator: O'Hara, C.G. Publication_Date: 1996 Title: Susceptibility of ground water to surface and shallow sources of contamination in Mississippi Series_Information: Series_Name: U.S. Geological Survey Hydrologic Investigations Atlas Issue_Identification: HA-739 Type_of_Source_Media: paper Source_Time_Period_of_Content: Time_Period_Information: Single_Date/Time: Calendar_Date: 1996 Source_Currentness_Reference: publication date Source_Citation_Abbreviation: O'Hara (1996) Source_Contribution: methods Source_Information: Source_Citation: Citation_Information: Originator: Trapp, H., Jr. Originator: Horn, M. A. Publication_Date: 1997 Title: Ground water atlas of the United States, Segment 11, Delaware, Maryland, New Jersey, North Carolina, Pennsylvania, Virginia, West Virginia Series_Information: Series_Name: Hydrologic Investigations Atlas Issue_Identification: 730-L Type_of_Source_Media: paper Source_Time_Period_of_Content: Time_Period_Information: Single_Date/Time: Calendar_Date: 1997 Source_Currentness_Reference: publication date Source_Citation_Abbreviation: Trapp and Horn (1997) Source_Contribution: generalized geology Source_Information: Source_Citation: Citation_Information: Originator: Eimers, J. L. Originator: Weaver, J. C. Originator: Terziotti, S. Originator: Midgette, R. W. Publication_Date: 2000 Title: Methods of rating unsaturated zone and watershed characteristics of public water supplies in North Carolina Series_Information: Series_Name: U. S. Geological Survey Water-Resources Investigations Issue_Identification: WRIR 99-4283 Type_of_Source_Media: paper Source_Time_Period_of_Content: Time_Period_Information: Single_Date/Time: Calendar_Date: 2000 Source_Currentness_Reference: publication date Source_Citation_Abbreviation: Eimers and others (2000) Source_Contribution: methods for applying ratings Process_Step: Process_Description: Several new counties were added to the dataset; Anson, Avery, Buncombe, Burke, Catawba, Chatham, Clay, Cleveland, Graham, Henderson, Lee, Lincoln, Madison, Montgomery, Stokes, Surry, Transylvania, Vance, Watauga, Yadkin and part of Haywood County were included in this update Process_Date: 200905 Process_Step: Process_Description: Using the NRCS Soil Data Viewer 5.0, Load each county soil shapefile and database into the viewer. Process_Date: 200905 Process_Step: Process_Description: For each new county, open the Soil Physical Properties Attribute Folder, and choose saturated Hydraulic Conductivity (Ksat) for analysis Process_Date: 200905 Process_Step: Process_Description: As the Rating Option, Choose Weiighted Average aggregation method, and use the Dept Range of 0 to 100 inches. Choose MAP to display within ArcMap session. Process_Date: 200905 Process_Step: Process_Description: Open the table and export it as a dbf table that contains the Musym and Ksat values for each county Process_Date: 200905 Process_Step: Process_Description: Add a new field to the Ksat table, Ksat_inhr, and calculate it equal to Ksat * .1417 to convert it from um/s to in/hr Process_Date: 200905 Process_Step: Process_Description: Join the tables to the shapefiles, and convert each county to a grid with Ksat_inhr as the value for the grid. Merge all new counties. Process_Date: 200905 Process_Step: Process_Description: Do similar processes for soil thickness and depth to bedrock for the new counties. Process_Date: 200905 Process_Step: Process_Description: Calculate the new conductivity values for the new counties, substituting in Ksat for HMP. Process_Date: 200905 Process_Step: Process_Description: merge the new conductance grid with the old grid conductance grid so that the new values replace the old one. The areas outside of the new counties will retain the original values of the old conductance grid. Process_Date: 200905 Process_Step: Process_Description: Remap the conductance grid into categories using the following remap table (Using the ARC/INFO command, SLICE, with the TABLE option): >50 : 1 >100 : 2 >200 : 3 >400 : 4 >800 : 5 >1600 : 6 >3200 : 7 >6400 : 8 >12800 : 9 >100000 : 10 > Process_Date: 200905 Process_Step: Process_Description: First draft of metadata created by seterzio using FGDCMETA.AML ver. 1.33 07/15/99 on ARC/INFO data set h:\conductance\condgw Process_Date: 200905 Process_Step: Process_Description: Metadata imported. Process_Date: 200905 Source_Used_Citation_Abbreviation: W:\SWAP_updates\FinalLayers\condgw Spatial_Data_Organization_Information: Direct_Spatial_Reference_Method: Raster Raster_Object_Information: Raster_Object_Type: Grid Cell Row_Count: 13282 Column_Count: 29766 Vertical_Count: 1 Spatial_Reference_Information: Horizontal_Coordinate_System_Definition: Planar: Grid_Coordinate_System: 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_Coordinate_Information: Planar_Coordinate_Encoding_Method: row and column Coordinate_Representation: Abscissa_Resolution: 30.000000 Ordinate_Resolution: 30.000000 Planar_Distance_Units: meters Geodetic_Model: Horizontal_Datum_Name: North American Datum of 1983 Ellipsoid_Name: Geodetic Reference System 80 Semi-major_Axis: 6378137.000000 Denominator_of_Flattening_Ratio: 298.257222 Entity_and_Attribute_Information: Detailed_Description: Entity_Type: Entity_Type_Label: condgw.vat Attribute: Attribute_Label: Rowid Attribute_Definition: Internal feature number. Attribute_Definition_Source: ESRI Attribute_Domain_Values: Unrepresentable_Domain: Sequential unique whole numbers that are automatically generated. Attribute: Attribute_Label: VALUE Attribute: Attribute_Label: COUNT Overview_Description: Entity_and_Attribute_Overview: > >Value Attribute Table, SOILSGW.VAT: > >COLUMN ITEM NAME WIDTH OUTPUT TYPE N.DEC ALTERNATE NAME > 1 VALUE 4 10 B - > 5 COUNT 4 10 B - > 9 PCT_TOT 4 8 F 2 > 13 SQMI 4 8 F 2 > VALUE is the rating: valid values are integers 1 to 10, inclusive COUNT is the number of 30-meter by 30-meter cells in the entire data set that have the value. PCT_TOT is the percent of the total area JUST FOR the North Carolina portion of the study area SQMI area in square miles for that category WITHIN NORTH CAROLINA > >list condgw.vat >VALUE COUNT PCT_TOT SQMI >1 51100160 33.00 17756.81 >2 21891965 14.14 7607.24 >3 13801470 8.91 4795.88 >4 16552914 10.69 5751.98 >5 12036342 7.77 4182.51 >6 4644788 3.00 1614.02 >7 4811959 3.11 1672.11 >8 7653977 4.94 2659.68 >9 3498085 2.26 1215.55 >10 18850175 12.17 6550.25 > MIN is the minimum value (1 at the least) MAX is the maximum value (10 at the most) MEAN is the average value STDV is the standard deviation > >Statistics Summary Table, SOILSGW.STA: > >COLUMN ITEM NAME WIDTH OUTPUT TYPE N.DEC ALTERNATE NAME > 1 MIN 8 15 F 3 > 9 MAX 8 15 F 3 > 17 MEAN 8 15 F 3 > 25 STDV 8 15 F 3 > >list condgw.sta >Record MIN MAX MEAN STDV > 1 1.000 10.000 3.910 3.136 > Entity_and_Attribute_Detail_Citation: none Distribution_Information: Distributor: Contact_Information: Contact_Organization_Primary: Contact_Organization: U.S. Geological Survey Contact_Position: Information Officer Contact_Address: Address_Type: mailing and physical address Address: 3916 Sunset Ridge Rd. City: Raleigh State_or_Province: NC Postal_Code: 27607 Country: USA Contact_Voice_Telephone: (919) 571-4000 Contact_Electronic_Mail_Address: gs-w-ncrlg_www@usgs.gov Contact_Instructions: Contact via email Resource_Description: Downloadable Data Distribution_Liability: Although these data have been used by the U.S. Geological Survey, U.S. Department of the Interior, no warranty expressed or implied is made by the U.S. Geological Survey as to the accuracy of the data. The act of distribution shall not constitute any such warranty, and no responsibility is assumed by the U.S. Geological Survey in the use of this data, software, or related materials. Standard_Order_Process: Digital_Form: Digital_Transfer_Information: Transfer_Size: 31.227 Metadata_Reference_Information: Metadata_Date: 20090630 Metadata_Review_Date: 2009 Metadata_Contact: Contact_Information: Contact_Organization_Primary: Contact_Organization: U.S. Geological Survey Contact_Person: North Carolina Water Science Center Director Contact_Position: Director Contact_Address: Address_Type: mailing and physical address Address: 3916 Sunset Ridge Road City: Raleigh State_or_Province: NC Postal_Code: 27607 Country: USA Contact_Voice_Telephone: (919) 571-4000 Contact_Facsimile_Telephone: (919) 571-4041 Contact_Electronic_Mail_Address: dc_nc@usgs.gov Metadata_Standard_Name: FGDC Content Standards for Digital Geospatial Metadata Metadata_Standard_Version: FGDC-STD-001-1998 Metadata_Time_Convention: local time Metadata_Access_Constraints: none Metadata_Use_Constraints: none Metadata_Extensions: Online_Linkage: http://www.esri.com/metadata/esriprof80.html Profile_Name: ESRI Metadata Profile