Documenting and improving the Oakland Tree data

Trees in Oakland.

• Please help improve this dataset to make it more useful as a machine readable resource for urban agriculture projects.

From the City of Oakland website http://www2.oaklandnet.com/Government/o/CityAdministration/OAK029272

And Code for Oakland Datasets http://codeforoakland.org/data-sets/

---- Team -------------------------------------------- Chacha Sikes chachasikes@gmail.com @chachasikes Phillip Minnick phillipminnick@gmail.com

8/8/2012 Edible Fruit Tree Data Sprint

• Made Seasonality CUESA database
• Looked up some common names for 20,000 Oakland trees
• Look up more tree databases for Oakland & Berkeley, found none except 20 Mulberry Trees, Urban Releaf 1800 Water restoration tree planting project 2010
• Decided to make filter for map of what's fruiting
• Discussed if we'll want Add Tree form (adapted from Lemonopoly)
• Talked about Parklet -- idea of finding adoptive organization

7/21/2012 Code for Oakland hackathon event

• We added common names for 11,000+ tree species from USDA Plant Checklist (using Google refine)
• Geocoded some tree data (but not all) based on address data.
• We are asking the City of Oakland for information about when tree data was collected and by whom. (Oakland website does not supply this information.)
• Considering creating a database of edible, medicinal and graftable fruit trees.
• Researched seasonality data
• Reached out to CUESA about making their local seasonal data machine readable. (http://cuesa.org/page/seasonality-chart-fruit-and-nuts)

Example:

species J F M A M J J A S O N D human_readable Apples 1 1 1 1 1 1 1 2 2 2 2 1 Available January-July & December; In Season August - November Asian Pears 1 1 1 1 0 0 2 2 2 2 2 1 Available December - April; In Season July - November

--- Key ------------------------ 0 - Not in season 1 - Available but not seasonal 2 - In season