COPEPODITE Incoming Data Review

Fatal Format Issues:   none


    Mild Data Warnings (non-numeric values):   20478    [ Jump to the DATA REVIEW SECTION ]
Warnings do not need to be fixed before processing, but could impact results.




HEADER REVIEW SECTION
[
Jump back to TOP ]

SEQUENTIAL ORDERING OF ACTIVE DATA COLUMNS

    Column # 1     [ DATE-MDY ]       Date Set = 1
    Column # 2    [ABND= Total Copepods (#/m3)]      ( date set 1 )

    Column # 3     [ DATE-DMY ]       Date Set = 2
    Column # 4    [ABDT2= Total Diatoms (#/L)]      ( date set 2 )
    Column # 5    [ABDT2= Total Dinoflagellates (#/ml)]      ( date set 2 )
    Column # 6    [ABDT3= Total Diatoms (#/L)]      ( date set 2 )
    Column # 7    [ABDT3= Total Dinoflagellates (#/ml)]      ( date set 2 )

    Column # 8     [ DATE-YMD ]       Date Set = 3
    Column # 9    [TEMP= Temperature ( C ) at 0m]      ( date set 3 )
    Column # 10    [PSAL= Salinity () at 0m]      ( date set 3 )
    Column # 11    [LOTH= Phosphate (uM) at 0m]      ( date set 3 )
    Column # 12    [LOTH= NO3NO2 (uM) at 0m]      ( date set 3 )
    Column # 13    [LOTH= NO2 (uM) at 0m]      ( date set 3 )
    Column # 14    [LOTH= Silicate (uM) at 0m]      ( date set 3 )
    Column # 15    [LOTH= NH4 (uM) at 0m]      ( date set 3 )
    Column # 16    [CHLA= Chlorophyll (ug/L) at 0m]      ( date set 3 )

    Column # 17     [ DATE-YMD ]       Date Set = 4
    Column # 18    [TEMP= Temperature ( C ) at 45m]      ( date set 4 )
    Column # 19    [PSAL= Salinity () at 45m]      ( date set 4 )
    Column # 20    [LOTH= Phosphate (uM) at 45m]      ( date set 4 )
    Column # 21    [LOTH= NO3NO2 (uM) at 45m]      ( date set 4 )
    Column # 22    [LOTH= NO2 (uM) at 45m]      ( date set 4 )
    Column # 23    [LOTH= Silicate (uM) at 45m]      ( date set 4 )
    Column # 24    [LOTH= NH4 (uM) at 45m]      ( date set 4 )
    Column # 25    [CHLA= Chlorophyll (ug/L) at 45m]      ( date set 4 )

    Column # 26     [ DATE-MDY ]       Date Set = 5
    Column # 27    [ABDT7= Total Cnidaria (#/m3)]      ( date set 5 )
    Column # 28    [ABDT7= Total Ctenophora (#/m3)]      ( date set 5 )
    Column # 29    [ABDT7= Total Chaetognatha (#/m3)]      ( date set 5 )

    Column # 30     [ DATE-YMD ]       Date Set = 6
    Column # 31    [OTHR= Secchi Depth (m)]      ( date set 6 )


DATA SORTED BY CATEGORY TYPES

    Total/non-zero Abundance Category
        Column # 2   [ ABND= Total Copepods (#/m3) ]

    Abundance (with zeros) Category
        Column # 4   [ ABDT2= Total Diatoms (#/L) ]
        Column # 5   [ ABDT2= Total Dinoflagellates (#/ml) ]
        Column # 6   [ ABDT3= Total Diatoms (#/L) ]
        Column # 7   [ ABDT3= Total Dinoflagellates (#/ml) ]
        Column # 27   [ ABDT7= Total Cnidaria (#/m3) ]
        Column # 28   [ ABDT7= Total Ctenophora (#/m3) ]
        Column # 29   [ ABDT7= Total Chaetognatha (#/m3) ]

    Log10 (logarithmic) Miscellaenous Category
        Column # 11   [ LOTH= Phosphate (uM) at 0m ]
        Column # 12   [ LOTH= NO3NO2 (uM) at 0m ]
        Column # 13   [ LOTH= NO2 (uM) at 0m ]
        Column # 14   [ LOTH= Silicate (uM) at 0m ]
        Column # 15   [ LOTH= NH4 (uM) at 0m ]
        Column # 20   [ LOTH= Phosphate (uM) at 45m ]
        Column # 21   [ LOTH= NO3NO2 (uM) at 45m ]
        Column # 22   [ LOTH= NO2 (uM) at 45m ]
        Column # 23   [ LOTH= Silicate (uM) at 45m ]
        Column # 24   [ LOTH= NH4 (uM) at 45m ]

    non-Log10 (linear) Miscellaenous Category
        Column # 31   [ OTHR= Secchi Depth (m) ]

    Temperatures Category
        Column # 9   [ TEMP= Temperature ( C ) at 0m ]
        Column # 18   [ TEMP= Temperature ( C ) at 45m ]

    Salinities Category
        Column # 10   [ PSAL= Salinity () at 0m ]
        Column # 19   [ PSAL= Salinity () at 45m ]

    Chlorophyll/Pigments Category
        Column # 16   [ CHLA= Chlorophyll (ug/L) at 0m ]
        Column # 25   [ CHLA= Chlorophyll (ug/L) at 45m ]

DATA SORTED BY GROUPING SETS:

    Category 8 Group # 2
        column # 4     [ ABDT2= Total Diatoms (#/L) ]
        column # 5     [ ABDT2= Total Dinoflagellates (#/ml) ]

    Category 8 Group # 3
        column # 6     [ ABDT3= Total Diatoms (#/L) ]
        column # 7     [ ABDT3= Total Dinoflagellates (#/ml) ]

    Category 8 Group # 7
        column # 27     [ ABDT7= Total Cnidaria (#/m3) ]
        column # 28     [ ABDT7= Total Ctenophora (#/m3) ]
        column # 29     [ ABDT7= Total Chaetognatha (#/m3) ]



DATE REVIEW SECTION
[
Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1999 2017
DATES in Column 3 no problems detected 1997 2017
DATES in Column 8 no problems detected 1998 2016
DATES in Column 17 no problems detected 1997 2017
DATES in Column 26 no problems detected 1999 2017
DATES in Column 30 no problems detected 2001 2016

 Date Column LabelingDate Value-Set1Date Value-Set2Date Value-Set3
DATE-column Date-Label AutoDetect match? SET1min SET1max SET2min SET2max SET3min SET3max
1 DATE-MDY DATE-MDY yes 1 12 1 31 1999 2017
3 DATE-DMY DATE-DMY yes 1 31 01 12 1997 2017
8 DATE-YMD DATE-YMD yes 1998 2016 1 12 1 31
17 DATE-YMD DATE-YMD yes 1997 2017 1 12 1 31
26 DATE-MDY DATE-MDY yes 1 12 1 31 1999 2017
30 DATE-YMD DATE-YMD yes 2001 2016 1 12 1 31



DATA REVIEW SECTION
[
Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)
Maximum Values
> 0
Values
> 1
Column 2 :
[ 04_ABND= Total Copepods (#/m3) ]
no problems detected 867 33.6800003 22395.3691 866
( 99%)
866
( 99%)
Column 4 :
[ 05_ABDT2= Total Diatoms (#/L) ]
no problems detected 949 570. 3282377.75 890
( 93%)
890
( 93%)
Column 5 :
[ 06_ABDT2= Total Dinoflagellates (#/ml) ]
no problems detected 949 100. 317467.156 633
( 66%)
633
( 66%)
Column 6 :
[ 07_ABDT3= Total Diatoms (#/L) ]
no problems detected 949 0.569999993 3282.37769 890
( 93%)
888
( 93%)
Column 7 :
[ 08_ABDT3= Total Dinoflagellates (#/ml) ]
no problems detected 949 0.100000001 317.467163 633
( 66%)
627
( 66%)
Column 9 :
[09_TEMP= Temperature ( C ) at 0m ]
There is/are 2053 count WARNING(S)!
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")

  • 803 4.36999989 16.2299995 803
    ( 100%)
    803
    ( 100%)
    Column 10 :
    [10_PSAL= Salinity () at 0m ]
    There is/are 2057 count WARNING(S)!
    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")

  • 799 32.9169998 34.993 799
    ( 100%)
    799
    ( 100%)
    Column 11 :
    [11_LOTH= Phosphate (uM) at 0m ]
    There is/are 2176 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")

  • 680 0.00999999978 0.720000029 680
    ( 100%)
    0
    ( 0%)
    Column 12 :
    [12_LOTH= NO3NO2 (uM) at 0m ]
    There is/are 1878 count WARNING(S)!
    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")

  • 978 0.00999999978 14.6000004 978
    ( 100%)
    583
    ( 59%)
    Column 13 :
    [13_LOTH= NO2 (uM) at 0m ]
    There is/are 2707 count WARNING(S)!
    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")

  • 149 0.00999999978 1.99000001 149
    ( 100%)
    8
    ( 5%)
    Column 14 :
    [14_LOTH= Silicate (uM) at 0m ]
    There is/are 1971 count WARNING(S)!
    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")

  • 885 0.00999999978 11.6499996 885
    ( 100%)
    709
    ( 80%)
    Column 15 :
    [15_LOTH= NH4 (uM) at 0m ]
    There is/are 2183 count WARNING(S)!
    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")

  • 673 0.00999999978 3.79999995 673
    ( 100%)
    123
    ( 18%)
    Column 16 :
    [16_CHLA= Chlorophyll (ug/L) at 0m ]
    There is/are 1403 count WARNING(S)!
    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")

  • 1453 0.0599999987 9.80000019 1453
    ( 100%)
    645
    ( 44%)
    Column 18 :
    [17_TEMP= Temperature ( C ) at 45m ]
    There is/are 276 count WARNING(S)!
    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")

  • 935 4.65999985 14.2399998 935
    ( 100%)
    935
    ( 100%)
    Column 19 :
    [18_PSAL= Salinity () at 45m ]
    There is/are 286 count WARNING(S)!
    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")

  • 925 33.9920006 34.993 925
    ( 100%)
    925
    ( 100%)
    Column 20 :
    [19_LOTH= Phosphate (uM) at 45m ]
    There is/are 431 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")

  • 780 0.00999999978 0.860000014 780
    ( 100%)
    0
    ( 0%)
    Column 21 :
    [20_LOTH= NO3NO2 (uM) at 45m ]
    There is/are 142 count WARNING(S)!
    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")

  • 1069 0.00999999978 11.6999998 1069
    ( 100%)
    664
    ( 62%)
    Column 22 :
    [21_LOTH= NO2 (uM) at 45m ]
    There is/are 1007 count WARNING(S)!
    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")

  • 204 0.0199999996 2.45000005 204
    ( 100%)
    15
    ( 7%)
    Column 23 :
    [22_LOTH= Silicate (uM) at 45m ]
    There is/are 237 count WARNING(S)!
    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")

  • 974 0.00999999978 8.38000011 974
    ( 100%)
    844
    ( 86%)
    Column 24 :
    [23_LOTH= NH4 (uM) at 45m ]
    There is/are 449 count WARNING(S)!
    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")

  • 762 0.00999999978 4.4000001 762
    ( 100%)
    219
    ( 28%)
    Column 25 :
    [24_CHLA= Chlorophyll (ug/L) at 45m ]
    There is/are 1206 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")

  • 6 0.170000002 2.03999996 6
    ( 100%)
    2
    ( 33%)
    Column 27 :
    [ 25_ABDT7= Total Cnidaria (#/m3) ]
    no problems detected 867 0.252626896 505.253784 665
    ( 76%)
    454
    ( 52%)
    Column 28 :
    [ 26_ABDT7= Total Ctenophora (#/m3) ]
    no problems detected 867 0.252626896 67.1987534 298
    ( 34%)
    123
    ( 14%)
    Column 29 :
    [ 27_ABDT7= Total Chaetognatha (#/m3) ]
    no problems detected 867 0.252626896 294.562958 841
    ( 97%)
    774
    ( 89%)
    Column 31 :
    [28_OTHR= Secchi Depth (m) ]
    There is/are 17 count WARNING(S)!
    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")

  • 689 2. 15. 689
    ( 100%)
    689
    ( 100%)

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