1 Topic by ser

  • ser
  • ser
  • Administrator
  • Offline
  • From: Staffordshire Ecological Recor
  • Registered: 24-09-2008
  • Posts: 603

Topic: Display Unchecked problem

I have just tried using the 'Display Unchecked Records' to show all the records with 'Zero Abundance' with the other two option not ticked.

This does display the Zero Abundance records but it also displays a variety of other records including, but not limited to:
1) Records with determination set to invalid
2) records with no abundance data whatsoever, but by no means all of these, only a selection!

Any ideas why

Craig

Craig Slawson
Staffordshire Ecological Record

ser's Website

2 Reply by sallyrankin

  • sallyrankin
  • Administrator
  • Offline
  • Registered: 07-04-2006
  • Posts: 371

Re: Display Unchecked problem

Have you looked in the taxon occurrence table to see if the zero abundance flag is set correctly for the observations that shouldn’t have been listed? Years ago there was a problem that meant this flag didn’t get set correctly but I think Mike has a batch update that will correct it. ZERO_ABUNDANCE on an observation’s entry in the TAXON_OCCURRENCE table should be set to True if DATA is 0 (zero) on all its entries in TAXON_OCCURRENCE_DATA.

Sally Rankin, JNCC Recorder Approved Expert
E-mail: s.rankin@btinternet.com
Telephone: 01491 578633
Mobile: 07941 207687

3 Reply by ser

  • ser
  • ser
  • Administrator
  • Offline
  • From: Staffordshire Ecological Recor
  • Registered: 24-09-2008
  • Posts: 603

Re: Display Unchecked problem

Hi Sally,

That's it, it is incorrect data in the ZERO_ABUNDANCE field, could you point me to Mike's batch update

Craig

Craig Slawson
Staffordshire Ecological Record

ser's Website

4 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: Display Unchecked problem

Hi Craig

See post http://forums.nbn.org.uk/viewtopic.php?id=4400

Mike Weideli

MikeWeideli's Website