Jump to content
Whatbird Community

Your checklist of the day!


Kevin
 Share

Recommended Posts

38 minutes ago, neilpa said:

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.

For some reason I was under the impression that it did, I guess not. You can only view your highest big days.

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

Well, I get this far in Excel.  Apparently 'Count' is the equivalent of Google's 'CountUnique', and it was the default.  Darned if I can figure out how to sort it.  The usual SORT option on the Data tab is disabled, and sorting doesn't appear to be an option on the column heading.  Google time, I guess.

image.png.efb1bda4a69fd8280bed5578b8faf86d.png

I also now remember why I never 'got' pivot tables.  I don't understand how the Columns, Rows, and Fields boxes interact.  I looked for a tutorial but all I found was how to drag fields into each box.  I don't understand how to choose WHICH fields go where.  In this case, @neilpa provided detailed instructions, but I don't think I would have ever gotten there on my own.

  • Like 2
Link to comment
Share on other sites

13 minutes ago, Charlie Spencer said:

Darned if I can figure out how to sort it.  The usual SORT option on the Data tab is disabled, and sorting doesn't appear to be an option on the column heading.

You right-click any cell in the column you want to sort.  A quick check shows that works in a data table too, I'm just used to using the menu for sorts and never noticed it on the right-click menu.

Now, how the heck does one search for a specific checklist by number in eBird?  Their own FAQ doesn't cover it?

EDIT: never mind.  I went back to the data table and searched for the checklist number.  It turned out to be a location where I've submitted only one checklist.

Edited by Charlie Spencer
Link to comment
Share on other sites

45 minutes ago, Charlie Spencer said:

Now, how the heck does one search for a specific checklist by number in eBird?

Macaulay will filter by checklist number.  Any of the resulting media files will include a link back to the original checklist.  Obviously, this won't work if the checklist didn't have any media files attached and thus isn't in Mac at all.

  • Like 2
Link to comment
Share on other sites

2 hours ago, Charlie Spencer said:

Now, how the heck does one search for a specific checklist by number in eBird?

I had this in my original post but it was buried in the other instructions. If you have the S######## value (where # are the actual digits) replace that part in the URL directly - https://ebird.org/checklist/S########

  • Thanks 1
Link to comment
Share on other sites

9 hours ago, neilpa said:

I had this in my original post but it was buried in the other instructions.

Yes, you did; no, it wasn't buried; yes, I read it and completely forgot it by the time I was finished mucking around with the pivot table.

Just for giggles, I tried to generate a count of species by location.  The best I could do was a total sum of all individual birds reported at a location.  Second place went to a list of individual species at a location but I couldn't figure out how to total them.  Fortunately, I just have to install Excel at work; I don't have to crunch large blocks of data with it.  I'm sure I could find some for-pay training if I needed it.

Thanks.

  • Like 2
Link to comment
Share on other sites

43 minutes ago, IKLland said:

Thanks! Why, did not you not get those two while you were down there?

No 😢 They aren’t as consistently found in the areas I visited, and I didn’t have enough time at the spot that had both. Ah well, an excuse to go down again when I can. 

  • Sad 2
Link to comment
Share on other sites

On 1/11/2022 at 4:58 PM, neilpa said:

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.

I never heard of the COUNTUNIQUE formula.  I will have to try that.  I just ran a count formula at the top row of the sheet my PT is on to get that number.  Thank you for that.  

  • Like 2
Link to comment
Share on other sites

1 hour ago, chipperatl said:

I never heard of the COUNTUNIQUE formula.  I will have to try that.  I just ran a count formula at the top row of the sheet my PT is on to get that number.  Thank you for that.  

Yeah, I was mistaken when I said I thought COUNT was the Windows Excel equivalent of the Google COUNTUNIQUE.  That misconception is why I was having problems getting a count of species by location.  I couldn't find a way in Excel that did the same thing.

  • Like 1
Link to comment
Share on other sites

I drove by this spot earlier in the morning, and no Lapland Longspur flock there.  My other travels took me back around close enough I tried again.  High count for the county for eBird of 203 Lapland Longspur.  Probably more that were out of the frame of the photo I chose to count.  One of my other pics have have shown more also, but who want to count over and over again.  

https://ebird.org/checklist/S101208067

  • Like 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...