How To...

How to do various things

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
Recover a deleted Managed Area
If you accidentally delete a Managed Area, you can recover your data from the deleted schema and insert it back into the source schema. The attached zip fi...
Thu, 2 Aug, 2018 at 1:53 PM
Decimal values lost when exporting data
PROBLEM: When I run the following script in QB and save as a gdb/shp the EOSIZE_AC field is exported as a long when it should be a float or double and so d...
Tue, 23 Jul, 2019 at 3:12 PM