search

BiologicalRecordsCentre / iRecord

Repository to store and track enhancements, issues and tasks regarding the iRecord website.
http://irecord.org.uk
2 stars 1 forks source link

Ecobat records query #927

Open kitenetter opened 4 years ago

kitenetter commented 4 years ago

A set of Ecobat records has ended up with grid references crosing the sea in a dead straight line, raising suspicion that the grid refs have been subject to corruption within Excel. Liaising with Mammal Soc to investigate. Mammal Soc having difficulty relating the records in Indicia to the raw data they start from.

Not sure what the problem is, awaiting feedback from Mammal Soc.

kitenetter commented 9 months ago

This issue has not been resolved, will chase Mammal Soc again.

kitenetter commented 6 months ago

@robin-hutchinson the records this applies to are a set of records from the "Ecobat" website (website ID = 88) that form a straight line more or less from Weston super Mare to Newport, and I think are all from 2016:

image

Can you query the data warehouse to find the list of occurrence IDs that go with these records - I'm hoping you can find a set of sequential records where the grid ref has been incremented for each record.

Once we have found the relevant occurrence IDs we should ask John to delete them.

robin-hutchinson commented 6 months ago

It looks like the start of this is ST337 and there is a set of sequential records with this start from 2016, but there doesn't seem to be a set of records where the y axis increases by a standard amount? ecobat_sea_records.xlsx