SYSTEMS PROGRAMS FOR THE ANALYSIS OF NONURBA.N, NONPOINT SOURCE POLLUTANTS IN THE MISSOURI BASIN REGION Supplement: User's Manual and Computer Program Listing by A. Eugene Vandegrift Shen-yann Chiu Midwest Research Institute 425 Volker Boulevard Kansas City, Missouri 64110 for the Office of Water Programs U.S. Environmental Protection Agency Suite 906, Lincoln Towers 1860 Lincoln Street Denver, Colorado Attn: Mr. Keith Snyder EPA Contract No. 68-01-0159 MRI Project No. 3572-C 3 May 1973 ------- DISCLAIMER This report has been reviewed by the Office of Water Programs and approved for publication. Approval does not signify that the contents necessarily reflect the views and policies of the Office of Water Programs, nor does mention of trade names or commercial products constitute endorsement or recommenda- tion for use. ------- PREFACE This report is a supplement to the Final Report and was prepared for EPA Contract No. 68-01-0159 which was monitored by Mr. Keith Snyder. The report gives a complete listing of the computer programs developed on this contract, as well as the operating instructions for using and updating these programs. The work was conducted in the Environmental Sciences Section of the Physical Sciences Division. The report was written by Dr. A. E. Vandegrift and Dr. S. Y. Chiu with assistance from Mr. Richard Salmon, Mr. Duane Dieckman, and Mr. Evan Stewart. MIDWEST RESEARCH INSTITUTE H. M. Hubbard, Director Physical Sciences Division 3 May 1973 iii ------- No Page iv ------- TABLE OF CONTENTS Page Introduction 1 Developing the Data Banks 3 COUNTY MASTER FILE - County Data Bank 3 STATION MASTER FILE - Watershed Data Bank 4 Data Bank Reports 7 Program Descriptions. ..... 9 Appendix A - Manual Data Card Layout Forms 21 Appendix B - Identification of Data by Source 33 Appendix C - Selected Water Quality Parameters 37 Appendix D - Land Resource Region Codes 43 v ------- INTRODUCTION A program system for the analysis of nonurban, nonpoint source pollutants in the Missouri River Basin was developed at Midwest Research Institute under the sponsorship of the Environmental Protection Agency (Contract No. 68-01-0159). In this program (to date) data related to nonurban, nonpoint source of pollutants were collected, evaluated, compiled, and organized. These data can be used to develop system models that can be used by EPA to assess the impact of nonpoint source pollutants on the pollution of surface water, and to facilitate long-range planning for pollution control. „ Based on the need for the development of system models, we identified the following data categories for this program: water quality, hydrol- ogy, climatology, topography, soil classification, land use, livestock distribution, fertilizer use, and pesticide use. The majority of data needed were available in a computer processible form, such as STORET (water quality and streamflow data), Census of Agriculture (land use and livestock data), Conservation Needs Inventory (land use and soil classification), and NOAA (precipitation data). Other data not avail- able on magnetic tapes were also collected, or estimated, and put into machine readable form. Two major computer files were produced for this program. The COUNTY MASTER FILE has one record for each of the 438 counties in the Missouri River Basin. Records for each county consist of data on land use, fertilizer and pesticide application, soil classification, livestock distribution, topography, and climatology. The STATION MASTER FILE con- tains information unique to an individual station and the watershed which impacts that station. In this file, the station location, the water quality and hydrological data, the area and physical characteristics of the watershed and all information available for counties in the water- shed as recorded in the COUNTY MASTER FILE are compiled. Two hundred thirty three water quality stations were selected in this program. The present file has water quality and hydrological data for 1968, 1969, and 1970, and land use data for 1969. Provisions have been made for updating when new data become available. Complete details on the determination of data needs and data sources, preliminary evaluation of data, compilation of data, conclusions, and our recommendations have been described in the Final Report. This 1 ------- supplement gives a complete listing of computer programs which were used to develop the data files. In the subsequent sections, we present the methods of data organization, methods to update data, and complete description of computer programs developed for this project. 2 ------- DEVELOPING THE DATA BANKS COUNTY MASTER FILE - County Data Bank The County Data Bank is created from four sources. They are as follows: Manually prepared data: The program NPSPGFM1 reads and edits the data prepared manually using the forms in Appendix A, creating magnetic tapes for use by other programs. NPSPGCMl reads the manual data file and creates, from card Types 1 and 2, a skeleton COUNTY MASTER FILE. This program should be used only for originating the COUNTY MASTER FILE. NPSPFPC1 reads the manual data file extracting card Types 8 and 9 and creates a disk work file which is sorted into state and county sequence by NPSPFPC2. The sorted work file from NPSPFRPC2 is read by NPSPFPC3 which updates the COUNTY MASTER FILE for the year 1969. Space is available in the COUNTY MASTER for years 1968, 1970, 1971, and 1972. A minor program change to NPSPFPC1 and NPSPFPC3 will be required if a year other than 1969 is to be updated. NPSPN0A1 reads the manual data file selecting card Type 10 for use in correlating NOAA station numbers to their appropriate state and county. Conservation Needs Inventory (1967); NPSPCNI2 reads the Conservation Needs Inventory files for each state and extracts the data required from each, building a disk work file by state and county. The data extracted are described in Appendix B. The disk work file is sorted into state and county sequence by NPSPCNI3. The sorted disk work file is read by NPSPCNI4 for updating the Conservation Needs Inventory data in the COUNTY MASTER FILE. The Conservation Needs Inventory data are for the year 1967 and because these data do not vary from year to year, no space is allocated for storing additional CNI data. Census of Agriculture (1969): NPSPCOA1 reads the Census of Agriculture files for each county, extracts the required data and creates a tape work file. The data extracted are described in Appendix B. NPSPCOA2 sorts the tape work file into state and county sequence. NPSPC0A3 reads the sorted tape work file and updates the COUNTY MASTER FILE for the year 1969. Space is available in the COUNTY MASTER FILE for the years 1968, 1970, 1971, and 1972. Minor changes to NPSPC0A1 and NPSPC0A3 will be required to update years other than 1969. 3 ------- National Oceanic and Atmospheric Administration (NOAA) 1968 - 1970: NPSPNOA1 reads the NOAA files and the manual data file (card Type 10) and extracts rainfall data by NOAA station and using card Type 10 data, converts the station number into the appropriate state and county. NPSPNOA1 creates a disk work file which is sorted by NPSPN0A2 into state and county sequence. NPSPN0A3 reads the sorted disk file and updates the COUNTY MASTER FILE for the years 1968, 1969, and 1970. Space is available in the COUNTY MASTER FILE for the years 1971 and 1972 when the data become available. Minor program changes to NPSPNOAl and NPSPN0A3 will be required when data for other years are added. STATION MASTER FILE - Watershed Data Bank The watershed data bank receives data from water quality data (STORET), from the completed COUNTY MASTER FILE and from manually prepared data. The description of these sources follows: Manually prepared data (1969): NPSPGSM1 reads the manual data file selecting card Types 3, 4, 5, 6, and 7 (Appendix A) which are written on a disk work file. The disk work file is sorted by NPSPGSM2 into MRI station number sequence. The sorted disk work file is read by NPSPGSM3 as well as card Types 1 and 2 from the manual data file. These two files create the skeleton STATION MASTER FILE with some constant data (described in the NPSPGSMl program writeup). Water quality data (STORET) (1968 - 1970): NPSPSTRl reads a file created by using STORET which contains water quality data (see Appendix C) for all of the USGS and STORET stations in the Missouri River Basin. Card Type 4 is read from the manual data file to provide a means of cor- relating USGS station numbers and STORET station numbers to MRI sta- tion numbers. The mean value and the number of samples for each quarter and year, for each parameter listed in Appendix C, is extracted and written on a disk work file with the appropriate MRI station number. The disk work file is sorted by NPSPSTR2 into MRI station number sequence. The sorted work file is read by NPSPSTR3 and the appropriate data for the years 1968, 1969, and 1970 are merged into the STATION MASTER FILE. Space is available in the STATION MASTER FILE to add data for the years 1971 and 1972. Minor changes to NPSPSTRl and NPSPSTR3 will be required if data for additional years are added. COUNTY MASTER FILE (1969): Updating the STATION MASTER FILE with data from the COUNTY MASTER FILE is a multiphase procedure and caution must 4 ------- be used in allocating county resources to a watershed region (or zone). A county may be wholly contained within a zone or may be split into many zones. Also, some data in the COUNTY MASTER FILE are allocated by a zone/county ratio (e.g., zone area/county area x county data), or a 1:1 ratio (e.g., ground slope). This is accomplished by executing NPSPGAL1 which reads card Types 2 and 5 from the manual data file and creates a disk work file for each card type. NPSPGAL2 sorts the disk work file for card Type 5 into state and county sequence while NPSPGAL3 sorts the disk work file for card Type 2 into state and county sequence. NPSPGAL4 reads the two sorted disk work files and creates a new disk work file adding the zone areas from the sum of the area field in the Type 5 card to the data already in both files. This new disk work file is sorted by NPSPGAL5 into MRI station number sequence. NPSPGAL6 reads the sorted work files and accumulates the zone area amounts for all zones assigned to a station to arrive at a station area (watershed) value. The records which have a station area computed are written onto another disk work file. NPSPGAL7 reads this disk work file and sorts it into state and county sequence and writes it on a magnetic tape which is the allocation file. The allocation file and the completed COUNTY MASTER FILE are read by NPSPCALl which matches on state and county and allocates the county data by the zone/county ratio, or 1:1 depending on the type of data. NPSPCALl then creates a Zone Master File on magnetic tape. NPSPCTS1 sorts the Zone Master File into MRI station number sequence. NPSPCTS2 reads the sorted Zone Master File and accumulates all like zones (same MRI station number) writing a disk work file with only one record for each MRI station number. NPSPCTS3 reads the disk work file and updates the STATION MASTER FILE with the county/zone data we have computed. These steps will need to be repeated every time a change is made to the COUNTY MASTER FILE to insure that the appropriate data in the STATION MASTER are also updated. 5 ------- No Page 6 ------- DATA BANK REPORTS When both data banks (COUNTY MASTER FILE and STATION MASTER FILE) are complete the contents of each may be printed by using the program NPSPCTYD for the COUNTY MASTER and NPSPSTMD for the STATION MASTER. Figure 1 shows an overall system flowchart which represents the logical sequence of events that take place in creating and maintaining the data banks. Exact operational instructions will vary depending on the type of computer system used. All programs are written in COBOL and should be easily adaptable to any computer system. 7 ------- Generote County Master NPSPGCM NOAA NP5PNOA N PS PC OA Census Of Agriculture Conservation Needs Inventory NPSPCNI Fert 111 zer- Pest Control NPSPFPC Print County Report NPSPCTYD Generote County To Station Allocation NPSPGAL Allocation Allocate County To Zones NPSPCAL Generote Station Master NPSPGSM Station Master STORET NPSPSTR Merge Zones With Stations NPSPCTS Print Station Report NPSPSTMD Figure 1 - System Flow Chart 8 ------- PROGRAM DESCRIPTIONS Brief discussions for each program are given in the following paragraphs and the printouts for each program are presented in Appendix E, which is a separate accompanying document. NPSPGMF1: This program will read the various cards created manually and write them onto a magnetic tape. This provides data to the STATION MASTER FILE and the COUNTY MASTER FILE that are not available from other sources. The only purpose is so that all card input for the sys- tem will be from a central file in an easily accessible form. There arc 10 different input forms, they are defined as follow: Form Number Description 1. State Name and State Number 2. County Data a. State and county codes b. Maximum 30-min rainfall. c. Soil type d. County area e. County name 3. Station Location and Identification a. MRI station number b. State and county code c. Latitude of station d. Longitude of station e. Stream name f. Location 4. Station Cross Reference List a. MRI station number b. STORET station number c. STORET agency number d. GWDC water-quality station number 9 ------- Form Number e. OWDC surface water station f. USGS station number g. USGS agency number 5. Zone Within Watershed Definition a. MRI station number b. County - (Up to 100 entries) 1. State and county code 2. County area 3. County - distance to station 6. Hydrological Sequence a. MRI station number b. Downstream MRI station number c. Mileage to downstream station 7. Zone Slope and Soil Characteristics a. MRI station number b. Main channel slope c. Soil infiltration rate d. Soil erosion factor e. Map number and location 8. Applied Fertilizer by County by Half Year a. State and county code b. Half year code c. Total nitrogen d. Total e. Total K2O 9. Pesticide Data a. State and county code b. Insecticide c. Herbicides d. Fungicides 10. NOAA Station-State County Cross Reference a. State and county code b. NOAA stations (up to 30) LO ------- NPSPGAL1: This program reads the tape created in NPSPGMF1 and extracts the data Types 2 and 5 onto intermediate data files for sorting. The sorted files will be used by NPSPGAL4 for county allocation data. NPSPGAL2 will sort Type 5 records and NPSPGAL3 will sort Type 2 records. NPSPGSMl: This program reads the tape created in NPSPGMF1 and extracts the data Types 3, 4, 5, 6, and 7 onto intermediate data files for sort- ing. The sorted files are used by NPSPGSM3 in the creation of the STATION MASTER FILE. NPSPGSM2 sorts the selected records into station sequence. NPSPGCM1: This program reads the tape created in NPSPGMF1 and selects data Types 1 and 2 for the creation of the COUNTY MASTER FILE. NPSPFPC1: This program reads the tape created in NPSPGMF1 and extracts the data Type 8 onto an intermediate data file for sorting. The sorted file is based in NPSPFPC3 to add the fertilizer data into the COUNTY MASTER FILE. NPSPFPC2 sorts the selected records into state and county sequence. NPSPCOAl: This program reads the Census of Agriculture tape (1969) and selects the following data which will be sorted by NPSPC0A2 for inclusion onto the COUNTY MASTER FILE in NPSPC0A3: 1. State 2. County 3. Data year 4. Land area 5. Total crop area 6. Pasture grazing -7. Woodlands 8. Irrigated 9. Total cattle 10. Total hogs 11 ------- 11. Corn 12. Sorghum 13. Hay 14. Cotton 15. Peanuts 16. Tobacco 17. Potatoes 18. Sheep 19. Horses 20. Total chickens 21. Chicken houses 22. Chickens in houses 23. Wheat 24. Other grain 25. Soybeans 26. Greenhouses 27. Vegetables 28. Berries 29. Orchards 30. Other crops 31. Cattle feedlots 12 ------- 32. Cattle in feedlots 33. Hog lots 34. Hogs in lots 35. Lime NPSPCNI2: This program reads the Conservation Needs Inventory file sorted by NPSPCNI2 and selects the following data which will be sorted by NPSPCNI3 for inclusion in the COUNTY MASTER FILE in NPSPCNI4. 1. Land resource area 2. Land resource region 3. Soil name 4. Watershed 5. Soil classes I 6. Slope percent class 7. Soil erosion class NPSPN0A1: This program reads the NOAA tape and selects the following data which will be sorted by NPSPN0A2 and added to the COUNTY MASTER in NPSPN0A3: Precipitation data for each season and the yearly total for the years 1968, 1969, and 1970. NPSPSTRl: This program will read a print image tape created by STORET and reformats the data onto an intermediate data file for sorting by NPSPSTR2. The sorted file will be read by NPSPSTR3 for updating the STATION MASTER FILE. The data will be selected from the STORET print image tape as described in Appendix C. NPSPCOA3: This program reads the file created by NPSPCOA1, sorted by NPSPC0A2, and updates the COUNTY MASTER FILE. The fields specified under NPSPCOA1 are the only fields affected. The data reported on the Census of Agriculture file in acres were converted to square miles in NPSPC0A1. 13 ------- NPSPCNI4: This program reads the files created in NPSPCNI2, sorted by NPSPCNI3, and updates the COUNTY MASTER FILE with the apposite data. The data fields affected are defined in NPSPCNI2. An error report will be printed reflecting CNI data for counties which do not exist on the COUNTY MASTER FILE. NPSPGAL4: This program reads the files created by NPSPGAL1, sorted by NPSPGAL2, NPSPGAL3, and allocates county area, county area for the sta- tion and percent of county area for the station and writes the alloca- tion data onto a magnetic tape which is sorted by NPSPGAL5 and used by NPSPGAL6. A report will be written reflecting the data generated with an flagging any fields in error. NPSPGAL6: This program reads the Zone Master created in NPSPGAL4, sorted into station sequence by NPSPGAL5 and accumulates the zone areas in each record. The sum of the zone areas by station will be the station area which will be written into each record. The output file will be a disk file to be sorted by NPSPGAL7 into county, state sequence. NPSPCAL1; This program reads the allocation file created by NPSPGAL6, sorted by NPSPGAL7, and the COUNTY MASTER FILE. The allocation data for each county are used in generating the Zone Master File. An error report is written reflecting: 1. No allocations for county records, and/or 2. No counties for allocation records. NPSPGSM3; This program reads the file created in NPSPGMF1 and the sorted file created by NPSPGSM2, and generates the STATION MASTER FILE. An error report is written for each station which does not have the necessary data. NPSPCTS2: This program reads the Zone Master File created by NPSPCAL1, |sorted by NPSPCTSl, and accumulates the zone records by station and writes the apposite county data to an intermediate data file in NPSPCTS3. . i' NPSPCTS3; This program reads the intermediate file created in NPSPCTS2 and updates the STATION MASTER FILE created in NPSPGSM3. An error re- port is written reflecting data for which a STATION MASTER record does not exist and STATION MASTER records without county data. NPSPN0A3: This program reads the intermediate file created by NPSPN0A1, sorted by NPSPN0A2, and updates the COUNTY MASTER FILE. An error report 14 ------- is written to show records selected for which a COUNTY MASTER record does not exist. NPSPFPC3: This program reads the intermediate file created in NPSPFPC1, sorted by NPSPFPC2, and updates the COUNTY MASTER FILE. An error re- port is written reflecting the data selected for which a COUNTY MASTER record does not exist. NPSPSTR3: This program reads the intermediate file created by NPSPSTR1, sorted by NPSPSTR2, and updates the STATION MASTER FILE. An error re- port is written for the data records for which no STATION MASTER record exists. NPSPSTMD: This program reads the STATION MASTER FILE and creates a re- port for each MRI station in the Missouri River Basin. The report re- flects the pertinent data within the following major categories; 1. Location 2. Land characteristics 3. Land use (acres) 4. Water quality data (averages) 5. Crop data 6. Fertilizer data (tons) and pesticide data (tons) 7. Livestock and poultry 8. Contributing counties (up to 100) The data furnished within each of the above categories are as follows: I 1. Location a. Stream name b. Location c. County d. State e. Latitude f. Longitude g- Downstream station h. Distance to downstream station i. MRI station number 15 ------- j. STORET station and agency number k. USGS station and agency number 1. OWDC WQ station number m. OWDC SW station number n. OWDC sub-subbasin number 0. Total watershed area 2. Land characteristics a. Main channel slope (feet per mile) b. Slope percent class (percentage slope for watershed) c. Soil erosion class d. Soil infiltration (inches per hour) e. Soil index f. Rainfall intensity (inches per 30 min) g. Total precipitation in inches for each season and the year h. Soil capability classes for the eight types 3. Land use (square miles) a. Land area b. Total cropland c. Pasture/grazing d. Woodlands e. Irrigated f. Other land in county g. Harvested cropland h. Other cropland 1. Other farmland j. Land in farms 4. Water quality data (averages) for each season and the year, see Appendix C Crop data (square miles) a. Corn b. Sorghum c. Wheat d. Other grains e. Soybeans f. Hay g. Cotton h. Peanuts 16 ------- i. Tobacco j. Potatoes k. Vegetables 1. Berries m. Orchards n. Other crops o. Greenhouses 6. Fertilizer data (tons) - by half year and pesticide data (tons) - by year a. Total nitrogen b. Total P2O5 c. Total K2O d. Lime e. Herbicides f. Insecticides g. Fungicides 7. Livestock and poultry a. Cattle and calves - total - feedlots - stock in lots b. Hogs - total - hog lots - hogs in lots c. Chickens - total - chicken houses - chickens in houses d. Sheep e. Horses and ponies 8. Contributing counties a.¦ Each county that shares in the watershed of this station will be listed showing the total county area, the county area in this station, percent of this county area to station area and the distance to the station. NPSPCTYD: This program reads the COUNTY MASTER FILE and creates a re- port for each county in each state within the Missouri River Basin. The report reflects the pertinent data within the following major categories. 1. Location 2. Land characteristics 17 ------- 3. Land use 4. Crop data 5. Fertilizer data and pesticide data 6. Livestock and poultry The data furnished within each of the above categories are as follows; 1. Location a. County b. State c. Watershed d. Land resource area e. Land resource region (see Appendix D) 2. Land characteristics a. Slope percent class (land slope for county) b. Soil erosion class c. Rainfall intensity (inches per 30 min) d. Total precipitation (all seasons and the year) e. Soil name f. Soil-capability classes 3. Land use (square miles) a. Land area b. Total cropland c. Pasture/grazing d. Woodlands e. Irrigated f. Total farmland g. Other land in county h. Harvested cropland i. Other cropland j. Other farmland 4. Crop data (square miles) a. Corn b. Sorghum c. Wheat 18 ------- d. Other grain e. Soybeans f. Hay 6 • Cotton h. Peanuts i. Tobacco j • Potatoes k. Vegetables 1. Berries m. Orchards n. Other crops o. Greenhouses Fertilizer data (tons) by half year and pesticide data (tons) by year a. Total nitrogen b. Total P2O5 c. Total K2O d. Lime e. Herbicides f. Insecticides g- Fungicides Livestock and poultry a. Cattle and calves - total - feedlots - stock in lots l b. Hogs - total - hog lots - hogs in lots c. Chickens - total - chicken houses - chickens in houses d. Sheep e. Horses and ponies 19 ------- No Page 20 ------- APPENDIX A MANUAL DATA CARD LAYOUT FORMS 21 ------- ro N> joe BT DATE WRiT TEN A3 punch as MRI$ NOTES ptate Code 'lumbers and Kanes eaGE 0r. 3^72-001 FICLD roraririclTio* Data Identification 4 - io r 20 T 51 — 3) State Nana 31-40 41-50 T 51-60 6i-7G T 71-80 DSBQSCefllDBaO^Q&SDBBSIiaHBSSBHB&lDaSBBBBBQaDBBElSBaEDBSOBBQBQBtDHigDSBQSEQtDSSDBBQSSBlDBg: J_L_ ------- ro u> JOB BY DATE w^n m as I 1 PUNCH AS MRI$ oar,E 0r. NOTES County Area, Rainfall, 5oil IVoe ana Same 3572-0.',? HflO OOTIf'CATiOM Data Identification i -10 r 20 r ctate County code o Max 30mn 1 hour rain 2E-LE Soil Tyoe T County Area < 1-50 DB0Q00Q0BSDSBQBEQ0E0HaSEaEBHEEDSEEBSBES3DBHE0EQGM Ci>MPX1kl>ATfikOOZ V I . BOBBBBBBtDBEIlBBBBBBBBBBBBBBBfllDBS) County Naiie 51-60 I 6'-70 71-80 ------- JOB BY DATE WRl N AS PUNCH AS 1 1 MRI® page: . of. NOTES Station Location and Identification 3^72-003 71-80 l-IO 51-60 41- 40 DBBBBBBBBaDBBaBBBBBBDBBBBBaBEEDBEBEBBEBaQBBBBBHBBEDBBBBBBHBBDBBBBBBBBBPBBBBBBBBEl Data Identification MRI ?tation Number State County- Code Latitude Lone Strean flame Location N'ane ------- ro Ui JOB BY PATE WRiTTl a5 1 i PUNCH AS 1 ! i Rig pa OF o<". NOTES Nation Crass 'teference List 3$7?-00lj riCLO mnrincJtt'oa rata -dertificatlon l-10 Mri Station !amber T CTCRKT Station Number Station 21-30 Agency 31-40 r CMDC Water Ouality Station 41-50 CWDC Surface Water Station 51-60 OStnS, Station 6r-70 i Agency +- 71-00 -t Daa3BBE3aBSnaai3BaflElBSDaSQHQH[3BBDBeBBSQE)aaOBBBB@HB0BD§03@SBS0BD0BSB0DBBSD9BO@aB00E i_L. I 1 -M- 4-f h •U- -M- -H-t- ¦i-U J -A J ------- ro j 08 BY PATE WRITTt^l A5 1 1 1 | ; j PUNCH 6S 1 1 i ! 1 | n/IRI® OftGE 0C. NOTES Coo-'ty "ltMn Zone Definition 3572-005 "CCD WTiri&ATiOM Data Identification 1I- I-10 H2l3l4l5l6l7l8l9lolH2l3|4|5 6 2) MRI station Number 7181910] 112131 3-31 5]6 County Cty Ho Area 31 H21314I5 6 ^0 7181910 Dist County fl! SE Ml Cty -50 22 Area TTIT34 _i_L Bist -60 5l6l7j8|9l0 Cour.iy m cty 6»- 3R1 6 7|8|9jO 7 3 4rea 71 -80 3H15I6I7. Dist 8l9]0 _Lx_ ------- J08 BY PATE WRITTEN AS j 1 punch as 1 1 1 NOTES Hydroloeical Sequence 3572-006 MRI® PAGE Or PO -J **Cio mrinutioa Dats Identification MKI Station Number Downs trear Station Number Mileage to Down Station i-io 11- 2 ) ! 1-30 31-40 41-50 51-60 61-70 71-60 U2l3l4]5l6!7l8l9lO 112131415 6 7181910 l|2l3 4 5|6|7]B|9|0 1 z 314|5i6|7|8 9|o I12I3I4151617I819I0 1 |2|3J4]5l6|7i8|9i0 I|213|4I516I718I?I0 1lZ1J|4|5l6l7|8[9t0 ft6toMsrA.57Wj.aafi ' ' ' 1 ' ' 1 1 1 1 . , . . J . . i . . . . 1 1 1 f J 1 i 1 | 1 i 1 1 1 J 1 1 l l i | a » . 1 t i 1.1 i 1 i 1 , 1 i t « f . . | . . . . 1 \ I * 1 / . I 1 ) r 1 1 > 1 I » 1 . i i i i i } / 111 11 i i ¦ i i 1 i i 1 . . . 1 1 I Jill. —l-J 1 1 1 1 L_l 4 l_l_J 1 1 i_l 1 1 L__l_l 1 L. .1 .1. i. L 1 1 1 1 I . . 1 . 1 . b i . ------- to 00 JOB BY DATE WRlTTEN A5 I » PUNCH AS nARI$ pa^E OF. NOTES Zone cloce and Soil Characteristics 3S72-O07 i-10 71-80 IIIBBHBEBtDBaDBBaBBBE]BBDBBBBBBBBHIlBBBBBBBBaDBBBBBBBaBDBB3BBBBBBIlBBBBBBBBSDBBBBBBBBBl Data Identification .•'SI Station Number vain Channel SloDe Soil Infiltra Rate Soil Erode. Factor ------- fo so JOB BY OATE WRITTEN AS Punch as MRI@ PAGE OP. NOTE^ tfoolied Fertilizer by County 3572-00* tltkD caCVTffteATlOB Data Identification t-10 I iT 20 r State County Code -3 s» u Vitropen 31-40 Phosohate 41-50 T cotash 51-60 T T:tal 6>-7CT 71-80 U0BQSSO0BSDS0B6BQ0BanaHE0Bfl0EED9BEE0BESail00Q0EQI30EDB0QBBQ00SI]SBQ00§BBGI190Q00H30E ------- JOB BY DATE WRITTEN A3 PUNCH AS MRI® PAGE (DE- NOTES Acolled °esticide by county 357?-009 nt to tacmricATioH Data Ideitificatio! i-io r T State County Code Cty, Herbicides Insecticides T Fungicides T 11- 20 1-3 J 31-40 41-50 51-60 61-70 71-80 000BBO0B3I10B0e0fl[DB[3DaaEBSBGlEEDHBB00flE0ail0BB00HBBEIlB0a00Q0BEIlB00B0B000119B0BaO00£ ?.P.S,TliCTPC. ¦CHQ.1 u> o ------- JOB Br DATE NOTES -t/}T t £ * i) v c — Cross £o WRITTEN A5 PUNCH AS MRI® PAGE 0r. i, r l v - s < J ncto «c*wc*Tt&* I-<0 I I H2Q r y.CA-4-STAT , .flta C*-«t d * w j_ 36 i i. _LL ------- No Page 32 ------- APPENDIX B IDENTIFICATION OF DATA BY SOURCE 33 ------- Source Manual Data Census of Agriculture (1969) Field Name Description MRI Station Number Card Type 3 OWDC Map and Basin Card Type 7 State and County Card Type 3 State Name Card Type 1 County Name Card Type 2 Latitude and Longitude Card Type 3 Stream Name Card Type 3 Location Name Card Type 3 STORET Station and Agency Card Type 4 OWDC Water-Quality Station Card Type 4 OWDC Surface Water Station Card Type 4 USGS Station and Agency Card Type 4 Downstream Station Card Type 6 Distance to Downstream Station Card Type 6 Main Channel Slope Card Type 7 Soil Infiltration Rate Card Type 7 Soil Index (Erosion Factor) Card Type 7 County Code-Each County in Station Card Type 5 County Total Area - Each County in Station Card Type 5 County Distance to Station - Each County in Station Card Type 5 Rain Intensity Card Type 2 Nitrogen Card Type 8 P205 Card Type 8 K2O Card Type 8 Herbicides Card Type 9 Insecticides Card Type 9 Fungicides Card Type 9 Land Area Total Farmland Total Other Land Total Crop area Pasture Grazing Cropland Harvested Cropland Other Cropland 34 ------- Source Field Name Description Woodlands Irrigated Farmland Other Farmland Corn Sorghum Wheat Other Grain Soybeans Hay Cotton Peanuts Tobacco Potatoes Vegetables Berries Orchards Other Crops Greenhouses Total Cattle Cattle Feedlots Cattle in Feedlots Total Hogs Hog Lots Hogs in Lots Sheep Horses Total Chickens Chicken Houses Chickens in Houses Lime Conservation Needs Inventory (1969) Soil Name Slope Percent Class Erosion Class Soil Class area by class and index Watershed Resource Area Resource Region (codes are listed in Appendix D) STORET Parameter List from Appendix C NOAA (1968, 1969, 1970) Rainfall Amount for quarters and year 35 ------- No Page 36 ------- APPENDIX C SELECTED WATER QUALITY PARAMETERS 37 ------- Code 00010 00011 00060 00070 00075 00095 00300 00301 00310 00335 00400 00500 00505 00510 00515 00520 00525 00530 00535 00540 00545 00600 00605 00610 00615 00620 00630 00635 00650 00655 00660 00665 00666 00667 00670 00930 00931 00935 00936 Parameter Description Parameter Abbreviation Water Temperature (degree Centigrade) TEMP CENT Water Temperature (degree Fahrenheit) TEMP FAHN Stream Flow (cubic feet per second) FLOW CFS Turbidity, Jackson Candle (Jackson Unit) JURB, J.U. Turbidity, Hellige (ppm as silicon dioxide) TURB PPMSI02 Conductivity (micromhos at 25°C) CNDUTVY M0 Dissolved Oxygen (mg/1) DO MG/L Dissolved Oxygen (percent of saturation) DO SAT PCT Biochemical Oxygen Demand (mg/1, 5-day-20°C) B0D5 MG/L Chemical Oxygen Demand, 0.025N l^CrO^ (mg/1) COD MG/L pH (standard unit) PH SU Total Residue (mg/1) T RSD MG/L Total Volatile Residue (mg/1) TV RSD MG/L Total Fixed Residue (mg/1) TFX RSD MG/L Total Filtrable Residue (mg/1) TF RSD MG/L Volatile Filtrable Residue (mg/1) VF RSD MG/L Fixed Filtrable Residue (mg/1) FF RSD MG/L Total Nonfiltrable Residue (mg/1) TNF RSD MG/L Volatile Nonfiltrable Residue (mg/1) VNF RSD MG/L Fixed Nonfiltrable Residue (mg/1) FNF RSD MG/L Settlable Residue (ml/1) S RSD ML/L Total Nitrogen (mg/1 as N) T N MG/L Organic Nitrogen (mg/1 as N) OG N MG/L Ammonia Nitrogen (mg/1 as N) AM N MG/L Nitrite (mg/1 as N) N02 MG/L N Nitrate (mg/1 as N) N03 MG/L N Nitrite Plus Nitrate, One Determ. (mg/1 as N) N02&3 MG/L N Ammonia & Organic Nitrogen, One Determ. (mg/1 as N) AM&OG N MG/L Total Phosphate (mg/1 as PO4) T P04 MG/L Poly Phosphate (mg/1 as PO4) PL P04 MG/L Ortho Phosphate (mg/1 as PO4) OT P04 MG/L Total Phosphorus, Wet Method (mg/1 as P) T P MG/L Diss. Phosphorus, Wet Method (mg/1 as P) D P MG/L Insoluble Phosphorus (mg/1 as P) I P MG/L Total Organic Phosphorus (mg/1 as P) T OG P MG/L Dissolved Sodium (mg/1 as N ) D NA MG/L Sodium Adsorption Ratio NA ADS RATIO Dissolved Potassium (mg/1 as K) D K MG/L Suspended Potassium (mg/1 as K) SUS K MG/L 38 ------- Code Parameter Description Parameter Abbreviation 00937 Total Potassium (mg/1 as K) T K MG/L 00940 Chloride (mg/1 as CI) CL MG/L 31501 Total Coliform (membrane filter, Immed., M-Endo Med, 35°C, /100 ml) T CLFl/100 ML 31503 Total Coliform (membrane filter, delayed, M-Endo Med, 35°C, /100 ml) T CLF2/100 ML 31504 Total Coliform (membrane filter, immed., Les Endo Agar, 35°C, /100 ml) T CLF3/100 ML 31615 Fecal Coliform (MPN, EC Med., 44.5°C, tube. 31614, /100 ml) F CLFl/100 ML 31616 Fecal Coliform (membrane filter, M-FC Broth, 44.5 °C, /100 ml) F CLF2/100 ML 31673 Fecal Streptoccoci (membrane filter, KF Agar, 35°C, 48 hr, /100 ml) F STCl/100 ML 31679 Fecal Streptoccoci (MF M-Enderoccocus Agar, 35 C, 48 hr, /100 ml) F STC2/100 ML 38260 Methylene Blue Active Substance MBAS MG/L 70299 Suspended Solids (Residue on Evap. at 180 C, nig/1) SS MG/L 70300 Total Filtrable Residue (dried at 180 C, mg/1) TF RSD MG/L 70302 Dissolved Solids - Tons per Day DS TONS/DAY 70303 Dissolved Solids - Tons per Ac-Ft DS TONS/A-FT 70324 Suspended Sediment (mg/1) SUS SED MG/L 71845 Ammonia Nitrogen (mg/1 as NH4) AM MG/L NH4 71850 Nitrate (mg/1 as NO3) N03 MG/L 71855 Nitrite (mg/1 as NO2) N02 MG/L 71886 Total Phosphorus (mg/1 as PO4) TP MG/L P04 71887 Total Nitrogen (mg/1 as NO3) TN MG/L N03 71888 Total Soluble Phosphorus (mg/1 as PO4) TSP MG/L P04 71889 Soluble Orthophosphate (mg/1 as PO4) SO P04 MG/L 39 ------- The concentration of insecticides, as denoted by INSECTICIDES in the Data Report, was taken as the average concentration in whole water sample (jig/1) of the following parameters; Code Parameter 39330 Aldrin 39340 BHC 39350 Chlorodane 39360 DDD 39365 DDE 39370 DDT 39380 Dieldrin 39388 Endosulfan 39390 Endrin 39398 Ethion 39400 Toxaphene 39410 Heptachlor 39420 Heptachlor Epoxide 39430 Isodrin 39440 NRX 39450 NHP 39460 Chlorobenzilate 39470 Dilan 39480 Methoxychlor 39530 Malathion 39540 Parathion 39550 Chlorothion 39560 Demeton 39570 Diazinon 39580 Guthion 39590 Hept 39600 Methyl Parathion 39610 Phosdrin 39620 Tepp 39750 Sevin 39780 Dicofol 39782 Lindane 39786 Trithion 39790 Methyl Trithion 39800 Imidan 39900 Allethrin 39910 Cinerin 39930 Pyrethrins 40 ------- The concentration of herbicides, as denoted by HERBICIDES in the Data Report, was the average concentration of the following parameters in the whole water sample, with unit yg/1: Code Parameter 39730 2,4-D 39740 2,4,5-T 39760 Silvex 39770 Dacthal (DCPA) 39920 DNOC ------- No Page 42 ------- APPENDIX D LAND RESOURCE REGION CODES 43 ------- Region Symbol A, C B D F F, G, H I, J, P, 0, T, U N, R, S K, L, M Physiographic Region Pacific Coast Columbia River Basin Southwestern Basins and Mountains and Colorado Plateau and Mountains Rocky Mountains Great Plains Atlantic and Gulf Coastal Plains Appalachian Ozark Highlands Central Basin 44 ------- |