National Water Information System Wizard NWiz - Software page

Release Date:

Documentation

NWiz can create user specified water-quality site lists or or can make site lists from queries based on state or latitude logitude box. The program also can use site lists generated in other applications.The program can then download site headers and site data for all the sites listed in a site list. These data can then be graphed and evaluated in a number of different ways.

Version 1.0.0

Cialowicz, M.P., and Granato, G.E., 2006, National Water Information System Wizard NWiz (Version 1.0)--A program for retrieval and examination of information and data from the U.S. Geological Survey National Water Information System-- Appendix 1 in Granato, G.E., 2006, Kendall-Theil Robust Line (KTRLine--version 1.0)—A visual basic program for calculating and graphing robust nonparametric estimates of linear-regression coefficients between two continuous variables: Techniques and Methods of the U.S. Geological Survey, book 4, chap. A7, 31 p.             Report On-Line          Compiled Software On-Line

Cialowicz, M.P., 2006, National Water Information System Wizard NWiz (Version 1.0) Help File in Granato, G.E., 2006, Kendall-Theil Robust Line (KTRLine--version 1.0)—A visual basic program for calculating and graphing robust nonparametric estimates of linear-regression coefficients between two continuous variables: Techniques and Methods of the U.S. Geological Survey, book 4, chap. A7, 31 p. NWIZHELP.HLP

Version 1.0.1

Cialowicz, M.P., and Granato, G.E., 2009, National Water Information System Wizard NWiz (Version 1.0)--A program for retrieval and examination of information and data from the U.S. Geological Survey National Water Information System-- Appendix 1 in Granato, G.E., Carlson, C.S., and Sniderman, B.S., 2009, Methods for development of planning-level estimates of water quality at unmonitored stream sites in the conterminous United States: Washington D.C., Federal Highway Administration Report FHWA-HEP-09-003, CD-ROM. Report On-Line

Software

Abstract

The National Water Information System Wizard (NWiz Version 1.0) is a computer application written to automatically retrieve information and data from the U.S. Geological Survey National Water Information System (NWIS). NWISWeb is an on-line database containing millions of water-quality measurements. NWiz is written in Microsoft Visual Basic 6.0 and has a simple interface that follows standard Microsoft Windows interface conventions. NWiz can be run to retrieve sampling-site information and data for an individual water-quality monitoring site or can be run in batch mode to retrieve information and data for multiple sites. The program works by translating the users input to structured query language commands that are transmitted over the internet to retrieve data. The program has a utility for finding sampling-site information within a geographic area and provides the ability to view graphs and summary statistics of the data from each site that is retrieved from NWISWeb. Inputs to NWiz include the current NWISWeb internet address, the target directory for downloaded files, U.S. Geological Survey (USGS) site numbers, and the NWIS parameter codes for the water-quality constituents of interest. Output from NWiz includes NWIS site information (header) files in a relational database (RDB) format, site data files in RDB format and in the Kendall-Theil Robust Line (KTRLine) input-file format, a “MissedFiles.txt” file to indicate sites that were not properly downloaded, and a “MissedData.txt” file to indicate sites that did not have the requested data. NWiz has a comprehensive help file that provides information about the use of the program.

The NWiz software is a Visual Basic program that provides several choices for processing NWISWeb data. The program is used to retrieve NWISWeb site information or water-quality data files of a specific format by translating user input to the appropriate SQL commands that are transmitted over the internet to retrieve data. The user interface consists of an introductory screen identifying the program, a main menu form, a program options form, and 10 special purpose forms. NWiz can be run to download files for individual sites or can be run in batch mode for multiple sites. The NWiz software, if installed properly, should be compatible with Microsoft operating systems

History

NWiz version 1.0.0 - Initial release. October 1, 2006

NWiz version 1.0.1 - Second release. December 15, 2009 The code for generating queries were changed to adapt to changes in NWIS WEB

System Requirements

The NWiz program is written in Visual Basic 6.0 and therefore use is limited to Microsoft Windows operating systems. To use NWiz you need a connection to the internet. For best results the connection speed should exceed 128 kilobytes per second. The graphical display forms require a screen reolution exceeding 1024 x 768 pixels.

Data Requirements

NWiz uses an initialization file, a site list file, and a parameter list file. The initialization file loads user-defined options. The initialization file is created by NWiz each time the user changes program options. The site list file is simply a text file with one USGS monitoring station number on each line. The user can create a site list file manually, by using the NWiz site-selection utility, or by using the Surface-Water Quality Data Miner. The parameter list file is simply a space-delimited text file with the USEPA 5-digit parameter code, a space, and the parameter name. The parameter codes in the list file must be sorted in ascending order. The user can create a site list file manually or by using the Surface-Water Quality Data Miner.

Input:

Test Queries:

The program creates NWIS WEB queries to obtain the data. The NWIS WEB team may change the query language. The following test queries can be used to determine if the queries have been changed. Contact the author to update the internal query syntax

Output:

The program creates several output files including a station list file (example above), RDB station header files pulled from NWIS WEB (with information about the station), RDB water-quality data files pulled from NWIS WEB, and Kendall-Theil Robust Line input files.

Source Code (Version 1.0.1)

  • Install.zip (2.4 MB) A compressed "zip" file containing the installation files
  • Package.zip (2.4 MB) A compressed "zip" file containing the support package that can be used to create a new installation package
  • VB6Code.zip (45 KB) A compressed "zip" file containing the Visual Basic 6.0 source code, which can be read with a text editor.

Support

Support for this software includes limited software support and compilation of suggested improvements. Only limited assistance can be provided for applying NWiz to specific problems. Limited support is provided for correcting bugs and clarification of how the code is intended to work. For a current list of known bugs and suggestions for improvement click here. For support or to provide feedback or suggestions for improvement, contact: Gregory E. Granato.

 

User Rights

This software and related material (data and documentation) are made available by the USGS to be used in the public interest and the advancement of science. You may, without any fee or cost, use, copy, modify, or distribute this software, and any derivative works thereof, and its supporting documentation, subject to the USGS Software User Rights Notice

Product Disclaimer

Any use of trade, product, or firm names is for decriptive purposes only and does not imply endorsement by the U.S. Government