COPEPODITE Incoming Data Review

Fatal Format Issues:   none


    Mild Data Warnings (non-numeric values):   1    [ Jump to the DATA REVIEW SECTION ]
Warnings do not need to be fixed before processing, but could impact results.




HEADER REVIEW SECTION
[
Jump back to TOP ]

SEQUENTIAL ORDERING OF ACTIVE DATA COLUMNS

    Column # 1     [ DATE-YMD ]       Date Set = 1
    Column # 2    [ABDT= Total Copepods (#/m3)]      ( date set 1 )
    Column # 3    [BIOM= Total Carbon Mass (ug-C/m3)]      ( date set 1 )

    Column # 4     [ DATE-MDY ]       Date Set = 2
    Column # 5    [ABDT5= Total Diatoms (cells/ml)]      ( date set 2 )
    Column # 6    [ABDT5= Total Dinoflagellates (cells/ml)]      ( date set 2 )
    Column # 7    [ABDT5= Total Coccolithophorids (cells/ml)]      ( date set 2 )

    Column # 8     [ DATE-MDY ]       Date Set = 3
    Column # 9    [TEMP= Temperature ( C ) at the surface]      ( date set 3 )
    Column # 10    [PSAL= Salinity () at the surface]      ( date set 3 )

    Column # 11     [ DATE-MDY ]       Date Set = 4
    Column # 12     [CHLA1= Chlorophyll-a (mg/m3) via fluorometer at the surface]      ( date set 4 )

    Column # 13     [ DATE-DMY ]       Date Set = 5
    Column # 14    [LOTH4= NO3+NO2 (uM) at the surface]      ( date set 5 )
    Column # 15    [LOTH4= Nitrite (uM) at the surface]      ( date set 5 )
    Column # 16    [LOTH4= Ammonia (uM) at the surface]      ( date set 5 )
    Column # 17    [LOTH4= Silicate (uM) at the surface]      ( date set 5 )
    Column # 18    [LOTH4= Phosphate (uM) at the surface]      ( date set 5 )


DATA SORTED BY CATEGORY TYPES

    Total Biomass Category
        Column # 3   [ BIOM= Total Carbon Mass (ug-C/m3) ]

    Abundance (with zeros) Category
        Column # 2   [ ABDT= Total Copepods (#/m3) ]
        Column # 5   [ ABDT5= Total Diatoms (cells/ml) ]
        Column # 6   [ ABDT5= Total Dinoflagellates (cells/ml) ]
        Column # 7   [ ABDT5= Total Coccolithophorids (cells/ml) ]

    Log10 (logarithmic) Miscellaenous Category
        Column # 14   [ LOTH4= NO3+NO2 (uM) at the surface ]
        Column # 15   [ LOTH4= Nitrite (uM) at the surface ]
        Column # 16   [ LOTH4= Ammonia (uM) at the surface ]
        Column # 17   [ LOTH4= Silicate (uM) at the surface ]
        Column # 18   [ LOTH4= Phosphate (uM) at the surface ]

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

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

    Chlorophyll/Pigments Category
        Column # 12   [ CHLA1= Chlorophyll-a (mg/m3) via fluorometer at the surface ]

DATA SORTED BY GROUPING SETS:

    Category 3 Group # 1
        column # 12     [ CHLA1= Chlorophyll-a (mg/m3) via fluorometer at the surface ]

    Category 8 Group # 5
        column # 5     [ ABDT5= Total Diatoms (cells/ml) ]
        column # 6     [ ABDT5= Total Dinoflagellates (cells/ml) ]
        column # 7     [ ABDT5= Total Coccolithophorids (cells/ml) ]

    Category 9 Group # 4
        column # 14     [ LOTH4= NO3+NO2 (uM) at the surface ]
        column # 15     [ LOTH4= Nitrite (uM) at the surface ]
        column # 16     [ LOTH4= Ammonia (uM) at the surface ]
        column # 17     [ LOTH4= Silicate (uM) at the surface ]
        column # 18     [ LOTH4= Phosphate (uM) at the surface ]



DATE REVIEW SECTION
[
Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1988 2017
DATES in Column 4 no problems detected 1992 2014
DATES in Column 8 no problems detected 1988 2017
DATES in Column 11 no problems detected 1992 2018
DATES in Column 13 no problems detected 2000 2018

 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 1988 2017 1 12 1 31
4 DATE-MDY DATE-MDY yes 1 12 1 31 1992 2014
8 DATE-MDY DATE-MDY yes Apr 12 01 31 1988 2017
11 DATE-MDY DATE-MDY yes 1 12 1 31 1992 2018
13 DATE-DMY DATE-DMY yes 1 31 01 12 2000 2018



DATA REVIEW SECTION
[
Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)
Maximum Values
> 0
Values
> 1
Column 2 :
[ 04_ABDT= Total Copepods (#/m3) ]
no problems detected 1317 10. 15480. 1314
( 99%)
1314
( 99%)
Column 3 :
[ 05_BIOM= Total Carbon Mass (ug-C/m3) ]
no problems detected 1317 100. 233800. 1317
( 100%)
1317
( 100%)
Column 5 :
[ 06_ABDT5= Total Diatoms (cells/ml) ]
no problems detected 916 0.100000001 5055.8999 916
( 100%)
902
( 98%)
Column 6 :
[ 07_ABDT5= Total Dinoflagellates (cells/ml) ]
no problems detected 916 0.100000001 4814.7002 914
( 99%)
662
( 72%)
Column 7 :
[ 08_ABDT5= Total Coccolithophorids (cells/ml) ]
no problems detected 916 0.100000001 2878.30005 725
( 79%)
716
( 78%)
Column 9 :
[ 09_TEMP= Temperature ( C ) at the surface ]
no problems detected 1886 6.76000023 19.9200001 1886
( 100%)
1886
( 100%)
Column 10 :
[10_PSAL= Salinity () at the surface ]
There is/are 1 count WARNING(S)!
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")

  • 1311 33.4599991 35.8600006 1311
    ( 100%)
    1311
    ( 100%)
    Column 12 :
    [ 11_CHLA1= Chlorophyll-a (mg/m3) via fluorometer at the surface ]
    no problems detected 1022 0.100000001 11.7200003 1022
    ( 100%)
    485
    ( 47%)
    Column 14 :
    [ 12_LOTH4= NO3+NO2 (uM) at the surface ]
    no problems detected 2223 0.00999999978 16.25 1973
    ( 88%)
    1254
    ( 56%)
    Column 15 :
    [ 13_LOTH4= Nitrite (uM) at the surface ]
    no problems detected 2269 0.00999999978 1.38999999 1810
    ( 79%)
    39
    ( 1%)
    Column 16 :
    [ 14_LOTH4= Ammonia (uM) at the surface ]
    no problems detected 1905 0.00999999978 4.13999987 1697
    ( 89%)
    62
    ( 3%)
    Column 17 :
    [ 15_LOTH4= Silicate (uM) at the surface ]
    no problems detected 2126 0.00999999978 13.6599998 2126
    ( 100%)
    1504
    ( 70%)
    Column 18 :
    [ 16_LOTH4= Phosphate (uM) at the surface ]
    no problems detected 2232 0.00999999978 1.11000001 2145
    ( 96%)
    3
    ( 0%)

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