Jump to content
Whatbird Community

Your checklist of the day!


Kevin
 Share

Recommended Posts

1 minute ago, Seanbirds said:

Wait, Whaaa??? You haven’t seen a Goldeneye before?!?! 

No. For some reason they’re very uncommon, but not rare here. This is the only hotspot we’re you can regularly get them in the winter, and anything more than one of them is considered a high count. Somehow I had THREE of them !

  • Like 2
Link to comment
Share on other sites

On 1/1/2022 at 5:19 PM, Charlie Spencer said:

I swear to you, I had NO CLUE the stationary RSHA was there until I looked at the photos just now.  :classic_ohmy: :classic_smile:

image.thumb.png.f97b447709419ea76921d39fc5a0287e.png

image.thumb.png.6f9c6a8cedf6ae637fcfe7bb5cd48964.png

image.thumb.png.cc00b0219e154d301d7cef3b8f0edef1.png

image.thumb.png.31c296afc363fcc725f83084a181fe1b.png

image.thumb.png.24a584db1dda1f425e3db7fdbbbff609.png

 

It is blending in pretty good. I think everyone has had this happen a time or two.

  • Like 1
Link to comment
Share on other sites

4 minutes ago, Charlie Spencer said:

Anyone know an easy way to find your checklist with the most species?  The list of your checklists doesn't show counts.

My eternal gratitude.  Well, ten, maybe fifteen minutes of gratitude.

I’ve wanted that too, I can’t figure it out.

Edited by IKLland
  • Like 1
Link to comment
Share on other sites

1 hour ago, Charlie Spencer said:

Anyone know an easy way to find your checklist with the most species?  The list of your checklists doesn't show counts.

My eternal gratitude.  Well, ten, maybe fifteen minutes of gratitude.

I've done this before, but depending on your level of Excel-fu it's likely not "easy".

Request an export of all your eBird data at https://ebird.org/downloadMyData . You'll get an email with a link to download a CSV file. It contains all your eBird observations, one row per-species (really taxa), per-checklist.

Import that file into Excel (or Google Sheets) and create a pivot table over the data. Use the "Submission ID" (e.g. checklist) field as the Rows to group by. Use the "Common Name" field as the Values and change the summarize dropdown to COUNTUNIQUE. You can then change the Rows to sort descending based on the counts.

The URL for a specific checklist is then https://ebird.org/checklist/S######## where you replace the S######## with value in the "Submission ID" column.

Here's a couple of screenshots of what this looks like in Google Sheets

149026869-54818311-310b-4a78-8f7e-f0257f

149026886-7a20be18-304c-48f7-9c58-942e1e

I've thought about making a small webpage that would automatically do this. Upload your eBird export and it could show this and other interesting tidbits that aren't easily exposed on the myebird page.

  • Like 3
  • Thanks 1
Link to comment
Share on other sites

5 minutes ago, neilpa said:

I've thought about making a small webpage that would automatically do this. Upload your eBird export and it could show this and other interesting tidbits that aren't easily exposed on the myebird page.

There is one that exists. Let me see if I can find it. It’s pretty cool how it presents your data. 

  • Like 3
Link to comment
Share on other sites

25 minutes ago, neilpa said:

create a pivot table

Yeah, I was with you right up to that point.  I'm decent with Excel, enough to have built the table to upload my Historical sightings, but pivot tables have always thrown me for a loop.  I'll do an import and see if I can crunch the data without one.  Or maybe this will give me an excuse to take another look at it.

So basically there's no way to do it inside eBird itself.

Edited by Charlie Spencer
  • Like 3
Link to comment
Share on other sites

5 minutes ago, neilpa said:

Thanks! That's essentially what I had in mind. One less thing for my random list of ideas to build.

I tried out birdstat, definitely a cool tool. Although, it doesn't appear to include a summary of checklists by species, the one thing that kicked off this topic.

  • Haha 3
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...