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 Phytoplankton < 20 um (cells/ml) at 1 m]      ( date set 1 )
    Column # 3     [ABND1= Total Synechococcus (cells/ml) at 1 m]      ( date set 1 )
    Column # 4     [ABND1= Total Cryptophytes (cells/ml) at 1 m]      ( date set 1 )
    Column # 5     [ABND1= Total Eukaryotic Phytoplankton (cells/ml) at 1 m]      ( date set 1 )
    Column # 6     [ABND1= Total small Eukaryotic Phytoplankton (cells/ml) at 1 m]      ( date set 1 )
    Column # 7     [ABND3= Total Bacteria (cells/ml) at 1 m]      ( date set 1 )

    Column # 8     [ DATE-YMD ]       Date Set = 2
    Column # 9     [CHLA= Total Chlorophyll (ug/l) at 1 m]      ( date set 2 )
    Column # 10     [CHLA= Total Chlorophyll < 3 um (ug/l) at 1 m]      ( date set 2 )
    Column # 11     [CHLA= Total Chlorophyll < 20 um (ug/l) at 1 m]      ( date set 2 )
    Column # 12     [CHLA= Total Chlorophyll 3-20 um (ug/l) at 1 m]      ( date set 2 )
    Column # 13     [CHLA= Total Chlorophyll > 20 um (ug/l) at 1 m]      ( date set 2 )

    Column # 14     [ DATE-YMD ]       Date Set = 3
    Column # 15     [TEMP= Temperature ( C ) at 1 m]      ( date set 3 )


DATA SORTED BY CATEGORY TYPES

    Total/non-zero Abundance Category
        Column # 2   [ ABND1= Total Phytoplankton < 20 um (cells/ml) at 1 m ]
        Column # 3   [ ABND1= Total Synechococcus (cells/ml) at 1 m ]
        Column # 4   [ ABND1= Total Cryptophytes (cells/ml) at 1 m ]
        Column # 5   [ ABND1= Total Eukaryotic Phytoplankton (cells/ml) at 1 m ]
        Column # 6   [ ABND1= Total small Eukaryotic Phytoplankton (cells/ml) at 1 m ]
        Column # 7   [ ABND3= Total Bacteria (cells/ml) at 1 m ]

    Temperatures Category
        Column # 15   [ TEMP= Temperature ( C ) at 1 m ]

DATA SORTED BY GROUPING SETS:

    Category 2 Group # 1
        column # 2     [ ABND1= Total Phytoplankton < 20 um (cells/ml) at 1 m ]
        column # 3     [ ABND1= Total Synechococcus (cells/ml) at 1 m ]
        column # 4     [ ABND1= Total Cryptophytes (cells/ml) at 1 m ]
        column # 5     [ ABND1= Total Eukaryotic Phytoplankton (cells/ml) at 1 m ]
        column # 6     [ ABND1= Total small Eukaryotic Phytoplankton (cells/ml) at 1 m ]

    Category 2 Group # 3
        column # 7     [ ABND3= Total Bacteria (cells/ml) at 1 m ]



DATE REVIEW SECTION
[
Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 2000 2023
DATES in Column 8 no problems detected 2000 2023
DATES in Column 14 no problems detected 2000 2023

 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 2000 2023 1 12 1 31
8 DATE-YMD DATE-YMD yes 2000 2023 1 12 1 31
14 DATE-YMD DATE-YMD yes 2000 2023 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_ABND1= Total Phytoplankton < 20 um (cells/ml) at 1 m ]
no problems detected 920 1052.00000 458946.000 920
( 100 %)
920
( 100 %)
Column 3 :
[ 05_ABND1= Total Synechococcus (cells/ml) at 1 m ]
no problems detected 920 71.0000000 275728.000 920
( 100 %)
920
( 100 %)
Column 4 :
[ 06_ABND1= Total Cryptophytes (cells/ml) at 1 m ]
no problems detected 920 11.0000000 3920.00000 920
( 100 %)
920
( 100 %)
Column 5 :
[ 07_ABND1= Total Eukaryotic Phytoplankton (cells/ml) at 1 m ]
no problems detected 920 571.000000 282446.000 920
( 100 %)
920
( 100 %)
Column 6 :
[ 08_ABND1= Total small Eukaryotic Phytoplankton (cells/ml) at 1 m ]
no problems detected 722 9.00000000 268306.000 722
( 100 %)
722
( 100 %)
Column 7 :
[ 09_ABND3= Total Bacteria (cells/ml) at 1 m ]
no problems detected 733 146154.000 8546805.00 733
( 100 %)
733
( 100 %)
Column 9 :
[ 10_CHLA= Total Chlorophyll (ug/l) at 1 m ]
no problems detected 926 0.213000000 24.2040005 926
( 100 %)
787
( 84 %)
Column 10 :
[ 11_CHLA= Total Chlorophyll < 3 um (ug/l) at 1 m ]
no problems detected 925 1.49999997E-02 2.99699998 924
( 99 %)
121
( 13 %)
Column 11 :
[ 12_CHLA= Total Chlorophyll < 20 um (ug/l) at 1 m ]
no problems detected 925 3.29999998E-02 20.4599991 924
( 99 %)
522
( 56 %)
Column 12 :
[ 13_CHLA= Total Chlorophyll 3-20 um (ug/l) at 1 m ]
no problems detected 924 1.00000005E-03 18.4599991 923
( 99 %)
296
( 32 %)
Column 13 :
[ 14_CHLA= Total Chlorophyll > 20 um (ug/l) at 1 m ]
no problems detected 903 4.00000019E-03 21.6340008 903
( 100 %)
358
( 39 %)
Column 15 :
[ 15_TEMP= Temperature ( C ) at 1 m ]
no problems detected 934 -2.00000000 23.0000000 913
( 97 %)
894
( 95 %)

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