flag maximal observations by species
Closed this issue · 1 comments
smnorris commented
For quicker queries/lookups and easier visualization, add field flagging maximal observations, by species
smnorris commented
Ideally we could:
ALTER TABLE whse_fish.fiss_fish_obsrvtn_events ADD COLUMN maximal_species text[]
Then iterate through the species of interest, applying updates to add values to the maximal_species
array. The problem is that the event locations are not unique. If two events are in the same spot, which record gets the max flag?