Re: Identifying species not available in taxon dictionary
I have a list of species that have come from a MapMate export. I know there are many in this list that do not match to the Recorder Taxon dictionary. I therefore did a query in Access to get a list of those that do not match. However, I think I may have done this on the wrong table.
I queried my list to the Taxon table and ended up with about 297 not matching.
However, this morning I did the same thing comparing to the Index_Taxon_Name table and the Preferred_Name field and this time it came up with 325. Querying to the Actual_Name instead gives me the same as the previous result to the Taxon table of 297.
Have I missed a trick here please? In order to determine which species are not going to match should I be doing this query in a different way?
When I look at the Taxon table it has 184976 distinct records of Item_Name whereas the ITN has 111060 distinct records of Preferred_Name.
Hope someone can help please?
Brian
(Conservation Officer (Buckinghamshire), BBOWT)