1 Topic by Wolfgang

  • Wolfgang
  • Member
  • Offline
  • Registered: 05-09-2012
  • Posts: 39

Topic: Taxon groups in Recorder

Hi,
who knows, how to extract the groups from Recorder when using SQL queries in a linked Access database? I find a table 'TAXON_GROUP' with a primary key 'TAXON_GROUP_KEY' but I don't find any other table which uses this field as foreign key. The table 'INDEX_TAXON_GROUP' doesn't help either and my data model from 2004 doesn't show the table 'TAXON_GROUP' at all.
Who knows more?

Thanks,
Wolfgang Ritter
HBIC

2 Reply by charliebarnes

  • charliebarnes
  • Veteran
  • Offline
  • From: Greater Lincolnshire
  • Registered: 07-09-2008
  • Posts: 1,390

Re: Taxon groups in Recorder

I use the Output_Group_Key of the Taxon_Version table to join to the Taxon_Group table.

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

charliebarnes's Website

3 Reply by Wolfgang

  • Wolfgang
  • Member
  • Offline
  • Registered: 05-09-2012
  • Posts: 39

Re: Taxon groups in Recorder

Thanks for the quick help.

Wolfgang
HBIC

4 Reply by AndyFoy

  • AndyFoy
  • Consultant
  • Offline
  • Registered: 09-08-2006
  • Posts: 219

Re: Taxon groups in Recorder

Hi Wolfgang

You might already have seen the email reply with a sample query to do this, but for anyone else that is interested this is how I would do it (limited only to system supplied recommended names to avoid picking up non-recommended synonyms and locally added names that may not have references to a taxon group).

If anyone knows of a better way, or thinks this approach is wrong, please say.

Andy

---

SELECT

       TG.TAXON_GROUP_NAME,
       ITN.ACTUAL_NAME,
       ITN.COMMON_NAME

       FROM INDEX_TAXON_NAME ITN
       INNER JOIN TAXON_LIST_ITEM TLI ON TLI.TAXON_LIST_ITEM_KEY = ITN.TAXON_LIST_ITEM_KEY
       INNER JOIN TAXON_VERSION TV ON TV.TAXON_VERSION_KEY = TLI.TAXON_VERSION_KEY
       INNER JOIN TAXON_RANK TR ON TR.TAXON_RANK_KEY = TLI.TAXON_RANK_KEY
       INNER JOIN TAXON_GROUP TG ON TG.TAXON_GROUP_KEY = TV.OUTPUT_GROUP_KEY

       WHERE ITN.TAXON_LIST_ITEM_KEY = ITN.RECOMMENDED_TAXON_LIST_ITEM_KEY
       AND ITN.SYSTEM_SUPPLIED_DATA = 1
       AND TLI.SYSTEM_SUPPLIED_DATA = 1
       AND TV.SYSTEM_SUPPLIED_DATA = 1

       ORDER BY TG.TAXON_GROUP_NAME, ITN.ACTUAL_NAME

Andy Foy
Systems Manager
Greenspace Information for Greater London (GiGL) CIC
www.gigl.org.uk