This function lets you pass in an element_global_id and will return the NatureServe Explorer informal taxonomy or, conversely, specify an informal taxonomy category and get a list of matching records. Each botany & zoology element will return one value only, based on the major categories from NSX. A list of all possible values is attached, so you can see what might be returned. Ecology elements will return "null" for now.

PLEASE NOTE that this function uses a higher taxonomy view that is not one of the standard Biotics views. You must create the element_global_tax_search_vw before creating the informal_tax function. The view is also available in the Knowledge Base, under Sample Scripts; Tips; Tricks --> Sample Oracle Views --> Element_Global taxonomy view.

Some examples of how to use the function:

SELECT informal_tax(element_global_id), elcode_bcd
FROM element_global
WHERE elcode_bcd like 'N%'

SELECT element_global_id, g_rank
FROM element_global
WHERE rounded_g_rank in ('G1','G2','T1','T2')
AND informal_tax(element_global_id) = 'Amphibians'