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-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 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_TEMP= Temperature ( C ) at 10 m ]
no problems detected 808 -1.55999994 21.0699997 768
( 95 %)
682
( 84 %)
Column 11 :
[ 11_PSAL= Salinity () at 10m ]
no problems detected 522 29.3600006 33.0600014 522
( 100 %)
522
( 100 %)
Column 12 :
[ 12_CHLA= Chlorophyll (ug/l) at 10m ]
no problems detected 463 9.72000044E-03 16.5594997 463
( 100 %)
94
( 20 %)
Column 13 :
[ 13_LOTH1= Nitrate (mmol/m3) at 10m ]
no problems detected 448 2.00000009E-03 7.90500021 362
( 80 %)
151
( 33 %)
Column 14 :
[ 14_LOTH1= Phosphate (mmol/m3) at 10m ]
no problems detected 446 6.40000030E-02 1.93350005 446
( 100 %)
2
( 0 %)
Column 15 :
[ 15_LOTH1= Silicate (mmol/m3) at 10m ]
no problems detected 447 4.99999989E-03 8.80500031 435
( 97 %)
225
( 50 %)
Column 16 :
[ 16_ABND2= Total Diatoms (#/L) at 10m ]
no problems detected 424 167.000000 1034400.00 423
( 99 %)
423
( 99 %)
Column 17 :
[ 17_ABND2= Total Dinoflagellates (#/L) at 10m ]
no problems detected 424 100.000000 126000.000 420
( 99 %)
420
( 99 %)
Column 18 :
[ 18_ABND2= Total Flagellates (#/L) at 10m ]
no problems detected 424 125.000000 161200.000 418
( 98 %)
418
( 98 %)

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