BSBI Distribution Database > message board

Vascular plants: Fumaria records - notes field corrupted

Anything related to particular plant records or other database entries

Vascular plants: Fumaria records - notes field corrupted

by AndyAmphlett » Fri Dec 01, 2017 7:23 am


this dataset - ... etInstance - (Fumaria records) seems to be corrupted. Looking at vc94 records, and a few from other vcs, the notes field has details from different (unrelated) records. Selecting a record from the Fumaria dataset, and then viewing duplicates of the record, reveals the problem.

For example, this record from the Fumaria dataset - ... nchstamp=0 - in the notes field says "comment: Name in Craib's Flora = Fumaria capreolata Whole County status = Colonist". But the original version of the record - ... nchstamp=0 - in the notes field says "On levelled and reseeded area by road."

I could mark the vc94 records as inferior duplicates, but the problem may be wider, so needs looking at.


Posts: 408
Joined: Fri Nov 23, 2012 9:32 am
name: Andy Amphlett

Re: Vascular plants: Fumaria records - notes field corrupted

by admin » Fri Dec 01, 2017 3:02 pm

Hi Andy,

Thanks for highlighting this. The mangled notes are identical in the source record from BRC - so the records were corrupted before they reached the DDb.

I might be able to trace the source data set that BRC uploaded, but at the moment it looks as though this entire Fumitory dataset is superfluous - duplicating records that we already have from the original sources. The vast majority of the records in the set are literal duplicates, and, so far all the records not detected automatically as duplicates that I've examined have turned out to be inferior versions of another record in the system.

I'll investigate a bit more, but probably will end up suppressing the dataset rather than trying to reload it.
Tom Humphrey
Database Officer, Botanical Society of Britain and Ireland (BSBI)
c/o Centre for Ecology and Hydrology,Maclean Building, Crowmarsh Gifford, Wallingford, Oxon, OX10 8BB, UK.
User avatar
Posts: 438
Joined: Tue Nov 20, 2012 4:16 pm
name: Tom Humphrey

Return to Records and data