Georgia Environmental Protection Division

Browse by Category
Browse by Program
Other Links
 

DATA
FROM GEORGIA'S WELLHEAD PROTECTION COMPLETED THROUGH DECEMBER 1999

DOCUMENTATION REPORT 00-13


OVERVIEW

GLOSSARY


PART A: GENERAL DESCRIPTION OF THE GIS DATABASE

1.0 Identification/Project Background 1

2.0 Data Quality Information 2

2.1 Attribute Accuracy 2

2.2 Logical Consistency 3

2.3 Completeness 3

2.4 Positional Accuracy 3

2.5 Lineage 4

3.0 Spatial Data Organization Information 5

4.0 Spatial Reference Information 5

5.0 Entity and Attribute Information 5

6.0 Distribution Information 5

7.0 Metadata Reference Information 6

Appendix A: Signatures

Appendix B: Figure One - Site Data From Georgia’s Wellhead Protection Plans Completed Through December 1999.


PART B: TECHNICAL DESCRIPTION OF THE GIS DATABASE
1.0 Identification Information 1

1.1 Citation 1

1.2 Description 1

1.3 Time Period of Content 3

1.4 Status 3

1.5 Spatial Domain 3

1.6 Keywords 3

1.7 Access Constraints 3

1.8 Use Constraints 3

1.9 Point of Contact 4

1.13 Native Data Set Environment 4

2.0 Data Quality Information 4

2.1 Attribute Accuracy 4

2.2 Logical Consistency Report 5

2.3 Completeness Report 5

2.4 Positional Accuracy 6

2.5 Lineage 6

3.0 Spatial Data Organization Information 16

3.1 Indirect Spatial Reference Method 16

3.2 Direct Spatial Reference Method 16

3.3 Point and Vector Object Information 16

4.0 Spatial Reference Information 16

4.1 Horizontal Coordinate System Definition 16

4.2 Vertical Coordinate System Definition 16

5.0 Entity and Attribute Information 16

5.1 Detailed Description 16

6.0 Distribution Information 27

6.1 Distributor 27

6.2 Resource Description 27

6.3 Distribution Liability 27

6.4 Standard Ordering Process 27

6.5 Custom Order Process 27

7.0 Metadata Reference Information 27

7.1 Metadata Date 27

7.2 Metadata Review Date 27

7.4 Metadata Contact 27

7.5 Metadata Standard Name 28

7.6 Metadata Standard Version 28

PART C: DIGITAL FILES CONTAINING GIS DATABASE
Summary of Contents of Data DISKETTE


OVERVIEW  

This documentation report followed the "Content Standards for Digital Geospatial Metadata" developed by the Federal Geographic Data Committee (FGDC), published June 8, . As a convenience, Part A and B employ the outline/headings contained in the Standards. A and B are printed on paper and Part C is composed of the digital products. Part B meets the requirements of the Standards.

This document is a three-part documentation report for a Geographic Information System (GIS) developed, with Arc/Info software, by the Geologic Survey Branch, Environmental Division of the Georgia Department of Natural Resources. Part A is intended as a purpose summary of the database. Part B is a more technical section included primarily for benefit of GIS processors. Part C contains the digital products, the database and its associated , which includes copies of this paper publication.

The digital documentation in Part C contains two copies of this publication. One digital copy is as an ASCII file, DR0013.TXT. The other copy is in WordPerfect 6/7/8 format, and is DR0013.WPD. The digital database in Part C consists of an Arc/Info Export file, .E00. To access the database, copy the Arc/Info Export file into a directory and then run Arc/Info Import command. See Part C of this document for a complete list of the diskette’s and for data file size.

The digital files are written to one 1.44 MB High Density data diskette. A directory of the files a short explanation is contained in the ASCII file README.TXT on the data diskette.

This database was developed to satisfy specific project purposes. Users advised to read the entire Documentation Report and to evaluate the and limitations of the database for their purpose.

This document contains data current through December 31, 1999 and Documentation Report 99-17, Data from Georgia's Wellhead Plans Completed Through December 1998.


GLOSSARY

Arc/Info: a popular GIS software, used by the Geologic Survey Branch.

aquifer: Stratum or zone below the surface of the earth capable of producing water as from a well. ground water refers to water that is under sufficient pressure (Hydrostatic head) to rise the aquifer that contains it. Unconfined ground water is water that is not under any pressure.

ASCII: abbreviation for 'American Standard Code for Information Interchange' a set of codes for alphanumeric information in a format so any computer can read.

attribute: a characteristic of a geographic feature. For example, if the geographic feature is a river, the attributes of a river are the river's name, the river's flow rate, and it's chemical composition, .

attribute accuracy: a measure of how well the reported characteristics actually match the characteristics of a geographic feature.

Compact Disk Read Only Memory (CD-ROM): an optical media which can store 650 MB of .

completeness: a description of the relation between the items represented in the database and the world. For example, if a database contains water wells in Georgia, does it contain all the water in Georgia, or a defined subset of wells? If the database contains a defined subset of wells, it contain every well in Georgia that meets the definition by which the subset was chosen?

contaminants: any substance that contaminates, to make impure by contact or mixing with (in this water and making it non drinkable or non-usable.

Content Standards for Digital Geospatial Metadata: a standard developed by the Federal Data Committee (FGDC) which specifies the information content of metadata for a set digital Geospatial data.

control zone (well): a circular area around a well with a radius of 15 feet for impervious surface or 25 feet for pervious surface materials. The purpose of the control zone is to provide for the well. The control zone generally will be required to have a fence and locking gate limit access. The owner of the well is expected to be able to control all activities within this zone that there are minimal sources of potential pollution within the immediate vicinity of the well.

crystalline rock: Rocks consisting of minerals in an obviously crystalline state. An inexact general for igneous and metamorphic rocks as opposed to sedimentary. In this documentation report term is used to describe a type of aquifer.

database: a logical collection of interrelated information, managed and stored as a unit on a or other storage media. A GIS database includes data about the spatial location and shape geographic features recorded as points, lines, areas, as well as their attributes.

decimal degrees: a unit of measure for geographic coordinates. The conversion formula for degrees is: Decimal Degrees = Degrees + Minutes/60 +Seconds/3600.

Department of Natural Resources (DNR): a department of the government of the State of .

digital: refers to the process of conversion of information into machine language so that a can read, write, store, and process the information.

Digital Line Graphs (DLG): computer files from the USGS which contain digital maps of

transportation, hydrography, contours, and public land survey boundaries.

digital maps: a map is an abstract representation of the physical features of a portion of the

Earth's surface graphically illustrated onto a piece of paper. When that piece of paper is converted

into a form which the computer can use, the map is then digital.

diskette: a storage medium, usually measuring 3.5 inches in diameter, which is used to store or

transfer information from one computer to another.

Federal Geographic Data Committee (FGDC): an inter-governmental committee established the Office of Management and Budget and charged with the responsibility to coordinate surveying, mapping, and spatial data activities to meet the needs of the Nation.

Geographic Information System (GIS): an organized collection of computer hardware, software, data, and personnel designed to efficiently capture, store, update, manipulate, analyze, display all forms of geographically referenced information.

Geographic Province: a region of similar structure (geology) and climate that has a unified history.

ground water: Water occupying openings, cavities, and spaces in soils or rocks.

hydrogeologic: the geologic factors relating to ground water.

hypsography: the scientific study of the earth’s topological configuration above sea level, the measurement and mapping of land elevations.

inner management zone: a term used by EPD to describe an area around a well (includes the zone) that provides for a high level of protection from potential pollution sources. The inner zone is a fixed radius around a well. For completely confined aquifer wells, the inner zone has a radius of 100 feet. Wells completed in unconfined or partially confined will have an inner management zone radius of 250 feet. For those wells completed in karst, inner management zone has a radius of 500 feet.

Karst: A limestone plateau marked by sinks, or karst holes, interspersed with abrupt ridges and protuberant rocks: usually underlain by caverns and underground streams. In this report the term is used to describe a type of aquifer.

Label points: a single x,y coordinate which identifies an area, and holds a place in the database the area's attribute information is stored.

latitude, longitude: a geographic reference system to locate positions on the Earth. Latitude and are angles measured from the Earth's center to a position on the Earth's surface. Latitude angles in a north-south direction, while longitude measure angles in the east-west .

lineage: information about the events, parameters, and source data which constructed a geographic , and information about the responsible parties.

logical consistency: an explanation of the fidelity of the relationships in the database. For example, a geographic area, do the vector lines which create area boundaries join to encircle the area with gap? Or for example, for a particular attribute, are all the values given within a valid range?

longitude, latitude: see latitude, longitude.

metadata: information about the content, quality, condition, and other characteristics of a .

municipal water system : a community public water system owned by a municipality, county or .

National Map Accuracy Standards: a set of standards developed by the USGS which states the of accuracy required for a map product of a particular scale.

outer management zone: a term used by EPD to describe a second protection area around the . This zone also is established to provide for a high level of protection from potential pollution . The size of the outer management zone varies according to the aquifer type, the wells rate water extraction, the hydrologic province, and proximity to recharge areas. For confined aquifer there is no outer management zone. For unconfined aquifer wells drilled into crystalline , the outer management zone is dependent on the pumping rate of the well. The higher the of water extraction, the larger the radius of the outer management zone. In order to determine radius of the outer management zone for fractured crystalline rock wells (Piedmont and Blue wells), EPD uses a modified methodology developed by Ralph Heath for the North Carolina Protection Program. For wells located in karst terrain, the outer management zone is based on hydrogeologic mapping.

PKZIP: a popular data compression software.

positional accuracy: an assessment of how well the reported position of a geographic feature the real-world position.

topology: The spatial relationships between connecting or adjacent coverage features

(e.g., arcs, nodes, polygons, and points). For example, the topology of an arc includes its from- and , and its left and right polygons. Topological relationships are built from simple elements complex elements: point (simplest element,) arcs (sets of connected points), areas (set of arcs), and routs (sets of sections, which are arcs or portions of arcs). Redundant data (coordinates) are eliminated because an arc may represent a linear feature, part of the boundary of area feature, or both. Topology is useful in GIS because many spatial modeling operations don't coordinates, only topological information. For example, to find an optimal path between points requires a list of the arcs that connect to each other and the cost to traverse each arc in direction. Coordinates are only needed for drawing the path after it is calculated.

spatial analysis: The process of modeling, examining, and interpreting model results. Spatial analysis is useful for evaluating suitability and capability, for estimating and predicting, and for and understanding. There are four traditional types of spatial analysis: topological and contiguity analysis, surface analysis, linear analysis, and raster analysis.

spatial data: Information about the location and shape of, and relationships among, geographic , usually stored as coordinates and topology.

subsurface drinking water supplies: drinking water extracted from ground water.

United States Geological Survey (USGS): a branch of the United States Department of

Interior.

vector lines: lines which are described by x,y coordinates and are commonly used to represent

linear geographic features. Each linear feature is represented as an ordered list of vertices.

Water System (Public ): A public water system is defined as a system that provides water via or other constructed conveyances for human consumption to at least 15 service connections serves an average of at least 25 people for at least 60 days each year. Municipal water systems defined as public water systems that are owned or operated by county or city governments.

Wellhead : in this report the term refers to the point where the water well casing is located and the water is pumped up from underground.

Wellhead Control zone : an area around a well with a 15 or 25 foot radius. The purpose of the zone is to provide security for the well. The control zone generally will be required to have fence and locking gate to limit access. The owner of the well is expected to be able to control all within this zone so that there are minimal sources of potential pollution within the vicinity of the well.

wellhead management zone: an area extending a sufficient distance from the well to provide from surface and near surface pollution sources. The size of the management zone will according to the aquifer type, pumping rate, hydrologic province, and proximity to recharge. this zone, certain potential pollution source activities are prohibited or the activities must be in accordance with EPD's Rules for Safe Drinking Water.

wellhead protection areas: see wellhead management zone .

WordPerfect: a popular word processing software.


PART A

GENERAL DESCRIPTION OF THE GIS DATABASE:

DATA FROM GEORGIA'S WELLHEAD PROTECTION PLANS THROUGH DECEMBER 1999


1.0 Identification/Project Background

The Federal Safe Drinking Water Act (PL93-523) requires each state to develop a program to the public water supplies that use ground water. To meet this requirement, Georgia passed Safe Drinking Water Act of 1977 (Act No. 231 O.C.G.A. 12-5-170 et. Seq., as amended). The of Natural Resources (DNR) is implementing the Wellhead Protection Program its Rules for Safe Drinking Water, (Chapter 391-3-5) which were promulgated in July . Wellhead Protection is addressed in section 391-3-5-.40 of the Rules. The Rules are for review or download at the web site   .

 

Wellhead protection (WHP) is the practice of managing an area around a water well or a spring, to any contaminants released at the ground's surface from reaching the sub-surface drinking , the ground water supply. Typically, this is achieved by restricting specific activities which occur within the WHP area. Wellhead protection areas are determined by using a well or geographic location, hydrogeologic characteristics of the water supply, well construction, locations of potential contaminant sources in relation to the wellhead. The large expense that be required for developing alternate water supplies or cleaning up contaminant spills makes Plans a desirable and cost-effective approach for protecting municipal ground water drinking .

The Geologic Survey Branch (GSB) of the Environmental Protection Division (EPD) of DNR, funds provided by the U.S. Environmental Protection Agency, gathers data needed for the of WHP plans, and delineates WHP areas around municipal ground water systems. initial information for municipal drinking water supply wells or springs comes from EPD's Water Permitting and Engineering Program files and is then correlated with the data at the GSB. Information about potential pollution sources and the well's and longitude is collected at the wellheads by GSB's field personnel.

For the year ending in 1999, GSB has compiled information used in developing the WHP Plans for wells and springs in 344 water systems. This information is contained within this GIS database. are approximately 1200 wells and springs in 425 municipal water systems in the state of . The database is scheduled to be updated annually as new WHP plans are completed. In update, well information from newly completed WHP plans are added to the database. some previously entered water systems may become inactive, well information is not during updating of the database.

This report is an update to and supercedes Documentation Report 99-17, Data from Georgia's Protection Plans Completed Through December 1998.

This database contains information that identifies each individual well or spring in a water system, about the geographic location of the well or spring, information about the WHP area, information about potential pollution sources in the WHP area.

The purpose of the database is to identify municipal water systems with completed Wellhead Plans through 1999, and to provide information about the wells in those systems.

The intended map scale for the database is 1:24,000 or smaller.

2.0 Data Quality Information

The following sections contain information describing the database's attribute accuracy, logical , completeness, positional accuracy, and lineage.

2.1 Attribute Accuracy

In this GIS database, every data record represents either a wellhead or a spring within a municipal system.

Information for each municipal water well or spring is copied from the Drinking Water Program

data files. The information is verified by the Drinking Water Program associates, who administer of the wells and springs in a drinking water system. The data is assumed by GSB to be .

An inventory of potential pollution sources is made by GSB associates using direct observations in the field. A listing of potential pollution sources can be found in the next to the last of Part A, Section 5.0, Entity and Attribute Information. The GSB management makes on site visitations for the purpose of verifying the accuracy of the well information and the for the potential pollution sources. The manager overseeing the WHP Program indicates that general, the results of the on-site visits are consistent with the draft WHP plans, although additional potential pollution sources are added to the plans.

The permit numbers (Water System Id) were current at the time of the wellhead protection plan's . Since that time, some water systems may no longer be active or may have been by another water system. In that case the system name or water system Id may no longer in use, but the WHP Plan is still valid.

For the attribute Physiographic Provinces in this GIS database, all crystalline rock aquifers in either Blue Ridge or Piedmont are listed as being in the Piedmont province.

Information used in developing a water system's WHP Plan is manually entered into a Quattro Pro which was used to generate this GIS coverage. GSB associates used random spot to verify the data entry in the Quattro Pro spreadsheet by comparing the spreadsheet with WHP Plans. Corrections were made to the Quattro Pro spreadsheet when omissions or errors found. The manager of the WHP Program has indicated that the accuracy of the WHP plans the Quattro Pro spreadsheet are generally very good.

A small scale (1:500,000) map was made with all the wells and springs from this GIS database. well site was labeled with its permit number (Water System Id). GSB compared this map with WHP Plans. No errors were noted.

2.2 Logical Consistency

A visual inspection of all attributes in the database was made and it appears that the data was input a consistent manner. The county column has valid county names. The imbedded county code in permit number and the county name corroborate each other. The quadrangle names that are in the database are valid quadrangle names. The latitude and longitude columns contain and have the same pattern of entry: Degrees, Minutes, Seconds.

2.3 Completeness

This GIS database contains the key data that was used in making WHP Plans. The database is as a set of 911 data points representing the wellhead locations for 344 municipal ground systems that have completed WHP Plans as of the end of December 1999. There are 1200 wells and springs in 425 municipal water systems in the state of Georgia. The is scheduled to be annually updated by GSB until all active municipal water wells and have WHP Plans.

2.4 Positional Accuracy

In most cases the wellhead latitude and longitude coordinates were collected in the field by GSB utilizing a Trimble Navigation GPS Pathfinder Basic Plus global positioning satellite receiver. In cases where the wellhead(s) is located inside of a building, the coordinates were outside of the building, and are not directly on the wellhead. A GPS receiver will not near or within a closed structure if it blocks the radio signals from the transmitting satellites. data was recorded indicating the amount or direction of the offset or to identify which wells offsets.

In general, the GPS coordinate accuracy is a function of the equipment and data processing . The DOD (Department of Defense) has the ability to degrade GPS accuracy at any time. these variations, GPS measurements and accuracy can range from 1 centimeter to over 300 . With differential correction, the accuracy is typically 2-5 meters.

In some cases the coordinates were not collected by GPS, instead they were derived from 1:24,000 topographic quadrangle maps. In those cases the GSB associates manually plotted the well spring location using graphic aids, and latitude and longitude lines printed on the quadrangle . The associates recorded the latitude and longitude to the nearest second of a degree, or 100 feet.

Positional attributes were checked for gross errors. Two methods were used. First, an internal check is used. For each well record, the county name listed in the database was against a county code embedded in the water system id number. The second method the used was to overlay the well latitude and longitude coordinates onto an existing county base map, with each well labeled by county. The map was then visually inspected to that the county name listed in the WHP database matched the county name on the base map. inconsistencies in the county information were found and are the result of the county information being derived from the location of the water plant rather than the location of the well, will occur when the water systems are close to the county line.

 

2.5 Lineage

This GIS database was created from data stored in a Quattro Pro spreadsheet. The data was input the Quattro Pro spreadsheet from individual Wellhead Protection Plans. The Wellhead Plans were prepared from information from several different sources.

Information about the wells and springs in a municipal water system come from EPD's Drinking Permitting and Engineering Program files. Information about the physiographic province and of a well or spring comes from the Geologic Map of Georgia and The Georgia Wellhead Plan, Appendix E .

The control zone for each well is calculated as a circular area with a radius of 15 feet from the when the well is surrounded by impermeable pavement or building, or a radius of 25 feet the wellhead when surrounded by permeable surfaces.

The inner management zone is calculated as a circular area with a radius of either: 100 feet for confined aquifer wells; 250 feet for unconfined or partially confined Coastal Plain or aquifers; and 500 feet for unconfined karst wells.

For an unconfined aquifer well drilled into fractured crystalline rock the outer management zone is as a circle whose radius depends on the pumping rate of the well. The greater the rate, the larger the radius. The modified Heath method is used as described in The Georgia Protection Plan, Appendix G . In the case of a completely confined aquifer well, an outer zone is not required. For unconfined wells in the Coastal Plain, a volumetric flow is used as described in Guidelines for Delineation of Wellhead Protection Areas , by the EPA,     For wells water from karst aquifers, the outer management zone is determined by using mapping.

Once the outer management zone of a well is delimited on a USGS topographic quadrangle map, GSB associates do a field survey. They collect the latitude and longitude of the wellhead using a receiver and inventory the area of the management zone for potential pollution sources.

The latitude and longitude are then differentially corrected for greater accuracy. In earlier releases this GIS database, the GPS latitude and longitude were reported to have been processed from the North America Datum (NAD) 83 to NAD 27. This was an error which has been corrected. GPS coordinates values were collected as NAD 83 and are now being reported in the Datum of this GIS database as NAD 83.

The GSB associates develop a WHP plan from the collected information. Once the plan is reviewed approved, data from the plan is entered into the Quattro Pro spreadsheet. The data is then into a GIS database.

  3.0 Spatial Data Organization Information

The database is organized as a set of 911 data points representing the wellheads for 344 municipal water systems that have completed WHP Plans as of the end of December 1999.

4.0 Spatial Reference Information

The wells in this database are all located within the state of Georgia. The projection is Albers-Georgia Conic Equal Area. For more detail, see Part B, Section 4.

5.0 Entity and Attribute Information

The GIS database contains information that was used in the development of a WHP Plan for each ground water system for the year ending 1999. There are 911 records, and each record information about a well or spring.

The database contains information about each water system: the water system ID number; the name; the water system name; and the size of the population served by the water system.

The database contains information to identify each well or spring: a unique record number; a well id , the name of the topographic quadrangle map in which the well is located; the province in which the well is located; an aquifer type from which the well pumps its , and the pump rate.

The database contains information about each well's location: the latitude coordinate, the longitude , the datum of the coordinates, and the source of the coordinates.

The database contains information about the WHP plan: year each plan was approved; radius of Control Zone area; radius of the Inner Management Zone area; and the radius of the Outer Zone area.

The database contains information about whether the following potential pollution sources exist the management zone: roads; vehicle parking; utility poles; electrical transformers; storage tanks; above ground storage tanks; septic tanks; septic drain fields; waste facilities; piles of debris, old tires, or junked cars; agricultural fields or pasture areas; fields; animal enclosures; heavy machinery storage; small commercial businesses; industrial ; agricultural waste impoundments; industrial waste disposal impoundments; demolition ; industrial landfill; quarries or mines; and hazardous waste sites.

The attributes are described in more technical detail in part B, section 5 of this report.

6.0 Distribution Information

This database is maintained by the Geologic Survey Branch as Documentation Report 00-13 and is in digital files in Part C of this publication.

7.0 Metadata Reference Information

The metadata incorporated within Part B of this publication, Documentation Report 00-13, meets "Content Standards for Digital Geospatial Metadata" as defined by the Federal Geographic Data on June 8, 1994.



Appendix A :

Signatures for the Database:

Data from Georgia's Wellhead Protection Plans

Completed Through December 1999

**********

Preparation of Database and Documentation Report

 

Prepared by: __________________________ ______________________

Dave Hipple (Date Signed)

Checked by: __________________________ ______________________

Elizabeth Cheney (Date Signed)

**********

Data Source   and Data Provider  

Data Provider: _________________________ ______________________

Sue Grunwald (Date Signed)

 

**********

Authorization  

The Geologic Survey Branch of the Environmental Protection Division of the Georgia Department Natural Resources approves of the release of the GIS database as described in Parts A and B of accompanying documentation report.

 

Authorized by: ________________________ (Signed) ___________________

(Date Signed)

_________________________ (Printed)

Assistant Branch Chief

PART B :

TECHNICAL DESCRIPTION OF THE GIS DATABASE:

DATA FROM GEORGIA'S WELLHEAD PROTECTION PLANS

COMPLETED THROUGH DECEMBER 1999


1.0 Identification Information :

1.1 Citation :

1.1.8.1 Originator: Geologic Survey Branch  

Environmental Protection Division

Georgia Department of Natural Resources  

1.1.8.2 Publication Date: 2000  

1.1.8.4 Title: DR0013: DATA FROM GEORGIA'S PROTECTION PLANS THROUGH DECEMBER   1999  

1.1.8.5 Edition: Ver. 1.0  

1.1.8.6 Geospatial Data Presentation Form: GIS Database,  

1.1.8.8.1 Publication Place: Atlanta, Georgia  

1.1.8.8.2 Publisher: Geologic Survey Branch

Environmental Protection Division

Georgia Department of Natural Resources  

1.1.8.10 Online Linkage:

   

1.2 Description :

1.2.1.1 Abstract:

  The Federal Safe Drinking Water Act (PL93-523) requires each state to a program to protect the public water supplies that use ground water. response, Georgia passed the Safe Drinking Water Act of 1977 (Act No. 231 .C.G.A. 12-5-170 et. Seq., as amended). The Department of Natural (DNR) is implementing the Wellhead Protection Program through Rules for Safe Drinking Water, (Chapter 391-3-5) which were promulgated July 1993. Wellhead Protection is addressed in section 391-3-5-.40 of the . Go to the web site   for more .

Wellhead protection (WHP) is the practice of managing an area (the WHP around a water well or a spring, to prevent any contaminants released at ground's surface from reaching the ground water supply, or the sub-surface drinking water. Typically, this is achieved by restricting specific which may occur within the WHP area. Wellhead protection areas determined by using a wellhead's geographic location, hydrogeologic of the water supply, well construction, and locations of potential sources in relation to the wellhead. The large expense that would be for developing alternate water supplies or cleaning up contaminant makes WHP Plans desirable and cost-effective for protecting municipal water drinking supplies.

The Geologic Survey Branch (GSB) of the Environmental Protection Division is utilizing funds provided by the U.S. Environmental Protection Agency to gather data needed for developing WHP plans, and to delineate areas around municipal, city or county owned water systems. The initial for municipal water supply wells or springs is gathered from Drinking Water Permitting and Engineering Program files and with the hydrogeologic data at the GSB. Information about contaminant sources and a well's position is collected at the wellhead by GSB's field personnel.

For the year ending in 1999, GSB has compiled information used in developing WHP Plans for 911 wells and springs in 344 water systems. The for these wells is contained within this GIS database. There are 1200 wells in 425 water systems in the state.

The database is scheduled to be updated annually and this report is an update and supercedes Documentation Report 99-17, Data from Georgia's Wellhead Plans Completed Through December 1998.

The Wellhead Protection Program associates collected and recorded the information: the water system's identification number; the name of county where the water system is permitted; water system's name; well ; the size of the population being served by the water system; the name the USGS 7.5 minute quadrangle topographic map where the wellhead is ; name of the physiographic province where the water well is located; type of aquifer from which the well pumps water; the pumping rate of the ; year of Wellhead Protection Plan completion; latitude, longitude, and used for the latitude and longitude collection; the source of the latitude longitude; and any potential pollution sources present in the WHP area.

The list of potential pollution sources collected for this database includes: , vehicle parking, utility poles, electrical power transformers, storage tanks, above ground storage tanks, septic tanks, septic fields, waste treatment facilities, debris piles, agricultural fields or areas, irrigated fields, animal enclosures, heavy machinery storage, commercial businesses, industrial complexes, agricultural waste , industrial waste disposal sites, demolition or industrial , quarries or mines, and hazardous waste sites.

Using the above information, Wellhead Protection Plans are prepared. in the Wellhead Protection program calculate the applicable radii the control zone, the inner management zone, and the outer management . These radii are reported in this GIS database.

 

1.2.2 Purpose of the database is to:

Identify water systems with completed municipal Wellhead Protection Plans 1999, and provide information about the wells in those systems.  

 

1.3 Time Period of Content : current through December 31, 1999.

1.3.1 Currentness Reference: publication date of WHP plans .

 

1.4 Status : Complete  

1.4.2 Update Frequency: Yearly until project completed.  

 

1.5 Spatial Domain :

1.5.1 Bounding Coordinates:

1.5.1.2 West Bounding Coordinate: - 085 29 46.6  

1.5.1.3 East Bounding Coordinate: - 080 44 27.6  

1.5.1.4 North Bounding Coordinate: 34 59 13.2  

1.5.1.5 South Bounding Coordinate: 30 40 51.6  

 

1.6 Keywords :

1.6.1 Theme:

1.6.1.1 Theme Keyword Reference: GEOREF Thesaurus and Guide to

Indexing, Second Edition. 1978. American Geological Institute.  

1.6.1.2 Theme Keyword: water supply  

1.6.1.2 Theme Keyword: wells

1.6.1.2 Theme Keyword: ground water  

1.6.2 Place:

1.6.2.1 Place Keyword: Ga.

1.6.2.1 Place Keyword: USA

1.6.2.1 Place Keyword: Georgia  

 

1.7 Access Constraints : None  

 

1.8 Use Constraints :

  The Georgia Geologic Survey Branch should be acknowledged as the source in products derived from these data.

This data set is not designed for use as a primary regulatory tool in or citing decisions, but may be used as a reference source. is public information and may be interpreted by organizations, , units of government, or others based on needs; however, they responsible for the appropriate application. Federal, State, local bodies, private individuals or organizations are not to to the Georgia Geologic Survey Branch any authority for the that they make.

This data set is not intended for map scales greater than 1:24000. or digital enlargement of these maps to scales greater at which they were originally mapped can cause misinterpretation the data. The use of these data does not eliminate the need for onsite , testing, and detailed study of specific sites for intensive uses. , these data and their interpretations are intended for planning purposes only. Digital data files are periodically updated. are dated, and users are responsible for obtaining the latest of the data.

 

1.9 Point of Contact :

1.9.10.1.1 Contact Person:

1.9.10.1.2 Contact Organization: Geologic Survey Branch  

1.9.10.1.3 Contact Position: Information Geologist  

1.9.10.1.4 Contact Address:

1.9.10.1.4.2 Address: 19 Martin Luther King, Jr., Dr., SW  

1.9.10.1.4.3 City: Atlanta  

1.9.10.1.4.4 State or Province: Georgia  

1.9.10.1.4.5 Postal Code: 30334-9004  

1.9.10.1.4.6 Country: USA  

1.9.10.1.5 Contact Voice Telephone: (404) 656-3214  

1.9.10.1.7 Contact Facsimile Telephone: (404) 657-8379


1.9.10.1.8 Contact Electronic Mail Address: Info_Geologist @mail.dnr.state.ga.us


1.9.10.1.9 Hours of Service: 8am - 1pm and 2pm - 4:30pm Eastern Time  

 

1.13 Native Data Set Environment: Arc/Info version 8.0.1, Microsoft NT 4.0

2.0 Data Quality Information :

2.1 Attribute Accuracy :

2.1.1 Attribute Accuracy Report:

In this GIS database, every data record represents a well site within a water system and contains 41 separate items of information.

Background information for a municipal water well is copied from the Water Permitting and Engineering Program’s data files [DWPP]. information is verified by Drinking Water Program associates. The data from the permit files are assumed by GSB to be accurate.  

 

The water system information is current at the time of the WHP plan's . Since that time, some water systems may no longer be active or have been purchased by another water system. In that case the system or water system id in the GIS database may no longer be valid.  

An inventory of potential pollution sources is made by GSB associates using observations while in the field. The GSB management makes random site visitations for the purpose of verifying the accuracy of the field . The manager of the WHP Program, the Groundwater Program Manager, indicates that in general, the results of the visits are consistent with the draft WHP plans. Sometimes additional potential pollution sources (PPS) are found during these QA/QC visits. The PPSs are added to the plans.  

 

For the attribute Physiographic Provinces in this GIS database, all crystalline aquifers in either the Blue Ridge or Piedmont are listed as being in the province.  

 

Information from each WHP Plan is manually entered into a Quattro Pro . There is a possibility of keyboard error. GSB associates used spot checking to verify the data entry in the Quattro Pro spreadsheet comparing the spreadsheet with the WHP Plans. Corrections were made to Quattro Pro spreadsheet when omissions or errors were found. The of the WHP Program has indicated that the accuracy of the WHP and the Quattro Pro spreadsheet are generally very good.  

 

A small scale (1:500,000) map was made with all the well sites from the GIS . Each well site was labeled with its permit number (water system Id). compared this map with their WHP Plans. No errors were noted.  

2.2 Logical Consistency Report :

  A visual inspection of all attributes in the database was made and it appears the data was input in a consistent manner. The values in the "county" were visually checked against a list of valid county names. The county code in the "permit" attribute and the "county" attribute each other. The data entries for the "quadrangle" attribute were against a valid list of quadrangle names. The "latitude" and attributes were visually checked to see that they contain numbers have the same pattern of degree, minute, and second entry.

The database contains point information, which has no inherent topology. consistency of the topology does not apply.  

 

2.3 Completeness Report :

  The database is not a complete set of all the (approximately 1200) wellheads for state of Georgia. The database is organized as a set of 911 data points the wellheads for 344 (out of 425) municipal ground water that have completed WHP Plans as of the end of December 1999. The for these wells is complete. The remaining municipal ground water in Georgia do not yet have WHP plans and so are not included in this . The database is scheduled to be updated annually as new WHP are completed.   In each update, well information from newly completed plans are added to the database. Although some previously entered systems may become inactive, well information is not removed during of the database.  

2.4 Positional Accuracy :

2.4.1.1 Horizontal Positional Accuracy Report:

  In most cases the well's latitude-longitude coordinates were determined in the by GSB associates utilizing a Trimble Navigation GPS Pathfinder Basic global positioning satellite (GPS) receiver for data collection while the wellhead. In some cases the wellheads are located inside of a . Therefore, some coordinates will represent not the actual wellhead but a point that is within a close proximity of the wellhead. The GPS will not operate near or within a closed structure that blocks the radio from the transmitting satellites. No data was recorded indicating the or direction of the offset or to identify which wells have offsets.

 

In general, the GPS coordinate accuracy is a function of the equipment and processing methods. The DOD (Department of Defense) has the ability to GPS accuracy at any time. With these variations, GPS measurements accuracy can range from 1 centimeter to over 300 meters. The General for the GPS Pathfinder System [TRIMBLE, pg. 29] states "Using the Pathfinder family of products, you can achieve accuracy typically on the of 2 to 5 meters with differential correction." In earlier releases of this database, the GPS latitude and longitude were incorrectly reported to been processed from the default North America Datum (NAD) 83 to NAD . This was an error that has been corrected in this version of the database. GPS coordinates values were collected as NAD 83 and are now being in the Datum column of this GIS database as NAD 83.  

In some cases a GPS reading was not taken for/at a wellhead. In those cases, GSB associates manually plotted onto USGS 7.5 minute topographic maps and then they extracted the wellhead location using graphic and the latitude and longitude lines printed on the USGS 7.5 minute quadrangle map. In those cases, the latitude and longitude are to the nearest second of a degree, or approximately 100 feet. , these latitude and longitude were reported using NAD27. The difference, NAD 27 and NAD83, was corrected during GIS Processing

2.4.2 Vertical Positional Accuracy Report: None

2.5 Lineage :

 

2.5.1 Source Information

2.5.1.1 Source Citation:  

2.5.1.1.8.1 Originator: Drinking Water Permitting and Engineering , Environmental Protection Division, Department of Natural Resources  

2.5.1.1.8.2 Publication Date: None  

2.5.1.1.8.4 Title None  

2.5.1.1.8.6 Geospatial Data Presentation Form: Text  

2.5.1.3 Type of Source Media: printed paper files  

2.5.1.5 Source Citation Abbreviation: DWPP  

2.5.1.6 Source Contribution: The Drinking Water Permitting and Engineering collects, processes, permits, and record files for drinking water systems the state of Georgia. Information from these is used in the creation of the WHP plans and GSB database.  

2.5.1 Source Information

2.5.1.1 Source Citation:

2.5.1.1.8.1 Originator: Environmental Protection Division , Department of Natural Resources  

2.5.1.1.8.2 Publication Date: March 2000 (Web site)  

2.5.1.1.8.4 Title: Technical Guidance, Drinking Water and Compliance - Drinking Systems

2.5.1.1.8.6 Geospatial Data Presentation Form: Online   Text  

2.5.1.1.8.8 Publication Information:

2.5.1.1.8.8.1 Publication Place: Atlanta, GA (via web site)

2.5.1.1.8.8.2 Publisher: Environmental Protection Division

2.5.1.1.8.10 Online Linkage:    

2.5.1.3 Type of Source Media: online machine-readable files  

2.5.1.5 Source Citation Abbreviation: EPD TG

2.5.1.6 Source Contribution: Published on web site the list of Drinking

Water System in the State of Georgia.

2.5.1 Source Information

2.5.1.1 Source Citation:  

2.5.1.1.8.1 Originator: Geologic Survey Branch, Environmental

Protection Division, Georgia Department of Resources  

2.5.1.1.8.2 Publication Date: 1976  

2.5.1.1.8.4 Title Geologic Map of Georgia  

2.5.1.1.8.6 Geospatial Data Presentation Form: map  

2.5.1.3 Type of Source Media: paper  

2.5.1.5 Source Citation Abbreviation: SM-3  

2.5.1.6 Source Contribution: Serves as a reference map for locating provinces used in the WHP .  

 

2.5.1 Source Information

2.5.1.1 Source Citation:  

2.5.1.1.8.1 Originator: Geologic Survey Branch, Environmental

Protection Division, Georgia Department

of Natural Resources  

2.5.1.1.8.2 Publication Date: 1992  

2.5.1.1.8.4 Title The Georgia Wellhead Protection  

2.5.1.1.8.6 Geospatial Data Presentation Form: Text  

2.5.1.3 Type of Source Media: paper  

2.5.1.5 Source Citation Abbreviation: GWHP  

2.5.1.6 Source Contribution: Provides the methodology used in  

  Wellhead Protection Plans.  

 

2.5.1 Source Information:

2.5.1.1 Source Citation:

2.5.1.1.8.1 Originator: Alhadeff, S. Jack  

2.5.1.1.8.2 Publication Date: 1996  

2.5.1.1.8.4 Title: County Boundaries of Georgia  

2.5.1.1.8.5 Edition: 1  

  2.5.1.1.8.6 Geospatial Data Presentation Form: GIS Database/Text  

2.5.1.1.8.7 Series Information:

2.5.1.1.8.7.1 Series Name: digital data series  

2.5.1.1.8.8 Publication Information:

2.5.1.1.8.8.1 Publication Place: Atlanta, GA  

2.5.1.1.8.8.2 Publisher: U.S. Geological Survey


2.5.1.1.8.10 Online Linkage: http://csat.gatech.edu/csat/statewide/statewide.html


2.5.1.2 Source Scale Denominator: 100,000  

2.5.1.3 Type of Media: machine-readable files  

2.5.1.5 Source Citation Abbreviation: USGS COUNTY  

2.5.1.6 Source Contribution: used for QA/QC of GSB database  

2.5.2 Process Step: see online documentation, .5.1.1.8.10  

2.5.1 Source Information:

2.5.1.1 Source Citation:

2.5.1.1.8.1 Originator: Musser, Jonathan W.  

2.5.1.1.8.2 Publication Date: 1997  

2.5.1.1.8.4 Title: 7.5 Minute Quadrangle Index for  

2.5.1.1.8.5 Edition: 1  

  2.5.1.1.8.6 Geospatial Data Presentation Form: GIS Database/Text  

2.5.1.1.8.7 Series Information:

2.5.1.1.8.7.1 Series Name: digital data series  

2.5.1.1.8.8 Publication Information:

2.5.1.1.8.8.1 Publication Place: Atlanta, GA  

2.5.1.1.8.8.2 Publisher: U.S. Geological Survey


2.5.1.1.8.10 Online Linkage: http://csat.gatech.edu/csat/statewide/statewide.html


2.5.1.2 Source Scale Denominator: 24,000  

2.5.1.3 Type of Media: machine-readable files  

2.5.1.5 Source Citation Abbreviation: USGS Quad24


2.5.1.6 Source Contribution: used for QA/QC of GSB database  

2.5.2 Process Step: see online documentation, 2.5.1.1.8.10  

2.5.1 Source Information

2.5.1.1 Source Citation:

2.5.1.1.8.1 Originator: Geologic Survey Branch  

  Environmental Protection Division

Georgia Department of Natural Resources  

2.5.1.1.8.2 Publication Date: 1987  

2.5.1.1.8.4 Title: Documentation Report 96-15: Map of Georgia

2.5.1.1.8.6 Geospatial Data

Presentation Form: Map / GIS Database

2.5.1.1.8.8 Publication Information:

2.5.1.1.8.8.1 Publication Place: Atlanta, GA  

2.5.1.1.8.8.2 Publisher: Georgia Department of Natural Resources  

2.5.1.1.8.10 Online Linkage: http://csat.gatech.edu/csat/statewide/statewide.html  

2.5.1.2 Source Scale Denominator: 2,000,000  

2.5.1.3 Type of Source Media: machine-readable files  

2.5.1.5 Source Citation Abbreviation: GSB, DR9613  

2.5.1.6 Source Contribution: developed the Map, GIS database, documentation . The above was used in the QA of the GIS database.  

2.5.2 Process Step: see online documentation, 2.5.1.1.8.10  

2.5.1 Source Information

2.5.1.1 Source Citation:

2.5.1.1.8.1 Originator: United States Department of Agriculture, Service, Southern Region,  

2.5.1.1.8.2 Publication Date: Hourly (06:00 - 20:00 via Web site)  

2.5.1.1.8.4 Title: Atlanta, Georgia G PS Base Station

2.5.1.1.8.6 Geospatial Data

Presentation Form: Trimble .SSF format computer files  

2.5.1.1.8.8 Publication Information:

2.5.1.1.8.8.1 Publication Place: Atlanta, GA (via web site)  

2.5.1.1.8.8.2 Publisher: USDA Forest Service, Southern Region

2.5.1.1.8.10 Online Linkage:

2.5.1.3 Type of Source Media: online machine-readable files  

2.5.1.5 Source Citation Abbreviation: USF S GPS

2.5.1.6 Source Contribution: Publish Trimble.SSF format data for in differential correction to GPS  

2.5.2 Process Step: see online documentation, 2.5.1.1.8.10  

 

2.5.1 Source Information

2.5.1.1 Source Citation:

2.5.1.1.8.1 Originator: Georgia Department of Community Affairs  

2.5.1.1.8.2 Publication Date: Hourly ( BBS)  

2.5.1.1.8.4 Title: Floyd’s Fine Differentials  

2.5.1.1.8.6 Geospatial Data Presentation Form: Trimble .SSF format files  

2.5.1.1.8.8 Publication Information:

2.5.1.1.8.8.1 Publication Place: Atlanta, GA (via Bulletin Board Service)  

2.5.1.1.8.8.2 Publisher: Georgia Department of Community Affairs  

2.5.1.1.8.10 Online Linkage: none

2.5.1.3 Type of Source Media: electronic Bulletin Board Service files  

2.5.1.5 Source Citation Abbreviation: DCA GPS  

2.5.1.6 Source Contribution: Publish Trimble.SSF format data for in differential correction to GPS . Service no longer available.  

 

2.5.1 Source Information

2.5.1.1 Source Citation:

2.5.1.1.8.1 Originator: Geologic Survey Branch  

  Environmental Protection Division

Georgia Department of Natural Resources  

2.5.1.1.8.2 Publication Date: 1999  

2.5.1.1.8.4 Title: Data from Georgia's Wellhead Protection Completed Through December   1998

2.5.1.1.8.6 Geospatial Data

Presentation Form: GIS Database

2.5.1.1.8.8 Publication Information:

2.5.1.1.8.8.1 Publication Place: Atlanta, GA  

2.5.1.1.8.8.2 Publisher: Georgia Department of Natural Resources  

2.5.1.1.8.10 Online Linkage:

  Geographic Information Systems GIS Databases and Documentation  

2.5.1.2 Source Scale Denominator: 24,000  

2.5.1.3 Type of Source Media: machine-readable files  

2.5.1.5 Source Citation Abbreviation: GSB  

2.5.1.6 Source Contribution: developed the GIS database, , and which the 1999 was merged with to create the GIS database.  

 

2.5.1 Source Information

2.5.1.1 Source Citation:

2.5.1.1.8.1 Originator: Geologic Survey Branch  

 

  Environmental Protection Division

Georgia Department of Natural Resources  

2.5.1.1.8.2 Publication Date: 1999  

2.5.1.1.8.4 Title: Data from Georgia's Wellhead Protection Completed Through December   1999  

2.5.1.1.8.6 Geospatial Data

Presentation Form: GIS Database  

2.5.1.2 Source Scale Denominator: 24,000  

2.5.1.3 Type of Source Media: machine-readable files  

2.5.1.5 Source Citation Abbreviation: GSB

2.5.1.6 Source Contribution: developed the GIS database  

2.5.2 Process Step:

2.5.2.1 Process Description:

Basic Information Research Procedures

Before preparing a municipal water system WHP Plan, the GSB associates information from various sources.

The initial water system information is gathered from EPD’s Drinking Water and Engineering Program data files [DWPP], and consists of: 1) the

name of the water system (SYSTEM_NAM); 2) the water system’s id ; 3) the number of permitted wells; 4) the name of the county in the permit is issued (COUNTY); 5) the pump rate of each well ; 6) the size of the population being served by the water system ; 7) the drilling log for each water well; and 8) the records for each well.

The physiographic province (PHYS_PROV) for each well is obtained by at the Geologic Map of Georgia, [SM-3] which was prepared in 1976 the Georgia Geological Survey at a scale of 1:500,000. The aquifer for each well is identified by referring to the drilling logs and for each well, and then verified with the list in The Georgia Protection Plan, Appendix E: Georgia Community Water Systems with Water Sources Population Data [GWHP] prepared in 1992 by the Geologic Survey.

The GSB associates use a preliminary wellhead location derived from a USGS quadrangle (QUADRANGLE) to map out the Control Zone , Inner Management Zone (IMZ), and Outer Management Zone (OMZ).

They calculate the Control Zone (CZR) as a circular area with a radius of 15 from the wellhead when the well is surrounded by impermeable pavement building, or they calculate the Control Zone as a circular area with a radius 25 feet from the borehole for wells surrounded by permeable surfaces.

The GSB associate uses the physiographic province and aquifer type to which method to use to calculate the inner and outer management

zones. The Inner Management Zone is calculated either as a circle with radius either 100 feet for completely confined aquifer wells; 250 feet for unconfined partially confined Coastal Plain or Piedmont aquifer wells; or 500 feet for karst aquifer wells and springs.

For unconfined aquifer wells drilled into fractured crystalline rocks the Outer Zone is calculated as a circle with a radius that depends on the rate of the well. The higher the pumping rate, the larger the radius. modified Heath Method   (GWHP) is used as described in The Georgia Protection Plan, Appendix G: North Carolina Wellhead Protection Applications Manual . In the case of a completely confined aquifer well, Outer Management Zone is not required and a value of “NOT APP” is to the OMZ field. For unconfined wells in the Coastal Plain, a flow calculation as described in Guidelines for Delineation of Protection Areas, pg. 4-4 published by EPA in 1987 is used to the radius of the circle delimiting the Outer Management Zone. See ’s Web site,      

For wells drawing from karst aquifers, the Outer Management Zone has not been determined. For these cases, a value of “NYD” is assigned to the field.

Field Information Procedures

At each water system, the GSB associates collect the latitude and longitude of well head location using a Trimble Navigation Basic Plus GPS receiver. In cases where the GPS receiver was not available the GSB associates used the preliminary latitude and longitude calculated from quadrangle maps.

The GSB associate records the information regarding the water system and the pollution sources into field notes. They obtain the well number

(WELL_NO) from the system operator. The GSB associates verify whether well is surrounded by impermeable pavement or a building. The GSB

associates then note the presence of potential pollution sources within the zones. Potential pollution sources noted when present are roads

(ROADS); vehicle parking lots (VEHICLE_PA); utility poles (UTILITY_PO); power transformers (TRANSFORME); underground storage tanks ; above ground storage tanks (AST); septic tanks (SEPTIC_TAN); septic fields (SEPTIC_DRA); waste treatment facility (WASTE_TREA);

debris piles, old tires, or junked cars (DEBRIS); agriculture fields or (FARMING); irrigated fields (IRRIGATION); animal enclosures ; heavy machinery storage (MACHINERY); small businesses (SMALL_BUSI); industrial complexes (INDUSTRY);

agricultural waste impoundments (AGRICULTUR); industrial waste disposal

impoundments (WASTE_DISP); demolition (DEMOLITION) or industrial

waste(INDUSTRIAL) landfills; quarries or mines (QUARRY_AND); and waste sites (HAZARDOUS). Other potential pollution sources or miscellaneous comments are noted as comments (COMMENTS).

Data Handling Procedures and Reporting

The GSB associates download the data files from the GPS receiver into a PC.

Base station data for post-processing differential correction were obtained

either from the Georgia Department of Community Affairs Trimble

base station (DCA GPS) or from the US Department of Agriculture, Forest GPS base station ( USFS GPS). The DCA GPS Trimble base station is atop the “Sloppy” Floyd Building, East Tower, in downtown Atlanta, and the base station data were downloaded into a personal computer a modem from a telephone dial-in computer bulletin board. The USF S Trimble base station is located on top of the Southern Region Office at Peachtree Rd., Atlanta Georgia. The base station data is available and via the Internet .

GSB associates use Trimble Navigation's PATHFINDER software following standard processing procedures described in Trimble PATHFINDER Users published by Trimble Navigation in 1992. The differentially corrected (LATITUDE) (LONGITUDE) coordinates and the datum 83 is recorded in field logbooks. In the cases where GPS was not used, latitude, longitude, and datum 27 from the topographic map are recorded the field logbooks. In the field logbooks, the associate indicates which (SOURCE) was used to calculate the latitude and longitude.

The GSB associate then uses the data to develop the Wellhead Protection . Once the WHP Plan is reviewed and approved, the year in which the Plan was completed is noted (YR_APP). Data from the plans are input into a Quattro Pro spreadsheet.

A GSB associate then performs random spot checking to verify the data entry the Quattro Pro spreadsheet by comparing the spreadsheet information with WHP Plan information.

The spreadsheet is then delivered to a GIS associate to be processed into a GIS .  

 

  GIS Procedures  

 

             

 

  The pre 1999 data was reprocessed into a new GIS master-dBase file with all (SOURCE) GPS data having a datum of NAD 83 in the (DATUM) column then an updated pre 1999 GIS database was created using ARC/INFO 8.0.1) software by the program dbf2cover, http://www.epa.gov/r10earth/dbf2info.html , written by the EPA . The program a dBase file directly into a GIS database/coverage and in this case well site is represented digitally as a point.

Format: dbf2cover dBASE.file coverage.name x-coord y-coord projection

ARC: &r dbf2cover whp_update_98d.dbf whp_update_98d longitude 83dms.alb  

 

  Any change in the datum will result in a positional shift, therefore, only a series test were completed to determine any affects on the positional dependent .

1. Compared the county name that is listed in each record in the pre 1999 to the name of the county where the well coordinates’ position , (USGS COUNTY .) Five inconsistencies in the county were found and are the result of the county information derived from the location of the water plant rather than the of the well, and occurs when the water systems are close to the line.

  2. Compared the quadrangle named for each record in the pre 1999 to the name of the quadrangle (USGS QUAD24) to which the coordinates’ position plotted.

  3. Compared the Physiographic Province, that is identified in each in the pre 1999 database , where the well coordinates’ position fell the Physiographic Province GIS information, (GSB DR9615 .)

 

The 1999 data - The 1999 WHP QuattroPro spreadsheet was delivered to the

GIS processor on a data diskette. On a PC the spreadsheet file was opened in

Quattro Pro and then saved as a DBASE IV file. The DBASE file was

transferred to a NT workstation utilizing the file transfer protocol (ftp) . The dBase file was processed in ARC/INFO (version 8.0.1)

software by the program dbf2cover and each well site is represented digitally as point.

  Command: dbf2cover  

Format:   dbf2cover dBASE.file coverage.name x-coord y-coord projection  

ARC: &r dbf2cover whp99d.dbf whp99d longitude latitude 83dms.alb  

Once the coverage was generated, a series of data comparison studies were

 

1. Visually compared the embedded county fips code, which is a part of the number, to the county name listed for each record in the 1999 database to a standard county/fips code list. No errors were noted.


2. Compared the county name that is listed in each record in the 1999 database the name of the county where the well coordinates’ position plotted , (USGS .) No discrepancy were noted .


3. Compared the quadrangle named for each record in the 1999 database to the of the quadrangle (USGS Quad24) to which the well coordinates’ position . Four discrepancies were found and corrected. Two quadrangle names were named in the database were changed to the corrected quadrangle based on each well’s coordinates. For the other two entries the latitudes corrected because there were transposition errors made when copying the from the Wellhead Plans into the Quattro Pro spreadsheet. The name s for these two data records are now based on the corrected .

4. Compared the Physiographic Province that is identified in each record in the database to the Physiographic Province GIS database, (GSB DR9615.) No were noted.

5. Compared the Wellhead Protection Data (1999) to the information at Drinking Water Permitting and Compliance - Drinking Water Systems data EPD’s web site, Technical , ( EPD TG).

A. Compared the “Permit” data v.s. “WSID” data, the information with each other. No discrepancies were noted.


B. Compared “County” data v.s. “County_N” data, the information with each other. No discrepancies were noted.

After verifying that the 1999 wellhead protection plans GIS information is , the coverage was converted into a dBASE file, using the ARC/INFO

command : INFODBASE. This dBASE file was altered to the format of a file and then it was merged with the wellhead protection data Master file the WHP Plans made as of December 1998 to create the Master dBASE file of 1999, WHPMSTR99.dbf. With this master file a final Wellhead Protection Plans as December 1999 GIS , DR0013 , was made with the command: DBF2COVER.

3.0 Spatial Data Organization Information :  

3.1 Indirect Spatial Reference Method : dms, county, Quadrangle  

3.2 Direct Spatial Reference Method : point  

3.3 Point and Vector Object Information :

3.3.1 SDTS Terms Description:

3.3.1.1 Object Type: Label point  

3.3.1.2 Object Count: 911  

 

4.0 Spatial Reference Information :  

 

4.1 Horizontal Coordinate System Definition :

4.1.2 Planar:

4.1.2.1 Map Projection:

4.1.2.1.2 Map Projection Name: Albers-Ga Conic Equal Area  

4.1.2.1.2.1.a Standard Parallel: 29 30 00  

4.1.2.1.2.1.b Standard Parallel: 45 30 00  

4.1.2.1.2.2 Longitude of Central Meridian: -083 30 00  

4.1.2.1.2.3 Latitude of Projection Origin: 23 00 00  

4.1.2.1.2.4 False Easting: 0.000  

4.1.2.1.2.5 False Northing: 0.000  

 

4.1.2.4 Planar Coordinate Information:

4.1.2.4.1 Planar Coordinate Encoding Method: Coordinate pair  

4.1.2.4.4 Planar Distance Units: Meters  

 

4.1.4. Geodetic Model:

4.1.4.1 Horizontal Datum Name: North American Datum of 1927  

4.1.4.2 Ellipsoid Name: Clarke 1866  

4.1.4.3 Semi-major Axis: 6378206.4  

4.1.4.4 Denominator of Flattening Ratio: 294.98  

4.2 Vertical Coordinate System Definition : None  

 

5.0 Entity and Attribute Information :

5.1 Detailed Description  

When the Quattro Pro spreadsheet file was converted into a dBase file, the

Field (column) name was truncated to 10 characters in length, so some of the labels may seem cryptic. The attribute labels are explained in detail .  

5.1.1 Entity Type

5.1.1.1 Entity Type Label : DR0013.PAT  

5.1.1.2 Entity Type Definition: Point attribute table.  

 

5.1.2 Attribute:

5.1.2.1 Attribute Label: AREA  

5.1.2.2 Attribute Definition: Area of each polygon, measured in units.  

5.1.2.3 Attribute Definition Source: Understanding GIS - The Arc/Info , by ESRI, pg. 5-9 .  

5.1.2.4 Attribute Domain Value: 4 characters, floating-point binary number; 0 value a point coverage.  

 

5.1.2.1 Attribute Label: PERIMETER  

5.1.2.2 Attribute Definition: Length of each polygon boundary, in coverage units.  

5.1.2.3 Attribute Definition Source: Understanding GIS - The Arc/Info , by ESRI, pg. 5-9 .  

5.1.2.4 Attribute Domain Value: 4 characters, floating-point binary number;   0 value a point coverage.  

   

5.1.2.1 Attribute Label: DR0013#  

5.1.2.2 Attribute Definition: An internal point number assigned ARC/INFO.  

5.1.2.3 Attribute Definition Source: Understanding GIS - The Arc/Info , by ESRI, pg. 5-9 .  

5.1.2.4 Attribute Domain Value: 4 characters, binary number .

 

5.1.2.1 Attribute Label: DR0013-ID  

5.1.2.2 Attribute Definition: User-id (assigned by the user)  

5.1.2.3 Attribute Definition Source: Understanding GIS - The Arc/Info , by ESRI, pg. 5-9 .  

5.1.2.4 Attribute Domain Value: 4 characters, binary number  

 

5.1.2.1 Attribute Label: RECORD  

5.1.2.2 Attribute Definition: A unique number used to identify a well record in the database. as the line number in the Pro spreadsheet.  

5.1.2.4 Attribute Domain Value: 4 Integer.

5.1.2.1 Attribute Label: PERMIT  

5.1.2.2 Attribute Definition: Permitted Water System number (WSID) by DWPP. The first 3 figures of the ID number are of Georgia county FIPS and the last 4 figures are the given to water systems in a . This number is not the as the water withdrawal number.  

5.1.2.4 Attribute Domain Value: 9 characters, text.  

5.1.2.4.1 Enumerated Domain: FIPS-Code  

5.1.2.4.1.1 Enumerated Domain Value:

First 3 characters, (001 thru 321)  

5.1.2.4.1.2 Enumerated Domain Value Definition:

  Country identification code; standards approved use by US government agencies, Federal Processing Standard, (FIPS.)  

5.1.2.4.1 Enumerated Domain: Numerical designation for

a municipal water systems.  

5.1.2.4.1.1 Enumerated Domain Value:

Last 4   characters, (0001 thru 9999)  

5.1.2.4.1.2 Enumerated Domain Value Definition:

municipal water system identification number.  

 

5.1.2.1 Attribute Label: COUNTY  

5.1.2.2 Attribute Definition: County where the municipal water is permitted  

5.1.2.4 Attribute Domain Value: 13 characters, text.  

 

5.1.2.1 Attribute Label: SYSTEM_NAM  

5.1.2.2 Attribute Definition: Water System Name or Owner .  

5.1.2.4 Attribute Domain Value: 39 characters, text.  

 

5.1.2.1 Attribute Label: WELL_NO  

5.1.2.2 Attribute Definition: The well number or spring's name or number by GSB. Ranges in value 0 to 302. This number is not same as the WRB's "source nor is it the always the number as listed on the water permit.  

5.1.2.4 Attribute Domain Value: 13 characters, text.  

 

5.1.2.1 Attribute Label: POPULATION  

5.1.2.2 Attribute Definition: The number of people being served the entire water system.  

5.1.2.4 Attribute Domain Value: 9 characters, text.  

 

 

 

 

5.1.2.1 Attribute Label: QUADRANGLE  

5.1.2.2 Attribute Definition: Name of the USGS 7.5 minute map where the well   or is located.  

5.1.2.4 Attribute Domain Value: 19 characters, Text.  

5.1.2.1 Attribute Label: PHYS_PROV  

5.1.2.2 Attribute Definition: The Physiographic Province where well or spring is located.  

5.1.2.4 Attribute Domain Value: 14 characters, Text.

5.1.2.4.1.1 Enumerated Domain Value: Coastal Plain  

<