Skip common site navigation and headers
United States Environmental Protection Agency
United States Environmental Protection Agency
STORET
Begin Hierarchical Links EPA Home > Water > Wetlands, Oceans, & Watersheds > Monitoring and Assessing Water Quality > STORET > Data Warehouse End Hierarchical Links

STORET Central Warehouse

STORET Warehouse Help

Overview of System

STORET Warehouse Application

Station Report
    Stations by Geographic Location
    Stations by Organization and Station ID

Result Reports
    Regular Result Report
    Biological Result Report
    Habitat Result Report
    Results by Geographic Location
    Results by Station
    Results by Project

Selection Criteria for Result and Station Reports
    Geographic Location Selection Overview
    Date Range Selection
    Characteristic Selection
    Activity Medium Selection
    Activity Intent and Community Sampled Selection
    Organization/Station Selection
    Organization/Project Selection
    Station Type Selection
    Organization Selection

Summary Pages

Station Search Summary Page
    Number of Stations Returned
    Search Parameter Values Summary
    Navigation Options for Stations
    Report Customization for Stations (Select Data Elements for Report)
    Station Group Elements
        Spring Info
        Latitude/Longitude
        Conv Latitude/Longitude
        Lat/Long Info
        Additional Elevation Info
        RF1 Info
        Estuary Info
    Station Data Elements

Result Search Summary Page
    Number of Results Returned
    Search Criteria for Results
    Navigation Options for Results
    Report Customization for Results (Select Data Elements for Report)
    Result Group Elements
        Station Location Info
        Station Lat/Long
        Conv Station Lat/Long
        Station Types
        Visit Start
        Visit Stop
        Activity Start
        Activity Stop
        Actual Activity Lat/Long
        Conv Actual Activity Lat/Long
        Additional Act Location Info
        Sample Preservation
        Additional Anal Proc Info
        Other Lab Info
        Net Tow Info
        Electroshock Info
        Net Non-Tow Info
        General Group Info
        Multi-Taxon Pop Census Info
        Single Taxon Group Summary Info
        Single Taxon Frequency Class Info
        Single Taxon Individual Info
    Regular Result Data Elements
    Biological Result Data Elements
    Habitat Result Data Elements

Watershed Summary
    Get Organization Summary and Download Results for One/All organizations
    Get Characteristic Type Summary and Download Results for Selected Characteristic Types

Download Results Page
    Download Results Page General
    Explanation of Result Report Format

Download Site Descriptions Page
    Download Site Descriptions Page General
    Explanation of Station Report Format

Download Your Compressed Data File

Retrieving Documents/Graphics

Glossary



Overview of System
    You are preparing to extract data from EPA's Modernized STORET Data Warehouse.  Data here have been provided to EPA through the voluntary contributions of many States, Federal Agencies, local organizations, Native American Tribes, volunteer groups, and other interested organizations.

    All data kept on this web site is fully documented with respect to field and laboratory methods employed, monitoring technologies used, project goals and plans, and QA/QC practices of the submitting organizations.  Questions concerning the specific data of any organization are best directed to the organization from which the data were obtained.

    EPA makes no warranty regarding the accuracy of the environmental data stored here.

    There are no fees or charges associated with the use of this site.

    The data on this web site are broken down into two major categories and they are Stations and Results.  The Station area has the selection options of Stations by Geographic Location and Stations by Organization and Station ID.  There are three groupings of Results: Regular, which are non-biological physical and chemical results, Biological, and Habitat.  Within each of these Result areas you have the option to select Results by Geographic Location, Results by Stations, or Results by Project.  Each one of these possible selections has a search criteria screen where you can streamline their query.

    For the Stations by Geographic Location option you will have the option to specify the type of data you want on your report or your search criteria.  The search criteria options are organized into several groups.  They are: Geographic Location, Station Types, Characteristics, and Organizations.  The available search criteria are:
     

    For the Stations by Organization and Station ID option you will have the option to specify the type of data you want on your report or your search criteria.  The search criteria options are organized into several groups.  They are: Organization/Station ID, Station Types, and Characteristics.  The available search criteria are:
     


    For each of the Result groupings there is a Results by Geographic Location option.  For this option you will be able to specify the type of data you want on your report.  The search criteria options are organized into several groups.  They are: Geographic Location, Date Ranges, and Characteristics.  In addition, for a Regular Results report one can select an Activity Medium and for a Biological Results report one can select Activity Intent and Community Sampled combination.  The available search criteria are:
     


    For each of the Result groupings there is a Results by Station option.  For this option you will be able to specify the type of data you want on your report.  The search criteria options are organized into several groups.  They are: Organization/Station, Date Ranges, and Characteristics.  In addition, for a Regular Results report one can select an Activity Medium and for a Biological Results report one can select Activity Intent and Community Sampled combination.  The available search criteria are:
     

    For each of the Result groupings there is a Results by Project option.  For this option you will be able to specify the type of data you want on your report.  The search criteria options are organized into several groups.  They are: Organization/Project, Date Ranges and Characteristics.  In addition, for a Regular Results report one can select an Activity Medium and for a Biological Results report one can select Activity Intent and Community Sampled combination.  The available search criteria are:
     
Top

STORET Warehouse Application

Station Report

Stations by Geographic Location
The Stations by Geographic Location page allows you to specify the selection criteria for your Station search.  There are four different selection criteria areas: Geographic Location Selection, Station Type Selection, Characteristic Selection, and Organization Selection.  Within each of the selection areas, you may accept the default values or enter/choose specific values as your search criteria.  After you have entered all of your selection criteria, click on the <Continue> button to perform the Station Search and proceed to the next page.  To reset all search criteria to default values, click on the <Clear Form> button.

Stations by Organization and Station ID
The Stations by Organization and Station ID page allows you to specify the selection criteria for your Station search.  There are three different selection criteria areas: Organization/Station Selection, Station Type Selection, and Characteristic Selection.  Within each of the selection areas, you may accept the default values or enter/choose specific values as your search criteria.  After you have entered all of your selection criteria, click on the <Continue> button to perform the Station Search and proceed to the next page.  To reset all search criteria to default values, click on the <Clear Form> button.

Result Reports
There are three categories of Result reports.  There is the Regular Result Report, the Biological Result Report, and the Habitat Result Report.  The Regular Result Report retrieves non-biological physical and chemical data.  The Biological Result Report and the Habitat Result Report retrieve biological and habitat data respectively.

Regular Result Report
The Regular Result Report consists of non-biological physical and chemical results data only.  Like the other two Result report pages, there are three selection criteria pages and they are Results by Geographic Location, Results by Station, and Results by Project.  The information on these pages is based on your specified selections.  For each of these pages you can narrow the scope by selecting specific criteria.  Each page provides Date Range and Characteristic selections.  The other selection criteria are specific for each page.

Biological Result Report
The Biological Result Report consists of biological data only.  Like the other two Result report pages, there are three selection criteria pages and they are Results by Geographic Location, Results by Station, and Results by Project.  The information on these pages is based on your specified selections.  For each of these pages you can narrow the scope by selecting specific criteria.  Each page provides Date Range and Characteristic selections.  The other selection criteria are specific for each page.

Habitat Result Report
The Habitat Result Report consists of habitat data only.  Like the other two Result report pages, there are three selection criteria pages and they are Results by Geographic Location, Results by Station, and Results by Project.  The information on these pages is based on your specified selections.  For each of these pages you can narrow the scope by selecting specific criteria.  Each page provides Date Range and Characteristic selections.  The other selection criteria are specific for each page.

Results by Geographic Location
The Results by Geographic Location page allows you to search for Results using these selection criteria areas for the three Result Reports (Regular, Biological, and Habitat Results): Geographic Location Selection,Station Type Selection, Date Range Selection, and Characteristic Selection.  For the Regular Result report you can also search for Results using Activity Medium Selection.  For the Biological Result there is an additional search for Activity Intent and Community Sampled Selection combinations.  Within each of the selection areas, you may accept the default values or enter/choose specific values as your search criteria.  After you have entered all of your selection criteria, click on the <Continue> button to perform the Result Search and proceed to the next page.  To reset all search criteria to default values, click on the <Clear Form> button.

Results by Station
The Results by Station page allows you to search for Results using these selection criteria areas for the three Result Reports (Regular, Biological, and Habitat Results): Organization/Station Selection,Date Range Selection, and Characteristic Selection.  For the Regular Result report you can also search for Results using Activity Medium Selection.  For the Biological Result there is an additional search for Activity Intent and Community Sampled Selection combinations.  Within each of the selection areas, you may accept the default values or enter/choose specific values as your search criteria.  After you have entered all of your selection criteria, click on the <Continue> button to perform the Result Search and proceed to the next page.  To reset all search criteria to default values, click on the <Clear Form> button.

Results by Project
The Results by Project page allows you to search for Results using these selection criteria areas for the three Result Reports (Regular, Biological, and Habitat Results): Organization/Project Selection,Station Type Selection, Date Range Selection, and Characteristic Selection.  For the Regular Result report you can also search for Results using Activity Medium Selection.  For the Biological Result there is an additional search for Activity Intent and Community Sampled Selection combinations.  Within each of the selection areas, you may accept the default values or enter/choose specific values as your search criteria.  After you have entered all of your selection criteria, click on the <Continue> button to perform the Result Search and proceed to the next page.  To reset all search criteria to default values, click on the <Clear Form> button.

The concept of National Projects is also supported by this selection criteria. Choosing the Organization selection "All Organizations (National Projects)" will populate the Project selection list with Projects where a common Project ID is shared across Organizations. Selecting one of these Projects will instigate data retrieval from the contributing Organizations.

Top

Selection Criteria for Result and Station Reports

Geographic Location Selection
The Geographic Location selection area is common to the Stations by Geographic Location and the three Results by Geographic Location reports (i.e. Regular, Biological, Habitat).  The Geographic Location selection area consists of three geographic selection options from which you can only select one: State/County, Latitude/Longitude, or Hydrologic Unit.  Click on the radio button next to the selection option that you wish to use to enter/choose specific values.

State/County Selection
The State/County Selection consists of the State Name list and the County Name list.  Select the state first, then counties.  The default values of "ALL" mean that no data is filtered based on state or county values.  Consequently, all result data are selected regardless of state and county values.

In the State Name list, the States and Territories of the United States are presented in alphabetical order.  They are followed by the States of Mexico and the Provinces of Canada in turn, each in alphabetical order within Country.  You may select any one state or province from this list by clicking once.

If you would like to select counties for the chosen state, click on the <Look Up> button to bring up the County Name list in a popup window.  You may select one county and click on the <Select> button.  You may select multiple counties by holding the <Ctrl> key down as you click on the additional rows or by holding the <Shift> key down as you click to select all the rows between the current row and the most recently selected row, and then click on <Select>.  While you are in the popup window, click on the <Cancel> button to close the window without selecting a county.

Latitude/Longitude Selection
The Latitude/Longitude selection allows you to specify search criteria based on a geographical area defined by maximum and minimum latitude (North Limit and South Limit) and longitude (West Limit and East Limit) entries.  If you choose to use the default values rather than your own entries, the search would retrieve data within the entire Northwest hemisphere.

The North Limit, South Limit, West Limit and East Limit define vertical and horizontal lines, respectively, that create the search area.  Station or Result data will be retrieved for Stations whose Point of Record is in or on the boundary of the defined area.  When a boundary is entered, let's say a northern boundary, an imaginary line is drawn around the world at that latitude.  Any Stationís Point of Record above this line will not be included in the report.  Any Stationís Point of Record on or below this line will be included in the report.  The defining of all four boundaries creates a box shape.

There can be many location points other than the Point of Record that are associated with the Station (e.g., Sampling, Boundary, Transect Sampling).  None of these other point types are considered when determining if a Station and its associated data will be included in a report.  However, all data, even for those points falling outside of the defined area, will be included in the report if the Stationís Point of Record has been included.  The following exhibit is a pictorial example representing boundary limits and fictitious Station location points on the state of Texas.

In the example, the shaded area represents the geographical area defined by the four boundary limits.  There are four data retrieval scenarios depicted as follows:

  • The Point of Record for Station A is entirely within the defined geographic area.  All sampling information associated with Station A will be included in the report.
  • The Point of Record for Station B is entirely within the defined geographic area.  All sampling information associated with Station B will be included in the report.  This includes the Sampling Point for Station B because the Point of Record for Station B is within the defined geographic area.
  • The Point of Record for Station C is on the boundary of the defined geographic area.  All sampling information associated with Station C will be included in the report.  If there were Sampling Points for Station C, they would also be included regardless of their location.
  • The Point of Record for Station D is outside the defined geographic area.  All sampling information associated with Station D will not be included in the report.  If there were Sampling Points for Station D, they would not be included regardless of their location.
Each boundary limit should be entered as a value in Decimal Degrees.  Position the cursor into the field you want to change and enter the desired value.

Drainage Basin/HUC Selection
The Drainage Basin/HUC (Hydrologic Unit Code) Selection allows you to specify the HUC within which you would like to search for Results or Stations.

To select a HUC, click on the <Look Up> button to bring up the HUC list in a popup window.

You may select any one HUC from this list by clicking once.

HUC is an optional field in STORET and may be missing for certain Station Descriptions.  Therefore, when searching for data by HUC, it's possible that not all Stations will be retrieved in the area of interest.

Top     Result Reports    Station Report

Date Range Selection
The Date Range selection area appears in all the Result Selection Criteria pages.  It allows you to select up to four different date ranges.  If the Activity Start Date falls within any of the date ranges then the result data are selected.  The four date ranges have a "from" date and a "to" date.  The "from" date must be less than or equal to the "to" date.  Also, the day must be valid for the specified month.  If you make no adjustments to the defaults, then no record will be filtered out of the selection process based on Activity Start Date values.

Characteristic Selection
The Characteristic selection area appears in all the Result Selection Criteria and Station Selection Criteria pages.  It allows you to search and select the Characteristics to use in the Result and Station searches.  It allows you to select Characteristics via Characteristic Alias Type (e.g.,  Systematic Name, STORET Parm Code) or the Characteristic Name itself.

Characteristic Searches
You have been given the option to use Characteristic Aliases or Characteristic Name to select Characteristics.  Select the specific Characteristic Alias Type (e.g., Systematic Name, STORET Parm Code) or Characteristic Name, for which you wish to search.  Enter as many characters of the selected Characteristic Alias or Characteristic Name as you desire for the search string.  Click on the <Search> button, and a popup window will display with the complete list of Characteristics based on the Characteristic Alias Type or name you selected, and based on the search string you entered.  From the list, highlight the ones that you would like to select and click on the <Select> button.  The popup window will be closed and the determined Characteristics will appear in the selected Characteristic Name list.  Even when you select a Characteristic Alias Type, like STORET Parm Code,  the software will determine the Characteristics based on the alias selected, and display these Characteristics in the selected Characteristic Name list.

Taxonomic Names
Because the total number of taxonomic Characteristics is large, the check box labeled "Hide Taxonomic Names" is checked by default.  This causes the Characteristic search to exclude all taxonomic Characteristics.  If you would like to include taxonomic names in the search, click on the check box to uncheck it.  The list will then display both non-taxonomic and taxonomic Characteristics.  Keep in mind that the only taxonomic Characteristics that will be returned are ones that have data associated to them.

Characteristic List Functions
After you have created the selected Characteristic Name list, you still have the option to remove Characteristics from the list.  To remove all Characteristics from the selected Characteristic Name list, click on the <Clear All> button.  To remove only specific Characteristics from the list, highlight the Characteristic(s) that you wish to remove, then click on the <Clear Selected> button.

Top      Result Reports

Activity Medium Selection
The Activity Medium Selection only appears in the Regular Result Selection Criteria page.  It allows you to search and select records based on Activity Medium.  You can select one or more Activity Mediums from the list of valid Activity Mediums.  The records selected for the report will contain the results with the selected Activity Mediums only.  If you select the "Select All" option there will be no filter for Activity Medium.

Activity Intent and Community Sampled Selection
The Activity Intent and Community Sampled Selections only appear in the Biological Result Selection Criteria page.  There is a list of Activity Intents from which you can choose one or more.  You can also select one or more Community Sampled from a list; however, Taxon Abundance is the only Activity Intent with Community Sampled data.  The records selected will be based on the selected Activity Intents or the combination of the Taxon Abundance Activity Intent and the selected Community Sampled.

Organization/Station Selection
The Organization/Station Selection area appears in the Stations by Organization and Station ID and Results by Station pages.  You can narrow the search criteria by selecting an Organization and one or more Stations within the selected Organization.  First, you select an Organization from the drop down list of Organizations.  After that, you select what attribute you would like to use to search for a Station list.  You can select Station ID, Station Name, or Station Alias.  If you select Station ID or Station Name you can enter as many characters of a Station ID or Station Name as you desire for the Station search string and click on the <Search Stations> button.  A popup window with the complete list of Station IDs and Station Names matching the search criteria will be displayed within the popup window.  If you select Station Alias, click on the <Look Up> button.  A popup window will be displayed with a list of Station Alias Types for the selected Organization.  Highlight your selection and click on the <Select> button.  You can only select a single Station Alias Type from the list.  This will return you to the Selection Criteria page.  Now, you can enter as many characters of the Station Alias as you desire for the Station search string and click on the <Search Stations> button.  A popup window with the complete list of Station IDs, Station Alias Types, Station Aliases, and Station Names matching the search criteria will be displayed within the popup window.  The Organization ID is also displayed in this popup.  From the list, highlight the stations you would like to select and click on the <Select> button.  The popup window will be closed and the selected Station IDs and Station Names will appear in the selected Stations list.

After you have created the selected Stations list, you still have the option to remove Stations from the list.  To remove all Stations from the selected Stations list, click on the <Clear All> button.  To remove only specific Stations from the list, highlight the Station(s) that you wish to remove, then click on the <Clear Selected> button.

To add Stations from another Organization, select another Organization from the Organization list and follow the steps above to select Stations.

If you leave the defaults intact, there will be no filter for Organization and Station criteria.  If you select an Organization but do not select any corresponding Stations, then only data for the selected Organization will be returned.  If you select one or more Stations then only records from the selected Stations will be chosen for the report.

Top      Result Reports

Organization/Project Selection
The Organization/Project Selection area appears in the Results by Project page.  You can narrow the search criteria by selecting an Organization and a Project within the selected Organization.  First, you select an Organization from the drop down list of Organizations.  After that, click on the <Look Up> button and a popup window with the complete list of Project IDs and Project Names within the selected Organization will be displayed within the popup window.  From the list, highlight the Project that you would like to select and click on the <Select> button.  The popup window will be closed and the selected Project Name will appear in the selected Project area.

After you have selected a Project, you can still remove the Project by selecting an Organization from the "Select an Organization" drop down list.  This will clear your Project selection.

If you leave the defaults intact there will be no filter for Organization or Project criteria.  If you select an Organization but do not select any corresponding Project, then only data for the selected Organization will be returned.  If you select an Organization and a Project then only the Result records from the selected Organization/Project will be chosen for the report.

Station Type Selection
The Station Type selection area appears in the Stations by Geographic Location and Stations by Organization and Station ID pages.  It allows you to choose one or more Primary Type/Secondary Type combinations to use in your Station search.  If "Select All" is chosen, then the Station search would include Stations of any Station Type.

You may select any one Station Primary Type/Secondary Type from the Station Type list by highlighting the desired row.

You may hold the <Ctrl> key down as you click additional rows if you wish to select more than one.

You may hold the <Shift> key down as you click to select all the rows between the current row and the most recently selected row.

Organization Selection
The Organization selection area appears in the Stations by Geographic Location page.  It allows you to choose one or more Organizations to use in your Station search.  If <Select All> is chosen, then the Station search would include Stations from any Organization.

You may select any one Organization from the Organization list by highlighting the desired row.

You may hold the <Ctrl> key down as you click additional rows if you wish to select more than one.

You may hold the <Shift> key down as you click to select all the rows between the current row and the most recently selected row.

Pressing the first character of an Organization's code will transfer the focus to that area of the Organization list.

Top      Station Report

Summary Pages
The Summary Pages for the Result and Station requests are very similar.  They both display the selection criteria of the request and the number of records selected.  Both have a selectable list of data elements that can be included in reports.

Station Search Summary Page
This page displays the total count of Stations returned followed by a list of the Station search parameters entered.  If the count of Station records is zero or more than maximum allowed then you are requested to modify your search criteria by making it more specific to eliminate records or more general to allow more records.  If the count of Stations falls between the allowable limits, then a list of Data Elements are displayed.  You can select from this list of Data Elements to customize the content of your report and continue, or return to the Station Selection Criteria page.  The allowable limits are divided into Online and Batch ranges.  The Batch range includes Immediate and Overnight processing.  Immediate option is only available for lower end of the Batch range.  These limits are maintained by the STORET administrator.  This page contains the following sections:

Number of Stations Returned
The number of Stations retrieved with the search criteria you entered on the previous page.

Search Parameter Values Summary
This box displays the Station search parameters you entered on the previous page.

Navigation Options for Stations
Click on the <Back> button to return to the Station Selection Criteria page for modifying Station search parameters and refining your query.

Click on the <Continue> button to generate a report based on your search criteria and selected data elements.

Choose the <Batch Processing> to submit a request for report based on your search criteria and selected data elements.

Batch Processing

Provide user profile to categorize the user type. This is required only for Batch Processing.

Provide email address to report the completion of your request. This is required only for Batch Processing.

Provide three character string to prefix the data filename. This is required only for Batch Processing.

Click on the <Immediate> button to submit the request to generate the report immediately.  An email will be sent after completing the process.

Click on the <Overnight> button to submit the request to generate the report overnight.  An email will be sent after completing the process.

Report Customization for Stations (Select Data Elements for Reports)
If the number of Station records selected are more than zero, then a list of Data Elements are displayed for you to select for your report.  You may select Data Elements that are appropriate to your Station search for customizing the content of your report.  There are default data elements selected for you when the page is displayed which are considered the most notable.  You can tailor the content of your report by selecting or unselecting data elements, via their check box, until you have selected your desired content.  Click on the <Select All> button to select all Data Elements, <Clear All> button to clear all selections, or <Restore Defaults> button to set the selections back to the default report elements.  Some of the displayed Data Elements are actually Group Elements.  These Group Elements represent more than one Data Element and, if selected, the report will contain the Data Elements of the group.  Once you have selected the data elements you want to see in the report, then click on the <Continue> button.

Distinct Clause
By Definition:
The DISTINCT clause acts as a filter to remove duplicate records from a result set. It ensures that any records that are returned are unique for the column or columns specified in the SELECT statement. A duplicate row is defined as a row with matching values for each expression in the SELECT list. The DISTINCT keyword is synonymous with the UNIQUE keyword, which is non-standard SQL.

Report Customization for Summary (Using the DISTINCT Clause):

Examples:
Who? has data (monitoring)
ORG_ID, ORG_NAME

What? type of data
CHAR_NAME, MEDIUM, ANALYTICAL METHOD
ACTIVITY TYPES

When? sample/submission event
ACTIVITY_START_DATE
ORG_ID, LAST_CHANGE_DATE

Where? site / geo /site type
ORG_ID, STATION_ID, CHAR_NAME (storetw.station_char)
HUC
COUNTY
STATION_TYPE

Why? Purpose
PROJECT_ID, PROJECT_NAME

More....

Top

Station Group Elements
As mentioned before, there are several Group Elements displayed in the Station Report's customization screen.  A Group Element represents several data elements.  When one selects a Group Element, the data elements represented by the Group Element will appear in the report.  The following is a list of Group Elements available in the Station Report and the data elements that are related.  The data elements are linked to the Glossary definitions.

Data Elements for Spring Info
    Spring Type Improvement
    Permanence
    USGS Geologic Unit Code-Name
    Spring Other Name
    USGS Lithologic Unit Code-Name

Data Elements for Latitude/Longitude
    Latitude
    Longitude
    Horizontal Datum

Data Elements for Converted Latitude/Longitude
    Converted Latitude
    Converted Longitude
    Converted Horizontal Datum

Data Elements for Lat/Long Info
    Geopositioning Method
    Map Scale

Data Elements for Additional Elevation Info
    Elevation Datum
    Elevation Method

Data Elements for RF1 Info
    RF1 Segment Code
    RF1 Segment Name
    RF1 Mileage
    On Reach Ind

Data Elements for Estuary Info
    Primary Estuary
    Secondary Estuary
    Other Estuary

Data Elements for Administrative Submission/Change Record
    Last Change Date
    Last Transaction ID
    Last User ID
 

Station Data Elements
The following are the Data Elements available for selection for the Station Report.  The data elements that are italicized are group elements.  Group Elements represent a group of related data elements.  When one selects a Group Element, one will get the related data elements in the report.  The Group Elements are linked to the list of related elements.  The default data elements are in bold and the data elements are linked to the Glossary to provide the definition.
 

Org ID Elevation Elevation Unit
Station ID Additional Elevation Info
Station Name Country Name
Organization Name State
Primary Type County
Secondary Type Hydrologic Unit Code (HUC)
S/G/O Indicator Hydrologic Unit Name
Well Number RF1 Info
Well Name NRCS Watershed ID
Pipe Number Estuary Info
NAICS Code Great Lake Name
Spring Info Ocean Name
Location Point Type Native American Land Name
Point Sequence Number FRS Key Identifier
Point Name Description Text
Latitude/Longitude Station Document/Graphic Name
Conv Latitude/Longitude Station Document/Graphic URL
Lat/Long Info Administrative Submission/Change Record

Top

Result Search Summary Page
This page is used by each of the Result pages (i.e. Regular, Biological, and Habitat).  This page displays the total count of Results returned followed by a list of the Result search parameters entered.  If the count of Result records is zero or more than 30,000, then you are requested to modify your search criteria by making it more specific to eliminate records, or more general to allow more records.  If the count of Results falls between the allowable limits, then a list of Data Elements is displayed.  You may select the Data Elements to customize the content of your report and continue, or return to the Result Selection Criteria page.  The allowable limits are divided into Online and Batch ranges.  The Batch range includes Immediate and Overnight processing.  Immediate option is only available for lower end of the Batch range.  These limits are maintained by the STORET administrator.  This page contains the following sections:

Number of Results Returned
The number of Results retrieved with the search criteria you entered on the previous page.

Search Criteria for Results
This box displays the Result search parameters you entered on the previous page.

Navigation Options for Results
Click on the <Back> button to return to the Results Selection Criteria page for modifying result search parameters and refining your query.

Click on the <Continue> button to generate a report based on your search criteria and selected data elements.

Choose the <Batch Processing> to submit a request for report based on your search criteria and selected data elements.

Batch Processing

Provide email address to report the completion of your request. This is required only for Batch Processing.

Provide three character string to prefix the data filename. This is required only for Batch Processing.

Click on the <Immediate> button to submit the request to generate the report immediately.  An email will be sent after completing the process.

Click on the <Overnight> button to submit the request to generate the report overnight.  An email will be sent after completing the process.

Report Customization for Results (Select Data Elements for Reports)
You may select Data Elements that are appropriate to your result search for customizing the content of your report.  The list of Data Elements available to select differs slightly among Regular Result, Biological Result, and Habitat Result.  There are default data elements selected for you when the page is displayed which are considered the most notable.  You can tailor the content of your report by selecting or unselecting data elements, via their check box, until you have selected your desired content.  Click on the <Select All> button to select all Data Elements, <Clear All> button to clear all selections, or <Restore Defaults> button to set the selections back to the default report elements.  Some of the displayed Data Elements are actually Group Elements.  These Group Elements represent more than one Data Element and, if selected, the report will contain the Data Elements of the group.  Once you have selected the data elements you want to see in the report, then click on the <Continue> button.

Top

Result Group Elements
As mentioned before, there are several Group Elements displayed in each of the Result Search Summary pages.  A Group Element represents a group of data elements.  When one selects a Group Element, the data elements represented by the Group Element will appear in the report.  The following is a list of Group Elements and the data elements that are related.  The data elements are linked to the Glossary to provide definitions.

Data Elements for Station Location Info
    State
    County
    HUC
    Generated HUC

Data Elements for Station Lat/Long
    Station Latitude
    Station Longitude
    Station Horizontal Datum

Data Elements for Conv Station Lat/Long
    Converted Station Latitude
    Converted Station Longitude
    Converted Station Horizontal Datum

Data Elements for Station Types
    Primary Type
    Secondary Type

Data Elements for Visit Start
    Visit Start
    Visit Start Time Zone

Data Elements for Visit Stop
    Visit Stop
    Visit Stop Time Zone

Data Elements for Activity Start
    Activity Start
    Activity Start Time Zone

Data Elements for Activity Stop
    Activity Stop
    Activity Stop Time Zone

Data Elements for Actual Activity Lat/Long
    Actual Activity Latitude
    Actual ActivityLongitude
    Actual Activity Horizontal Datum

Data Elements for Conv Actual Activity Lat/Long
    Converted Actual Activity Latitude
    Converted Actual Activity Longitude
    Converted Actual Activity Horizontal Datum

Data Elements for Additional Act Location Info
    Geopositioning Method
    Map Scale

Data Elements for Sample Preservation
    Container Description
    Temp Pres Type
    Pres Storage Proc

Data Elements for Additional Anal Proc Info
    Detection/Threshold Limit
    Detection/Threshold Limit Unit
    Detection/Threshold Limit Descript
    Lower Quantification Limit
    Upper Quantification Limit
    All Result Detections/Thresholds

Data Elements for Other Lab Info
    Lab ID
    Lab Name
    Lab Cert
    Lab Batch ID
    Analysis Date
    Analysis Date Time Zone

Data Elements for Net Tow Info
    Trawl Start Point Name
    Trawl Start Latitude
    Trawl Start Longitude
    Trawl Start Horizontal Datum
    Conv Trawl Start Latitude
    Conv Trawl Start Longitude
    Conv Trawl Start Datum
    Trawl Start Depth (w/units)
    Trawl Stop Point Name
    Trawl Stop Latitude
    Trawl Stop Longitude
    Trawl Stop Horizontal Datum
    Conv Trawl Stop Latitude
    Conv Trawl Stop Longitude
    Conv Trawl Stop Datum
    Trawl Stop Depth (w/units)
    Fished Duration Measure (w/units)
    Boat Speed (w/units)
    Fished Distance (w/units)
    Rel Current Dir
    Rel Wind Dir
    Trawl Comment

Data Elements for Electroshock Info
    Voltage Measure
    Current Type Code
    Amperage Measure
    Pass Count
    Pass Length Measure (w/units)
    Pulse Rate Measure
    Electroshock Comment
    Total Energzed Time (w/units)

Data Elements for Net Non-Tow Info
    Sampling Duration (w/units)
    Orientation to Current
    Rel Current Dir
    Rel Wind Dir
    Trap Net Comment

Data Elements for General Group Info
    Bio Result Group ID
    Bio Result Group Type
    Bio Result Group Subject Taxon (w/species #)
    Bio Result Group Desc

Data Elements for Multi-Taxon Pop Census Info
    Feeding Group
    Pollution Tolerance
    Trophic Level
    Habit
    Voltinism
    Cell Shape
    Cell Form

Data Elements for Single Taxon Group Summary Info
    Number in Group
    Group Count Type

Data Elements for Single Taxon Frequency Class Info
    Phys/Bio Ind
    Bio Result Group ID (sex)
    Bio Result Group ID (lifestage)
    Bio Result Group Class Var
    Class Prim Desc
    Class Sec Desc
    Class Lower Bound
    Class Upper Bound
    Units

Data Elements for Single Taxon Individual Info
    Number in Group
    Bio Individual Number

Data Elements for Administrative Submission/Change Record
    Last Change Date
    Last Transaction ID
    Last User ID

Top

Regular Result Data Elements
The following are the Data Elements available for selection for the Regular Results Report.  The data elements that are italicized are group elements.  Group elements represent a group of related data elements.  When one selects a Group Element, one will get the related data elements in the report.  The Group Elements are linked to the list of related elements.  The default data elements are in bold, and the data elements are linked to the Glossary to provide the definition.
 

Org ID Conv Actual Activity Lat/Long Converted Result Units
Org Name Well Number Result Comment
Station ID Pipe Number Result Free Text
Station Name Additional Act Location Info Weight Basis
Station Location Info Activity Depth Temperature Basis
Station Lat/Long Activity Depth Unit Duration Basis
Conv Station Lat/Long Activity Upper Depth Particle Size Basis
S/G/O Indicator Activity Rel Depth  Distance Measured From
Visit Num Activity Lower Depth Distance Measured to
Visit Start Upr Lwr Depth Unit Analytical Proc ID
Visit Stop Sample Collection ID Additional Anal Proc Info
Trip ID Field Gear ID Lab Remark
Trip Name Field Gear Config ID Dilution Ind
Activity ID Sample Preservation Recovery Ind
Activity Start Portable Data Logger Correction Ind
Activity Stop Characteristic Name Other Lab Info
Activity Medium CAS Num Num of Reps
Activity Matrix EPA Registry Num Precision
Activity Type ITIS Num Bias
Activity Category-Rep Num Sample Fraction Conf Level
Activity Intent Value Type Correction for Bias Ind
Field Set Statistic Type Result Document/Graphic Name
Actual Point Type Result Value as Text Result Document/Graphic URL
Actual Point Sequence Result Value as Number Activity Document/Graphic Name
Actual Point  Name Units Activity Document/Graphic URL
Actual Activity Lat/Long Converted Result Value Activity Comment
Activity Depth Ref Point Administrative Submission/Change Record

Biological Result Data Elements
The following are the Data Elements available for selection for the Biological Results Report.  The data elements that are italicized are group elements.  Group elements represent a group of related data elements.  When one selects a Group Element, one will get the related data elements in the report.  The Group Elements italicized below are linked to the list of related elements.  The default data elements are in bold, and the data elements are linked to the Glossary to provide the definition.
 

Org ID Well Number Duration Basis
Org Name Pipe Number Particle Size Basis
Station ID Additional Act Location Info Distance Measured From
Station Name Activity Depth Distance Measured to
Station Location Info Activity Depth Unit Analytical Proc ID
Station Lat/Long Activity Upper Depth Additional Anal Proc Info
Conv Station Lat/Long Activity Rel Depth  Lab Remark
S/G/O Indicator Activity Lower Depth Dilution Ind
Visit Num Upr Lwr Depth Unit Recovery Ind
Visit Start Sample Collection ID Correction Ind
Visit Stop Field Gear ID Other Lab Info
Trip ID Field Gear Config ID Num of Reps
Trip Name Sample Preservation Precision
Activity ID Characteristic Name Bias
Activity Start CAS Num Conf Level
Activity Stop EPA Registry Num Correction for Bias Ind
Activity Medium ITIS Num Net Tow Info
Activity Type Sample Fraction Electroshock Info
Activity Category-Rep Num Value Type Net Non-Tow Info
Activity Intent Statistic Type General Group Info
Community Sampled Result Value as Text Multi-Taxon Pop Census Info
Subject Taxon Result Value as Number Single Taxon Group Summary Info
Biopart Units Single Taxon Frequency Class Info
Field Set Converted Result Value Single Taxon Individual Info
Actual Point Type Converted Result Unit Result Document/Graphic Name
Actual Point Sequence Result Comment Result Document/Graphic URL
Actual Point  Name Result Free Text Activity Document/Graphic Name
Actual Activity Lat/Long Weight Basis Activity Document/Graphic URL
Conv Actual Activity Lat/Long Temperature Basis Activity Comment
Activity Depth Ref Point Administrative Submission/Change Record

Habitat Result Data Elements
The following are the Data Elements available for selection for the Habitat Results Report.  The data elements that are italicized are group elements.  Group elements represent a group of related data elements.  When one selects a Group Element, one will get the related data elements in the report.  The Group Elements italicized below are linked to the list of related elements.  The default data elements are in bold, and the data elements are linked to the Glossary to provide the definition.
 

Org ID Actual Point  Name Temperature Basis
Org Name Actual Activity Lat/Long Duration Basis
Station ID Conv Actual Activity Lat/Long Distance Measured From
Station Name Well Number Distance Measured to
Station Location Info Pipe Number Analytical Proc ID
Station Lat/Long Additional Act Location Info Additional Anal Proc Info
Conv Station Lat/Long Characteristic Name Lab Remark
S/G/O Indicator Habitat Class Name Dilution Ind
Visit Num EPA Registry Num Recovery Ind
Visit Start Sample Fraction Correction Ind
Visit Stop Value Type Other Lab Info
Trip ID Statistic Type Num of Reps
Trip Name Result Value as Text Precision
Activity ID Result Value as Number Bias
Activity Start Units Conf Level
Activity Stop Converted Result Value Correction for Bias Ind
Activity Type Converted Result Unit Result Document/Graphic Name
Field Set Result Comment Result Document/Graphic URL
Actual Point Type Result Free Text Activity Document/Graphic Name
Actual Point Sequence Weight Basis Activity Document/Graphic URL
Activity Comment Administrative Submission/Change Record

Top

Watershed Summary
Watershed summary report provides a summary of STORET results for a chosen Hydrologic Unit Code, grouped by organization or characteristic type. A dropdown list of Hydrologic Unit Codes is displayed, from which you can choose a Hydrologic Unit Code and request for summary information. The Search By radio buttons provided on the web page allow you to choose one out of the two formats for watershed summary display.

Get Organization Summary and Download Results for One or All organization(s)
This page displays the number of organizations, stations, characteristics and results for the selected watershed. Name of each organization within the selected watershed is displayed with a radio button. Number of stations, and distibution of results across the various characteristic types for each organization will be displayed as hyperlinks. The stations hyperlink lists station names and number of results of each station, for the selected organization within the watershed. The hyperlinks attached to the characteristic types provide names and number of results for each characteristic of the selected characteristic type found within the selected organization and watershed.

Get Characteristic Type Summary and Download Results for Selected Characteristic Type(s)
This page displays the total number of characteristics and the total number of results available for the selected watershed. Names of characteristic types found across the results of the watershed are displayed. The check boxes displayed next to each of the characteristic type allow you to choose one or more of the characteristic types, and request STORET result data for the watershed for the selected characteristic types.

Top

Download Results Page

Download Results Page General
This page gives you the option to download your report or to have it compressed first before downloading.  It displays the size of your report in kilobytes to assist you in deciding to compress (zip) the report or not.  Click on the link  "Download your file now..." to download your report.  Click the "Compress Data File Now" button to proceed with compressing your report.  Another download page is brought up when you select to compress your report.  From this page you can download your compressed report.

Explanation of Result Report Format
The generated report provides the available information associated with the selected data elements when Results exist that match the search criteria.

The file will be "Tilde Delimited" flat ASCII text.  The Tilde character (i.e., ~) is found on many keyboards at the top left, just above the TAB key, and looks like a horizontal "S".

This unusual character has been used as a delimiter because of its lower likelihood of appearing in any of your downloaded data over other more common characters.
 

Download Site Descriptions Page

Download Site Descriptions Page General
This page gives you the option to download your report or to have it compressed first before downloading.  It displays the size of your report in kilobytes to assist you in deciding to compress (zip) the report or not.  Click on the link  "Download your file now..." to download your report.  Click the "Compress Data File Now" button to proceed with compressing your report.  Another download page is brought up when you select to compress your report.  From this page you can download your compressed report.

Explanation of Station Report Format
The generated report provides the available information associated with the selected data elements when monitoring sites exist that match the search criteria.

The file will be "Tilde Delimited" flat ASCII text.  The Tilde character (i.e., ~) is found on many keyboards at the top left, just above the TAB key, and looks like a horizontal "S".

This unusual character has been used as a delimiter because of its lower likelihood of appearing in any of your downloaded data over other more common characters.

Download Your Compressed Data File
If you select to compress your report, a download page is opened.  This page allows you to download your compressed report.  The file size is given to help you decide whether to download or not.  The report is compressed using a UNIX tool.  The compressed file has an extension of ".gz".  This stands for GZIP.  Most compression or Zip software recognizes this extension and is compatible with the file.  However, some Zip software will not be able to unzip this file.  By clicking on the link  "Download your compressed file now..."  your default Zip software will open ready to unzip your report.  Depending on your browser's settings, you may be prompted to either open or save your compressed file before your Zip software is called.  You can save it to a directory of your choice or unzip the report right away.  The report is the same tilde delimited file described in the Download Results Page and the Download Site Descriptions Page.  It should be noted that the Netscape browser does not work properly with the zip enhancement.  It unzips the file immediately, instead of bringing up the zip program to allow you to determine what to do with the file.

Retrieving Documents/Graphics
Retrieving documents/graphics requires a few additional steps when customizing and downloading your Station or Result report.† When customizing your report the data elements associated with Station documents/graphics are Station Document/Graphic Name and Station Document/Graphic URL.† These data elements can be selected from the Station Search Summary page.† The data elements associated with Result documents/graphics are Result Document/Graphic Name and Result Document/Graphic URL.† The data elements associated with Activity documents/graphics are Activity Document/Graphic Name and Activity Document/Graphic URL.† Documents/graphics for both Activity and Result data can be selected from the Result Search Summary page.† For each type of documents/graphics (Station, Result, or Activity) the Document/Graphic Name data element provides the title or name of† the documents/graphics.† The Document/Graphic URL data element provides the address or Uniform Resource Locator (URL) of the web page that can download your documents/graphics.† This data element is essential to retrieve your documents/graphics.† The Document/Graphic Name data element is optional.

To retrieve a documents/graphics, select, at least, the Document/Graphic URL data element for which you are interested. Download your report as usual.† Highlight the URL that appears in the body of the report.† Copy and paste it into the "Address" prompt on your web browser and hit "Enter".† Make sure the complete URL is copy and pasted.† This will open the Download Document/Graphic page. Clicking on the "Download your Document/Graphic now..." link will open the documents/graphics on your browser or with other software compatible with the file type.

The URL contained in your Document/Graphic URL data element will remain accurate and can be used again without running another report, unless that documents/graphics record gets modified through STORET's data entry.

Download Document/Graphic Page
As mentioned above, this page is displayed when the value in the Document/Graphic URL data element is transcribed to the address prompt of your web browser.† By clicking on the link† "Download your Document/Graphic now..."† the document or graphic being pointed to by the URL is downloaded and opened on your browser or with other software compatible with the file type.

Top

Glossary

Activity Category
A descriptor used to distinguish different kinds of samples and different kinds of Measurements & Observations.

Activity Category-Rep Num
This is the concatenation of Activity Category and Replicate Number.  An Activity Category is a descriptor used to distinguish different kinds of samples and different kinds of Measurements & Observations.  A Replicate Number is a user-assigned number applied to samples/measurements of the same type, medium, etc. to differentiate between them (e.g., Water Replicate 1 and Water Replicate 2).  Note: This applies only to certain Activity Categories for Samples (replicate, field replicate, depletion replicate, sample created from sample) and Measurements (measurement replicate)- not Observations.

Activity Depth
Distance from the surface to the point in the water column at which the activity is conducted.

Activity Depth Unit
The code that represents the units in which the depth to activity is expressed.

Activity Document/Graphic Name
An activity may be further described by a document or graphic.  This field defines the title of the documents/graphics which further defines this activity.

Activity Document/Graphic URL
A Uniform Resource Locator (URL) is an address of a file accessible on the internet.  In this case, it is the address of a Document/Graphic describing an activity.

Activity ID
The Organization-assigned alphanumeric code that identifies a Field Activity, sometimes called Sample ID.  The combination of Activity/Sample ID and Replicate Number must be unique among all samples collected during one Station visit conducted during any one Trip.

Activity Intent
The primary reason the Field Activity occurred.  Note: This is mandatory for Biological Medium, and not available for other media.

Activity Comment
Free text comments usually originating from members of the field crew regarding the Field Activity.

Activity Lower Depth
This measure is associated with an activity that is normally conducted over or within a vertical depth range within the water column.  This attribute is a measure of the distance from the surface to the lower boundary of the zone within which the activity is conducted or over which the activity is integrated.

Activity Matrix
The short name of the Sample Matrix.

Activity Medium
The name of the medium where the Field Activity occurred.

Activity Rel Depth
The name that indicates the approximate location within the water column at which the activity occurred.

Activity Start
For Samples Collected or for Measurements/Observations made - the date and time that the Field Activity began.  For Samples Created from other samples - the date and time on which a sample is created by compositing, splitting, or subsampling from a parent sample.  It is a date/time attribute containing Activity Start Date and Activity Start Time.

Activity Start Time Zone
Time Zone for Activity Start.

Activity Stop
Date and time that the Field Activity ended.  It is a date/time attribute containing Activity Stop Date and Activity Stop Time.

Activity Stop Time Zone
Time Zone for Activity Stop.

Activity Type
The type of the Field Activity being performed, used to distinguish between field samples and field measurements and observations.

Activity Upper Depth
This measure is associated with an activity that is normally conducted over or within a vertical depth range within the water column.  This attribute is a measure of the distance from the surface to the upper boundary of the zone within which the activity is conducted or over which the activity is integrated.

Actual Activity Latitude
The Latitude (in decimal degrees) for the absolute location point of the Activity.  Latitudes South of the Equator are negative.

Actual Activity Longitude
The Longitude (in decimal degrees) for the absolute location point of the Activity.  Longitudes in the Western Hemisphere (including the entire continental United States) are negative.
 

Top
 

Actual Point Type
The code that identifies the type of location for an Absolute Location Point.

Actual Point Name
User-specified free text name by which a specific absolute location point will be known.

Actual Point Sequence
The number that indicates the sequence position of current point among a group of points.  For example, if several points are recorded to mark the boundary of a Station, the sequence number specifies the order in which the system should "connect the dots."

Amperage Measure
The rate of current flow (amperes) produced by the electroshock equipment used to collect the Sample.

Analysis Date
The date on which laboratory analysis of the sample for this particular result was performed.

Analysis Date Time Zone
The time zone of  the Analysis Date.

Analytical Proc Name
The full title of the analytical procedure.

Analytical Proc ID
A combination of an abbreviation or acronym identifying the Organization that owns the analytical procedure (e.g. ASTM, USGS, and EPA) and the abbreviated name or identifying code of the analytical procedure.

Bias
A consistent deviation of measured values from the true value, caused by systematic errors in a procedure, as determined by applying the identical procedures to a specimen of known properties.

Bio Individual Number
System assigned sequence number to the individual in accordance with the total number of individuals reported by the user.  Once assigned, this number does not change and cannot be changed/deleted.  Each defined group of individuals gets an increasing series of "individual numbers" beginning with 1 for the identification of individual specimens from the original group.  Results then describe the specific individual.

Bio Result Group Class Var
The name of the characteristic when the group is Single Taxon Frequency Classes based on Physical measures.

Bio Result Group Desc
Additional user-specified text describing the biological result group.  Not intended to replace results with characteristics with text values.

Bio Result Group ID
The user-assigned number that identifies a Biological Result Group.

Bio Result Group ID (lifestage)
The lifestage of all organisms in the biological result group, when the group is Single Taxon Frequency Classes based on Physical measures.

Bio Result Group ID (sex)
The sex of all organisms in the biological result group, when the group is Single Taxon Frequency Classes based on Physical measures.

Bio Result Group Subject Taxon (w/species #)
This field is a combination of two fields.  Part of it is a number that is assigned as a part of a taxonomic identification.  Used with a valid genus (or higher taxonomic rank) to indicate a unique species has been observed but not taxonomically identified (e.g., Lepomis sp.1).  It is also the name of the taxonomic characteristic.

Bio Result Group Type
The name of the kind of group.  Examples include:  1. Multi-Taxon Population Census  2. Single taxon frequency class    3. Single taxon group summary    4. Single taxon individual

Biopart
The usual anatomical term which identifies the portion of an organism to be analyzed.

Boat Speed
The relative speed, through the water, of the boat during Sample collection.  This field also includes the code that represents the unit in which the boat speed is expressed.

CAS Num
Chemical Abstract Service Registry Number.  It is a unique identifier for chemicals.

Cell Form
The name of the cell form for cellular organisms expressed as a result.  A single cellular species may have a result value for any or all of these cell forms.

Cell Shape
The cell shape of the cellular organism.  For example, a chrysophyta can have a form and a shape.

Characteristic Name
The name of the characteristic as it is to be displayed on windows and reports.

Characteristic Type
A Characteristic Type represents a group of characteristics. Each Characteristic is assigned to one or more characteristic types.

Class Lower Bound
Represents the value of the lower bound of the result class interval.

Class Prim Desc
For Single Taxon Frequency Classes based on biological conditions for a group of organisms, this defines either the Sex or the Lifestage of all organisms participating in the frequency class.

Class Sec Desc
For Single Taxon Frequency Classes based on biological conditions for a group of organisms, this optionally defines either the Sex or the Lifestage (whichever was not used as Primary) of all organisms participating in the frequency class.

Class Upper Bound
Represents the value of the upper bound of the result class interval.

Community Sampled
The name of the Biological Community from which the Sample was taken.  Note: This is only valid when medium is Biological and the intent type is Taxon Abundance.  It is mandatory for that combination of descriptors.

Confidence Level
A statistical calculation measuring the certainty about the result.

Container Description
The style and material of the container, the color of the container, the measure of the size of the container, and the unit which the size of the container is expressed which is used to collect and transport a sample.

Container Color
The description of the color of the container used to collect and transport the sample.

Converted Actual Activity Latitude
The Latitude (in decimal degrees) for the absolute location point of the Activity. Latitudes South of the Equator are negative. This value has been converted to standard units where possible to assist with data analysis.

Converted Actual Activity Longitude
The Longitude (in decimal degrees) for the absolute location point of the Activity. Longitudes in the Western Hemisphere (including the entire continental United States) are negative. This value has been converted to standard units where possible to assist with data analysis.

Converted Actual Activity Horizontal Datum
The set of reference points from which the Latitude and Longitude were determined. Accuracy of the latitude/longitude determination is affected by the choice of a datum. This value has been converted to standard units where possible to assist with data analysis.

Converted Result Value
The numeric representation of the result value for fully numeric values. Note: This value will be determined by converting the text values from Value Text. This conversion to numeric is always attempted during data entry, and when successful, its result is placed in this field. This value has been converted to standard units where possible to assist with data analysis.

Converted Result Unit
The unit of measure. This value has been converted to standard units where possible to assist with data analysis.

Converted Trawl Start Latitude
The measure of latitude in decimal degrees (-90.0 to 90.0) indicating angular distance North or South of the equator where the trawl began. This value has been converted to standard units where possible to assist with data analysis.

Converted Trawl Start Longitude
The measure of longitude in decimal degrees (-180.0 to 180.0) indicating angular distance west or east of the prime meridian where the trawl began. This value has been converted to standard units where possible to assist with data analysis.

Converted Trawl Start Datum
The set of reference points from which the Latitude and Longitude were determined. Accuracy of the latitude/longitude determination is affected by the choice of a datum. This value has been converted to standard units where possible to assist with data analysis.

Converted Station Latitude
The Latitude (in decimal degrees) at which the Station's Point of Record is located. Latitudes South of the Equator are negative. Every STORET Station has a Point of Record. This value has been converted to standard units where possible to assist with data analysis.

Converted Station Longitude
The Longitude (in decimal degrees) at which the Station's Point of Record is located. Longitudes in the Western Hemisphere (including the entire continental United States) are negative. This value has been converted to standard units where possible to assist with data analysis.

Converted Station Horizontal Datum
The set of reference points from which the Latitude and Longitude were determined. Accuracy of the latitude/longitude determination is affected by the choice of a datum. This value has been converted to standard units where possible to assist with data analysis.

Converted Trawl Stop Latitude
The measure of latitude in decimal degrees (-90.0 to 90.0) indicating angular distance North or South of the equator where the trawl ended. This value has been converted to standard units where possible to assist with data analysis.

Converted Trawl Stop Longitude
The measure of longitude in decimal degrees (-180.0 to 180.0) indicating angular distance west or east of the prime meridian where the trawl ended. This value has been converted to standard units where possible to assist with data analysis.

Converted Trawl Stop Datum
The set of reference points from which the Latitude and Longitude were determined. Accuracy of the latitude/longitude determination is affected by the choice of a datum. This value has been converted to standard units where possible to assist with data analysis.

Correction for Bias Ind
A code indicating whether the confidence level has been corrected for Bias.

Correction Indicator
A code indicating whether the reported result has been adjusted in accordance with a correction factor.

Country Code
A 2-character abbreviation that is used to uniquely identify a country.  ( i.e., US for the United States and its territories, CN for Canada, and MX for Mexico.)

Country Name
The country name (English spelling).  Only Canada, the United States, and Mexico are included in STORET.

County
For Stations in the United States (only), the name of the county or county equivalent in which the Station is located.

Current Type Code
The code that represents the type of current produced by the electroshock equipment.

Description Text
Contains the organization-defined description of the station.  This text could include the distance of the left or right shore to the station, or any other information that would further identify the station.

Top

Detection/Threshold Limit
Represents the least amount of the target substance which could be detected by the instrument/analytical process employed to determine the result.  Above this value the target substance is presumed to be present.

Detection/Threshold Limit Unit
Represents the unit of measure.

Detection/Threshold Limit Descript
Text providing further description and comment on the detection and/or threshold limits, for example "Instrument Detection Level (IDL)", "Method Detection Level (MDL)", etc.

All Result Detections/Thresholds
Represents a delimited list of detection thresholds and limits referenced by the instrument/analytical process employed to determine the result.  Each threshold and/or limit is separated by a semicolon (';') as the delimiter.

Dilution Indicator
A code indicating that the result has been calculated from an analysis performed on a diluted sample.

Distance Measured From
The point from which a measurement such as surface elevation or stream width is taken.

Distance Measured to
The point to which a measurement such as stream width or surface elevation was taken.

Duration Basis
The period of time (in days) over which a measurement was made.

Electroshock Comment
User-defined text that provides further information about the Electroshock Operation.

Elevation
The vertical distance above or below sea level at which the Station is located.

Elevation Unit
Represents the unit of measure.

Elevation Datum
The set of reference points from which elevation measurements were made.  The accuracy of an elevation determination is affected by the choice of a datum.

Elevation Method
The method by which the elevation measurements were made.  The accuracy of the elevation determination is affected by the choice of a method.

EPA Registry Num
A number used to standardize the identification of characteristics.

External Reference Scheme Acronym
The abbreviation or acronym of the external reference scheme in which the Station participates.  For example, if the reference is to the National Pollution Discharge Elimination System the acronym is NPDES.

Feeding Group
For entries representing taxa, a code representing the functional feeding group with which the reported taxon is typically associated.

Field Gear Configuration ID
The code that identifies a Gear Configuration within the Organization.

Field Gear ID
An Organization-assigned ID Code that identifies a specific instance of Field Gear.  Note: One Field Gear may have many Gear Configurations.  Used as a shorthand or abbreviation to represent the Field Gear in batch data update runs.

Field Procedure ID
The short name (i.e., abbreviation or acronym) listed in reference document.

Field Procedure Name
The name of the sampling procedure, as listed in the reference document.

Field Set
The long name assigned by the Organization to identify and group field activities.

FIPS County Code
The Federal Information Processing Standard (FIPS) code, a 3-digit integer, used by government agencies to identify Counties and County equivalents within the States of the United States.  Canadian Provinces and Mexican States have no counties.

FIPS State Code
The Federal Information Processing Standard (FIPS) code, a 2-digit integer, used by government agencies to identify States within the countries of North America.

Fished Distance
The distance over which the trawl was operated for Sample collection.  This field also includes the code that represents the units in which the fished distance is expressed.

Fished Duration Measure
The length of time the Trawl is considered to be operational (i.e., collecting).  This field also includes the code that represents the units in which the fished duration is expressed.

FRS Key Identifier
FRS is the Facility Registry System, a scheme adopted by EPA to uniquely identify facilities in which EPA has a regulatory or monitoring interest.  This identifier, if present, can be used as a link to the Facility Registry.

Top

Gear Configuration Name
The Organization-defined name of the Gear Configuration.

Geopositioning Method
The name of the method used to determine the latitude/longitude.  Accuracy of the latitude/longitude determination is affected by the choice of method.

Great Lake Name
For Stations within any of the five Great Lakes, the name of the Great Lake on which the Station is located.

Group Count Type
A name that represents the process which was used in the determination of the Single Taxon Summary Group result value (e.g., actual, estimated, calculated).

Habit
A characteristic form or mode of a plant or animal.

Habitat Class Name
The Organization-defined label for the aggregation of characteristics that are habitat related.

Horizontal Datum
The set of reference points from which the Latitude and Longitude were determined.  Accuracy of the latitude/longitude determination is affected by the choice of a datum.

Hydrologic Unit Code (HUC)
An 8-digit integer standardized by the United States Geological Survey to identify large drainage basins within the United States.  The Hydrologic Unit Code (HUC) is not defined for Canada or Mexico.  Internally, the code consists of four fields of 2 digits each, identifying the hydrologic Region, Subregion, Accounting Unit, and Cataloging Unit respectively.

Hydrologic Unit Name
For Stations in the United States (only), the name of the Hydrologic Unit or drainage basin in which the Station is located.

Generated Hydrologic Unit Code (Generated HUC)
Currently it is a copy of Hydrologic Unit Code (HUC). In the future it is intended to hold user provided HUC and generated HUC based on Station geographic location information.

Generated Hydrologic Unit Name
For Stations in the United States (only), the name of the Generated Hydrologic Unit or generated drainage basin based on geographic location in which the Station is located.

ITIS Num
Integrated Taxonomic Information System Number is used to identify taxonomic information on plants, animals, fungi, and microbes.

Lab Batch ID
The code that represents the laboratory batch ID for a result or a group of results.  Batch ID may be used to link with Laboratory Data files, which may contain useful information further describing the reported result.

Lab Cert
A code indicating whether the laboratory was certified for the analyte and the analytical procedure at the time that the result determination was made.

Lab ID
An abbreviation or commonly-used name of the laboratory.

Lab Name
The formal title of the laboratory facility.

Lab Remark
An Organization defined code which represents a particular laboratory remark.

Last Change Date
The date of submission when the system processes and tracks the record transaction (INSERT,UPDATE).

Last Transaction ID
The WQX data submission Transaction ID reported by the exchange network services.

Last User ID
The User ID / NAAS ID of the data submission to the WQX data flow.

Latitude
The Latitude (in decimal degrees) at which the Station's Point of Record is located.  Latitudes South of the Equator are negative.  Every STORET Station has a Point of Record.

Location Point Type
Stations in STORET may have a large number of physical points described within their boundaries, and each point gets a descriptor explaining its function at the Station.  Valid types include point of record (every Station has exactly one), boundary points, sampling points, ends of pipes, well heads, and the origins of permanent sampling grids or transects.

Longitude
The Longitude (in decimal degrees) at which the Station's Point of Record is located.  Longitudes in the Western Hemisphere (including the entire continental United States) are negative.

Top

Lower Quantification Limit
Represents the least amount of the target substance which could be quantified by the instrument/analytical process employed to determine the result.  Values above the minimum and below the maximum quantitation limits are reported as valid numeric results.

Map Scale
Further qualifies latitude/longitude methods requiring map interpolation.  Accuracy of the latitude/longitude determination is affected by the scale of the map from which the interpolation is performed.

NAICS Code
North American Industrial Classification System Codes.  These codes uniquely identify industrial classifications.

Native American Land Name
The name of the Native American Land in which the Station is located, if applicable.

NRCS Watershed ID
The Natural Resources Conservation Service (NRCS), formerly known as the Soil Conservation Service (SCS), has standardized a method for subdividing the drainages defined by the HUC scheme, and where it has been implemented extends the HUC by 3 to 6 digits.  The NRCS Watershed identifying scheme is not available in Canada or Mexico, and it is not implemented by all states.

Number in Group
The total number of individuals in a Single Taxon Summary Group or Single Taxon Individual Group.

Number of Replicates
When the laboratory analysis is repeated for quality control purposes, the number of the specific replicate being reported for this specific result.

Ocean Name
For Stations located in the Ocean, offshore of North America, the name of the Ocean in which the Station is located.

On Reach Ind
Y (yes) or N(no); is the Station actually on the reach segment to which it is ascribed.

Organization ID
An 8-character code that uniquely identifies the Organization.

Organization Name
The name of the Organization.

Orientation to Current
The name of the orientation of the equipment with respect to the water current (e.g. down current).

Other Estuary
Where the Station's location is best described by a colloquial term commonly used to identify the estuarine waters on which it is located.

Particle Size Basis
User defined free text describing the particle size class for which the associated result is defined.

Pass Count
The number of times the electroshock gear was swept through the water from which the Sample was collected.

Pass Length Measure
The distance through which the electroshock was swept on each pass (assuming passes of equal length) through the water from which the Sample was collected.  This field also includes the code that represents the units in which the pass length is expressed.

Permanence
The code that describes the flow frequency of a Spring, e.g. continuous, intermittent.

Phys/Bio Ind
This is used to determine whether or not Single Taxon Frequency Classes are defined by Physical Measures such as length or weight, or Biological Conditions such as sex or lifestage.

Pipe Number
Uniquely identifies a pipe within the facility.  When a location point is a pipe, it is assigned an identifying numerical code by its owner.

Point Sequence Number
Every boundary point and sampling point is assigned a sequence number.  For boundary points, the sequence number determines the logical order for a boundary traverse.

Point Name
User-specified free text name by which a specific absolute location point will be known.

Pollution Tolerance
For entries representing taxa, a code representing the ability of the reported taxon to tolerate pollution.

Portable Data Logger
This field consists of two values.  The first is a mandatory, system generated number representing a single recording event during the deployment of a hand-held data logger and the other is a user-assigned text identifier further describing the single recording event during deployment of the device

Precision
Estimate of the maximum possible error in the result (e.g., Counting error in determining radiological beta particle counts).

Pres Storage Proc
Free text description providing additional information about the preservation and storage of the sample.

Primary Estuary
For Stations located in a defined estuary, the name of the Primary Estuary in which the Station is located.

Primary Type
A descriptor which generally characterizes the nature of the site being monitored.

Proc Exception
The description of the procedure exception.

Project description
The description of the project.

Project Document/Graphic Name
A Project may be further described by a document or graphic. This field defines the title of the documents/graphics which further defines this Project.

Project Document/Graphic URL
A Uniform Resource Locator (URL) is an address of a file accessible on the internet. In this case, it is the address of a Document/Graphic describing a Project.

Project Name
The name of the project.

Pulse Rate Measure
The number of times the electric current is interrupted in one second during use of the gear.

Top

Recovery Indicator
A code indicating whether the reported result has been adjusted in accordance with a recovery factor.

Regular Results
Non-biological physical and chemical results.

Rel Current Dir (Non-Tow)
The direction of water current movement relative to the bow heading of the trawling boat. It is measured in degrees clockwise from the bow heading, with zero indicating a bow heading directly into the current.  Recorded in degrees from 0-359; 0 is into the current, 90 is perpendicular to the current with the current running right to left, 180 is with the current and 270 is perpendicular to the current with the current running left to right.  This current direction is when Net Towing is NOT being performed.

Rel Current Dir (Tow)
The direction of water current movement relative to the bow heading of the trawling boat.  It is measured in degrees clockwise from the bow heading, with zero indicating a bow heading directly into the current.  Recorded in degrees from 0-359; 0 is into the current, 90 is perpendicular to the current with the current running right to left, 180 is with the current and 270 is perpendicular to the current with the current running left to right.  This current direction is when Net Towing is being performed.

Rel Wind Dir (Non-Tow)
The direction of wind movement relative to the bow heading of the trawling boat.  It is measured in degrees clockwise from the bow heading, with zero indicating a bow heading directly into the wind.  Recorded in degrees from 0-359; 0 is into the wind, 90 is perpendicular to the wind with the wind blowing right to left, 180 is with the wind and 270 is perpendicular to the wind with the wind blowing left to right.  This wind direction is when Net Towing is NOT being performed.

Rel Wind Dir (Tow)
The direction of wind movement relative to the bow heading of the trawling boat.  It is measured in degrees clockwise from the bow heading, with zero indicating a bow heading directly into the wind.  Recorded in degrees from 0-359; 0 is into the wind, 90 is perpendicular to the wind with the wind blowing right to left, 180 is with the wind and 270 is perpendicular to the wind with the wind blowing left to right.  This wind direction is when Net Towing is being performed.

Replicate Number
User-assigned number applied to samples of the same type, medium, etc. to differentiate between them (e.g., Water Replicate 1 and Water Replicate 2).  Note: This applies only to certain Activity Categories for Samples (e.g., replicate, field replicate, depletion replicate, sample created from sample) and Measurements (measurement replicate)- not Observations.

Result Comment
Comments made about the result.

Result Free Text
A text description of the result.

Result Document/Graphic Name
A result may be further described by a document or graphic.  This field defines the title of the documents/graphics which further defines this result.

Result Document/Graphic URL
A Uniform Resource Locator (URL) is an address of a file accessible on the internet.  In this case, it is the address of a Document/Graphic describing a result.

Result Value as Number
The numeric representation of the result value for fully numeric values.  Note: This value will be determined by converting the text values from Value Text.  This conversion to numeric is always attempted during data entry, and when successful, its result is placed in this field.

Result Value as Text
The alphanumeric representation of the result of analyzing, measuring, or observing a Characteristic.  Note: All numeric values will also be stored numerically in Result Numeric Value to support mathematical computations.  Reports will display the text form of all results, preserving the exact form in which data entry was done.  Characteristics for which values must be taken from permitted text values will carry NULL in the corresponding Result Numeric Value field, and their chosen textual value in this field.  *TEXT signifies that the result consists of long free text.  The actual long free text is stored in Text Result.  *Present<QL, *Present>QL, and *Not Detected are textual entries in this field to indicate that a detection condition exists.

RF1 Mileage
Where an RF1 segment is given, the mileage between the downstream end of the segment and the Station, or the point on the segment which best represents the Station.

RF1 Segment Code
RF1 is a reference to a numbering scheme for stream segments adopted by EPA during the 1970's to identify and logically connect the large streams of the United States.  RF1 stream segments are not applicable to streams in Canada or Mexico.

RF1 Segment Name
For Stations in the United States (only), the name of the stream containing the segment on which the Station is located.

S/G/O Indicator
This field is valued at "S" for Surface, "G" for Ground, or "O" for Other based on Station Type.

Sample Collection ID
The short name (i.e., abbreviation or acronym) for procedure used to collect or create the field sample.

Sample Fraction
The text name of the portion of the sample associated with results obtained from a physically-partitioned sample.  Examples:  - dissolved  - suspended  - total

Sample Handling Desc
Free text description providing additional information about the preservation and storage of the sample.

Sample Prep Proc
A combination of the long name of the Sample Preparation Procedure and the brief acronym representing the Organization which publishes the official description of the procedure (e.g. APHA).

Sampling Duration
The length of time the Trap or Net is considered to be operational (i.e., collecting) and the code that represents the units in which the sampling duration is expressed.

Secondary Type
Further describes the nature of the Station within the category identified by the Primary Type.

Secondary Estuary
For Stations located in complex estuaries, the name of the secondary estuary within the primary designation.

Spring Other Name
An alternative or colloquial name used to further identify the Geologic Unit or Aquifer which feeds the spring.

Spring Type Improvement
The code that describes the man-made improvement made to the Spring.

State
The full name of the State or Province in which the Station is located.

State Postal Code
The official U.S. Postal Service abbreviation for the State.  Province abbreviations for Canada, and state abbreviations for Mexico are not official.

Station Document/Graphic Name
A station may be further described by a document or graphic.  This field defines the title of the documents/graphics which further defines this station.

Station Document/Graphic URL
A Uniform Resource Locator (URL) is an address of a file accessible on the internet.  In this case, it is the address of a Document/Graphic describing a station.

Station ID
A 15-character code which uniquely identifies the Station within the Organization.

Station Latitude
See Latitude

Station Longitude
See Longitude

Station Name
A 60-character text field which provides a descriptive name for the Station.

Statistic Type
A statistic or calculation type which describes the reported result (e.g., average, mode, median, MPN).

Subject Taxon
A combination of the name of the taxonomic characteristic as it is to be displayed on windows and reports, and a number assigned as a part of the taxonomic identification.  Used with a valid genus or higher rank name to indicate a unique species has been observed but not taxonomically identified (e.g., Lepomis sp.1).

Top

Temp Pres Type
The means by which a sample was preserved using temperature.

Temperature Basis
The name that represents the controlled temperature at which the sample was maintained during analysis.

Total Energzed Time
Total time during the sample collection event that the electrodes were in the water and effective voltage was applied.  For pulsed or intermittent electroshock procedures, this is not the same as elapsed time.  This field also includes the code that represents the units in which the sampling duration is expressed.

Trap Net Comment
User-defined text that provides further information about the Trap or Net Operation.

Trawl Comment
User-defined text that provides further information about the Trawl Operation.

Trawl Start
Identifies the location at which a trawl or horizontal tow began.

Trawl Start Depth
The measure of the distance from the surface to the bottom where the trawl started.  This field also includes the code that represents the units in which the bottom depth is expressed.

Trawl Start Latitude
The measure of latitude in decimal degrees (-90.0 to 90.0) indicating angular distance North or South of the equator where the trawl began.

Trawl Start Longitude
The measure of longitude in decimal degrees (-180.0 to 180.0) indicating angular distance west or east of the prime meridian where the trawl began.

Trawl Start Point Name
User-specified free text name by which a specific absolute location point will be known.  This name refers to the location which a trawl or horizontal tow began.

Trawl Stop
Identifies the location at which a trawl or horizontal tow ended.

Trawl Stop Depth
The measure of the distance from the surface to the bottom where the trawl ended.  This field also includes the code that represents the units in which the bottom depth is expressed.

Trawl Stop Latitude
The measure of latitude in decimal degrees (-90.0 to 90.0) indicating angular distance North or South of the equator where the trawl ended.

Trawl Stop Longitude
The measure of longitude in decimal degrees (-180.0 to 180.0) indicating angular distance west or east of the prime meridian where the trawl ended.

Trawl Stop Point Name
User-specified free text name by which a specific absolute location point will be known.  This name refers to the location which a trawl or horizontal tow ended.

Trophic Level
For entries representing taxa, a code representing the trophic level with which the reported taxon is typically assigned.

Trip ID
The Organization-assigned alphanumeric code that identifies a Trip.  This number must be unique within the Organization.

Trip Name
The long name assigned by the Organization to the Trip.

Units
The unit of measure.

Upper Quantification Limit
Represents the largest amount of the target substance which could be quantified by the instrument/analytical process employed to determine the result.  Values above the minimum and below the maximum quantitation limits are reported as valid numeric results.

Upr Lwr Depth Unit
The code that represents the units in which the upper and lower depth to activity is expressed.

Activity Depth Ref Point
It describes the reference point from which the depth is measured, typically "Surface".

USGS Geologic Unit Code-Name
The official United States Geological Survey (USGS) National Water Information System (NWIS) II code which identifies the Geologic Unit and the official USGS NWIS II name which identifies the Geologic Unit.

USGS Lithologic Unit Code-Name
The official United States Geological Survey (USGS) National Water Information System (NWIS) II  code which identifies the Lithologic Unit and the official USGS NWIS-II name of the Lithologic Unit.

Value Type
A name that represents the process which was used in the determination of the result value, (e.g., actual, estimated, calculated).

Visit Num
The Organization-assigned alphanumeric code that identifies a Station Visit for the Trip and visited Station.

Visit Start
Combination of the date and time that the Station Visit commenced.  Note: Defaults to Trip Start Date.

Visit Start Time Zone
The time zone of the Station Visit Start.

Visit Stop
Combination of the date and time that the Station Visit concluded.

Visit Stop Time Zone
The time zone of the Station Visit Stop.

Voltage Measure
The magnitude of the electro-motive force (volts) applied to the electroshock equipment used to collect the Sample.

Voltinism
A duration required to complete a life cycle or generation.

Weight Basis
The name that represents the form of the sample or portion of the sample which is associated with the result value (e.g., wet weight, dry weight, ash-free dry weight).

Well Name
The name of the Well.  User defined text.

Well Number
Uniquely identifies a well within a Station.  When a location point is a well head, it is assigned an identifying numerical code by its owner.
 

Top
 
 
 
 



 
 

Comments? If you have a question or comments on this website or on the STORET system,
please call STORET User Assistance at 1-800-424-9067,
or send us an email at STORET@epa.gov.











 
Begin Site Footer

EPA Home | Privacy and Security Notice | Contact Us