smnorris/bcfishobs

flag maximal observations by species

Closed this issue · 1 comments

For quicker queries/lookups and easier visualization, add field flagging maximal observations, by species

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?