Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

and “PLANTEDRELEASED_population” and “species_name_population”

Code Block
"DBH" is null

Opportunistic columns

  1. Select data for opportunistic only

Code Block
bdbsa.supatch."SITETYPE" = 'OP' 

Opportunistic records may or may not have a site name (parent site). These records do not belong to a quadrat. All of these records have been assigned a “PATCHID” however a site sensu TERN data ontology does not exist. In terms of the ontology, these records are plot-less

2. For these FOI, a “tern_opportunistic_suspecies” data has to be created and the following columns from the suspecies table need to be included:

NUMOBSERVED,PLANTEDRELEASED_occurence and species_occurrence

3. LOCMETHODNR and RELIABNR are attributes of the coordinates. In the first case it is an instrument that varies by latitude,longitude combination. In the second case is a reliability value for the coordinates that comes in a lookuptable lureliab