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 Copepods (#/m2)]      ( date set 1 )

    Column # 3     [ DATE-MDY ]       Date Set = 2
    Column # 4    [ABDT1= Calanus finmarchicus (#/m2)]      ( date set 2 )

    Column # 5     [ DATE-MDY ]       Date Set = 3
    Column # 6    [ABDT1= Calanus glacialis (#/m2)]      ( date set 3 )

    Column # 7     [ DATE-MDY ]       Date Set = 4
    Column # 8    [ABDT1= Calanus hyperboreus (#/m2)]      ( date set 4 )

    Column # 9     [ DATE-MDY ]       Date Set = 5
    Column # 10    [ABDT1= Pseudocalanus spp. (#/m2)]      ( date set 5 )

    Column # 11     [ DATE-MDY ]       Date Set = 6
    Column # 12    [ABDT= Temora sp. (#/m2)]      ( date set 6 )
    Column # 13    [ABDT= Temora longicornis (#/m2)]      ( date set 6 )
    Column # 14    [ABDT= Oithona spp. (#/m2)]      ( date set 6 )
    Column # 15    [ABDT= Oithona atlantica (#/m2)]      ( date set 6 )
    Column # 16    [ABDT= Oithona similis (#/m2)]      ( date set 6 )
    Column # 17    [ABDT= Centropages spp. (#/m2)]      ( date set 6 )
    Column # 18    [ABDT= Centropages hamatus (#/m2)]      ( date set 6 )
    Column # 19    [ABDT= Centropages typicus (#/m2)]      ( date set 6 )
    Column # 20    [ABDT= Metridia sp. (#/m2)]      ( date set 6 )
    Column # 21    [ABDT= Metridia longa (#/m2)]      ( date set 6 )
    Column # 22    [ABDT= Metridia lucens (#/m2)]      ( date set 6 )
    Column # 23    [ABDT= Pteropoda (#/m2)]      ( date set 6 )
    Column # 24    [ABDT= Hyperiid (#/m2)]      ( date set 6 )
    Column # 25    [ABDT= Euphausia (#/m2)]      ( date set 6 )
    Column # 26    [ABDT= Calanoid nauplii (#/m2)]      ( date set 6 )

    Column # 27     [ DATE-YMD ]       Date Set = 7
    Column # 28    [TEMP= Temperature (C) from 0-10m]      ( date set 7 )

    Column # 29     [ DATE-YMD ]       Date Set = 8
    Column # 30    [PSAL= Salinity () from 0-10m]      ( date set 8 )

    Column # 31     [ DATE-YMD ]       Date Set = 9
    Column # 32    [OTHR= Dissolved Oxygen (mmol/m3) from 0-10m]      ( date set 9 )

    Column # 33     [ DATE-YMD ]       Date Set = 10
    Column # 34    [LOTH= Phosphate (mmol/m3) from 0-10m]      ( date set 10 )

    Column # 35     [ DATE-YMD ]       Date Set = 11
    Column # 36    [LOTH= Silicate (mmol/m3) from 0-10m]      ( date set 11 )

    Column # 37     [ DATE-YMD ]       Date Set = 12
    Column # 38    [CHLA= Chlorophyll (ug/l) from 0-10m]      ( date set 12 )


DATA SORTED BY CATEGORY TYPES

    Abundance (with zeros) Category
        Column # 2   [ ABDT1= Total Copepods (#/m2) ]
        Column # 4   [ ABDT1= Calanus finmarchicus (#/m2) ]
        Column # 6   [ ABDT1= Calanus glacialis (#/m2) ]
        Column # 8   [ ABDT1= Calanus hyperboreus (#/m2) ]
        Column # 10   [ ABDT1= Pseudocalanus spp. (#/m2) ]
        Column # 12   [ ABDT= Temora sp. (#/m2) ]
        Column # 13   [ ABDT= Temora longicornis (#/m2) ]
        Column # 14   [ ABDT= Oithona spp. (#/m2) ]
        Column # 15   [ ABDT= Oithona atlantica (#/m2) ]
        Column # 16   [ ABDT= Oithona similis (#/m2) ]
        Column # 17   [ ABDT= Centropages spp. (#/m2) ]
        Column # 18   [ ABDT= Centropages hamatus (#/m2) ]
        Column # 19   [ ABDT= Centropages typicus (#/m2) ]
        Column # 20   [ ABDT= Metridia sp. (#/m2) ]
        Column # 21   [ ABDT= Metridia longa (#/m2) ]
        Column # 22   [ ABDT= Metridia lucens (#/m2) ]
        Column # 23   [ ABDT= Pteropoda (#/m2) ]
        Column # 24   [ ABDT= Hyperiid (#/m2) ]
        Column # 25   [ ABDT= Euphausia (#/m2) ]
        Column # 26   [ ABDT= Calanoid nauplii (#/m2) ]

    Log10 (logarithmic) Miscellaenous Category
        Column # 34   [ LOTH= Phosphate (mmol/m3) from 0-10m ]
        Column # 36   [ LOTH= Silicate (mmol/m3) from 0-10m ]

    non-Log10 (linear) Miscellaenous Category
        Column # 32   [ OTHR= Dissolved Oxygen (mmol/m3) from 0-10m ]

    Temperatures Category
        Column # 28   [ TEMP= Temperature (C) from 0-10m ]

    Salinities Category
        Column # 30   [ PSAL= Salinity () from 0-10m ]

    Chlorophyll/Pigments Category
        Column # 38   [ CHLA= Chlorophyll (ug/l) from 0-10m ]

DATA SORTED BY GROUPING SETS:

    Category 8 Group # 1
        column # 2     [ ABDT1= Total Copepods (#/m2) ]
        column # 4     [ ABDT1= Calanus finmarchicus (#/m2) ]
        column # 6     [ ABDT1= Calanus glacialis (#/m2) ]
        column # 8     [ ABDT1= Calanus hyperboreus (#/m2) ]
        column # 10     [ ABDT1= Pseudocalanus spp. (#/m2) ]



DATE REVIEW SECTION
[
Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1999 2015
DATES in Column 3 no problems detected 1999 2015
DATES in Column 5 no problems detected 1999 2015
DATES in Column 7 no problems detected 1999 2015
DATES in Column 9 no problems detected 1999 2015
DATES in Column 11 no problems detected 1999 2013
DATES in Column 27 no problems detected 2001 2016
DATES in Column 29 no problems detected 2001 2016
DATES in Column 31 no problems detected 2000 2010
DATES in Column 33 no problems detected 1999 2016
DATES in Column 35 no problems detected 1999 2016
DATES in Column 37 no problems detected 2000 2016

 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 2015 01 12 15 15
3 DATE-MDY DATE-MDY yes 1 12 1 31 1999 2015
5 DATE-MDY DATE-MDY yes 1 12 1 31 1999 2015
7 DATE-MDY DATE-MDY yes 1 12 1 31 1999 2015
9 DATE-MDY DATE-MDY yes 1 12 1 31 1999 2015
11 DATE-MDY DATE-MDY yes 1 12 1 31 1999 2013
27 DATE-YMD DATE-YMD yes 2001 2016 01 12 01 31
29 DATE-YMD DATE-YMD yes 2001 2016 01 12 01 31
31 DATE-YMD DATE-YMD yes 2000 2010 02 12 01 30
33 DATE-YMD DATE-YMD yes 1999 2016 01 12 01 31
35 DATE-YMD DATE-YMD yes 1999 2016 01 12 01 31
37 DATE-YMD DATE-YMD yes 2000 2016 01 12 01 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 Copepods (#/m2) ]
no problems detected 175 10449.7627 296745.969 175
( 100%)
175
( 100%)
Column 4 :
[ 05_ABDT1= Calanus finmarchicus (#/m2) ]
no problems detected 503 140.367996 142142.969 503
( 100%)
503
( 100%)
Column 6 :
[ 06_ABDT1= Calanus glacialis (#/m2) ]
no problems detected 357 9.05599976 67231.7422 357
( 100%)
357
( 100%)
Column 8 :
[ 07_ABDT1= Calanus hyperboreus (#/m2) ]
no problems detected 298 11.9991999 17387.5195 298
( 100%)
298
( 100%)
Column 10 :
[ 08_ABDT1= Pseudocalanus spp. (#/m2) ]
no problems detected 501 416.575989 652611.562 501
( 100%)
501
( 100%)
Column 12 :
[09_ABDT= Temora sp. (#/m2) ]
There is/are 2 count WARNING(S)!

Some of your values are zero or "one".

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")

  • 440 579.583984 579.583984 1
    ( 0%)
    1
    ( 0%)
    Column 13 :
    [ 10_ABDT= Temora longicornis (#/m2) ]
    no problems detected 440 144.895996 320220.156 348
    ( 79%)
    348
    ( 79%)
    Column 14 :
    [ 11_ABDT= Oithona spp. (#/m2) ]
    no problems detected 440 7534.5918 389480.438 105
    ( 23%)
    105
    ( 23%)
    Column 15 :
    [ 12_ABDT= Oithona atlantica (#/m2) ]
    no problems detected 440 144.895996 122871.805 103
    ( 23%)
    103
    ( 23%)
    Column 16 :
    [ 13_ABDT= Oithona similis (#/m2) ]
    no problems detected 440 579.583984 1033977.88 438
    ( 99%)
    438
    ( 99%)
    Column 17 :
    [ 14_ABDT= Centropages spp. (#/m2) ]
    no problems detected 440 289.791992 30138.3672 66
    ( 15%)
    66
    ( 15%)
    Column 18 :
    [ 15_ABDT= Centropages hamatus (#/m2) ]
    no problems detected 440 144.895996 5795.83984 67
    ( 15%)
    67
    ( 15%)
    Column 19 :
    [ 16_ABDT= Centropages typicus (#/m2) ]
    no problems detected 440 144.895996 41730.0469 23
    ( 5%)
    23
    ( 5%)
    Column 20 :
    [ 17_ABDT= Metridia sp. (#/m2) ]
    no problems detected 440 18.1119995 111280.125 317
    ( 72%)
    317
    ( 72%)
    Column 21 :
    [ 18_ABDT= Metridia longa (#/m2) ]
    no problems detected 440 18.1119995 15069.1836 137
    ( 31%)
    137
    ( 31%)
    Column 22 :
    [19_ABDT= Metridia lucens (#/m2) ]
    There is/are 2 count WARNING(S)!

    Some of your values are zero or "one".

    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")

  • 440 289.791992 289.791992 1
    ( 0%)
    1
    ( 0%)
    Column 23 :
    [ 20_ABDT= Pteropoda (#/m2) ]
    no problems detected 440 144.895996 69550.0781 420
    ( 95%)
    420
    ( 95%)
    Column 24 :
    [ 21_ABDT= Hyperiid (#/m2) ]
    no problems detected 440 2.26399994 1159.16797 67
    ( 15%)
    67
    ( 15%)
    Column 25 :
    [ 22_ABDT= Euphausia (#/m2) ]
    no problems detected 440 2.26399994 10432.5117 97
    ( 22%)
    97
    ( 22%)
    Column 26 :
    [ 23_ABDT= Calanoid nauplii (#/m2) ]
    no problems detected 440 18.1119995 185466.875 394
    ( 89%)
    394
    ( 89%)
    Column 28 :
    [ 24_TEMP= Temperature (C) from 0-10m ]
    no problems detected 980 -1.77999997 16.8700008 842
    ( 85%)
    751
    ( 76%)
    Column 30 :
    [ 25_PSAL= Salinity () from 0-10m ]
    no problems detected 1250 30.5879993 34.901001 1250
    ( 100%)
    1250
    ( 100%)
    Column 32 :
    [ 26_OTHR= Dissolved Oxygen (mmol/m3) from 0-10m ]
    no problems detected 268 233.100006 464.013214 268
    ( 100%)
    268
    ( 100%)
    Column 34 :
    [ 27_LOTH= Phosphate (mmol/m3) from 0-10m ]
    no problems detected 818 0.0199999996 1.96000004 808
    ( 98%)
    32
    ( 3%)
    Column 36 :
    [ 28_LOTH= Silicate (mmol/m3) from 0-10m ]
    no problems detected 839 0.00999999978 7.34000015 765
    ( 91%)
    519
    ( 61%)
    Column 38 :
    [ 29_CHLA= Chlorophyll (ug/l) from 0-10m ]
    no problems detected 759 0.00999999978 10.1400003 757
    ( 99%)
    177
    ( 23%)

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