About this Dataset

San Francisco Plant Finder Data

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
Organization: City of San Francisco
Last updated: 2020-11-10T16:57:01.465912
Tags: environment, green-connections, planning, plant, plantfinder, plants, sf-plant-finder

Tables

Table 1

@usgov.city_of_san_francisco_san_francisco_plant_finder_data.table_1

100.91 KB
714 rows
43 columns


CREATE TABLE table_1 (
  "latin_name" VARCHAR,
  "common_name" VARCHAR,
  "family_name" VARCHAR,
  "former_latin_name" VARCHAR,
  "plant_type" VARCHAR,
  "bloom_time" VARCHAR,
  "flower_color" VARCHAR,
  "size_at_maturity" VARCHAR,
  "climate_appropriate_plants" VARCHAR,
  "plant_communities" VARCHAR,
  "suitable_site_conditions" VARCHAR,
  "soil_type" VARCHAR,
  "pruning_needs" VARCHAR,
  "water_needs" VARCHAR,
  "habitat_value" VARCHAR,
  "associated_wildlife" VARCHAR,
  "stormwater_benefit" VARCHAR,
  "stormwater_int" DOUBLE,
  "appropriate_location" VARCHAR,
  "suggested_green_connection_routes" VARCHAR,
  "street_tree_list" VARCHAR,
  "additional_characteristices_notes" VARCHAR,
  "nurseries" VARCHAR,
  "photocredit01" VARCHAR,
  "photocredit02" VARCHAR,
  "photocredit03" VARCHAR,
  "photocredit04" VARCHAR,
  "additional_species_cultivars_varieties" VARCHAR,
  "special_list" VARCHAR,
  "habitat" VARCHAR,
  "habitat_int" DOUBLE,
  "thrifty150" VARCHAR,
  "thrifty150_int" DOUBLE,
  "sidewalk_landscaping_plants" VARCHAR,
  "sidewalk_landscaping_plants_int" DOUBLE,
  "super60" VARCHAR,
  "super60_int" DOUBLE,
  "top20" VARCHAR,
  "top20_int" DOUBLE,
  "shady_clay" VARCHAR,
  "shady_clay_int" DOUBLE,
  "sandy_soil" VARCHAR,
  "sandy_soil_int" DOUBLE
);