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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 108584 | 108584 | 8437 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1720X Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/2015 12:00:00 AM | 3 | 3X3 | Permit Number 774582 | 6003236.76685 | 2113929.6842 | 37.7846307428776 | -122.432528061255 | (37.7846307428776, -122.432528061255) |
| 103533 | 103533 | 12529 | Private 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 105 Lake St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | FUF 1 | 07/12/2004 12:00:00 AM | 6 | 3x3 | Permit Number 773769 | 5995136.95364 | 2114887.49287 | 37.78679797610221 | -122.460619935074 | (37.7867979761022, -122.460619935074) |
| 21253 | 21253 | 18474 | Permitted Site 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 73 | 1260 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/05/2015 12:00:00 AM | 3 | 0 | Permit Number 773798 | 6010545.83787 | 2101980.95756 | 37.752234043567206 | -122.406398781502 | (37.7522340435672, -122.406398781502) |
| 8180 | 8180 | 21666 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1765 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 4X4 | Permit Number 774582 | 6004178.5577 | 2114595.027 | 37.7865109691436 | -122.42931724201799 | (37.7865109691436, -122.429317242018) |
| 20639 | 20639 | 22907 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 250 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/07/2011 12:00:00 AM | 20 | 3x3 | Permit Number 767420 | 6006042.54291 | 2108252.09004 | 37.7692001550981 | -122.422417449121 | (37.7692001550981, -122.422417449121) |
| 171430 | 171430 | 30366 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 764 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 1 | Permit Number 38805 | 6013019.81503 | 2103473.1005 | 37.756469231694005 | -122.397947987108 | (37.756469231694, -122.397947987108) | |
| 51571 | 51571 | 30371 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 515 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | 6 | Permit Number 31120 | 6013002.357469999 | 2104627.1215 | 37.759636948818795 | -122.398089319161 | (37.7596369488188, -122.398089319161) | |
| 82807 | 82807 | 30377 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1701 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/08/1992 12:00:00 AM | Permit Number 31010 | 6012960.93819193 | 2104700.44987644 | 37.759835985409204 | -122.39823771351101 | (37.7598359854092, -122.398237713511) | ||
| 130293 | 130293 | 30380 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 732 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 12 | Permit Number 38802 | 6013003.98141 | 2103630.18764 | 37.7568996769083 | -122.39801376532 | (37.7568996769083, -122.39801376532) | |
| 61456 | 61456 | 30447 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 337 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 6 | Permit Number 43381 | 6011303.90393 | 2119683.69843 | 37.8008840523194 | -122.40502361014799 | (37.8008840523194, -122.405023610148) | |
| 114157 | 114157 | 30455 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 311 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1994 12:00:00 AM | Permit Number 104 | 6011427.19225713 | 2119702.8800107 | 37.8009436113771 | -122.404598329285 | (37.8009436113771, -122.404598329285) | ||
| 73688 | 73688 | 30472 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 524 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/02/1995 12:00:00 AM | 11 | 3x3 | Permit Number 119 | 6010416.9297 | 2119611.1498 | 37.8006352293469 | -122.408087810014 | (37.8006352293469, -122.408087810014) |
| 88005 | 88005 | 30508 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 363 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/1998 12:00:00 AM | Permit Number 40123 | 6009708.62861324 | 2092740.2698514 | 37.72681424554771 | -122.40864217293199 | (37.7268142455477, -122.408642172932) | ||
| 169855 | 169855 | 30511 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 440 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1995 12:00:00 AM | 7 | Permit Number 34524 | 6010611.16196 | 2106233.9432099997 | 37.763915445554105 | -122.40647253668699 | (37.7639154455541, -122.406472536687) | |
| 59605 | 59605 | 30514 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 340 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2000 12:00:00 AM | 22 | Permit Number 42913 | 6008785.20324 | 2113547.07327 | 37.783893261596 | -122.41330519888201 | (37.783893261596, -122.413305198882) | |
| 148399 | 148399 | 30516 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 375 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2000 12:00:00 AM | 7 | Permit Number 42914 | 6008644.40916 | 2113485.04991 | 37.783715054661705 | -122.413787907302 | (37.7837150546617, -122.413787907302) | |
| 94341 | 94341 | 30517 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 375 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/2000 12:00:00 AM | Permit Number 42914 | 6008641.14761203 | 2113482.39812883 | 37.783707590346204 | -122.41379900342599 | (37.7837075903462, -122.413799003426) | ||
| 47051 | 47051 | 30518 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 409 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2000 12:00:00 AM | 5 | Permit Number 34527 | 6008424.27484 | 2113452.8519200003 | 37.7836142820115 | -122.41454721209 | (37.7836142820115, -122.41454721209) | |
| 89964 | 89964 | 30519 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 411 Eddy St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1995 12:00:00 AM | Permit Number 34527 | 6008457.07910461 | 2113456.83135452 | 37.783627051473 | -122.41443400319599 | (37.783627051473, -122.414434003196) | ||
| 107382 | 107382 | 30520 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 411 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/23/2000 12:00:00 AM | Permit Number 34527 | 6008457.07910461 | 2113456.83135452 | 37.783627051473 | -122.41443400319599 | (37.783627051473, -122.414434003196) | ||
| 111593 | 111593 | 30521 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 411 Eddy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1995 12:00:00 AM | Permit Number 34527 | 6008457.07910461 | 2113456.83135452 | 37.783627051473 | -122.41443400319599 | (37.783627051473, -122.414434003196) | ||
| 183653 | 183653 | 30522 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 215 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1995 12:00:00 AM | 25 | Permit Number 34528 | 6008488.127169999 | 2112769.36057 | 37.781741165964704 | -122.414277931689 | (37.7817411659647, -122.414277931689) | |
| 75995 | 75995 | 30523 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 215 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1995 12:00:00 AM | 23 | Permit Number 34528 | 6008465.79864 | 2112766.79262 | 37.7817328607212 | -122.414354996407 | (37.7817328607212, -122.414354996407) | |
| 36120 | 36120 | 30524 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 161 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1995 12:00:00 AM | 7 | Permit Number 34529 | 6008071.29151 | 2113023.94527 | 37.7824167708541 | -122.415738023293 | (37.7824167708541, -122.415738023293) | |
| 115333 | 115333 | 30525 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 96 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/2005 12:00:00 AM | 10 | 3x3 | 6008672.39963745 | 2112539.12321188 | 37.7811193385199 | -122.41362414398701 | (37.7811193385199, -122.413624143987) | |
| 77733 | 77733 | 30527 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 142 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/09/1995 12:00:00 AM | Permit Number 34532 | 6008613.3918835 | 2112962.19179435 | 37.7822776699047 | -122.413858217761 | (37.7822776699047, -122.413858217761) | ||
| 141388 | 141388 | 30529 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 318 Leavenworth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/2005 12:00:00 AM | Permit Number 34533 | 6008529.5129024 | 2113563.57951959 | 37.7839242250739 | -122.414190964021 | (37.7839242250739, -122.414190964021) | ||
| 83616 | 83616 | 30531 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 100 20th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/1986 12:00:00 AM | 2 | 3x3 | Permit Number 34534 | 5989617.18715 | 2114630.7338900003 | 37.7857738797228 | -122.479698023599 | (37.7857738797228, -122.479698023599) |
| 18258 | 18258 | 30562 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1074 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 14 | Permit Number 38411 | 6008011.79259 | 2101700.97642 | 37.7513231949327 | -122.41514211632798 | (37.7513231949327, -122.415142116328) | |
| 20458 | 20458 | 30563 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1074 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 14 | Permit Number 38411 | 6008014.076330001 | 2101681.3139299997 | 37.7512693345126 | -122.415132827214 | (37.7512693345126, -122.415132827214) | |
| 119869 | 119869 | 30569 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 248 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1995 12:00:00 AM | Permit Number 34546 | 6003788.00361454 | 2109234.47759535 | 37.771770112694 | -122.430285874486 | (37.771770112694, -122.430285874486) | ||
| 121255 | 121255 | 30570 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 525 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1995 12:00:00 AM | 9 | Permit Number 34547 | 6003602.3977 | 2110192.9008 | 37.774391192641204 | -122.43099631245 | (37.7743911926412, -122.43099631245) | |
| 133523 | 133523 | 30571 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 175 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/04/1996 12:00:00 AM | 7 | Permit Number 37782 | 6003466.026380001 | 2108789.48044 | 37.7705300167765 | -122.431367842974 | (37.7705300167765, -122.431367842974) | |
| 34256 | 34256 | 30572 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 128 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1995 12:00:00 AM | 8 | Permit Number 34549 | 6004633.56138 | 2108812.47866 | 37.7706592637331 | -122.427330967069 | (37.7706592637331, -122.427330967069) | |
| 92514 | 92514 | 30573 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 164 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1995 12:00:00 AM | Permit Number 34550 | 6004481.83420946 | 2108792.73976924 | 37.7705964833806 | -122.42785438691001 | (37.7705964833806, -122.42785438691) | ||
| 162119 | 162119 | 30574 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 170 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1995 12:00:00 AM | 6 | Permit Number 34551 | 6004467.68034 | 2108789.06417 | 37.7705855903724 | -122.427903083363 | (37.7705855903724, -122.427903083363) | |
| 69045 | 69045 | 30575 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 262 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2001 12:00:00 AM | 9 | Permit Number 43817 | 6004015.932680001 | 2108728.78356 | 37.7703945078227 | -122.429461383638 | (37.7703945078227, -122.429461383638) | |
| 102404 | 102404 | 30577 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 398 Hermann St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1995 12:00:00 AM | Permit Number 34554 | 6003372.12986837 | 2108639.033429 | 37.7701116041764 | -122.43168188857099 | (37.7701116041764, -122.431681888571) | ||
| 70291 | 70291 | 30580 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 562 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1995 12:00:00 AM | 8 | Permit Number 34555 | 6003898.2777 | 2109747.6579 | 37.7731854257993 | -122.42994104161001 | (37.7731854257993, -122.42994104161) | |
| 136113 | 136113 | 30581 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 562 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1995 12:00:00 AM | 6 | Permit Number 34555 | 6003882.9857 | 2109746.0047 | 37.7731800204909 | -122.42999382068899 | (37.7731800204909, -122.429993820689) | |
| 44149 | 44149 | 30586 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 800 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1995 12:00:00 AM | 8 | Permit Number 34556 | 6002690.739 | 2109580.279 | 37.7726573855875 | -122.43410610481001 | (37.7726573855875, -122.43410610481) | |
| 40285 | 40285 | 30587 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 68 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1995 12:00:00 AM | 11 | Permit Number 34557 | 6002888.52611 | 2108685.82804 | 37.7702126667237 | -122.43335801118499 | (37.7702126667237, -122.433358011185) | |
| 20152 | 20152 | 30589 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 530 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1995 12:00:00 AM | 24 | 6x12 | Permit Number 34559 | 6003171.8807 | 2110158.6701 | 37.7742727998886 | -122.43248310501801 | (37.7742727998886, -122.432483105018) |
| 17116 | 17116 | 30590 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 530 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/09/1995 12:00:00 AM | 12 | 6x9 | Permit Number 34559 | 6003172.5389 | 2110146.1627 | 37.77423849498221 | -122.43247993465401 | (37.7742384949822, -122.432479934654) |
| 185754 | 185754 | 30598 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 66 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1995 12:00:00 AM | 12 | Permit Number 34565 | 6004323.10435 | 2108874.18954 | 37.7708111439393 | -122.428409241587 | (37.7708111439393, -122.428409241587) | |
| 19226 | 19226 | 30599 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 82 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1995 12:00:00 AM | 8 | 5x7 | Permit Number 34566 | 6004311.30995 | 2108965.65965 | 37.771061631219 | -122.428456559416 | (37.771061631219, -122.428456559416) |
| 125762 | 125762 | 30601 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 140 11th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | Permit Number 34568 | 6007766.12041799 | 2109892.83524287 | 37.7738023323227 | -122.416571913724 | (37.7738023323227, -122.416571913724) | ||
| 125796 | 125796 | 30602 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 140 11th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | Permit Number 34568 | 6007766.12041799 | 2109892.83524287 | 37.7738023323227 | -122.416571913724 | (37.7738023323227, -122.416571913724) | ||
| 105981 | 105981 | 30603 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 146 11th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | Permit Number 34569 | 6007781.17491897 | 2109877.16754304 | 37.7737601591827 | -122.41651872759199 | (37.7737601591827, -122.416518727592) | ||
| 140348 | 140348 | 30604 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 158 11th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | Permit Number 34570 | 6007811.28392093 | 2109845.83214339 | 37.773675812829794 | -122.416412355511 | (37.7736758128298, -122.416412355511) | ||
| 111859 | 111859 | 30605 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 158 11th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | Permit Number 34570 | 6007811.28392093 | 2109845.83214339 | 37.773675812829794 | -122.416412355511 | (37.7736758128298, -122.416412355511) | ||
| 124461 | 124461 | 30606 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 40 12th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | Permit Number 34571 | 6006862.94085785 | 2109917.12606637 | 37.773818193258 | -122.41969788695299 | (37.773818193258, -122.419697886953) | ||
| 142306 | 142306 | 30607 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 40 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 3x3 | Permit Number 34571 | 6006862.94085785 | 2109917.12606637 | 37.773818193258 | -122.41969788695299 | (37.773818193258, -122.419697886953) | |
| 92107 | 92107 | 30608 | Permitted Site 1 | Afrocarpus gracilior :: Fern Pine 70 | 40 12th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | Permit Number 34571 | 6006862.94085785 | 2109917.12606637 | 37.773818193258 | -122.41969788695299 | (37.773818193258, -122.419697886953) | ||
| 175099 | 175099 | 30609 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 365 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 16 | Permit Number 34572 | 6008561.72189 | 2108643.78999 | 37.770417459437496 | -122.41373142536501 | (37.7704174594375, -122.413731425365) | |
| 165051 | 165051 | 30610 | Permitted Site 1 | Melaleuca spp :: Melaleuca spp 130 | 130 Dore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 9 | Permit Number 34573 | 6009109.45338 | 2109560.9678 | 37.7729665590046 | -122.411901635954 | (37.7729665590046, -122.411901635954) | |
| 16083 | 16083 | 30613 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1286 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2016 12:00:00 AM | 3 | Permit Number 775151 | 6009246.0909 | 2109942.5257 | 37.774021892488 | -122.411455949977 | (37.774021892488, -122.411455949977) | |
| 117537 | 117537 | 30614 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | Permit Number 34576 | 6008169.65081501 | 2108823.23186566 | 37.7708881396338 | -122.415100307898 | (37.7708881396338, -122.415100307898) | ||
| 107582 | 107582 | 30615 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1600 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | Permit Number 34576 | 6008169.65081501 | 2108823.23186566 | 37.7708881396338 | -122.415100307898 | (37.7708881396338, -122.415100307898) | ||
| 146830 | 146830 | 30616 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1621 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 7 | Permit Number 34577 | 6008176.3922 | 2108702.7792 | 37.7705577837388 | -122.415068461945 | (37.7705577837388, -122.415068461945) | |
| 149670 | 149670 | 30617 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1625 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 5 | Permit Number 34579 | 6008161.857999999 | 2108672.7086 | 37.7704744001626 | -122.41511660718399 | (37.7704744001626, -122.415116607184) | |
| 56000 | 56000 | 30618 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1645 Folsom St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 5 | Permit Number 34580 | 6008139.305 | 2108622.0896 | 37.7703341448356 | -122.41519103466601 | (37.7703341448356, -122.415191034666) | |
| 62594 | 62594 | 30619 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 1645 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 4 | Permit Number 34580 | 6008146.3215 | 2108637.1249 | 37.7703758225592 | -122.41516782897499 | (37.7703758225592, -122.415167828975) | |
| 60127 | 60127 | 30620 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1645 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 9 | Permit Number 34580 | 6008131.7874 | 2108606.0519 | 37.7702896865902 | -122.415215902671 | (37.7702896865902, -122.415215902671) | |
| 80716 | 80716 | 30621 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2701 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38398 | 6007059.6868862 | 2102620.31016548 | 37.753793923292896 | -122.41849979623001 | (37.7537939232929, -122.41849979623) | ||
| 53824 | 53824 | 30624 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1655 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 7 | Permit Number 35324 | 6008124.7709 | 2108587.5084 | 37.7702383761626 | -122.41523885993 | (37.7702383761626, -122.41523885993) | |
| 16412 | 16412 | 30636 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1690 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2004 12:00:00 AM | 3 | 3x3 | Permit Number 47466 | 6008078.6625 | 2108652.1603 | 37.770413303673394 | -122.4154029268 | (37.7704133036734, -122.4154029268) |
| 155975 | 155975 | 30645 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 40 Isis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 19 | Permit Number 34587 | 6008284.75086 | 2108527.77481 | 37.7700833513812 | -122.414681260537 | (37.7700833513812, -122.414681260537) | |
| 103043 | 103043 | 30646 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 40 Isis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | Permit Number 34587 | 6008294.77147475 | 2108579.37432912 | 37.7702255945661 | -122.414650251323 | (37.7702255945661, -122.414650251323) | ||
| 56584 | 56584 | 30647 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 40 Isis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 22 | Permit Number 34587 | 6008282.2586 | 2108516.1513099996 | 37.770051295947496 | -122.414689058564 | (37.7700512959475, -122.414689058564) | |
| 14735 | 14735 | 30648 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 15 Lafayette St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 10 | 3x3 | Permit Number 34588 | 6007479.3068699995 | 2109694.71788 | 37.7732422146752 | -122.417550006149 | (37.7732422146752, -122.417550006149) |
| 53399 | 53399 | 30653 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 18 Lafayette St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/09/2002 12:00:00 AM | 5 | Permit Number 34589 | 6007410.65466 | 2109713.22327 | 37.7732891628947 | -122.417788795914 | (37.7732891628947, -122.417788795914) | |
| 125584 | 125584 | 30655 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 35 Lafayette St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 10 | 3x3 | Permit Number 34590 | 6007536.63957853 | 2109665.02696878 | 37.773163916329295 | -122.41734957960699 | (37.7731639163293, -122.417349579607) |
| 142130 | 142130 | 30656 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 35 Lafayette St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 10 | 3x3 | Permit Number 34590 | 6007536.63957853 | 2109665.02696878 | 37.773163916329295 | -122.41734957960699 | (37.7731639163293, -122.417349579607) |
| 107668 | 107668 | 30657 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 35 Lafayette St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 10 | 3x3 | Permit Number 34590 | 6007536.63957853 | 2109665.02696878 | 37.773163916329295 | -122.41734957960699 | (37.7731639163293, -122.417349579607) |
| 310 | 310 | 30658 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 47 Lafayette St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 6 | 3x3 | Permit Number 34591 | 6007577.417719999 | 2109608.9608 | 37.7730122661246 | -122.41720454865299 | (37.7730122661246, -122.417204548653) |
| 15769 | 15769 | 30659 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 54 Lafayette St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 34592 | 6007591.74325 | 2109572.72569 | 37.7729135790239 | -122.41715242667 | (37.7729135790239, -122.41715242667) |
| 31429 | 31429 | 30660 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 81 Lafayette St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/13/2004 12:00:00 AM | 4 | Permit Number 47724 | 6007698.39694 | 2109510.52201 | 37.772748781854794 | -122.41677909020201 | (37.7727487818548, -122.416779090202) | |
| 15792 | 15792 | 30661 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 83 Lafayette St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 8 | 3x3 | Permit Number 34594 | 6007673.53493 | 2109511.3804599997 | 37.7727497405427 | -122.416865151724 | (37.7727497405427, -122.416865151724) |
| 56201 | 56201 | 30662 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 McCoppin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2003 12:00:00 AM | 2 | Permit Number 46640 | 6006559.28152 | 2109117.66624 | 37.771605957578394 | -122.42069153050801 | (37.7716059575784, -122.420691530508) | |
| 177721 | 177721 | 30663 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 McCoppin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2003 12:00:00 AM | 3 | Permit Number 46640 | 6006564.909030001 | 2109121.1634 | 37.7716158771129 | -122.420672312891 | (37.7716158771129, -122.420672312891) | |
| 30093 | 30093 | 30664 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 McCoppin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2003 12:00:00 AM | 3 | Permit Number 46640 | 6006594.41261 | 2109123.24947 | 37.7716232677391 | -122.420570406196 | (37.7716232677391, -122.420570406196) | |
| 103263 | 103263 | 30665 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1 McCoppin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2003 12:00:00 AM | Permit Number 46640 | 6006663.15128516 | 2109148.64693366 | 37.7716968767803 | -122.42033443755 | (37.7716968767803, -122.42033443755) | ||
| 142462 | 142462 | 30666 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1 McCoppin St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2003 12:00:00 AM | Permit Number 46640 | 6006663.15128516 | 2109148.64693366 | 37.7716968767803 | -122.42033443755 | (37.7716968767803, -122.42033443755) | ||
| 141337 | 141337 | 30667 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 McCoppin St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | Permit Number 34595 | 6006663.15128516 | 2109148.64693366 | 37.7716968767803 | -122.42033443755 | (37.7716968767803, -122.42033443755) | ||
| 113758 | 113758 | 30668 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 McCoppin St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | Permit Number 34595 | 6006663.15128516 | 2109148.64693366 | 37.7716968767803 | -122.42033443755 | (37.7716968767803, -122.42033443755) | ||
| 168897 | 168897 | 30669 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 McCoppin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2003 12:00:00 AM | 2 | Permit Number 46640 | 6006474.54027 | 2109116.5589 | 37.7715981406638 | -122.42098457729999 | (37.7715981406638, -122.4209845773) | |
| 150139 | 150139 | 30670 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 33 McCoppin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2004 12:00:00 AM | 1 | Permit Number 47746 | 6006381.58873 | 2109111.27047 | 37.7715783798663 | -122.421305726983 | (37.7715783798663, -122.421305726983) | |
| 144523 | 144523 | 30672 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 39 McCoppin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/08/2003 12:00:00 AM | Permit Number 34597 | 6006368.06236527 | 2109117.19408355 | 37.7715938820876 | -122.421352936259 | (37.7715938820876, -122.421352936259) | ||
| 157187 | 157187 | 30673 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1018 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 7 | Permit Number 34598 | 6007663.01696 | 2109836.11415 | 37.77364079062939 | -122.416924546537 | (37.7736407906294, -122.416924546537) | |
| 97541 | 97541 | 30674 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1040 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/26/2005 12:00:00 AM | Permit Number 34599 | 6007565.37727332 | 2109755.15641274 | 37.77341300719829 | -122.417256559972 | (37.7734130071983, -122.417256559972) | ||
| 127539 | 127539 | 30676 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1040 Minna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 11 | 3x3 | Permit Number 34599 | 6007565.37727332 | 2109755.15641274 | 37.77341300719829 | -122.417256559972 | (37.7734130071983, -122.417256559972) |
| 157068 | 157068 | 30677 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 920 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 8 | Permit Number 34600 | 6008142.25986 | 2110035.66546 | 37.7742156570679 | -122.415280896104 | (37.7742156570679, -122.415280896104) | |
| 26674 | 26674 | 30678 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1035 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 9 | Permit Number 34601 | 6007763.45978 | 2109624.69043 | 37.77306592059371 | -122.41656211886499 | (37.7730659205937, -122.416562118865) | |
| 154076 | 154076 | 30679 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 170 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 9 | Permit Number 34602 | 6007305.02231 | 2108788.4597099996 | 37.7707440365283 | -122.41808862091699 | (37.7707440365283, -122.418088620917) | |
| 65090 | 65090 | 30681 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 405 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 19 | 6x4 | Permit Number 34603 | 6004611.85495 | 2109916.0887 | 37.7736882811098 | -122.427484684578 | (37.7736882811098, -122.427484684578) |
| 162433 | 162433 | 30682 | Permitted Site 1 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 425 Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 3 | Permit Number 772924 | 6004593.18284 | 2110062.14173 | 37.7740882510028 | -122.427559681752 | (37.7740882510028, -122.427559681752) | |
| 16951 | 16951 | 30683 | Permitted Site 1 | Schinus molle :: California Pepper 138 | 425 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/2014 12:00:00 AM | 3 | Permit Number 772924 | 6004598.67244 | 2110025.49511 | 37.773987938825 | -122.42753808091999 | (37.773987938825, -122.42753808092) | |
| 21171 | 21171 | 30684 | Permitted Site 1 | Schinus molle :: California Pepper 138 | 425 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/2014 12:00:00 AM | 3 | Permit Number 772924 | 6004595.56145 | 2110044.99198 | 37.7740412965118 | -122.427550231668 | (37.7740412965118, -122.427550231668) |
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");