Oracle Functions, Procedures, Queries, Scripts, Views...

FUNCTION: Get best EO Rank
The GET_BEST_EORANK function: -- user-defined function, written by eml 7-8-2003 for Kentucky NHP -- -- designed to retrieve highest EORANK for a given elem...
Mon, 9 Apr, 2018 at 11:19 AM
PROCEDURE: Remove data from deleted schema which has been restored to the regular schema
Records being restored from the deleted schema are not automatically removed from the deleted schema after restoration. It is important to remove data from ...
Thu, 27 Jun, 2019 at 8:03 AM
QUERY: Get ESR data for a subnation for a list of snames
Attached is a query by Adele Tomaino.  Make sure to update the Subnation & SNAME at the end of the query!  Query updated by Shelley Cooke 1/16/18 to...
Wed, 16 Jan, 2019 at 3:41 PM
QUERY: Who deleted an EO (or another record)?
Description: I looked in the deleted schema at the "deleted_by" field in eo_del to see who had performed some EO deletions. But all of the values...
Mon, 9 Apr, 2018 at 11:46 AM
QUERY: Querying working lists - some examples
Description: Is there a way to build a query based upon a working list? I.e., I have a list of 50 bird species and I would like to know which ones we are t...
Mon, 9 Apr, 2018 at 11:47 AM
QUERY: Delimlist for subnational distribution fields
/* Delimlist for element_subnational distribution fields (taxon_subnatl_dist ); values are concatenated to keep each "row" of the distribution gri...
Mon, 9 Apr, 2018 at 11:50 AM
QUERY: Element_management from both element_global and element_group
Description: Returns el_mgmt records/data for EGTs on a working list, from both a directEGT-el_mgmt link and a EGT-Element_Group-El_mgmt link. Author: Marc...
Mon, 9 Apr, 2018 at 11:51 AM
QUERY: EO_Specs from both ELEMENT_GLOBAL and ELEMENT_GROUP
Description: Returns animal and plant eo_spec records / data from both a direct EGT-eo_specs link and a EGT-Element_Group-Eo_specs link. Note: Though it is...
Fri, 3 May, 2019 at 1:21 PM
QUERY: Delimlists for adult and immature food habits and phenology
Delimlists for adult and immature food habits and phenology AUTHOR: Jason McNees, NatureServe SELECT egt.element_global_id, egt.elcode_bcd, gname.scientif...
Mon, 9 Apr, 2018 at 1:36 PM
QUERY: Delimlist for some EO fields
sample SQL for EO delimlists for COUNTY, MAPSHEET, WATERSHED, MA_NAME, CITATIONS, and OWNER_TYPE You should be able to insert the delimlists into the "...
Mon, 9 Apr, 2018 at 1:37 PM