# DataDictDocumentation

Documentation:
COPYRIGHT NOTICE:
 
  DataDict  and all associated files and documentation
  Copyright © 1998-2001 Steve Tessler.    All Rights Reserved

 LICENSE: DataDict

  DataDict (the SOFTWARE) is provided as Freeware.  That means that DataDict is
  copyrighted (not public domain) but you are not charged for your copy and  you can't
  make anyone else pay for a copy.  No registration of any kind is required.
  If you want to thank me, think of me when you do your next good deed.

  For customized versions or permission to distribute the Software electronically or with
  commercial or shareware programs, contact the author.

  Permission is hereby granted, without written agreement and without license or royalty fees, to
  use, copy and/or distribute the software, provided that:

  - the Software is not distributed for profit
  - the Software is not bundled with or incorporated into any other software without the author's
           written permission
  - all copyright notices are maintained unchanged on all files and Software
  - the Software and documentation is not modified in any way
  - you do not attempt directly or indirectly to disassemble/reverse-engineer the program code
  - any distribution of this Software includes all and only original files, including the program,
          supporting files, and license
  - you acknowledge that the Software is not warranted to be free of bugs
  - you agree to the complete license agreement 

  YOU ARE NOT ENTITLED TO ANY OF THE RIGHTS GRANTED BY THIS LICENSE IF YOU
  DO NOT AGREE TO BE BOUND BY THE TERMS OF THE  LICENSE AGREEMENT.  
  THIS SOFTWARE IS PROVIDED "AS IS" AND WITHOUT WARRANTY. ANY EXPRESS OR
  IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
  WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
  DISCLAIMED. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR ANY DAMAGES
  WHATSOEVER (INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF BUSINESS
  PROFITS, BUSINESS INTERRUPTION, LOSS OF BUSINESS INFORMATION, OR OTHER
  PECUNIARY LOSS) ARISING OUT OF THE USE OF OR INABILITY TO USE THE SOFTWARE,
  EVEN IF THE AUTHOR HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. 

  The SOFTWARE is provided with RESTRICTED RIGHTS. Use, duplication, or disclosure by
  the Government is subject to restrictions as set forth in subparagraph (c)(1)(ii) of The Rights in
  Technical Data and Computer Software clause at DFARS 252.227-7013 or subparagraphs (c)(1)
  and (2) of the Commercial Computer Software -- Restricted Rights at 48 CFR 52.227-19, as
  applicable.  Manufacturer is Steven Tessler, 78 Suburban Lane, Upper Darby, PA, 19082, U.S.A.
  (Email: UnTools@email.com)

  All trademarks and registered trademarks are the property of their owners.


Header:
This is general information and instructions for DataDict

Documentation:
**This is the Help from the FULL VERSION of DataDict available from the website listed below. **

** This custom version does not allow updating of the dictionary information. **

** This custom version is licensed only for distribution with the NDAMS database. **

*-------------------------------------------
 COPYRIGHT NOTICE:
 
 DataDict  © 1998-2001 Steve Tessler.    All Rights Reserved.
 Email: UnTools@email.com
 Website: www.CleanDataSystems.com

  Purpose
  License
  Requirements
  Support
  Disclaimer
  Considerations
  Loading your Database Information
  Known problems
  Note on naming conventions

 PURPOSE:

  DataDict is a tool to help with documenting a database.  It produces a reasonable report of Table
  and Field information,  and has 'browsers' that let you examine the database metadata in different
  ways, but its main purpose is to assist *you* with ensuring that each table and field is correctly
  described and has the appropriate property settings.


 LICENSE:

  The comments here are not a substitute for the full License agreement.  The complete License
   agreement can be viewed from the 'About' button of DataDict.  Your installation or use of the
   DataDict constitutes your acceptance of the terms of the License.  You assume all risks
   associated with the use or misuse of DataDict on your system, files, and data.

  DataDict is provided to you as freeware.  DataDict and its documentation are copyrighted.
  You are not charged for your copy, can't charge anyone else for a copy, and no registration
  of any kind is required.  Feel free to share DataDict with others.  If you want to thank me, think
  of me when you do your next good deed.


 REQUIREMENTS:

  Minimum: You need Access 97 to use the current release version of DataDict.
                      You also need at least one defined table with one field in your database.

 SUPPORT:

  Since DataDict is provided to you without charge, the License should not imply and does
  not entitle any user to support for solving data problems using DataDict, and it does not
  guarantee that I will quickly repair any bugs you may discover.  However, I use DataDict
  myself and would be interested to hear of any problems you have using DataDict that are
  not covered in this document.  You can contact me via email at:

                                  UnTools@email.com
  
  I would also like to hear from anyone who finds DataDict useful.  Let me know how things
  should act if you wished they acted differently.  Since I only work on this in my mythical spare
  time, a little encouragement wouldn't hurt either.


 DISCLAIMER:

 * CAUTION:  Always WORK ON A *NEW* COPY of your data, NOT YOUR *ONLY* COPY of
    your data.   You should ALWAYS BACKUP YOUR DATA REGULARLY.

*  DataDict is not warranted to be free of bugs.  In fact, there is no warranty of any kind.
    Unlike the incredible diversity of invertebrates in nature, any 'bugs' in DataDict are not to be
    admired.   I've tested and used DataDict extensively, but can't anticipate all of the situations
    you may encounter with your own data, software and hardware.  See the SUPPORT section
    above to report problems.


 CONSIDERATIONS:

 ** When viewing the DataDict information about your database, you may be tempted to
      edit it.  This defeats the whole purpose of DataDict, in that it should be reporting FROM
      your database and not just displaying information you've typed into an unrelated report.

    When you find that the information shown through DataDict is not correct, you must fix it in
     your database and repeat the dictionary generation steps described below.  Now when
     you examine the report in DataDict again, your changes should be shown.  This is the
    only way to make sure your database is documented and correctly configured even
    without any accompanying documentation (but you know you want to provide that too!).

 ** The current version of DataDict is tuned for some naming conventions (see end of this
     document) that affect how different browsing tools function.  (The report does not depend upon
     these naming conventions.)  If you are not seeing what you need, DataDict may not be for you
     at this point.  With the note above in mind, feel free to edit the tblFieldDefinition information to
     alter the display as you see fit when DataDict is not performing for you rather than showing
     errors in your database that need correcting.

 ** COMPACT DataDict database periodically to remove traces of earlier activity with the current
     or previous ObjectDefinition table used to populate the DataDict tool.  You can often get
     better performance from Access and a smaller file, too.

LOADING YOUR DATABASE INFORMATION

You have to do a few minutes work to use DataDict with your database.  Part 1 is done in your database--the one you want to document.  Part 2 is done in DataDict itself.


Part 1 - within your database.

1.  a.  If an 'Object Definition' table is in your database from a previous session, delete it.

    b.  Consider Compacting your database before beginning (Menu item Tools/Database Utilities/Compact Database), unless it is so large that would take an unpleasant amount of time.

2.  Make sure your database has a 'name' by going to the menu item Tools/Startup, and putting something useful into the field "Application Title:".  Click OK when satisfied.  This name will appear as the main title of the DataDict report.

3.  Select the menu item Tools/Analyze/Documenter.  The Documenter dialog appears.

4.  Select the tab "Tables", and Click "Select All".

5.  Select the tab "Current Database", and Click "Select All".

6.  After you have tagged BOTH tabbed items above, Click "OK".

7.  When the report appears, select the menu item File/Save as Table.  Progress bar activity occurs.

8.  When the table is saved a dialog box appears and says "Successfully created table 'Object Definition'.".  Click OK and close the report window.

9.  Leave your database open.


Part 2 -- within DataDict.

10.  Open DataDict.

11.  Select the Tables tab and check to see if a table named 'Object Definition' already exists from a previous session.  If so, delete it and compact the DataDict database.

12.  Now you need to copy the 'Object Definition' table from your database to DataDict.  The easiest way is to have both databases open and drag the table from your database to DataDict.

     Highlight 'Object Definition' in your database and drag to the
     DataDict tab on your computer taskbar; DataDict's window will open.

     Position your mouse over the database object and the Tables tab
     should open (if not already), let go, and the table will be copied.

13.  You can now delete the 'Object Definition' table within **your original database***, but leave that database open in case you find something you want to fix.  You may also want to delay compacting that database until you've generated the dictionary report that you are satisfied with (and all corrections to your database are completed).  You'll work with 'Object Definition' within DataDict now.

14.  If the DataDict main menu form is not open, open it by double-clicking on the 'frmDataDictMainMenu' form.

15.  Click the button for the menu choice "Refresh Dictionary with new OD".  This will trigger the routines that convert the recursive 'Object Definition' table you just copied into DataDict into entries in tblDBDefinition, tblTableDefintion and tblFieldDefinition.

  If no 'Object Definition' table is found you will be told as much.
  When it is done, it will tell you that, too.

16.  The 'Object Definition' table is automatically deleted after loading in DataDict, but you should compact DataDict to recover the space used for the OD table and other temporary items created/deleted during the generation of the dictionary tables.


To see the results of loading your database information, choose either the table browser or the Preview/Print buttons.

Explore the other buttons at your leisure.


KNOWN PROBLEMS

You must compact DataDict periodically.  I usually compact immediately after loading a fresh Object Definition table (which gets deleted by DataDict when done).  This is not a problem, but DataDict will grow with the excess space the deleted tables take up.

The cover of the dictionary may not have the correct number of 'unique key fields' and 'number of non-key fields', depending upon the naming conventions you use.

If you don't like my report, copy tblDBDefinition, tblTableDefinition and tblFieldDefinition to your own database and make your own reports just how you like 'em.  ;-)


- - - - - - -

Note on naming conventions

Tessler's Table and Field naming conventions

The following naming conventions are used by me and supported completely by DataDict.

All tables have a lower-case three-letter prefix:
tbl - Main data tables.
tds,tdx - domain (lookup) tables (tds - static, tdx - user extendable)
tas,tad - associative tables (tas - simple, all keys; tad - adds 'data')

Fields:
Singular keys (including surrogates) have the root table name plus a suffix of '_ID'.  This allows all keys to be easily recognized within tables, and those not sharing the parent table's root name must be foreign keys representing additional information in the relational design.

Any field having the same name in different tables *must* have the identical definition and other properties--otherwise it is not the same 'field' and should have a different name.

Experiment, explore and have fun.  I hope DataDict helps and saves you time in your work.


# tblFieldDefinition

FieldDesc:
Key which uniquely associates the metadata in this table with a specific report in the bibliography (Citation_ID – tblCitation).


FieldDesc:
Key which uniquely identifies a Storm Type.  Identifies the  type(s) of precipation in storms sampled during the sampling period of a given study.


FieldDesc:
The number of storms sampled during the entire sampling period.


FieldDesc:
Key which uniquely identifies the Subject of a report.  Identifies a keyword code which classifies the subject emphasis of the report.


FieldDesc:
Key which uniquely identifies the Major and Minor subject of a report.  Indicates the primary and secondary subject emphasis of a report.


FieldDesc:
Key which uniquely identifies a Constituent.  Indicates the environmental quality variable(s) tested in a given study.


FieldDesc:
Key which uniquely identifies the matrix of a sample.  Identifies the medium from which samples for analysis of constituents or properties are collected in a given study.


FieldDesc:
Key which uniquely identifies the method used to quantify Hydraulic Conductivity. The method used to quantify the coefficient of proportionality that describes the rate at which water can move through an aquifer or other permeable medium.


FieldDesc:
Key which uniquely identifies the Precipitation Data Source. Identifies the source from which the precipitation data was obtained for a given study.


FieldDesc:
Key which uniquely identifies the Precipitation Distance.  Identifies the approximate distance from a water-quality mornitoring site to a precipitation monitoring site.


FieldDesc:
Key which uniquely identifies the Precipitation Type. Identifies the type of precipitation measured.


FieldDesc:
Key which uniquely identifies the Channel Type.  Identifies the natural or engineered water conduit.


FieldDesc:
Key which uniquely identifies the Sampling Program. Documents the sampling plan for water-quality properties and constituents.


FieldDesc:
Key which uniquely identifies the Month(s) samples were collected. Provides a detailed account of the exact month(s) samples were collected.


FieldDesc:
A brief report summary that contains the general content of the report and may also contain the significant findings and conclusions as discussed in the report.


FieldDesc:
The company, university, agency, or other organization employing the first author during the study period.


FieldDesc:
The company, university, agency, or other organization that funded the project.


FieldDesc:
A referable, obtainable, and published document that is reviewed by technical reviewers who are outside the author's immediate organizational unit .


FieldDesc:
Key which uniquely identifies the Report Type. Identifies the type of report as classified by content.


FieldDesc:
The country, state, municipality, and highway where the original study was conducted.


FieldDesc:
Key which uniquely identifies the Area of Study. Refers to the geographical scale for the study.


FieldDesc:
The number of identified places where samples were taken for a given study.


FieldDesc:
Documents whether the study documented QA/QC procedures.


FieldDesc:
Documents whether the report documented individual data for each sample collected in the study.  Data summaries or averages do not qualify as original data.


FieldDesc:
Key which uniquely identifies the type of Data Presentation. Identifies the type of data presented in a report.


FieldDesc:
Key which uniquely identifies the Data Form.  Identifies the format used to present data in a report.


FieldDesc:
Documents whether the data are available in a useful electronic format in an existing national database, a local, state, or federal repository, or other accessible locations.


FieldDesc:
The quantitative analysis of the propagation of measurement error in the study results. Uncertainty Analysis involves quantifying the error of the measurements taken in the study and calculating the final error of the results.


FieldDesc:
Documented whether the report presented error for individual measurement components or indicated the expected uncertainty in final results without supporting documentation.


FieldDesc:
The time rate of volumetric movement for water and other matrices.  Other names for flow include flow rate and discharge.  the dimensions of flow are [VOLUME/TIME].


FieldDesc:
The quantity of the constituents related to the quantity of the matrix in which the constituent is found.  The dimensions of the concentration are [MASS of constituent/VOLUME of matrix] or [MASS of constituent/MASS of matrix].


FieldDesc:
The total mass quantities of constituents resulting from individual storms.  The dimensions of storm loads are [MASS of constituent/AREA drained] or [MASS of constituent].


FieldDesc:
The total mass quantities of constituents occurring in a year. The dimensions of annual loads are [MASS of constituent/AREA drained] or [MASS of constituent].


FieldDesc:
Space for comments on any of the section's general information categories.


FieldDesc:
Documents the authors recommendations for further studies indicated by reported results.


FieldDesc:
Any problems that the author specifically mentions in the report pertaining to data collection, analysis, and(or) interpretation.


FieldDesc:
Documents whether further detail is given in the report review (i.e. beyond Sections 1,2,7.0, and 8 of the NDAMS Review Sheet).


FieldDesc:
A sequential number used to sort bibliographic references alpha-numerically.


FieldDesc:
The journal/book, volume, and page numbers of the report.


FieldDesc:
Documents whether an abstract is available in the database for the report.


FieldDesc:
Documents whether the report citation was verified as correct and complete.


FieldDesc:
Documents whether the citation verification was done directly or through a secondary source.


FieldDesc:
Documents whether the report was reviewed in accordance with the criteria listed in the National Data and Methodology Synthesis Data Review Sheet.


FieldDesc:
Key which uniquely identifies the Citation Type. Indicates specifically what organization published the report.


FieldDesc:
Water-quality properties that are characterized by measurements such as water temperature, pH, and dissolved oxygen.  These measurements generally are made at a data collection site but may also be measured in a laboratory.


FieldDesc:
A compound, such as calcium chloride or calcium magnesium acetate (CMA), to remove ice and snow from roadways in the winter.


FieldDesc:
Constituents that occur naturally in concentrations greater than 1 milligram per liter.


FieldDesc:
Any substance that is assimilated by organisms and promotes growth; generally applied to any or all of the constituents that contain nitrogen or phosphorus.


FieldDesc:
Metals and similar elements that routinely occur in nature in concentrations less than 1 milligram per liter, usually due to their insolubility.


FieldDesc:
Any measure of (organic and inorganic) particulate matter.


FieldDesc:
The need for molecular oxygen to meet the needs of biological and chemical processes in water. The amount of oxygen dissolved in water becomes a critical environmental constraint on the biota living in the water.


FieldDesc:
A carbon containing compound.  Some examples include organic and inorganic carbon, oil and grease, VOCs, SVOCs, and phenols.


FieldDesc:
A pesticide is any chemical agent (usually organic compounds) used to control the population of specific organisms.  Specifically, an herbicide is any chemical agent used to control plant growth.


FieldDesc:
The science that deals with the study of the organisms (microbes) that can be seen only with the aid of a microscope.


FieldDesc:
The process of enrichment of a lake by nutrients, naturally or by pollution rich dissolved nutrients, commonly phosphorus and nitrogen.  Eutrophication is 
often signaled with a deficiency in dissolved oxygen.


FieldDesc:
Parameters indicating the effect of stormwater on the ecological environment.


FieldDesc:
A procedure to determine the toxicity of a chemical or an effluent to a predetermined species of living organisms.  Measure of acute or chronic effects on test organisms exposed to a specific chemical or effluent.


FieldDesc:
Any constituent given in a report that could not be readily assigned to the above constituent classes using published materials or expert input.


FieldDesc:
Key which uniquely identifies Geologic Material. Characterizes the unconsolidated materials in the aquifer that the ground water flows through.


FieldDesc:
Key which uniquely identifies Confinement of the aquifer. characterizes the type of aquifer (confined vs. unconfined).


FieldDesc:
Refers to whether continuous (ground) water level recording equipment was used in the study.


FieldDesc:
Describes the type of continuous water level equipment used in the study.


FieldDesc:
The numerical estimate associated with the error of the ground water level measurements.


FieldDesc:
The location used for monitoring the flow of water being sampled relative to the location used for water-quality sampling.


FieldDesc:
Particles of liquid water or ice that fall through the atmosphere and may reach the ground.


FieldDesc:
Process in which a substance (such as water) in the liquid state or solid state passes into the vapor state.


FieldDesc:
Water on the surface of the earth whose surface is naturally exposed to the atmosphere; for example, rivers, lakes, seas, and estuaries.


FieldDesc:
This is the subsurface zone between the water table and the land surface where pore spaces contain water as well as air and other gases.


FieldDesc:
Water that flows or seeps downward and saturates soil or rock.


FieldDesc:
Any flow location given in a report that is not an option listed above.


FieldDesc:
A place for other information on surface water, groundwater,  precipitation or information on methods for determining other types of flow.


FieldDesc:
Key which uniquely identifies the type of Precipitation Measurement collected. Identifies the form of precipitation data collected.


FieldDesc:
Key which uniquely identifies the Precipitation Minimal Interval between measurements. Documents the approximate time interval between precipitation measurements, such as sec, min, hourly, and daily.


FieldDesc:
Key which uniquely identifies the Method used to collect Precipitation measurements. Identifies whether precipitation measurements were done automatically and(or) manually.


FieldDesc:
Key which uniquely identifies the Method used to collect Flow data. Identifies the method used to determine the flow rate of surface water.


FieldDesc:
The measurement of the depth of flow relative to an arbitrary datum point.


FieldDesc:
The measurement of the volume of water passing a specified point for a specific time frame.


FieldDesc:
The measurement of the speed (linear rate of movement) and direction of the flowing water.


FieldDesc:
The physical characteristics of a channel such as a natural constriction, a long straight reach, a stretch of rapids, or an artificial structure downstream from a gaging station that determines the stage-discharge relation at the gage.


FieldDesc:
Regular maintenance and cleaning of the hydraulic control used to determine flow.


FieldDesc:
Key which uniquely identifies Rating.  Identifies the stage-discharge relationship for the channel or water body.


FieldDesc:
Checking of the rating relationship with newly measured stage and discharge data for the channel.


FieldDesc:
The propagation of measurement errors in the reported flow result.


FieldDesc:
Flow measurements that are independent of a stage-discharge relationship.


FieldDesc:
Continuous monitoring of flow by an automatic machine.


FieldDesc:
The brand or model of the instruments as well as any additional information about the flow monitoring equipment.


FieldDesc:
The appropriateness of the equipment's range of measurable values relative to actual flow values.


FieldDesc:
Flora or fauna occurring in the study region such as bacteria, algae, invertebrates, and other organisms that is sampled.


FieldDesc:
Precipitation, runoff, surface water, pore water, or groundwater that is sampled.


FieldDesc:
Soil, dust, sweepings, or particulate material that is in suspension in water or recently deposited from suspension that is sampled.


FieldDesc:
Any matrix  in gaseous form that is sampled.


FieldDesc:
Any other matrix sampled which is not in one of the categories above.


FieldDesc:
The written plan detailing use of QA/QC protocols for the field study.


FieldDesc:
The systematic examination of the implementation of the QA/QC plan and the procedures by properly trained personnel outside of the immediate organizational unit.


FieldDesc:
An assessment of the methods used to collect, reduce, interpret, characterize, and report project data and results.


FieldDesc:
A qualitative on-site evaluation of measurement and data collection programs.


FieldDesc:
The process of standardizing field equipment to eliminate bias or systematic errors.


FieldDesc:
The practice of cleaning containers before new rounds of sampling.


FieldDesc:
A sample of purified water  that tests the concentration of constituents introduced by a container usually before and after containers have been cleaned.


FieldDesc:
Any QA/QC processes that evaluate variability, bias, and effectiveness of preservation practices.


FieldDesc:
Any QA/QC processes that evaluate variability, bias, and effectiveness of filtering practices.


FieldDesc:
A pure standard solution taken to the sampling site, exposed to the sampling locations, and treated exactly like the environmental samples in order to check for analytical artifacts.


FieldDesc:
A pure standard solution passed through the sampling, splitting, or filtration equipment, then treated like a sample and returned to the laboratory as a sample in order to check the cleanliness of the device.


FieldDesc:
The process of  testing of a portion of the water used as the source of the pure standard solutions in order to confirm that the pure standard solution is free of contamination.


FieldDesc:
A sample prepared in the field by adding a known mass of target analyte to a specified amount of matrix sample for which a corresponding unspiked sample is also available.


FieldDesc:
A sample prepared in the field by adding a known mass of target analyte to a specified amount of reagent sample for which a corresponding unspiked sample is also available.


FieldDesc:
A subsample submitted for analysis with a composition and identity known to the submitter (usually the field project staff) but unknown to the analyst in order to test the analyst’s or laboratory’s proficiency.


FieldDesc:
Two or more representative portions of a sample or subsample that are analyzed by different analysts or laboratories to ensure repeatability of measurements and test laboratory variability or interlaboratory bias.


FieldDesc:
Two or more samples taken at the same time that represent the same space and population.  The samples are independently carried through all steps of the sampling and measurement process in an identical manner.


FieldDesc:
Two or more samples taken one after another within minutes that represent the same space and population.  The samples are independently carried though all steps of the sampling and measurement process in an identical manner.


FieldDesc:
Two or more pure standard solutions that are independently carried though all steps of the sampling and measurement process in an identical manner.


FieldDesc:
Two or more samples taken by different sampling teams.  The samples represent the same population, time and space.  The samples are independently carried through all steps of the sampling and measurement process in an identical manner.


FieldDesc:
Two or more samples taken by different sets of equipment of the same type.  The samples represent the same population, time, and space.  Samples are independently carried through all steps of the sampling and measurement process in an identical manner.


FieldDesc:
Participation in a study of results from many laboratories.


FieldDesc:
Systematic evaluation by an outside organization to determine compliance with operational plans such as analysis plans, and QA program and project plans.


FieldDesc:
The written plan for use of QA/QC protocols for the laboratory.


FieldDesc:
Documents whether the report gives a reference for the QA/QC plan.


FieldDesc:
Process that confirms that the period of time between collection and analysis is within the established period of time during which a water sample can be stored after collection and preservation without significantly affecting the accuracy of analysis.


FieldDesc:
Confirmation that the samples are stored under conditions that will not significantly affect the accuracy of analysis.


FieldDesc:
The comparison of data entered for reporting with the original lab sheets completed by analysts.


FieldDesc:
The process of testing and calibrating laboratory equipment to eliminate bias or systematic errors.


FieldDesc:
The process of verifying the effectiveness of laboratory methods by testing samples with known amounts of the analyte.  This includes method blanks.


FieldDesc:
The process of taking two or more representative portions from a sample or subsample and having them each analyzed in order to ensure the repeatability of the measurements of interest.


FieldDesc:
Confirmation by analysis of manufacturer certification that the composition of the reagent is of appropriate purity for intended uses.


FieldDesc:
Program of submitting samples for analysis with a composition known by the submitter, but unknown to the analyst in order to test the analyst's or laboratory's proficiency.


FieldDesc:
A blind sample program run by an organization outside of the laboratory.  In other words, the submitter of the blind sample is from an established laboratory-evaluation program outside of the laboratory.


FieldDesc:
Quality control from the field to the laboratory.


FieldDesc:
A sample prepared in the laboratory by adding a known mass of target analyte to a specified amount of matrix sample for which a corresponding unspiked sample is also available.


FieldDesc:
A sample prepared in the laboratory by adding a known mass of target analyte to a specified amount of reagent sample for which a corresponding unspiked sample is also available .


FieldDesc:
Two or more representative portions taken from a sample or subsample and analyzed by different analysts within a given laboratory in order to ensure the repeatability of measurements of interest and test laboratory variability.


FieldDesc:
Defines the geographic location and describes environmental variables that may affect the biological assessment at a site.


FieldDesc:
Human made structures or facilities to control or use water.  Natural-lake is an exception to this definition.


FieldDesc:
The part of a body of flowing water that changes the form of the underlying geology and topography.


FieldDesc:
The layer of material beneath the surface soil on the bottom of the body of water.


FieldDesc:
The native environment or specific surroundings where a plant or animal naturally grows or lives.


FieldDesc:
Any factor that might explain changes to the form of the underlying geology and topography.


FieldDesc:
A map showing locations of site characteristics listed in this section.


FieldDesc:
The existence of vegetation in, on, or along bodies of water.


FieldDesc:
Key which uniquely identifies the Detection Limits Reported. Documents the concentration below which a laboratory will not report the determination of a concentration.


FieldDesc:
The procedures (commonly referred to as “clean hands/dirty hands”) that are designed to control the contamination of attenuation of analytes during the sample collection and handling processes.


FieldDesc:
Documents whether the filter type (brand name) is reported.


FieldDesc:
Documents whether the filter pore size is reported.


FieldDesc:
Documents whether the material the filter is composed of is reported.


FieldDesc:
Documents whether the filter size (diameter) is reported.


FieldDesc:
The materials that physically contacted the samples during collection.


FieldDesc:
The materials that physically contacted the samples during field and lab processing.


FieldDesc:
The program used to minimize undesirable chemical reactions in the sample container.


FieldDesc:
The methods that make equipment free of living organisms prior to sampling.  This includes general cleaning and removal of contaminants.


FieldDesc:
The methods employed during sample collection, handling, and processing that keep samples from being contaminated by living organisms not originally in the sampling matrix.


FieldDesc:
Key which uniquely identifies the Microbiology Collection Method. Identifies how the samples represent variations in space.


FieldDesc:
Techniques that maintain the integrity of the sample between collection and analysis.


FieldDesc:
The length of time between collection and analysis of the samples.


FieldDesc:
The type of sample that was used to collect organic samples, such as a plastic bucket or an automatic ISCO 1680 sampler.


FieldDesc:
Documents whether the sampler was cleaned prior to each sampling round.  Common cleaning methods include washing the sampler with distilled water between sampling rounds.


FieldDesc:
Documents whether a sample was taken at a location where volatilization (off gassing as vapor) occurred before sampling.  Volatilization can occur when water falls, such as from a pipe outfall.


FieldDesc:
Documents whether the sampler uses suction in sample collection and thus induces volatilization.


FieldDesc:
Documents whether the maintenance schedule for a highway site is given in the report.


FieldDesc:
Documents whether samples were collected after pesticides were applied to the area.


FieldDesc:
The act of adjusting the output reading of analytical measurement instrumentation using documented standard reference marks to validate and document the instrument readings, to maximize accuracy and precision, and to eliminate systematic bias.


FieldDesc:
The manual or automatic methods used to ensure that variations in air and water temperature do not introduce bias or decrease the accuracy and precision of the environmental instrumentation readings.


FieldDesc:
The actions taken (on a regular basis) to manually inspect, clean, calibrate, and if necessary replace the environmental instrumentation.


FieldDesc:
Sampling that occurs with the fluid in the sampling nozzle moving at the same velocity as the effluent stream.


FieldDesc:
The comparison of automatic or grab sampling data to isokinetic sampling data.


FieldDesc:
The brand and (or) model of the equipment used to sample for solids in fluids.


FieldDesc:
The diameter of the nozzle used to direct the fluid into the sampling container.


FieldDesc:
The amount of time it takes to sample a cross-section of the flow.


FieldDesc:
The position of the hydrograph at the time of sampling for aqueous solids.


FieldDesc:
Documents whether samples were collected for the duration of the runoff event or storm event.


FieldDesc:
The name of the lab used to process sediment samples.


FieldDesc:
Documents whether the sediment laboratory participates in an external, documented, and comprehensive QA/QC program.  The U.S. EPA has a lab certification program.


FieldDesc:
This refers to the depth in the water column or the soil strata where samples were collected.


FieldDesc:
The comparison of data obtained by different sampling personnel.  Calibration includes adjustment of the data to account for systematic errors.


FieldDesc:
Key which uniquely identifies the Change in Stage. Documents the change in hydrograph stage at the time of sampling. (Stage is the height of water above an arbitrary datum.)


FieldDesc:
Documents whether water levels (stage) were measured and recorded throughout the sampling period.


FieldDesc:
Documents whether  water-quality (QW) properties were measured and recorded throughout the sampling period.  Water-quality properties refer to physicochemical measurements indicating water quality.


FieldDesc:
Key which uniquely identifies the Sampling Method.  Documents the sampling plan for water-quality properties and constituents.


FieldDesc:
Refers to how the samples represent variations in time.


FieldDesc:
Refers to how the samples represent variations in space.


FieldDesc:
Key which uniquely identifies the Compositing Method used. Documents the methods used to create composite samples in either time or space.


FieldDesc:
The method for determining the mixing ratios in the composite sample.  Examples include flow weighted and time averaged.


FieldDesc:
Refers to samples taken from the first runoff after the start of a storm.


FieldDesc:
Refers to the materials that physically contacted the samples during sample collection and handling.  Typical materials include metal, plastic, polyethylene, and rubber.


FieldDesc:
A record of every person who had possession of the sample during collection and analysis. Chain-of-custody is required for any sample data to be admissible in court proceedings.


FieldDesc:
Documents whether the sample was mixed to create a uniform sample before analysis, especially if the sample settled during collection, transportation to the lab or during shelf life.


FieldDesc:
Refers to the methods employed for sample preservation, such as freezing or chemical processing.


FieldDesc:
The documented length of time between sample collection and direct analysis in the field or transport to the lab for analysis.


FieldDesc:
The documented length of time the sample was stored in the lab before it was analyzed.


FieldDesc:
Refers to the materials that come into physical contact with the sample while in the field after collection and before lab analysis.


FieldDesc:
Refers to the materials that come into physical contact with the samples during laboratory  processing.


FieldDesc:
The name of the laboratory used to analyze the samples.


FieldDesc:
Refers to whether or not the laboratory participates in an external, comprehensive, documented QA/QC program.  For example, the U.S. EPA has a lab certification program.


FieldDesc:
The water sampled on the surface of the earth whose surface is naturally exposed to the atmosphere; for example, rivers, lakes, seas, and estuaries.


FieldDesc:
The subsurface zone between the water table and the land surface where pore spaces contain water as well as air and other gases (also known as the vadose zone or zone of aeration).


FieldDesc:
The water sampled that flows or seeps downward and saturates soil or rock.


FieldDesc:
The sample of a substance transferred from the air to the surface of the earth, either in wet or dry form.  Some examples include rain, snow, fog, air, dust and aerosols.


FieldDesc:
Refers to sampling occurring on specific highway or road locations including pavement-edge (gutter), catchbasin/gullypot, shoulders/median, drainage pipe, and other.


FieldDesc:
Refers to sampling occurring  in areas that are designed to reduce the amount of pollutants in highway runoff and urban storm water.  Some BMPs used are grassy swales, detention ponds, and silt fences.


FieldDesc:
Refers to sampling occurring in a sewage system that carries both sanitary sewage and storm water runoff.


FieldDesc:
Refers to sampling occurring in a drain connected to a storm sewer which only carries surface runoff, street wash, and snowmelt from land.


FieldDesc:
Refers to sampling occurring in a body of water flowing in a natural or engineered channel containing water from baseflow at least part of the year.


FieldDesc:
Refers to sampling occurring in the transitional land between terrestrial and aquatic systems where land is usually inundated or saturated by water.  Wetlands include swamps, marshes and bogs.


FieldDesc:
Refers to sampling occurring in a body of inland water that is not engineered specifically for the purposes of being a best management practice.  Usually, but not necessarily, denoting a natural water body.


FieldDesc:
Refers to sampling occurring in ocean water that is adjacent to the coast.


FieldDesc:
Refers to sampling occurring in an unknown sampling location.


FieldDesc:
A sequential identifier for study sites from each report citation.


FieldDesc:
The name of the site as referred to in the report.


FieldDesc:
Key which uniquely identifies the study Country. Identifies the name of the country where the study was done.


FieldDesc:
Key which uniquely identifies the study State. Identifies the name of the state where the study was done.


FieldDesc:
The name of the county and/or city where the study was conducted.


FieldDesc:
The local drainage basin containing the study site of interest that drains to a readily identifiable water course or water body.


FieldDesc:
Any information about the study site not mentioned elsewhere in the review.


FieldDesc:
The latitude at which the study occurred.


FieldDesc:
The expected uncertainty of the given latitude value(s), as determined by the reviewer.


FieldDesc:
The longitude at which the study occurred.


FieldDesc:
The expected uncertainty of the given longitude value(s), as determined by the reviewer.


FieldDesc:
The land area from which all the surface water runoff drains to the sampling point.


FieldDesc:
Key which uniquely identifies the study Local Land Use.  Identifies the primary use of the land on which the study site is located.


FieldDesc:
Key which uniquely identifies the study Surrounding Land Use.  Identifies the primary use of the land located in close proximity to the study site.


FieldDesc:
The percent of the drainage area in the study area that prevents infiltration of rainfall and thus increases surface runoff.  Impervious land can be covered by asphalt, concrete, rooftops, and so forth.


FieldDesc:
The percent of the drainage area of the study site in question that is covered by pavement.


FieldDesc:
Details of the local topography or terrain at the study site (e.g. local elevation or if the study area is located in a rain shadow).


FieldDesc:
Attributes about the local soil such as soil type, cation exchange rate, and permeability.


FieldDesc:
The type and (or) condition of the vegetation at the study site (e.g. whether the vegetation is natural or landscaped).


FieldDesc:
The total volume of rain and (or) snow for the study site usually presented as an annualized amount.


FieldDesc:
The number of storm events in a given year.


FieldDesc:
The amount of precipitation that falls in a unit time interval.


FieldDesc:
The time span in which rain or snowfall occurs for an individual storm event.


FieldDesc:
The average amount of precipitation per storm in each month during the study period.


FieldDesc:
The average number of days preceding a storm without precipitation in each month during the study period.


FieldDesc:
Mean of daily air temperature means for a given year or succession of years.


FieldDesc:
Mean of daily air temperature means for January or succession of Januarys.


FieldDesc:
The average speed of air motion, dominantly horizontal relative to the earth's surface.


FieldDesc:
A sequential identifier for study sites from each report cititation.


FieldDesc:
Key which uniquely identifies the Highway Name.  Idendifies the number of the highway, state or interstate route on which the study was done.


FieldDesc:
The total number of highway lanes, in either direction, that are included in the drainage area of the study site.


FieldDesc:
The total length of the road surface being drained to the sampling point.


FieldDesc:
Key which uniquely identifies the Pavement Type.  Identifies the materials used to cover the highway surface, such as concrete or asphalt.


FieldDesc:
The barriers that may be on the side of the highway that prevent surface runoff from draining on  the adjacent land.


FieldDesc:
Key which uniquely identifies the highway Section Type. Identifies the local topography of the road section being studied.


FieldDesc:
The maximum speed allowed on a section of road.


FieldDesc:
The number of vehicles that pass a particular point on a roadway during a period of 24 consecutive hours averaged overa period of days.


FieldDesc:
The time frame for which the Average Daily Traffic (ADT)  was measured.


FieldDesc:
The number of vehicles that pass through the study section during the storm event being sampled.


FieldDesc:
The presence of any areas including limited access highway ramps, traffic lights, and areas of substantial stop and go traffic, where vehicles would accelerate or brake, that may be in the drainage area.


FieldDesc:
Key which uniquely identifies the Drainage System Type.  Identifies a structure, natural or manmade, that removes runoff from the drainage area.


FieldDesc:
The procedures used by highway personnel to clean and maintain the highway.  The reviewer should not assume that practices such as deicing were used solely because an area receives a large amount of snow fall.


FieldDesc:
Key which uniquely identifies the BMP Used.  Identifies the  best management practices used to mitigate the effects of runoff on the local watershed.  BMPs include both structural methods and management methods.


FieldDesc:
The date the field work portion of the study began.


FieldDesc:
The date the field work portion of the study ended.


FieldDesc:
The total number of times samples were collected.  If the number of sampling rounds is different per site or per matrix sampled, the reviewer can explain this in the comment section.


FieldDesc:
The amount of time preceding a sampled storm in which there were no precipitation events (i.e. the number of "dry days" before a storm).


FieldDesc:
Provides space for comments on any temporal information.


FieldDesc:
Key which uniquely identifies the Uncertainty/Error Expression.  Documents the form of the uncertainty and error information as expressed in a report.


FieldDesc:
The documented analysis of data from more than one study site to establish that data collected at a site will represent data characteristics from other, similar sites.


FieldDesc:
The documented analysis of the precision and bias of data as influenced by field sampling methods.


FieldDesc:
The documented analysis of the accuracy and precision of measurement instruments used to collect data for the report.


FieldDesc:
The documented analysis of the accuracy and precision of reported values delivered by the laboratory.


FieldDesc:
The documented analysis of the accuracy and precision of reported stage values.


FieldDesc:
The documented analysis of the accuracy and precision of reported water velocity measurements.


FieldDesc:
The documented analysis of the accuracy and precision of reported precipitation values.


FieldDesc:
The documented analysis of the accuracy and precision of calculated values.


FieldDesc:
The documented analysis of the accuracy and precision of values calculated by a model.


FieldDesc:
Key which uniquely identifies the study local or surrounding Land Use.


FieldDesc:
The primary use of the land on which the study site is located or the land located in close proximity to the study site.


FieldDesc:
Key which uniquely identifies the sampling Method used in Space and(or) Time.


FieldDesc:
Documents how samples represent variations in space and(or) time.


FieldDesc:
Key which uniquely identifies a Constituent.


FieldDesc:
Key which uniquely identifies the parent group (constituent category) of a constituent in a report.


FieldDesc:
Indicates the environmental quality variable(s) (constituents) tested in a given study.


FieldDesc:
The level of the constituent in question in the constituent hierarchy.


FieldDesc:
Key which uniquely identifies the Matrix of a sample.


FieldDesc:
Key which uniquely identifies the parent matrix of a sample.


FieldDesc:
The medium from which samples for analysis of constituents or properties are collected in a given study.


FieldDesc:
The level of the matrix in question  in the matrix hierarchy.


FieldDesc:
Key which uniquely identifies the Area of Study.


FieldDesc:
Key which uniquely identifies the BMP Used.


FieldDesc:
The best management practices used to mitigate the effects of runoff on the local watershed.  BMPs include both structural methods and management methods.


FieldDesc:
Key which uniquely identifies the Change in Stage.


FieldDesc:
Stage is the height of water above an arbitrary datum. Change in stage refers to the documented change in hydrograph stage  at the time of sampling.


FieldDesc:
Key which uniquely identifies the Channel Type.


FieldDesc:
Identifies the natural or engineered water conduit.


FieldDesc:
Key which uniquely identifies the Citation Type.


FieldDesc:
Indicates the general group level of the organization that published the report.


FieldDesc:
Indicates specifically what organization published the report.


FieldDesc:
Key which uniquely identifies the Compositing Method used.


FieldDesc:
Documents the methods used to create composite samples in either time or space.


FieldDesc:
Key which uniquely identifies Confinement of the aquifer.


FieldDesc:
Characterizes the type of aquifer. A confined aquifer is bounded above by formations of impermeable or relatively impermeable material.  An unconfined aquifer is at atmospheric pressure at its upper limit-- the water table.


FieldDesc:
The phylum level in the constituent hierarchy.


FieldDesc:
The order level in the constituent hierarchy.


FieldDesc:
The class level in the constituent hierarchy.


FieldDesc:
The family level in the constituent hierarchy.


FieldDesc:
The genus level in the constituent hierarchy.


FieldDesc:
The section on the National Data and Methodology Synthesis (NDAMS) Data Review Sheet where specific constituents are classified.


FieldDesc:
Key which uniquely identifies the Data Form.


FieldDesc:
The format used to present data in a report.


FieldDesc:
Key which uniquely identifies the type of Data Presentation.


FieldDesc:
Key which uniquely identifies the Detection Limits Reported.


FieldDesc:
The concentration below which a laboratory will not report the determination of a concentration.


FieldDesc:
Key which uniquely identifies the Drainage System Type.


FieldDesc:
A structure, natural or manmade, that removes runoff from the drainage area, such as a swale, pipe, combined sewer, and storm drain.


FieldDesc:
Key which uniquely identifies the Method used to collect Flow data.


FieldDesc:
The method used to determine the flow rate of surface water.


FieldDesc:
Key which uniquely identifies Geologic Material.


FieldDesc:
Characterizes the unconsolidated materials in the aquifer that the ground water flows through.


FieldDesc:
Key which uniquely identifies the method used to quantify Hydraulic Conductivity.


FieldDesc:
The method used to quantify the coefficient of proportionality that describes the rate at which water can move through an aquifer or other permeable medium.


FieldDesc:
Key which uniquely identifies the Major and Minor subject of a report.


FieldDesc:
Indicates the primary and secondary subject emphasis of a report.


FieldDesc:
The phylum level in the matrix hierarchy.


FieldDesc:
Key which uniquely identifies the Microbiology Collection Method.


FieldDesc:
Identifies how the samples represent variations in space.


FieldDesc:
Key which uniquely identifies the Month(s) samples were collected.


FieldDesc:
Provides a detailed account of the exact month(s) samples were collected.


FieldDesc:
Key which uniquely identifies the Pavement Type.


FieldDesc:
The materials used to cover the highway surface, such as concrete or asphalt.


FieldDesc:
Key which uniquely identifies the Precipitation Data Source.


FieldDesc:
Identifies the source from which the precipitation data was obtained for a given study.


FieldDesc:
Key which uniquely identifies the Precipitation Distance.


FieldDesc:
Identifies the approximate distance from a water-quality monitoring site to a precipitation monitoring site.


FieldDesc:
Key which uniquely identifies the type of Precipitation Measurement collected.


FieldDesc:
The form of precipitation data collected.


FieldDesc:
Key which uniquely identifies the Method used to collect Precipitation measurements.


FieldDesc:
Identifies whether precipitation measurements were done automatically and(or) manually.


FieldDesc:
Key which uniquely identifies the Precipitation Minimal Interval between measurements.


FieldDesc:
The approximate time interval between precipitation measurements, such as sec, min, hourly, and daily.


FieldDesc:
Key which uniquely identifies Precipitation Type.


FieldDesc:
The stage-discharge relationship for the channel or water body.  It is often in the form of a graph or a table.


FieldDesc:
Key which uniquely identifies the Report Type.


FieldDesc:
The type of report as classified by content.


FieldDesc:
Key which uniquely identifies the Sampling Method.


FieldDesc:
Documents the sampling plan for water-quality properties and constituents.


FieldDesc:
Key which uniquely identifies the Sampling Program.


FieldDesc:
Documents the sampling program for water-quality properties and constituents.


FieldDesc:
Key which uniquely identifies the highway Section Type.


FieldDesc:
The local topography of the road section being studied.


FieldDesc:
Key which uniquely identifies a Storm Type.


FieldDesc:
Identifies the type(s) of precipitation in storms sampled during the sampling period of a given study.


FieldDesc:
Key which uniquely identifies the Subject of a report.


FieldDesc:
A one letter code that defines the primary and(or) secondary emphasis of a report.


FieldDesc:
The keyword code which classifies the subject emphasis of the report.


FieldDesc:
Key which uniquely identifies the Uncertainty/Error Expression.


FieldDesc:
Documents the form of the uncertainty and error information as expressed in a report.


FieldDesc:
Key which uniquely identifies the study Country.


FieldDesc:
The name of the country where the study was done.


FieldDesc:
Key which uniquely identifies the Highway Name.


FieldDesc:
The number of the highway, state or interstate route on which the study was done.


FieldDesc:
An index number to ensure that highways appear in the right order in the selection list


FieldDesc:
Key which uniquely identifies the study State.


FieldDesc:
The two-letter postal abbreviation for one of the 50 states.


FieldDesc:
The name of the state where the study was done.


FieldDesc:
The two digit Federal Information Processing Standards (FIPS) code for one of the 50 states.


# tblTableDefinition

TableDesc:
Association of the type and number of storms with each reviewed report (Section 3: Temporal)


TableDesc:
Association of the major and minor subjects (keywords) with for all reports (Section 1: Bibliographic/Review)


TableDesc:
Association of the measured constituents with each reviewed report (Section 7: Constituents)


TableDesc:
Association of sampling matrixes with each reviewed report (Section 8: Sampling Focus and Matrix)


TableDesc:
Association of hydraulic conductivities with each reviewed report (Section 9: Flow Monitoring)


TableDesc:
Association of precipitation source data with each reviewed report (Section 9: Flow Monitoring)


TableDesc:
Association of distance between precipitation and site monitoring stations with each reviewed report (Section 9: Flow Monitoring)


TableDesc:
Association of the type of measured precipitation with each reviewed report (Section 9: Flow Monitoring)


TableDesc:
Association of channel type monitored with each reviewed report (Section 9: Flow Monitoring)


TableDesc:
Association of sampling plan with each reviewed report (Section 5: Water-Quality Monitoring)


TableDesc:
Association of months when samples were collected with each reviewed report (Section 3: Temporal)


TableDesc:
Abstracts or previas of selected reports 
(Section 1: Bibliographic)


TableDesc:
Overview of basic report information for reviewed reports (Section 2: Investigation and Report)


TableDesc:
Details of citation information for all reports
(Section 1: Bibliographic)


TableDesc:
Overview of constituent classes  for reviewed reports (Section 7.0: Constituents)


TableDesc:
Citation IDs for reviewed reports that contain detailed information (Section 2: Investigation and Report)


TableDesc:
Details about ground-water flow monitoring  information for reviewed reports (Section 9: Flow Monitoring)


TableDesc:
Details of flow location and flow-monitoring method information in reviewed reports
(Section 9: Flow Monitoring)


TableDesc:
Other flow-monitoring method information documented in reviewed reports (Section 9: Flow Monitoring)


TableDesc:
Precipitation monitoring information documented in reviewed reports (Section 9: Flow Monitoring)


TableDesc:
Surface water monitoring information documented in reviewed reports (Section 9: Flow Monitoring)


TableDesc:
Details about sampled matrixes documented in  reviewed reports (Section 8: Sampling Focus and Matrix)


TableDesc:
Details about field quality-assurance and quality-control documented in reviewed reports (Section 10: Field QA/QC)


TableDesc:
Details about laboratory quality-assurance and quality-control documented in reviewed reports (Section 11: Laboratory QA/QC)


TableDesc:
Data-quality information for biological sampling efforts in reviewed reports (Section 7.12: Constituents, Biological)


TableDesc:
Data-quality information for trace-element sampling efforts in reviewed reports 
(Section 7.05: Constituents, Trace Elements)


TableDesc:
Data-quality information for microbial sampling efforts in reviewed reports (Section 7.10: Constituents, Microbiology)


TableDesc:
Data-quality information for organic-constituent sampling efforts in reviewed reports 
(Section 7.08: Constituents, Organics)


TableDesc:
Data-quality information for pesticide and herbicide sampling efforts in reviewed reports
(Section 7.09: Constituents, Pesticides/Herbicides)


TableDesc:
Data-quality information for water-quality property sampling efforts in reviewed reports
(Section 7.01: Constituents, Properties)


TableDesc:
Data-quality information for solid, sediment, and turbidity sampling efforts in reviewed reports
(Section 7.06: Constituents; Solids, Sediments, and Turbidity)


TableDesc:
Information about water-quality monitoring methods in reviewed reports (Section 5: Water-Quality Monitoring)


TableDesc:
Details about water-quality sample handling methods in reviewed reports (Section 6: Sample Handling)


TableDesc:
Details about the part of the hydrologic cycle being sampled in reviewed reports (Section 8: Sampling Focus and Matrix)


TableDesc:
Details about physical location of sampling points  in reviewed reports (Section 8: Sampling Focus and Matrix)


TableDesc:
Details about site information in reviewed reports (Section 4: Location)


TableDesc:
Details about climatic variables at sites in reviewed reports (Section 4: Location)


TableDesc:
Details about roadway characteristics at sampling sites documented in reviewed reports (Section 4: Location)


TableDesc:
Details about temporal information for sampling events documented in reviewed reports
(Section 3: Temporal)


TableDesc:
Details about uncertainty and error analysis documented in reviewed reports
(Section 12: Uncertainty/Error Analysis)


TableDesc:
List of land use types and site information
(Section 4: Location)


TableDesc:
List of choices (none, calculated or estimated) for data entry (multiuse)


TableDesc:
List of choices (none, calculated, measured, or estimated) for data entry (multiuse)


TableDesc:
List of choices for characterization of the spatial and temporal extent of sampling efforts
(Section 5: Water-Quality Monitoring)


TableDesc:
List of choices(yes, no, or not applicable) for data entry (multiuse)


TableDesc:
List of choices (yes, no, or unknown) for data entry (multiuse)


TableDesc:
List of constituent categories, recursively defines each constituent with the parent group, the constituent name, and the level in the hierarchy (Section 7: Constituents)


TableDesc:
List of sample matrixes recursively defined by parent group, name, and hierarchy level
(Section 8: Sampling Focus and Matrix)


TableDesc:
List of geographic extent of study (Section 2: Investigation and Report)


TableDesc:
List of best management practices used to remove constituents from runoff (Section 4: Location)


TableDesc:
List of times when samples were taken
within the hydrograph (Section 5: Water-Quality Monitoring)


TableDesc:
List of channel types monitored (Section 9: Flow Monitoring)


TableDesc:
List of citation types (Section 1: Bibliographic)


TableDesc:
List of method used to aggregate discrete samples into a composite sample (Section 5: Water-Quality Monitoring)


TableDesc:
List of aquifer types (Section 9: Flow Monitoring)


TableDesc:
List of constituent categories, defines the organizational hierarchy for constituents (Section 7: Constituents)


TableDesc:
List of constituent categories, defines the subsection of the review form appropriate for a given constituent (Section 7: Constituents)


TableDesc:
List defining data documentation--tabular and(or) graphic--(Section 2: Investigation and Report)


TableDesc:
List for indicating if individual data and(or) population measures are documented
(Section 2: Investigation and Report)


TableDesc:
List for indicating the extent of constituent detection-limit documentation (Section 7: Constituents)


TableDesc:
List of drainage system types in the area of study (Section 4: Location)


TableDesc:
List of methods used to document surface water flow (Section 9: Flow Monitoring)


TableDesc:
List of geologic material present in a given aquifer (Section 9: Flow Monitoring)


TableDesc:
List of tests, analysis methods, or instruments used to determine hydraulic conductivity 
(Section 9: Flow Monitoring)


TableDesc:
List (major or minor) of qualifiers for subject codes (Section 1: Bibliographic)


TableDesc:
List for defining  the matrix organizational hierarchy (Section 8: Sampling Focus and Matrix)


TableDesc:
List of sample types for microbial analysis of surface waters (Section 7.10: Constituents, Microbiology)


TableDesc:
List of month(s) in which samples were collected 
(Section 3: Temporal)


TableDesc:
List of materials used to surface paved areas (Section 4: Location)


TableDesc:
List of potential data sources for precipitation
(Section 9: Flow Monitoring)


TableDesc:
List of potential distances from water-quality monitoring sites to precipitation monitoring sites (Section 9: Flow Monitoring)


TableDesc:
List for defining precipitation total and/or intensity (Section 9: Flow Monitoring)


TableDesc:
List of  methods used to measure precipitation (Section 9: Flow Monitoring)


TableDesc:
List of minimum time intervals between individual precipitation measurements (Section 9: Flow Monitoring)


TableDesc:
List of precipitation event types (Section 9: Flow Monitoring)


TableDesc:
List of  methods used to define the stage-discharge relationship for the channel or water body (Section 9: Flow Monitoring)


TableDesc:
List of types of reports indicating the type of information available (Section 2: Investigation and Report)


TableDesc:
List of sampling processes (Section 5: Water-Quality Monitoring)


TableDesc:
List of time intervals between sampling events (Section 5: Water-Quality Monitoring)


TableDesc:
List of types of road sections (Section 4: Location)


TableDesc:
List of the types of storm events sampled (Section 3: Temporal)


TableDesc:
A list of subject codes--keywords--and their definitions (Section 1: Bibliographic)


TableDesc:
A list of modes for defining the uncertainty or error associated with a given data set (Section 12: Uncertainty/Error Analysis)


TableDesc:
A list of countries in which samples were taken (Section 4: Location)


TableDesc:
A list of highway names/numbers along which samples were taken (Section 4: Location)


TableDesc:
A list of  states and provinces in which samples were taken (Section 4: Location)


