Warning: Javascript must be enabled to use all the features on this page!


Page Loading - Please Wait...

Click to hideNews Bulletins
  • Try our new Mobile-friendly water data site from your mobile device!
  • Full News RSS icon
  • Water Quality Samples for the Nation

    Help home page Navigation help Search criteria help
    Output formats help Codes help Parameter help

    Output Formats

    Standard Options

    Show sites on a map

    This output provides a map view of the locations of sites with USGS water data that meet the specified Search Criteria. Google Maps are used to provide speed and versatility in a format that is familiar to many users. Instructions for the sites mapper can be found here.

    List of sites

    A list of Sites with their agency code, Site ID, and station name will be displayed in an HTML table. You can select to have the sites grouped by county or by hydrologic unit code. You can also sort the sites by the USGS site number or by the station name

    Scroll list of sites

    A list of sites will be presented in a pick box, allowing you to choose multiple sites and a new output format.

    Brief descriptions

    A list of sites with some basic information about each site will be presented. You can then choose which sites you want more information on. Each site has basic information like this:

    USGS 15290100 L SUSITNA R NR HOUSTON AK

    Matanuska-Susitna Borough County, Alaska
    Hydrologic Unit Code 19020505
    Latitude 61°37‘36", Longitude 149°48‘03" NAD27
    Drainage area 168.00 square miles
    Contributing drainage area square miles

    In addition to the site information, for those searches that are used to locate data, such as streamflow or water-quality data, a table showing the dates of the first and last observation and the total number of observations is displayed.

    USGS 15290100 L SUSITNA R NR HOUSTON AK
    Matanuska-Susitna Borough County, Alaska
    Latitude  61°37‘36", Longitude 149°48‘03" NAD27
    This site is a Surface Water station.
    Period of record
    Begin End Count
    02/12/1972 07/27/1983 4
    Save file of selected sites to local disk for future upload

    All sites that match your criteria will saved in a tab-separated format into a file you specify. You can then use this file on a later retrieval to get data on just the sites you want.


    Data specific options


    Site inventory data options

    Detailed descriptions with links to available data for each site

    If Station manuscript information is available for a site, a link to the data is provided.

    HTML table

    All sites that match query are presented in an HTML table. The column headers are selectable by a select box.

    Tab-separated data file

    All sites that match query are presented in a tab-separated data file. The column headers are selectable by a select box. A compressed format is available. Explanation of output codes can be found here. For Compressed file, save the file with a .gz extension.

    Daily-value streamflow data options

    Graph of daily-value streamflow data

    Graphical image of daily value data. Data can be retrieved in tab-separated format if desired.

    Tab-separated data file

    All data that match query are presented in a tab-separated data file. The data can be in various date formats and it can be downloaded in a compressed format. Explanation of data value qualification code (dv_cd).

    Daily-value Streamflow Statistics

    Daily-value streamflow statistics data options The following statistics are available for each station
    CodeDescription
    begin_yr_dtFirst complete year of data
    end_yr_dtLast complete year of data
    max_mean_vaMaximum daily mean value for this day
    min_mean_vaMinimum daily mean value for this day
    count_nuNumber of daily mean values for this day
    mean_vaMean of daily mean values for this day
    p05_va05 percentile
    p10_va10 percentile
    p15_va15 percentile
    p20_va20 percentile
    p25_va25 percentile
    p30_va30 percentile
    p35_va35 percentile
    p40_va40 percentile
    p45_va45 percentile
    p50_va50 percentile (median)
    p55_va55 percentile
    p60_va60 percentile
    p65_va65 percentile
    p70_va70 percentile
    p75_va75 percentile
    p80_va80 percentile
    p85_va85 percentile
    p90_va90 percentile
    p95_va95 percentile
    HTML table

    The selected statistic is shown in an HTML table. The columns are each month, and the rows are each day.

    Tab-separated data

    All data that match query are presented in a tab-separated data file. The data can be in various date formats and it can be downloaded in a compressed format.

    Published Peak Streamflow Data

    Graph

    Graphical image of peak streamflow data. Data can be obtained in other formats.

    Formatted table

    Data is output in an HTML table.

    Tab-separated data

    All data that match query are presented in a tab-separated data file. The data can be in various date formats and it can be downloaded in a compressed format.

    WATSTORE standard format

    Data stored in this format is in a "card" format. Thus, data is in a column format and care should be taken to make sure everything is in the correct column.

    Columns Description
    1 Card format number. Data is contained in the 3 format
    2-16 Station number
    17-20 Calendar year -- a 4-digit number representing the actual calendar year of the annual peak streamflow; if columns 21-22 are blank, this field is assumed to be a water year.
    21-22 Month -- a 2-digit number representing the month of the annual peak streamflow. For example, March is coded as 03.
    23-24 Day -- a 2-digit number in the range 01-31 representing the day of the month of the annual peak streamflow.
    25-31 Annual peak streamflow in cubic feet per second -- the value has a decimal point, and significant digits to the right of the decimal point where needed. Whole numbers need no decimal point. Blank fields are interpreted as no data available.
    32-43 Annual peak streamflow qualification codes -- This field contains 1-column fields in which from none to 12 codes can be used. There are a total of 14 single- character codes presently available.
    44-51 Gage height associated with annual peak streamflow -- the value is punched with a decimal point, and significant digits to the right of the decimal point where needed. Whole numbers need no decimal point. Blank fields are interpreted as no data available.
    52-55 Gage height qualification codes -- four 1-column fields in which none to 4 qualification codes can be used. There are a total of 6 single-character codes presently available.
    56-59 "Highest since" year -- a 4-digit number representing the calendar year after which the given peak streamflow (cols. 25-31) is known to be the highest. This year is determined from historic newspaper accounts, local information, or other sources.
    60-75 Annual peak gage height information. These columns contain four fields for the annual peak gage height, to be coded if the maximum gage height for the water year is not that associated with the maximum streamflow.
    76-80 Blank.

    Definitions and terms of peak output

    Data Element Description
    Peak flow The maximum streamflow value for the year.
    Gage height Gage height for the maximum streamflow.
    Gage height qualification codes 1 - gage height affected by backwater
    2 - gage height not the maximum for the year*
    3 - gage height at different site and(or) datum
    4 - gage height below minimum recordable elevation
    5 - gage height is an estimate
    6 - gage datum changed during this year
    * If code 2 is given here, there should be date and data entries for the maximum annual gage height.
    Peak streamflow qualification codes 1 - streamflow is a maximum daily average
    2 - streamflow is an estimate
    3 - streamflow affected by dam failure
    4 - streamflow less than indicated value, which is minimum recordable streamflow at this site*
    5 - streamflow affected to unknown degree by regulation or diversion**
    6 - streamflow affected by regulation or diversion**
    7 - streamflow is a historic peak***
    8 - streamflow actually greater than indicated value
    9 - streamflow due to snowmelt, hurricane, ice-jam or debris dam breakup
    A - year of occurrence is unknown or not exact
    B - month or day of occurrence is unknown or not exact
    C - all or part of the record affected by urbanization, mining, agricultural changes, channelization, or others
    D - base streamflow changed during this year
    E - only annual maximum peak available for this year
    * Code 4 cannot occur simultaneously with codes 1, 2, 3, 7, or 8.
    **Codes 5 and 6 cannot occur simultaneously.
    ***Code 7 should indicate that the value for the particular year is a historic peak and the particular year occurred before or after the systematic record, or during a break in the systematic record.
    Highest since year Peak streamflow reported is the highest since this year.
    Annual peak stage Maximum stage for the water year.
    Peak stage month Month of peak stage.
    Peak stage day Day of peak stage.
    Peak stage qualification code 1 - gage height affected by backwater.
    3- gage height at different site and(or) datum
    5- gage height is an estimate.
    6 - gage datum changed during this year
    Partial duration peak streamflow(s) Each peak streamflow less than annual maximum peak streamflow but higher than base streamflow in Site File
    Partial duration peak time(s) Time of each partial duration peak streamflow.
    Partial duration peak stage(s) Each peak stage less than annual maximum stage.
    Partial duration peak stage qualification codes 1 - gage height due to backwater
    3 - gage height at different site and(or) datum
    4 - gage height below minimum recordable elevation
    5 - gage height is an estimate
    6 - gage datum changed during this year.
    Partial duration peak streamflow qualification codes 1 - streamflow is a maximum daily average
    2 - streamflow is an estimate
    3 - streamflow affected by dam failure
    4 - streamflow less than indicated value, which is minimum recordable streamflow at this site
    5 - streamflow affected to unknown degree by regulation or diversion
    6 - streamflow affected by regulation or diversion
    7 - streamflow is a historic peak
    8 - streamflow actually greater than indicated value
    9 - streamflow due to snowmelt, hurricane, ice-jam, or debris dam breakup
    A - year of occurrence is unknown or not exact
    B - month or day of occurrence is unknown or not exact
    C - all or part of the record affected by urbanization, mining, agricultural changes,channelization, or others
    D - base streamflow changed during this year
    E - only annual maximum peak available for this year

    Streamflow Measurement Data

    Unused Measurements

    Under certain circumstances, a hydrographer may call a field discharge measurement unused. Reasons could include instrument failure, inability to complete the discharge measurement, or the presence of a second measurement made at the same condition on the same day (known as a check measurement). The existence of an unused measurement is shown in the display so as to not leave a gap in the measurement numbering, but the details of the measurement are left blank. Please contact the local water science center for more information on a particular unused measurement.

    Graph

    Graphical image of streamflow measurement data. Data can be obtained in other formats.

    Formatted table

    Data is output in an HTML table.

    Tab-separated data

    All data that match query are presented in a tab-separated data file. The data can be in various date formats and it can be downloaded in a compressed format. The tab-separated output file column names and definitions are shown in the following table.

    Tab-separated Output Column Name Formatted Table Output Column Name Description Link to additional Information
    agency_cd Not Included agency code Possible code values
    site_no Not Included site number  
    measurement_nu Meas.Number measurement number  
    measurement_dt Date/Time date of measurement (format = MMDDYYYY or Month/Day/Year. The user has options for the data output format)  
    tz_cd Time Zone Codes Time zone offset. An ANSI SQL/92 time zone offset string. Some examples are '-07:00' (Eastern), '+02:00' (Eastern Europe), and '+03:30' (India). Possible code values
    q_meas_used_fg Measurement used? Flag indicates if the discharge measurement is marked used.  
    party_nm Who an indication of who made the measurement and is usually populated with a pair of initials separated with a slash  
    site_visit_coll_agency_cd Agency What agency made the measurement at the site visit Possible code values
    discharge_va Streamflow the computed discharge in cubic feet per second (cfs)  
    gage_height_va Gage Height gage height as shown on the inside staff gage at the site or read off the recorder inside the gage house in feet  
    current_rating_nu Rating No. The number of the rating used to calculate the streamflow from the gage height  
    shift_adj_va Shift Adj. The current shift being applied to the rating (feet)  
    diff_from_rating_pc % Diff. The percent difference between the measurement and the rating with the shift applied  
    gage_va_change GH Change The amount the gage height changed while the measurement was being made in feet  
    gage_va_time Meas. Duration The amount of time elapsed while the measurement was being made in decimal hours  
    measured_rating_diff Meas.Rated measurement rating codes that denote the relative quality of the measurement Possible code values
    control_type_cd Control condition of the rating control at the time of the measurement Possible code values
    discharge_cd Flow Adjust. Code The adjustment code for the measured discharge Possible code values
    chan_nu Channel Number The channel number  
    chan_name Channel Name The channel name  
    meas_type Measurement Type The channel measurement type Possible code values
    streamflow_method Streamflow Method The channel discharge measurement method Possible code values
    velocity_method Velocity Method The channel velocity measurement method Possible code values
    chan_discharge Channel Flow The channel discharge in cubic feet per second  
    chan_width Channel Width The channel width in feet  
    chan_velocity Channel Velocity The mean velocity in feet per second  
    chan_area Channel Area The channel area in square feet  
    chan_stability Channel Stability The stability of the channel material Possible code values
    chan_material Channel Material The channel material Possible code values
    chan_evenness Channel Evenness The channel evenness from bank to bank Possible code values
    long_vel_desc Long. Vel. Desc. The longitudinal velocity description Possible code values
    horz_vel_desc Horz. Vel. Desc. The horizontal velocity description Possible code values
    vert_vel_desc Vert. Vel. Desc. The vertical velocity description Possible code values
    chan_loc_cd Channel Loc. Code The channel location code Possible code values
    chan_loc_dist Channel Loc. Dist. The channel location distance  

    Groundwater site inventory data options

    Detailed descriptions with links to available data for each site

    Station manuscript information. If data is available for a site, a link to the data is available.

    HTML table

    All sites that match query are presented in an HTML table. The column headers are selectable by a select box.

    Tab-separated data file

    All sites that match query are presented in an HTML table. The column headers are selectable by a select box. A compressed format is available.

    Groundwater level data options

    Graph(s) of Groundwater level data

    Groundwater level data is presented in a gif image.

    HTML table of Groundwater level data

    Groundwater level data is presented in an HTML table.

    Code Name Explanation
    NGVD29 V Datum of 1929 National Geodetic Vertical Datum of 1929
    NAVD88 V Datum of 1988 North American Vertical Datum of 1988
    OLDAK Old Alaska Old Alaska (Mainland) and Aleutian Island Datum
    OLDPR Old PR & VI Old Puerto Rico and Virgin Island Datum
    HILOCAL Hawaii Local Local Hawaiian Datum
    GUVD04 Guam Datum Guam Vertical Datum of 2004
    ASVD02 Am Samoa Datum American Samoa Vertical Datum of 2002
    NMVD03 N Marianas Datum Northern Marianas Vertical Datum of 2003
    TIDELOCAL Tidal Local Local Tidal Datum
    COE1912 COE Datum 1912 U.S. Corps of Engineers datum adjustment 1912
    IGLD Gr Lakes Datum International Great Lakes Datum
    ASLOCAL *Am Samoa Local Local American Samoa Datum
    GULOCAL *Guam Local Local Guam Datum
    Tab-separated data file

    Groundwater data is presented in a tab-separated data file. The data can be in various date formats and it can be downloaded in a compressed format.

    Water Quality Samples Options

    Parameter Group Period of Record table

    This table summarizes what data are available for a group of related parameters for each selected site.

    Date Retrieval

    The output of data may be restricted to a specific date range. Leaving this field blank retrieves all available samples. A time zone datum is associated with each sample date. You may either choose to view the stored time datum for each sample or you may request that all sample times be converted to the Coordinated Universal Time (UTC) datum.

    Samples and parameters to include

    If a list of sites was found by requesting sites that include one or more samples using a list of selected requested parameter codes, then output of samples for these sites may be requested using the same list of parameter codes. After the list of sites has been retrieved and listed in one of the output of sites formats, use the back button on your browser. Then select "Only samples that include site selection parameter (Count: xx)". The count value "xx" lists the number of parameter codes you previously requested. Choose the output format (table of data, inventory, tab-separated data) and submit.

    To retrieve all samples and results for the period of record for each site found in the site selection step, choose "All samples and all parameters".

    To select samples and results that contain one or more parameters from a range of parameter codes entered, choose 'Samples that include one or more of these parameters' and enter a range of parameter codes in the box below. Example of format: 00001-00200. The maximum number of parameter codes that will be retrieved is 200.

    A complete list of parameter codes, associated groupings can be found here.

    Table of data

    Water-quality sample data are presented in an HTML table, with one sample per row. Two output options determine the contents of the output:

    Inventory of water-quality data

    A summary of all parameters available for each site is listed and includes the number of available results for each parameter and the date range of data for that parameter. Two output options are available:

    Tab-separated data files

    There are multiple output formats available, each with multiple date format options. These files may be viewed in your browser or can be written to your computer desktop. File output can be requested in an uncompressed or compressed format ("zipped"). Output formats available are:

    Examples of output

    Output-column changes for water-quality results where each row represents one measurement, specified by URL argument: "&qw_sample_wide=0", are summarized in the table below.


    Previous version New version
    agency_cd agency_cd
    site_no site_no
    sample_dt sample_dt
    sample_tm sample_tm
    -- sample_end_dt
    -- sample_end_tm
    -- sample_start_time_datum_cd
    -- tm_datum_rlbty_cd
    coll_ent_cd coll_ent_cd
    medium_cd medium_cd
    -- tu_id
    -- body_part_id
    parameter_cd parm_cd (column name changed)
    remark_cd remark_cd
    result_va result_va
    -- val_qual_tx
    meth_cd meth_cd
    anl_stat_cd --
    anl_src_cd --
    hyd_cond_cd --
    samp_type_cd --
    hyd_event_cd --
    -- dqi_cd
    -- rpt_lev_va
    -- rpt_lev_cd
    -- lab_std_va
    anl_ent_cd anl_ent_cd

    Output-column changes for retrieval of water-quality results where each row represents one sample, specified by URL argument: "&qw_sample_wide=wide", are summarized in the table below.


    Previous version New version
    agency_cd agency_cd
    site_no site_no
    sample_dt sample_dt
    sample_tm sample_tm
    -- sample_end_dt
    -- sample_end_tm
    -- sample_start_time_datum_cd
    -- tm_datum_rlbty_cd
    -- tu_id
    -- body_part_id
    coll_ent_cd coll_ent_cd
    medium_cd medium_cd
    p00001 p00001
    p00002 p00002
    p00003 p00003
    ... ...

    Additional columns can be obtained in either the sample-based or the result-based layout of water-quality data by specifying the URL argument: "&rdb_qw_attributes=expanded". Information about the expanded attributes is listed in a table here. Retrieved date and time previously have been expressed in the local time zone of the sample collector, and continue to be expressed in local time by default. The expression of date and time can be converted to Universal Coordinated Time using the URL argument: "&TZoutput=inUTC". PLEASE Note: The use of UTC element is only available in Water Quality Data output.

    Parameter Code Definition options

    Formats

    Table format
    All parameter codes that match query are presented in a HTML table.
    Tab-separated data format
    All parameter codes that match query are presented in a tab-separated data file.
    Tab-separated data format --saved to compressed file
    All parameter codes that match query are presented in a compressed tab-separated data file. gunzip or winzip programs will be able to uncompress it
    Tab-separated format --saved to file
    All parameter codes that match query are presented in a tab-separated data file and you are prompted to save it to your hard drive

    Other Options

    Survey Email Address

    Entering an EMail Address is not required. If provided, you may be randomly contacted so USGS can determine your satisfaction with this system. If you enter this field, please enter a valid Email address where you can be reached.