How To...

How to do various things

Managed Area Element List: Change EGT to EST
During conversion from BCD to Biotics, any ET that was in the Managed Area Element list was converted at the Global level. If you would like to change the...
Mon, 9 Apr, 2018 at 11:37 AM
Fix out-of-synch NEXT_SEQ values
This will set the sequence of tables to the next value to prevent PK constraint violations when you try to add a record. You can also get other strange, une...
Tue, 1 Jun, 2021 at 10:58 AM
Create a working list in the database outside of Biotics
I was wondering if there was a way to create a working list outside of Biotics? Is there a sql statement that can be written to create a working list? I am ...
Mon, 9 Apr, 2018 at 3:38 PM
Enter species in the COMM_EO_COMPOSITION table with a batch update
How can I populate the COMM_EO_COMPOSITION table with a list of species in a batch update? There's several ways do it. These steps assume that the s...
Mon, 9 Apr, 2018 at 3:40 PM
Update working list record counts
Problem: The working list record count displayed in Biotics5 comes from the field working_list.working_list_record_count, but that field is only updated...
Mon, 9 Apr, 2018 at 3:51 PM
Element Rank Estimator (Rank Calculator)
Find the Element Rank Estimator Simplified v 3.17 attached.
Mon, 9 Apr, 2018 at 3:54 PM
Find previous values as of a specific date
Attached is a script to add a function called value_on_date, which finds the value of a specific field on a specific date. It was developed in the Florida N...
Mon, 9 Apr, 2018 at 3:57 PM
Delete unmapped EO & SF records through SQL
Mapped EOs & SFs should be deleted through the Map in Biotics 5.  This can be done for each feature individually, according to the instructions in the ...
Mon, 9 Apr, 2018 at 3:56 PM
How to see newly created table or view in Query Builder
If you create a new table or view in Oracle, in order to be able to see it from within Query Builder, you must first Grant/Refresh Database Privileges. You ...
Tue, 25 May, 2021 at 12:01 PM
Bulk delete EST Records (and all its child records including EOs and Source Features) via SQL
WARNING: Prior to proceeding with these instructions, make sure you want to delete all child records, including EOs and Source Features that are related t...
Mon, 9 Apr, 2018 at 2:27 PM