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 Copepods (mg-WW/m3) from 0-10m]      ( date set 1 )
    Column # 3    [ABDT1= Total Cladocera (mg-WW/m3) from 0-10m]      ( date set 1 )
    Column # 4    [ABDT1= Total Meroplankton (mg-WW/m3) from 0-10m]      ( date set 1 )
    Column # 5    [ABDT1= Total Rotatoria (mg-WW/m3) from 0-10m]      ( date set 1 )

    Column # 6     [ DATE-MDY ]       Date Set = 2
    Column # 7    [ABDT5= Bacillariophyceae (mg-WW/m3)]      ( date set 2 )
    Column # 8    [ABDT5= Dinophyceae (mg-WW/m3)]      ( date set 2 )
    Column # 9    [ABDT5= Charophyceae (mg-WW/m3)]      ( date set 2 )
    Column # 10    [ABDT5= Chlorophyceae (mg-WW/m3)]      ( date set 2 )
    Column # 11    [ABDT5= Chrysophyceae (mg-WW/m3)]      ( date set 2 )
    Column # 12    [ABDT5= Litostomatea (mg-WW/m3)]      ( date set 2 )
    Column # 13    [ABDT5= Cryptophyceae (mg-WW/m3)]      ( date set 2 )
    Column # 14    [ABDT5= Ebriidea (mg-WW/m3)]      ( date set 2 )
    Column # 15    [ABDT5= Euglenophyceae (mg-WW/m3)]      ( date set 2 )
    Column # 16    [ABDT5= Cyanophyceae (mg-WW/m3)]      ( date set 2 )
    Column # 17    [ABDT5= Prasinophyceae (mg-WW/m3)]      ( date set 2 )
    Column # 18    [ABDT5= Prymnesiophyceae (mg-WW/m3)]      ( date set 2 )

    Column # 19     [ DATE-MDY ]       Date Set = 3
    Column # 20    [CHLA= Chlorophyll-a (mg/m3) averaged from 0-10 m]      ( date set 3 )
    Column # 21    [LOTH= NO3NO2 (uM) averaged from 0-10 m]      ( date set 3 )
    Column # 22    [LOTH= Nitrite (uM) averaged from 0-10 m]      ( date set 3 )
    Column # 23    [LOTH= Nitrate (uM) averaged from 0-10 m]      ( date set 3 )
    Column # 24    [OTHR= Oxygen (ml/l) averaged from 0-10 m]      ( date set 3 )
    Column # 25    [OTHR= Oxygen (mg/l) averaged from 0-10 m]      ( date set 3 )
    Column # 26    [LOTH= Phosphate (uM) averaged from 0-10 m]      ( date set 3 )
    Column # 27    [PSAL= Salinity () averaged from 0-10 m]      ( date set 3 )
    Column # 28    [LOTH= Silicate (uM) averaged from 0-10 m]      ( date set 3 )
    Column # 29    [TEMP= Temperature ( C ) averaged from 0-10 m]      ( date set 3 )


DATA SORTED BY CATEGORY TYPES

    Abundance (with zeros) Category
        Column # 2   [ ABDT1= Total Copepods (mg-WW/m3) from 0-10m ]
        Column # 3   [ ABDT1= Total Cladocera (mg-WW/m3) from 0-10m ]
        Column # 4   [ ABDT1= Total Meroplankton (mg-WW/m3) from 0-10m ]
        Column # 5   [ ABDT1= Total Rotatoria (mg-WW/m3) from 0-10m ]
        Column # 7   [ ABDT5= Bacillariophyceae (mg-WW/m3) ]
        Column # 8   [ ABDT5= Dinophyceae (mg-WW/m3) ]
        Column # 9   [ ABDT5= Charophyceae (mg-WW/m3) ]
        Column # 10   [ ABDT5= Chlorophyceae (mg-WW/m3) ]
        Column # 11   [ ABDT5= Chrysophyceae (mg-WW/m3) ]
        Column # 12   [ ABDT5= Litostomatea (mg-WW/m3) ]
        Column # 13   [ ABDT5= Cryptophyceae (mg-WW/m3) ]
        Column # 14   [ ABDT5= Ebriidea (mg-WW/m3) ]
        Column # 15   [ ABDT5= Euglenophyceae (mg-WW/m3) ]
        Column # 16   [ ABDT5= Cyanophyceae (mg-WW/m3) ]
        Column # 17   [ ABDT5= Prasinophyceae (mg-WW/m3) ]
        Column # 18   [ ABDT5= Prymnesiophyceae (mg-WW/m3) ]

    Log10 (logarithmic) Miscellaenous Category
        Column # 21   [ LOTH= NO3NO2 (uM) averaged from 0-10 m ]
        Column # 22   [ LOTH= Nitrite (uM) averaged from 0-10 m ]
        Column # 23   [ LOTH= Nitrate (uM) averaged from 0-10 m ]
        Column # 26   [ LOTH= Phosphate (uM) averaged from 0-10 m ]
        Column # 28   [ LOTH= Silicate (uM) averaged from 0-10 m ]

    non-Log10 (linear) Miscellaenous Category
        Column # 24   [ OTHR= Oxygen (ml/l) averaged from 0-10 m ]
        Column # 25   [ OTHR= Oxygen (mg/l) averaged from 0-10 m ]

    Temperatures Category
        Column # 29   [ TEMP= Temperature ( C ) averaged from 0-10 m ]

    Salinities Category
        Column # 27   [ PSAL= Salinity () averaged from 0-10 m ]

    Chlorophyll/Pigments Category
        Column # 20   [ CHLA= Chlorophyll-a (mg/m3) averaged from 0-10 m ]

DATA SORTED BY GROUPING SETS:

    Category 8 Group # 1
        column # 2     [ ABDT1= Total Copepods (mg-WW/m3) from 0-10m ]
        column # 3     [ ABDT1= Total Cladocera (mg-WW/m3) from 0-10m ]
        column # 4     [ ABDT1= Total Meroplankton (mg-WW/m3) from 0-10m ]
        column # 5     [ ABDT1= Total Rotatoria (mg-WW/m3) from 0-10m ]

    Category 8 Group # 5
        column # 7     [ ABDT5= Bacillariophyceae (mg-WW/m3) ]
        column # 8     [ ABDT5= Dinophyceae (mg-WW/m3) ]
        column # 9     [ ABDT5= Charophyceae (mg-WW/m3) ]
        column # 10     [ ABDT5= Chlorophyceae (mg-WW/m3) ]
        column # 11     [ ABDT5= Chrysophyceae (mg-WW/m3) ]
        column # 12     [ ABDT5= Litostomatea (mg-WW/m3) ]
        column # 13     [ ABDT5= Cryptophyceae (mg-WW/m3) ]
        column # 14     [ ABDT5= Ebriidea (mg-WW/m3) ]
        column # 15     [ ABDT5= Euglenophyceae (mg-WW/m3) ]
        column # 16     [ ABDT5= Cyanophyceae (mg-WW/m3) ]
        column # 17     [ ABDT5= Prasinophyceae (mg-WW/m3) ]
        column # 18     [ ABDT5= Prymnesiophyceae (mg-WW/m3) ]



DATE REVIEW SECTION
[
Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1957 2015
DATES in Column 6 no problems detected 1993 2017
DATES in Column 19 no problems detected 1993 2017

 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 1957 2015 01 12 1 31
6 DATE-MDY DATE-MDY yes 3 12 1 31 1993 2017
19 DATE-MDY DATE-MDY yes 1 12 1 31 1993 2017



DATA REVIEW SECTION
[
Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)
Maximum Values
> 0
Values
> 1
Column 2 :
[ 04_ABDT1= Total Copepods (mg-WW/m3) from 0-10m ]
no problems detected 423 1. 10069. 420
( 99%)
417
( 98%)
Column 3 :
[ 05_ABDT1= Total Cladocera (mg-WW/m3) from 0-10m ]
no problems detected 423 1. 2014. 330
( 78%)
312
( 73%)
Column 4 :
[ 06_ABDT1= Total Meroplankton (mg-WW/m3) from 0-10m ]
no problems detected 423 1. 998. 382
( 90%)
369
( 87%)
Column 5 :
[ 07_ABDT1= Total Rotatoria (mg-WW/m3) from 0-10m ]
no problems detected 85 1. 1372. 78
( 91%)
73
( 85%)
Column 7 :
[ 08_ABDT5= Bacillariophyceae (mg-WW/m3) ]
no problems detected 247 0.300000012 10225.5996 229
( 92%)
216
( 87%)
Column 8 :
[ 09_ABDT5= Dinophyceae (mg-WW/m3) ]
no problems detected 243 0.300000012 4379. 235
( 96%)
222
( 91%)
Column 9 :
[10_ABDT5= Charophyceae (mg-WW/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")

  • 11 0.0399999991 2.79999995 10
    ( 90%)
    1
    ( 9%)
    Column 10 :
    [ 11_ABDT5= Chlorophyceae (mg-WW/m3) ]
    no problems detected 149 0.300000012 676.099976 149
    ( 100%)
    146
    ( 97%)
    Column 11 :
    [ 12_ABDT5= Chrysophyceae (mg-WW/m3) ]
    no problems detected 244 0.200000003 62.2000008 203
    ( 83%)
    182
    ( 74%)
    Column 12 :
    [ 13_ABDT5= Litostomatea (mg-WW/m3) ]
    no problems detected 118 2. 2843.8999 118
    ( 100%)
    118
    ( 100%)
    Column 13 :
    [ 14_ABDT5= Cryptophyceae (mg-WW/m3) ]
    no problems detected 253 1. 229. 252
    ( 99%)
    251
    ( 99%)
    Column 14 :
    [ 15_ABDT5= Ebriidea (mg-WW/m3) ]
    no problems detected 60 0.800000012 167.399994 60
    ( 100%)
    57
    ( 95%)
    Column 15 :
    [ 16_ABDT5= Euglenophyceae (mg-WW/m3) ]
    no problems detected 213 0.300000012 315.700012 156
    ( 73%)
    130
    ( 61%)
    Column 16 :
    [ 17_ABDT5= Cyanophyceae (mg-WW/m3) ]
    no problems detected 248 0.100000001 2039. 243
    ( 97%)
    223
    ( 89%)
    Column 17 :
    [ 18_ABDT5= Prasinophyceae (mg-WW/m3) ]
    no problems detected 145 0.100000001 310.882263 145
    ( 100%)
    136
    ( 93%)
    Column 18 :
    [ 19_ABDT5= Prymnesiophyceae (mg-WW/m3) ]
    no problems detected 239 0.00999999978 114.699997 198
    ( 82%)
    152
    ( 63%)
    Column 20 :
    [ 20_CHLA= Chlorophyll-a (mg/m3) averaged from 0-10 m ]
    no problems detected 303 0.590361416 50.9959831 303
    ( 100%)
    301
    ( 99%)
    Column 21 :
    [ 21_LOTH= NO3NO2 (uM) averaged from 0-10 m ]
    no problems detected 153 0.00333333295 39.9199982 149
    ( 97%)
    93
    ( 60%)
    Column 22 :
    [ 22_LOTH= Nitrite (uM) averaged from 0-10 m ]
    no problems detected 148 0.00333333295 1.33000004 147
    ( 99%)
    1
    ( 0%)
    Column 23 :
    [ 23_LOTH= Nitrate (uM) averaged from 0-10 m ]
    no problems detected 147 0.0166666675 27.2933331 147
    ( 100%)
    77
    ( 52%)
    Column 24 :
    [ 24_OTHR= Oxygen (ml/l) averaged from 0-10 m ]
    no problems detected 182 4.12876129 14.5249996 177
    ( 97%)
    177
    ( 97%)
    Column 25 :
    [ 25_OTHR= Oxygen (mg/l) averaged from 0-10 m ]
    no problems detected 125 6.56181812 13.1733332 125
    ( 100%)
    125
    ( 100%)
    Column 26 :
    [ 26_LOTH= Phosphate (uM) averaged from 0-10 m ]
    no problems detected 289 0.00688171992 2.54333329 288
    ( 99%)
    10
    ( 3%)
    Column 27 :
    [ 27_PSAL= Salinity () averaged from 0-10 m ]
    no problems detected 246 0.0176190473 5.79333353 246
    ( 100%)
    244
    ( 99%)
    Column 28 :
    [ 28_LOTH= Silicate (uM) averaged from 0-10 m ]
    no problems detected 280 0.00845238101 42.0858345 280
    ( 100%)
    257
    ( 91%)
    Column 29 :
    [ 29_TEMP= Temperature ( C ) averaged from 0-10 m ]
    no problems detected 239 0.0199999996 23.9666672 239
    ( 100%)
    237
    ( 99%)

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