amckennafoster / flattenedfauna

A data curation project for roadkill data
MIT License
0 stars 2 forks source link

Review datasets #1

Open lc63 opened 5 years ago

lc63 commented 5 years ago

Colorado Colorado Cougar-human Interactions Massachusetts Washington- deer and elk salvage only Vermont Idaho Black Bear

One using the 311 service: https://data.cincinnati-oh.gov/Thriving-Healthy-Neighborhoods/roadkill/wdw5-d4i2

University efforts to collect this information for their state: Utah Wildlife-Vehicle Collision Reporter-partners with Adventure Scientists below for global data collection. UC-Davis Road Ecology Center North and South Carolina-partnership to document all sightings, including roadkill.

Private or nonprofit efforts: Adventure Scientists- global Spotteron- European Maine Audubon

amckennafoster commented 5 years ago

I'll do North/South Carolina, Adventure Scientists, and Spotteron.

lc63 commented 5 years ago

I've started OR, I'll do ID and UC-Davis also--actually it will end up being CROS database, I think that is what the UC Davis REC uses to get their hotspot data.

cmcd77 commented 5 years ago

@lc63 I just saw this comment, and I just finished CROS! I hope I didn't duplicate your efforts. I also did Utah, which was simple. I'll work on Vermont next.

lc63 commented 5 years ago

@cmcd77 I of course got distracted and didn't finish. No duplication here!

cmcd77 commented 5 years ago

Roadkill Datasets.xlsx Here is my analysis of VT (terrible), ME (iNaturalist based), CA (incredibly specific!) and UT.

lc63 commented 5 years ago

So, it turns out that the cougar data was housed in a report that studies Colorado cougar ecology. I extracted the data from the PDF using Tabula (wow! it's the best). Here is the raw data: ColoradoCougarEncounters.xlsx **I'll clean it later and write up a procedure for that. source report

lc63 commented 5 years ago

I cleaned the Black Bear Roadkill Data from Florida, in that I put in descending order by date. Black_Bear_RoadkillByDecDate.xlsx I will finish the dictionary and common variables in today and put them in the master.