Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Switch to GitHub Actions #1

Closed
simonw opened this issue Oct 22, 2021 · 2 comments
Closed

Switch to GitHub Actions #1

simonw opened this issue Oct 22, 2021 · 2 comments
Labels
enhancement New feature or request

Comments

@simonw
Copy link
Owner

simonw commented Oct 22, 2021

Looks like CircleCI stopped running a few months ago.

simonw added a commit that referenced this issue Oct 22, 2021
@simonw
Copy link
Owner Author

simonw commented Oct 22, 2021

Made a total mess of that: 27640e0 added files I didn't intend to add:

  • Street_Tree_List-old.csv
  • Street_Tree_List-unsorted.csv
  • message.txt

I'm going to fix that with a force-push so the unwanted files don't stay in the history.

simonw added a commit that referenced this issue Oct 22, 2021
simonw referenced this issue Oct 22, 2021
520 trees changed

  TreeID: 100773
    XCoord: "6005678.7" => "6005659"
    YCoord: "2111113.4" => "2111053"
    Latitude: "37.77703609052226" => "37.77686913464808"
    Longitude: "-122.42387945289902" => "-122.42394330530641"
    Location: "(37.77703609052226, -122.42387945289902)" => "(37.77686913464808, -122.42394330530641)"

  TreeID: 10286
    qSpecies: "::" => "Hymenosporum flavum :: Sweetshade"

  TreeID: 103460
    SiteOrder: "4" => "3"

  TreeID: 10388
    qSpecies: "Tristania conferta ::" => "Potential Site :: Potential Site"

  TreeID: 10434
    qSpecies: "Acacia melanoxylon :: Blackwood Acacia" => "Lophostemon confertus :: Brisbane Box"

  TreeID: 10444
    qSpecies: "Pyrus kawakamii :: Evergreen Pear" => "Lophostemon confertus :: Brisbane Box"

  TreeID: 10459
    qSpecies: "Pyrus kawakamii :: Evergreen Pear" => "Lophostemon confertus :: Brisbane Box"

  TreeID: 10463
    qSpecies: "Ficus retusa nitida :: Banyan Fig" => "Lophostemon confertus :: Brisbane Box"

  TreeID: 104822
    qSpecies: "Tree(s) ::" => "Agonis flexuosa :: Peppermint Willow"

  TreeID: 106322
    qSpecies: "Tristaniopsis laurina :: Swamp Myrtle" => "Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant'"

  TreeID: 112783
    qSpecies: "Ulmus parvifolia 'Drake' :: Drake's Chinese Elm" => "Ligustrum japonicum :: Japanese Privet"
    SiteOrder: "1" => "2"

  TreeID: 113032
    qSpecies: "Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut" => "Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood"

  TreeID: 114875
    qSpecies: "Schinus terebinthifolius :: Brazilian Pepper" => "Pittosporum undulatum :: Victorian Box"

  TreeID: 116783
    PlantDate: "" => "08/06/2021 12:00:00 AM"
    DBH: "16" => "3"
    PermitNotes: "" => "Permit Number 778230"

  TreeID: 116784
    PermitNotes: "" => "Permit Number 778230"

  TreeID: 116785
    PermitNotes: "" => "Permit Number 778230"

  TreeID: 116786
    PermitNotes: "" => "Permit Number 778230"

  TreeID: 116787
    PermitNotes: "" => "Permit Number 778230"

  TreeID: 117300
    PlantDate: "06/06/2016 12:00:00 AM" => "06/24/2021 12:00:00 AM"

  TreeID: 118314
    qSpecies: "Prunus cerasifera :: Cherry Plum" => "Magnolia grandiflora :: Southern Magnolia"

  TreeID: 118839
    qSpecies: "Pinus radiata :: Monterey Pine" => "Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman'"

  TreeID: 121688
    qSpecies: "Lophostemon confertus :: Brisbane Box" => "Olea europaea 'Fruitless' :: Fruitless Olive"

  TreeID: 121689
    qSpecies: "Lophostemon confertus :: Brisbane Box" => "Olea europaea 'Fruitless' :: Fruitless Olive"
    PlantDate: "" => "10/08/2021 08:02:00 AM"
    DBH: "9" => "3"

  TreeID: 124562
    qSpecies: "Myoporum laetum :: Myoporum" => "Tristania conferta ::"
    PlantDate: "" => "06/12/2021 12:00:00 AM"
    DBH: "18" => "3"
    PermitNotes: "" => "Permit Number 788553"

  TreeID: 124891
    PermitNotes: "" => "Permit Number 778230"

  TreeID: 125692
    qAddress: "3651 Baker St" => ""

  TreeID: 126400
    PlantDate: "" => "09/01/2021 12:00:00 AM"
    DBH: "4" => "3"

  TreeID: 126893
    qLegalStatus: "DPW Maintained" => "Permitted Site"
    qSpecies: "Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem'" => "Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia"
    PlantDate: "" => "07/08/2021 12:00:00 AM"
    DBH: "5" => "3"
    PlotSize: "Width 3ft" => "3x3"
    PermitNotes: "" => "Permit Number 788633"

  TreeID: 127065
    SiteOrder: "5" => "4"
    XCoord: "6001375.07484" => "6001390"
    YCoord: "2119548.95116" => "2119623"
    Latitude: "37.79995404091463" => "37.80015820883262"
    Longitude: "-122.43937180647009" => "-122.43932547052692"
    Location: "(37.79995404091463, -122.43937180647009)" => "(37.80015820883262, -122.43932547052692)"

  TreeID: 127639
    qSpecies: "Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem'" => "Ficus microcarpa :: Chinese Banyan"

  TreeID: 127985
    PlantDate: "" => "06/21/2021 12:00:00 AM"
    DBH: "20" => "3"

  TreeID: 128994
    qAddress: "1414 Jones St" => "1441 Jones St"
    PlantDate: "" => "12/26/1989 12:00:00 AM"

  TreeID: 128995
    qAddress: "1414 Jones St" => "1441 Jones St"

  TreeID: 129422
    PermitNotes: "" => "Permit Number 788576"

  TreeID: 129655
    PlantDate: "" => "06/21/2021 12:00:00 AM"
    DBH: "7" => "3"

  TreeID: 129659
    PlantDate: "" => "06/21/2021 12:00:00 AM"
    DBH: "7" => "3"

  TreeID: 130150
    qSpecies: "Lophostemon confertus :: Brisbane Box" => ":: Tree"
    PermitNotes: "" => "Permit Number 788864"

  TreeID: 130955
    qAddress: "159 Chestnut St" => "111 Chestnut St"
    XCoord: "6011140.46997" => "6011172"
    YCoord: "2121055.2291" => "2121034"
    Latitude: "37.804640801990026" => "37.80458427520943"
    Longitude: "-122.40568582233792" => "-122.40557521293628"
    Location: "(37.804640801990026, -122.40568582233792)" => "(37.80458427520943, -122.40557521293628)"

  TreeID: 130956
    qAddress: "159 Chestnut St" => "111 Chestnut St"
    XCoord: "6011155.36791" => "6011172"
    YCoord: "2121057.17715" => "2121034"
    Latitude: "37.804646983936" => "37.80458427520943"
    Longitude: "-122.4056344035992" => "-122.40557521293628"
    Location: "(37.804646983936, -122.4056344035992)" => "(37.80458427520943, -122.40557521293628)"

  TreeID: 131344
    SiteOrder: "3" => "5"

  TreeID: 131345
    SiteOrder: "2" => "4"

  TreeID: 132861
    qSpecies: "Pittosporum undulatum :: Victorian Box" => "Myoporum laetum :: Myoporum"

  TreeID: 133557
    qSpecies: "Platanus x hispanica :: Sycamore: London Plane" => "Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree"
    PlantDate: "" => "08/27/2021 12:00:00 AM"
    DBH: "4" => "3"
    PermitNotes: "" => "Permit Number 788594"

  TreeID: 134715
    SiteOrder: "4" => "6"

  TreeID: 136633
    qSpecies: "Taxodium distichum :: Bald Cypress" => "Acacia melanoxylon :: Blackwood Acacia"
    PermitNotes: "" => "Permit Number 778230"

  TreeID: 137603
    qCaretaker: "Private" => "Mayor Office of Housing"

  TreeID: 138001
    qAddress: "1685 SUTTER ST" => "1695 SUTTER ST"

  TreeID: 138112
    qAddress: "1695 Sutter St" => "1698 Sutter St"

  TreeID: 138185
    PlantDate: "" => "08/11/2021 12:00:00 AM"
    DBH: "6" => "3"

  TreeID: 139039
    qSpecies: "::" => "Elaeocarpus decipiens :: Japanese Blueberry Tree"

  TreeID: 139618
    qCaretaker: "Private" => "DPW"

  TreeID: 139619
    qCaretaker: "Private" => "DPW"

  TreeID: 13993
    PlantDate: "02/11/2006 12:00:00 AM" => "06/16/2021 12:00:00 AM"
    DBH: "11" => "3"

  TreeID: 13994
    PlantDate: "11/21/2011 12:00:00 AM" => "06/16/2021 12:00:00 AM"

  TreeID: 13995
    PlantDate: "05/09/2005 12:00:00 AM" => "06/16/2021 12:00:00 AM"

  TreeID: 13996
    PlantDate: "" => "06/16/2021 12:00:00 AM"
    DBH: "35" => "3"

  TreeID: 13997
    PlantDate: "" => "06/16/2021 12:00:00 AM"
    DBH: "35" => "3"

  TreeID: 13998
    PlantDate: "" => "06/16/2021 12:00:00 AM"
    DBH: "30" => "3"

  TreeID: 13999
    PlantDate: "" => "06/16/2021 12:00:00 AM"
    DBH: "35" => "3"

  TreeID: 14000
    PlantDate: "" => "06/16/2021 12:00:00 AM"
    DBH: "30" => "3"

  TreeID: 14001
    PlantDate: "" => "06/16/2021 12:00:00 AM"
    DBH: "40" => "3"

  TreeID: 14002
    PlantDate: "" => "06/16/2021 12:00:00 AM"
    DBH: "40" => "3"

  TreeID: 14003
    PlantDate: "" => "06/16/2021 12:00:00 AM"
    DBH: "40" => "3"

  TreeID: 140213
    qAddress: "658 Fillmore St" => "650X Fillmore St"
    XCoord: "6003592.9683" => "6003633"
    YCoord: "2110633.2956" => "2110561"
    Latitude: "37.77559987389129" => "37.775403636311"
    Longitude: "-122.43106036937913" => "-122.43091672928027"
    Location: "(37.77559987389129, -122.43106036937913)" => "(37.775403636311, -122.43091672928027)"

  TreeID: 140514
    qCaretaker: "Private" => "DPW"

  TreeID: 140515
    qCaretaker: "Private" => "DPW"

  TreeID: 140517
    qCaretaker: "Private" => "DPW"

  TreeID: 140518
    qCaretaker: "Private" => "DPW"

  TreeID: 140519
    qCaretaker: "Private" => "DPW"

  TreeID: 140523
    qSpecies: "Tristania conferta ::" => "Lophostemon confertus :: Brisbane Box"

  TreeID: 141639
    qSpecies: "Prunus cerasifera :: Cherry Plum" => "Quercus spp :: Oak"

  TreeID: 142620
    qAddress: "1 Scotland St" => "785 Columbus Ave"

  TreeID: 142716
    qSpecies: "::" => "Lophostemon confertus :: Brisbane Box"
    qAddress: "1120 COLUMBUS AVE" => "1150 COLUMBUS AVE"
    PlantDate: "" => "10/08/2021 09:33:00 AM"
    DBH: "0" => "3"

  TreeID: 143924
    PlantDate: "03/18/2021 12:00:00 AM" => "06/22/2021 12:00:00 AM"

  TreeID: 14585
    qSpecies: "Ficus retusa nitida :: Banyan Fig" => "Lophostemon confertus :: Brisbane Box"

  TreeID: 150570
    qAddress: "878 Kansas St" => "880 Kansas St"

  TreeID: 15748
    qSpecies: "Myoporum laetum :: Myoporum" => "Melaleuca linariifolia :: Flaxleaf Paperbark"
    PlantDate: "" => "07/20/2021 12:00:00 AM"
    DBH: "18" => "3"

  TreeID: 15750
    qSpecies: "Ficus retusa nitida :: Banyan Fig" => "Melaleuca linariifolia :: Flaxleaf Paperbark"
    PlantDate: "" => "07/20/2021 12:00:00 AM"
    DBH: "6" => "3"

  TreeID: 161312
    PlantDate: "11/27/2019 12:00:00 AM" => "07/24/2021 12:00:00 AM"

  TreeID: 164022
    qSpecies: "Tree(s) ::" => "Crataegus phaenopyrum :: Washington Hawthorn"

  TreeID: 171168
    qSpecies: "Pistacia chinensis :: Chinese Pistache" => "Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold"
    PlantDate: "" => "08/28/2021 12:00:00 AM"

  TreeID: 171274
    qSpecies: "Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia" => "Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless"
    PlantDate: "04/04/2017 12:00:00 AM" => "09/07/2021 12:00:00 AM"

  TreeID: 172375
    qSpecies: "Lagunaria patersonii :: Primrose Tree" => "Pistacia chinensis :: Chinese Pistache"
    PlantDate: "10/11/2017 07:37:00 AM" => "07/20/2021 12:00:00 AM"

  TreeID: 173682
    qSpecies: "Eucalyptus globulus :: Blue Gum" => "Myrica californica :: Pacific Wax Myrtle Tree"
    PlantDate: "" => "06/25/2021 12:00:00 AM"
    DBH: "" => "3"
    PermitNotes: "" => "Permit Number 788606"

  TreeID: 175507
    PlantDate: "" => "06/16/2021 12:00:00 AM"
    DBH: "4" => "3"

  TreeID: 175800
    qSpecies: "Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman'" => "Callistemon viminalis :: Weeping Bottlebrush"

  TreeID: 175829
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 175830
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 175831
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 175832
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 175833
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 175834
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 176296
    qSpecies: "Eriobotrya deflexa 'Coppertone' :: Coppertone Loquat" => "Photinia fraseri :: Photinia Tree"

  TreeID: 176578
    qSpecies: "Ilex altaclarensis 'Wilsonii' :: Wilson Holly Tree" => "Melaleuca quinquenervia :: Cajeput"
    PlantDate: "" => "08/14/2021 12:00:00 AM"
    DBH: "12" => "3"

  TreeID: 177705
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 177789
    PlantDate: "" => "08/03/2021 12:00:00 AM"
    DBH: "2" => "3"

  TreeID: 177791
    qSpecies: "Eriobotrya deflexa :: Bronze Loquat" => "Agonis flexuosa :: Peppermint Willow"
    PlantDate: "10/11/2017 11:44:00 AM" => "08/14/2021 12:00:00 AM"

  TreeID: 178099
    SiteOrder: "1" => "10"
    XCoord: "6009870.22482" => "6009884"
    YCoord: "2092198.24037" => "2092220"
    Latitude: "37.7253349956071" => "37.725395514253435"
    Longitude: "-122.40804532773453" => "-122.40799924184167"
    Location: "(37.7253349956071, -122.40804532773453)" => "(37.725395514253435, -122.40799924184167)"

  TreeID: 178100
    qAddress: "450 Holyoke St" => "475 Holyoke St"
    SiteOrder: "1" => "4"
    XCoord: "6009850.68827" => "6009884"
    YCoord: "2092261.77394" => "2092220"
    Latitude: "37.725508351604304" => "37.725395514253435"
    Longitude: "-122.4081173427337" => "-122.40799924184167"
    Location: "(37.725508351604304, -122.4081173427337)" => "(37.725395514253435, -122.40799924184167)"

  TreeID: 178103
    qAddress: "450 Holyoke St" => "475 Holyoke St"
    SiteOrder: "4" => "9"
    XCoord: "6009835.80068" => "6009884"
    YCoord: "2092308.97785" => "2092220"
    Latitude: "37.725637130044746" => "37.725395514253435"
    Longitude: "-122.40817213573688" => "-122.40799924184167"
    Location: "(37.725637130044746, -122.40817213573688)" => "(37.725395514253435, -122.40799924184167)"

  TreeID: 178104
    qAddress: "450 Holyoke St" => "475 Holyoke St"
    XCoord: "6009831.59561" => "6009884"
    YCoord: "2092324.84748" => "2092220"
    Latitude: "37.725680469261974" => "37.725395514253435"
    Longitude: "-122.40818779113867" => "-122.40799924184167"
    Location: "(37.725680469261974, -122.40818779113867)" => "(37.725395514253435, -122.40799924184167)"

  TreeID: 178105
    qAddress: "450 Holyoke St" => "475 Holyoke St"
    XCoord: "6009827.37216" => "6009884"
    YCoord: "2092339.81548" => "2092220"
    Latitude: "37.72572133176082" => "37.725395514253435"
    Longitude: "-122.40820344653513" => "-122.40799924184167"
    Location: "(37.72572133176082, -122.40820344653513)" => "(37.725395514253435, -122.40799924184167)"

  TreeID: 178106
    qAddress: "450 Holyoke St" => "475 Holyoke St"
    SiteOrder: "7" => "8"
    XCoord: "6009819.25849" => "6009884"
    YCoord: "2092363.88194" => "2092220"
    Latitude: "37.72578695888565" => "37.725395514253435"
    Longitude: "-122.40823319163155" => "-122.40799924184167"
    Location: "(37.72578695888565, -122.40823319163155)" => "(37.725395514253435, -122.40799924184167)"

  TreeID: 178834
    PlantDate: "" => "06/16/2021 12:00:00 AM"

  TreeID: 178864
    qSpecies: "Prunus persica :: Peach" => "Arbutus 'Marina' :: Hybrid Strawberry Tree"
    qSiteInfo: "Sidewalk: Property side : Yard" => "Sidewalk: Curb side : Cutout"

  TreeID: 179145
    qAddress: "102 Wayland St" => "98 Wayland St"
    XCoord: "6011376.8849" => "6011305"
    YCoord: "2092609.12278" => "2092589"
    Latitude: "37.7265474363946" => "37.72648816924292"
    Longitude: "-122.40286580203293" => "-122.40311289193515"
    Location: "(37.7265474363946, -122.40286580203293)" => "(37.72648816924292, -122.40311289193515)"

  TreeID: 179146
    qAddress: "102 Wayland St" => "98 Wayland St"
    XCoord: "6011358.3265" => "6011305"
    YCoord: "2092604.64263" => "2092589"
    Latitude: "37.72653409855019" => "37.72648816924292"
    Longitude: "-122.40292964310275" => "-122.40311289193515"
    Location: "(37.72653409855019, -122.40292964310275)" => "(37.72648816924292, -122.40311289193515)"

  TreeID: 17957
    qSpecies: "Eucalyptus globulus :: Blue Gum" => "Corymbia ficifolia :: Red Flowering Gum"

  TreeID: 180595
    qSpecies: "Tree(s) ::" => "Tristaniopsis laurina :: Swamp Myrtle"

  TreeID: 180600
    qSpecies: "Lophostemon confertus :: Brisbane Box" => "Lagunaria patersonii :: Primrose Tree"
    PlantDate: "01/21/2021 08:28:00 AM" => "08/31/2021 12:00:00 AM"

  TreeID: 181857
    qSpecies: "::" => "Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood"
    PlantDate: "" => "08/31/2021 12:00:00 AM"
    DBH: "0" => "3"

  TreeID: 181874
    qSpecies: "::" => "Eriobotrya deflexa :: Bronze Loquat"
    PlantDate: "" => "06/22/2021 12:00:00 AM"
    DBH: "0" => "3"

  TreeID: 181940
    qSpecies: "Myoporum laetum :: Myoporum" => "Tristaniopsis laurina :: Swamp Myrtle"
    qSiteInfo: "Sidewalk: Curb side : Yard" => "Sidewalk: Curb side : Cutout"
    PlantDate: "" => "06/03/2021 12:00:00 AM"
    DBH: "23" => "3"

  TreeID: 181949
    qSpecies: "Lagunaria patersonii :: Primrose Tree" => "Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless"
    PlantDate: "" => "06/22/2021 12:00:00 AM"
    DBH: "1" => "3"

  TreeID: 181965
    qSpecies: "::" => "Tristaniopsis laurina :: Swamp Myrtle"
    PlantDate: "" => "04/13/2021 12:00:00 AM"
    DBH: "0" => "3"

  TreeID: 181987
    qSpecies: "::" => "Metrosideros excelsa :: New Zealand Xmas Tree"
    PlantDate: "" => "04/10/2021 12:00:00 AM"
    DBH: "0" => "3"

  TreeID: 182196
    PlantDate: "" => "06/21/2021 12:00:00 AM"
    DBH: "0" => "3"
    PermitNotes: "" => "Permit Number 784708"

  TreeID: 182686
    qSpecies: "::" => "Agonis flexuosa :: Peppermint Willow"
    PlantDate: "" => "06/03/2021 12:00:00 AM"
    DBH: "0" => "3"

  TreeID: 182842
    qSpecies: "::" => "Tristaniopsis laurina :: Swamp Myrtle"
    PlantDate: "" => "06/22/2021 12:00:00 AM"
    DBH: "0" => "3"

  TreeID: 183041
    qSpecies: "::" => "Metrosideros excelsa :: New Zealand Xmas Tree"
    qSiteInfo: "Sidewalk: Curb side : Cutout" => "Sidewalk: Property side : Cutout"

  TreeID: 183502
    qSpecies: "::" => "Agonis flexuosa :: Peppermint Willow"
    PlantDate: "" => "05/08/2021 12:00:00 AM"
    DBH: "0" => "3"

  TreeID: 183556
    qSpecies: "Myoporum laetum :: Myoporum" => "Tristaniopsis laurina :: Swamp Myrtle"
    PlantDate: "" => "04/10/2021 12:00:00 AM"
    DBH: "12" => "3"

  TreeID: 183858
    qLegalStatus: "Undocumented" => "DPW Maintained"
    qSpecies: "::" => "Eriobotrya deflexa :: Bronze Loquat"
    qCareAssistant: "" => "FUF"
    PlantDate: "" => "06/29/2021 12:00:00 AM"
    DBH: "0" => "3"

  TreeID: 186717
    qSiteInfo: "Sidewalk: Property side : Yard" => "Median : Yard"

  TreeID: 187425
    qAddress: "2951 San Bruno Ave" => "2955 San Bruno Ave"
    SiteOrder: "1" => "2"
    XCoord: "6011542.1326" => "6011573"
    YCoord: "2091891.6066" => "2091893"
    Latitude: "37.72458651060748" => "37.72459205955793"
    Longitude: "-122.40224411850768" => "-122.40213751120393"
    Location: "(37.72458651060748, -122.40224411850768)" => "(37.72459205955793, -122.40213751120393)"

  TreeID: 188620
    qSpecies: "Acacia melanoxylon :: Blackwood Acacia" => "Lophostemon confertus :: Brisbane Box"
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 188621
    qSpecies: "Acacia melanoxylon :: Blackwood Acacia" => "Lophostemon confertus :: Brisbane Box"
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 188622
    qSpecies: "Acacia melanoxylon :: Blackwood Acacia" => "Lophostemon confertus :: Brisbane Box"
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 188820
    qSpecies: "Betula pendula :: European White Birch" => "Pittosporum undulatum :: Victorian Box"
    qSiteInfo: "Sidewalk: Property side : Yard" => "Sidewalk: Curb side : Cutout"

  TreeID: 189022
    PlantDate: "12/20/2018 12:00:00 AM" => ""

  TreeID: 189023
    PlantDate: "12/20/2018 12:00:00 AM" => ""

  TreeID: 189024
    PlantDate: "12/20/2018 12:00:00 AM" => ""

  TreeID: 189025
    PlantDate: "12/20/2018 12:00:00 AM" => ""

  TreeID: 189026
    PlantDate: "12/20/2018 12:00:00 AM" => ""

  TreeID: 189092
    qSpecies: "Acer rubrum :: Red Maple" => "Acacia melanoxylon :: Blackwood Acacia"

  TreeID: 190140
    qSpecies: "Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem'" => "Magnolia grandiflora :: Southern Magnolia"
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 190658
    qSpecies: "::" => "Hymenosporum flavum :: Sweetshade"
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 190659
    qSpecies: "::" => "Hymenosporum flavum :: Sweetshade"
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 190662
    qSpecies: "::" => "Hymenosporum flavum :: Sweetshade"
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 192294
    qSpecies: "Fraxinus spp :: Ash Spp" => "Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant'"
    PlantDate: "" => "07/28/2021 12:00:00 AM"
    DBH: "13" => "3"

  TreeID: 192295
    qSpecies: "Fraxinus spp :: Ash Spp" => "Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant'"
    PlantDate: "" => "07/28/2021 12:00:00 AM"
    DBH: "12" => "3"

  TreeID: 192296
    qSpecies: "Fraxinus spp :: Ash Spp" => "Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant'"
    PlantDate: "" => "07/28/2021 12:00:00 AM"
    DBH: "11" => "3"

  TreeID: 192298
    qLegalStatus: "DPW Maintained" => "Street Tree Maintenance Opt Out"
    qCareAssistant: "" => "DPW"

  TreeID: 192299
    qLegalStatus: "DPW Maintained" => "Street Tree Maintenance Opt Out"
    qCareAssistant: "" => "DPW"

  TreeID: 192300
    qLegalStatus: "DPW Maintained" => "Street Tree Maintenance Opt Out"
    qSpecies: "Fraxinus spp :: Ash Spp" => "Fraxinus oxycarpa 'Raywood' :: Raywood Ash"

  TreeID: 192301
    qLegalStatus: "DPW Maintained" => "Street Tree Maintenance Opt Out"
    qSpecies: "Fraxinus spp :: Ash Spp" => "Fraxinus oxycarpa 'Raywood' :: Raywood Ash"

  TreeID: 192303
    qLegalStatus: "DPW Maintained" => "Street Tree Maintenance Opt Out"

  TreeID: 193095
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 193312
    SiteOrder: "1" => "3"

  TreeID: 193613
    qSpecies: "Melaleuca quinquenervia :: Cajeput" => "Eucalyptus polyanthemos :: Silver Dollar Eucalyptus"

  TreeID: 194673
    qLegalStatus: "DPW Maintained" => "Street Tree Maintenance Opt Out"

  TreeID: 194674
    qLegalStatus: "DPW Maintained" => "Street Tree Maintenance Opt Out"

  TreeID: 194956
    qSpecies: "Pittosporum undulatum :: Victorian Box" => "Tristaniopsis laurina :: Swamp Myrtle"
    PlantDate: "" => "09/30/2021 12:00:00 AM"
    DBH: "6" => "3"
    PermitNotes: "" => "Permit Number 782801"

  TreeID: 194957
    qSpecies: "Pittosporum undulatum :: Victorian Box" => "Tristaniopsis laurina :: Swamp Myrtle"
    PlantDate: "" => "09/30/2021 12:00:00 AM"
    DBH: "4" => "3"
    PermitNotes: "" => "Permit Number 782801"

  TreeID: 196160
    qLegalStatus: "DPW Maintained" => "Prune Opt Out"
    PermitNotes: "" => "Permit Number 788889"

  TreeID: 196161
    qLegalStatus: "DPW Maintained" => "Prune Opt Out"
    PermitNotes: "" => "Permit Number 788889"

  TreeID: 196560
    XCoord: "6011757.86648" => "6011777"
    YCoord: "2105666.49456" => "2105680"
    Latitude: "37.76242144230656" => "37.762459593356304"
    Longitude: "-122.40246650302767" => "-122.40240127653195"
    Location: "(37.76242144230656, -122.40246650302767)" => "(37.762459593356304, -122.40240127653195)"

  TreeID: 197071
    PlantDate: "" => "08/13/2021 12:00:00 AM"
    DBH: "5" => "3"

  TreeID: 197170
    qSpecies: "Pyrus kawakamii :: Evergreen Pear" => "Acer rubrum 'Autumn Glory' :: Red Maple Tree 'Autumn Glory'"

  TreeID: 198081
    qLegalStatus: "DPW Maintained" => "Street Tree Maintenance Opt Out"

  TreeID: 198082
    qLegalStatus: "DPW Maintained" => "Street Tree Maintenance Opt Out"

  TreeID: 198083
    qLegalStatus: "DPW Maintained" => "Street Tree Maintenance Opt Out"

  TreeID: 198084
    qLegalStatus: "DPW Maintained" => "Street Tree Maintenance Opt Out"

  TreeID: 198085
    qLegalStatus: "DPW Maintained" => "Street Tree Maintenance Opt Out"

  TreeID: 198086
    qLegalStatus: "DPW Maintained" => "Street Tree Maintenance Opt Out"

  TreeID: 198087
    qLegalStatus: "DPW Maintained" => "Street Tree Maintenance Opt Out"

  TreeID: 198088
    qLegalStatus: "DPW Maintained" => "Street Tree Maintenance Opt Out"

  TreeID: 198089
    qLegalStatus: "DPW Maintained" => "Street Tree Maintenance Opt Out"

  TreeID: 198090
    qLegalStatus: "DPW Maintained" => "Street Tree Maintenance Opt Out"

  TreeID: 198091
    qLegalStatus: "DPW Maintained" => "Street Tree Maintenance Opt Out"

  TreeID: 198092
    qLegalStatus: "DPW Maintained" => "Street Tree Maintenance Opt Out"

  TreeID: 198093
    qLegalStatus: "DPW Maintained" => "Street Tree Maintenance Opt Out"

  TreeID: 198095
    qLegalStatus: "DPW Maintained" => "Street Tree Maintenance Opt Out"

  TreeID: 198096
    qLegalStatus: "DPW Maintained" => "Street Tree Maintenance Opt Out"

  TreeID: 198097
    qLegalStatus: "DPW Maintained" => "Street Tree Maintenance Opt Out"

  TreeID: 198098
    qLegalStatus: "DPW Maintained" => "Street Tree Maintenance Opt Out"

  TreeID: 198099
    qLegalStatus: "DPW Maintained" => "Street Tree Maintenance Opt Out"

  TreeID: 198100
    qLegalStatus: "DPW Maintained" => "Street Tree Maintenance Opt Out"

  TreeID: 198101
    qLegalStatus: "DPW Maintained" => "Street Tree Maintenance Opt Out"

  TreeID: 198102
    qLegalStatus: "DPW Maintained" => "Street Tree Maintenance Opt Out"

  TreeID: 198103
    qLegalStatus: "DPW Maintained" => "Street Tree Maintenance Opt Out"

  TreeID: 198105
    qLegalStatus: "DPW Maintained" => "Street Tree Maintenance Opt Out"

  TreeID: 198274
    qLegalStatus: "DPW Maintained" => "Street Tree Maintenance Opt Out"

  TreeID: 198275
    qLegalStatus: "DPW Maintained" => "Street Tree Maintenance Opt Out"
    qSpecies: "Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant'" => "Pittosporum undulatum :: Victorian Box"

  TreeID: 199649
    qSpecies: "::" => "Magnolia grandiflora :: Southern Magnolia"
    qSiteInfo: ":" => "Sidewalk: Curb side : Yard"

  TreeID: 200337
    qLegalStatus: "Undocumented" => "DPW Maintained"
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"
    qCaretaker: "Private" => "DPW"
    PlotSize: "Width 4ft" => "3x3"
    PermitNotes: "" => "Permit Number 779844"

  TreeID: 200509
    PlantDate: "01/27/2021 12:00:00 AM" => "10/08/2021 12:00:00 AM"

  TreeID: 200513
    qSpecies: "Tristania conferta ::" => "Lophostemon confertus :: Brisbane Box"

  TreeID: 200759
    XCoord: "6014603.9551" => "6014644"
    YCoord: "2094093.5604" => "2094084"
    Latitude: "37.73080306794007" => "37.730779039970564"
    Longitude: "-122.39181360527064" => "-122.39167449435949"
    Location: "(37.73080306794007, -122.39181360527064)" => "(37.730779039970564, -122.39167449435949)"

  TreeID: 200891
    PlantDate: "" => "06/16/2021 12:00:00 AM"
    DBH: "9" => "3"

  TreeID: 200892
    PlantDate: "" => "06/16/2021 12:00:00 AM"
    DBH: "10" => "3"

  TreeID: 202874
    PlantDate: "" => "06/25/2021 12:00:00 AM"
    PermitNotes: "" => "Permit Number 788608"

  TreeID: 203462
    qSpecies: "Afrocarpus gracilior :: Fern Pine" => "Podocarpus gracilor :: Fern Pine"
    PermitNotes: "" => "Permit Number 788522"

  TreeID: 203463
    qSpecies: "Afrocarpus gracilior :: Fern Pine" => "Podocarpus gracilor :: Fern Pine"
    PermitNotes: "" => "Permit Number 788522"

  TreeID: 204001
    qLegalStatus: "DPW Maintained" => "Section 806 (d)"
    qSpecies: "Acacia melanoxylon :: Blackwood Acacia" => "Lophostemon confertus :: Brisbane Box"
    PlantDate: "" => "06/30/2021 12:00:00 AM"
    DBH: "11" => "3"
    PermitNotes: "" => "Permit Number 782207"

  TreeID: 204102
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 204158
    qSpecies: "Arbutus 'Marina' :: Hybrid Strawberry Tree" => "Lophostemon confertus :: Brisbane Box"

  TreeID: 204749
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 205022
    qSpecies: "Arbutus 'Marina' :: Hybrid Strawberry Tree" => "Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark'"

  TreeID: 207630
    qLegalStatus: "DPW Maintained" => "Permitted Site"
    PlantDate: "" => "03/24/2015 12:00:00 AM"
    PermitNotes: "" => "Permit Number 774785"

  TreeID: 207862
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 207864
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 208094
    qLegalStatus: "DPW Maintained" => "Undocumented"

  TreeID: 209632
    qLegalStatus: "DPW Maintained" => "Permitted Site"
    PlantDate: "" => "12/04/1992 12:00:00 AM"
    PermitNotes: "" => "Permit Number 31360"

  TreeID: 209642
    PlantDate: "" => "06/16/2008 12:00:00 AM"
    PermitNotes: "" => "Permit Number 50889"

  TreeID: 209645
    SiteOrder: "1" => "2"

  TreeID: 209828
    qLegalStatus: "DPW Maintained" => "Permitted Site"
    PlantDate: "" => "11/03/1972 12:00:00 AM"
    PermitNotes: "" => "Permit Number 11033"

  TreeID: 210161
    qLegalStatus: "Permitted Site" => "DPW Maintained"

  TreeID: 210533
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 210534
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 210574
    SiteOrder: "3" => "4"

  TreeID: 210685
    qSpecies: "Olea europaea :: Olive Tree" => "Cordyline australis :: Dracena Palm"

  TreeID: 211378
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 211379
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 211380
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 211381
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 211382
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 211383
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 211384
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 211385
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 211386
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 211387
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 211388
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 211389
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 211390
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 211728
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 211729
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 211730
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 211731
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 211732
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 211733
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 211734
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 211735
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 211736
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 211737
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 211738
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 211739
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 213270
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 213685
    PlantDate: "09/23/2002 12:00:00 AM" => "07/02/2021 12:00:00 AM"
    DBH: "9" => "3"

  TreeID: 214154
    qSpecies: "Schinus molle :: California Pepper" => ":: Tree"
    PlantDate: "" => "06/14/2021 12:00:00 AM"
    DBH: "4" => "3"
    PermitNotes: "" => "Permit Number 788504"

  TreeID: 214155
    qSpecies: "Schinus molle :: California Pepper" => ":: Tree"
    PlantDate: "" => "06/14/2021 12:00:00 AM"
    DBH: "5" => "3"
    PermitNotes: "" => "Permit Number 788504"

  TreeID: 214564
    qSpecies: "Prunus spp :: Cherry" => "Tristaniopsis laurina :: Swamp Myrtle"

  TreeID: 214884
    XCoord: "5990584.10582" => "5990565"
    YCoord: "2103413.45434" => "2103419"
    Latitude: "37.75503040185077" => "37.75504452119043"
    Longitude: "-122.47553344880325" => "-122.47559992643376"
    Location: "(37.75503040185077, -122.47553344880325)" => "(37.75504452119043, -122.47559992643376)"

  TreeID: 216077
    qLegalStatus: "DPW Maintained" => "Permitted Site"
    PlantDate: "" => "10/30/1996 12:00:00 AM"
    PermitNotes: "" => "Permit Number 37237"

  TreeID: 21648
    qSpecies: "Tree(s) ::" => "Prunus spp :: Cherry"

  TreeID: 216749
    PlantDate: "10/06/2017 08:25:00 AM" => "09/23/2021 12:00:00 AM"

  TreeID: 219079
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 219799
    PlantDate: "01/23/2021 12:00:00 AM" => ""

  TreeID: 219931
    qLegalStatus: "DPW Maintained" => "Permitted Site"
    PlantDate: "" => "07/27/2016 12:00:00 AM"
    PermitNotes: "" => "Permit Number 778685"

  TreeID: 219990
    qSpecies: "Acacia baileyana :: Bailey's Acacia" => "Arbutus 'Marina' :: Hybrid Strawberry Tree"

  TreeID: 220124
    qLegalStatus: "DPW Maintained" => "Prune Opt Out"
    PermitNotes: "" => "Permit Number 788639"

  TreeID: 220232
    qSpecies: "Acacia melanoxylon :: Blackwood Acacia" => "Lophostemon confertus :: Brisbane Box"
    PlantDate: "" => "07/27/2021 12:00:00 AM"
    DBH: "28" => "3"

  TreeID: 220638
    qLegalStatus: "DPW Maintained" => "Undocumented"
    PlantDate: "" => "01/14/2016 12:00:00 AM"
    PermitNotes: "" => "Permit Number 774709"

  TreeID: 220654
    qLegalStatus: "DPW Maintained" => "Permitted Site"
    PlantDate: "" => "06/12/2001 12:00:00 AM"
    PermitNotes: "" => "Permit Number 44129"

  TreeID: 220655
    qLegalStatus: "DPW Maintained" => "Permitted Site"
    PlantDate: "" => "06/12/2001 12:00:00 AM"
    PermitNotes: "" => "Permit Number 44129"

  TreeID: 221825
    PlantDate: "" => "06/25/2021 12:00:00 AM"
    DBH: "5" => "3"
    PermitNotes: "" => "Permit Number 770511"

  TreeID: 221826
    PlantDate: "" => "06/25/2021 12:00:00 AM"
    DBH: "8" => "3"
    PermitNotes: "" => "Permit Number 770511"

  TreeID: 221827
    PlantDate: "" => "06/25/2021 12:00:00 AM"
    DBH: "8" => "3"
    PermitNotes: "" => "Permit Number 770511"

  TreeID: 221879
    qAddress: "43 Powers Ave" => "45 Powers Ave"
    XCoord: "6006986.90322" => "6007012"
    YCoord: "2099718.335" => "2099736"
    Latitude: "37.74582166064301" => "37.74587157761808"
    Longitude: "-122.41854573280304" => "-122.41846020386082"
    Location: "(37.74582166064301, -122.41854573280304)" => "(37.74587157761808, -122.41846020386082)"

  TreeID: 221880
    qAddress: "47 Coleridge St" => "4X Coleridge St"
    SiteOrder: "1" => "2"
    XCoord: "6007035.70082" => "6007037"
    YCoord: "2099744.20537" => "2099802"
    Latitude: "37.74589544193323" => "37.74605420611214"
    Longitude: "-122.41837883124053" => "-122.4183784360217"
    Location: "(37.74589544193323, -122.41837883124053)" => "(37.74605420611214, -122.4183784360217)"

  TreeID: 221935
    qSpecies: "Agonis flexuosa :: Peppermint Willow" => "Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint"
    qAddress: "102 Randall St" => "106 Randall St"
    XCoord: "6004836.87593" => "6004863"
    YCoord: "2097581.93653" => "2097583"
    Latitude: "37.739834321604576" => "37.739838717928194"
    Longitude: "-122.42582818552306" => "-122.42573793508703"
    Location: "(37.739834321604576, -122.42582818552306)" => "(37.739838717928194, -122.42573793508703)"

  TreeID: 222690
    qSpecies: "Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman'" => "Quercus tomentella :: Island oak"
    qCareAssistant: "" => "Mission Verde"

  TreeID: 222753
    XCoord: "6007621.03284" => "6007632"
    YCoord: "2099982.0606" => "2100001"
    Latitude: "37.74658147176345" => "37.74663409183141"
    Longitude: "-122.41637167303122" => "-122.41633509089068"
    Location: "(37.74658147176345, -122.41637167303122)" => "(37.74663409183141, -122.41633509089068)"

  TreeID: 223107
    qLegalStatus: "DPW Maintained" => "Permitted Site"
    PlantDate: "" => "06/12/2001 12:00:00 AM"
    PermitNotes: "" => "Permit Number 44129"

  TreeID: 223923
    qAddress: "325 Park St" => "335 Park St"

  TreeID: 224255
    qLegalStatus: "DPW Maintained" => "Street Tree Maintenance Opt Out"
    PermitNotes: "" => "Permit Number 788785"

  TreeID: 224824
    qLegalStatus: "DPW Maintained" => "Permitted Site"
    qSpecies: "Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem'" => "Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold"
    PlantDate: "" => "09/07/2021 12:00:00 AM"
    DBH: "21" => "3"
    PlotSize: "Width 5ft" => "5x5"
    PermitNotes: "" => "Permit Number 787848"

  TreeID: 224825
    qLegalStatus: "DPW Maintained" => "Permitted Site"
    qSpecies: "Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem'" => "Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold"
    PlantDate: "" => "09/07/2021 12:00:00 AM"
    DBH: "21" => "3"
    PlotSize: "Width 5ft" => "5x5"
    PermitNotes: "" => "Permit Number 787848"

  TreeID: 225062
    qSpecies: "Ceratonia siliqua :: Carob" => "Ligustrum lucidum :: Glossy Privet"

  TreeID: 225107
    qSpecies: "Cercis canadensis :: Eastern Redbud" => "Cercis occidentalis :: Western Redbud"

  TreeID: 225790
    qSpecies: "Fraxinus spp :: Ash Spp" => "Pistacia chinensis :: Chinese Pistache"

  TreeID: 225791
    qSpecies: "Fraxinus spp :: Ash Spp" => "Pistacia chinensis :: Chinese Pistache"

  TreeID: 225914
    qLegalStatus: "DPW Maintained" => "Prune Opt Out"
    PermitNotes: "" => "Permit Number 788889"

  TreeID: 226641
    qLegalStatus: "DPW Maintained" => "Section 806 (d)"
    qSpecies: "Ligustrum japonicum :: Japanese Privet" => "Arbutus 'Marina' :: Hybrid Strawberry Tree"
    qSiteInfo: "Sidewalk: Property side : Yard" => "Sidewalk: Curb side : Cutout"
    PlantDate: "" => "08/30/2021 12:00:00 AM"
    PlotSize: "Width 2ft" => "4x4"
    PermitNotes: "" => "Permit Number 782497"

  TreeID: 227168
    qSpecies: "Ligustrum lucidum :: Glossy Privet" => "Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree"
    PlantDate: "" => "07/27/2021 12:00:00 AM"
    DBH: "13" => "3"

  TreeID: 227189
    qSpecies: "Ligustrum lucidum :: Glossy Privet" => "Arbutus 'Marina' :: Hybrid Strawberry Tree"

  TreeID: 227722
    qLegalStatus: "DPW Maintained" => "Prune Opt Out"
    PermitNotes: "" => "Permit Number 788886"

  TreeID: 227759
    PlantDate: "" => "04/06/1998 12:00:00 AM"
    PermitNotes: "" => "Permit Number 38991"

  TreeID: 228015
    qSpecies: "Liquidambar styraciflua :: American Sweet Gum" => "Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia"
    PlantDate: "" => "07/27/2021 12:00:00 AM"
    DBH: "17" => "3"

  TreeID: 228159
    qAddress: "82 Coleridge St" => "90X Coleridge St"

  TreeID: 228441
    qSpecies: "::" => "Hymenosporum flavum :: Sweetshade"
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"
    PlantDate: "04/08/2008 12:00:00 AM" => ""

  TreeID: 228859
    qAddress: "220 Valencia St" => "224 Valencia St"
    SiteOrder: "2" => "1"
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"
    XCoord: "6006042.19236" => "6006015"
    YCoord: "2108323.05651" => "2108306"
    Latitude: "37.769394992320194" => "37.769346625219264"
    Longitude: "-122.42242370479886" => "-122.42251654992683"
    Location: "(37.769394992320194, -122.42242370479886)" => "(37.769346625219264, -122.42251654992683)"

  TreeID: 230712
    qSpecies: "Magnolia grandiflora :: Southern Magnolia" => "Magnolia spp :: Magnolia"

  TreeID: 231383
    qLegalStatus: "DPW Maintained" => "Permitted Site"
    PlantDate: "" => "06/12/1989 12:00:00 AM"
    PermitNotes: "" => "Permit Number 26094"

  TreeID: 231440
    qAddress: "101x Portola Dr" => "100x Portola Dr"
    XCoord: "5999772.05051" => "5999749"
    YCoord: "2101277.39678" => "2101261"
    Latitude: "37.74969364764613" => "37.749647311391804"
    Longitude: "-122.44360556644999" => "-122.44368409794198"
    Location: "(37.74969364764613, -122.44360556644999)" => "(37.749647311391804, -122.44368409794198)"
    Police Districts: "4" => "5"

  TreeID: 232165
    qAddress: "44 Masonic Ave" => "1601X Masonic Ave"

  TreeID: 232166
    qAddress: "44 Masonic Ave" => "1601x Masonic Ave"

  TreeID: 232167
    qAddress: "44 Masonic Ave" => "1601x Masonic Ave"

  TreeID: 232168
    qAddress: "38 Masonic Ave" => "1699x Masonic Ave"

  TreeID: 232169
    qAddress: "38 Masonic Ave" => "1699X Masonic Ave"

  TreeID: 232170
    qAddress: "38 Masonic Ave" => "1699x Masonic Ave"

  TreeID: 232171
    qAddress: "38 Masonic Ave" => "1699X Masonic Ave"

  TreeID: 232274
    qSpecies: "Morus alba :: White Mulberry" => "Metrosideros excelsa :: New Zealand Xmas Tree"

  TreeID: 232988
    qSpecies: "Olea europaea :: Olive Tree" => "Ginkgo biloba 'Autumn Sentinel' :: Autumn Sentinel Ginkgo"
    PlantDate: "" => "07/23/2021 12:00:00 AM"
    DBH: "14" => "3"

  TreeID: 233190
    qAddress: "109 Frederick St" => "115 Frederick St"
    SiteOrder: "1" => "3"
    XCoord: "5999429.25241" => "5999399"
    YCoord: "2107693.46617" => "2107668"
    Latitude: "37.76729103199039" => "37.767219381403265"
    Longitude: "-122.44525221342163" => "-122.44535502055226"
    Location: "(37.76729103199039, -122.44525221342163)" => "(37.767219381403265, -122.44535502055226)"

  TreeID: 233553
    SiteOrder: "3" => "2"

  TreeID: 23393
    qSpecies: "Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem'" => "Platanus x hispanica :: Sycamore: London Plane"

  TreeID: 234218
    qSpecies: "Pittosporum undulatum :: Victorian Box" => "Hymenosporum flavum :: Sweetshade"

  TreeID: 235116
    qAddress: "24 Montezuma St" => "7X Montezuma St"
    XCoord: "6007446.73076" => "6007443"
    YCoord: "2099760.64216" => "2099831"
    Latitude: "37.74596370316711" => "37.74615668015421"
    Longitude: "-122.41695870729862" => "-122.41697659196267"
    Location: "(37.74596370316711, -122.41695870729862)" => "(37.74615668015421, -122.41697659196267)"

  TreeID: 235266
    SiteOrder: "1" => "2"

  TreeID: 235872
    qLegalStatus: "DPW Maintained" => "Prune Opt Out"
    PermitNotes: "" => "Permit Number 788889"

  TreeID: 236398
    qSpecies: "Prunus cerasifera :: Cherry Plum" => "Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia"
    PlantDate: "" => "07/27/2021 12:00:00 AM"
    DBH: "7" => "3"

  TreeID: 236415
    qSpecies: "Prunus cerasifera :: Cherry Plum" => "Platanus x hispanica :: Sycamore: London Plane"
    PlantDate: "" => "07/27/2021 12:00:00 AM"
    DBH: "12" => "3"

  TreeID: 236678
    qSpecies: "Prunus cerasifera :: Cherry Plum" => "Arbutus 'Marina' :: Hybrid Strawberry Tree"
    PlantDate: "" => "06/06/2019 12:00:00 AM"

  TreeID: 236679
    qSpecies: "Prunus cerasifera :: Cherry Plum" => "Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia"

  TreeID: 236900
    qSpecies: ":: Tree" => "Cinnamomum camphora :: Camphor Tree"

  TreeID: 237325
    qAddress: "69 Winfield St" => "65 Winfield St"
    XCoord: "6007282.46233" => "6007301"
    YCoord: "2099098.54602" => "2099097"
    Latitude: "37.744136493903035" => "37.74413329191088"
    Longitude: "-122.41747981135" => "-122.417415602468"
    Location: "(37.744136493903035, -122.41747981135)" => "(37.74413329191088, -122.417415602468)"

  TreeID: 237371
    qSpecies: "Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry" => "Jacaranda mimosifolia :: Jacaranda"
    qCareAssistant: "" => "Mission Verde"
    PlantDate: "" => "07/01/2021 12:00:00 AM"
    DBH: "16" => "3"

  TreeID: 237440
    qSpecies: "Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry" => "Arbutus 'Marina' :: Hybrid Strawberry Tree"

  TreeID: 237442
    qSpecies: "Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry" => "Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia"

  TreeID: 237857
    qSpecies: "Prunus cerasifera :: Cherry Plum" => "Washingtonia robusta :: Mexican Fan Palm"

  TreeID: 237858
    qSpecies: "Prunus cerasifera :: Cherry Plum" => "Washingtonia robusta :: Mexican Fan Palm"

  TreeID: 237859
    qSpecies: "Prunus cerasifera :: Cherry Plum" => "Washingtonia robusta :: Mexican Fan Palm"

  TreeID: 237918
    qSpecies: "Prunus domestica 'Mariposa' :: Mariposa Plum" => "Lagerstroemia indica :: Crape Myrtle"

  TreeID: 238089
    qAddress: "194 Emmett Ct" => "194 Precita Ave"
    XCoord: "6007674.45635" => "6007669"
    YCoord: "2100290.92554" => "2100249"
    Latitude: "37.74743254969249" => "37.747317124762326"
    Longitude: "-122.41620881120485" => "-122.4162247100402"
    Location: "(37.74743254969249, -122.41620881120485)" => "(37.747317124762326, -122.4162247100402)"

  TreeID: 238213
    qLegalStatus: "DPW Maintained" => "Permitted Site"
    qSpecies: "Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry" => "Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman'"
    PlantDate: "" => "09/24/2021 12:00:00 AM"
    DBH: "4" => "3"
    PlotSize: "Width 3ft" => "3x3"
    PermitNotes: "" => "Permit Number 788843"

  TreeID: 23904
    SiteOrder: "7" => "6"
    XCoord: "6003550.0996" => "6003596"
    YCoord: "2114363.7178" => "2114195"
    Latitude: "37.78584025322631" => "37.78537959802679"
    Longitude: "-122.43147503127187" => "-122.43130418097743"
    Location: "(37.78584025322631, -122.43147503127187)" => "(37.78537959802679, -122.43130418097743)"

  TreeID: 239708
    qSpecies: "Schinus terebinthifolius :: Brazilian Pepper" => "Agonis flexuosa :: Peppermint Willow"
    PlantDate: "" => "06/16/2021 12:00:00 AM"
    DBH: "18" => "3"
    PermitNotes: "" => "Permit Number 788545"

  TreeID: 239846
    XCoord: "6006248.0181" => "6006239"
    YCoord: "2098531.08744" => "2098517"
    Latitude: "37.74252012171501" => "37.742480932418694"
    Longitude: "-122.42101641510237" => "-122.42104659705039"
    Location: "(37.74252012171501, -122.42101641510237)" => "(37.742480932418694, -122.42104659705039)"

  TreeID: 240479
    qAddress: "191 Ashbury St" => "800X Ashbury St"
    XCoord: "5999133.37279" => "5999157"
    YCoord: "2107619.10211" => "2107308"
    Latitude: "37.767069953432596" => "37.76621709468495"
    Longitude: "-122.44627026488254" => "-122.44616616185084"
    Location: "(37.767069953432596, -122.44627026488254)" => "(37.76621709468495, -122.44616616185084)"
    Supervisor Districts: "5" => "11"

  TreeID: 240578
    qLegalStatus: "Planning Code 138.1 required" => "DPW Maintained"
    qSpecies: "Tree(s) ::" => "Tristaniopsis laurina :: Swamp Myrtle"
    PlantDate: "04/17/2019 12:00:00 AM" => "10/13/2021 12:00:00 AM"
    PermitNotes: "Permit Number 782238" => "Permit Number 788899"

  TreeID: 241169
    PlantDate: "" => "08/29/2021 12:00:00 AM"
    DBH: "1" => "3"

  TreeID: 243440
    PermitNotes: "Permit Number 781301" => "Permit Number 775133"

  TreeID: 243517
    qSpecies: "Lophostemon confertus :: Brisbane Box" => "Acer rubrum 'Armstrong' :: Armstrong Red Maple"

  TreeID: 243655
    PlantDate: "" => "06/25/2021 12:00:00 AM"
    PermitNotes: "" => "Permit Number 788610"

  TreeID: 244117
    qSpecies: "Corymbia ficifolia :: Red Flowering Gum" => "Schinus molle :: California Pepper"

  TreeID: 244508
    PlantDate: "" => "08/21/2021 11:50:00 AM"
    DBH: "13" => "3"

  TreeID: 244874
    qSpecies: "Tree(s) ::" => "Ligustrum japonicum :: Japanese Privet"

  TreeID: 244915
    qSpecies: "Callistemon citrinus :: Lemon Bottlebrush" => "Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia"
    PlantDate: "" => "07/16/2021 08:58:00 AM"
    DBH: "7" => "3"

  TreeID: 244995
    qSpecies: "Myoporum laetum :: Myoporum" => "Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman'"

  TreeID: 244996
    qSpecies: "Myoporum laetum :: Myoporum" => "Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman'"

  TreeID: 244997
    qSpecies: "Myoporum laetum :: Myoporum" => "Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman'"

  TreeID: 244998
    qSpecies: "Myoporum laetum :: Myoporum" => "Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman'"

  TreeID: 245001
    qSpecies: "Myoporum laetum :: Myoporum" => "Arbutus 'Marina' :: Hybrid Strawberry Tree"

  TreeID: 245032
    qSpecies: "Myoporum laetum :: Myoporum" => "Acer buergeranum :: Trident Maple"

  TreeID: 245035
    qSpecies: "Arbutus 'Marina' :: Hybrid Strawberry Tree" => "Tree(s) ::"
    qSiteInfo: "Sidewalk: Curb side : Yard" => "Sidewalk: Curb side : Cutout"
    PlantDate: "" => "10/01/2021 12:00:00 AM"
    DBH: "10" => "3"
    PermitNotes: "" => "Permit Number 788734"

  TreeID: 245167
    qSpecies: "Corymbia ficifolia :: Red Flowering Gum" => "Prunus serrulata :: Ornamental Cherry"

  TreeID: 245458
    qSpecies: "::" => "Geijera parviflora :: Australian Willow"

  TreeID: 245459
    qLegalStatus: "DPW Maintained" => "Section 806 (d)"
    PlantDate: "" => "09/28/2021 12:00:00 AM"
    DBH: "12" => "3"
    PlotSize: "Width 0ft" => "5x5"
    PermitNotes: "" => "Permit Number 782204"

  TreeID: 245828
    qLegalStatus: "DPW Maintained" => "Prune Opt Out"
    PermitNotes: "" => "Permit Number 788639"

  TreeID: 245829
    qLegalStatus: "DPW Maintained" => "Prune Opt Out"
    PermitNotes: "" => "Permit Number 788639"

  TreeID: 245830
    qLegalStatus: "DPW Maintained" => "Prune Opt Out"
    PermitNotes: "" => "Permit Number 788639"

  TreeID: 245831
    qLegalStatus: "DPW Maintained" => "Prune Opt Out"
    PermitNotes: "" => "Permit Number 788639"

  TreeID: 245832
    qLegalStatus: "DPW Maintained" => "Prune Opt Out"
    PermitNotes: "" => "Permit Number 788639"

  TreeID: 245986
    qSpecies: "Pyrus kawakamii :: Evergreen Pear" => "Lophostemon confertus :: Brisbane Box"

  TreeID: 245987
    qSpecies: "Pyrus kawakamii :: Evergreen Pear" => "Corymbia ficifolia :: Red Flowering Gum"

  TreeID: 245992
    qSpecies: "Tristania conferta ::" => "Lophostemon confertus :: Brisbane Box"

  TreeID: 246010
    qSpecies: "Pyrus kawakamii :: Evergreen Pear" => "Lophostemon confertus :: Brisbane Box"

  TreeID: 246034
    qSpecies: "Acacia baileyana :: Bailey's Acacia" => "Olea europaea :: Olive Tree"

  TreeID: 246062
    qSpecies: "Cinnamomum camphora :: Camphor Tree" => "Acer buergeranum :: Trident Maple"

  TreeID: 246111
    qSpecies: "Pyrus calleryana :: Ornamental Pear" => "Elaeocarpus decipiens :: Japanese Blueberry Tree"

  TreeID: 246143
    qSpecies: "Prunus blireiana :: Flowering Plum" => "Arbutus 'Marina' :: Hybrid Strawberry Tree"

  TreeID: 246183
    qSpecies: "Prunus blireiana :: Flowering Plum" => "Cordyline australis :: Dracena Palm"

  TreeID: 246193
    qSpecies: "Agonis flexuosa :: Peppermint Willow" => "Magnolia grandiflora :: Southern Magnolia"

  TreeID: 246195
    qSpecies: "Schinus terebinthifolius :: Brazilian Pepper" => "Ulmus parvifolia :: Chinese Elm"

  TreeID: 246203
    qSpecies: "Schinus terebinthifolius :: Brazilian Pepper" => "Magnolia grandiflora :: Southern Magnolia"

  TreeID: 246211
    qSpecies: "Prunus cerasifera :: Cherry Plum" => "Olea europaea :: Olive Tree"

  TreeID: 246215
    qSpecies: "::" => "Olea europaea :: Olive Tree"

  TreeID: 246243
    qSpecies: "Tristaniopsis laurina :: Swamp Myrtle" => "Rhamnus alaternus :: Italian Buckthorn"

  TreeID: 246390
    qSpecies: "Dodonaea viscosa :: Hop Bush" => "Acacia melanoxylon :: Blackwood Acacia"

  TreeID: 246391
    qSpecies: "Dodonaea viscosa :: Hop Bush" => "Olea europaea :: Olive Tree"
    qAddress: "1302 Waller St" => "1320 Waller St"
    XCoord: "5999418.9163" => "5999384"
    YCoord: "2108430.2253" => "2108424"
    Latitude: "37.769313396925746" => "37.76929431060968"
    Longitude: "-122.44534094397548" => "-122.44546126962591"
    Location: "(37.769313396925746, -122.44534094397548)" => "(37.76929431060968, -122.44546126962591)"

  TreeID: 246392
    qAddress: "1310 Waller St" => "1320 Waller St"
    XCoord: "5999402.5635" => "5999384"
    YCoord: "2108427.4999" => "2108424"
    Latitude: "37.769304980173196" => "37.76929431060968"
    Longitude: "-122.44539731131914" => "-122.44546126962591"
    Location: "(37.769304980173196, -122.44539731131914)" => "(37.76929431060968, -122.44546126962591)"

  TreeID: 246393
    qAddress: "1318 Waller St" => "1320 Waller St"
    XCoord: "5999383.4853" => "5999384"
    YCoord: "2108424.4716" => "2108424"
    Latitude: "37.76929557612139" => "37.76929431060968"
    Longitude: "-122.44546308385654" => "-122.44546126962591"
    Location: "(37.76929557612139, -122.44546308385654)" => "(37.76929431060968, -122.44546126962591)"

  TreeID: 246394
    SiteOrder: "1" => "4"

  TreeID: 246395
    SiteOrder: "2" => "5"

  TreeID: 246396
    qSpecies: "Dodonaea viscosa :: Hop Bush" => "Podocarpus gracilor :: Fern Pine"
    SiteOrder: "3" => "6"

  TreeID: 246401
    qSpecies: "Ligustrum lucidum :: Glossy Privet" => "Schinus terebinthifolius :: Brazilian Pepper"
    qAddress: "1599 Clayton St" => "612 Clayton St"
    SiteOrder: "1" => "3"

  TreeID: 246979
    qLegalStatus: "DPW Maintained" => "Prune Opt Out"
    PermitNotes: "" => "Permit Number 788804"

  TreeID: 247238
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 247366
    qSpecies: "Myoporum laetum :: Myoporum" => "Lagunaria patersonii :: Primrose Tree"

  TreeID: 247492
    qSpecies: "Magnolia grandiflora :: Southern Magnolia" => "Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia"

  TreeID: 247544
    qSpecies: "Ilex spp :: Holly Species" => "Acacia melanoxylon :: Blackwood Acacia"

  TreeID: 248420
    qSpecies: "Tristania conferta ::" => "Lophostemon confertus :: Brisbane Box"
    qCareAssistant: "" => "DPW"
    PlotSize: "Width 0ft" => "3x3"

  TreeID: 248506
    qSpecies: "Pittosporum tenuifolium :: Tawhiwhi Pittosporum" => "Lagunaria patersonii :: Primrose Tree"

  TreeID: 248507
    qSpecies: "Pittosporum tenuifolium :: Tawhiwhi Pittosporum" => "Lagunaria patersonii :: Primrose Tree"

  TreeID: 248519
    qSpecies: "Prunus cerasifera :: Cherry Plum" => "Ginkgo biloba :: Maidenhair Tree"
    qAddress: "216 Frederick St" => "218 Frederick St"
    XCoord: "5998904.7125" => "5998894"
    YCoord: "2107666.4904" => "2107683"
    Latitude: "37.76718700803937" => "37.76723172717469"
    Longitude: "-122.44706457331563" => "-122.44710281438437"
    Location: "(37.76718700803937, -122.44706457331563)" => "(37.76723172717469, -122.44710281438437)"

  TreeID: 248549
    qSpecies: "Myoporum laetum :: Myoporum" => "Ulmus parvifolia :: Chinese Elm"

  TreeID: 248550
    qSpecies: "Myoporum laetum :: Myoporum" => "Ulmus parvifolia :: Chinese Elm"

  TreeID: 248551
    qSpecies: "Myoporum laetum :: Myoporum" => "Ulmus parvifolia :: Chinese Elm"

  TreeID: 248552
    qSpecies: "Prunus cerasifera :: Cherry Plum" => "Ulmus parvifolia :: Chinese Elm"

  TreeID: 248562
    qAddress: "202 Frederick St" => "200 Frederick St"
    XCoord: "5999042.1969" => "5999048"
    YCoord: "2107684.963" => "2107722"
    Latitude: "37.7672455832581" => "37.76734760899149"
    Longitude: "-122.44659036611634" => "-122.44657295908779"
    Location: "(37.7672455832581, -122.44659036611634)" => "(37.76734760899149, -122.44657295908779)"

  TreeID: 248564
    qAddress: "204 Frederick St" => "200 Frederick St"
    SiteOrder: "1" => "4"
    XCoord: "5999003.7376" => "5998985"
    YCoord: "2107680.4205" => "2107656"
    Latitude: "37.767230913813414" => "37.76716279089231"
    Longitude: "-122.4467230638633" => "-122.4467861168844"
    Location: "(37.767230913813414, -122.4467230638633)" => "(37.76716279089231, -122.4467861168844)"

  TreeID: 248565
    qAddress: "204 Frederick St" => "200 Frederick St"
    SiteOrder: "2" => "5"
    XCoord: "5998984.3566" => "5998985"
    YCoord: "2107677.9979" => "2107656"
    Latitude: "37.76722315482007" => "37.76716279089231"
    Longitude: "-122.44678992532113" => "-122.4467861168844"
    Location: "(37.76722315482007, -122.44678992532113)" => "(37.76716279089231, -122.4467861168844)"

  TreeID: 248580
    qSpecies: "Ficus carica :: Edible Fig" => "Araucaria heterophylla :: Norfolk Island Pine"

  TreeID: 248632
    qLegalStatus: "DPW Maintained" => "Prune Opt Out"
    PermitNotes: "" => "Permit Number 788639"

  TreeID: 248633
    qLegalStatus: "DPW Maintained" => "Prune Opt Out"
    PermitNotes: "" => "Permit Number 788639"

  TreeID: 248634
    qLegalStatus: "DPW Maintained" => "Prune Opt Out"
    PermitNotes: "" => "Permit Number 788639"

  TreeID: 248800
    qCaretaker: "Private" => "DPW"

  TreeID: 248809
    qLegalStatus: "DPW Maintained" => "Permitted Site"

  TreeID: 248810
    qLegalStatus: "DPW Maintained" => "Permitted Site"

  TreeID: 248811
    qLegalStatus: "DPW Maintained" => "Permitted Site"

  TreeID: 248812
    qLegalStatus: "DPW Maintained" => "Permitted Site"

  TreeID: 249405
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 249406
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 249548
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 250027
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 250028
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 250029
    qSiteInfo: ":" => "Sidewalk: Curb side : Cutout"

  TreeID: 251079
    SiteOrder: "1" => "3"

  TreeID: 251080
    SiteOrder: "2" => "4"

  TreeID: 253663
    SiteOrder: "1" => "3"

  TreeID: 253664
    SiteOrder: "2" => "4"

  TreeID: 253665
    SiteOrder: "3" => "5"

  TreeID: 253899
    qLegalStatus: "Significant Tree" => "DPW Maintained"

  TreeID: 254404
    qSpecies: "Metrosideros excelsa :: New Zealand Xmas Tree" => "Ginkgo biloba :: Maidenhair Tree"

  TreeID: 254764
    XCoord: "5997448.21567" => "5997502"
    YCoord: "2089391.00345" => "2089431"
    Latitude: "37.71692364595276" => "37.717036545896974"
    Longitude: "-122.45078451099077" => "-122.45060148753163"
    Location: "(37.71692364595276, -122.45078451099077)" => "(37.717036545896974, -122.45060148753163)"

  TreeID: 255456
    qSpecies: "Acer rubrum 'October Glory' :: Red October Glory Maple" => "Aesculus californica :: California Buckeye"

  TreeID: 255468
    qSpecies: "Acer rubrum 'October Glory' :: Red October Glory Maple" => "Aesculus californica :: California Buckeye"

  TreeID: 255469
    qSpecies: "Acer rubrum 'October Glory' :: Red October Glory Maple" => "Aesculus californica :: California Buckeye"

  TreeID: 255470
    qSpecies: "Acer rubrum 'October Glory' :: Red October Glory Maple" => "Quercus agrifolia :: Coast Live Oak"

  TreeID: 255471
    qSpecies: "Acer rubrum 'October Glory' :: Red October Glory Maple" => "Quercus agrifolia :: Coast Live Oak"

  TreeID: 255498
    qLegalStatus: "Undocumented" => "Private"
    qSpecies: "Tree(s) ::" => "Lophostemon confertus :: Brisbane Box"
    PlantDate: "" => "07/01/2021 12:00:00 AM"
    DBH: "" => "3"
    PermitNotes: "" => "Permit Number 781789"

  TreeID: 255499
    qLegalStatus: "Undocumented" => "Private"
    qSpecies: "Ligustrum lucidum :: Glossy Privet" => "Lophostemon confertus :: Brisbane Box"
    PlantDate: "" => "07/01/2021 12:00:00 AM"
    DBH: "" => "3"
    PermitNotes: "" => "Permit Number 781789"

  TreeID: 256319
    qAddress: "375 Stonecrest Dr" => "199X Broadmoor Dr"
    SiteOrder: "2" => "1"

  TreeID: 256784
    qSpecies: "Cedrus deodara :: Deodar Cedar" => "Tree(s) ::"
    PlantDate: "" => "07/20/2021 12:00:00 AM"
    DBH: "" => "3"
    PermitNotes: "" => "Permit Number 788668"

  TreeID: 258701
    qSpecies: "Tree(s) ::" => "Acer palmatum :: Japanese Maple"

  TreeID: 259357
    PlantDate: "05/25/2019 12:00:00 AM" => "09/23/2021 12:00:00 AM"

  TreeID: 259358
    PlantDate: "05/25/2019 12:00:00 AM" => "09/28/2021 12:00:00 AM"

  TreeID: 259361
    qSpecies: "Acer rubrum 'October Glory' :: Red October Glory Maple" => "Laurus nobilis :: Sweet Bay: Grecian Laurel"
    PlantDate: "05/25/2019 12:00:00 AM" => "10/26/2021 12:00:00 AM"

  TreeID: 259370
    PlantDate: "04/27/2019 12:00:00 AM" => "09/23/2021 12:00:00 AM"

  TreeID: 259371
    PlantDate: "04/27/2019 12:00:00 AM" => "09/23/2021 12:00:00 AM"

  TreeID: 259372
    PlantDate: "04/27/2019 12:00:00 AM" => "09/23/2021 12:00:00 AM"

  TreeID: 259374
    PlantDate: "04/27/2019 12:00:00 AM" => "09/28/2021 12:00:00 AM"

  TreeID: 260624
    SiteOrder: "1" => "3"

  TreeID: 260629
    qSpecies: "Ulmus 'Frontier' :: Frontier Elm" => "Olea europaea 'Fruitless' :: Fruitless Olive"
    PlantDate: "" => "06/25/2021 12:00:00 AM"
    DBH: "" => "3"
    PermitNotes: "" => "Permit Number 788609"

  TreeID: 261244
    PlantDate: "12/17/2019 12:00:00 AM" => ""

  TreeID: 261606
    qLegalStatus: "DPW Maintained" => "Section 806 (d)"
    qSpecies: "::" => "Ginkgo biloba :: Maidenhair Tree"
    PlantDate: "" => "06/21/2021 12:00:00 AM"
    DBH: "" => "3"

  TreeID: 26182
    qAddress: "490 Castro St" => "480 Castro St"
    SiteOrder: "1" => "4"

  TreeID: 26183
    qAddress: "490 Castro St" => "480 Castro St"
    SiteOrder: "2" => "3"
    PlantDate: "" => "09/14/2021 10:44:00 AM"
    DBH: "12" => "3"

  TreeID: 262425
    DBH: "" => "3"

  TreeID: 262426
    DBH: "" => "3"

  TreeID: 262427
    DBH: "" => "3"

  TreeID: 262528
    qSpecies: "Schinus terebinthifolius :: Brazilian Pepper" => "Magnolia grandiflora :: Southern Magnolia"

  TreeID: 26426
    qSpecies: "Pittosporum crassifolium :: Karo Tree" => "Platanus x hispanica :: Sycamore: London Plane"

  TreeID: 264729
    qLegalStatus: "Permitted Site" => "DPW Maintained"
    PlotSize: "" => "2x4"

  TreeID: 264789
    qSpecies: "Potential Site :: Potential Site" => "Lophostemon confertus :: Brisbane Box"
    PlantDate: "" => "07/30/2021 12:00:00 AM"
    DBH: "" => "3"

  TreeID: 264790
    qSpecies: "Potential Site :: Potential Site" => "Lophostemon confertus :: Brisbane Box"
    PlantDate: "" => "07/30/2021 12:00:00 AM"
    DBH: "" => "3"

  TreeID: 264791
    qSpecies: "Potential Site :: Potential Site" => "Lophostemon confertus :: Brisbane Box"
    PlantDate: "" => "07/30/2021 12:00:00 AM"
    DBH: "" => "3"

  TreeID: 265549
    PlantDate: "" => "03/30/2021 12:00:00 AM"
    DBH: "" => "3"

  TreeID: 265550
    PlantDate: "" => "03/30/2021 12:00:00 AM"
    DBH: "" => "3"

  TreeID: 265551
    PlantDate: "" => "03/30/2021 12:00:00 AM"
    DBH: "" => "3"

  TreeID: 265552
    PlantDate: "" => "03/30/2021 12:00:00 AM"
    DBH: "" => "3"

  TreeID: 265553
    PlantDate: "" => "03/30/2021 12:00:00 AM"
    DBH: "" => "3"

  TreeID: 265554
    PlantDate: "" => "03/30/2021 12:00:00 AM"
    DBH: "" => "3"

  TreeID: 265555
    PlantDate: "" => "03/30/2021 12:00:00 AM"
    DBH: "" => "3"

  TreeID: 265556
    PlantDate: "" => "03/30/2021 12:00:00 AM"
    DBH: "" => "3"

  TreeID: 265647
    PermitNotes: "" => "Permit Number 788256"

  TreeID: 265743
    SiteOrder: "" => "1"

  TreeID: 265763
    qLegalStatus: "DPW Maintained" => "Street Tree Maintenance Opt Out"
    PermitNotes: "" => "Permit Number 788785"

  TreeID: 265764
    qLegalStatus: "DPW Maintained" => "Street Tree Maintenance Opt Out"
    PermitNotes: "" => "Permit Number 788785"

  TreeID: 265765
    qLegalStatus: "DPW Maintained" => "Street Tree Maintenance Opt Out"
    PermitNotes: "" => "Permit Number 788785"

  TreeID: 265766
    qLegalStatus: "DPW Maintained" => "Street Tree Maintenance Opt Out"
    PermitNotes: "" => "Permit Number 788785"

  TreeID: 265783
    qSpecies: "Cedrus deodara :: Deodar Cedar" => "Tree(s) ::"
    PlantDate: "" => "07/02/2021 12:00:00 AM"
    DBH: "" => "3"
    PermitNotes: "" => "Permit Number 788580"

  TreeID: 265840
    PlantDate: "" => "06/30/2021 12:00:00 AM"
    DBH: "" => "3"
    PermitNotes: "" => "Permit Number 782207"

  TreeID: 265841
    PlantDate: "" => "06/30/2021 12:00:00 AM"
    DBH: "" => "3"
    PermitNotes: "" => "Permit Number 782207"

  TreeID: 265842
    PlantDate: "" => "06/30/2021 12:00:00 AM"
    DBH: "" => "3"
    PermitNotes: "" => "Permit Number 782207"

  TreeID: 265843
    PlantDate: "" => "06/30/2021 12:00:00 AM"
    DBH: "" => "3"
    PermitNotes: "" => "Permit Number 782207"

  TreeID: 265844
    PlantDate: "" => "06/30/2021 12:00:00 AM"
    DBH: "" => "3"
    PermitNotes: "" => "Permit Number 782207"

  TreeID: 265845
    PlantDate: "" => "06/30/2021 12:00:00 AM"
    DBH: "" => "3"
    PermitNotes: "" => "Permit Number 782207"

  TreeID: 265875
    PlantDate: "" => "06/21/2021 12:00:00 AM"
    DBH: "" => "3"
    PermitNotes: "" => "Permit Number 784708"

  TreeID: 265954
    qSpecies: "Pinus radiata :: Monterey Pine" => "Tree(s) ::"
    PlantDate: "" => "06/16/2021 12:00:00 AM"
    DBH: "" => "3"
    PermitNotes: "" => "Permit Number 788511"

  TreeID: 26627
    qLegalStatus: "Permitted Site" => "DPW Maintained"
    XCoord: "6011420.37467" => "6011424.18604"
    YCoord: "2093734.24789" => "2093729.7468"
    Latitude: "37.72963922465219" => "37.72962707840682"
    Longitude: "-122.40279455261944" => "-122.4027810598091"
    Location: "(37.72963922465219, -122.40279455261944)" => "(37.72962707840682, -122.4027810598091)"

  TreeID: 28646
    SiteOrder: "8" => "7"

  TreeID: 34225
    qLegalStatus: "DPW Maintained" => "Prune Opt Out"
    PermitNotes: "Permit Number 52249" => "Permit Number 788637"

  TreeID: 34517
    PlantDate: "07/17/1997 12:00:00 AM" => "09/01/2021 12:00:00 AM"
    DBH: "7" => "3"

  TreeID: 35352
    qSpecies: "Rhaphiolepis Majestic Beauty :: Indian Hawthorn  'Majestic Beau'" => "Olea europaea :: Olive Tree"

  TreeID: 39834
    PlantDate: "01/06/1999 12:00:00 AM" => "07/02/2021 12:00:00 AM"
    DBH: "1" => "3"

  TreeID: 42173
    PlantDate: "06/21/2000 12:00:00 AM" => "10/19/2021 12:00:00 AM"
    DBH: "11" => "3"

  TreeID: 43340
    PlantDate: "07/13/2000 12:00:00 AM" => "06/16/2021 12:00:00 AM"
    DBH: "8" => "3"

  TreeID: 43760
    qSpecies: "Schinus terebinthifolius :: Brazilian Pepper" => "Tree(s) ::"
    PlantDate: "07/26/2000 12:00:00 AM" => "07/02/2021 12:00:00 AM"
    DBH: "8" => "3"
    PermitNotes: "Permit Number 43395" => "Permit Number 788516"

  TreeID: 44396
    qSpecies: "Platanus occidentalis :: American sycamore" => "Lophostemon confertus :: Brisbane Box"
    PlantDate: "10/10/2017 01:07:00 PM" => "08/14/2021 12:00:00 AM"

  TreeID: 44399
    qLegalStatus: "DPW Maintained" => "Prune Opt Out"

  TreeID: 44400
    qLegalStatus: "DPW Maintained" => "Permitted Site"
    qSpecies: "Arbutus 'Marina' :: Hybrid Strawberry Tree" => "Tree(s) ::"
    PlantDate: "03/23/2001 12:00:00 AM" => "09/14/2021 12:00:00 AM"
    DBH: "12" => "3"
    PermitNotes: "Permit Number 43754" => "Permit Number 786647"

  TreeID: 47192
    qLegalStatus: "DPW Maintained" => "Street Tree Maintenance Opt Out"

  TreeID: 47193
    qLegalStatus: "DPW Maintained" => "Street Tree Maintenance Opt Out"

  TreeID: 49544
    qSpecies: "Prunus cerasifera :: Cherry Plum" => "Olea europaea :: Olive Tree"

  TreeID: 49871
    qAddress: "2519SCOTT Broadway" => "2519 Broadway"

  TreeID: 50162
    qAddress: "100@ GRO…
@simonw simonw closed this as completed Oct 22, 2021
@simonw
Copy link
Owner Author

simonw commented Oct 22, 2021

Wrote up how I fixed that rogue commit as a TIL: https://til.simonwillison.net/git/remove-commit-and-force-push

@simonw simonw added the enhancement New feature or request label Oct 22, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant