|
The technical forum of the NBN Trust for use by the Network. It includes discussions and announcements on the NBN Atlas, Recorder 6 and Indicia |
You are not logged in. Please login or register.
Forum → UK Species Inventory / Dictionary → A Small Query
Charles,
Just a small query:
Is this Common Name synonym supposed to be in the Dictionary (as it is merely a spelling mistake/typo):-
Janapese Knotweed, - NBNSYS0000168057
Cheers.
Steve
Hi Steve,
This is a hangover from Recorder 3.3. It remains in, just in case there are any existing records against this name. Of course3 the correctly spelled name is also in the Dictionary.
Charles Hussey
Can anyone tell me an easy way to create an excel spreadsheet from one of the species dictionary lists.
Thanks
Janet
You can generate an XML report then export this to Excel. The basic query is as follows. The query as it stands just picks up the preferred names (not synonyms). It needs the key from the list you want (Table taxon_List. ) and expanding to get out the fields you want. Getting the common name from the list is bit more difficult, but it can be done. I will put it into a XML report for you if you specify what you need.
SELECT T.ITEM_NAME
FROM TAXON T INNER JOIN TAXON_VERSION TV ON TV.TAXON_KEY
= T.TAXON_KEY
INNER JOIN TAXON_LIST_ITEM TLI ON TLI.TAXON_VERSION_KEY
= TV.TAXON_VERSION_KEY
INNER JOIN TAXON_LIST_VERSION TLV
ON TLV.TAXON_LIST_VERSION_KEY = TLI.TAXON_LIST_VERSION_KEY
WHERE TLV.TAXON_LIST_KEY = 'NHMSYS0000357024'
AND TLI.PREFERRED_NAME = TLI.TAXON_LIST_ITEM_KEY
Is there a way to import the TOK from a spreadsheet exported from a copy of recorder?
Thanks
Janet
You could use a field like Surveyor’s Ref but ideally you should go back to the Recorder user and get them to do an export in NBN Access Database (zipped) format and import that. You definitely shouldn’t use Site ID and Record ID for the reasons explained in http://forums.nbn.org.uk/viewtopic.php?pid=8197#p8197 .The problem with importing data from a spreadsheet exported from a copy of Recorder is that new keys will be assigned to the records which could lead to duplication of them because two versions of them will exist in Recorder systems with different keys.
Thanks Sally. I take your point but sometimes it is easier to manipulate the data you want to export outside Recorder eg in GIS. SometimesI have wanted to remove some data before it is exported to another person. As you cannot see the records directly exported from Recorder it is sometimes preferable to export as a spreadsheet. However then the other person cannot import to include the TOK.
Janet
Can someone explain why this old hangover from the R3.3 species dictionary has become the preferred name when exploring records on iRecord and other Indicia systems (http://www.brc.ac.uk/irecord/species-maps)? Is Janapese Knotweed as hard to eradicate as Japanese Knotweed?
Perhaps what is harder to explain is why Recorder 6 hasn't got the problem.
So what is the easy explanation for the proliferation of this name outside the confines of Recorder?
I can't speak for the specific systems, but in principle for any given taxon version key there can be a number of different common names depending on which Taxon_List you look at. There are no recommended taxon common names in the NHM dictionary, so when the dictionary is processed there will be some rules coded into the process which make the decision on which name to use. Normally, the R3.3 list is a good one to choose, but this case looks like an exception. Up to recently the NHM were reluctant to change entries on old lists, but this is an obvious error and I think that Chris Raper might be willing to make the change. This would be the best solution as it fixes the problem with the R3.3 list as well as with the recommended common name. I will draw his attention to the post.
Thanks Mike
Just noticed my name in this thread! :)
In the past we took the view that we must be able to produce old checklists verbatim and so tweaking the names and checklist entries to correct obvious errors was frowned upon. But I am trying to be far more pragmatic with this - especially with lists that I would term "unpublished lists" where they have been used in Recorder but never actually appeared in print. The obvious example is the Recorder 3.3 list which has contained numerous ill-formed names and typos and I correct these on a case-by-case basis :)
Thanks Chris !!
Steve
Forum → UK Species Inventory / Dictionary → A Small Query
Powered by PunBB 1.4.6, supported by Informer Technologies, Inc.