1 Topic by SteveHannah

  • SteveHannah
  • Veteran
  • Offline
  • From: Midlothian
  • Registered: 02-09-2010
  • Posts: 84

Topic: IUCN 2001 Red List

I can't seem to find any reference to the IUCN 2001 Red List within the species dictionary.  I have only noticed this since the last dictionary upgrade (00000010), as previously we used the IUCN Criteria for the red listing for our own export routine.

-----------------------------------------------------------------------
Steve Hannah - GIS and Data Infrastructure Officer
The Wildlife Information Centre

SteveHannah's Website

2 Reply by ChrisR

  • ChrisR
  • Administrator
  • Offline
  • Registered: 27-08-2011
  • Posts: 1,131

Re: IUCN 2001 Red List

Hi Steve

Where were you expecting to see the 2001 designations? Do you have specific queries that used to work but now don't?

I have done a quick query here on the master copy and the IUCN 2001 designations only seem to be tagged against the "JNCC collation of taxon designations" (version 3) checklist items. Not sure if that helps but do let me know if you'd like me to look further.

Chris R.

Chris Raper, Manager of the UK Species Inventory, Angela Marmont Centre for UK Biodiversity,
Natural History Museum, Cromwell Road, London, SW7 5BD.  (tel: 020 7942 5894)
also Tachinid Recording Scheme (http://tachinidae.org.uk/)

3 Reply by SteveHannah

  • SteveHannah
  • Veteran
  • Offline
  • From: Midlothian
  • Registered: 02-09-2010
  • Posts: 84

Re: IUCN 2001 Red List

I thought there was a dictionary list for the IUCN Red List in previous versions.  The problem I'm having is that an export query we use in recorder, to get records into separate tables for export to GIS, used to pick up on the IUCN Criteria that lived in the TAXON_DESIGNATION.DETAIL column, and adjust a status abbreviation in the export tables.  It doesn't seem to be now for some reason, and the only thing that has changed is the dictionary update.  Have the criteria (which was based on the letters A through E) changed?

-----------------------------------------------------------------------
Steve Hannah - GIS and Data Infrastructure Officer
The Wildlife Information Centre

SteveHannah's Website

4 Reply by ChrisR

  • ChrisR
  • Administrator
  • Offline
  • Registered: 27-08-2011
  • Posts: 1,131

Re: IUCN 2001 Red List

Hi Steve

My copy of Recorder6 seems to produce the same query as my master copy of the data here. I have just started by dumping out everything with an IUCN 2001 designation to prove that it exists and that it links into a checklist - like this:

SELECT TAXON_LIST.ITEM_NAME, TAXON_LIST_VERSION.VERSION, TAXON.ITEM_NAME, TAXON.AUTHORITY, TAXON_VERSION.ATTRIBUTE, TAXON_DESIGNATION_TYPE.SHORT_NAME, TAXON_DESIGNATION_TYPE.LONG_NAME, TAXON_DESIGNATION.DETAIL
FROM TAXON INNER JOIN ((((TAXON_LIST INNER JOIN TAXON_LIST_VERSION ON TAXON_LIST.TAXON_LIST_KEY = TAXON_LIST_VERSION.TAXON_LIST_KEY) INNER JOIN TAXON_LIST_ITEM ON TAXON_LIST_VERSION.TAXON_LIST_VERSION_KEY = TAXON_LIST_ITEM.TAXON_LIST_VERSION_KEY) INNER JOIN (TAXON_DESIGNATION INNER JOIN TAXON_DESIGNATION_TYPE ON TAXON_DESIGNATION.TAXON_DESIGNATION_TYPE_KEY = TAXON_DESIGNATION_TYPE.TAXON_DESIGNATION_TYPE_KEY) ON TAXON_LIST_ITEM.TAXON_LIST_ITEM_KEY = TAXON_DESIGNATION.TAXON_LIST_ITEM_KEY) INNER JOIN TAXON_VERSION ON TAXON_LIST_ITEM.TAXON_VERSION_KEY = TAXON_VERSION.TAXON_VERSION_KEY) ON TAXON.TAXON_KEY = TAXON_VERSION.TAXON_KEY
WHERE (((TAXON_DESIGNATION_TYPE.LONG_NAME) Like "*IUCN*2001*"))
ORDER BY TAXON_LIST.ITEM_NAME, TAXON_LIST_VERSION.VERSION, TAXON.ITEM_NAME;

Does that produce anything on your version?

Chris Raper, Manager of the UK Species Inventory, Angela Marmont Centre for UK Biodiversity,
Natural History Museum, Cromwell Road, London, SW7 5BD.  (tel: 020 7942 5894)
also Tachinid Recording Scheme (http://tachinidae.org.uk/)

5 Reply by SteveHannah

  • SteveHannah
  • Veteran
  • Offline
  • From: Midlothian
  • Registered: 02-09-2010
  • Posts: 84

Re: IUCN 2001 Red List

Hi Chris

Query produced everything.  Found out why the export category wasn't picking it up, looks like a change in the detail field to the IUCN Criterion.  Query was looking for a particular syntax that no longer exists.  Thanks for your help!

-----------------------------------------------------------------------
Steve Hannah - GIS and Data Infrastructure Officer
The Wildlife Information Centre

SteveHannah's Website

6 Reply by ChrisR

  • ChrisR
  • Administrator
  • Offline
  • Registered: 27-08-2011
  • Posts: 1,131

Re: IUCN 2001 Red List

No problem Steve - glad you found the problem :)

Chris Raper, Manager of the UK Species Inventory, Angela Marmont Centre for UK Biodiversity,
Natural History Museum, Cromwell Road, London, SW7 5BD.  (tel: 020 7942 5894)
also Tachinid Recording Scheme (http://tachinidae.org.uk/)