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 Copepoda (#/m3)]      ( date set 1 )
    Column # 3    [ABDT1= Total Rotifera (#/m3)]      ( date set 1 )
    Column # 4    [ABDT1= Total Cirripedia (#/m3)]      ( date set 1 )
    Column # 5    [ABDT1= Total Euphausiacea (#/m3)]      ( date set 1 )
    Column # 6    [ABDT1= Total Polychaeta (#/m3)]      ( date set 1 )
    Column # 7    [ABDT1= Total Gastropoda (#/m3)]      ( date set 1 )
    Column # 8    [ABDT1= Total Bivalvia (#/m3)]      ( date set 1 )
    Column # 9    [ABDT1= Total Chaetognatha (#/m3)]      ( date set 1 )
    Column # 10    [ABDT1= Total Echinodermata (#/m3)]      ( date set 1 )
    Column # 11    [ABDT1= Total Appendicularia (#/m3)]      ( date set 1 )
    Column # 12    [ABDT2= Total Copepoda (#/m3)]      ( date set 1 )
    Column # 13    [ABDT2= Acartia spp. (#/m3)]      ( date set 1 )
    Column # 14    [ABDT2= Calanus spp. (#/m3)]      ( date set 1 )
    Column # 15    [ABDT2= Centropages spp. (#/m3)]      ( date set 1 )
    Column # 16    [ABDT2= Microsetella spp. (#/m3)]      ( date set 1 )
    Column # 17    [ABDT2= Oithona spp. (#/m3)]      ( date set 1 )
    Column # 18    [ABDT2= Paracalanus spp. (#/m3)]      ( date set 1 )
    Column # 19    [ABDT2= Temora spp. (#/m3)]      ( date set 1 )
    Column # 20    [ABDT2= Other copepoda (#/m3)]      ( date set 1 )

    Column # 21     [ DATE-YMD ]       Date Set = 2
    Column # 22    [ABDT1= Total Diatoms (#/L)]      ( date set 2 )
    Column # 23    [ABDT1= Total Dinoflagellates (#/L)]      ( date set 2 )
    Column # 24    [ABDT1= Total Cyanobacteria (#/L)]      ( date set 2 )
    Column # 25    [ABDT1= Total Coccolithophorids (#/L)]      ( date set 2 )
    Column # 26    [ABDT1= Total Ciliphora (#/L)]      ( date set 2 )
    Column # 27    [ABDT1= Total Cryptomonads (#/L)]      ( date set 2 )
    Column # 28    [ABDT1= Total Chrysomonads (#/L)]      ( date set 2 )
    Column # 29    [ABDT1= Total Euglenophyta (#/L)]      ( date set 2 )

    Column # 30     [ DATE-YMD ]       Date Set = 3
    Column # 31    [TEMP= Temperature (C)]      ( date set 3 )
    Column # 32    [PSAL= Salinity (pss)]      ( date set 3 )
    Column # 33    [OTHR= pH ()]      ( date set 3 )
    Column # 34    [OTHR= Oxygen (ml/l)]      ( date set 3 )
    Column # 35    [OTHR= OxygenSat (%)]      ( date set 3 )
    Column # 36    [LOTH= Po4-P (uM)]      ( date set 3 )
    Column # 37    [LOTH= Tot-P (uM)]      ( date set 3 )
    Column # 38    [LOTH= NO2-N (uM)]      ( date set 3 )
    Column # 39    [LOTH= NO3-N (uM)]      ( date set 3 )
    Column # 40    [LOTH= NH4-N (uM)]      ( date set 3 )
    Column # 41    [LOTH= Tot-N (uM)]      ( date set 3 )
    Column # 42    [LOTH= SiO3-Si (uM)]      ( date set 3 )
    Column # 43    [CHLA= Chlorophyll (ug/l)]      ( date set 3 )


DATA SORTED BY CATEGORY TYPES

    Abundance (with zeros) Category
        Column # 2   [ ABDT1= Total Copepoda (#/m3) ]
        Column # 3   [ ABDT1= Total Rotifera (#/m3) ]
        Column # 4   [ ABDT1= Total Cirripedia (#/m3) ]
        Column # 5   [ ABDT1= Total Euphausiacea (#/m3) ]
        Column # 6   [ ABDT1= Total Polychaeta (#/m3) ]
        Column # 7   [ ABDT1= Total Gastropoda (#/m3) ]
        Column # 8   [ ABDT1= Total Bivalvia (#/m3) ]
        Column # 9   [ ABDT1= Total Chaetognatha (#/m3) ]
        Column # 10   [ ABDT1= Total Echinodermata (#/m3) ]
        Column # 11   [ ABDT1= Total Appendicularia (#/m3) ]
        Column # 12   [ ABDT2= Total Copepoda (#/m3) ]
        Column # 13   [ ABDT2= Acartia spp. (#/m3) ]
        Column # 14   [ ABDT2= Calanus spp. (#/m3) ]
        Column # 15   [ ABDT2= Centropages spp. (#/m3) ]
        Column # 16   [ ABDT2= Microsetella spp. (#/m3) ]
        Column # 17   [ ABDT2= Oithona spp. (#/m3) ]
        Column # 18   [ ABDT2= Paracalanus spp. (#/m3) ]
        Column # 19   [ ABDT2= Temora spp. (#/m3) ]
        Column # 20   [ ABDT2= Other copepoda (#/m3) ]
        Column # 22   [ ABDT1= Total Diatoms (#/L) ]
        Column # 23   [ ABDT1= Total Dinoflagellates (#/L) ]
        Column # 24   [ ABDT1= Total Cyanobacteria (#/L) ]
        Column # 25   [ ABDT1= Total Coccolithophorids (#/L) ]
        Column # 26   [ ABDT1= Total Ciliphora (#/L) ]
        Column # 27   [ ABDT1= Total Cryptomonads (#/L) ]
        Column # 28   [ ABDT1= Total Chrysomonads (#/L) ]
        Column # 29   [ ABDT1= Total Euglenophyta (#/L) ]

    Log10 (logarithmic) Miscellaenous Category
        Column # 36   [ LOTH= Po4-P (uM) ]
        Column # 37   [ LOTH= Tot-P (uM) ]
        Column # 38   [ LOTH= NO2-N (uM) ]
        Column # 39   [ LOTH= NO3-N (uM) ]
        Column # 40   [ LOTH= NH4-N (uM) ]
        Column # 41   [ LOTH= Tot-N (uM) ]
        Column # 42   [ LOTH= SiO3-Si (uM) ]

    non-Log10 (linear) Miscellaenous Category
        Column # 33   [ OTHR= pH () ]
        Column # 34   [ OTHR= Oxygen (ml/l) ]
        Column # 35   [ OTHR= OxygenSat (%) ]

    Temperatures Category
        Column # 31   [ TEMP= Temperature (C) ]

    Salinities Category
        Column # 32   [ PSAL= Salinity (pss) ]

    Chlorophyll/Pigments Category
        Column # 43   [ CHLA= Chlorophyll (ug/l) ]

DATA SORTED BY GROUPING SETS:

    Category 8 Group # 1
        column # 2     [ ABDT1= Total Copepoda (#/m3) ]
        column # 3     [ ABDT1= Total Rotifera (#/m3) ]
        column # 4     [ ABDT1= Total Cirripedia (#/m3) ]
        column # 5     [ ABDT1= Total Euphausiacea (#/m3) ]
        column # 6     [ ABDT1= Total Polychaeta (#/m3) ]
        column # 7     [ ABDT1= Total Gastropoda (#/m3) ]
        column # 8     [ ABDT1= Total Bivalvia (#/m3) ]
        column # 9     [ ABDT1= Total Chaetognatha (#/m3) ]
        column # 10     [ ABDT1= Total Echinodermata (#/m3) ]
        column # 11     [ ABDT1= Total Appendicularia (#/m3) ]
        column # 22     [ ABDT1= Total Diatoms (#/L) ]
        column # 23     [ ABDT1= Total Dinoflagellates (#/L) ]
        column # 24     [ ABDT1= Total Cyanobacteria (#/L) ]
        column # 25     [ ABDT1= Total Coccolithophorids (#/L) ]
        column # 26     [ ABDT1= Total Ciliphora (#/L) ]
        column # 27     [ ABDT1= Total Cryptomonads (#/L) ]
        column # 28     [ ABDT1= Total Chrysomonads (#/L) ]
        column # 29     [ ABDT1= Total Euglenophyta (#/L) ]

    Category 8 Group # 2
        column # 12     [ ABDT2= Total Copepoda (#/m3) ]
        column # 13     [ ABDT2= Acartia spp. (#/m3) ]
        column # 14     [ ABDT2= Calanus spp. (#/m3) ]
        column # 15     [ ABDT2= Centropages spp. (#/m3) ]
        column # 16     [ ABDT2= Microsetella spp. (#/m3) ]
        column # 17     [ ABDT2= Oithona spp. (#/m3) ]
        column # 18     [ ABDT2= Paracalanus spp. (#/m3) ]
        column # 19     [ ABDT2= Temora spp. (#/m3) ]
        column # 20     [ ABDT2= Other copepoda (#/m3) ]



DATE REVIEW SECTION
[
Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 2007 2011
DATES in Column 21 no problems detected 2002 2010
DATES in Column 30 no problems detected 2001 2012

 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 2007 2011 01 12 06 31
21 DATE-YMD DATE-YMD yes 2002 2010 01 12 03 31
30 DATE-YMD DATE-YMD yes 2001 2012 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_ABDT1= Total Copepoda (#/m3) ]
no problems detected 36 59.6800003 106055.672 36
( 100%)
36
( 100%)
Column 3 :
[ 05_ABDT1= Total Rotifera (#/m3) ]
no problems detected 36 0.639999986 5570.56006 9
( 25%)
8
( 22%)
Column 4 :
[ 06_ABDT1= Total Cirripedia (#/m3) ]
no problems detected 36 0.639999986 163.839996 7
( 19%)
6
( 16%)
Column 5 :
[ 07_ABDT1= Total Euphausiacea (#/m3) ]
no problems detected 36 0.479999989 163.839996 13
( 36%)
11
( 30%)
Column 6 :
[ 08_ABDT1= Total Polychaeta (#/m3) ]
no problems detected 36 0.639999986 2785.28003 20
( 55%)
19
( 52%)
Column 7 :
[ 09_ABDT1= Total Gastropoda (#/m3) ]
no problems detected 36 5.11999989 23592.9609 31
( 86%)
31
( 86%)
Column 8 :
[ 10_ABDT1= Total Bivalvia (#/m3) ]
no problems detected 36 5.11999989 23592.9609 31
( 86%)
31
( 86%)
Column 9 :
[ 11_ABDT1= Total Chaetognatha (#/m3) ]
no problems detected 36 0.159999996 43.5200005 15
( 41%)
12
( 33%)
Column 10 :
[ 12_ABDT1= Total Echinodermata (#/m3) ]
no problems detected 36 2.55999994 5898.24023 24
( 66%)
24
( 66%)
Column 11 :
[ 13_ABDT1= Total Appendicularia (#/m3) ]
no problems detected 36 0.639999986 983.039978 26
( 72%)
25
( 69%)
Column 12 :
[ 14_ABDT2= Total Copepoda (#/m3) ]
no problems detected 36 59.6800003 106055.672 36
( 100%)
36
( 100%)
Column 13 :
[ 15_ABDT2= Acartia spp. (#/m3) ]
no problems detected 36 0.959999979 3932.15991 32
( 88%)
31
( 86%)
Column 14 :
[ 16_ABDT2= Calanus spp. (#/m3) ]
no problems detected 36 5.11999989 6225.91992 35
( 97%)
35
( 97%)
Column 15 :
[ 17_ABDT2= Centropages spp. (#/m3) ]
no problems detected 36 0.479999989 3461.11987 32
( 88%)
31
( 86%)
Column 16 :
[ 18_ABDT2= Microsetella spp. (#/m3) ]
no problems detected 36 0.639999986 1310.71997 24
( 66%)
23
( 63%)
Column 17 :
[ 19_ABDT2= Oithona spp. (#/m3) ]
no problems detected 36 18.0799999 93716.4766 35
( 97%)
35
( 97%)
Column 18 :
[ 20_ABDT2= Paracalanus spp. (#/m3) ]
no problems detected 36 3.83999991 21135.3594 34
( 94%)
34
( 94%)
Column 19 :
[ 21_ABDT2= Temora spp. (#/m3) ]
no problems detected 36 0.159999996 1310.71997 25
( 69%)
24
( 66%)
Column 20 :
[ 22_ABDT2= Other copepoda (#/m3) ]
no problems detected 36 12.96 2621.43994 35
( 97%)
35
( 97%)
Column 22 :
[ 23_ABDT1= Total Diatoms (#/L) ]
no problems detected 85 50. 5147470. 83
( 97%)
83
( 97%)
Column 23 :
[ 24_ABDT1= Total Dinoflagellates (#/L) ]
no problems detected 85 102. 286320. 85
( 100%)
85
( 100%)
Column 24 :
[ 25_ABDT1= Total Cyanobacteria (#/L) ]
no problems detected 85 250. 6809400. 9
( 10%)
9
( 10%)
Column 25 :
[ 26_ABDT1= Total Coccolithophorids (#/L) ]
no problems detected 85 1778. 372827. 39
( 45%)
39
( 45%)
Column 26 :
[ 27_ABDT1= Total Ciliphora (#/L) ]
no problems detected 85 50. 15299. 83
( 97%)
83
( 97%)
Column 27 :
[ 28_ABDT1= Total Cryptomonads (#/L) ]
no problems detected 85 1805. 1178620. 81
( 95%)
81
( 95%)
Column 28 :
[ 29_ABDT1= Total Chrysomonads (#/L) ]
no problems detected 85 50. 176171. 44
( 51%)
44
( 51%)
Column 29 :
[ 30_ABDT1= Total Euglenophyta (#/L) ]
no problems detected 85 50. 12291. 9
( 10%)
9
( 10%)
Column 31 :
[ 31_TEMP= Temperature (C) ]
no problems detected 138 -1.05999994 20.7800007 136
( 98%)
136
( 98%)
Column 32 :
[ 32_PSAL= Salinity (pss) ]
no problems detected 134 15.9219999 34.2820015 134
( 100%)
134
( 100%)
Column 33 :
[ 33_OTHR= pH () ]
no problems detected 62 8.10999966 8.46000004 62
( 100%)
62
( 100%)
Column 34 :
[ 34_OTHR= Oxygen (ml/l) ]
no problems detected 137 5.46999979 9.53999996 137
( 100%)
137
( 100%)
Column 35 :
[ 35_OTHR= OxygenSat (%) ]
no problems detected 131 96. 114. 131
( 100%)
131
( 100%)
Column 36 :
[ 36_LOTH= Po4-P (uM) ]
no problems detected 139 0.0199999996 0.579999983 139
( 100%)
0
( 0%)
Column 37 :
[ 37_LOTH= Tot-P (uM) ]
no problems detected 135 0.129999995 1.08000004 135
( 100%)
1
( 0%)
Column 38 :
[ 38_LOTH= NO2-N (uM) ]
no problems detected 139 0.0199999996 1.35000002 139
( 100%)
1
( 0%)
Column 39 :
[ 39_LOTH= NO3-N (uM) ]
no problems detected 139 0.100000001 9.15999985 139
( 100%)
45
( 32%)
Column 40 :
[ 40_LOTH= NH4-N (uM) ]
no problems detected 135 0.0500000007 1.37 135
( 100%)
2
( 1%)
Column 41 :
[ 41_LOTH= Tot-N (uM) ]
no problems detected 135 6.9000001 22.2999992 135
( 100%)
135
( 100%)
Column 42 :
[ 42_LOTH= SiO3-Si (uM) ]
no problems detected 139 0.100000001 8.39999962 139
( 100%)
66
( 47%)
Column 43 :
[ 43_CHLA= Chlorophyll (ug/l) ]
no problems detected 139 0.100000001 19.8999996 139
( 100%)
52
( 37%)

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