COPEPODITE Incoming Data Review

Fatal Format Issues:   none



HEADER REVIEW SECTION
[
Jump back to TOP ]

SEQUENTIAL ORDERING OF ACTIVE DATA COLUMNS

    Column # 1     [ DATE-MDY ]       Date Set = 1
    Column # 2     [ABND= Total Copepods (#/m3)]      ( date set 1 )
    Column # 3     [ABND= Total Copepod Biomass (mg/m3)]      ( date set 1 )
    Column # 4     [CHLA= Total Chlorophyll (ug/L)]      ( date set 1 )
    Column # 5     [LOTH= PO4 (uM)]      ( date set 1 )
    Column # 6     [LOTH= SiO4 (uM)]      ( date set 1 )
    Column # 7     [LOTH= NO3 (uM)]      ( date set 1 )
    Column # 8     [LOTH= NO2 (uM)]      ( date set 1 )
    Column # 9     [LOTH= NH4 (uM)]      ( date set 1 )

    Column # 10     [ DATE-MDY ]       Date Set = 2
    Column # 11     [ABDT1= Total Copepod Biomass (mgC/m3)]      ( date set 2 )

    Column # 12     [ DATE-MDY ]       Date Set = 3
    Column # 13     [BIOM1= Total Copepod Biomass - all years (mgC/m3)]      ( date set 3 )

    Column # 14     [ DATE-MDY ]       Date Set = 4
    Column # 15     [ABDT1= Cold Neritic Copepod Biomass (mgC/m3)]      ( date set 4 )
    Column # 16     [ABDT1= Warm Neritic Copepod Biomass (mgC/m3)]      ( date set 4 )
    Column # 17     [ABDT1= Subarctic Copepod Biomass (mgC/m3)]      ( date set 4 )
    Column # 18     [ABDT1= Warm Ocean Copepod Biomass (mgC/m3)]      ( date set 4 )

    Column # 19     [ DATE-MDY ]       Date Set = 5
    Column # 20     [ABDT2= Total Copepod Abundance (#/m3)]      ( date set 5 )

    Column # 21     [ DATE-MDY ]       Date Set = 6
    Column # 22     [ABDT2= Cold Neritic Copepod Abundance (#/m3)]      ( date set 6 )
    Column # 23     [ABDT2= Warm Neritic Copepod Abundance (#/m3)]      ( date set 6 )
    Column # 24     [ABDT2= Subarctic Copepod Abundance (#/m3)]      ( date set 6 )
    Column # 25     [ABDT2= Warm Ocean Copepod Abundance (#/m3)]      ( date set 6 )

    Column # 26     [ DATE-MDY ]       Date Set = 7
    Column # 27     [CHLA= Total Chlorophyll (ug/L)]      ( date set 7 )
    Column # 28     [LOTH= PO4 (um)]      ( date set 7 )
    Column # 29     [LOTH= SiO4 (um)]      ( date set 7 )
    Column # 30     [LOTH= NO3 (um)]      ( date set 7 )
    Column # 31     [LOTH= NO2 (um)]      ( date set 7 )
    Column # 32     [LOTH= NH4 (um)]      ( date set 7 )

    Column # 33     [ DATE-MDY ]       Date Set = 8
    Column # 34     [TEMP= Temperature ( C ) at the surface]      ( date set 8 )
    Column # 35     [TEMP= Temperature ( C ) at 50 m]      ( date set 8 )
    Column # 36     [TEMP= Average Temperature ( C ) from 0-50 m]      ( date set 8 )
    Column # 37     [PSAL= Salinity () at the surface]      ( date set 8 )
    Column # 38     [PSAL= Salinity () at 50 m]      ( date set 8 )
    Column # 39     [PSAL= Average Salinity () from 0-50 m]      ( date set 8 )


DATA SORTED BY CATEGORY TYPES

    Total/non-zero Abundance Category
        Column # 2   [ ABND= Total Copepods (#/m3) ]
        Column # 3   [ ABND= Total Copepod Biomass (mg/m3) ]

    Abundance (with zeros) Category
        Column # 11   [ ABDT1= Total Copepod Biomass (mgC/m3) ]
        Column # 15   [ ABDT1= Cold Neritic Copepod Biomass (mgC/m3) ]
        Column # 16   [ ABDT1= Warm Neritic Copepod Biomass (mgC/m3) ]
        Column # 17   [ ABDT1= Subarctic Copepod Biomass (mgC/m3) ]
        Column # 18   [ ABDT1= Warm Ocean Copepod Biomass (mgC/m3) ]
        Column # 20   [ ABDT2= Total Copepod Abundance (#/m3) ]
        Column # 22   [ ABDT2= Cold Neritic Copepod Abundance (#/m3) ]
        Column # 23   [ ABDT2= Warm Neritic Copepod Abundance (#/m3) ]
        Column # 24   [ ABDT2= Subarctic Copepod Abundance (#/m3) ]
        Column # 25   [ ABDT2= Warm Ocean Copepod Abundance (#/m3) ]

    Temperatures Category
        Column # 34   [ TEMP= Temperature ( C ) at the surface ]
        Column # 35   [ TEMP= Temperature ( C ) at 50 m ]
        Column # 36   [ TEMP= Average Temperature ( C ) from 0-50 m ]

    Salinities Category
        Column # 37   [ PSAL= Salinity () at the surface ]
        Column # 38   [ PSAL= Salinity () at 50 m ]
        Column # 39   [ PSAL= Average Salinity () from 0-50 m ]

DATA SORTED BY GROUPING SETS:

    Category 8 Group # 1
        column # 11     [ ABDT1= Total Copepod Biomass (mgC/m3) ]
        column # 15     [ ABDT1= Cold Neritic Copepod Biomass (mgC/m3) ]
        column # 16     [ ABDT1= Warm Neritic Copepod Biomass (mgC/m3) ]
        column # 17     [ ABDT1= Subarctic Copepod Biomass (mgC/m3) ]
        column # 18     [ ABDT1= Warm Ocean Copepod Biomass (mgC/m3) ]

    Category 8 Group # 2
        column # 20     [ ABDT2= Total Copepod Abundance (#/m3) ]
        column # 22     [ ABDT2= Cold Neritic Copepod Abundance (#/m3) ]
        column # 23     [ ABDT2= Warm Neritic Copepod Abundance (#/m3) ]
        column # 24     [ ABDT2= Subarctic Copepod Abundance (#/m3) ]
        column # 25     [ ABDT2= Warm Ocean Copepod Abundance (#/m3) ]



DATE REVIEW SECTION
[
Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1996 2018
DATES in Column 10 no problems detected 1996 2012
DATES in Column 12 no problems detected 1969 2012
DATES in Column 14 no problems detected 1996 2012
DATES in Column 19 no problems detected 1996 2012
DATES in Column 21 no problems detected 1996 2012
DATES in Column 26 no problems detected 1996 2011
DATES in Column 33 no problems detected 1996 2012

 Date Column LabelingDate Value-Set1Date Value-Set2Date Value-Set3
DATE-column Date-Label AutoDetect match? SET1min SET1max SET2min SET2max SET3min SET3max
1 DATE-MDY DATE-MDY yes 1 12 1 31 1996 2018
10 DATE-MDY DATE-MDY yes 1 12 1 31 1996 2012
12 DATE-MDY DATE-MDY yes 1 12 1 31 1969 2012
14 DATE-MDY DATE-MDY yes 1 12 1 31 1996 2012
19 DATE-MDY DATE-MDY yes 1 12 1 31 1996 2012
21 DATE-MDY DATE-MDY yes 1 12 1 31 1996 2012
26 DATE-MDY DATE-MDY yes 01 12 01 31 1996 2011
33 DATE-MDY DATE-MDY yes 1 12 1 31 1996 2012



DATA REVIEW SECTION
[
Jump back to TOP ]



DATA COLUMN Comments"n" Minimum
(non-zero)
Maximum Values
> 0
Values
> 1
Column 2 :
[ 04_ABND= Total Copepods (#/m3) ]
no problems detected 583 140.796082 14784.9395 583
( 100 %)
583
( 100 %)
Column 3 :
[ 05_ABND= Total Copepod Biomass (mg/m3) ]
no problems detected 583 0.600000024 235.830002 583
( 100 %)
581
( 99 %)
Column 4 :
[ 06_CHLA= Total Chlorophyll (ug/L) ]
no problems detected 479 4.86159995E-02 39.3300018 479
( 100 %)
332
( 69 %)
Column 5 :
[ 07_LOTH= PO4 (uM) ]
no problems detected 465 1.40863995E-03 3.30900002 465
( 100 %)
125
( 26 %)
Column 6 :
[ 08_LOTH= SiO4 (uM) ]
no problems detected 464 0.123999998 56.5699997 458
( 98 %)
426
( 91 %)
Column 7 :
[ 09_LOTH= NO3 (uM) ]
no problems detected 452 -1.50000001E-03 32.5499992 434
( 96 %)
293
( 64 %)
Column 8 :
[ 10_LOTH= NO2 (uM) ]
no problems detected 452 8.99999985E-04 1.90310001 434
( 96 %)
1
( 0 %)
Column 9 :
[ 11_LOTH= NH4 (uM) ]
no problems detected 450 -3.99999990E-04 8.21090031 429
( 95 %)
74
( 16 %)
Column 11 :
[ 12_ABDT1= Total Copepod Biomass (mgC/m3) ]
no problems detected 447 0.499069989 89.0131378 447
( 100 %)
444
( 99 %)
Column 13 :
[ 13_BIOM1= Total Copepod Biomass - all years (mgC/m3) ]
no problems detected 523 0.259999990 314.514709 523
( 100 %)
517
( 98 %)
Column 15 :
[ 14_ABDT1= Cold Neritic Copepod Biomass (mgC/m3) ]
no problems detected 447 1.10099996E-02 88.2678833 445
( 99 %)
393
( 87 %)
Column 16 :
[ 15_ABDT1= Warm Neritic Copepod Biomass (mgC/m3) ]
no problems detected 447 1.75000005E-03 7.60377979 370
( 82 %)
71
( 15 %)
Column 17 :
[ 16_ABDT1= Subarctic Copepod Biomass (mgC/m3) ]
no problems detected 447 7.90000020E-04 4.50647020 328
( 73 %)
27
( 6 %)
Column 18 :
[ 17_ABDT1= Warm Ocean Copepod Biomass (mgC/m3) ]
no problems detected 447 1.32000004E-03 10.9246302 286
( 63 %)
62
( 13 %)
Column 20 :
[ 18_ABDT2= Total Copepod Abundance (#/m3) ]
no problems detected 447 140.800003 14784.9404 447
( 100 %)
447
( 100 %)
Column 22 :
[ 19_ABDT2= Cold Neritic Copepod Abundance (#/m3) ]
no problems detected 447 2.42000008 13898.4600 445
( 99 %)
445
( 99 %)
Column 23 :
[ 20_ABDT2= Warm Neritic Copepod Abundance (#/m3) ]
no problems detected 447 1.82000005 3302.31982 370
( 82 %)
370
( 82 %)
Column 24 :
[ 21_ABDT2= Subarctic Copepod Abundance (#/m3) ]
no problems detected 447 0.850000024 293.880005 328
( 73 %)
327
( 73 %)
Column 25 :
[ 22_ABDT2= Warm Ocean Copepod Abundance (#/m3) ]
no problems detected 447 1.54999995 709.810059 286
( 63 %)
286
( 63 %)
Column 27 :
[ 23_CHLA= Total Chlorophyll (ug/L) ]
no problems detected 373 4.86159995E-02 39.3300018 373
( 100 %)
276
( 73 %)
Column 28 :
[ 24_LOTH= PO4 (um) ]
no problems detected 351 1.40863995E-03 2.71138000 351
( 100 %)
112
( 31 %)
Column 29 :
[ 25_LOTH= SiO4 (um) ]
no problems detected 350 0.123999998 56.5699997 344
( 98 %)
323
( 92 %)
Column 30 :
[ 26_LOTH= NO3 (um) ]
no problems detected 339 8.66958033E-03 32.5499992 325
( 95 %)
220
( 64 %)
Column 31 :
[ 27_LOTH= NO2 (um) ]
no problems detected 338 8.99999985E-04 30.6984005 322
( 95 %)
11
( 3 %)
Column 32 :
[ 28_LOTH= NH4 (um) ]
no problems detected 335 3.00000003E-03 3.76500010 312
( 93 %)
62
( 18 %)
Column 34 :
[ 29_TEMP= Temperature ( C ) at the surface ]
no problems detected 382 7.94000006 18.2600002 382
( 100 %)
382
( 100 %)
Column 35 :
[ 30_TEMP= Temperature ( C ) at 50 m ]
no problems detected 385 6.90999985 12.9200001 385
( 100 %)
385
( 100 %)
Column 36 :
[ 31_TEMP= Average Temperature ( C ) from 0-50 m ]
no problems detected 409 7.34000015 13.6400003 409
( 100 %)
409
( 100 %)
Column 37 :
[ 32_PSAL= Salinity () at the surface ]
no problems detected 381 23.8500004 33.8899994 381
( 100 %)
381
( 100 %)
Column 38 :
[ 33_PSAL= Salinity () at 50 m ]
no problems detected 384 32.0400009 34.0299988 384
( 100 %)
384
( 100 %)
Column 39 :
[ 34_PSAL= Average Salinity () from 0-50 m ]
no problems detected 408 31.3700008 33.9399986 408
( 100 %)
408
( 100 %)

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