Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: qLegalStatus
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6 | 6 | 141566 | Permitted Site 1 | Myoporum laetum :: Myoporum 1 | 501X Baker St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6000587.8822 | 2110733.5952 | 37.7757045307049 | -122.441462866076 | (37.7757045307049, -122.441462866076) | |||
| 31 | 31 | 22614 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x5 | 6005426.7391 | 2112695.1691 | 37.781365013820206 | -122.424863625752 | (37.7813650138202, -122.424863625752) | |||
| 33 | 33 | 2889 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1545 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3X3 | 6006951.47041 | 2116025.01423 | 37.79059395549061 | -122.419825138035 | (37.7905939554906, -122.419825138035) | |||
| 45 | 45 | 27522 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3201 California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 5998967.7443 | 2114917.3257 | 37.787099536792 | -122.44736849888001 | (37.787099536792, -122.44736849888) | |||
| 55 | 55 | 2909 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1700 California St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 4X4 | 6006037.49643 | 2115968.63965 | 37.7903876339283 | -122.422983431149 | (37.7903876339283, -122.422983431149) | |||
| 56 | 56 | 27602 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 988 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 4X4 | 6003218.3377 | 2111393.5053 | 37.7776659856505 | -122.432410615738 | (37.7776659856505, -122.432410615738) | |||
| 75 | 75 | 138824 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 729 GROVE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6004305.1004 | 2111150.1162 | 37.77705926326529 | -122.428633779399 | (37.7770592632653, -122.428633779399) | |||
| 85 | 85 | 22613 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1001 Turk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 3x5 | 6005358.7073 | 2112686.5825 | 37.7813375942673 | -122.42509837168001 | (37.7813375942673, -122.42509837168) | |||
| 87 | 87 | 11032 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1500 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 70 | 3X3 | 6007492.86428 | 2117507.22815 | 37.794694232707 | -122.41805706457599 | (37.794694232707, -122.418057064576) | |||
| 111 | 111 | 7749 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 400X Franklin St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3X3 | 6006371.15759 | 2111615.2483900003 | 37.7784531123456 | -122.421519673008 | (37.7784531123456, -122.421519673008) | |||
| 113 | 113 | 183695 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1341 42nd Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983048.7244 | 2105854.1384 | 37.7612921278024 | -122.50177309900499 | (37.7612921278024, -122.501773099005) | |||
| 115 | 115 | 6964 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 700 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 6003997.6735 | 2110460.7643 | 37.7751490695403 | -122.42964808764499 | (37.7751490695403, -122.429648087645) | |||
| 116 | 116 | 26163 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 220 Richardson Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999083.87135 | 2119853.9919 | 37.8006609458028 | -122.447322173097 | (37.8006609458028, -122.447322173097) | |||
| 122 | 122 | 183689 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1341 42nd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5983043.6112 | 2105976.497 | 37.761627789464704 | -122.501799836383 | (37.7616277894647, -122.501799836383) | |||
| 132 | 132 | 116641 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 270 Brannan St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 1 | 4x4 | 6015158.0 | 2112983.0 | 37.782700175280794 | -122.39121805332199 | (37.7827001752808, -122.391218053322) | |||
| 157 | 157 | 3193 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3698 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 5996969.37189 | 2114704.2549799997 | 37.7864001056199 | -122.454266992435 | (37.7864001056199, -122.454266992435) | |||
| 180 | 180 | 18700 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 100X Richardson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5999457.6873699995 | 2119517.78462 | 37.799759164102895 | -122.44600442526199 | (37.7997591641029, -122.446004425262) | |||
| 194 | 194 | 138802 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2375 PINE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6002539.8455 | 2115065.9469 | 37.787711085766894 | -122.435020465254 | (37.7877110857669, -122.435020465254) | |||
| 203 | 203 | 134565 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 15 | Width 4ft | 6007431.26589 | 2111583.6583 | 37.7784260904314 | -122.41785010990299 | (37.7784260904314, -122.417850109903) | |||
| 205 | 205 | 134566 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 99 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 14 | Width 4ft | 6007493.55732 | 2111589.9734900002 | 37.7784469358085 | -122.417635067622 | (37.7784469358085, -122.417635067622) | |||
| 206 | 206 | 4750 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1201 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 6007660.31382 | 2121409.3470799997 | 37.8054178953714 | -122.417754386066 | (37.8054178953714, -122.417754386066) | |||
| 229 | 229 | 138803 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2375 PINE ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6002563.9496 | 2115068.4842 | 37.787719421164496 | -122.434937251329 | (37.7877194211645, -122.434937251329) | |||
| 232 | 232 | 2726 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2211 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002817.4873 | 2114756.5606 | 37.7868773504916 | -122.43403775447099 | (37.7868773504916, -122.434037754471) | |||
| 312 | 312 | 226557 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 320 Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 7ft | 6004833.37225 | 2106401.74543 | 37.7640512674875 | -122.42646813862 | (37.7640512674875, -122.42646813862) | |||
| 318 | 318 | 142205 | Permitted Site 1 | Tree(s) :: 17 | 1683 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | Permit Number 779644 | 5999834.1012 | 2110180.6204 | 37.774143230926 | -122.44403063203698 | (37.774143230926, -122.444030632037) | ||
| 386 | 386 | 2602 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1760 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6005112.3923 | 2115130.7833 | 37.7880348455319 | -122.42612455857201 | (37.7880348455319, -122.426124558572) | |||
| 407 | 407 | 248462 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 130 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | Permit Number 779787 | 5997458.097999999 | 2107812.3026 | 37.767504613553 | -122.45207869525 | (37.767504613553, -122.45207869525) | ||
| 408 | 408 | 23369 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1350 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 4x4 | 6006387.07969 | 2115184.64805 | 37.788254707334 | -122.421718185767 | (37.788254707334, -122.421718185767) | |||
| 414 | 414 | 17191 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1804X Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4X4 | 6004806.1465 | 2115088.0891 | 37.7879003042654 | -122.427181073064 | (37.7879003042654, -122.427181073064) | |||
| 422 | 422 | 23174 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 240 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 5 | 3x3 | 6006908.21847 | 2111432.04348 | 37.777980343250796 | -122.419648771078 | (37.7779803432508, -122.419648771078) | |||
| 435 | 435 | 95185 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401X Divisadero St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6001223.4102 | 2113260.1588 | 37.78267801898829 | -122.43944557401699 | (37.7826780189883, -122.439445574017) | |||
| 442 | 442 | 9602 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1355 Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6003083.4108 | 2112017.0963 | 37.779370559175206 | -122.432921935155 | (37.7793705591752, -122.432921935155) | |||
| 468 | 468 | 18829 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 1940 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4.5x4.5 | 6005473.09052 | 2116220.8866 | 37.791048376629 | -122.42495419379601 | (37.791048376629, -122.424954193796) | |||
| 488 | 488 | 2821 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1100X California St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6008831.67633 | 2116355.92064 | 37.7916082855564 | -122.41334312239701 | (37.7916082855564, -122.413343122397) | |||
| 510 | 510 | 7848 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 885 Franklin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4X4 | 6006120.7355 | 2113033.04101 | 37.7823319018231 | -122.422486748168 | (37.7823319018231, -122.422486748168) | |||
| 534 | 534 | 2998 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2314 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6003265.59996 | 2115577.92692 | 37.7891580349704 | -122.43254607984501 | (37.7891580349704, -122.432546079845) | |||
| 542 | 542 | 224353 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3024 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 6006632.75905 | 2106740.0972599997 | 37.7650818572521 | -122.42026859194901 | (37.7650818572521, -122.420268591949) | |||
| 548 | 548 | 18094 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 3001 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5999514.29 | 2114642.3727 | 37.786375803755895 | -122.445457799993 | (37.7863758037559, -122.445457799993) | |||
| 550 | 550 | 3006 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2380 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 75 | 3X3 | 6002989.49365 | 2115542.57517 | 37.7890453067372 | -122.433498845012 | (37.7890453067372, -122.433498845012) | |||
| 564 | 564 | 222895 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 3080 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | Permit Number 27054 | 6006273.18784 | 2106724.0940099997 | 37.765017648370105 | -122.42151112584801 | (37.7650176483701, -122.421511125848) | ||
| 570 | 570 | 22578 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Turk St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006396.3025 | 2112828.5224900004 | 37.7817858856438 | -122.421518877095 | (37.7817858856438, -122.421518877095) | |||
| 577 | 577 | 15499 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2704 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006991.0 | 2102555.0 | 37.7536107294676 | -122.41873270043001 | (37.7536107294676, -122.41873270043) | |||
| 579 | 579 | 2702 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2121 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003192.7078 | 2114808.0993 | 37.7870401500361 | -122.432743262211 | (37.7870401500361, -122.432743262211) | |||
| 583 | 583 | 7548 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2882 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 5x5 | 6008321.80095 | 2101666.80438 | 37.751246783135 | -122.414067651319 | (37.751246783135, -122.414067651319) | |||
| 589 | 589 | 26916 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1901 Geary Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6002555.1851 | 2113680.9302 | 37.783909052953 | -122.43486830704398 | (37.783909052953, -122.434868307044) | |||
| 598 | 598 | 22577 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Turk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006373.00538 | 2112825.1930299997 | 37.7817754301315 | -122.421599237822 | (37.7817754301315, -122.421599237822) | |||
| 602 | 602 | 15498 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2704 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6007015.1629 | 2102569.9783 | 37.7536532168709 | -122.41865020170799 | (37.7536532168709, -122.418650201708) | |||
| 612 | 612 | 23503 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2550 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005820.29029 | 2119236.56275 | 37.7993482683535 | -122.42396743424999 | (37.7993482683535, -122.42396743425) | |||
| 630 | 630 | 20157 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1100X Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 4X4 | 6002895.0285 | 2112125.5503 | 37.7796576600117 | -122.433581380876 | (37.7796576600117, -122.433581380876) | |||
| 670 | 670 | 13108 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1557 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3x3 | 6004929.5061 | 2119810.12 | 37.80087277869679 | -122.427090735634 | (37.8008727786968, -122.427090735634) | |||
| 684 | 684 | 24323 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 600X Golden Gate Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006332.380890001 | 2112512.31586 | 37.7809140549901 | -122.42171754994101 | (37.7809140549901, -122.421717549941) | |||
| 687 | 687 | 13252 | Permitted Site 1 | Tristania conferta :: 79 | 2395 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3X3 | 6001005.1632 | 2119265.163 | 37.7991537757264 | -122.440631471061 | (37.7991537757264, -122.440631471061) | |||
| 706 | 706 | 2833 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1200 California St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6008452.59238 | 2116301.4374700002 | 37.7914373972624 | -122.41465089583099 | (37.7914373972624, -122.414650895831) | |||
| 718 | 718 | 99173 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2100 Webster St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | Permit Number 25928 | 6003311.25259 | 2116120.54401 | 37.790650512059 | -122.432426898975 | (37.790650512059, -122.432426898975) | ||
| 728 | 728 | 2813 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1075 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2X2 | 6009225.04881 | 2116342.3210299998 | 37.7915930222591 | -122.41198109107599 | (37.7915930222591, -122.411981091076) | |||
| 776 | 776 | 196857 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 487 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010733.79239 | 2111871.68352 | 37.7794022433647 | -122.406445673949 | (37.7794022433647, -122.406445673949) | |||
| 823 | 823 | 13156 | Permitted Site 1 | Tristania conferta :: 79 | 1875 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6003411.9498 | 2119598.2407 | 37.800205081624604 | -122.432326975222 | (37.8002050816246, -122.432326975222) | |||
| 847 | 847 | 107475 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1099x Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5999355.4 | 2109104.7 | 37.77116170781979 | -122.445609151717 | (37.7711617078198, -122.445609151717) | |||
| 872 | 872 | 5299 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1635 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6001101.8528 | 2114070.3216 | 37.7848955998057 | -122.43992421757 | (37.7848955998057, -122.43992421757) | |||
| 884 | 884 | 20233 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1724 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6002600.0088 | 2114219.702 | 37.785390928556396 | -122.43475177403499 | (37.7853909285564, -122.434751774035) | |||
| 888 | 888 | 14525 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 638 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5999197.0779 | 2110617.9064 | 37.7753075467631 | -122.44626566212901 | (37.7753075467631, -122.446265662129) | |||
| 897 | 897 | 22581 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Turk St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006522.42636 | 2112846.04587 | 37.7818411112169 | -122.42108379139799 | (37.7818411112169, -122.421083791398) | |||
| 910 | 910 | 7954 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1756 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3X3 | 6005736.45543 | 2116153.36588 | 37.7908778543671 | -122.424038156058 | (37.7908778543671, -122.424038156058) | |||
| 917 | 917 | 8555 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2141 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Mayor Office of Housing 7 | 18 | 3X3 | 6001312.669 | 2113446.883 | 37.7831957953331 | -122.43915016448999 | (37.7831957953331, -122.43915016449) | |||
| 921 | 921 | 30278 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 128 | ||||||||||
| 932 | 932 | 7693 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 581 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6008532.7031 | 2121045.4305 | 37.804467726204 | -122.41470958714899 | (37.804467726204, -122.414709587149) | |||
| 943 | 943 | 17376 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1600 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | Property owner contact Achmed 821-1594. | 6014810.6051199995 | 2095342.4042099998 | 37.7342436096391 | -122.391186437905 | (37.7342436096391, -122.391186437905) | ||
| 946 | 946 | 23565 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2958 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 2X2 | 6005634.29929 | 2120573.5209 | 37.8030087114389 | -122.424706189543 | (37.8030087114389, -122.424706189543) | |||
| 997 | 997 | 95184 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401X Divisadero St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6001220.026000001 | 2113275.7262 | 37.7827205704951 | -122.439458398161 | (37.7827205704951, -122.439458398161) | |||
| 1009 | 1009 | 223537 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 1300 Noe St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 5ft | 6003218.0959 | 2100594.3408 | 37.7480140720016 | -122.431640256605 | (37.7480140720016, -122.431640256605) | |||
| 1040 | 1040 | 7083 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1790 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 5998868.4415 | 2109744.0912 | 37.772889499766606 | -122.447339580133 | (37.7728894997666, -122.447339580133) | |||
| 1049 | 1049 | 110158 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1061 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 775265 | 6008518.81141 | 2118257.36351 | 37.7968116091339 | -122.41456024686501 | (37.7968116091339, -122.414560246865) | ||
| 1058 | 1058 | 19026 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 3173 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 5999643.72529 | 2115362.65802 | 37.78836090738071 | -122.44506178917 | (37.7883609073807, -122.44506178917) | |||
| 1064 | 1064 | 7177 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 827 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6003463.7289 | 2111198.6401 | 37.7771448458144 | -122.431547809387 | (37.7771448458144, -122.431547809387) | |||
| 1089 | 1089 | 9603 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1355 Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6003102.1679 | 2112019.7759 | 37.7793789805584 | -122.43285723801 | (37.7793789805584, -122.43285723801) | |||
| 1115 | 1115 | 2987 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2266X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6003539.7936 | 2115618.85396 | 37.7892859554236 | -122.431600327591 | (37.7892859554236, -122.431600327591) | |||
| 1118 | 1118 | 26811 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1850 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6001133.0786 | 2112143.4834 | 37.7796067716282 | -122.43967800032301 | (37.7796067716282, -122.439678000323) | |||
| 1129 | 1129 | 251457 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 758 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001327.0 | 2092594.0 | 37.7259396258956 | -122.437606717792 | (37.7259396258956, -122.437606717792) | ||||
| 1136 | 1136 | 3286 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 4620 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5993188.57682 | 2114188.1560400003 | 37.784765502430794 | -122.467309935148 | (37.7847655024308, -122.467309935148) | |||
| 1150 | 1150 | 246081 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1390 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 0ft | 5999109.7278 | 2108387.5264 | 37.769178502070204 | -122.44640733565201 | (37.7691785020702, -122.446407335652) | |||
| 1154 | 1154 | 246084 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1390 Waller St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5999058.5497 | 2108380.2585 | 37.7691556230859 | -122.446583834228 | (37.7691556230859, -122.446583834228) | |||
| 1164 | 1164 | 246083 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1390 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5999078.2336 | 2108382.6812 | 37.7691633995354 | -122.446515923307 | (37.7691633995354, -122.446515923307) | |||
| 1172 | 1172 | 143012 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 336 LOMBARD ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6010686.887999999 | 2120692.5302 | 37.803619545603205 | -122.40722991099 | (37.8036195456032, -122.40722991099) | |||
| 1176 | 1176 | 246082 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1390 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5999092.1637 | 2108384.801 | 37.7691700156221 | -122.44646789257601 | (37.7691700156221, -122.446467892576) | |||
| 1198 | 1198 | 3004 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2361 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6003049.1023 | 2115481.5645 | 37.788881168762295 | -122.433288245694 | (37.7888811687623, -122.433288245694) | |||
| 1300 | 1300 | 14826 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1269 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6003119.6747 | 2111677.9775 | 37.7784414803533 | -122.432772251133 | (37.7784414803533, -122.432772251133) | |||
| 1317 | 1317 | 14834 | Permitted Site 1 | Syagrus romanzoffianum :: Queen Palm 142 | 1288 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003007.4145 | 2111705.9811 | 37.7785120037891 | -122.433162602474 | (37.7785120037891, -122.433162602474) | |||
| 1319 | 1319 | 23465 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2305 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3X3 | 6005845.91849 | 2118326.2505200002 | 37.796850228717105 | -122.42381398834699 | (37.7968502287171, -122.423813988347) | |||
| 1346 | 1346 | 21675 | Permitted Site 1 | Tristania conferta :: 79 | 1788 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6004079.3213 | 2114634.9946 | 37.7866150915141 | -122.42966342693899 | (37.7866150915141, -122.429663426939) | |||
| 1349 | 1349 | 20251 | Permitted Site 1 | Schinus molle :: California Pepper 138 | 1880 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002540.9652 | 2114632.1752 | 37.786520122821 | -122.43498555674299 | (37.786520122821, -122.434985556743) | |||
| 1371 | 1371 | 251505 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 360 Clementina St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011658.68026 | 2112523.0235200003 | 37.781242368680296 | -122.403291911611 | (37.7812423686803, -122.403291911611) | ||||
| 1385 | 1385 | 23847 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1370 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6003735.9392 | 2113413.2165 | 37.7832409463281 | -122.43076422395599 | (37.7832409463281, -122.430764223956) | |||
| 1396 | 1396 | 21755 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 2350 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008465.3581 | 2120976.6726 | 37.8042751503167 | -122.414937771753 | (37.8042751503167, -122.414937771753) | |||
| 1411 | 1411 | 183698 | Permitted Site 1 | Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 8 | 1341 42nd Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5983051.8246 | 2105805.0517 | 37.761157531744104 | -122.501758745065 | (37.7611575317441, -122.501758745065) | |||
| 1415 | 1415 | 9957 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 165X Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Mayor Office of Housing 7 | 18 | 4x4 | 6007023.214790001 | 2111521.59802 | 37.778232715494205 | -122.41925731148399 | (37.7782327154942, -122.419257311484) | |||
| 1426 | 1426 | 5257 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1199 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6001336.2739 | 2112445.4083 | 37.780447344039395 | -122.43899670569701 | (37.7804473440394, -122.438996705697) | |||
| 1450 | 1450 | 18855 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2222 Sacramento St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3X3 | 6003966.78981 | 2116014.3774900003 | 37.790396155900105 | -122.43015119962 | (37.7903961559001, -122.43015119962) | |||
| 1474 | 1474 | 139883 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1585 TURK ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6002506.9595 | 2112283.5581 | 37.780069483595 | -122.434935181147 | (37.780069483595, -122.434935181147) | |||
| 1478 | 1478 | 2891 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1555 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3x3 | 6006907.6574099995 | 2116020.89539 | 37.7905801778777 | -122.419976436385 | (37.7905801778777, -122.419976436385) | |||
| 1483 | 1483 | 251556 | Permitted Site 1 | Tree(s) :: 17 | 299 Clinton Park | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004847.0 | 2108161.0 | 37.7688825293039 | -122.42654628279399 | (37.7688825293039, -122.426546282794) |
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");