Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1659 | 1659 | 251643 | Undocumented 2 | Tree(s) :: 17 | 2701 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6007328.0 | 2121670.0 | 37.8061148757045 | -122.418922903139 | (37.8061148757045, -122.418922903139) | |||
| 3387 | 3387 | 161273 | Undocumented 2 | Crataegus laevigata :: English Hawthorn 66 | 566 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 0 | Width 0ft | 6002889.180369999 | 2090346.5289900003 | 37.719857269085104 | -122.432045948864 | (37.7198572690851, -122.432045948864) | ||
| 3455 | 3455 | 160606 | Undocumented 2 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 745 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 0 | Width 0ft | 6002538.27018 | 2089198.0058799998 | 37.716683778298 | -122.43317690119301 | (37.716683778298, -122.433176901193) | ||
| 5176 | 5176 | 253818 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 219 Concord St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5999956.6131 | 2087048.59536 | 37.7106351918399 | -122.44194619318 | (37.7106351918399, -122.44194619318) | ||||
| 5256 | 5256 | 253838 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 1458 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5.5x4 | 5981900.0 | 2105162.0 | 37.759324170949604 | -122.505694672765 | (37.7593241709496, -122.505694672765) | |||
| 10027 | 10027 | 122385 | Undocumented 2 | Tree(s) :: 17 | 1642 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 778904 | 5990935.0 | 2104213.0 | 37.7572460781285 | -122.474378311379 | (37.7572460781285, -122.474378311379) | ||
| 10860 | 10860 | 104506 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 631 France Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 3x3 | 6002582.75614 | 2089515.1433 | 37.7175570910528 | -122.43304578096 | (37.7175570910528, -122.43304578096) | ||
| 13187 | 13187 | 106199 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2107 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4 | 3x4 | 5983225.8003 | 2100763.9337 | 37.74732624942661 | -122.500784246807 | (37.7473262494266, -122.500784246807) | ||
| 13559 | 13559 | 106005 | Undocumented 2 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 59 Reddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 3x3 | 6013632.51665 | 2093922.487 | 37.7302793593954 | -122.395160068985 | (37.7302793593954, -122.395160068985) | ||
| 13782 | 13782 | 121585 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 424 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 3x3 | 6013758.73818 | 2105099.18568 | 37.760975233543 | -122.395506429391 | (37.760975233543, -122.395506429391) | ||
| 19276 | 19276 | 108963 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2395x 15TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6001858.0 | 2107008.0 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | ||||
| 20943 | 20943 | 6386 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 205 Elsie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 3x3 | 6006831.93965 | 2097911.00568 | 37.7408504143285 | -122.418953412568 | (37.7408504143285, -122.418953412568) | ||
| 23887 | 23887 | 83255 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 790 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5983253.61867 | 2110435.38712 | 37.773882958787205 | -122.501403365431 | (37.7738829587872, -122.501403365431) | |||
| 26077 | 26077 | 98248 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 650 Eddy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 3x3 | I believe these were planted in 2010 by FUF. C.Buck | 6007281.495490001 | 2113344.84788 | 37.7832534614285 | -122.41849313956001 | (37.7832534614285, -122.41849313956) | |
| 27427 | 27427 | 109082 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 360 09th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 5993123.846940001 | 2113007.94423 | 37.7815212258156 | -122.46744802506399 | (37.7815212258156, -122.467448025064) | |||
| 28065 | 28065 | 84526 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1607 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 5985279.5041 | 2104240.0581 | 37.756991093889496 | -122.49393892942699 | (37.7569910938895, -122.493938929427) | |||
| 28970 | 28970 | 84365 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 129 Escolta Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 5986616.9958 | 2097211.3869 | 37.7377704195158 | -122.488796798517 | (37.7377704195158, -122.488796798517) | |||
| 30893 | 30893 | 81813 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1419 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 5988645.6741 | 2105641.5626 | 37.7610356250119 | -122.482400266833 | (37.7610356250119, -122.482400266833) | |||
| 31787 | 31787 | 121581 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 199X Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 3x3 | 6013754.46885 | 2106222.8302700003 | 37.764060277784 | -122.395599922908 | (37.764060277784, -122.395599922908) | ||
| 34385 | 34385 | 109079 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 360 09th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 8 | 5993122.1097099995 | 2113067.45423 | 37.7816845237935 | -122.46745836376999 | (37.7816845237935, -122.46745836377) | |||
| 36445 | 36445 | 106365 | Undocumented 2 | Podocarpus gracilor :: Fern Pine 13 | 1970 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 4x2 | 5981684.7966 | 2101671.2426 | 37.7497268716349 | -122.506180099858 | (37.7497268716349, -122.506180099858) | ||
| 38343 | 38343 | 122390 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1958 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x2 | 5991007.0 | 2102078.0 | 37.7513881006776 | -122.47397354599501 | (37.7513881006776, -122.473973545995) | |||
| 39790 | 39790 | 79264 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 180 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5989943.75827 | 2114181.74363 | 37.7845600440954 | -122.47853534669399 | (37.7845600440954, -122.478535346694) | |||
| 39825 | 39825 | 83498 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1840 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4 | 5987237.7366 | 2102721.865 | 37.752936928713495 | -122.48705521280199 | (37.7529369287135, -122.487055212802) | |||
| 41359 | 41359 | 80821 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 843 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 7 | 5988489.67822 | 2110248.9611400003 | 37.7736771996736 | -122.48327752702299 | (37.7736771996736, -122.483277527023) | |||
| 43230 | 43230 | 81651 | Undocumented 2 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1100@ 12th Ave Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6 | Permit Number 767881 | 5992197.33713 | 2110704.35062 | 37.7751426520596 | -122.470485452724 | (37.7751426520596, -122.470485452724) | ||
| 46325 | 46325 | 82058 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2663 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 5988935.079 | 2097218.8486 | 37.737925915904896 | -122.480782703185 | (37.7379259159049, -122.480782703185) | |||
| 46823 | 46823 | 114049 | Undocumented 2 | Betula spp :: Birch 95 | 1190 Shafter Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 3x3 | 6017122.5886 | 2092569.8305 | 37.7267587013694 | -122.38300019404801 | (37.7267587013694, -122.383000194048) | ||
| 47382 | 47382 | 84587 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2374 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 5981781.9237 | 2098926.9802 | 37.7421976095989 | -122.50564083146999 | (37.7421976095989, -122.50564083147) | |||
| 49381 | 49381 | 109083 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 360 09th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 9 | 5993121.9003800005 | 2112970.33483 | 37.7814178482518 | -122.46745202346001 | (37.7814178482518, -122.46745202346) | |||
| 50399 | 50399 | 83940 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 346 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 6002623.3428 | 2091444.05642 | 37.722855759877895 | -122.43304322866999 | (37.7228557598779, -122.43304322867) | |||
| 54494 | 54494 | 83988 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 51 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 6004863.63581 | 2090857.16015 | 37.7213710933771 | -122.425257258112 | (37.7213710933771, -122.425257258112) | |||
| 57301 | 57301 | 83542 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 875 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 19 | 5980747.696719999 | 2109761.67142 | 37.7718856460039 | -122.51002154176399 | (37.7718856460039, -122.510021541764) | |||
| 57867 | 57867 | 79130 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1293 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4 | 5987372.1815 | 2106509.2764 | 37.763343966061896 | -122.486868390866 | (37.7633439660619, -122.486868390866) | |||
| 59442 | 59442 | 80399 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1359 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4 | 5985221.9445 | 2105957.3134 | 37.7617028317997 | -122.494264562885 | (37.7617028317997, -122.494264562885) | |||
| 59855 | 59855 | 82988 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1345 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 6008577.18796 | 2110086.84492 | 37.7743806179076 | -122.41378001753701 | (37.7743806179076, -122.413780017537) | |||
| 59973 | 59973 | 82021 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1550 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 5987476.0557 | 2104733.3067 | 37.75847369503 | -122.48637873374099 | (37.75847369503, -122.486378733741) | |||
| 61360 | 61360 | 83419 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2379 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5988867.9747 | 2099162.5294 | 37.7432588555713 | -122.48115699763201 | (37.7432588555713, -122.481156997632) | |||
| 62195 | 62195 | 84689 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 3632 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 6002195.05393 | 2120739.39081 | 37.80326930438871 | -122.436619630107 | (37.8032693043887, -122.436619630107) | |||
| 65198 | 65198 | 82609 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 343 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 7 | 5990560.55724 | 2113091.75493 | 37.7816030289127 | -122.476321807103 | (37.7816030289127, -122.476321807103) | |||
| 65671 | 65671 | 78959 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2083 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5987558.9086 | 2101118.3339 | 37.748552784681 | -122.485826868551 | (37.748552784681, -122.485826868551) | |||
| 69699 | 69699 | 109081 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 360 09th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 8 | 5993122.61553 | 2113029.97254 | 37.7815816384713 | -122.46745388745701 | (37.7815816384713, -122.467453887457) | |||
| 69765 | 69765 | 83695 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2434 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 5986135.3818 | 2098661.4883 | 37.741723893319 | -122.49056860476601 | (37.741723893319, -122.490568604766) | |||
| 69848 | 69848 | 81662 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 563 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4 | 5991577.12734 | 2111607.04314 | 37.7775853186785 | -122.472696706975 | (37.7775853186785, -122.472696706975) | |||
| 70462 | 70462 | 81627 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 351 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 5990871.84274 | 2113035.63499 | 37.781466986417605 | -122.475240820306 | (37.7814669864176, -122.475240820306) | |||
| 70536 | 70536 | 83955 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 55 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4 | 6005194.32236 | 2092948.4396799998 | 37.7271319660671 | -122.42426282649099 | (37.7271319660671, -122.424262826491) | |||
| 71159 | 71159 | 84446 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 901 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6 | 6000457.5617 | 2112125.7689 | 37.77951966026271 | -122.442013625663 | (37.7795196602627, -122.442013625663) | |||
| 74615 | 74615 | 78962 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 2324 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6 | 6000164.38759 | 2119919.6080400003 | 37.8009027932886 | -122.443587870495 | (37.8009027932886, -122.443587870495) | |||
| 79710 | 79710 | 84511 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 670 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 3x3 | 6002290.0 | 2089910.0 | 37.7186246694004 | -122.434085914673 | (37.7186246694004, -122.434085914673) | ||
| 82474 | 82474 | 108629 | Undocumented 2 | :: 54 | 82-98X Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6002862.02202 | 2108710.63631 | 37.7702792804688 | -122.433451461668 | (37.7702792804688, -122.433451461668) | |||
| 83043 | 83043 | 108962 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2395x 15TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6001858.0 | 2107008.0 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | ||||
| 83081 | 83081 | 111955 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 49 Seacliff Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10 | 5987872.34655427 | 2115783.06288074 | 37.78883633031629 | -122.48581921103799 | (37.7888363303163, -122.485819211038) | |||
| 83734 | 83734 | 121582 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 199X Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | 6013716.0 | 2106401.0 | 37.764547352750604 | -122.39574546120899 | (37.7645473527506, -122.395745461209) | |||
| 83803 | 83803 | 98247 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 650 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | I think these were planted in 2010 by FUF. | 6007271.2 | 2113371.6 | 37.783326336649 | -122.41853065554 | (37.783326336649, -122.41853065554) | ||
| 88381 | 88381 | 108965 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2395x 15TH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6001858.0 | 2107008.0 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | ||||
| 94644 | 94644 | 109077 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 360 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5993247.8 | 2113128.2 | 37.7818585707794 | -122.467027956142 | (37.7818585707794, -122.467027956142) | ||||
| 98605 | 98605 | 110268 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 282 28th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 14 | 3x3 | 6004065.51901322 | 2099574.2006491 | 37.745261000615294 | -122.428637192649 | (37.7452610006153, -122.428637192649) | ||
| 102413 | 102413 | 108826 | Undocumented 2 | :: 54 | 146-150X Gillette Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6013072.89275 | 2086799.9167400002 | 37.7106910734067 | -122.39659568235001 | (37.7106910734067, -122.39659568235) | ||||
| 110078 | 110078 | 108964 | Undocumented 2 | Ficus microcarpa :: Chinese Banyan 94 | 2395x 15TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6001858.0 | 2107008.0 | 37.7655472468341 | -122.436802461881 | (37.7655472468341, -122.436802461881) | ||||
| 112953 | 112953 | 118305 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 399X Willard St North | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5996275.15044137 | 2110427.69020243 | 37.774617956047294 | -122.456359464233 | (37.7746179560473, -122.456359464233) | ||||
| 115978 | 115978 | 108771 | Undocumented 2 | :: 54 | 500X Lathrop Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | ||||
| 117204 | 117204 | 103694 | Undocumented 2 | Tree(s) :: 17 | 1867 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 3x3 | 5993101.5 | 2102776.7 | 37.753427650109295 | -122.46678136639 | (37.7534276501093, -122.46678136639) | ||
| 122059 | 122059 | 108765 | Undocumented 2 | :: 54 | 500X Lathrop Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6012750.2 | 2086624.6 | 37.7101917236901 | -122.397698699654 | (37.7101917236901, -122.397698699654) | ||||
| 123589 | 123589 | 103670 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 4428-4430 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 3x3 | Permit Number 770987 | 6000065.0 | 2105781.0 | 37.7620761444221 | -122.44291590806401 | (37.7620761444221, -122.442915908064) | |
| 124295 | 124295 | 118306 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 399X Willard St North | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5996275.15044137 | 2110427.69020243 | 37.774617956047294 | -122.456359464233 | (37.7746179560473, -122.456359464233) | ||||
| 133689 | 133689 | 84536 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 124 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 6 | 5988694.18379 | 2114506.16667 | 37.7853781914991 | -122.482882183887 | (37.7853781914991, -122.482882183887) | |||
| 133734 | 133734 | 119275 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 350 Jackson St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 3x3 | 6012236.75747 | 2118139.41245 | 37.7966959176338 | -122.40168691852 | (37.7966959176338, -122.40168691852) | ||
| 134586 | 134586 | 78989 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2319 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5988235.2891 | 2099507.8812 | 37.7441702991504 | -122.483369943638 | (37.7441702991504, -122.483369943638) | |||
| 135908 | 135908 | 83938 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2518 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5986775.0522 | 2098100.4905 | 37.740220885396 | -122.48831564909099 | (37.740220885396, -122.488315649091) | |||
| 140112 | 140112 | 98246 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 650 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | I think these were planted by FUF in 2010. C.Buck | 6007271.2 | 2113371.6 | 37.783326336649 | -122.41853065554 | (37.783326336649, -122.41853065554) | ||
| 144866 | 144866 | 99251 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1999X Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 3x3 | 5998316.3 | 2109969.5 | 37.7734768483436 | -122.44926573693998 | (37.7734768483436, -122.44926573694) | ||
| 150080 | 150080 | 93910 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 2690 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 16 | 3x3 | 6001101.2138 | 2114914.769 | 37.7872141986511 | -122.439986998855 | (37.7872141986511, -122.439986998855) | ||
| 154737 | 154737 | 79125 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 825-875 La Playa | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11 | 4x4 | 5980734.99741 | 2110066.24575 | 37.772721168522295 | -122.51008810063601 | (37.7727211685223, -122.510088100636) | ||
| 159094 | 159094 | 109084 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 360 09th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 17 | 5993121.03742 | 2112948.65717 | 37.78135827747111 | -122.467453432024 | (37.7813582774711, -122.467453432024) | |||
| 159990 | 159990 | 84515 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2626 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 5984786.4387 | 2096844.8835 | 37.73665709999079 | -122.49509880737101 | (37.7366570999908, -122.495098807371) | |||
| 162279 | 162279 | 98249 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 650 Eddy St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 3x3 | I believe these were planted in 2010 by FUF. | 6007258.637490001 | 2113341.44217 | 37.783242823338796 | -122.418571977707 | (37.7832428233388, -122.418571977707) | |
| 162757 | 162757 | 83261 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2845 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 5985858.0832 | 2096114.3937 | 37.7347140487015 | -122.491339973082 | (37.7347140487015, -122.491339973082) | |||
| 163267 | 163267 | 83315 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2772 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 5985277.8232 | 2096355.5717 | 37.735342335532295 | -122.493363864082 | (37.7353423355323, -122.493363864082) | |||
| 170630 | 170630 | 83694 | Undocumented 2 | Prunus ilicifoia :: Holly-leaved Cherry 353 | 2455 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 5987336.2715 | 2098572.6525 | 37.7415500456995 | -122.486409860339 | (37.7415500456995, -122.486409860339) | |||
| 174137 | 174137 | 84659 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 187 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 5996845.0781 | 2111686.6666 | 37.7781074773999 | -122.45447894833201 | (37.7781074773999, -122.454478948332) | |||
| 175726 | 175726 | 117338 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 364 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 24 | 6x7 | 6006121.81566 | 2111101.2962700003 | 37.7770278622883 | -122.42234571558201 | (37.7770278622883, -122.422345715582) | ||
| 177498 | 177498 | 83768 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2207 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 5986660.4861 | 2100216.6072 | 37.7460244920213 | -122.488867282426 | (37.7460244920213, -122.488867282426) | |||
| 177747 | 177747 | 109080 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 360 09th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 8 | 5993120.9106 | 2113052.2781700003 | 37.7816427852337 | -122.46746140817301 | (37.7816427852337, -122.467461408173) | |||
| 179201 | 179201 | 81193 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1367 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5 | 5985222.59 | 2105907.6105 | 37.7615663992774 | -122.494258666726 | (37.7615663992774, -122.494258666726) | |||
| 179909 | 179909 | 109078 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 360 09th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 9 | 5993118.36836 | 2113092.87816 | 37.7817541149895 | -122.467473156324 | (37.7817541149895, -122.467473156324) | |||
| 180063 | 180063 | 83723 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2215 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 5986042.1421 | 2100161.1312 | 37.7458360633129 | -122.491001322638 | (37.7458360633129, -122.491001322638) | |||
| 180505 | 180505 | 79189 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2266 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 5988574.1949 | 2099905.7282 | 37.745282400553 | -122.482227237552 | (37.745282400553, -122.482227237552) | |||
| 180534 | 180534 | 80675 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 245 Silliman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3 | 6009985.12224 | 2094065.2976 | 37.7304679742101 | -122.407779728251 | (37.7304679742101, -122.407779728251) | |||
| 182506 | 182506 | 83202 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 405 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4 | 5987450.31295 | 2113217.36399 | 37.7817670537285 | -122.487090859235 | (37.7817670537285, -122.487090859235) | |||
| 183647 | 183647 | 80237 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1675 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 5985295.5529 | 2103816.7715 | 37.7558298048279 | -122.49385223473601 | (37.7558298048279, -122.493852234736) | |||
| 185122 | 185122 | 84071 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1639 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 4 | 5986834.2299 | 2104106.3182 | 37.756714724552104 | -122.488552342602 | (37.7567147245521, -122.488552342602) | |||
| 189011 | 189011 | 80586 | Undocumented 2 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1919 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 2 | 5985971.2412 | 2102145.8827 | 37.7512815105045 | -122.49139254176599 | (37.7512815105045, -122.491392541766) | |||
| 94236 | 94236 | 83699 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 52 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2013 12:00:00 AM | 4 | 3x3 | Permit Number 769773 | 6002629.0 | 2105596.0 | 37.76171402608121 | -122.434034805509 | (37.7617140260812, -122.434034805509) |
| 131526 | 131526 | 78188 | Undocumented 2 | Celtis sinensis :: Chinese Hackberry 111 | 61 University St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2002 12:00:00 AM | 5 | 6007814.1581 | 2093767.18412 | 37.7295276448871 | -122.415263990666 | (37.7295276448871, -122.415263990666) | ||
| 132672 | 132672 | 69750 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 805 University St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2002 12:00:00 AM | 10 | 6008877.581730001 | 2090316.9331 | 37.720113693661496 | -122.411343969962 | (37.7201136936615, -122.411343969962) | ||
| 169130 | 169130 | 79549 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 206 Gambier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2002 12:00:00 AM | 1 | 6005878.19097 | 2092769.79945 | 37.7266800504424 | -122.421886012749 | (37.7266800504424, -122.421886012749) | ||
| 24726 | 24726 | 72266 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 359 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 12 | 6002393.10905 | 2091502.19798 | 37.7230023412585 | -122.43384325116999 | (37.7230023412585, -122.43384325117) | ||
| 28751 | 28751 | 72246 | Undocumented 2 | Liquidambar styraciflua :: American Sweet Gum 62 | 418 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 6 | 6002360.66039 | 2091027.7988900002 | 37.721697906115104 | -122.433921526363 | (37.7216979061151, -122.433921526363) | ||
| 32068 | 32068 | 72263 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 350 Paris St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 8 | 6002374.01007 | 2091556.78865 | 37.723151151179295 | -122.43391317255899 | (37.7231511511793, -122.433913172559) | ||
| 34766 | 34766 | 72249 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 327 London St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1996 12:00:00 AM | 7 | 6002262.973180001 | 2091806.41787 | 37.723830275124705 | -122.434314843048 | (37.7238302751247, -122.434314843048) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");