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 (#/L) at the surface]      ( date set 1 )

    Column # 3     [ DATE-YMD ]       Date Set = 2
    Column # 4    [ABDT1= Total Dinoflagellates (#/L) at the surface]      ( date set 2 )

    Column # 5     [ DATE-YMD ]       Date Set = 3
    Column # 6    [TEMP= Temperature (C) at the surface]      ( date set 3 )

    Column # 7     [ DATE-YMD ]       Date Set = 4
    Column # 8    [PSAL= Salinity () at the surface]      ( date set 4 )

    Column # 9     [ DATE-YMD ]       Date Set = 5
    Column # 10    [OTHR= Oxygen (ml/l) at the surface]      ( date set 5 )

    Column # 11     [ DATE-YMD ]       Date Set = 6
    Column # 12    [CHLA= Chlorophyll (ug/L) at the surface]      ( date set 6 )


DATA SORTED BY CATEGORY TYPES

    Abundance (with zeros) Category
        Column # 2   [ ABDT1= Total Diatoms (#/L) at the surface ]
        Column # 4   [ ABDT1= Total Dinoflagellates (#/L) at the surface ]

    non-Log10 (linear) Miscellaenous Category
        Column # 10   [ OTHR= Oxygen (ml/l) at the surface ]

    Temperatures Category
        Column # 6   [ TEMP= Temperature (C) at the surface ]

    Salinities Category
        Column # 8   [ PSAL= Salinity () at the surface ]

    Chlorophyll/Pigments Category
        Column # 12   [ CHLA= Chlorophyll (ug/L) at the surface ]

DATA SORTED BY GROUPING SETS:

    Category 8 Group # 1
        column # 2     [ ABDT1= Total Diatoms (#/L) at the surface ]
        column # 4     [ ABDT1= Total Dinoflagellates (#/L) at the surface ]



DATE REVIEW SECTION
[
Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1987 2007
DATES in Column 3 no problems detected 1987 2007
DATES in Column 5 no problems detected 1987 2017
DATES in Column 7 no problems detected 1987 2017
DATES in Column 9 no problems detected 1988 2007
DATES in Column 11 no problems detected 1991 2008

 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 1987 2007 01 12 01 31
3 DATE-YMD DATE-YMD yes 1987 2007 01 12 01 31
5 DATE-YMD DATE-YMD yes 1987 2017 01 12 01 31
7 DATE-YMD DATE-YMD yes 1987 2017 01 12 01 31
9 DATE-YMD DATE-YMD yes 1988 2007 01 12 01 31
11 DATE-YMD DATE-YMD yes 1991 2008 01 12 01 31



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 (#/L) at the surface ]
no problems detected 407 600. 1880700. 407
( 100%)
407
( 100%)
Column 4 :
[ 05_ABDT1= Total Dinoflagellates (#/L) at the surface ]
no problems detected 369 100. 387400. 329
( 89%)
329
( 89%)
Column 6 :
[ 06_TEMP= Temperature (C) at the surface ]
no problems detected 778 4.5 20.8999996 778
( 100%)
778
( 100%)
Column 8 :
[ 07_PSAL= Salinity () at the surface ]
no problems detected 776 19.3999996 38.2999992 775
( 99%)
775
( 99%)
Column 10 :
[ 08_OTHR= Oxygen (ml/l) at the surface ]
no problems detected 79 4.96999979 9.55000019 79
( 100%)
79
( 100%)
Column 12 :
[ 09_CHLA= Chlorophyll (ug/L) at the surface ]
no problems detected 430 0.0419999994 9.36999989 429
( 99%)
174
( 40%)

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