Connor Cochrane Posted January 11, 2022 Share Posted January 11, 2022 (edited) 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 January 11, 2022 by Connor Cochrane 1 Link to comment Share on other sites More sharing options...
Charlie Spencer Posted January 11, 2022 Share Posted January 11, 2022 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. 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. 2 Link to comment Share on other sites More sharing options...
Charlie Spencer Posted January 11, 2022 Share Posted January 11, 2022 (edited) 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 January 11, 2022 by Charlie Spencer Link to comment Share on other sites More sharing options...
Charlie Spencer Posted January 12, 2022 Share Posted January 12, 2022 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. 2 Link to comment Share on other sites More sharing options...
neilpa Posted January 12, 2022 Share Posted January 12, 2022 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######## 1 Link to comment Share on other sites More sharing options...
Charlie Spencer Posted January 12, 2022 Share Posted January 12, 2022 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. 2 Link to comment Share on other sites More sharing options...
IKLland Posted January 12, 2022 Share Posted January 12, 2022 I’m still uploading my photos from Florida, but I finished for this amazing list I had! I posted it already, but I’ll link it again now that all the photos are up. https://ebird.org/checklist/S98969490 4 Link to comment Share on other sites More sharing options...
Birding Boy Posted January 13, 2022 Share Posted January 13, 2022 2 hours ago, IKLland said: I’m still uploading my photos from Florida, but I finished for this amazing list I had! I posted it already, but I’ll link it again now that all the photos are up. https://ebird.org/checklist/S98969490 Whoah, simply awesome, great variety of your classic Florida stuff. Super envious of the PUGA and Swamphen! 1 1 Link to comment Share on other sites More sharing options...
IKLland Posted January 13, 2022 Share Posted January 13, 2022 4 minutes ago, Birding Boy said: Whoah, simply awesome, great variety of your classic Florida stuff. Super envious of the PUGA and Swamphen! Thanks! Why, did not you not get those two while you were down there? 1 Link to comment Share on other sites More sharing options...
Birding Boy Posted January 13, 2022 Share Posted January 13, 2022 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. 2 Link to comment Share on other sites More sharing options...
chipperatl Posted January 13, 2022 Share Posted January 13, 2022 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 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. Â 2 Link to comment Share on other sites More sharing options...
Charlie Spencer Posted January 13, 2022 Share Posted January 13, 2022 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. 1 Link to comment Share on other sites More sharing options...
Charlie Spencer Posted January 13, 2022 Share Posted January 13, 2022 Oh, and this turned out to be the checklist with the most entries: https://ebird.org/checklist/S60273038 Santee National Wildlife Refuge, central SC, September, 2019. It was one of several walks offered in the Carolina Bird Club's meeting that weekend. 2 Link to comment Share on other sites More sharing options...
IKLland Posted January 13, 2022 Share Posted January 13, 2022 On 12/17/2021 at 12:08 PM, Birding Boy said: Awesome, jealous of the Frigatebirds! Can't wait to see your photos man. https://ebird.org/media/catalog?taxonCode=magfri&mediaType=p&sort=rating_rank_desc&searchField=user&includeUnconfirmed=T&userId=USER1824290&species=Magnificent Frigatebird - Fregata magnificens 2 Link to comment Share on other sites More sharing options...
IKLland Posted January 16, 2022 Share Posted January 16, 2022 Nothing much today https://ebird.org/checklist/S100813691 2 Link to comment Share on other sites More sharing options...
IKLland Posted January 16, 2022 Share Posted January 16, 2022 On 12/17/2021 at 12:08 PM, Birding Boy said: Awesome, jealous of the Frigatebirds! Can't wait to see your photos man. I’ve uploaded all the photos from that day now! https://ebird.org/checklist/S99000713 2 Link to comment Share on other sites More sharing options...
Birding Boy Posted January 16, 2022 Share Posted January 16, 2022 14 hours ago, IKLland said: I’ve uploaded all the photos from that day now! https://ebird.org/checklist/S99000713 Very nice collection of good shots there. Jealous of the LBBG, I can’t seem to get decent shots of any of the cooler species up here! 2 1 Link to comment Share on other sites More sharing options...
Birding Boy Posted January 17, 2022 Share Posted January 17, 2022 Saw my first ever January Killdeer today! It had been reported last week; I was scanning through tons of dabblers when the crazy dude flew in and landed on the ice. Crazy how adaptable these guys are. Also saw my first of year Green-winged Teal. https://ebird.org/checklist/S100884700 3 Link to comment Share on other sites More sharing options...
Connor Cochrane Posted January 17, 2022 Share Posted January 17, 2022 Did some higher elevation birding today. Nothing that interesting, but it was nice to get Townsend's Solitare for the year. https://ebird.org/checklist/S100887704 4 Link to comment Share on other sites More sharing options...
IKLland Posted January 19, 2022 Share Posted January 19, 2022 https://ebird.org/checklist/S101014774 2 Link to comment Share on other sites More sharing options...
Kevin Posted January 21, 2022 Author Share Posted January 21, 2022 https://ebird.org/checklist/S101140727 3 Link to comment Share on other sites More sharing options...
Quiscalus quiscula Posted January 22, 2022 Share Posted January 22, 2022 3 hours ago, Kevin said: https://ebird.org/checklist/S101140727 I would have gotten seventeen lifers... Link to comment Share on other sites More sharing options...
IKLland Posted January 22, 2022 Share Posted January 22, 2022 (edited) lifer pine Siskin and an uncommon(but not rare) Bullocks Oriole in the winter! https://ebird.org/checklist/S101163771 Edited January 22, 2022 by IKLland 2 Link to comment Share on other sites More sharing options...
chipperatl Posted January 23, 2022 Share Posted January 23, 2022 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 3 Link to comment Share on other sites More sharing options...
IKLland Posted January 23, 2022 Share Posted January 23, 2022 https://ebird.org/checklist/S101248382 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now