Note: EPA no longer updates this information, but it may be useful as a reference or resource.
Katrina Warehouse Help
Station Report
Stations by Geographic Location
Stations by Organization and Station ID
Result Reports
Regular 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
Organization/Station Selection
Organization/Project Selection
Station Type Selection
Organization Selection
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
Regular Result Data Elements
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
Overview of System
You are preparing to extract data from EPA's KATRINA Data Warehouse. The data on this web site are broken down into two major categories: Stations and Results. The Station area has the selection options of Stations by Geographic Location and Stations by Organization and Station ID. The Result area has the selection options 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.
The Stations by Geographic Location option has the following groups of criteria: Geographic Location, Station Types, Characteristics, and Organizations. The available search criteria within the groups are:
The Stations by Organization and Station ID option has the following groups of criteria: Organization/Station ID, Station Types, and Characteristics. The available search criteria within the groups are:
The Results by Geographic Location option has the following groups of criteria: Geographic Location, Date Ranges, Characteristics and Activity Medium. The available search criteria within the groups are:
- State/County
- Latitude/Longitude
- Drainage Basin/HUC
- Date Ranges
- Characteristics
- Activity Medium
- Activity Intent and Community Sampled
The Results by Station option has the following groups of criteria: Organization/Station, Date Ranges, Characteristics and Activity Medium. The available search criteria within the groups are:
- Organization/Station
- Date Ranges
- Characteristics
- Activity Medium
- Activity Intent and Community Sampled
The Results by Project option has the following groups of criteria: Organization/Station, Date Ranges, Characteristics and Activity Medium. The available search criteria within the groups are:
- Organization/Project
- Date Ranges
- Characteristics
- Activity Medium
- Activity Intent and Community Sampled
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.
Regular Result Reports
The Regular Result Report consists of chemical and microbial results data. 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, Date
Range Selection, and Characteristic
Selection. For the Regular Result report you can also search for
Results using Activity
Medium 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 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. 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, Date
Range Selection, and Characteristic
Selection. For the Regular Result report you can also search for
Results using Activity
Medium 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 Result Search and proceed to
the next page. To reset all search criteria to default values, click on
the <Clear Form> button.
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 Regular Results by Geographic Location reports. 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 KATRINA 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.
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, KATRINA Parm
Code) or the Characteristic Name itself.
Characteristic Searches
You have been given the option to use a variety of Characteristic Identifiers (e.g.,
Characteristic Name, Systematic Name, CAS Number) to select
Characteristics. The default is Characteristic Name. Select the specific Characteristic Identifier
for which you wish to search. Enter as many characters of the selected
Characteristic Identifier 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 Identifier you
selected and 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 selected Characteristics
will appear in the selected Characteristic Name list.
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.
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.
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.
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.
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. 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.
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.
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
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.
Result Search Summary Page
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. 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.
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.
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 Limit (w/units)
Detection Limit Descript
Lower Quantification Limit
Upper Quantification Limit
Data Elements for Other
Lab Info
Lab ID
Lab Name
Lab Cert
Lab Batch ID
Analysis Date
Analysis Date Time Zone
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.
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.
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 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.
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."
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.
CAS Num
Chemical Abstract Service Registry Number. It is a unique identifier for
chemicals.
Characteristic Name
The name of the characteristic as it is to be displayed on windows and reports.
Class Lower Bound
Represents the value of the lower bound of the result class interval.
Class Upper Bound
Represents the value of the upper bound of the result class interval.
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 KATRINA 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 KATRINA.
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.
Detection 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 Limit Descript
Text providing further description and comment on the detection and/or quantitation limits, for example "Instrument Detection
Limit".
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 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.
FIPSCounty 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.
FIPSState 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.
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 LakeName
For Stations within any of the five Great Lakes, the name of the Great Lake on which the Station is
located.
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.
Latitude
The Latitude (in decimal degrees) at which the Station's Point of Record is
located. Latitudes South of the Equator are negative. Every KATRINA
Station has a Point of Record.
Location Point Type
Stations in KATRINA 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.
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
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.
Permanence
The code that describes the flow frequency of a Spring,
e.g. continuous, intermittent.
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.
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.
Recovery Indicator
A code indicating whether the reported result has been adjusted in accordance
with a recovery factor.
Regular
Results
Chemical and microbial results.
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).
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.
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.
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.
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.
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.