The following query returns global rank factor, management, and characterization data, including the habitat fields with values comma-delimited. It is set u...

The following query will allow you to replicate what you see in an element working list. The Full ID and Geolevel columns are calculated values that are use...

To query just those columns found in a working list (no other data from the records), you can take advantage of the views that exist in Biotics for all the ...

SELECT hcu_o.higher_class_unit_name as Tax_Order , hcu_f.higher_class_unit_name AS Family , sn.scientific_name AS Taxa , sn.author_name AS Author , eg.round...

Runs off a working list and reports global habitat information for animals. Could be modified for use with plant elements and subnational data by substituti...

Here are some queries that you may find useful in querying the audit log. Basically, there are two tables that are important. Table AUDIT_LOG contains summa...

/*This query returns USESA and related fields by Element ID, ELCODE, and Scientific Name. It lists the USESA Synonym, if one exists, but otherwise leaves th...

Lets say you wanted to create a view that would select all the values between the first two astrices in a column you could say:  create view junk1 as select...

Although Contacts have not been included in Biotics 5, the Contacts from your Biotics 4 database are still within the Biotics 5 databse.  Utilize the follow...

/* This query selects all EOs with the selected edauthor names. To change the edauthor, move down to the WHERE clause to make the change. */ SELECT SCIENTI...