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...

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...

You need to use quotes around the fieldname: select "User_ID", "Username", "Full Name", "E-mail" from SECURITY_USER...

An Oracle view is a virtual table that does not physically exist. It is stored in Oracle data dictionary and do not store any data. A view is created by a q...

Use the following string within a query to generate the link (URL) for an element in Explorer, using the necessary universal keys. An example of it in a qu...

Following is a query to determine which (child) tables are dependent on another table, in this case ELEMENT_GLOBAL_RANK. select distinct c.TABLE_NAME fr...

The threat category domain (d_iucn_threat_category) table is locally extensible. We have established conventions that allow for the addition of custom level...

Although the Biotics application itself prevents duplicate Visit records from being created, if you run SQL statements, duplicates can be created as there i...

NatureServe is working to incorporate Species Habitat Model (SHM) information from model providers into the NatureServe SHM database, including metadata and...