local rainfall
Contents
1. NNDC CLIMATE DATA ONLINE Daily data for 1 stations fist appears below Selected Meteorological Flement s Date Range Year Month See notes PRCE TMA TMIN SNOW SNWD TORS 02 2005 Selected Output Format Web Form Output via FTP Clear Selections Internet 11 In the Data Range Year Month column select the time period 1980 01 to 2004 12 or the appropriate time period for you project 2 Daily Surface Data Microsoft Internet Explorer File Edit View Favorites Tools Help Oo x EI OD pi C Search SP Favorites 4 A ee al rel NNDC CLIMATE DATA ONLINE Daily data for 1 stations fist appears below selected Meteorological Element s PRCP TMAX TMIN SNOW SNWD TORS Selected Output Format Web Form Output via FTP Cea Selection Internet 12 Click on the Continue button After a few seconds the following webpage will appear SOD Surface Data Daily US amp some non US Request Summary Microsoft Intefffet xpiorer File Edit View Favorites Tools Help Q ex i 7 gt E A po Search SIP Favorites 4 g je Address 2 https hurricane ncdc noaa govicoi binfcdofcdoprod pl prr Dictionary Thesaurus GA Word of the Day NNDC CLIMATE DATA ONLINE SOD Surface Data Daily US amp some non US Request Summary Selected Stations includes 1 stations See selected stations below selected Meteorological Elem2. Select the data file 151899640758 txt and click Open The Text Import Wizard window will pop up The Text Wizard has determined that your data is Delimited IF this is correct choose Next or choose the data type that best describes your data Original data type Choose the File type that best describes your data Characters such as commas or tabs separate each field CO Fixed width Fields are aligned in columns with spaces between each field Start import at pow 1 File origin 437 OEM United States t Preview of file C Courses CR55696101151699640758 txt OOPLID WEANID Prelin wear month day Tmax Tmin Tobs Twean ldd Hd S46d6 99999 1380 O11 43 32 36 738 0 27 0 35 0 oO Siae Sagoo o S lee oP 25 46 55 0227 0 0 r r r r 0 4 D34648 99999 1980 01 3 56 29 49 43 0 Z2 0 O O 94648 99999 1980 01 4 49 34 34 42 0 23 0 35 Ca a a 4 Select Delimited in the Original data type and click Next gt 12 Text Import Wizard Step of 3 This screen lets you set the delimiters your data contains You can see how your text is affected in the preview below Delimiters Tab d Semicolon E i _ Space _ Other Text qualifier E v Treat consecutive delimiters as one Data preview PaN ID Prelim Fear 5 Select Comma in Delimiters and click Next gt Text Import Wizard Step 3 of 3 This screen lets you select each column and set Column data Format the Data Fo
3. precipitation data ASCII file s base name 30 17 Click Table Stop Editing and click Yes at the Stop Editing window Notice that the field names become italic which indicates that the table is now non editable 2 ArcView GIS 3 2 2 locpcp dbf 946485 pepjasp 34 5000 84 4667 446 18 Click File Exit and choose No at the pop up window 19 If it has not already been done copy this precipitation gage location file and the precipitation data file s prepared in the previous section to the data directory of your SWAT model project Notes This note only provides the directions for downloading daily precipitation data from NCDC website and preparing the corresponding precipitation data file s and precipitation gage location file It is very similar to prepare data and location files for daily temperature and other meteorological data but using comma to separate values However 1f you want to work on hourly or sub hourly precipitation data you are encouraged to read Chapter 7 especially Section 7 2 very carefully In such a case a short computer program instead of Excel may be required 31
4. 45 46 0 19 0 O O0 094648 99999 1980 01 22 50 41 46 46 0 19 0 13 0 094648 99999 1980 01 23 46 28 30 37 0 28 1 42 0 094648 99999 1980 01 24 55 17 46 36 0 29 0 O 094648 99999 1980 01 25 55 32 48 44 0 21 0 O 094648 99999 1980 01 26 48 39 45 44 0 21 0 O 0 Internet 18 Click File Save As to save the ASCII data file Repeat to save the fourth file station file B Processing the downloaded data using MS Excel Having downloaded the ASCII weather data from NCDC the next step is to use MS Excel to process the downloaded precipitation data and save it into the format that the SWAT interface requires The ASCII txt table format for the precipitation data table required by the SWAT interface either BASINS SWAT or AVSWAT is described on Page 12 of the AVSWAT 2000 User s Manual http www brc tamus edu swat downloads doc swatav2000 pdf 1 Open MS Excel if it is not already open 2 Click File Open and navigate to the directory that contains the downloaded precipitation data ASCII file Change the file type at the bottom of the Excel Open window from All Microsoft Excel Files to All Files 11 3 Mame Sze Type awe EPS Total Maximum Daily Loads Overview of Curr File Folder My Recent SH 151599640758 472 KB Text Document Documents 1 KE Text Document My Documents My Computer Br jiji Lh Op My Network Places Files oF type Text Files Cancel 3
5. Request Verification Microsoft Internet Explorer Seles File Edit View Favorites Tools Help Om gt ix EI J gt Search SP Favorites EA A te a Ll rel 14 NNDC CLIMATE DATA ONLINE SOD Surface Data Daily US amp some non US Request Verification Your SOD Surface Data Daly US amp some non US request CDOOO718319 has been submitted for processing You will be notified by emal at hnzhulu uga edu when processing has completed for your request NOTICE Click on the following URL to access your files http wwwLaedc noaa cov pub orders CDO1S51899640758 html Ee Internet If the database is functioning properly it only takes a few minutes at most to process your request Then you can access your files either by clicking on the hyperlink of the last line or opening the email from NCDC in your email box However some times it takes a few days to process your request Fortunately this kind of situation does not happen very often so it shouldn t be an excuse for an overdue project 15 Click on the hyperlink and you will get the following webpage 2 SOD Surface Data Daily US amp some non US Data Access Microsoft Internet Explorer File Edit View Favorites Tools Help pack i x a A po Search Sp Favorites 4 ra k te wl rel Address 2 http www cdc noaa gov pubsorders Cl0151899640758 html 3 ar D Dictionary Thesaurus GA Word of the Day SOD Surface Data
6. be in meters All this information can be found in the station file that we downloaded along with the precipitation data file 6 Click Edit Add Field Type ID in the Name box select Number in the Type box type 8 in the Width box and type 0 in the Decimal Places box Field Definition Ed Type Humber Ecd Width g Decimal Places 0 7 Click OK The first field ID Field required is then added to the location table 2 2 ArcView GIS 3 2 DER File Edt Table Field Window Help 0 of 0 selected 2 locpcp dbf 8 To add the NAME field Click Edit Add Field Type NAME in the Name box select String in the Type box and type 8 in the Width box 2 Field Definition Name NAME Type Sting Cancel e Width g 9 Click Edit Add Field Type LAT in the Name box select Number in the Type box type 8 in the Width box and type 4 in the Decimal Places box Field Definition Ed Type Number Cancel E Width g Decimal Places 4 10 Click Edit Add Field Type LONG in the Name box select Number in the Type box type 8 in the Width box and type 4 in the Decimal Places box 28 amp Field Definition Type Number Cancel E Width g Decimal Places 4 11 Click Edit Add Field Type ELEVATION in the Name box select Number in the Type box type 8 in the Width box and type 0 in Decimal Places box amp Field Definition Name ELEVA
7. on ORK EJ Microsoft Excel jasper_precip Sle at File Edit View Insert Format Tools Data Window Help Adobe PDF f x MEEA TEEMA E Er T RAE R e 100 x Arial 10 B i A gt p Security Ez gt e ef Ge gt O FE B a 2 ee ee a E 1 Prep ram 5 9 C nn bw Sheet Sheet Sheeta IE ii Draw v Le AutoShapes a C C gt AS a l 22s 8 Lal A Ready ace el en E gt 21 Now replace the precipitation column head Prcp mm with a date string that represents the first date in the file 19800101 as shown below 23 EJ Microsoft Excel jasper_precip JE File Edit wiew Insert Format Tools Data Window Help Adobe POF Ft SEREA IEA de RF Oe CB Gg 100 x Arial ait B oe rT gt Security 54 32 ke oe 19500101 E 1 ES Ee E EFA ra ae Ready MUM 22 Click File Save As In the pop up window select Text MS DOS in the Save As Type box and type pcp jasp in the File Name box Save the file and keep in mind where it was saved for writing the precipitation gage location table below Answer Yes when asked if you want to keep the workbook in this format 24 EPS Total Maximum Daily Loads Overview of Current Total Maximum Daily Load TMDL Program 151699640756 1518996407 58stn Sspcpjasp My Recent Documents My Documents My Computer i File name pcpjasp w My Metw
8. to Tf there was only one weather station in this city you would have bypassed step 5 and been brought to this webpage directly 4 NCDC Weather Station Microsoft Internet Explorer File Edit View Favorites Tools Help Qm i gt x a A lf Search SP Favorites E2 A te Additional data products may be available for this station If you can t fmd what you are looking for here please try our Most Popular Products page Forms Publications and Web Pages Graphs and Other Images CD ROMs Digital ASCH Files 8 Click on Digital ASCII Files you will see 4 NCDC Weather Station Microsoft Internet Explorer File Edit View Favorites Tools Help ae 3 o Dictionary T Thesaurus QA Word of the Day Digital ASCH Files These files may or may not contam column headers In order to use these files you will need to umport them into a spreadsheet or database package for presentation Please do not order these data if you do not know what a Digital ASCH File is A sample Digital ASCI File is available for wiewme but content vanes a great deal depending on your request Other digital files are available Offlme that may contam data for this station For additional information and product samples click on the icon next to the desired product SOD Daily Surface Data TD3200 3210 combed 3220 Swmmary Of The Month SOM Cooperative 3240 Hourly Precipitation Data Internet 9 Click on SOD Daily
9. Customizing Local Precipitation Data Files for SWAT Zhulu Lin Department of Crop and Soil Sciences The University of Georgia Athens GA 30602 linzhulu uga edu In order to successfully apply SWAT meteorological data local to the area being studied are required at least for precipitation data Normally there are two ways to obtain local precipitation data one is to go to the National Climatic Data Center NCDC website www ncdc noaa gov to download precipitation data for your watershed the other is to set up local rain gage stations The former method is more practical for modeling a large watershed while the latter can obtain more accurate rainfall data for a smaller watershed It is also easier to attain sub daily rainfall data through using local rain gage stations Usually the rainfall measurement device is set to record data once very five minutes But most of precipitation data downloaded from the NCDC website are daily time series If you are lucky you may find some hourly precipitation data for a short time period for some weather stations In this note we will present a procedure for 1 downloading daily precipitation data files from the NCDC website 2 converting downloaded data into the format that is required by ArcView interfaces for SWAT 1 e BASINS SWAT or AVSWAT and 3 writing the precipitation gage location table dBase file A Downloading daily precipitation data from NCDC We will begin by downloading some pre
10. Daily US amp some non US Data Access Request ID CDO00718319 NOTICE From the time you submitted your request it may be several minutes to several hours for larger volumes before your web form is available For this reason it 1s recommended that you bookmark this web page for future reference and access to your web form You will also receive email nottication when your web form is ready File Size File Contents Access URL e N E HOD Surface Data Daily Us amp http fae nede noaa gowipubiordersi 31890640738 dat html 2304000 some non US Web Form we fioftp ned fmahforderss1 51299640753 txt 262640 some non US ASCII File neae no aa gow pub orders AOD Surface Data Daily Us amp http awl nede noaa zovspub orders 1 212998407 Seine tat O70 some non Us inventory mtation List http awa node noaa gowpubiordersi 131890640738 str txt 405 Internet 16 There are four files that are relevant to your request The first file is the data file in html format You don t need it The second file is the data file in text format ASCII file which is what you need The third file is the inventory file you just viewed before you submitted your request The fourth file is the weather station characteristics We will use the second and fourth files 17 Click on the second file 10 ftp ftp ncdc noaa gov pub orders 151899640758 txt Microsoft Internet Explorer Seles File Edit View Favorites Tools H
11. Help Adobe POF ETEENI FEN Arial Bio D oe 4645 L a Sort Descending Ally Top 10 Custom HAH 151899640758 Drawy L AutoShapes Ne a O O 44 iia Sets For siia r x Security r ETIT a 10 Then all blank rows will not be displayed For example as shown in the below figure the row 33 is hidden 16 E Microsoft Excel 151899640758 Sele e Fie Edit wiew Insert Format Tools Data window Help Adobe POF Type a question For help X n mY k 3 s i A rr TRR eee ee eee ae ee ee at J fh E 24 Elat a ag 100 o F Arial i0 B Z U pig A gt Security 5H Se lee oo p fe G4b45 g 94640 99999 94646 99999 1980 94646 99999 1980 94640 99999 1900 94640 99999 1900 94646 99999 1950 94640 99999 1950 94640 99999 1900 94645 agag 19580 94640 99999 1980 94640 99999 1900 94640 SEESE 1900 94640 99099 1550 94640 23039 1950 94640 99999 1900 94645 99999 1980 94646 99999 1980 94640 99999 1950 DATAT maw mm a n 100m M 4 Hh 151899640758 iia Draw Lg AutoShapes Noy OOA a dl 22 8 ial o A SS 5675 of 6959 records Found Sum 394495 77 DJ 00 Oo oo OO G0 u 11 Select the whole worksheet and click Edit Copy 12 Open a new Excel worksheet by clicking on the New icon or clicking on File New 13 In the blank newly created Excel workbook click Edit Paste The new Excel workbook n
12. Surface Data TD3200 3210 combined Climatic Data Online Application Router Microsoft Internet Explorer File Edit View Favorites Tools Help oO C x a A gt L Search SP Favorites 4 B NNDC CLIMATE DATA ONLINE Accessing data selection screen FOR Surface Data DAILY US amp SOME non US Simplified this system allows for very easy selection of data for a station OR multiple stations FOR USER selected TIME period The elements provided are precipitation maximum temperature MINIMUM temperature snowtall AND snow depth AS available FOR EACH station GH an easy TO KEAD printable FORM AND an ASCII text FILE Continue With SIMPLIFIED Options Advanced this system allows for selection of data for a station or multiple stations FOR USER selected TIME period IN contrast TO the simplitted amp YSTEM the USER selects the elements OF interest eg snow depth AND the output I5 provided IN an ASCII text FILE FOR later USE IN a spreadsheet Continue With ADYANCED Options Internet 10 Click on the Continue With SIMPLIFIED Options button the following webpage appears 2 Daily Surface Data Microsoft Internet Explorer File Edit View Favorites Tools Help pack gt x a Ch pa Search SP Favorites 4 A E bam rel Address http iicdo nedc noaa gow pls plcimprad poemain cdobystn vl gt iam j E Dictionary Gal Thesaurus ERA word of the Day
13. TION Type Humber Cancel Width E Decimal Places T 12 Click OK The location table is ready for adding a rain gage station 2 ArcView GIS 3 2 File Edit Table Field Window Help T 2 2 ble u O selected 3 locpep dbf PID NAME LAT LONG 13 Click Edit Add Record 29 ArcView GIS 3 2 Seles File Edit Table Field Window d Le E to AIA u 1 selected 2 locpcp dbf a rr a 0 0000 D a r Provides information about a record 14 In the second group on the toolbar click on the arrow with an T the Edit icon 15 Then click on each field of the added record and type in the relevant information Please note that the name for this rain gage station should be the same as the name that you gave to the processed precipitation file That is pcpjasp In addition the latitude and longitude are converted to decimal degrees from degree minutes divide the minutes by 60 to get the decimals After you ve finished inputting the gage information click on the Select icon which is the large arrow Otherwise you will lose the data you just typed in 2 ArcView GIS 3 2 Sele File Lable Field Window Help BOE H AAN B E locpcp dbf PL nane Je LONG ELEVATION 16 Repeat steps from 13 to 15 for any other rain gage stations It is worth repeating that the names for the rain gage stations in the NAME field should be the same as the
14. asper 1 NNW the following webpage will appear 4 NCDC Weather Station Microsoft Internet Explorer View Favorites Tools Help a i File Edit Search SP Favorites 4 3 t Te s NCDC Chimate Radar Data Inventores Locate Station Search 7 1 NNW Jasper GA United States Other Stations in Jasper List Siations in Division GA 02 List Stations in Pickens County List Stations within 5 10 25 or 50 miles Type Climate Division In Serice Elevation LatLon County COOP Call gn WERAN OC sini GAO North Central WIG ID 01 Jul 1945 to Present 446 5m 1465 above 5 1 34 30 N 84 27 8 W 094645 Pickens Data Inventories DATA Station History State Climatolo sist Regional Climate Center Information at Other Sites NWatonal Weather Service southern Region Headquarters Regional Forecast Office Local Weather Conditions Local Weather Forecast Current Radar Current Satellite Sunrise sunset Internet Bele 6 At the beginning of this page you can find the information about this weather station For example it shows the elevation latitude and longitude of this weather station It also shows the time period years when the weather station is was in Service 7 Ifthe In service time period covers the years you wanted click on DATA in the upper right corner you ll be brought
15. cipitation data from the National Climatic Data Center NCDC for weather stations in the Upper Etowah River watershed which was the subject of your Assignment 2 1 Using Internet Explorer do not use Netscape go to http www ncdc noaa gov oa climate stationlocator html 2 Locate station using Search by Station Name City You may use any other methods to locate weather stations in the interested area depending on what kind of information 1s available 3 In the search box type Jasper GA 4 NCDC Locate Weather Observation Station Record Microsoft Internet Explorer File Edit View Favorites Tools Help pack g j x a F pa Search SIP Favorites 4 A x rel Address https iwww nede noaa gov oa climate stationlacator htmal k Go CHD 7 D Dictionary Thesaurus BEA Word of the Day NCDC Chmate Radar Data Inventories Locate Station Search Help b Locate Station by aia e Latitude Longitude e State Division County City si TE ke ene gt a e List Radar Stations by Name by Alias a ee i e Search By Select the field you wish fo search Station Name City frity not identified in some records Locate Zip Code zi O State fuse tre character abbreviation WW eather County feountp not identified imn some records WBAN Observation calsim sat Cooperative Station ID Station World Meteorological Organization ID en Enter fhe val
16. ee eee ee eee ee l MM 18 Copy the formula to the entire column then copy the entire Prep mm column Use Paste Special to paste only the values not the formula of the column to the same positions Then delete all other columns except the newly created column Prep mm But keep in mind that the starting date for this precipitation time series is 1 1 1980 21 EJ Microsoft Excel jasper_precip la fx x E File Edit view Insert Format Tools Data Window Help Adobe PDF Type a question For help F 2D oS hs Qh SF EA an Pg A E o z i10 B Z U Li A p Security 2 5b kz 00 12 954 an AEn 44 gt Mh Sheeti lt Sheet Sheeta x pranz a Autoshanes z gt a OLOS T E Ne k k k k k l Ml 1 19 Now use Edit Replace to convert missing values of 25 400 to 99 0 Then select the entire column except the column head and click Format Cells Format Cells Number Alignment Font Border Patterns Protection Category Sample General Prep mm Currency Decimal places Accounting Date Time Use 1000 Separator Percentage Fraction Scientific Text Special Custom Negative numbers Number is used For general display of numbers Currency and Accounting offer specialized Formatting for monetary value 22 20 In the tab Number select Number in Category and 1 in Decimal places Then click
17. elp a sack ix EI A pi A Seems SP Favorites 4 7 Lod rel Address EJ Fro Ftp ncde noaa gov pubsorders 151899640758 txt v Go 3 D Dictionary Thesaurus GA Word of the Day A COOPID WBANID Prelim year month day Tmax Tmin Tobs Tmean Cdd Hdd Prep Flag Snow Flag Snwd meanT 094645 939999 1980 01 1 435 32 36 35 0 27 0 35 0 094645 99999 1980 01 2 51 25 46 35 0 27 0 0 oO 094646 99999 1980 01 3 56 29 49 4353 0 22 0 0 0O 094646 99999 1980 01 4 49 34 34 42 0 23 0 35 0 094646 99999 1980 01 5 34 26 25 30 0 35 0 05 0 094646 99999 1980 01 6 42 18 36 30 0 35 0 0 094646 99999 1980 01 7 42 30 40 36 0 29 0 0 094646 99999 1980 01 8 435 37 40 40 0 25 0 33 094646 99999 1980 01 9 435 35 40 41 0 24 0 07 094646 99999 1980 01 10 45 368 36 42 0 23 0 Q 094646 99999 1980 01 11 48 40 44 44 0 21 0 Q f f d d E E f f f f 094648 99999 1980 01 12 44 30 35 37 0 28 0 80 0 094648 99999 1980 01 13 42 32 36 37 0 28 0 0 O 094648 99999 1980 01 14 49 36 45 43 0 22 0 30 0 ga4e4g 99999 1960 01 15 55 32 32 44 0 21 0 0 p0 094648 99999 1980 01 16 60 99999 55 99999 99999 99999 0 O O 094648 99999 1980 01 17 55 48 50 52 0 13 0 51 O 0 094648 99999 1980 01 18 66 50 60 58 0 7 0 60 0 094648 99999 1980 01 19 65 31 60 48 0 17 0 O O0 094648 99999 1980 01 20 63 32 53 48 0 17 0 O O0 094648 99999 1980 01 21 55 36
18. ent s Date Range Year i Month 3 LPRCPE VINA 2 Thi Salou tshirt Tons 1920 01 to 2003 12 selected Output Format Web Form Selected Output Media PTR Total Data Rows Available 1704 View Inventory Output File Size Estimate bytes 2504000 Inventory Review I have reviewed the Inventory File to see if the elements dates desired are included before orderng Some time periods or elements may be missing For daily data there are often missing days and or missing elements eg temperature m the data received IMPORTANT Please enter a vald email address below so we can notify you when your request has finished processing E mail Address linzhulu uga edu submit Request Internet 13 Check the box in front of Inventory Review after you have viewed the inventory file by clicking on View Inventory in the above table Type in your email address in the box after E mail Address and click on Submit Request Then the following webpage pops up It should be noted that if you re using a university computer to download meteorological data from NCDC you shouldn t be asked for fees because the data are free of charge for users in non profit organizations If you are asked to purchase the data either switch to another computer or let your network administrator know about it who can easily solve your problem but I don t know how they do it SOD Surface Data Daily US amp some non US
19. k 18 EJ Microsoft Excel jasper_precip e File Edit View Insert Format Tools Data Window Help Adobe POF Type a question For help Do EIEEE TET E EL AL tifa com i0 B Z U hii A gt Security A 36 be oo E Tobs Tmean Cdd 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 4 I O eo Co Co Co co oy m G A aa G G an G G m G G a G n 10 1N i I gt Mo 4 gt MA Sheeti lt Sheet f Sheet3 f kk mM Draw e Autoshapess Noy Co Ad iid E Gl ee AW SS ie 15 If you scroll to the right you will find the title for Column M is Prep which is a standard abbreviation for precipitation The data contained in this column is the daily precipitation recorded by the Jasper INNW weather station In this project we don t need other meteorological data except precipitation Therefore delete all 99 66 other columns but the columns year month day and prep 19 EJ Microsoft Excel jasper_precip Sele E File 40 4 4 F Draw Y 16 I7 Edit wiew Insert Format Tools Data Window Help Adobe POF Type a question For help F X PETET ETES E p Security A 36 be oo E 0 0 0 0 0 3 0 0 0 51 anon 40 a H Sheet1 Sheet2 f Sheets lt lg AutoShapes No Oe ila al 23 8 Ge co i A Ge 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 4 After this step we will change the precipitation values from inches to mm which is the u
20. nit SWAT uses But before we do this we have to contend with the cells that have missing values or text If you scroll down you will find in the Prep column that some cells are empty for example in June of 1981 and December of 2003 and some cells contain 999 99 These dates have missing values Other cells have a T which stands for a trace of precipitation which we will treat as a zero value In SWAT a missing value for precipitation should be 99 0 see page 102 of the SWAT User s Manual but when we make the unit conversion that will change the value For the moment we will replace the missing values with 1000 Use Edit Replace to change all 999 99 to 1000 and to change all to 1000 Use the same procedure to change all T to 0 In this step we need to convert the precipitation into mm To the right of the Prep column create new column named as Prep mm and use a formula to multiply the value in inches by 25 4 20 EJ Microsoft Excel jasper_precip Sele e Fie Edit wiew Insert Format Tools Data window Help Adobe POF Type a question For help F X PTET TET ETEEN HT 19580 19580 1960 1960 1580 1960 1960 1580 19580 1960 1960 19580 1960 1960 1580 19580 1960 0 51 100r ol a M E at T z E a a o h Sheet1 Shest2 f Sheets Is M Draw L AutoShapess S a COO all os a fs re i A ae a g a i u uu ee ee a ee ee ee ee e
21. ork C Writing precipitation gage location table When the local measured precipitation data are to be used in SWAT a precipitation gage location table is required to provide the locations of the rain gages This table should be a dBase file The format required by SWAT ArcView interfaces is described on page 19 of AVSWAT User s Manual Normally ArcView is used to prepare this type of gage location table 1 Open ESRI ArcView as a blank project if it is not already open 2 Click on Table 25 2 ArcView GIS 3 2 File Project Window Help a 3 Click New and navigate to the directory where contains the processed precipitation file pcpjasp txt Then type locpcp dbf in the File Name box New Table File Hame Directories locpcp dbf c courses crss861 0 foo A gt courses 4 epa total maximum daily Drives c 4 Click OR For your project both files should be placed in the user data directory 26 2 ArcView GIS 3 2 File Edit Table Field Window Help le 0 of 0 selected d locpcp dbf TERRE oa 5 Now we are to add the Jasper 1 NNW precipitation gage into the precipitation gage location table According to SWAT User s Manual each gage station occupies one row in which there are 5 fields They are ID NAME LAT latitude LONG longitude and ELEVATION The latitude and longitude should be in degrees and the elevation should
22. ow contains the meteorological data from Jasper INNW without blank rows 17 Ed File Edit RREA oe ELEA eee 10 a B Z UJ Arial EJ Microsoft Excel Book3 View Insert Formak Tools Data Ee iil GE window FA fe A ae ee ee ee ee 1 COORID WBANID Prelim 94648 94645 94649 5 GARAGE 6 94648 94649 8 4648 9 94648 94645 94649 94648 94648 94649 94648 94648 94645 94649 10 Bam aoa ld E Ready 99999 99999 99999 99999 gogg 99999 99999 99999 99999 99999 99999 ee be ee bee 99999 ogaoga 99999 29999 m nann 4 HM Sheeti Sheet Sheet3 lg AutoShapess N a C Oea a ll 233 al Gg oo ok A SS Oe year 1950 1980 1900 1900 1980 1950 1900 1580 1950 1900 1900 1980 1950 1900 1580 1950 1960 Mort Adobe PDF TETRAMER Type a question For help Sets r _ fF X p Security 3h le Ge a a a Tmax Tmin Tobs 45 J2 J36 2 5 25 4h J 56 29 49 i al 49 a4 a4 5 a4 ZA 25 G 42 18 J36 T 42 30 40 g 45 af 40 z 45 38 40 10 45 J8 a 11 46 40 44 12 Ad 30 35 13 4 J2 J6 14 49 J6 45 15 55 J2 J7 16 BO 99999 55 1 55 40 s0 d 15 a py em P lt il a g MUM Tmean J Form 14 Click File Save As to save the current Excel workbook to a new name say jasper_precip xls Then close the old data file for future use From now on we ll work on the newly created Excel workboo
23. rmat General General converts numeric values to numbers date Text i values to dates and all remaining values to text O bate MDY we Do not import column fskip Data preview COOPID WEANID er rear TECT i O346465 E TECT is ECTE is 6 Click Finish 7 Ifyou scroll down a little bit you will find there is a blank row after the observations for the first month of 1980 shown in the figure below As a matter of fact there is 13 always a blank row after the observations of each month First we need to get rid of these blank rows EJ Microsoft Excel 151899640758 iE Fie Edit view Insert Format Tools Data window Help Adobe PDF Type a question For help be eS Sh e Oe BL ELE ile app 100 tai pe fe A iP Security A 3 We Go i fe COOPID ee bee 1950 99999 1900 99999 1900 99999 1980 EEEE 1950 agg 1900 9999 1900 99999 1980 99999 1950 99999 1900 99999 1900 99999 1950 99999 1900 99999 1900 be be 1950 ee bee 1950 99999 1900 AAA AO A0 GAAT MH 4 gt MA 151899640758 A lt i Draw 3 AutoShapes r N o CO OF l 2 8 Ll amp vw A Ses ee 8 As shown below Select the entire worksheet and click Data Filter AutoFilter 14 Al J Microsoft Excel 151899640758 29 File Edit view Insert Format Tools Oh Sh ah 10 BZ 9 Click on the downward arrow that is to the right of the column head of
24. the first column COOPID from the drop down list select Nonblank Bc Inbox Microsoft Out Window Help Adobe PDF z 73 Eli AutoFilter tt Show All A B C Advanced Filter COOPIL WBANI Prelim v year yim robs 94646 99999 43 32 94648 99999 1 51 25 94648 99999 1 56 29 94648 99999 1 49 34 94646 99999 1 34 26 94646 99999 1 42 18 94645 99999 1 42 30 94648 99999 1 43 37 94646 99999 1 43 38 94646 99999 1 45 38 94646 99999 1 48 40 94645 99999 1 44 30 94646 99999 1 42 32 94645 99999 1 49 36 99999 1 55 32 99999 1 60 99999 99999 1 55 46 99999 1 66 50 99999 1 65 31 99999 1 63 32 S9999 1 55 36 99999 1 50 41 99999 1 46 28 99999 1 55 17 99999 1 55 32 99999 1 48 39 99999 1 45 40 99999 1 52 30 99999 1 44 30 99999 1 32 22 M 4 gt 151899640758 i a Ch Customize local preci 15 ti jag 100 OB p Security J 3 gt kZ oe 0 0 0 0 0 0 0 0 0 0 DOO 1 C6565 C637 on GS ome W ar X mm KG cn 7 2 Internet Explorer Type a question for help hd Flag Snow Fle 0 35 0 0 0 35 0 05 0 0 0 33 0 07 0 0 0 8 0 0 3 0 0 0 51 0 6 0 0 0 0 13 1 42 0 04 o00 Sum 1747571690 Te C0565 GA mm G es palea ga wa Eiran KA on ES ose W ar OX mmm e cen D vea g e Por C63 5657 Ce sea amp 3 SD Sy 12 28PM Eq Microsoft Excel 151899640758 e File Edit View Insert Format Tools Data Window
25. ue pou wish fo fine j kF if Recoil d eA OLS Confrolled Stations Cnlp Af This Time List of Stations with Photocraphs Available On Line WabCHSery Version 2 5 Ke Internet 4 Click the SEARCH button the following Station List webpage shows there are three weather stations in the City of Jasper GA NCDC Station List Microsoft Internet Explorer Seles File Edit View Favorites Tools Help AN QO sect re 2 A P Search Ip Favorites E3 A in rel ED J Dictionary E T Thesaurus GA Word of the Day S NVCDC Clmate Radar Data Inventories Locate Station Search Station List 3 station s found with Georgia Name City or Alias matching Jasper Ga Access Thatal ASCH Data For Tlus Group of Stations Select mdividual station below to access data for that station NCDC May Not Have Received Any Data for Some of these Stations Station Mame City State or Province Couniry UPS Sign iea Period of Record WEAN ACS Jasper ol May 19 1959 OF Aue 2002 094651 Jasper GA United States Pickens County Jasper 1 NNW O1 Jul 1948 Present 094648 Jasper GA United States Pickens County Jasper 7 W 0l Aug i94 28 Feb 1952 094633 i Jasper GA United States Pickens County Internet 5 In the column Period of Record only the second station Jasper 1 NNW contains data up to the present The other two weather stations were out of service at least 3 years ago Therefore click on J
Download Pdf Manuals
Related Search