Feature: Show proper total when zero total for species but have ISSF/SPUH etc.

[jhurley13]

As part of prepare_for_compiler, highlight CountSpecial count fields if all counts in Group are zero. For example, count "peep sp." iff all other on list in "Sandpipers and Allies" are zero Or "gull sp." iff "Gulls, Terns, and Skimmers" all zero This isn't quite right though, since "peep sp." would require all Shorebirds to be 0 See e.g. "Western/Clark's Grebe" and "Western/Clark's Grebe"

SLASH [clear path]
For "Western/Clark's Grebe", both ['WEGR', 'CLGR'] entries must be zero
For "Short-billed/Long-billed Dowitcher" both ['SBDO', 'LBDO'] entries must be zero
Field in Taxonomy is "comNameCodes"

ISSF
Northern Flicker (Yellow-shafted) has ['NOFL'] in comNameCodes; This must be zero

INTERGRADE
Northern Flicker (Yellow-shafted x Red-shafted) has ['NOFL'] in comNameCodes; This must be zero

HYBRID
Northern x Gilded Flicker (hybrid) ['GIFL', 'NOFL'] in comNameCodes

SPUH
gull sp. has [] in comNameCodes

peep sp. has "Sandpipers and Allies" in familyComName, SPECIES_GROUP is "Shorebirds"
this means we have to populate familyComName as well

duck sp. familyComName is "Ducks, Geese, and Waterfowl"

DOMESTIC
Mallard (Domestic type) not countable
Muscovy Duck (Domestic type) not countable

To get 4 char code, it may be in comNameCodes, or if that's [], then bandingCodes
See e.g. Peregrine Falcon, also Wood Duck

familyComName - column J
comNameCodes - column G
SPECIES_GROUP - column X
bandingCodes - column F

Leads to general rule for checklists: if SLASH/HYBRID/ISSF present, 
then base species must be on list as well. Seen with Dark-eyed Junco

See https://nationalaudubon.app.box.com/s/h5h73acc0ix86vap55hf8miici88bniw
"Total Number of Species" from
https://www.audubon.org/christmas-bird-count-compiler-resources

[jhurley13]

Good illustration of SPUH question: Red-winged Blackbird 50 Tricolored Blackbird 10 Brewer's Blackbird 50 blackbird sp. 300 L2597366-Sergey Pavlov-15:16-Coyote Valley-S77941274

[jhurley13]

From Barry 01-29-21:

CAPA Calculated total: 174 Reported total: 171 Reasons for difference: Dark-eyed Junco (Slate-colored) and Dark-eyed Junco (Oregon) together count as one species (subtract 1) Yellow-rumped Warbler, (Audubon’s) and (Myrtle) together count as a single species (subtract 2) parakeet sp. (aka spittacara sp.) would count as a species, but are not countable via ABA rules (no change) Final number: 171

CASJ Calculated total: 174 Reported total: 173 Reasons for difference: Yellow-rumped Warbler, (Audubon’s) and (Myrtle) together count as a single species (subtract 2) (Brown Pelican wasn’t actually on the list) Final number: 172

CAMH No discrepancies

CACR Calculated total: 145 Reported total: 144 Yellow-rumped Warbler, (Audubon’s) and (Myrtle) together count as a single species (subtract 2) Rock Pigeon (Feral Pigeon) is countable (add 1) Final number: 144

Other notes: (these didn’t happen this time) Greater/Lesser Scaup — if both Greater Scaup and Lesser Scaup were zeroes, we would add 1 for this item Western/Clark's Grebe — if both Western Grebe and Clark’s Grebe were zeroes, we would add 1 for this item Short-billed/Long-billed Dowitcher — if both Short-billed Dowitcher and Long-billed Dowitcher were zeroes, we would add 1 for this item

[jhurley13]

[From Barry, 01-30-21] Gentle reader,

Brace yourself for a dive into typographic esoterica :-). This is my attempt to come up with a solution for the many different subspecies situations that arise when showing tabular data for the CBC. I’ve come up with options that are visually appealing (to my eye) and make sense (to me at least).

Here are the possible situations that I’ve observed, along with my typographic representation:

Situation A: Only one subspecies was observed and people want to know which subspecies it is: Iceland Gull (Thayer’s) — no indentation, not italic, subspecies name in parentheses and italics

Iceland.png

Situation B: There’s a main subspecies that is observed in the area and we’re sure what we saw is from that subspecies, but other subspecies were observed and people want to know the name of our main subspecies: Dark-eyed Junco (Oregon) — no indentation, not italic, subspecies name in parentheses and italics Dark-eyed Junco (Slate-colored) — indented, italic, subspecies name in parentheses and italics

Junco2.png

Situation C: There’s a main likely subspecies observed, but there’s enough of a chance that it could be something else that we would call it out if it were something else, but no other subspecies were positively identified: Northern Flicker — no indentation, not italic

Flicker.png

Situation D: There are multiple local subspecies, some of which we identified, some not: Yellow-rumped Warbler — no indentation, not italic Yellow-rumped Warbler (Audubon’s) — indented, italic, subspecies name in parentheses and italics Yellow-rumped Warbler (Myrtle) — indented, italic, subspecies name in parentheses and italics

YRWA.png

Situation E: There are subspecies, but either it’s unlikely to be found in the area or it’s hard enough to differentiate them that we didn’t do so: Canada Goose — no indentation, not italic Great Blue Heron — no indentation, not italic White-crowned Sparrow — no indentation, not italic etc.

CANG.png

Other possibilities may arise in other years, but we can deal with them as they come up.