Project

General

Profile

NYBG issues

Error rate: 190 error(s)/328,040 row(s) = 0.058%

Some fields appear to be imported incorrectly from a CSV file

Sample row:

key CatalogNumber Habitat UniqueNYInternalRecordNumber
3096 401109 Boggy edge of Acer forest",,,,309412\n3097,"2008-4-2T13:13:38.000EST Parinari excelsa Sabine

Error: Habitat field contains CSV formatting

Some rows have a MonthCollected but YearCollected is 0

Rows affected: 30

Sample row:

key YearIdentified Collector YearCollected MonthCollected DayCollected CollectedDate StateProvince County UniqueNYInternalRecordNumber
15265 1980 W. M. Canby 0 8 0 NULL Maryland Wicomico Co. 1107281

Error: 0 indicates year is missing

CoordinatePrecision sometimes uses CV percents (e.g. 'CV 5') instead of decimal degree values

Rows affected: 165

Sample row:

key CatalogNumber Locality Longitude Latitude CoordinatePrecision UniqueNYInternalRecordNumber
680 1071785 Guánica Forest. -66.9 17.9 CV 5 1216017

Error:

SyntaxException: Invalid XML function syntax: CvException: CV (coefficient of variation) values are only allowed for ratio scale data (see <http://en.wikipedia.org/wiki/Coefficient_of_variation>) 
function:
<_noCV><value>CV 5</value></_noCV>
 row #:  619
 input row: 
(680L,)

Some rows have an identifying party but no taxon determination

Rows affected: < 7 (some rows produce this error because of a mappings bug)

Sample row:

key Kingdom Phylum Class Order Family Genus Species Subspecies ScientificNameAuthor IdentifiedBy UniqueNYInternalRecordNumber
131 Plantae NULL NULL NULL Unknown NULL NULL NULL NULL C. L. Hitchcock 670505

Error:

NullValueException: columns: plantconcept_id 
cause: IntegrityError: null value in column "plantconcept_id" violates not-null constraint
query: INSERT INTO taxondetermination (determinationtype, taxonoccurrence_id, determinationdate, role_id, party_id, iscurrent) VALUES (E'Author', 309, E'1939-03-30', 1697, 174, E'true')
node:
<taxondetermination>
    <role_id><role><rolecode>identifier</rolecode></role></role_id>
    <determinationdate>1939-03-30</determinationdate>
    <determinationtype>Author</determinationtype>
    <iscurrent>true</iscurrent>
    <party_id>
        <party>
            <givenname>C.</givenname>
            <middlename>L.</middlename>
            <surname>Hitchcock</surname>
        </party>
    </party_id>
</taxondetermination>
 row #:  118
 input row: 
(131L,)

MinimumElevation is sometimes '.': FIXED

Rows affected: 2

Sample row:

key ScientificName MinimumElevation MaximumElevation UniqueNYInternalRecordNumber
192604 Aciotis annua (Mart. ex DC.) Triana . 0 980514

Error:

SyntaxException: Invalid XML function syntax: ValueError: could not convert string to float: . 
function:
<_avg>
    <max>0</max>
    <min>.</min>
</_avg>
 row #:  187102
 input row: 
(192604L,)

Input data is sometimes longer than VegBank allowed a field to be: FIXED

Sample row:

key CatalogNumber ScientificName UniqueNYInternalRecordNumber
3096 401109 Plagiomnium cuspidatum (Hedw.) T. J. Kop. Parinari excelsa Sabine

Error:

DataError: value too long for type character varying(20) 
query: INSERT INTO plantobservation (authorplantcode) VALUES (E'Parinari excelsa Sabine')
node:
<plantobservation>
    <!-- ... -->
    <authorplantcode>Parinari excelsa Sabine</authorplantcode>
</plantobservation>
input row: 
(3096L,)