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     [CHLA= Average Chlorophyll (ug/l) from 0-10m]      ( date set 1 )
    Column # 3     [CHLA= Average Chlorophyll (ug/l) from 10-30m]      ( date set 1 )

    Column # 4     [ DATE-YMD ]       Date Set = 2
    Column # 5     [LOTH= Average TSS (mg/l) from 0-10m]      ( date set 2 )
    Column # 6     [LOTH= Average TSS (mg/l) from 10-50m]      ( date set 2 )
    Column # 7     [LOTH= Average PIM (mg/l) from 0-10m]      ( date set 2 )
    Column # 8     [LOTH= Average PIM (mg/l) from 10-50m]      ( date set 2 )
    Column # 9     [LOTH= Average POM (mg/l) from 0-10m]      ( date set 2 )
    Column # 10     [LOTH= Average POM (mg/l) from 10-50m]      ( date set 2 )
    Column # 11     [OTHR= Average POM (%) from 0-10m]      ( date set 2 )
    Column # 12     [OTHR= Average POM (%) from 10-50m]      ( date set 2 )

    Column # 13     [ DATE-YMD ]       Date Set = 3
    Column # 14     [TEMP= Average Temperature (C) from 0-10m]      ( date set 3 )
    Column # 15     [TEMP= Average Temperature (C) from 10-50m]      ( date set 3 )
    Column # 16     [PSAL= Average Salinity () from 0-10m]      ( date set 3 )
    Column # 17     [PSAL= Average Salinity () from 10-50m]      ( date set 3 )


DATA SORTED BY CATEGORY TYPES

    non-Log10 (linear) Miscellaenous Category
        Column # 11   [ OTHR= Average POM (%) from 0-10m ]
        Column # 12   [ OTHR= Average POM (%) from 10-50m ]

    Temperatures Category
        Column # 14   [ TEMP= Average Temperature (C) from 0-10m ]
        Column # 15   [ TEMP= Average Temperature (C) from 10-50m ]

    Salinities Category
        Column # 16   [ PSAL= Average Salinity () from 0-10m ]
        Column # 17   [ PSAL= Average Salinity () from 10-50m ]



DATE REVIEW SECTION
[ Jump back to TOP ]

DATE COLUMNCommentsMinimum YearMaximum Year
DATES in Column 1 no problems detected 1991 2010
DATES in Column 4 no problems detected 1992 2010
DATES in Column 13 no problems detected 1991 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 1991 2010 01 12 01 31
4 DATE-YMD DATE-YMD yes 1992 2010 01 12 01 31
13 DATE-YMD DATE-YMD yes 1991 2012 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_CHLA= Average Chlorophyll (ug/l) from 0-10m ] 		no problems detected 581 5.99999987E-02 9.88000011 551
( 94 %)		 154
( 26 %)
Column 3 :
[ 05_CHLA= Average Chlorophyll (ug/l) from 10-30m ] 		no problems detected 382 5.00000007E-02 10.0100002 356
( 93 %)		 103
( 26 %)
Column 5 :
[ 06_LOTH= Average TSS (mg/l) from 0-10m ] 		no problems detected 483 4.99999989E-03 156.000000 481
( 99 %)		 440
( 91 %)
Column 6 :
[ 07_LOTH= Average TSS (mg/l) from 10-50m ] 		no problems detected 321 4.00000019E-03 146.000000 319
( 99 %)		 285
( 88 %)
Column 7 :
[ 08_LOTH= Average PIM (mg/l) from 0-10m ] 		no problems detected 483 1.99999996E-02 126.000000 473
( 97 %)		 382
( 79 %)
Column 8 :
[ 09_LOTH= Average PIM (mg/l) from 10-50m ] 		no problems detected 321 9.99999978E-03 116.000000 316
( 98 %)		 245
( 76 %)
Column 9 :
[ 10_LOTH= Average POM (mg/l) from 0-10m ] 		no problems detected 483 -0.400000006 750.000000 476
( 98 %)		 284
( 58 %)
Column 10 :
[ 11_LOTH= Average POM (mg/l) from 10-50m ] 		no problems detected 321 1.00000005E-03 730.000000 318
( 99 %)		 192
( 59 %)
Column 11 :
[ 12_OTHR= Average POM (%) from 0-10m ] 		no problems detected 483 -5.26000023 100.000000 478
( 98 %)		 478
( 98 %)
Column 12 :
[ 13_OTHR= Average POM (%) from 10-50m ] 		no problems detected 321 5.88199997 137.500000 319
( 99 %)		 319
( 99 %)
Column 14 :
[ 14_TEMP= Average Temperature (C) from 0-10m ] 		no problems detected 20841 -1.97099996 2.83999991 10515
( 50 %)		 6971
( 33 %)
Column 15 :
[ 15_TEMP= Average Temperature (C) from 10-50m ] 		no problems detected 27177 -1.97800004 1.88999999 14063
( 51 %)		 8309
( 30 %)
Column 16 :
[ 16_PSAL= Average Salinity () from 0-10m ] 		no problems detected 20837 2.13000011 35.0499992 20837
( 100 %)		 20837
( 100 %)
Column 17 :
[ 17_PSAL= Average Salinity () from 10-50m ] 		no problems detected 27175 3.42000008 34.5400009 27175
( 100 %)		 27175
( 100 %)

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