USGS
 Environmental Geochemistry and Sediment Quality in Lake Pontchartrain

Figure 2.  Relationships between EMAP Sediment tables

The diagram below shows the sediment data tables and their relationships with each other.  The data in all the tables can be linked using the station ID field.   (The toxicity table is shown with a dotted border because it has not been incorporated into this USGS database.)  EPA maintains similar relational tables for biological and water quality data which are also related to these sediment tables via the station ID ("sta_name").  [see Table 2 for example data from the chemistry table.]

emapflow.gif (9009 bytes)


arrow2l.jpg (1149 bytes) Back to Relational Databases

 

[an error occurred while processing this directive]