Oracle Functions, Procedures, Queries, Scripts, Views...
DESCRIPTION I am trying to develop a query to aid in updating our rankings. It needs to include the eo data, the last obs date, and the first obs date. I ...
Mon, 9 Apr, 2018 at 3:43 PM
DESCRIPTION I would like to see the underlying code for some of the SQL functions that come with Biotics (there are some syntax issues that I could learn s...
Fri, 16 Nov, 2018 at 8:18 AM
As part of the audit tracking procedures in Biotics, changes to s_rank and rounded_s_rank are routinely tracked in the audit log tables.However, the reaso...
Thu, 31 Dec, 2015 at 9:27 AM
select column_name, count(column_name) from table group by column_name having count (column_name) > 1; This can be adjusted for selecting multiple co...
Mon, 9 Apr, 2018 at 3:23 PM
Following is syntax for searching all views for a given field/column name. In the example below, we're searching for OU_UID - make sure to replace thi...
Mon, 9 Apr, 2018 at 3:21 PM
If you are trying to delete an EO, Managed Area, Reference, Conservation Site or other record, and you get an error message indicting that you can't de...
Mon, 9 Apr, 2018 at 2:36 PM
The old Biotics4 Query Builder allowed you to preview N-number of results before running the query. Currently, Biotics5 doesn't have this functionality,...
Mon, 9 Apr, 2018 at 2:33 PM
Because Source Features are points, lines, and polygons, the entire SF set has to be exported into 3 separate shapefiles/gdbs. Attached is a file including...
Tue, 1 Dec, 2020 at 8:50 AM
The following query written by former staff of Kentucky State Nature Preserves Commission, Shauna Dunham, parses SCIENTIFIC_NAME: select replace(substr...
Mon, 9 Apr, 2018 at 2:26 PM
The following was provided by Greg Krakow of the Georgia Natural Heritage Program. The Oracle Spatial query below selects all eos within 5 kilimeters (500...
Mon, 9 Apr, 2018 at 2:25 PM