1 Topic by DaveSlade

  • DaveSlade
  • Veteran
  • Offline
  • Registered: 15-05-2006
  • Posts: 332

Topic: Designations

This is probably a stupid question, but how is the TAXON_DESIGNATION table populated? There are over 150 species in the Wildlife and Countryside act Schedule 9 dictionary, but only 60 in the TAXON_DESIGNATION table for the same list. Is the one kept up to date but not the other?

Dave Slade
Senior IT & Records Officer,
15 Talbot Road, Talbot Green, Pontyclun, CF72 8AD
www.sewbrec.org.uk, www.sewbrecord.org.uk

2 Reply by MikeWeideli

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

Re: Designations

The Taxon Designation table is populated from the list of keys contained in the setting table under TaxDesLists. Mainly this is the  'JNCC collation of taxon designations ' list. This replaced a number of list which used to be used for designations.  We would need to check with JNCC, but I think that not all the WCA designations are included in  the  'JNCC collation of taxon designations ' list (for a good reason I believe).

Mike Weideli

MikeWeideli's Website

3 Reply by DaveSlade

  • DaveSlade
  • Veteran
  • Offline
  • Registered: 15-05-2006
  • Posts: 332

Re: Designations

It may be a good reason, but without know what has been removed and why, I can't use the R6 species dictionary as the basis for the LRC Wales status list table.

Thanks anyway,
Dave

Dave Slade
Senior IT & Records Officer,
15 Talbot Road, Talbot Green, Pontyclun, CF72 8AD
www.sewbrec.org.uk, www.sewbrecord.org.uk

4 Reply by MikeWeideli

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

Re: Designations

You can add in other lists by appending the taxon_List_key(s) to the list in the settings table. Then rebuild Index_Taxon_Designation.

Mike Weideli

MikeWeideli's Website

5 Reply by TonyP

  • TonyP
  • TonyP
  • Veteran
  • Offline
  • From: Somerset
  • Registered: 15-05-2006
  • Posts: 306

Re: Designations

Ah so basically we should make it clear on ALL our documents that the statues of species are determined BY JNCC and any errors are THEIRS.

Data Manger
Somerset Environmental Records Centre

TonyP's Website