1 Reply by ian

  • ian
  • ian
  • Veteran
  • Offline
  • From: Herts
  • Registered: 26-10-2009
  • Posts: 75

Re: Roman Snail - Helix (Helix) pomatia

I think the RECOMMENDED_TAXON_LIST_ITEM_KEY for the above is wrong. The SQL I'm writing show the RECOMMENDED_TAXON_LIST_ITEM_KEY as:

NHMSYS0001701116

When I use the key in the Go To Taxon Key in R6 it pulls up the MOLLUSCA (NON-MARINE) list but doesn't go to the Taxon. I think the correct RECOMMENDED_TAXON_LIST_ITEM_KEY should be:

NHMSYS0020527488

Check it out using charlesr code at:

http://forums.nbn.org.uk/viewtopic.php?id=286

Ian

2 Reply by MikeWeideli

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

Re: Roman Snail - Helix (Helix) pomatia

I think you are right. TLI   NHMSYS0001701116 and TLI NHMSYS0020527488 both relate to the MOLLUSCA (NON-MARINE) list, but  NHMSYS0020527488 relates to a later version of the list so this should be the  RECOMMENDED_TAXON_LIST_ITEM_KEY. :

Because  NHMSYS0020527488  has a recommended key of NHMSYS0001701116  this will have minimal effect on reporting except that  the sort order will not be correct.

As the taxon version  keys are the same this isn't a problem with NameServer but to do with the way JNCC are allocating the recommended taxon list item keys.

A review of the way the dictionary works is underway and this issue will be picked up under this.

Mike Weideli

MikeWeideli's Website