5-Mile Radius Bookkeeping

For 2019 I'm participating in the 5-Mile Radius Challenge hosted by Jen Sanford of the I Used to Hate Birds blog. In preparation of the upcoming year, I have been doing a little bit of "paperwork" and data work.

First, I started by creating a Google Earth map of my 5MR. I then uploaded all of coordinates of my eBird Hotspots and got this lovely image. This was all a fairly easily process to do. Some quick Google searching and an Excel spreadsheet later everything was uploaded.

I had already created a Google doc which housed all of the eBird Hotspots in my 5MR with their species totals, and a total amount of completed checklists, but today I took that list and added which Hotspots were missing entries on their barcharts. (These charts represent how bird occurrence changes over the course of the year and are pulled directly from eBird data.) This allows me to prioritize based on which Hotspots have missing data and/or which have the lowest species counts. This will help me throughout the year as I attempt to eBird as much of my 5MR as possible while getting all the Hotspots up to at least 50 and filling in as much missing data as possible.

Here is a little glimpse of how I set my Google Sheet up.

The row coloring got messed up as I was sorting in different ways.

Posted on 31 de dezembro de 2018, 12:03 AM by hallnatec