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


Page Loading - Please Wait...

Click to hideNews Bulletins

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.