COPEPODITE Incoming Data Review

Fatal Format Issues:   none


    Mild Data Warnings (non-numeric values):   2    [ 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    [ABDT1= Total Small Copepods (#/m3)]      ( date set 1 )
    Column # 3    [ABDT1= Total Small Calanoid Copepods (#/m3)]      ( date set 1 )
    Column # 4    [ABDT1= Acartia spp (#/m3)]      ( date set 1 )
    Column # 5    [ABDT1= Centropages spp (#/m3)]      ( date set 1 )
    Column # 6    [ABDT1= Pseudo-/Paracalanus spp (#/m3)]      ( date set 1 )
    Column # 7    [ABDT1= Temora longicornis (#/m3)]      ( date set 1 )
    Column # 8    [ABDT1= Oithona spp (#/m3)]      ( date set 1 )

    Column # 9     [ DATE-YMD ]       Date Set = 2
    Column # 10    [ABDT1= Acartia spp. (#/m3)]      ( date set 2 )
    Column # 11    [ABDT1= Paracalanus and Pseudocalanus (#/m3)]      ( date set 2 )
    Column # 12    [ABDT1= Temora longicornis (#/m3)]      ( date set 2 )

    Column # 13     [ DATE-YMD ]       Date Set = 3
    Column # 14    [ABDT1= Oithona spp. (#/m3)]      ( date set 3 )

    Column # 15     [ DATE-MDY ]       Date Set = 4
    Column # 16    [ABDT= Total Bacillariophyceae (#/l)]      ( date set 4 )
    Column # 17    [ABDT= Total Dinophyceae (#/l)]      ( date set 4 )

    Column # 18     [ DATE-MDY ]       Date Set = 5
    Column # 19    [TEMP= Temperature (C)]      ( date set 5 )
    Column # 20    [PSAL= Salinity ()]      ( date set 5 )
    Column # 21    [LOTH3= Phosphate (uMol/l)]      ( date set 5 )
    Column # 22    [LOTH3= Silicate (uMol/l)]      ( date set 5 )
    Column # 23    [LOTH3= Nitrate (uMol/l)]      ( date set 5 )
    Column # 24    [LOTH3= Nitrite (uMol/l)]      ( date set 5 )
    Column # 25    [LOTH3= NO3+NO2 (uMol/l)]      ( date set 5 )
    Column # 26    [LOTH3= Ammonium (uMol/l)]      ( date set 5 )
    Column # 27    [LOTH3= Dissolved Inorganic Nitrogen (uMol/l)]      ( date set 5 )


DATA SORTED BY CATEGORY TYPES

    Abundance (with zeros) Category
        Column # 2   [ ABDT1= Total Small Copepods (#/m3) ]
        Column # 3   [ ABDT1= Total Small Calanoid Copepods (#/m3) ]
        Column # 4   [ ABDT1= Acartia spp (#/m3) ]
        Column # 5   [ ABDT1= Centropages spp (#/m3) ]
        Column # 6   [ ABDT1= Pseudo-/Paracalanus spp (#/m3) ]
        Column # 7   [ ABDT1= Temora longicornis (#/m3) ]
        Column # 8   [ ABDT1= Oithona spp (#/m3) ]
        Column # 10   [ ABDT1= Acartia spp. (#/m3) ]
        Column # 11   [ ABDT1= Paracalanus and Pseudocalanus (#/m3) ]
        Column # 12   [ ABDT1= Temora longicornis (#/m3) ]
        Column # 14   [ ABDT1= Oithona spp. (#/m3) ]
        Column # 16   [ ABDT= Total Bacillariophyceae (#/l) ]
        Column # 17   [ ABDT= Total Dinophyceae (#/l) ]

    Log10 (logarithmic) Miscellaenous Category
        Column # 21   [ LOTH3= Phosphate (uMol/l) ]
        Column # 22   [ LOTH3= Silicate (uMol/l) ]
        Column # 23   [ LOTH3= Nitrate (uMol/l) ]
        Column # 24   [ LOTH3= Nitrite (uMol/l) ]
        Column # 25   [ LOTH3= NO3+NO2 (uMol/l) ]
        Column # 26   [ LOTH3= Ammonium (uMol/l) ]
        Column # 27   [ LOTH3= Dissolved Inorganic Nitrogen (uMol/l) ]

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

    Salinities Category
        Column # 20   [ PSAL= Salinity () ]

DATA SORTED BY GROUPING SETS:

    Category 8 Group # 1
        column # 2     [ ABDT1= Total Small Copepods (#/m3) ]
        column # 3     [ ABDT1= Total Small Calanoid Copepods (#/m3) ]
        column # 4     [ ABDT1= Acartia spp (#/m3) ]
        column # 5     [ ABDT1= Centropages spp (#/m3) ]
        column # 6     [ ABDT1= Pseudo-/Paracalanus spp (#/m3) ]
        column # 7     [ ABDT1= Temora longicornis (#/m3) ]
        column # 8     [ ABDT1= Oithona spp (#/m3) ]
        column # 10     [ ABDT1= Acartia spp. (#/m3) ]
        column # 11     [ ABDT1= Paracalanus and Pseudocalanus (#/m3) ]
        column # 12     [ ABDT1= Temora longicornis (#/m3) ]
        column # 14     [ ABDT1= Oithona spp. (#/m3) ]

    Category 9 Group # 3
        column # 21     [ LOTH3= Phosphate (uMol/l) ]
        column # 22     [ LOTH3= Silicate (uMol/l) ]
        column # 23     [ LOTH3= Nitrate (uMol/l) ]
        column # 24     [ LOTH3= Nitrite (uMol/l) ]
        column # 25     [ LOTH3= NO3+NO2 (uMol/l) ]
        column # 26     [ LOTH3= Ammonium (uMol/l) ]
        column # 27     [ LOTH3= Dissolved Inorganic Nitrogen (uMol/l) ]



DATE REVIEW SECTION
[
Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1974 2018
DATES in Column 9 no problems detected 1975 2016
DATES in Column 13 no problems detected 1975 2016
DATES in Column 15 no problems detected 1962 2015
DATES in Column 18 no problems detected 1962 2015

 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 1974 2018 01 12 01 31
9 DATE-YMD DATE-YMD yes 1975 2016 Apr 12 01 31
13 DATE-YMD DATE-YMD yes 1975 2016 Apr 12 1 31
15 DATE-MDY DATE-MDY yes 1 12 1 31 1962 2015
18 DATE-MDY DATE-MDY yes 1 12 1 31 1962 2015



DATA REVIEW SECTION
[
Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)
Maximum Values
> 0
Values
> 1
Column 2 :
[ 04_ABDT1= Total Small Copepods (#/m3) ]
no problems detected 5776 3.16000009 143576.188 5773
( 99%)
5773
( 99%)
Column 3 :
[ 05_ABDT1= Total Small Calanoid Copepods (#/m3) ]
no problems detected 5776 2.28999996 143576.188 5772
( 99%)
5772
( 99%)
Column 4 :
[ 06_ABDT1= Acartia spp (#/m3) ]
no problems detected 5776 0.790000021 44156.7305 5718
( 98%)
5715
( 98%)
Column 5 :
[ 07_ABDT1= Centropages spp (#/m3) ]
no problems detected 5776 0.330000013 13820.9697 4450
( 77%)
4418
( 76%)
Column 6 :
[ 08_ABDT1= Pseudo-/Paracalanus spp (#/m3) ]
no problems detected 5776 0.479999989 67950.8203 5750
( 99%)
5748
( 99%)
Column 7 :
[ 09_ABDT1= Temora longicornis (#/m3) ]
no problems detected 5776 0.5 104676.859 5588
( 96%)
5579
( 96%)
Column 8 :
[ 10_ABDT1= Oithona spp (#/m3) ]
no problems detected 5776 0.100000001 11883.4199 4839
( 83%)
4824
( 83%)
Column 10 :
[ 11_ABDT1= Acartia spp. (#/m3) ]
no problems detected 2260 0.189999998 32749.666 2248
( 99%)
2246
( 99%)
Column 11 :
[ 12_ABDT1= Paracalanus and Pseudocalanus (#/m3) ]
no problems detected 2260 0.25999999 35313. 2252
( 99%)
2251
( 99%)
Column 12 :
[ 13_ABDT1= Temora longicornis (#/m3) ]
no problems detected 2260 0.0299999993 29013. 2188
( 96%)
2181
( 96%)
Column 14 :
[ 14_ABDT1= Oithona spp. (#/m3) ]
no problems detected 2260 0.200000003 10687. 2072
( 91%)
2040
( 90%)
Column 16 :
[ 15_ABDT= Total Bacillariophyceae (#/l) ]
no problems detected 11604 40. 14611230. 11336
( 97%)
11336
( 97%)
Column 17 :
[ 16_ABDT= Total Dinophyceae (#/l) ]
no problems detected 11604 40. 4045840. 10819
( 93%)
10819
( 93%)
Column 19 :
[ 17_TEMP= Temperature (C) ]
no problems detected 13089 -1.60000002 20.2000008 13060
( 99%)
12945
( 98%)
Column 20 :
[ 18_PSAL= Salinity () ]
no problems detected 12697 22.7450008 36.105999 12697
( 100%)
12697
( 100%)
Column 21 :
[ 19_LOTH3= Phosphate (uMol/l) ]
no problems detected 11509 -0.189999998 8.07999992 11459
( 99%)
2368
( 20%)
Column 22 :
[20_LOTH3= Silicate (uMol/l) ]
There is/are 2 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")

  • 10855 0.00499999989 44.5499992 10848
    ( 99%)
    9830
    ( 90%)
    Column 23 :
    [ 21_LOTH3= Nitrate (uMol/l) ]
    no problems detected 11543 0.00999999978 138.199997 11543
    ( 100%)
    11023
    ( 95%)
    Column 24 :
    [ 22_LOTH3= Nitrite (uMol/l) ]
    no problems detected 11618 -0.0299999993 6.30000019 11601
    ( 99%)
    3016
    ( 25%)
    Column 25 :
    [ 23_LOTH3= NO3+NO2 (uMol/l) ]
    no problems detected 11601 0.00499999989 139.220001 11601
    ( 100%)
    11172
    ( 96%)
    Column 26 :
    [ 24_LOTH3= Ammonium (uMol/l) ]
    no problems detected 11548 -0.100000001 32.0999985 11520
    ( 99%)
    9557
    ( 82%)
    Column 27 :
    [ 25_LOTH3= Dissolved Inorganic Nitrogen (uMol/l) ]
    no problems detected 11520 0.00999999978 143.860001 11520
    ( 100%)
    11411
    ( 99%)

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