1 Reply by charlesroper

  • charlesroper
  • charlesroper
  • Digital Development Manager
  • Offline
  • From: Field Studies Council
  • Registered: 26-03-2006
  • Posts: 906

Re: Bradley & Fletcher numbers

Within the taxon dictionary, butterflies and moths have a Bradley & Fletcher number. This can be seen in the details pane of the taxon dictionary like this:

http://flickr.com/photos/sxbrc_charles/2262124135/

Question is, where in the db are these codes stored? I need to extract them for a job.

Cheers,
Charles

Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital

charlesroper's Website

2 Reply by CharlesHussey

  • CharlesHussey
  • Veteran
  • Offline
  • From: The Natural History Museum
  • Registered: 11-05-2007
  • Posts: 174

Re: Bradley & Fletcher numbers

Dear Charles,

Codes are stored in the LST_ITM_CODE field in the TAXON_LIST_ITEM table (codes are stored against lists rather than taxa). You will therefore need to build a query that extracts rows in TAXON_LIST_ITEM that relate to the Bradley & Fletcher checklist and their associated taxa.

Cheers,

Charles Hussey

NBN Species Dictionary Project Manager (Retired!) smile

3 Reply by charlesroper

  • charlesroper
  • charlesroper
  • Digital Development Manager
  • Offline
  • From: Field Studies Council
  • Registered: 26-03-2006
  • Posts: 906

Re: Bradley & Fletcher numbers

That's great, thanks Charles.

Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital

charlesroper's Website

4 Reply by Janet Simkin

  • Janet Simkin
  • Janet Simkin
  • Veteran
  • Offline
  • From: Northumberland
  • Registered: 10-05-2006
  • Posts: 260

Re: Bradley & Fletcher numbers

But why are some of the codes not displayed in the taxon information pane? Almost all the entries in the British Isles List of Lichens and Lichelicolous Fungi dictionary have a BLS code against them, and the codes show correctly if the taxa are included in a recording card, but only about half of them get displayed in the taxon dictionary itself.

Janet

Janet Simkin
British Lichen Society

Janet Simkin's Website

5 Reply by Sarah Shaw

  • Sarah Shaw
  • Veteran
  • Offline
  • Registered: 23-06-2006
  • Posts: 267

Re: Bradley & Fletcher numbers

Hi Janet

I've had a quick look at this but can't fathom why some codes display and some don't.

John (Dorset Software) - wondered whether you could say if this is likely to be a bug or a data issue? Some codes in [Taxon_List_Item].[Lst_Itm_Code] aren't displayed in the details pane in the Taxon Dictionary Browser.

Many thanks,

Sarah Shaw
Biodiversity Information Assistant
JNCC

6 Reply by johnvanbreda

  • johnvanbreda
  • Administrator
  • Offline
  • From: UK
  • Registered: 27-04-2006
  • Posts: 1,237

Re: Bradley & Fletcher numbers

Hi Janet & Sarah

When you view the taxon dictionary, you are viewing the code for just the item on the list and not looking for codes in other lists. When you view a record card, the system is looking to see if any of the other lists have a code for the taxon.

Best Wishes
John

John van Breda
Biodiverse IT

johnvanbreda's Website

7 Reply by Janet Simkin

  • Janet Simkin
  • Janet Simkin
  • Veteran
  • Offline
  • From: Northumberland
  • Registered: 10-05-2006
  • Posts: 260

Re: Bradley & Fletcher numbers

Yes, but I only use the BLS dictionary (British Isles List of Lichens and Lichenicolous Fungi) and that is where the codes are held. Some are displayed, others not. The taxon facts that we added to the dictionary a while back are also erratic, sometimes they show and sometimes not. Other lichen recorders are reporting the same thing so it is not just happening on my system.

Could it be something to do with our dictionary not being set as the preferred list for lichens (which it should be!), perhaps our information is not being shown if there is also information held against the species in another dictionary?

This gives me the chance to raise another issue which may be related. The synonyms shown are taken from all the dictionaries and not just ours, so our careful weeding out of incorrect synonyms over the last few years has been a waste of time as they still appear from out of date sources. Is there any way of limiting the information shown in the taxon window to just that from the dictionary being viewed? The user can always click on the other dictionary links to view the species there.

Thanks,

Janet

Janet Simkin
British Lichen Society

Janet Simkin's Website

8 Reply by wilkin_s

  • wilkin_s
  • Administrator
  • Offline
  • Registered: 31-03-2006
  • Posts: 87

Re: Bradley & Fletcher numbers

Janet,
Sorry for the delay. There are two points here:
- the code not appearing looks odd - we will raise a CCN for this though it is unlikely to be the next version
- the synonymy issue - the lichen list does have a much more restricted synonymy in - so that information / work has not been lost. The synonymy information appearing in the window though is not specific to the list being viewed but everything that Recorder things is a synonym. I assume what you are saying is that there are names listed as synonyms that are not synonyms of the current species? If you could provide an example or two that would be useful as it is worth getting to the bottom of it as the synonymy listed is what Recorder is using in the background. eg. if there is a record against one of the synonyms it would be reported against the preferred name.
Best wishes
STeve