San Francisco Plant Finder Data

data.sfgov.org | Last Updated 6 Sep 2019

This is the plant list used by the SF Plant Finder (http://sfplantfinder.org). The San Francisco Plant Finder is a resource for gardeners, designers, ecologists and anyone who is interested in greening neighborhoods, enhancing our urban ecology and surviving the drought. The Plant Finder recommends appropriate habitat-building plants for sidewalks, gardens and roofs that are adapted to San Francisco's unique environment and climate. The plants in the database include California natives and Mediterranean climate exotics. A large subset of the California natives are actually local San Francisco natives. We strongly recommend local natives since they provide the best habitat for local pollinators and other wildlife with whom they have co-evolved. San Francisco natives are the most closely adapted to the climate and environment of the San Francisco peninsula of course, and so they are the best in terms of water and soil conservation, ecosystem health, and overall sustainability. You can get the geographic ares for plant communities represented in this dataset here: https://data.sfgov.org/d/27u4-a5b3

Tags: plants, plant, plantfinder, sf plant finder, planning, green connections, environment

This dataset has the following 43 columns:

Column NameAPI Column NameData TypeSample Values
Latin_Namelatin_nametext
Common_Namecommon_nametext
Family_Namefamily_nametext
Former_Latin_Nameformer_latin_nametext
Plant_Typeplant_typetext
Bloom_Timebloom_timetext
Flower_Colorflower_colortext
Size_at_Maturitysize_at_maturitytext
Climate_Appropriate_Plantsclimate_appropriate_plantstext
Plant_Communitiesplant_communitiestext
Suitable_Site_Conditionssuitable_site_conditionstext
Soil_Typesoil_typetext
Pruning_Needspruning_needstext
Water_Needswater_needstext
Habitat_Valuehabitat_valuetext
Associated_Wildlifeassociated_wildlifetext
Stormwater_Benefitstormwater_benefittext
Stormwater_intstormwater_intnumber
Appropriate_Locationappropriate_locationtext
Suggested_Green_Connection_Routessuggested_green_connection_routestext
Street_Tree_Liststreet_tree_listtext
Additional_Characteristices_Notesadditional_characteristices_notestext
Nurseriesnurseriestext
PhotoCredit01photocredit01text
PhotoCredit02photocredit02text
PhotoCredit03photocredit03text
PhotoCredit04photocredit04text
Additional_Species_Cultivars_Varietiesadditional_species_cultivars_varietiestext
Special_Listspecial_listtext
Habitathabitattext
Habitat_inthabitat_intnumber
Thrifty150thrifty150text
Thrifty150_intthrifty150_intnumber
Sidewalk_Landscaping_Plantssidewalk_landscaping_plantstext
Sidewalk_Landscaping_Plants_intsidewalk_landscaping_plants_intnumber
Super60super60text
Super60_intsuper60_intnumber
Top20top20calendar_date
Top20_inttop20_intnumber
Shady_Clayshady_claytext
Shady_Clay_intshady_clay_intnumber
Sandy_Soilsandy_soiltext
Sandy_Soil_intsandy_soil_intnumber