Oracle Functions, Procedures, Queries, Scripts, Views...
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
Records being restored from the deleted schema are not automatically removed from the deleted schema after restoration. It is important to remove data from ...
Tue, 23 Jun, 2020 at 2:39 PM
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
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
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
/* 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
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
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
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
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