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 1994 2004
DATES in Column 6 no problems detected 1994 2010
DATES in Column 9 no problems detected 1994 2010
DATES in Column 17 no problems detected 1994 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 1 30 Apr Sep 00 99
6 DATE-MDY DATE-MDY yes 1 12 1 30 1994 2010
9 DATE-MDY DATE-MDY yes 1 12 1 30 1994 2010
17 DATE-MDY DATE-MDY yes 1 12 1 30 1994 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 93 7. 11965. 89
( 95%)		 89
( 95%)
Column 3 :
[ 05_ABDT1= Total Dinoflagellates (#/L) ] 		no problems detected 93 7. 757. 92
( 98%)		 92
( 98%)
Column 4 :
[ 06_ABDT1= Other Phytoplankton (#/L) ] 		no problems detected 93 210. 4015. 93
( 100%)		 93
( 100%)
Column 5 :
[ 07_ABDT1= Total Phytoplankton (#/L) ] 		no problems detected 93 330. 13566. 93
( 100%)		 93
( 100%)
Column 7 :
[ 08_ABND= Faecal Coliforms (cfu/100ml) ] 		no problems detected 167 1. 1100. 167
( 100%)		 28
( 16%)
Column 8 :
[09_ABND= Escherichia coli (cfu/100ml) ] 		There is/are 1 count WARNING(S)!

Some of your values are zero or "one".

Possible warning triggers:
  • a non-numeric value was encountered!
  • text comments like "null" or "n/a" will be ignored.
  • Engineering units ("1.25E5", "1.25 x 10^5")

    		•  167 1. 26. 167
    ( 100%)    		 5
    ( 2%)
    Column 10 :
    [ 10_TEMP= Temperature (C) at the surface ]     		no problems detected 167 14.6000004 31.6000004 167
    ( 100%)    		 167
    ( 100%)
    Column 11 :
    [ 11_PSAL= Salinity () at the surface ]     		no problems detected 167 22. 34.4000015 167
    ( 100%)    		 167
    ( 100%)
    Column 12 :
    [ 12_CHLA= Chlorophyll (ug/l) at the surface ]     		no problems detected 167 0.200000003 9. 167
    ( 100%)    		 117
    ( 70%)
    Column 13 :
    [ 13_OTHR= Secchi Depth (m) ]     		no problems detected 167 0.800000012 10. 167
    ( 100%)    		 166
    ( 99%)
    Column 14 :
    [ 14_OTHR= Oxygen (mg/l) at the surface ]     		no problems detected 167 3.70000005 10.3000002 167
    ( 100%)    		 167
    ( 100%)
    Column 15 :
    [ 15_OTHR= pH () at the surface ]     		no problems detected 167 7.19999981 8.69999981 167
    ( 100%)    		 167
    ( 100%)
    Column 16 :
    [ 16_LOTH= Turbidity (NTU) at the surface ]     		no problems detected 167 0.100000001 17.2999992 167
    ( 100%)    		 146
    ( 87%)
    Column 18 :
    [ 17_LOTH= NO3-N (mg/l) at the surface ]     		no problems detected 167 0.00200000009 0.180000007 167
    ( 100%)    		 0
    ( 0%)
    Column 19 :
    [ 18_LOTH= NO2-N (mg/l) at the surface ]     		no problems detected 167 0.00200000009 0.0289999992 167
    ( 100%)    		 0
    ( 0%)
    Column 20 :
    [ 19_LOTH= Ammonium-N (mg/l) at the surface ]     		no problems detected 167 0.00499999989 0.109999999 167
    ( 100%)    		 0
    ( 0%)
    Column 21 :
    [ 20_LOTH= Phosphate-P (mg/l) at the surface ]     		no problems detected 167 0.00200000009 0.0270000007 167
    ( 100%)    		 0
    ( 0%)
    Column 22 :
    [ 21_LOTH= Silicate-Si (mg/l) at the surface ]     		no problems detected 167 0.0500000007 2.29999995 167
    ( 100%)    		 10
    ( 5%)

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