The symbology displayed in the Map for Source Features and EOs is based on the values within the D_NAME_CATEGORY table. The Name Category is defined within the Scientific Name record/table. Most of the symbology definitions are obvious based on the NAME_CATEGORY_DESC, but those which are not are listed below:
  • Alga/Fungus: D_NAME_CATEGORY_ID in (19, 6)
  • Communities/Ecological Systems: D_NAME_CATEGORY_ID in (8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 20, 21, 22, 23)

To determine if there are any EOs for a given name category, run the following query, in Query Builder for the name category in question. The following example uses looks for Geological Feature EOs:
select eo_id from eo_view_all_att_map where name_category_desc='Geological Feature'

To determine which categories your program does have EOs for, run the following query:
select distinct(name_category_desc) from eo_view_all_att_map 


And to determine which Scientific Name records are of a given name category (i.e. Geological Feature), run the following query:

select distinct(scientific_name) from scientific_name where d_name_category_id = (select d_name_category_id from d_name_category where name_category_desc = 'Geological Feature') order by scientific_name