document workflow - adding attributes for new species

[emillipede]

at the moment, adding species attributes to the CSV is a manual process (documented here). I'd like to automate as much of it as possible and then better document the parts that can't be automated.

1. open the species_attributes.csv, add the species' or variety's (the list is alphabetically sorted by botanical name) botanical and common names
2. find the corresponding species ID in the city's trees inventory and input the ID in csv
3. to find out if it's native to California, look up the species in calflora. document the tree as either native or exotic. if the species is a horticultural variety or hybrid, skip this step and mark it as 'exotic'
4. search for the species on EOL. add the EOL ID and overview URL*. use the information in EOL to document the species' family name (latin and common).
5. look up the species on the IUCN. if the species is listed, document the DOI (or, if none is available, the URL) and the conservation status. in the simplified column, list the conservation status without the supplemental numbers and letters. if the species is a horticultural variety or hybrid, skip this step and mark it as 'not listed'
6. to find out if the species is designated as invasive in california, look up the species in CAL IPC. if it's recognized as invasive, document CAL IPC's designation of the species.
7. look up the species in selectree to find out of it's deciduous or evergreen

*all images currently come from EOL. some species may not be easy to find in EOL. the botanical names in EOL don't always match the ones in the trees inventory dataset (eg Afrocarpus elongatus is listed as Podocarpus elongatus). if you can't find a tree, you can use google to check for synonyms. for tree varieties (a word in quotation marks after the species name, eg Afrocarpus elongatus 'Icee Blue'), we currently refer to and use the information associated with the main species (Afrocarpus elongatus). horticultural varieties aren't specified in EOL. most hybrids (anything with an x in the botanical name) aren't documented either, but a few are included.

missing species:

• Acacia podalyriifolia Pearl Acacia 1105
• Callistemon spp. Bottlebrush 1154
• Cedrus atlantica 'Pendula' Cedar Weeping 1168
• Cercidium spp. Palo Verde 682
• Citrus reticulata Tangerine 229
• Elaeocarpus decipiens Japanese Blueberry Tree 543
• Eucalyptus spp. Eucalyptus 44
• Lagerstroemia indica 'Dynamite' Dynamite Crape Myrtle 1567
• Lagerstroemia indica 'Pink' Pink Crape Myrtle 1287
• Leptospermum petersonii Lemon Scented Tea Tree 2008
• Liquidambar styraciflua 'Palo Alto' Palo Alto Sweetgum 459
• Persea spp. Avocado Species 1763
• Thuja plicata Western Red Cedar 375
• Unknown Unknown 9997