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     [BIOM2= Total Dry 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     [BIOM3= Total Wet Weight of >10 mm (g/m2)]      ( date set 2 )

    Column # 9     [ DATE-MDY ]       Date Set = 3
    Column # 10     [TEMP= Temperature ( C ) at 10 m]      ( date set 3 )
    Column # 11     [PSAL= Salinity () at 10m]      ( date set 3 )
    Column # 12     [CHLA= Chlorophyll (ug/l) at 10m]      ( date set 3 )
    Column # 13     [LOTH1= Nitrate (mmol/m3) at 10m]      ( date set 3 )
    Column # 14     [LOTH1= Phosphate (mmol/m3) at 10m]      ( date set 3 )
    Column # 15     [LOTH1= Silicate (mmol/m3) at 10m]      ( date set 3 )
    Column # 16     [ABND2= Total Diatoms (#/L) at 10m]      ( date set 3 )
    Column # 17     [ABND2= Total Dinoflagellates (#/L) at 10m]      ( date set 3 )
    Column # 18     [ABND2= Total Flagellates (#/L) at 10m]      ( date set 3 )


DATA SORTED BY CATEGORY TYPES

    Total/non-zero Abundance Category
        Column # 16   [ ABND2= Total Diatoms (#/L) at 10m ]
        Column # 17   [ ABND2= Total Dinoflagellates (#/L) at 10m ]
        Column # 18   [ ABND2= Total Flagellates (#/L) at 10m ]

    Abundance (with zeros) Category
        Column # 2   [ ABDT3= Total Copepods (#/m2) ]

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

    Salinities Category
        Column # 11   [ PSAL= Salinity () at 10m ]

DATA SORTED BY GROUPING SETS:

    Category 2 Group # 2
        column # 16     [ ABND2= Total Diatoms (#/L) at 10m ]
        column # 17     [ ABND2= Total Dinoflagellates (#/L) at 10m ]
        column # 18     [ ABND2= Total Flagellates (#/L) at 10m ]

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



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 2022

 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-MDY DATE-MDY yes 1 12 1 31 1999 2022



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 246 1074.70166 729773.312 246
( 100 %)
246
( 100 %)
Column 4 :
[ 05_BIOM3= Total Wet Weight (g/m2) ]
no problems detected 224 0.111256279 91.3872452 224
( 100 %)
187
( 83 %)
Column 5 :
[ 06_BIOM2= Total Dry Weight (g/m2) ]
no problems detected 243 1.18181817E-02 14.5660353 238
( 97 %)
97
( 39 %)
Column 6 :
[ 07_BIOM2= Total Dry Weight of <10 mm (g/m2) ]
no problems detected 238 1.18181817E-02 14.5660353 238
( 100 %)
95
( 39 %)
Column 7 :
[ 08_BIOM3= Total Wet Weight of <10 mm (g/m2) ]
no problems detected 218 0.111256279 58.1649933 218
( 100 %)
176
( 80 %)
Column 8 :
[ 09_BIOM3= Total Wet Weight of >10 mm (g/m2) ]
no problems detected 137 7.92270340E-03 94.5332260 133
( 97 %)
26
( 18 %)
Column 10 :
[ 10_TEMP= Temperature ( C ) at 10 m ]
no problems detected 331 0.560000002 15.0699997 331
( 100 %)
330
( 99 %)
Column 11 :
[ 11_PSAL= Salinity () at 10m ]
no problems detected 330 28.6200008 33.0299988 330
( 100 %)
330
( 100 %)
Column 12 :
[ 12_CHLA= Chlorophyll (ug/l) at 10m ]
no problems detected 302 7.40799978E-02 11.3761997 302
( 100 %)
143
( 47 %)
Column 13 :
[ 13_LOTH1= Nitrate (mmol/m3) at 10m ]
no problems detected 311 0.818400025 11.9335003 311
( 100 %)
308
( 99 %)
Column 14 :
[ 14_LOTH1= Phosphate (mmol/m3) at 10m ]
no problems detected 286 0.316500008 1.29949999 286
( 100 %)
19
( 6 %)
Column 15 :
[ 15_LOTH1= Silicate (mmol/m3) at 10m ]
no problems detected 311 1.21500003 11.7049999 311
( 100 %)
311
( 100 %)
Column 16 :
[ 16_ABND2= Total Diatoms (#/L) at 10m ]
no problems detected 304 1600.00000 1007000.00 304
( 100 %)
304
( 100 %)
Column 17 :
[ 17_ABND2= Total Dinoflagellates (#/L) at 10m ]
no problems detected 304 100.000000 19200.0000 245
( 80 %)
245
( 80 %)
Column 18 :
[ 18_ABND2= Total Flagellates (#/L) at 10m ]
no problems detected 304 100.000000 30200.0000 169
( 55 %)
169
( 55 %)

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