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     [ABND1= Total Copepods (#/m3)]      ( date set 1 )
    Column # 3     [ABDT1= Calanidae (#/m3)]      ( date set 1 )
    Column # 4     [ABDT1= Paracalanidae (#/m3)]      ( date set 1 )
    Column # 5     [ABDT1= Acartiidae (#/m3)]      ( date set 1 )
    Column # 6     [ABDT1= Oithonidae (#/m3)]      ( date set 1 )
    Column # 7     [ABDT2= Salpidae (#/m3)]      ( date set 1 )
    Column # 8     [ABDT2= Doliolidae (#/m3)]      ( date set 1 )

    Column # 9     [ DATE-MDY ]       Date Set = 2
    Column # 10     [CHLA= Chlorophyll (mg/m3)]      ( date set 2 )

    Column # 11     [ DATE-YMD ]       Date Set = 3
    Column # 12     [BIOM= Total Dry Mass (mg/m3)]      ( date set 3 )

    Column # 13     [ DATE-YMD ]       Date Set = 4
    Column # 14     [ABDT3= Total Diatoms (#/L)]      ( date set 4 )
    Column # 15     [ABDT3= Total Centric Diatoms (#/L)]      ( date set 4 )
    Column # 16     [ABDT3= Total Pennate Diatoms (#/L)]      ( date set 4 )
    Column # 17     [ABDT4= Total Dinoflagellates (#/L)]      ( date set 4 )
    Column # 18     [ABDT= Total Flagellates (#/L)]      ( date set 4 )
    Column # 19     [ABDT= Total Naked Flagellates (#/L)]      ( date set 4 )
    Column # 20     [ABDT= Total Ciliates (#/L)]      ( date set 4 )
    Column # 21     [ABDT= Total Coccolithophore (#/L)]      ( date set 4 )
    Column # 22     [ABDT= Total Cyanobacteria (#/L)]      ( date set 4 )

    Column # 23     [ DATE-YMD ]       Date Set = 5
    Column # 24     [PSAL= Salinity () at 10m]      ( date set 5 )
    Column # 25     [OTHR= Oxygen (uM) at 10m]      ( date set 5 )
    Column # 26     [LOTH= Silicate (uM) at 10m]      ( date set 5 )
    Column # 27     [LOTH= Nitrate (uM) at 10m]      ( date set 5 )
    Column # 28     [LOTH= Nitrite (uM) at 10m]      ( date set 5 )
    Column # 29     [LOTH= NH4 (uM) at 10m]      ( date set 5 )
    Column # 30     [LOTH= Phosphate (uM) at 10m]      ( date set 5 )
    Column # 31     [OTHR= TCO2 (umol/kg) at 10m]      ( date set 5 )
    Column # 32     [OTHR= Total Alkalinity (umol/kg) at 10m]      ( date set 5 )

    Column # 33     [ DATE-YMD ]       Date Set = 6
    Column # 34     [PSAL= Average Salinity () from 0-100m]      ( date set 6 )
    Column # 35     [OTHR= Average Oxygen (uM) from 0-100m]      ( date set 6 )
    Column # 36     [LOTH= Average Silicate (uM) from 0-100m]      ( date set 6 )
    Column # 37     [LOTH= Average Nitrate (uM) from 0-100m]      ( date set 6 )
    Column # 38     [LOTH= Average Nitrite (uM) from 0-100m]      ( date set 6 )
    Column # 39     [LOTH= Average NH4 (uM) from 0-100m]      ( date set 6 )
    Column # 40     [LOTH= Average Phosphate (uM) from 0-100m]      ( date set 6 )
    Column # 41     [OTHR= Average TCO2 (umol/kg) from 0-100m]      ( date set 6 )
    Column # 42     [OTHR= Average Total Alkalinity (umol/kg) from 0-100m]      ( date set 6 )

    Column # 43     [ DATE-YMD ]       Date Set = 7
    Column # 44     [TEMP= Temperature () at the surface]      ( date set 7 )
    Column # 45     [PSAL= Salinity () at the surface]      ( date set 7 )
    Column # 46     [CHLA= Fluorometric Chlorophyll () at the surface]      ( date set 7 )
    Column # 47     [OTHR= Turbidity () at the surface]      ( date set 7 )

    Column # 48     [ DATE-YMD ]       Date Set = 8
    Column # 49     [TEMP= Temperature ( C ) at 5m]      ( date set 8 )
    Column # 50     [TEMP= Temperature ( C ) at 10m]      ( date set 8 )
    Column # 51     [TEMP= Temperature ( C ) at 20m]      ( date set 8 )
    Column # 52     [TEMP= Temperature ( C ) at 30m]      ( date set 8 )
    Column # 53     [TEMP= Temperature ( C ) at 40m]      ( date set 8 )
    Column # 54     [TEMP= Temperature ( C ) at 50m]      ( date set 8 )


DATA SORTED BY CATEGORY TYPES

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

    Abundance (with zeros) Category
        Column # 3   [ ABDT1= Calanidae (#/m3) ]
        Column # 4   [ ABDT1= Paracalanidae (#/m3) ]
        Column # 5   [ ABDT1= Acartiidae (#/m3) ]
        Column # 6   [ ABDT1= Oithonidae (#/m3) ]
        Column # 7   [ ABDT2= Salpidae (#/m3) ]
        Column # 8   [ ABDT2= Doliolidae (#/m3) ]
        Column # 14   [ ABDT3= Total Diatoms (#/L) ]
        Column # 15   [ ABDT3= Total Centric Diatoms (#/L) ]
        Column # 16   [ ABDT3= Total Pennate Diatoms (#/L) ]
        Column # 17   [ ABDT4= Total Dinoflagellates (#/L) ]
        Column # 18   [ ABDT= Total Flagellates (#/L) ]
        Column # 19   [ ABDT= Total Naked Flagellates (#/L) ]
        Column # 20   [ ABDT= Total Ciliates (#/L) ]
        Column # 21   [ ABDT= Total Coccolithophore (#/L) ]
        Column # 22   [ ABDT= Total Cyanobacteria (#/L) ]

    non-Log10 (linear) Miscellaenous Category
        Column # 25   [ OTHR= Oxygen (uM) at 10m ]
        Column # 31   [ OTHR= TCO2 (umol/kg) at 10m ]
        Column # 32   [ OTHR= Total Alkalinity (umol/kg) at 10m ]
        Column # 35   [ OTHR= Average Oxygen (uM) from 0-100m ]
        Column # 41   [ OTHR= Average TCO2 (umol/kg) from 0-100m ]
        Column # 42   [ OTHR= Average Total Alkalinity (umol/kg) from 0-100m ]
        Column # 47   [ OTHR= Turbidity () at the surface ]

    Temperatures Category
        Column # 44   [ TEMP= Temperature () at the surface ]
        Column # 49   [ TEMP= Temperature ( C ) at 5m ]
        Column # 50   [ TEMP= Temperature ( C ) at 10m ]
        Column # 51   [ TEMP= Temperature ( C ) at 20m ]
        Column # 52   [ TEMP= Temperature ( C ) at 30m ]
        Column # 53   [ TEMP= Temperature ( C ) at 40m ]
        Column # 54   [ TEMP= Temperature ( C ) at 50m ]

    Salinities Category
        Column # 24   [ PSAL= Salinity () at 10m ]
        Column # 34   [ PSAL= Average Salinity () from 0-100m ]
        Column # 45   [ PSAL= Salinity () at the surface ]

DATA SORTED BY GROUPING SETS:

    Category 2 Group # 1
        column # 2     [ ABND1= Total Copepods (#/m3) ]

    Category 8 Group # 1
        column # 3     [ ABDT1= Calanidae (#/m3) ]
        column # 4     [ ABDT1= Paracalanidae (#/m3) ]
        column # 5     [ ABDT1= Acartiidae (#/m3) ]
        column # 6     [ ABDT1= Oithonidae (#/m3) ]

    Category 8 Group # 2
        column # 7     [ ABDT2= Salpidae (#/m3) ]
        column # 8     [ ABDT2= Doliolidae (#/m3) ]

    Category 8 Group # 3
        column # 14     [ ABDT3= Total Diatoms (#/L) ]
        column # 15     [ ABDT3= Total Centric Diatoms (#/L) ]
        column # 16     [ ABDT3= Total Pennate Diatoms (#/L) ]

    Category 8 Group # 4
        column # 17     [ ABDT4= Total Dinoflagellates (#/L) ]



DATE REVIEW SECTION
[
Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 2002 2015
DATES in Column 9 no problems detected 2009 2014
DATES in Column 11 no problems detected 2009 2018
DATES in Column 13 no problems detected 2009 2015
DATES in Column 23 no problems detected 2009 2018
DATES in Column 33 no problems detected 2009 2018
DATES in Column 43 no problems detected 2009 2015
DATES in Column 48 no problems detected 2009 2013

 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 2002 2015 01 12 01 31
9 DATE-MDY DATE-MDY yes 1 12 1 30 2009 2014
11 DATE-YMD DATE-YMD yes 2009 2018 01 12 01 31
13 DATE-YMD DATE-YMD yes 2009 2015 01 12 01 31
23 DATE-YMD DATE-YMD yes 2009 2018 1 12 1 31
33 DATE-YMD DATE-YMD yes 2009 2018 1 12 1 31
43 DATE-YMD DATE-YMD yes 2009 2015 01 12 01 31
48 DATE-YMD DATE-YMD yes 2009 2013 Apr Sep 1 30



DATA REVIEW SECTION
[
Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)
Maximum Values
> 0
Values
> 1
Column 2 :
[ 04_ABND1= Total Copepods (#/m3) ]
no problems detected 149 12.2574997 12207.3633 148
( 99 %)
148
( 99 %)
Column 3 :
[ 05_ABDT1= Calanidae (#/m3) ]
no problems detected 149 0.882000029 3541.62231 148
( 99 %)
147
( 98 %)
Column 4 :
[ 06_ABDT1= Paracalanidae (#/m3) ]
no problems detected 149 0.332800001 652.450623 148
( 99 %)
146
( 97 %)
Column 5 :
[ 07_ABDT1= Acartiidae (#/m3) ]
no problems detected 149 0.166400000 716.104370 140
( 93 %)
136
( 91 %)
Column 6 :
[ 08_ABDT1= Oithonidae (#/m3) ]
no problems detected 149 1.89849997 3978.35791 148
( 99 %)
148
( 99 %)
Column 7 :
[ 09_ABDT2= Salpidae (#/m3) ]
no problems detected 149 0.707300007 992.419373 56
( 37 %)
55
( 36 %)
Column 8 :
[ 10_ABDT2= Doliolidae (#/m3) ]
no problems detected 149 0.257200003 1311.26672 103
( 69 %)
98
( 65 %)
Column 10 :
[11_CHLA= Chlorophyll (mg/m3) ]
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")

  • 52 0.159999996 1.84300005 52
    ( 100 %)
    4
    ( 7 %)
    Column 12 :
    [ 12_BIOM= Total Dry Mass (mg/m3) ]
    no problems detected 169 0.194490001 140.084198 169
    ( 100 %)
    161
    ( 95 %)
    Column 14 :
    [ 13_ABDT3= Total Diatoms (#/L) ]
    no problems detected 70 50.0000000 189311.000 70
    ( 100 %)
    70
    ( 100 %)
    Column 15 :
    [ 14_ABDT3= Total Centric Diatoms (#/L) ]
    no problems detected 70 25.0000000 188808.000 70
    ( 100 %)
    70
    ( 100 %)
    Column 16 :
    [ 15_ABDT3= Total Pennate Diatoms (#/L) ]
    no problems detected 70 25.0000000 11262.0000 68
    ( 97 %)
    68
    ( 97 %)
    Column 17 :
    [ 16_ABDT4= Total Dinoflagellates (#/L) ]
    no problems detected 70 95.0000000 7995.00000 68
    ( 97 %)
    68
    ( 97 %)
    Column 18 :
    [17_ABDT= Total Flagellates (#/L) ]
    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")

  • 70 9999999.00 0.00000000 0
    ( 0 %)
    0
    ( 0 %)
    Column 19 :
    [ 18_ABDT= Total Naked Flagellates (#/L) ]
    no problems detected 70 503.000000 947732.000 63
    ( 90 %)
    63
    ( 90 %)
    Column 20 :
    [ 19_ABDT= Total Ciliates (#/L) ]
    no problems detected 70 25.0000000 3518.00000 23
    ( 32 %)
    23
    ( 32 %)
    Column 21 :
    [20_ABDT= Total Coccolithophore (#/L) ]
    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")

  • 70 127.000000 3015.00000 3
    ( 4 %)
    3
    ( 4 %)
    Column 22 :
    [21_ABDT= Total Cyanobacteria (#/L) ]
    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")

  • 70 9999999.00 0.00000000 0
    ( 0 %)
    0
    ( 0 %)
    Column 24 :
    [ 22_PSAL= Salinity () at 10m ]
    no problems detected 103 34.7560005 35.8129997 103
    ( 100 %)
    103
    ( 100 %)
    Column 25 :
    [23_OTHR= Oxygen (uM) at 10m ]
    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")

  • 0 9999999.00 -9999999.00 0
    ( -2147483648 %)
    0
    ( -2147483648 %)
    Column 26 :
    [ 24_LOTH= Silicate (uM) at 10m ]
    no problems detected 103 -0.100000001 3.70000005 94
    ( 91 %)
    21
    ( 20 %)
    Column 27 :
    [ 25_LOTH= Nitrate (uM) at 10m ]
    no problems detected 102 0.100000001 7.50000000 71
    ( 69 %)
    25
    ( 24 %)
    Column 28 :
    [ 26_LOTH= Nitrite (uM) at 10m ]
    no problems detected 16 9.99999978E-03 0.519999981 15
    ( 93 %)
    0
    ( 0 %)
    Column 29 :
    [ 27_LOTH= NH4 (uM) at 10m ]
    no problems detected 101 9.99999978E-03 1.44000006 89
    ( 88 %)
    5
    ( 4 %)
    Column 30 :
    [ 28_LOTH= Phosphate (uM) at 10m ]
    no problems detected 103 9.99999978E-03 2.03999996 103
    ( 100 %)
    1
    ( 0 %)
    Column 31 :
    [29_OTHR= TCO2 (umol/kg) at 10m ]
    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")

  • 0 9999999.00 -9999999.00 0
    ( -2147483648 %)
    0
    ( -2147483648 %)
    Column 32 :
    [30_OTHR= Total Alkalinity (umol/kg) at 10m ]
    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")

  • 0 9999999.00 -9999999.00 0
    ( -2147483648 %)
    0
    ( -2147483648 %)
    Column 34 :
    [ 31_PSAL= Average Salinity () from 0-100m ]
    no problems detected 1023 34.7400017 35.8190002 1023
    ( 100 %)
    1023
    ( 100 %)
    Column 35 :
    [32_OTHR= Average Oxygen (uM) from 0-100m ]
    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")

  • 0 9999999.00 -9999999.00 0
    ( -2147483648 %)
    0
    ( -2147483648 %)
    Column 36 :
    [ 33_LOTH= Average Silicate (uM) from 0-100m ]
    no problems detected 1034 -0.100000001 7.40000010 1007
    ( 97 %)
    566
    ( 54 %)
    Column 37 :
    [ 34_LOTH= Average Nitrate (uM) from 0-100m ]
    no problems detected 1026 -0.100000001 13.1000004 905
    ( 88 %)
    655
    ( 63 %)
    Column 38 :
    [ 35_LOTH= Average Nitrite (uM) from 0-100m ]
    no problems detected 160 9.99999978E-03 1.03999996 154
    ( 96 %)
    1
    ( 0 %)
    Column 39 :
    [ 36_LOTH= Average NH4 (uM) from 0-100m ]
    no problems detected 1009 -9.99999978E-03 3.53999996 916
    ( 90 %)
    54
    ( 5 %)
    Column 40 :
    [ 37_LOTH= Average Phosphate (uM) from 0-100m ]
    no problems detected 1034 9.99999978E-03 2.03999996 1032
    ( 99 %)
    1
    ( 0 %)
    Column 41 :
    [ 38_OTHR= Average TCO2 (umol/kg) from 0-100m ]
    no problems detected 556 1977.30005 2134.72998 556
    ( 100 %)
    556
    ( 100 %)
    Column 42 :
    [ 39_OTHR= Average Total Alkalinity (umol/kg) from 0-100m ]
    no problems detected 561 2284.57007 2348.35010 561
    ( 100 %)
    561
    ( 100 %)
    Column 44 :
    [ 40_TEMP= Temperature () at the surface ]
    no problems detected 319 15.4372997 24.4549007 319
    ( 100 %)
    319
    ( 100 %)
    Column 45 :
    [ 41_PSAL= Salinity () at the surface ]
    no problems detected 319 30.9662991 35.6808014 319
    ( 100 %)
    319
    ( 100 %)
    Column 46 :
    [ 42_CHLA= Fluorometric Chlorophyll () at the surface ]
    no problems detected 318 0.354900002 12.5195999 318
    ( 100 %)
    272
    ( 85 %)
    Column 47 :
    [43_OTHR= Turbidity () at the surface ]
    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")

  • 0 9999999.00 -9999999.00 0
    ( -2147483648 %)
    0
    ( -2147483648 %)
    Column 49 :
    [ 44_TEMP= Temperature ( C ) at 5m ]
    no problems detected 50 16.5221996 24.5063000 50
    ( 100 %)
    50
    ( 100 %)
    Column 50 :
    [ 45_TEMP= Temperature ( C ) at 10m ]
    no problems detected 50 16.4256001 24.5007000 50
    ( 100 %)
    50
    ( 100 %)
    Column 51 :
    [ 46_TEMP= Temperature ( C ) at 20m ]
    no problems detected 50 15.9750004 24.4958000 50
    ( 100 %)
    50
    ( 100 %)
    Column 52 :
    [ 47_TEMP= Temperature ( C ) at 30m ]
    no problems detected 50 14.9738998 23.7639008 50
    ( 100 %)
    50
    ( 100 %)
    Column 53 :
    [ 48_TEMP= Temperature ( C ) at 40m ]
    no problems detected 50 14.3556004 21.8586006 50
    ( 100 %)
    50
    ( 100 %)
    Column 54 :
    [ 49_TEMP= Temperature ( C ) at 50m ]
    no problems detected 50 14.1843996 20.9416008 50
    ( 100 %)
    50
    ( 100 %)

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