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

sowhite@oees.com

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

Castro@water.dnr.state.sc.us