| Lake Pontchartrain
Basin: Bottom Sediments and Related Environmental Resources |
Table 3. Example of "horizontal" format for Pontchartrain
chemistry table.
[Each sample has a unique ID and all the data associated with that sample
are stored across one row.
Each constituent measured has 3 columns; one for the concentration value (heading ends with "_C"),
one for the quality control notes ("_Q"), and one for the detection limit ("_D"). The station data
are
stored in a separate table with corresponding unique_ids.]
| UNIQUE_ID |
C2FLORNE_C |
C2FLORNE_Q |
C2FLORNE_D |
C3FLORNE_C |
C3FLORNE_Q |
C3FLORNE_D |
1-MT-PHE_C |
1-MT-PHE_Q |
1-MT-PHE_D |
C1PHENAN_C |
C1PHENAN_Q |
C1PHENAN_D |
| 2312 |
1.21 |
CH-B |
10 |
|
CH-A |
10 |
0.34 |
CH-B |
0.6 |
1.15 |
CH-B |
16.4 |
| 2313 |
8.22 |
CH-B |
10 |
8.83 |
CH-B |
10 |
2.02 |
|
|
7.44 |
CH-B |
16.4 |
| 2314 |
3.44 |
CH-B |
10 |
5.05 |
CH-B |
10 |
0.81 |
|
|
3.82 |
CH-B |
16.4 |
| 2315 |
6.91 |
CH-B |
10 |
11.54 |
|
|
2.13 |
|
|
7.71 |
CH-B |
16.4 |
| 2316 |
2.62 |
CH-B |
10 |
3.52 |
CH-B |
10 |
1.11 |
|
|
3.27 |
CH-B |
16.4 |
| 2317 |
13.64 |
|
|
11.56 |
|
|
5.09 |
|
|
20.05 |
|
|
| 2318 |
1.63 |
CH-B |
10 |
2.88 |
CH-B |
10 |
0.57 |
CH-B |
0.6 |
2.1 |
CH-B |
16.4 |
| 2319 |
4.25 |
CH-B |
10 |
6.53 |
CH-B |
10 |
1.81 |
|
|
8.14 |
CH-B |
16.4 |
| 2320 |
2.64 |
CH-B |
10 |
3.43 |
CH-B |
10 |
0.97 |
|
|
3.59 |
CH-B |
16.4 |
| 2321 |
2.72 |
CH-B |
10 |
3.25 |
CH-B |
10 |
1.26 |
|
|
4.14 |
CH-B |
16.4 |
| 2322 |
4.36 |
CH-B |
10 |
6.87 |
CH-B |
10 |
1.18 |
|
|
5.79 |
CH-B |
16.4 |
 Back to Horizontal
vs. Vertical
|