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     [ABDT3= Total Copepods (#/m2)]      ( date set 1 )

    Column # 3     [ DATE-YMD ]       Date Set = 2
    Column # 4     [BIOM3= Total Wet Weight (g/m2)]      ( date set 2 )
    Column # 5     [BIOM2= Total Dry Weight (g/m2)]      ( date set 2 )
    Column # 6     [BIOM3= Total Wet Weight of <10 mm (g/m2)]      ( date set 2 )
    Column # 7     [BIOM3= Total Wet Weight of >10 mm (g/m2)]      ( date set 2 )
    Column # 8     [BIOM2= Total Dry Weight of <10 mm (g/m2)]      ( date set 2 )

    Column # 9     [ DATE-YMD ]       Date Set = 3
    Column # 10     [ABDT8= Total Diatoms (#/L)]      ( date set 3 )
    Column # 11     [ABDT8= Total Dinoflagellates (#/L)]      ( date set 3 )
    Column # 12     [ABDT8= Total Ciliates (#/L)]      ( date set 3 )
    Column # 13     [ABDT8= Total Flagellates (#/L)]      ( date set 3 )

    Column # 14     [ DATE-YMD ]       Date Set = 4
    Column # 15     [CHLA= Integrated Chlorophyll (mg/m2) from 0-100m]      ( date set 4 )

    Column # 16     [ DATE-YMD ]       Date Set = 5
    Column # 17     [LOTH3= Nitrate (mmol/m3) at the surface]      ( date set 5 )
    Column # 18     [LOTH3= Phosphate (mmol/m3) at the surface]      ( date set 5 )
    Column # 19     [LOTH3= Silicate (mmol/m3) at the surface]      ( date set 5 )

    Column # 20     [ DATE-YMD ]       Date Set = 6
    Column # 21     [LOTH3= Nitrate (mmol/m3) at the bottom]      ( date set 6 )
    Column # 22     [LOTH3= Phosphate (mmol/m3) at the bottom]      ( date set 6 )
    Column # 23     [LOTH3= Silicate (mmol/m3) at the bottom]      ( date set 6 )

    Column # 24     [ DATE-YMD ]       Date Set = 7
    Column # 25     [TEMP1= Temperature ( C ) at the surface]      ( date set 7 )
    Column # 26     [PSAL1= Salinity () at the surface]      ( date set 7 )
    Column # 27     [TEMP1= Temperature ( C ) at the bottom]      ( date set 7 )
    Column # 28     [PSAL1= Salinity () at the bottom]      ( date set 7 )


DATA SORTED BY CATEGORY TYPES

    Abundance (with zeros) Category
        Column # 2   [ ABDT3= Total Copepods (#/m2) ]
        Column # 10   [ ABDT8= Total Diatoms (#/L) ]
        Column # 11   [ ABDT8= Total Dinoflagellates (#/L) ]
        Column # 12   [ ABDT8= Total Ciliates (#/L) ]
        Column # 13   [ ABDT8= Total Flagellates (#/L) ]

    Temperatures Category
        Column # 25   [ TEMP1= Temperature ( C ) at the surface ]
        Column # 27   [ TEMP1= Temperature ( C ) at the bottom ]

    Salinities Category
        Column # 26   [ PSAL1= Salinity () at the surface ]
        Column # 28   [ PSAL1= Salinity () at the bottom ]

DATA SORTED BY GROUPING SETS:

    Category 4 Group # 1
        column # 25     [ TEMP1= Temperature ( C ) at the surface ]
        column # 27     [ TEMP1= Temperature ( C ) at the bottom ]

    Category 5 Group # 1
        column # 26     [ PSAL1= Salinity () at the surface ]
        column # 28     [ PSAL1= Salinity () at the bottom ]

    Category 8 Group # 3
        column # 2     [ ABDT3= Total Copepods (#/m2) ]

    Category 8 Group # 8
        column # 10     [ ABDT8= Total Diatoms (#/L) ]
        column # 11     [ ABDT8= Total Dinoflagellates (#/L) ]
        column # 12     [ ABDT8= Total Ciliates (#/L) ]
        column # 13     [ ABDT8= Total Flagellates (#/L) ]



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 1999 2017
DATES in Column 9 no problems detected 1999 2017
DATES in Column 14 no problems detected 1999 2017
DATES in Column 16 no problems detected 1999 2017
DATES in Column 20 no problems detected 1999 2017
DATES in Column 24 no problems detected 1999 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 1999 2017 1 12 1 31
3 DATE-YMD DATE-YMD yes 1999 2017 1 12 1 31
9 DATE-YMD DATE-YMD yes 1999 2017 1 12 1 31
14 DATE-YMD DATE-YMD yes 1999 2017 1 12 1 31
16 DATE-YMD DATE-YMD yes 1999 2017 1 12 1 31
20 DATE-YMD DATE-YMD yes 1999 2017 1 12 1 31
24 DATE-YMD DATE-YMD yes 1999 2017 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_ABDT3= Total Copepods (#/m2) ]
no problems detected 377 2160.72241 1032078.81 377
( 100 %)
377
( 100 %)
Column 4 :
[ 05_BIOM3= Total Wet Weight (g/m2) ]
no problems detected 349 0.259410173 102.994705 349
( 100 %)
346
( 99 %)
Column 5 :
[ 06_BIOM2= Total Dry Weight (g/m2) ]
no problems detected 366 2.26361398E-02 255.597229 366
( 100 %)
321
( 87 %)
Column 6 :
[ 07_BIOM3= Total Wet Weight of <10 mm (g/m2) ]
no problems detected 331 0.241753981 127.269508 331
( 100 %)
327
( 98 %)
Column 7 :
[ 08_BIOM3= Total Wet Weight of >10 mm (g/m2) ]
no problems detected 321 3.16908304E-03 23.8573608 311
( 96 %)
144
( 44 %)
Column 8 :
[ 09_BIOM2= Total Dry Weight of <10 mm (g/m2) ]
no problems detected 366 2.26361398E-02 255.597229 366
( 100 %)
319
( 87 %)
Column 10 :
[ 10_ABDT8= Total Diatoms (#/L) ]
no problems detected 345 167.000000 1034400.00 344
( 99 %)
344
( 99 %)
Column 11 :
[ 11_ABDT8= Total Dinoflagellates (#/L) ]
no problems detected 345 100.000000 126000.000 341
( 98 %)
341
( 98 %)
Column 12 :
[ 12_ABDT8= Total Ciliates (#/L) ]
no problems detected 345 100.000000 6000.00000 306
( 88 %)
306
( 88 %)
Column 13 :
[ 13_ABDT8= Total Flagellates (#/L) ]
no problems detected 345 125.000000 161200.000 339
( 98 %)
339
( 98 %)
Column 15 :
[ 14_CHLA= Integrated Chlorophyll (mg/m2) from 0-100m ]
no problems detected 397 2.07417941 937.586975 397
( 100 %)
397
( 100 %)
Column 17 :
[ 15_LOTH3= Nitrate (mmol/m3) at the surface ]
no problems detected 387 4.00000019E-03 16.7859993 316
( 81 %)
126
( 32 %)
Column 18 :
[ 16_LOTH3= Phosphate (mmol/m3) at the surface ]
no problems detected 385 5.70000000E-02 1.31500006 385
( 100 %)
2
( 0 %)
Column 19 :
[ 17_LOTH3= Silicate (mmol/m3) at the surface ]
no problems detected 386 3.09999995E-02 15.4130001 376
( 97 %)
187
( 48 %)
Column 21 :
[ 18_LOTH3= Nitrate (mmol/m3) at the bottom ]
no problems detected 387 1.38499999 20.1930008 387
( 100 %)
387
( 100 %)
Column 22 :
[ 19_LOTH3= Phosphate (mmol/m3) at the bottom ]
no problems detected 385 0.465999991 11.5699997 385
( 100 %)
355
( 92 %)
Column 23 :
[ 20_LOTH3= Silicate (mmol/m3) at the bottom ]
no problems detected 387 0.901000023 20.3395004 387
( 100 %)
386
( 99 %)
Column 25 :
[ 21_TEMP1= Temperature ( C ) at the surface ]
no problems detected 395 -1.62730002 21.1737003 374
( 94 %)
337
( 85 %)
Column 26 :
[ 22_PSAL1= Salinity () at the surface ]
no problems detected 388 29.2651997 32.2014008 388
( 100 %)
388
( 100 %)
Column 27 :
[ 23_TEMP1= Temperature ( C ) at the bottom ]
no problems detected 363 1.27629995 10.5019999 363
( 100 %)
363
( 100 %)
Column 28 :
[ 24_PSAL1= Salinity () at the bottom ]
no problems detected 358 31.9522991 34.9753990 358
( 100 %)
358
( 100 %)

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