Return-Path: rmusson@srv1rvares.er.usgs.gov Received: from mailrvares.er.usgs.gov (srv1rvares.er.usgs.gov [130.11.51.209]) by id02didbse.wr.usgs.GOV (Geomail 1.2.3) with ESMTP id LAA02731 for ; Tue, 1 Jul 1997 11:27:31 -0600 Received: from w105dcascr.wr.usgs.gov (w105dcascr.wr.usgs.gov [130.118.108.225]) by mailrvares.er.usgs.gov (Geomail 1.2.3) with ESMTP id NAA15164; Tue, 1 Jul 1997 13:25:28 -0400 Received: (nakagaki@localhost) by w105dcascr.wr.usgs.gov (Geomail 8.6.11/1.2.3-dky) id KAA09101; Tue, 1 Jul 1997 10:25:25 -0700 Message-Id: <199707011725.KAA09101@w105dcascr.wr.usgs.gov> Subject: FY91 SU - SW GIS DATA CORRECTION REQUEST To: nawqa91pc@srv1rvares.er.usgs.gov, nawqa91gis@srv1rvares.er.usgs.gov, nawqa91db@srv1rvares.er.usgs.gov Date: Tue, 1 Jul 1997 10:25:23 -0700 (PDT) Cc: nawqanlt@srv1rvares.er.usgs.gov, nawqanst@srv1rvares.er.usgs.gov, nadasig@srv1rvares.er.usgs.gov From: "Naomi Nakagaki, Cartographer, Sacramento, CA" Phone: (916) 278-3092 X-Mailer: ELM [version 2.4 PL25] MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Length: 30033 This memo is being sent again for easier reading. I apologize for the inconvenience. Naomi MEMORANDUM June 30, 1997 TO: Study-Unit Chiefs (1991), GIS Specialists (1991) and Data Base Managers (1991) National Water-Quality Assessment Program SUBJECT: FY91 study units' surface-water GIS data correction request This request reflects a memo which will be transmitted by Tim Miller (within the next few days), regarding the corrections and re-aggregation of NWIS data and SW GIS data. The target date for submitting corrected SW GIS data is July 31st, 1997. As part of the quality control checking by National Synthesis, it has been found that for approximately 1/10th of all fixed and bed-sediment and tissue sites, the GIS-derived drainage areas differ from the NWIS reported drainage areas by over 10%. These differences may be attributed to various factors, but without the help of study units, it is impossible for National Synthesis to identify or explain why the differences exist for each site. Correct basin boundaries are vital to data analysis and we must resolve the discrepancies. After examining the discrepancies, it appears that part of the differences may be due to the confusion as to how contributing and total drainage are reported in each districts' NWIS data base. It seems that in most districts, contributing drainage area in NWIS is reported ONLY if it differs from the total drainage area. In addition, based on GIS-derived areas, it is possible that NWIS may be missing contributing drainage entries. If contributing drainage was not entered in NWIS, comparisons were made by subtracting the GIS-derived basin area from the NWIS total drainage area; if NWIS contributing drainage area was available, it was subtracted from the GIS-derived basin area. This approach may or may not be appropriate; the criteria that each district uses to store drainage area in NWIS would ultimately determine whether this comparison approach is meaningful. Another factor attributing to the discrepancies between GIS-derived drainage areas and NWIS drainage areas is an oversight by National Synthesis to clarify the need to have both contributing AND total drainage boundary coverages for a site, if they differed. As a result, nearly all study units submitted a coverage of either the contributing or total drainage area for basins where each could be delineated separately. But for National Synthesis and future data users to be able to choose the more applicable ancillary data pertaining to a contributing or total drainage area, both contributing and total drainage boundary coverages will be needed. For example, if pesticide application (by drainage area) was calculated in the summer months, the drainage area most applicable might be solely the contributing drainage. On the other hand, if pesticide application by drainage area was needed during the winter months prior to a major storm, the entire drainage may be more appropriate for use estimation. Some of the discrepancies may also be caused from the possibility that NWIS drainage areas are not up-to-date, due to the methodology used to derive drainage totals (e.g. planimeters vs. GIS). In addition, it is possible that NWIS totals don't yet reflect recent human influences to a drainage, e.g. diverted or ported water from other basins. Though it is encouraged that study units take action to inform local districts of the need to correct these data, the effort here is focused solely on correcting GIS basin boundary coverages. Station ID's for fixed and bed-sediment and tissue sites having basin area discrepancies over 10% are found below. Also included are station ID's for fixed-sites having basin area discrepancies less than 10%. The sites are organized by type of discrepancy, in six separate tables, the first five of which are of higher priority. Please review all tables, and for tables 1-5, provide National Synthesis with any insight that could aid us in understanding the influences that may be attributing to the discrepancies. Also, where contributing and total drainage areas are not coincident, National Synthesis will need a separate coverage for each drainage. If these coverages are not currently available and it is not possible to meet the time frame in providing these coverages, please relay this information to your regional hydrologist and to National Synthesis (email nakagaki) as soon as possible so any conflicts can be assessed immediately and resolved in some manner. In the email, please include a list of sites/basins by STAID for which contributing or total drainage basins are not available, and the time and resources that would be needed to generate GIS coverages. When making your coverages available, please use same naming convention as in previous SW GIS requests ('b' + first 8 digits of STAID) and include coverage documentation. Then export each coverage and place them in your local anonymous ftp pub area. Please send email to Naomi Nakagaki (nakagaki) with your IP address and any other information that should be known about your drainage basins. On a side note, in regards to the GW GIS data, we think that some study units may need to refine their polygon coverages, for example, land use polygons that don't fully represent the targeted land use. Also, study units might need to enhance the coverage documentation to clarify the procedure that they used to develop the polygons and select the wells. The GW GIS correction memo will be released July 31st, 1997. Thank you. ======================================================================== Table 1. GIS-derived area compared with NWIS contributing drainage area. In most cases, contributing area = total area, but difference between GIS and NWIS contributing basin area is 10%. If GIS- derived area is accurate, and represents the contributing and total drainage area, no action needs to be taken. If GIS boundary represents either contributing OR total drainage, and their delineation is NOT coincident, please provide coverage not yet submitted. ------------------------------------------------------------------------ SU STAID GIS NWIScontrib NWIS-total diff %diff ccpt 12464770 459 384.000 384.000 74.62 16 ccpt 12513650 475 798.000 798.000 323.23 -68 gafl 02324000 305 350.000 350.000 44.69 -15 gafl 02301750 14 16.100 16.100 2.25 -16 gafl 02324500 102 120.000 120.000 17.52 -17 gafl 02300700 20 29.100 29.100 9.57 -49 gafl 02303300 12 60.000 60.000 48.18 -40 redn 05058500 4,045 2,110.000 7,810.000 1,934.99 48 riog 08249000 789 887.000 887.000 98.18 -12 riog 08227000 512 595.000 595.000 82.53 -16 ======================================================================== ======================================================================== Table 2. Does the GIS basin boundary correspond to contributing area only within the study unit? If so, a coverage of the entire drainage would also be needed for these sites. ------------------------------------------------------------------------ SU STAID GIS NWIScontrib NWIS-total diff %diff cnbr 06805500 30,174 71,000.000 85,800.000 40,826.49 -58 cnbr 06770500 3,265 54,000.000 58,800.000 50,735.28 100 cnbr 06768000 1,878 52,900.000 57,700.000 51,021.55 100 cnbr 06766000 552 51,400.000 56,200.000 50,847.62 100 cnbr 06765698 552 -- 55,200.000 -54,647.62 100 cnbr 06799350 4,676 4,100.000 5,100.000 575.83 12 redn 05056000 1,877 760.000 2,070.000 1,117.26 60 ======================================================================== ======================================================================== Table 3. GIS basin boundary appears to correspond to TOTAL drainage area; Entry in NWIS implies contributing basin exists separate from total contributing area? If so, a coverage delineating the contributing drainage area is needed. ------------------------------------------------------------------------ SU STAID GIS NWIScontrib NWIS-total diff %diff cnbr 06775900 966 30.000 960.000 936.48 97 cnbr 06791500 752 50.000 762.000 701.65 93 cnbr 06790500 4,302 1,240.000 4,290.000 3,061.94 71 cnbr 06785000 8,076 3,130.000 8,090.000 4,946.29 61 cnbr 06782000 1,212 700.000 1,340.000 511.98 42 cnbr 06799000 2,864 1,790.000 2,790.000 1,074.13 38 cnbr 06800500 6,946 5,870.000 6,900.000 1,075.51 15 redn 05058700 4,493 2,490.000 4,490.000 2,002.55 45 redn 05084000 405 336.000 456.000 69.18 17 redn 05066500 1,242 1,090.000 1,200.000 152.34 12 redn 05059000 5,006 3,020.000 5,010.000 1,986.12 40 redn 05053000 2,091 1,490.000 2,080.000 600.59 29 riog 08353000 7,380 6,220.000 7,350.000 1,160.40 16 ======================================================================== ======================================================================== Table 4. Contributing drainage area is NOT reported, so total drainage was used to compare with GIS-derived basin area. Again, if contributing and total drainage differ, please provide coverage not yet submitted. If GIS coverage needs refinement, please submit another coverage. If NWIS area needs update, no action is needed. ------------------------------------------------------------------------ SU STAID GIS NWIScontrib NWIS-total diff %diff acfb 02335790 16 -- 14.000 1.98 12 albe 02084540 44 -- 26.000 18.34 41 albe 02083833 17 -- 11.000 6.18 36 ccpt 12472600 386 -- 4,840.000 -4,454.25 100 cnbr 06800000 369 -- 450.000 -81.26 -22 cnbr 06787000 693 -- 983.000 -290.32 -42 gafl 02324400 76 -- 60.000 15.76 21 hdsn 01372800 73 -- 57.300 16.12 22 hdsn 01361200 55 -- 60.600 -5.79 -11 hdsn 01359131 6 -- 7.370 -1.03 -16 hdsn 01361500 80 -- 98.000 -18.40 -23 lsus 405121077342701 41 -- 17.500 23.57 57 lsus 402549078213001 116 -- 135.000 -19.46 -17 nvbr 094196783 1,019 -- 1,350.000 -330.76 -32 nvbr 09419790 1,555 -- 2,200.000 -644.87 -41 ozrk 06923150 41 -- 35.700 5.05 12 ozrk 06923250 337 -- 377.000 -39.85 -12 ozrk 06929315 30 -- 34.200 -3.73 -12 ozrk 06926500 9,430 -- 14,500.000 -5,069.50 -54 ozrk 07055875 67 -- 462.000 -394.58 100 ozrk 07183500 200 -- 4,905.000 -4,705.21 100 poto 01617800 16 -- 18.900 -2.68 -17 redn 05051300 1,553 -- 1,880.000 -327.20 -21 redn 05086000 218 -- 309.000 -90.61 -41 redn 05104500 432 -- 573.000 -140.55 -33 redn 05030000 197 -- 270.000 -72.76 -37 redn 05104000 215 -- 312.000 -97.17 -45 redn 05060600 6,929 -- 10,700.000 -3,770.91 -54 sanj 11303500 7,345 -- 13,536.000 -6,190.99 -84 splt 06713500 24 -- 409.000 -385.39 100 splt 06753400 172 -- 195.000 -23.01 -13 usnk 13081500 18,853 -- 15,700.000 3,153.23 17 will 14200400 10 0.000 10.000 9.84 100 will 14153500 35 -- 104.000 -69.10 100 will 14153000 35 -- 104.000 -69.28 100 wmic 04062085 44 -- 49.000 -4.83 -11 ======================================================================== ======================================================================== Table 5. The following is a list of fixed-sites that have ANY discrepancy less than or equal to 10%, between NWIS contributing drainage area (if reported, total drainage if not) and GIS- derived basin area. A number of these discrepancies are minute, however, for several, the difference in area in square miles is substantial, especially in large drainages. Please verify- if contributing and total drainage areas vary for a site, please provide coverage not yet submitted. Also, if national synthesis' GIS-derived basin area does not match fairly closely with study units' GIS basin area, please provide another coverage. ------------------------------------------------------------------------ SU STAID GIS NWIScontrib NWIS-total diff %diff acfb 02359170 19,241 -- 19,200.000 41.13 0 acfb 02338000 2,411 -- 2,430.000 -18.89 1 albe 02084558 74 -- 68.000 5.90 8 albe 02083500 2,222 -- 2,180.000 41.54 2 albe 02089500 2,711 -- 2,690.000 20.99 1 albe 02091500 737 -- 733.000 3.90 1 albe 02084160 42 -- 45.000 -2.90 -7 ccpt 13349320 79 73.200 73.200 5.42 7 ccpt 13349410 306 302.000 302.000 3.90 1 ccpt 13346000 487 -- 491.000 -3.64 -1 ccpt 13351000 2,463 2,500.000 2,500.000 -36.74 -1 cnbr 06795500 294 -- 270.000 24.02 8 cnbr 06773050 140 -- 132.000 8.45 6 cnbr 06791150 12,690 -- 12,500.000 189.50 1 conn 01184000 9,672 9,660.000 9,660.000 11.77 0 gafl 02318500 1,492 1,480.000 1,480.000 11.73 1 gafl 02226160 14,108 14,000.000 14,000.000 108.43 1 hdsn 01371500 735 695.000 695.000 39.58 5 hdsn 01357500 3,519 -- 3,450.000 68.71 2 hdsn 01372043 11,927 -- 11,700.000 226.50 2 hdsn 01335770 4,625 -- 4,620.000 4.90 0 nvbr 10348200 1,067 -- 1,070.000 -3.40 -0 nvbr 10350500 1,592 -- 1,600.000 -8.43 -1 nvbr 10351700 1,807 -- 1,830.000 -22.90 -1 nvbr 10312020 1,397 -- 1,450.000 -53.07 -4 nvbr 10312000 1,234 -- 1,300.000 -66.15 -5 ozrk 07196500 948 -- 959.000 -11.41 -1 ozrk 07189000 850 -- 872.000 -22.30 -3 ozrk 07186480 294 -- 323.000 -28.53 -0 poto 01614500 504 -- 494.000 10.05 2 poto 01639000 176 -- 173.000 3.36 2 poto 01636500 3,043 -- 3,040.000 2.66 0 poto 01646580 11,574 -- 11,600.000 -26.48 -0 poto 01608500 1,461 -- 1,470.000 -8.92 -1 poto 01608000 279 -- 283.000 -3.55 -1 redn 05079000 5,268 -- 5,270.000 -2.00 -0 redn 05046000 1,738 -- 1,740.000 -2.10 -0 redn 05053800 6,614 -- 6,750.000 -136.00 -2 redn 05102490 35,554 -- 35,600.000 -45.73 -0 redn 05112000 1,556 -- 1,560.000 -3.88 -0 redn 05102500 35,577 36,400.000 35,600.000 -822.91 -2 redn 05082500 25,676 26,300.000 25,700.000 -623.92 -2 redn 05064500 17,272 18,000.000 17,300.000 -727.85 -4 riog 08363500 30,238 27,860.000 30,800.000 2,378.10 8 riog 08364000 31,323 29,270.000 32,210.000 2,052.69 7 riog 08358400 25,978 24,760.000 27,700.000 1,217.95 5 riog 08290000 3,145 3,044.000 3,144.000 101.09 3 riog 08220000 1,312 1,320.000 1,320.000 -8.16 -1 riog 08331000 14,742 14,960.000 17,900.000 -217.96 -1 riog 08240000 2,749 2,800.000 5,740.000 -51.16 -2 riog 08313000 11,031 11,360.000 14,300.000 -329.43 -3 riog 08251500 4,585 4,760.000 7,700.000 -174.79 -4 riog 08276500 6,529 6,790.000 9,730.000 -260.80 -4 sanj 11272500 1,394 -- 1,273.000 121.22 9 sanj 11303000 1,111 -- 1,075.000 35.82 3 sanj 11290000 1,842 -- 1,884.000 -42.21 -2 splt 06720500 4,830 -- 4,710.000 120.27 2 splt 06731000 989 -- 976.000 13.18 1 splt 06754000 9,708 -- 9,650.000 58.12 1 splt 06714000 3,865 -- 3,860.000 4.63 0 splt 06765500 24,126 -- 24,100.000 25.87 0 splt 06759910 16,803 -- 16,800.000 2.86 0 splt 06753990 569 -- 571.000 -2.45 -0 splt 06752000 1,028 -- 1,060.000 -31.57 -3 splt 06719505 387 -- 400.000 -12.83 -3 trin 08065800 335 -- 321.000 13.58 4 trin 08058900 169 -- 164.000 5.44 3 trin 08064100 823 -- 807.000 15.84 2 trin 08051500 298 -- 295.000 3.47 1 trin 08044000 336 -- 333.000 2.98 1 trin 08066500 17,243 -- 17,200.000 43.30 0 trin 08057410 6,291 -- 6,280.000 10.83 0 usnk 13152500 3,323 2,990.000 2,990.000 333.30 10 usnk 13056500 3,219 2,920.000 2,920.000 298.84 9 usnk 13069500 12,185 11,300.000 11,300.000 884.52 7 usnk 13010065 511 486.000 486.000 25.38 5 usnk 13073000 588 570.000 570.000 18.20 3 usnk 13027500 852 829.000 829.000 22.86 3 usnk 13154500 35,885 35,800.000 35,800.000 84.64 0 usnk 13055000 886 890.000 890.000 -4.11 -0 usnk 13120500 442 450.000 450.000 -8.36 -2 whit 03360895 60 -- 56.200 3.38 6 whit 394340085524601 95 -- 93.400 1.68 2 whit 385234087071801 4,801 -- 4,790.000 10.94 0 whit 03374100 11,309 -- 11,300.000 9.09 0 whit 03373500 4,923 -- 4,930.000 -6.75 -0 will 14202000 487 -- 479.000 8.05 2 will 14211720 11,173 -- 11,100.000 72.51 1 wmic 04085139 6,343 -- 6,330.000 13.08 0 wmic 04067500 3,921 -- 3,930.000 -8.95 -0 ======================================================================== ======================================================================== Table 6. Missing entry in NWIS for BOTH contributing and total drainage area; it is assumed that drainage is represented correctly by GIS coverage - they are listed here only for study units to verify. ------------------------------------------------------------------------ SU STAID GIS NWIScontrib NWIS-total diff acfb 02335868 11 -- -- ? acfb 02339935 45 -- -- ? acfb 023415605 68 -- -- ? acfb 02334080 905 -- -- ? acfb 02339190 3,247 -- -- ? acfb 02350330 3,700 -- -- ? acfb 02356025 7,661 -- -- ? acfb 02344070 8,623 -- -- ? acfb 302837085000000 17,178 -- -- ? acfb 304219084520800 17,178 -- -- ? acfb 295620085011500 19,245 -- -- ? albe 02085390 33 -- -- ? albe 02053490 54 -- -- ? albe 02051000 56 -- -- ? albe 02056670 580 -- -- ? albe 02049500 611 -- -- ? albe 02047000 1,441 -- -- ? albe 02088119 1,679 -- -- ? ccpt 471313119422400 2 -- -- ? ccpt 462258119110800 4 -- -- ? ccpt 12472000 10 -- -- ? ccpt 470100119030000 20 -- -- ? ccpt 13346990 34 -- -- ? ccpt 12472950 37 -- -- ? ccpt 465637116381400 47 -- -- ? ccpt 465210119211500 56 -- -- ? ccpt 465537116422500 135 -- -- ? ccpt 464539117133000 157 -- -- ? ccpt 12513400 269 -- -- ? ccpt 12513600 453 -- -- ? ccpt 465950117371000 894 -- -- ? gafl 02322016 6 -- -- ? gafl 02234100 136 -- -- ? gafl 02217481 352 -- -- ? hdsn 01346865 22 -- -- ? hdsn 01372681 54 -- -- ? hdsn 01348995 58 -- -- ? hdsn 0136215855 112 -- -- ? hdsn 01372306 137 -- -- ? hdsn 01360515 153 -- -- ? hdsn 0136216850 170 -- -- ? hdsn 01333763 511 -- -- ? hdsn 01342702 627 -- -- ? hdsn 01351450 875 -- -- ? hdsn 01325010 2,713 -- -- ? hdsn 01376304 13,347 -- -- ? lsus 402108076363701 77 -- -- ? lsus 404422076325401 82 -- -- ? lsus 404354076474001 119 -- -- ? lsus 404328076485701 155 -- -- ? lsus 404334076501601 157 -- -- ? lsus 403626077340401 189 -- -- ? lsus 400037076423701 242 -- -- ? lsus 395614076231401 472 -- -- ? lsus 400144076310701 26,006 -- -- ? lsus 394608076150801 27,097 -- -- ? nvbr 10309010 375 -- -- ? nvbr 094196784 1,020 -- -- ? nvbr 360748114520301 1,568 -- -- ? nvbr 10351690 1,807 -- -- ? nvbr 10312275 1,850 -- -- ? nvbr 10351750 1,916 -- -- ? ozrk 07194947 39 -- -- ? ozrk 07065040 42 -- -- ? ozrk 06917380 156 -- -- ? ozrk 07061170 160 -- -- ? ozrk 07065495 305 -- -- ? ozrk 07073800 380 -- -- ? ozrk 07061400 430 -- -- ? ozrk 07052250 464 -- -- ? ozrk 07061600 495 -- -- ? ozrk 07067000 1,679 -- -- ? poto 01643020 819 -- -- ? redn 484642097474301 127 -- -- ? redn 471243095514301 139 -- -- ? redn 465149096280401 380 -- -- ? redn 05062250 487 -- -- ? redn 05094500 491 -- -- ? redn 05087600 762 -- -- ? redn 461500096353001 1,969 -- -- ? redn 05099300 2,881 -- -- ? redn 05099900 3,267 -- -- ? redn 05100100 3,281 -- -- ? redn 475331096144601 3,583 -- -- ? redn 485634097173801 3,761 -- -- ? riog 354511106151010 19 -- -- ? riog 372124105510601 265 -- -- ? riog 372214105491210 268 -- -- ? riog 374922106542901 640 -- -- ? riog 372334105470001 2,116 -- -- ? riog 351921106332710 14,036 -- -- ? sanj 11274653 8 -- -- ? sanj 11274538 10 -- -- ? sanj 11274554 22 -- -- ? sanj 11274560 86 -- -- ? sanj 11261100 473 -- -- ? sanj 11262900 473 -- -- ? sanj 11260815 818 -- -- ? sanj 11222700 1,696 -- -- ? sanj 11223300 1,767 -- -- ? sanj 11274570 3,736 -- -- ? splt 402114105350101 38 -- -- ? trin 325147097185398 25 -- -- ? trin 08048542 34 -- -- ? trin 324853097151498 50 -- -- ? trin 321313096415201 60 -- -- ? trin 324724096581698 88 -- -- ? trin 321017096420099 95 -- -- ? trin 08066295 109 -- -- ? trin 321441096442601 327 -- -- ? trin 315801096282999 730 -- -- ? trin 315821096152299 857 -- -- ? trin 320228096122999 1,043 -- -- ? trin 324500097163097 3,000 -- -- ? trin 324500097163098 3,000 -- -- ? trin 324643096561397 3,180 -- -- ? trin 324643096561398 3,180 -- -- ? trin 324345096454698 6,152 -- -- ? usnk 13075983 3 -- -- ? usnk 13023700 20 -- -- ? usnk 13091995 52 -- -- ? usnk 13135350 125 -- -- ? usnk 13092733 236 -- -- ? usnk 13092747 241 -- -- ? usnk 13092753 241 -- -- ? usnk 13075800 1,319 -- -- ? usnk 13090000 22,817 -- -- ? usnk 13094000 29,384 -- -- ? will 433453123040801 1 -- -- ? will 441310122095801 2 -- -- ? will 451551122573100 3 -- -- ? will 440234123004301 5 -- -- ? will 433407123043401 6 -- -- ? will 445047122174801 9 -- -- ? will 453205122223701 14 -- -- ? will 451203122550500 20 -- -- ? will 451309123041501 36 -- -- ? will 443138123120901 146 -- -- ? will 443321123155201 151 -- -- ? will 453056122213701 484 -- -- ? will 453329122425201 11,204 -- -- ? ========================================================================