COPEPODITE Incoming Data Review

Fatal Format Issues:   none



HEADER REVIEW SECTION
[
Jump back to TOP ]

SEQUENTIAL ORDERING OF ACTIVE DATA COLUMNS

    Column # 1     [ DATE-DMY ]       Date Set = 1
    Column # 2    [ABDT1= Total Diatoms (#/L)]      ( date set 1 )
    Column # 3    [ABDT1= Total Dinoflagellates (#/L)]      ( date set 1 )
    Column # 4    [ABDT1= Other Phytoplankton (#/L)]      ( date set 1 )
    Column # 5    [ABDT1= Total Phytoplankton (#/L)]      ( date set 1 )

    Column # 6     [ DATE-MDY ]       Date Set = 2
    Column # 7    [ABND= Faecal Coliforms (cfu/100ml)]      ( date set 2 )
    Column # 8    [ABND= Escherichia coli (cfu/100ml)]      ( date set 2 )

    Column # 9     [ DATE-MDY ]       Date Set = 3
    Column # 10    [TEMP= Temperature (C) at the surface]      ( date set 3 )
    Column # 11    [PSAL= Salinity () at the surface]      ( date set 3 )
    Column # 12    [CHLA= Chlorophyll (ug/l) at the surface]      ( date set 3 )
    Column # 13    [OTHR= Secchi Depth (m)]      ( date set 3 )
    Column # 14    [OTHR= Oxygen (mg/l) at the surface]      ( date set 3 )
    Column # 15    [OTHR= pH () at the surface]      ( date set 3 )
    Column # 16    [LOTH= Turbidity (NTU) at the surface]      ( date set 3 )

    Column # 17     [ DATE-MDY ]       Date Set = 4
    Column # 18    [LOTH= NO3-N (mg/l) at the surface]      ( date set 4 )
    Column # 19    [LOTH= NO2-N (mg/l) at the surface]      ( date set 4 )
    Column # 20    [LOTH= Ammonium-N (mg/l) at the surface]      ( date set 4 )
    Column # 21    [LOTH= Phosphate-P (mg/l) at the surface]      ( date set 4 )
    Column # 22    [LOTH= Silicate-Si (mg/l) at the surface]      ( date set 4 )


DATA SORTED BY CATEGORY TYPES

    Total/non-zero Abundance Category
        Column # 7   [ ABND= Faecal Coliforms (cfu/100ml) ]
        Column # 8   [ ABND= Escherichia coli (cfu/100ml) ]

    Abundance (with zeros) Category
        Column # 2   [ ABDT1= Total Diatoms (#/L) ]
        Column # 3   [ ABDT1= Total Dinoflagellates (#/L) ]
        Column # 4   [ ABDT1= Other Phytoplankton (#/L) ]
        Column # 5   [ ABDT1= Total Phytoplankton (#/L) ]

    Log10 (logarithmic) Miscellaenous Category
        Column # 16   [ LOTH= Turbidity (NTU) at the surface ]
        Column # 18   [ LOTH= NO3-N (mg/l) at the surface ]
        Column # 19   [ LOTH= NO2-N (mg/l) at the surface ]
        Column # 20   [ LOTH= Ammonium-N (mg/l) at the surface ]
        Column # 21   [ LOTH= Phosphate-P (mg/l) at the surface ]
        Column # 22   [ LOTH= Silicate-Si (mg/l) at the surface ]

    non-Log10 (linear) Miscellaenous Category
        Column # 13   [ OTHR= Secchi Depth (m) ]
        Column # 14   [ OTHR= Oxygen (mg/l) at the surface ]
        Column # 15   [ OTHR= pH () at the surface ]

    Temperatures Category
        Column # 10   [ TEMP= Temperature (C) at the surface ]

    Salinities Category
        Column # 11   [ PSAL= Salinity () at the surface ]

    Chlorophyll/Pigments Category
        Column # 12   [ CHLA= Chlorophyll (ug/l) at the surface ]

DATA SORTED BY GROUPING SETS:

    Category 8 Group # 1
        column # 2     [ ABDT1= Total Diatoms (#/L) ]
        column # 3     [ ABDT1= Total Dinoflagellates (#/L) ]
        column # 4     [ ABDT1= Other Phytoplankton (#/L) ]
        column # 5     [ ABDT1= Total Phytoplankton (#/L) ]



DATE REVIEW SECTION
[
Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1991 2004
DATES in Column 6 no problems detected 1989 2010
DATES in Column 9 no problems detected 1989 2010
DATES in Column 17 no problems detected 1989 2010

 Date Column LabelingDate Value-Set1Date Value-Set2Date Value-Set3
DATE-column Date-Label AutoDetect match? SET1min SET1max SET2min SET2max SET3min SET3max
1 DATE-DMY DATE-DMY yes 2 31 Apr Sep 00 99
6 DATE-MDY DATE-MDY yes 1 12 2 31 1989 2010
9 DATE-MDY DATE-MDY yes 1 12 2 31 1989 2010
17 DATE-MDY DATE-MDY yes 1 12 2 31 1989 2010



DATA REVIEW SECTION
[
Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)
Maximum Values
> 0
Values
> 1
Column 2 :
[ 04_ABDT1= Total Diatoms (#/L) ]
no problems detected 110 4. 36741. 106
( 96%)
106
( 96%)
Column 3 :
[ 05_ABDT1= Total Dinoflagellates (#/L) ]
no problems detected 110 4. 253. 105
( 95%)
105
( 95%)
Column 4 :
[ 06_ABDT1= Other Phytoplankton (#/L) ]
no problems detected 110 10. 15503. 108
( 98%)
108
( 98%)
Column 5 :
[ 07_ABDT1= Total Phytoplankton (#/L) ]
no problems detected 110 20. 52315. 110
( 100%)
110
( 100%)
Column 7 :
[ 08_ABND= Faecal Coliforms (cfu/100ml) ]
no problems detected 192 1. 370. 192
( 100%)
81
( 42%)
Column 8 :
[ 09_ABND= Escherichia coli (cfu/100ml) ]
no problems detected 192 1. 95. 192
( 100%)
43
( 22%)
Column 10 :
[ 10_TEMP= Temperature (C) at the surface ]
no problems detected 192 14.1999998 29.7999992 192
( 100%)
192
( 100%)
Column 11 :
[ 11_PSAL= Salinity () at the surface ]
no problems detected 192 10.1999998 34.4000015 192
( 100%)
192
( 100%)
Column 12 :
[ 12_CHLA= Chlorophyll (ug/l) at the surface ]
no problems detected 192 0.200000003 33. 192
( 100%)
150
( 78%)
Column 13 :
[ 13_OTHR= Secchi Depth (m) ]
no problems detected 192 0.5 7. 192
( 100%)
175
( 91%)
Column 14 :
[ 14_OTHR= Oxygen (mg/l) at the surface ]
no problems detected 192 4. 14.1000004 192
( 100%)
192
( 100%)
Column 15 :
[ 15_OTHR= pH () at the surface ]
no problems detected 192 7.19999981 9.30000019 192
( 100%)
192
( 100%)
Column 16 :
[ 16_LOTH= Turbidity (NTU) at the surface ]
no problems detected 192 0.5 30.3999996 192
( 100%)
189
( 98%)
Column 18 :
[ 17_LOTH= NO3-N (mg/l) at the surface ]
no problems detected 192 0.00200000009 1.20000005 192
( 100%)
2
( 1%)
Column 19 :
[ 18_LOTH= NO2-N (mg/l) at the surface ]
no problems detected 192 0.00200000009 0.140000001 192
( 100%)
0
( 0%)
Column 20 :
[ 19_LOTH= Ammonium-N (mg/l) at the surface ]
no problems detected 192 0.00499999989 0.239999995 192
( 100%)
0
( 0%)
Column 21 :
[ 20_LOTH= Phosphate-P (mg/l) at the surface ]
no problems detected 192 0.00200000009 0.0390000008 192
( 100%)
0
( 0%)
Column 22 :
[ 21_LOTH= Silicate-Si (mg/l) at the surface ]
no problems detected 192 0.0500000007 5.5999999 192
( 100%)
59
( 30%)

The "Values >0" and "Values >1" columns look for data cases in which data values are heavily counts of "zero" or "1".