1.  Download/Format Stations Data 
* Go to http://nwis.waterdata.usgs.gov/fl/nwis/qwdata
* Click County box.  Submit.
* Select all counties.
* Click radio button next to Site-description informaiton displayed in.  Select drop down menu option "--saved to file".  
* Select Agency, Site ID#, Site Name, Decimal latitude, decimal longitude.  Click submit.
* Save file as Stations_4digityear_original.txt
* Cut off all header information and save as Stations_4digityear.txt

2.  Run createtable_USGS_STATIONS_RAW.txt - You will need a username/password with appropriate privledges.

3.  In Toad, go to Database>Import>SQL *Loader Wizard.  Load existing control file:  Stations_2008_RAW.CTL (need to update each year).

4.  Update USGS_STATIONS_RAW table
*  Org_ID:  Set to 112WRD
*  Identification_Cd:  No changes needed
*  Name:  No changes needed
*  Lat:  No changes needed
*  Long:  No changes needed
*  Sta:  Set to ORG_ID||Identification_Cd (see below script)
update storet1.usgs_stations_raw RS
Set STA = RS.ORG_ID||'  '||RS.IDENTIFICATION_CD
*  Sta_Station_Key:  create sequence (see below scripts)
CREATE SEQUENCE sta_seq INCREMENT BY 1 START WITH 9984000001;
Update STORET1.USGS_STATIONS_RAW Set STA_STATION_KEY = sta_seq.nextval;
*Rename USGS_STATIONS_RAW table to USGS_STATIONS_2008

5.  Download/Format Results
* Go to http://nwis.waterdata.usgs.gov/fl/nwis/qwdata
* Click box next to County
* Pick one county at a time.  
* Click radio button next to Tab-separated data
* Drop down the following menus choices:  one result per row, default attributes, MM/DD/YYYY, save to file.  Click Submit and save file.  
* Remove all header information.  
* Repeat for all counties.


6.  Run create_usgs_results_2008_table.txt - You will need a username/password with appropriate privledges.

7.  In Toad, go to Database>Import>SQL *Loader Wizard.  Load existing control file:  2008Load.CTL (need to update each year).  


Notes for next year - 
* Download Station type
* Download MDL







































Step3:  Update STORET1.USGS_STATIONS_RAW Set ORG_ID = '112WRD'

Step4:  Update STORET1.USGS_STATIONS_RAW Set STA = ORG_ID||'  '||IDENTIFICATION_CD