Neighborhood Nature

Our Family's Nature Blog

Test Page for eBird Data – Graphs and Charts March 24, 2015

Here are the results of a series of tests for how to upload/paste graphics and tables into this WordPress blog format.

1. I copied the Cedar Waxwing graph in Excel and then pasted to Photoshop Elements. Saved as jpg, 100% quality, full width 1039 (145 kb), then inserted it as media here. When I noticed the image as displayed on the blog was really small, I went into the Media Settings page and changed the Width of the thumbnail to 600 which seemed pretty reasonable.:

CEWA-Columbus

Note that the graph above is still fairly hard to read on the page, but you can click to enlarge.

2. I really needed to add a title to the enlarged graph. So I did that, increased the height and width of the original graph bit, and followed the same procedure as above:

CEWA-Columbus-Titled

NOTE: I added several more graphs at the bottom of this page, using test protocol 2.

3. For this test I pasted a table directly from Excel to here. Note that the original included colors that do not duplicate here:

Location: Douglas Park Columbus Park Riis Park Taylor Park South Oak Park Our Block
# Confirmed Breeders 21 17 12 6 10 11
# Probable Breeders 5 7 0 5 4 2
# Possible Breeders 0 4 5 0 7 3
# Off-Site 3 3 1 0 0 1
Species (highest breeding code for 2014):
Canada Goose Confirmed Confirmed
Wood Duck Confirmed
Mallard Confirmed Confirmed Confirmed
Great Blue Heron OS-F OS-F
Green Heron Confirmed
Cooper’s Hawk Confirmed
Caspian Tern OS-F OS-F
Rock Pigeon (Feral Pigeon) Confirmed Probable Probable
Mourning Dove Confirmed Confirmed Possible Possible Confirmed
Chimney Swift OS-W OS-W OS-W Probable Probable
Ruby-throated Hummingbird Probable
Downy Woodpecker Confirmed Confirmed Confirmed Possible Confirmed Confirmed
Northern Flicker Probable
Kestrel Confirmed
Eastern Phoebe Confirmed
Eastern Wood-Pewee Possible
Eastern Kingbird Confirmed Probable
Warbling Vireo Confirmed Probable
Red-eyed Vireo Probable Probable Possible Possible
Blue Jay Possible Possible Confirmed
American Crow Confirmed Possible Possible
Northern Rough-winged Swallow Confirmed
Tree Swallow Possible
Barn Swallow Confirmed
Black-capped Chickadee Probable Probable Possible Confirmed Confirmed Confirmed
House Wren Confirmed Confirmed
Blue-gray Gnatcatcher Possible
American Robin Confirmed Confirmed Confirmed Confirmed Confirmed Confirmed
Gray Catbird Confirmed Confirmed Probable
European Starling Confirmed Confirmed Confirmed Confirmed Confirmed Confirmed
Cedar Waxwing Probable Possible Confirmed Confirmed Confirmed
Common Yellowthroat Probable Possible
Yellow Warbler Confirmed
Chipping Sparrow Possible Possible
Song Sparrow Probable Confirmed
Northern Cardinal Confirmed Confirmed Confirmed Confirmed Confirmed Confirmed
Indigo Bunting Confirmed
Red-winged Blackbird Confirmed Confirmed Confirmed
Common Grackle Confirmed Confirmed Confirmed Possible Possible
Brown-headed Cowbird Confirmed Confirmed Possible Possible
Orchard Oriole Probable
Baltimore Oriole Confirmed Confirmed
House Finch Possible Possible Possible Confirmed Confirmed
American Goldfinch Confirmed Confirmed Confirmed Confirmed Confirmed
House Sparrow Confirmed Confirmed Confirmed Confirmed Confirmed

4. Here’s the key for the above table, again pasted directly into the blog page (no colors on this table):

Breeding Bird Codes(mostly from eBird)
Confidence eBird Code My Code Meaning
Confirmed NY Nest with Young
Confirmed NE Nest with Eggs
Confirmed ON Occupied Nest
Confirmed FL Recently Fledged Young
Confirmed FY Feeding Young
Confirmed FS Carrying Fecal Sac
Confirmed CF Carrying Food
Confirmed DD Distraction Display
Confirmed PE Brood Patch and Physiological Evidence
Confirmed NB Nest Building
Confirmed CN Carrying Nesting Material
Probable T Territory Held for 7+ Days
Probable C Courtship, Display, or Copulation
Probable N Visiting Probable Nesting Site
Probable A Agitated Behavior
Probable PE Pair in Suitable Habitat
Probable M Multiple (7+) Singing Males
Possible S Singing male
Possible H In appropriate habitat
Flyover F
Off-site OS-F Capturing food and leaving park to possible nest
Off-site OS-W Drinking water but possibly nesting off site

5. To get the colors for the breeding bird table, I copied the table in Excel, pasted it into Photoshop Elements, saved it as a jpg, and uploaded to the blog as a media file. To get a decent sized image on the page, I went to media Settings and changed the height of the thumbnail to 1024:

BreedingBirds2014

The file is large (~650 kb), and you have to click on it to read it, but it does preserve all the detail. Also, it needs a title that shows up on the enlarged version, but I’ll do that later.

—–

Here are some additional Columbus Park species abundance graphs displayed using test protocol 2:

Number of species recorded each month:

ColumbusSpeciesByMonth

Number of visits per month (both monitoring visits and other visits):

ColumbusVisitsPerMonth

Highest daily count for each month for Canada Goose:

ColumbusCAGO

Highest daily count for each month for Wood Duck:

ColumbusWODU

Highest daily count for each month for Mourning Dove:

ColumbusMODO

Highest daily count for each month for Chimney Swift:

ColumbusCHSW

Highest daily count for each month for Downy Woodpecker:

ColumbusDOWO

Highest daily count for each month for Northern Flicker:

ColumbusNOFL

Highest daily count for each month for Monk Parakeet:

ColumbusMOPA

Highest daily count for each month for Blue Jay:

ColumbusBLJA

Highest daily count for each month for American Crow:

ColumbusAMCR

I will add more species abundance graphs later.

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s