How do I pivot to summarize my entries by a specific area?
Do you know that you only have woodpecker, robin, blackbird, chaffinch? To pivot at all you must either


Constraint the value-set in the table that you're pivoting on. Because values become schema, and schema must be determined at the time you issue the query you would have to know all possible values.
Make two trips to the server, one to generate the original resulset of values. And a second to read the metadata from that resultset so you can issue a second query against it.