Hydrologists Use ArcView to Monitor Statewide Water Use
Suzanne O. White and Joffre E. Castro
ABSTRACT
South Carolina has experienced several droughts during the past decade. The ability to survey and monitor water use across the State has become necessary. Using an existing water use database, an end-user application was developed to query ground water and surface water users separately. Water use can easily and interactively be totaled by county boundaries, watershed boundaries, water use type, or any combination of these conditions. The application, additionally, creates output maps from the result of the queries. Hydrologists and decision-makers can use this information to evaluate the status of water resources and then provide sound management recommendations.
INTRODUCTION
South Carolina, during the last century, has enjoyed an abundant supply of water that has adequately met the State’s water demands. In recent decades, however, demand has increased in response to strong regional economic development. The water supply sources have been adversely affected by more frequent and persistent droughts. The management of the State’s water resources has received, consequently, a great deal of attention and scrutiny. The use of a geographic information system (GIS) has been a major aid in a successful implementation and evaluation of new management strategies.
Drought management decisions are made on the basis of hydrological, meteorological, and water demand information. Hydrological and meteorological data are constantly monitored by gauging stations while water use information is not. In order to provide timely information to water resources managers, an interactive GIS application was developed using ArcView software. Using this application, valuable water use data are quickly displayed on a map of South Carolina showing pertinent information such as, but not limited to, geographical location, user name and phone number, and daily water use.
WATER USE DATABASE
To prepare a comprehensive database of water users in South Carolina, information from several sources had to be compiled. Data used for this study were obtained from the South Carolina Departments of Health and Environmental Control (DHEC), Commerce (DOC), and Natural Resources (DNR).
Six databases with water use and related information were obtained from DHEC:
a) WSINV.DBF, South Carolina Public-Drinking Water Inventory, is a compilation of public supply systems.
b) METER.DBF, Meter Systems, is a listing of public supply facilities that purchase water from other systems.
c) CU_MONIT.DBF, Capacity Use Monitoring, is a compilation of ground water users in the two Capacity Use Areas: Low Country and Waccamaw.
d) CAPUSE.DBF is a support file for the CU_MONIT.DBF that contains general information on users in the capacity use areas.
e) WU_MONIT.DBF, Water Use Program, is a record of users that pump more than 100,000 gallons per day.
f) WATERUSE.DBF is a support file for the WU_MONIT.DBF that contains basic information on the Water Use Program users.
Two databases with geographic information on selected public supply systems were obtained from DOC:
g) WATDAT.DBF has attribute data associated with public-supply service areas.
h) COVERAGE ARC/INFO has service-area coverage for public supply systems by Council of Government (COG) region.
One database with information on water wells was obtained from DNR:
i) WELLTAB.DBF is an inventory of water wells in South Carolina.
These databases were compiled and used to compute an average usage of water, in million gallons per day (MGD), and to identify location of sources, types of use, and distribution of water use. To facilitate the presentation of information, the database was divided into surface water and ground water. ArcView shapefiles were created containing the water intake locations for surface water and ground water. All databases were subjected to a limited quality-control check. Filters were run on the data to isolate gross errors. In many cases the records from one database were cross-correlated with the other databases to verify the information, mostly regarding location and use type. In a few cases, errors were corrected by contacting users; and several records were deleted because the data were unusable, for example, the reported usage was zero. Overall, the best source of information was the WSINV file and the worst was the WU_MONIT file. A reason for the difference in data quality may be that information for the WSINV comes from a program that is mandatory whereas information for the WU_MONIT comes from a program that is voluntary.
Past and Present Water Use
A summary of the water use in South Carolina for 1950-1996 is presented in Table 1. The information from 1950 through 1991 was obtained from the previously mentioned reports and from 1992 through 1996 from DHEC files. In this table and in the report the following convention has been followed:
PS, public supply, includes water that is used mostly for drinking and household uses, although a considerable percentage may also be used for industrial and commercial purposes.
IND, industrial, includes systems that use water for industrial and commercial purposes and are self-supplied.
OTH, other purposes, includes golf-course (GC) and crop irrigation (IR), mining (MI), and most other types of water use not covered in this classification.
Power, includes systems that use water for the production of energy, such as hydroelectric power (HP), nuclear power (NP), and thermal power (TP). Although NP is a type of TP, it has been listed separately to emphasis its importance. Nearly all of the water withdrawn for these types of uses is returned to the source.
For simplicity, the amounts given in tables have been reported in million gallons per day and were rounded upward. Table 1 shows that during the mid-1950's and the 1980's there was a decrease in water use for HP. During those years, South Carolina underwent prolonged drought, which in some months became severe. This illustrates the dependency that hydropower production has on surface water availability. Another interesting point is the decrease of IND usage after 1989, when the Savannah River Site shut down its nuclear reactors.
From 1994 to 1996, the total water use in South Carolina ranged from 59 to 68 billion gallons per day. More than 98 percent of that total was used for power generation, most of which was returned to the source, a small fraction being lost to evaporation. The remaining 2 percent, approximately 1.1 billion gallons per day, were used mostly for public supply and industrial purposes. By comparison, the aggregate daily flow of the rivers in South Carolina averages 33 billion gallons (SCWRC, 1993), which shows that, in South Carolina, surface water is used, on average, almost two times before it flows into the ocean; for the nation, the average is three times. This suggests that South Carolina could be more efficient in the utilization of its water resources.
TABLE 1. Water Use in South Carolina 1950-1996
(Millions of gallons per day)
YEAR |
NON-POWER GENERATION |
POWER GENERATION |
|||||
PS |
IND |
OTH |
TOTAL |
TP+NP |
HP |
TOTAL |
|
1950 |
100 |
70 |
10 |
180 |
-- |
44,500 |
44,500 |
1955 |
150 |
170 |
30 |
350 |
400 |
29,000 |
29,400 |
1960 |
190 |
140 |
50 |
380 |
600 |
62,000 |
62,600 |
1965 |
260 |
240 |
30 |
530 |
1,000 |
60,000 |
61,000 |
1970 |
300 |
350 |
30 |
680 |
2,600 |
41,000 |
43,600 |
1975 |
320 |
350 |
30 |
700 |
5,800 |
-- |
--- |
1976 |
370 |
440 |
-- |
810 |
4,400 |
-- |
--- |
1980 |
380 |
910 |
70 |
1,360 |
4,400 |
-- |
--- |
1983 |
340 |
1,100 |
40 |
1,480 |
5,000 |
48,100 |
53,100 |
1984 |
340 |
1,110 |
40 |
1,490 |
4,700 |
57,400 |
62,100 |
1985 |
330 |
1,080 |
30 |
1,440 |
5,300 |
40,500 |
45,800 |
1986 |
400 |
1,200 |
70 |
1,670 |
4,400 |
39,300 |
43,700 |
1987 |
250 |
1,200 |
60 |
1,510 |
4,300 |
52,900 |
57,200 |
1988 |
300 |
1,110 |
70 |
1,480 |
4,600 |
39,000 |
43,600 |
1989 |
330 |
640 |
30 |
1,000 |
4,900 |
60,400 |
65,300 |
1990 |
350 |
630 |
60 |
1,040 |
4,800 |
60,000 |
64,800 |
1991 |
400 |
740 |
40 |
1,180 |
4,300 |
57,900 |
62,200 |
1992 |
430 |
710 |
60 |
1,200 |
4,300 |
59,300 |
63,600 |
1993 |
460 |
630 |
80 |
1,170 |
4,600 |
52,600 |
57,200 |
1994 |
480 |
580 |
80 |
1,140 |
4,600 |
53,800 |
58,400 |
1995 |
510 |
560 |
50 |
1,100 |
4,900 |
62,400 |
67,300 |
1996 |
590 |
570 |
10 |
1,170 |
4,400 |
61,800 |
66,200 |
Distribution and Use
Table 2 provides a breakdown of water use by county. Excluding power generation, public supply and industry are the largest water users in South Carolina (Figure 1). Moreover, a large percentage of the public-supply demand is for industrial purposes. For example, Andrews in Georgetown County used 1.67 MGD for public supply in 1994 and had a per capita use of over 500 gpd/p. This per capita use is nearly three times the State’s average (151 gpd/p), which suggests that two-thirds of the public-supply use in Andrews was for industrial purposes. Thus, forecasting industrial use, which is related to economic growth and development, is critical. This will be accomplished by using a combination of land-use/land-cover and population-density information, which will be explained and discussed in a future report.
TABLE 2. Water use in South Carolina counties, 1994
(millions of gallons per day)
County |
NON-POWER FACILITIES |
POWER FACILITIES |
TOTAL |
||||||
PS |
IND |
DOM |
OTH |
HYDRO |
THERMAL |
NUCLEAR |
NON- POWER |
POWER |
|
Abbeville |
3.07 |
0.43 |
0.60 |
|
3,284 |
|
|
4 |
3,284 |
Aiken* |
21.55 |
79.38 |
1.63 |
1.80 |
|
200 |
|
104 |
200 |
Allendale |
1.68 |
2.38 |
0.22 |
1.44 |
|
|
|
6 |
|
Anderson |
19.42 |
2.84 |
0.50 |
0.11 |
2,933 |
50 |
|
23 |
2,983 |
Bamberg |
1.34 |
|
0.50 |
1.20 |
|
|
|
3 |
|
Barnwell |
2.29 |
|
0.59 |
0.13 |
|
|
|
3 |
|
Beaufort |
19.88 |
0.41 |
0.09 |
4.68 |
|
|
|
25 |
|
Berkeley |
12.61 |
10.92 |
5.72 |
2.27 |
3,253 |
478 |
|
32 |
3,731 |
Calhoun |
0.79 |
97.18 |
0.53 |
0.98 |
|
|
|
99 |
|
Charleston |
59.55 |
39.03 |
0.80 |
1.45 |
|
|
|
101 |
|
Cherokee |
10.34 |
2.15 |
0.72 |
0.19 |
1,910 |
|
|
13 |
1,910 |
Chester |
5.73 |
0.34 |
1.11 |
|
6,563 |
|
|
7 |
6,563 |
Chesterfield |
5.33 |
0.43 |
1.03 |
1.33 |
|
|
|
8 |
|
Clarendon |
1.55 |
|
0.91 |
|
|
|
|
2 |
|
Colleton* |
3.04 |
|
0.45 |
0.31 |
|
4 |
|
4 |
4 |
Darlington |
6.34 |
21.11 |
0.77 |
0.11 |
|
|
8 |
28 |
8 |
Dillon |
4.53 |
2.21 |
0.36 |
0.01 |
|
|
|
7 |
|
Dorchester |
9.80 |
3.25 |
1.65 |
0.02 |
|
|
|
15 |
|
Edgefield* |
2.61 |
|
0.24 |
0.06 |
3,561 |
|
|
3 |
3,561 |
Fairfield |
1.88 |
|
0.59 |
0.25 |
5,823 |
|
664 |
3 |
6,487 |
Florence |
15.29 |
36.12 |
2.95 |
0.56 |
|
|
|
55 |
|
Georgetown* |
6.76 |
35.12 |
0.62 |
4.93 |
|
7 |
|
47 |
7 |
Greenville |
65.64 |
0.42 |
2.84 |
0.73 |
615 |
|
|
70 |
615 |
Greenwood |
14.96 |
0.31 |
1.04 |
0.18 |
1,031 |
|
|
16 |
1,031 |
Hampton |
1.68 |
0.67 |
0.47 |
0.84 |
|
|
|
4 |
|
Horry* |
22.77 |
0.35 |
1.88 |
6.49 |
|
81 |
|
31 |
81 |
Jasper |
1.24 |
|
0.50 |
0.39 |
|
|
|
2 |
|
Kershaw* |
9.05 |
10.06 |
0.57 |
0.25 |
2,986 |
|
|
20 |
2,986 |
Lancaster |
12.76 |
9.75 |
0.54 |
|
2,640 |
|
|
23 |
2,640 |
Laurens |
6.84 |
0.06 |
1.05 |
0.12 |
118 |
|
|
8 |
118 |
Lee |
1.09 |
1.98 |
0.79 |
|
|
|
|
4 |
|
Lexington |
13.26 |
43.28 |
5.96 |
4.85 |
1,257 |
131 |
|
67 |
1,389 |
Marion |
4.28 |
|
0.49 |
0.28 |
|
|
|
5 |
|
Marlboro |
9.12 |
|
0.55 |
0.02 |
|
|
|
10 |
|
McCormick |
0.77 |
6.55 |
0.07 |
0.29 |
5,621 |
|
|
8 |
5,621 |
Newberry |
4.06 |
0.10 |
0.82 |
|
|
|
|
5 |
|
Oconee* |
8.95 |
1.70 |
0.75 |
0.13 |
2,821 |
|
2,466 |
12 |
5,287 |
Orangeburg |
11.51 |
5.44 |
1.13 |
7.61 |
|
|
|
26 |
|
Pickens* |
11.49 |
1.19 |
1.25 |
0.07 |
3,955 |
|
|
14 |
3,955 |
Richland |
50.93 |
28.12 |
2.24 |
0.49 |
1,687 |
419 |
|
82 |
2,106 |
Saluda |
1.02 |
0.36 |
0.75 |
|
|
|
|
2 |
|
Spartanburg |
39.50 |
5.55 |
2.61 |
0.10 |
148 |
|
|
48 |
148 |
Sumter |
15.24 |
0.59 |
1.89 |
1.59 |
|
|
|
19 |
|
Union* |
7.46 |
3.08 |
0.39 |
|
1,300 |
|
|
11 |
1,300 |
Williamsburg |
3.41 |
2.28 |
1.43 |
0.01 |
|
|
|
7 |
|
York |
18.81 |
84.91 |
2.39 |
0.08 |
2,247 |
|
101 |
106 |
2,348 |
TOTAL |
551 |
540 |
55 |
46 |
53,752 |
1,371 |
3,227 |
1,193 |
58,363 |
Figure 1. Water use in South Carolina by type, 1994-1996.
THE ARCVIEW WATER USE APPLICATION
An ArcView application was developed for hydrologists to monitor water use. A customized interface prompts for a selection between surface water use or ground water use. Next, a view of South Carolina with water intake locations is displayed in ArcView. The water intake shapefile is linked to the water use database using a one-to-many relationship. The average MGD is totaled by intake location. The water intake location table is displayed along with the water use database table.
Water intake locations may be selected and analyzed individually, by type, by county that the location is in (Figure 2), by the county that uses the water (regardless of intake location), or by river basin. The selected records are highlighted and promoted in both tables. Water use is easily totaled based on the selections. The interface provides a button to display only the records selected (Figure 3). Additionally, maps may be generated from the result of the queries. Hydrologists and decision-makers can use this information to evaluate the status of water resources and then provide sound management recommendations.
Figure 2. Selection of surface water intakes within York County.
Figure 3. Surface water intakes located in York County.
SUMMARY AND RECOMMENDATIONS
South Carolina had a reported water use of 59.4 billion gallons per day in 1994, 68.4 in 1995, and 67.4 in 1996. More than 98 percent of the use was for power generation, in which most of the water withdrawn was returned to the original source. Of the remaining, 48 percent was for public supply, 51 percent for industry, and 1 percent for other uses. Except for power generation, the reported water use is believed to be, at best, a low estimate of the actual use.
South Carolina, in 1994, had few sites where use was high (more than 20 MGD), some areas with moderate usage (from 1 to 10 MGD), and most with low use (less than 0.1 MGD). The water use appeared to be concentrated in five regions: (1) the northwest, around Greenville-Spartanburg-Rock Hill; (2) the center, around Aiken-Columbia-Florence; (3) the northeast, around Myrtle Beach-Georgetown; (4) the southeast, around Charleston; and (5) the south, around Beaufort-Hilton Head.
Currently, the ArcView Water Use Application is an efficient tool to examine these existing conditions. The application may be further enhanced with additional data layers and analysis of land use/ land cover, climatological data, and population-density. Models should be developed within in the application to forecast long-term water use availability and demand.
REFERENCES
Water Resources Commission, 1993. South Carolina water use, four year report 1988-1991. South Carolina Water Resources Commission, 16p.
AUTHOR INFORMATION
Suzanne O’Brien White
GIS Analyst
Ogden Environmental and Energy Services, Co., Inc.
3800 Ezell Road
Nashville , TN 37211
(615) 333-0630 phone
(615) 781-0655 fax
Joffre E. Castro, Ph.D.
Senior Hydrologist
South Carolina Department of Natural Resources
1201 Main Street, Suite 1100
Columbia, SC 29201
(803) 737-0800 phone