COPEPODITE Incoming Data Review
Fatal Format Issues:   none


HEADER REVIEW SECTION
[ Jump back to TOP ]

SEQUENTIAL ORDERING OF ACTIVE DATA COLUMNS

    Column # 1     [ DATE-YMD ]       Date Set = 1
    Column # 2     [ABDT1= Total Diatoms (#/ml)]      ( date set 1 )
    Column # 3     [ABDT1= Total Dinoflagellates (#/ml)]      ( date set 1 )
    Column # 4     [ABDT2= Chloro/Chryso Flagellates (#/ml)]      ( date set 1 )
    Column # 5     [ABDT= Chlorophyta (#/ml)]      ( date set 1 )
    Column # 6     [ABDT= Chlorophyta : passive (#/ml)]      ( date set 1 )
    Column # 7     [ABDT2= Chrysophyta (#/ml)]      ( date set 1 )
    Column # 8     [ABDT2= Cryptophyta (#/ml)]      ( date set 1 )
    Column # 9     [ABDT2= Dictoyphyta (#/ml)]      ( date set 1 )
    Column # 10     [ABDT2= Euglenophyta (#/ml)]      ( date set 1 )
    Column # 11     [ABDT2= Haptophyta (#/ml)]      ( date set 1 )
    Column # 12     [ABDT2= Raphidoophyta (#/ml)]      ( date set 1 )
    Column # 13     [ABDT2= Xanthophyta (#/ml)]      ( date set 1 )
    Column # 14     [ABDT= Cyanophyta : group (#/ml)]      ( date set 1 )
    Column # 15     [ABDT= Cyanophyta : n-fixing (#/ml)]      ( date set 1 )
    Column # 16     [ABDT= Cyanophyta : non-n-fixing (#/ml)]      ( date set 1 )
    Column # 17     [ABDT= Coliforms : presum-thermotol (CFU/dl)]      ( date set 1 )
    Column # 18     [ABDT= Enterococci : conf (MPN/dl)]      ( date set 1 )

    Column # 19     [ DATE-YMD ]       Date Set = 2
    Column # 20     [TEMP= Temperature (C)]      ( date set 2 )
    Column # 21     [PSAL= Salinity ()]      ( date set 2 )
    Column # 22     [OTHR= Oxygen (mg/ml)]      ( date set 2 )
    Column # 23     [OTHR= Oxygen Saturation (%)]      ( date set 2 )
    Column # 24     [LOTH= Total Phosphate (mg/L)]      ( date set 2 )
    Column # 25     [LOTH= PO4-P (mg/L)]      ( date set 2 )
    Column # 26     [LOTH= SiO2 (mg/L)]      ( date set 2 )
    Column # 27     [LOTH= SiO2-Si (mg/L)]      ( date set 2 )
    Column # 28     [LOTH= Total N (mg/L)]      ( date set 2 )
    Column # 29     [LOTH= NH4-N/NH3-N (mg/L)]      ( date set 2 )
    Column # 30     [LOTH= NO2-N (mg/L)]      ( date set 2 )
    Column # 31     [LOTH= NO3-N (mg/L)]      ( date set 2 )
    Column # 32     [OTHR= pH ()]      ( date set 2 )
    Column # 33     [OTHR= Total Alkalinity (mg/L)]      ( date set 2 )
    Column # 34     [OTHR= Secchi Depth (m)]      ( date set 2 )
    Column # 35     [LOTH= DOC (mg/L)]      ( date set 2 )
    Column # 36     [LOTH= TSS (mg/L)]      ( date set 2 )
    Column # 37     [LOTH= Turbidity (NTU)]      ( date set 2 )
    Column # 38     [CHLA= Chlorophyll-a (mg/L)]      ( date set 2 )
    Column # 39     [CHLA= Chlorophyll-b (mg/L)]      ( date set 2 )
    Column # 40     [CHLA= Chlorophyll-c (mg/L)]      ( date set 2 )
    Column # 41     [CHLA= Phaeophytin (mg/L)]      ( date set 2 )
    Column # 42     [OTHR= Wind speed (knots)]      ( date set 2 )

    Column # 43     [ DATE-YMD ]       Date Set = 3
    Column # 44     [OTHR= Monthly Total Streamflow (m3/month)]      ( date set 3 )
    Column # 45     [LOTH= log of Monthly Total Streamflow (m3/month)]      ( date set 3 )


DATA SORTED BY CATEGORY TYPES

    Abundance (with zeros) Category
        Column # 2   [ ABDT1= Total Diatoms (#/ml) ]
        Column # 3   [ ABDT1= Total Dinoflagellates (#/ml) ]
        Column # 4   [ ABDT2= Chloro/Chryso Flagellates (#/ml) ]
        Column # 5   [ ABDT= Chlorophyta (#/ml) ]
        Column # 6   [ ABDT= Chlorophyta : passive (#/ml) ]
        Column # 7   [ ABDT2= Chrysophyta (#/ml) ]
        Column # 8   [ ABDT2= Cryptophyta (#/ml) ]
        Column # 9   [ ABDT2= Dictoyphyta (#/ml) ]
        Column # 10   [ ABDT2= Euglenophyta (#/ml) ]
        Column # 11   [ ABDT2= Haptophyta (#/ml) ]
        Column # 12   [ ABDT2= Raphidoophyta (#/ml) ]
        Column # 13   [ ABDT2= Xanthophyta (#/ml) ]
        Column # 14   [ ABDT= Cyanophyta : group (#/ml) ]
        Column # 15   [ ABDT= Cyanophyta : n-fixing (#/ml) ]
        Column # 16   [ ABDT= Cyanophyta : non-n-fixing (#/ml) ]
        Column # 17   [ ABDT= Coliforms : presum-thermotol (CFU/dl) ]
        Column # 18   [ ABDT= Enterococci : conf (MPN/dl) ]

    non-Log10 (linear) Miscellaenous Category
        Column # 22   [ OTHR= Oxygen (mg/ml) ]
        Column # 23   [ OTHR= Oxygen Saturation (%) ]
        Column # 32   [ OTHR= pH () ]
        Column # 33   [ OTHR= Total Alkalinity (mg/L) ]
        Column # 34   [ OTHR= Secchi Depth (m) ]
        Column # 42   [ OTHR= Wind speed (knots) ]
        Column # 44   [ OTHR= Monthly Total Streamflow (m3/month) ]

    Temperatures Category
        Column # 20   [ TEMP= Temperature (C) ]

    Salinities Category
        Column # 21   [ PSAL= Salinity () ]

DATA SORTED BY GROUPING SETS:

    Category 8 Group # 1
        column # 2     [ ABDT1= Total Diatoms (#/ml) ]
        column # 3     [ ABDT1= Total Dinoflagellates (#/ml) ]

    Category 8 Group # 2
        column # 4     [ ABDT2= Chloro/Chryso Flagellates (#/ml) ]
        column # 7     [ ABDT2= Chrysophyta (#/ml) ]
        column # 8     [ ABDT2= Cryptophyta (#/ml) ]
        column # 9     [ ABDT2= Dictoyphyta (#/ml) ]
        column # 10     [ ABDT2= Euglenophyta (#/ml) ]
        column # 11     [ ABDT2= Haptophyta (#/ml) ]
        column # 12     [ ABDT2= Raphidoophyta (#/ml) ]
        column # 13     [ ABDT2= Xanthophyta (#/ml) ]


DATE REVIEW SECTION
[ Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1994 2010
DATES in Column 19 no problems detected 1994 2010
DATES in Column 43 no problems detected 1996 2010

 Date Column LabelingDate Value-Set1Date Value-Set2Date Value-Set3
DATE-column Date-Label AutoDetect match? SET1min SET1max SET2min SET2max SET3min SET3max
1 DATE-YMD DATE-YMD yes 1994 2010 01 12 01 31
19 DATE-YMD DATE-YMD yes 1994 2010 01 12 01 31
43 DATE-YMD DATE-YMD yes 1996 2010 01 12 15 15


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 (#/ml) ] 		no problems detected 417 2.00000000 53126.0000 409
( 98 %)		 409
( 98 %)
Column 3 :
[ 05_ABDT1= Total Dinoflagellates (#/ml) ] 		no problems detected 803 1.00000000 76053.0000 688
( 85 %)		 685
( 85 %)
Column 4 :
[ 06_ABDT2= Chloro/Chryso Flagellates (#/ml) ] 		no problems detected 417 3.00000000 22776.0000 405
( 97 %)		 405
( 97 %)
Column 5 :
[ 07_ABDT= Chlorophyta (#/ml) ] 		no problems detected 389 3.00000000 63538.0000 341
( 87 %)		 341
( 87 %)
Column 6 :
[ 08_ABDT= Chlorophyta : passive (#/ml) ] 		no problems detected 417 2.00000000 1018080.00 269
( 64 %)		 269
( 64 %)
Column 7 :
[ 09_ABDT2= Chrysophyta (#/ml) ] 		no problems detected 795 1.00000000 24594.0000 387
( 48 %)		 386
( 48 %)
Column 8 :
[ 10_ABDT2= Cryptophyta (#/ml) ] 		no problems detected 805 1.00000000 11076.0000 749
( 93 %)		 748
( 92 %)
Column 9 :
[11_ABDT2= Dictoyphyta (#/ml) ] 		There is/are 2 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")

    		•  758 10.0000000 253.000000 4
    ( 0 %)    		 4
    ( 0 %)
    Column 10 :
    [ 12_ABDT2= Euglenophyta (#/ml) ]     		no problems detected 787 2.00000000 4141.00000 341
    ( 43 %)    		 341
    ( 43 %)
    Column 11 :
    [ 13_ABDT2= Haptophyta (#/ml) ]     		no problems detected 758 2.00000000 202.000000 68
    ( 8 %)    		 68
    ( 8 %)
    Column 12 :
    [ 14_ABDT2= Raphidoophyta (#/ml) ]     		no problems detected 791 2.00000000 12053.0000 334
    ( 42 %)    		 334
    ( 42 %)
    Column 13 :
    [15_ABDT2= Xanthophyta (#/ml) ]     		There is/are 2 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")

    		•  628 13.0000000 404.000000 3
    ( 0 %)    		 3
    ( 0 %)
    Column 14 :
    [ 16_ABDT= Cyanophyta : group (#/ml) ]     		no problems detected 367 3.00000000 1818.00000 26
    ( 7 %)    		 26
    ( 7 %)
    Column 15 :
    [17_ABDT= Cyanophyta : n-fixing (#/ml) ]     		There is/are 2 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")

    		•  417 16.0000000 253.000000 5
    ( 1 %)    		 5
    ( 1 %)
    Column 16 :
    [ 18_ABDT= Cyanophyta : non-n-fixing (#/ml) ]     		no problems detected 417 1.00000000 10605.0000 107
    ( 25 %)    		 106
    ( 25 %)
    Column 17 :
    [19_ABDT= Coliforms : presum-thermotol (CFU/dl) ]     		There is/are 3 count WARNING(S)!

    All/most of your values are EMPTY (missing).
    This variable will be ignored!

    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")

    		•  1 80.0000000 80.0000000 1
    ( 100 %)    		 1
    ( 100 %)
    Column 18 :
    [20_ABDT= Enterococci : conf (MPN/dl) ]     		There is/are 3 count WARNING(S)!

    All/most of your values are EMPTY (missing).
    This variable will be ignored!

    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")

    		•  1 52.0000000 52.0000000 1
    ( 100 %)    		 1
    ( 100 %)
    Column 20 :
    [ 21_TEMP= Temperature (C) ]     		no problems detected 7685 9.76000023 30.5100002 7684
    ( 99 %)    		 7684
    ( 99 %)
    Column 21 :
    [ 22_PSAL= Salinity () ]     		no problems detected 7642 0.100000001 37.3499985 7640
    ( 99 %)    		 7635
    ( 99 %)
    Column 22 :
    [ 23_OTHR= Oxygen (mg/ml) ]     		no problems detected 7679 9.99999978E-03 17.8299999 7678
    ( 99 %)    		 7210
    ( 93 %)
    Column 23 :
    [ 24_OTHR= Oxygen Saturation (%) ]     		no problems detected 7552 0.100000001 216.199997 7551
    ( 99 %)    		 7498
    ( 99 %)
    Column 24 :
    [ 25_LOTH= Total Phosphate (mg/L) ]     		no problems detected 1755 4.99999989E-03 2.20000005 1755
    ( 100 %)    		 2
    ( 0 %)
    Column 25 :
    [ 26_LOTH= PO4-P (mg/L) ]     		no problems detected 1753 3.00000003E-03 0.720000029 1753
    ( 100 %)    		 0
    ( 0 %)
    Column 26 :
    [ 27_LOTH= SiO2 (mg/L) ]     		no problems detected 279 0.300000012 16.0000000 279
    ( 100 %)    		 272
    ( 97 %)
    Column 27 :
    [ 28_LOTH= SiO2-Si (mg/L) ]     		no problems detected 307 9.99999978E-03 9.50000000 307
    ( 100 %)    		 277
    ( 90 %)
    Column 28 :
    [ 29_LOTH= Total N (mg/L) ]     		no problems detected 1755 0.159999996 8.10000038 1755
    ( 100 %)    		 529
    ( 30 %)
    Column 29 :
    [ 30_LOTH= NH4-N/NH3-N (mg/L) ]     		no problems detected 1755 4.99999989E-03 1.39999998 1755
    ( 100 %)    		 2
    ( 0 %)
    Column 30 :
    [31_LOTH= NO2-N (mg/L) ]     		There is/are 1 count WARNING(S)!

    All/most of your values are EMPTY (missing).
    This variable will be ignored!

    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")

    		•  2 4.99999989E-03 4.99999989E-03 2
    ( 100 %)    		 0
    ( 0 %)
    Column 31 :
    [ 32_LOTH= NO3-N (mg/L) ]     		no problems detected 118 4.99999989E-03 0.529999971 118
    ( 100 %)    		 0
    ( 0 %)
    Column 32 :
    [ 33_OTHR= pH () ]     		no problems detected 7225 5.65000010 10.3199997 7224
    ( 99 %)    		 7224
    ( 99 %)
    Column 33 :
    [ 34_OTHR= Total Alkalinity (mg/L) ]     		no problems detected 862 13.0000000 160.000000 862
    ( 100 %)    		 862
    ( 100 %)
    Column 34 :
    [ 35_OTHR= Secchi Depth (m) ]     		no problems detected 749 5.00000007E-02 4.50000000 749
    ( 100 %)    		 181
    ( 24 %)
    Column 35 :
    [ 36_LOTH= DOC (mg/L) ]     		no problems detected 673 1.00000000 74.0000000 673
    ( 100 %)    		 669
    ( 99 %)
    Column 36 :
    [ 37_LOTH= TSS (mg/L) ]     		no problems detected 758 1.00000000 270.000000 758
    ( 100 %)    		 748
    ( 98 %)
    Column 37 :
    [ 38_LOTH= Turbidity (NTU) ]     		no problems detected 4543 -5.09999990 2213.80005 4185
    ( 92 %)    		 4047
    ( 89 %)
    Column 38 :
    [39_CHLA= Chlorophyll-a (mg/L) ]     		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")

    		•  1727 1.99999995E-04 0.419999987 1727
    ( 100 %)    		 0
    ( 0 %)
    Column 39 :
    [40_CHLA= Chlorophyll-b (mg/L) ]     		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")

    		•  1727 1.99999995E-04 13.0000000 1726
    ( 99 %)    		 1
    ( 0 %)
    Column 40 :
    [41_CHLA= Chlorophyll-c (mg/L) ]     		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")

    		•  1727 1.99999995E-04 75.0000000 1727
    ( 100 %)    		 4
    ( 0 %)
    Column 41 :
    [42_CHLA= Phaeophytin (mg/L) ]     		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")

    		•  1725 1.99999995E-04 6.30000010E-02 1725
    ( 100 %)    		 0
    ( 0 %)
    Column 42 :
    [ 43_OTHR= Wind speed (knots) ]     		no problems detected 604 1.00000000 25.0000000 469
    ( 77 %)    		 432
    ( 71 %)
    Column 44 :
    [ 44_OTHR= Monthly Total Streamflow (m3/month) ]     		no problems detected 168 1.00000005E-03 238.505005 168
    ( 100 %)    		 111
    ( 66 %)
    Column 45 :
    [ 45_LOTH= log of Monthly Total Streamflow (m3/month) ]     		no problems detected 168 1.00000005E-03 238.505005 168
    ( 100 %)    		 111
    ( 66 %)

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