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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15 | 15 | 196591 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 43 Lafayette St | 3 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | Permit Number 772992 | 6007555.65106 | 2109624.06249 | 37.7730525072055 | -122.417280912782 | (37.7730525072055, -122.417280912782) | ||
| 62 | 62 | 239043 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 10 12th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006946.59098 | 2109912.5632700003 | 37.773810376676295 | -122.41940820332898 | (37.7738103766763, -122.419408203329) | |||
| 188 | 188 | 138368 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2060 SUTTER ST | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | Width 0ft | 6002679.2262 | 2114443.3671 | 37.786009553218996 | -122.434493703661 | (37.786009553219, -122.434493703661) | |||
| 189 | 189 | 138807 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 2355 PINE ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | Width 0ft | 6002661.6347 | 2115086.2451 | 37.7877737339769 | -122.434600550462 | (37.7877737339769, -122.434600550462) | |||
| 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) | |||
| 483 | 483 | 236058 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 601X 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004683.7857099995 | 2107762.8709299997 | 37.767780134560205 | -122.427082469082 | (37.7677801345602, -122.427082469082) | |||
| 543 | 543 | 224593 | Permitted Site 1 | Ficus microcarpa :: Chinese Banyan 94 | 3131 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/02/1981 12:00:00 AM | 13 | Width 3ft | Permit Number 18870 | 6005970.19181 | 2106649.76485 | 37.7647964691065 | -122.42255383310801 | (37.7647964691065, -122.422553833108) | |
| 802 | 802 | 64866 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2185 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/1989 12:00:00 AM | 13 | Permit Number 25884 | 5997401.9097 | 2109840.7512 | 37.773070992957 | -122.45241943675501 | (37.773070992957, -122.452419436755) | |
| 810 | 810 | 212202 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 800 Bosworth St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6001677.26505 | 2095571.4535400001 | 37.734134940976 | -122.43660890297501 | (37.734134940976, -122.436608902975) | ||||
| 901 | 901 | 224716 | Property Tree 7 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3255x 24th St | 5 | Front Yard : Cutout 8 | Tree 1 | MTA 6 | 13 | Width 3ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 904 | 904 | 140946 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2060 Ofarrell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
| 942 | 942 | 139350 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400 GEARY BLVD | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | Width 0ft | 6004774.9676 | 2114125.1051 | 37.785254427644404 | -122.427220325156 | (37.7852544276444, -122.427220325156) | |||
| 951 | 951 | 248015 | DPW Maintained 3 | Casuarina cunninghamiana :: Horsetail pine 123 | 525 Franconia St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | Width 4ft | 6009932.57505 | 2098116.0025400002 | 37.741587399748894 | -122.408246979117 | (37.7415873997489, -122.408246979117) | |||
| 962 | 962 | 139345 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1400 GEARY BLVD | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | Width 0ft | 6004932.8001 | 2114145.6028 | 37.7853196336912 | -122.426675732937 | (37.7853196336912, -122.426675732937) | |||
| 1022 | 1022 | 186874 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 2700 Sunset Blvd | 23 | Median : Yard 3 | Tree 1 | DPW 2 | 13 | Width 0ft | 5985204.8462 | 2096382.2812 | 37.7354114037883 | -122.493618136413 | (37.7354114037883, -122.493618136413) | |||
| 1168 | 1168 | 218199 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 819 Ulloa St | 1 | : 4 | Tree 1 | DPW 2 | 13 | Width 3ft | 5993346.67502 | 2098141.32486 | 37.740714236277 | -122.46559677389799 | (37.740714236277, -122.465596773898) | |||
| 1405 | 1405 | 228661 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 4235 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 03/07/1990 12:00:00 AM | 13 | Width 3ft | 6001838.07707 | 2104669.16217 | 37.7591242363206 | -122.436703937943 | (37.7591242363206, -122.436703937943) | ||
| 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) | |||
| 1466 | 1466 | 247380 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1001 Oak St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | Width 0ft | 6002208.0 | 2109818.0 | 37.7732826991746 | -122.43579295981199 | (37.7732826991746, -122.435792959812) | |||
| 1515 | 1515 | 243950 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 10 South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/14/2004 12:00:00 AM | 13 | Width 5ft | Permit Number 47529 | 6007004.81099 | 2110130.42285 | 37.774411845966895 | -122.419222267617 | (37.7744118459669, -122.419222267617) | |
| 1740 | 1740 | 200859 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1133 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6008786.0 | 2112009.0 | 37.7796701249263 | -122.413193644333 | (37.7796701249263, -122.413193644333) | |||
| 1792 | 1792 | 200049 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1590 Shafter Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6015007.7446 | 2094143.437 | 37.7309624265756 | -122.390421112537 | (37.7309624265756, -122.390421112537) | |||
| 1909 | 1909 | 125218 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 2101 Washington St | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 13 | Width 4ft | 6005090.35688 | 2116771.11072 | 37.7925375271472 | -122.42631763077499 | (37.7925375271472, -122.426317630775) | |||
| 2054 | 2054 | 143144 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2150 LOMBARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | Width 0ft | 6002035.2938 | 2119489.3913 | 37.799828054976395 | -122.437082936374 | (37.7998280549764, -122.437082936374) | |||
| 2095 | 2095 | 58908 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 353 10th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/1980 12:00:00 AM | 13 | 3x3 | Permit Number 780019 | 6009109.47745 | 2109280.29041 | 37.7721958858688 | -122.41188171506501 | (37.7721958858688, -122.411881715065) | |
| 2204 | 2204 | 204163 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 44 Southwood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2003 12:00:00 AM | 13 | Width 3ft | Permit Number 46258 | 5995611.132540001 | 2092478.8947 | 37.7252969291056 | -122.45735764125 | (37.7252969291056, -122.45735764125) | |
| 2212 | 2212 | 204345 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 44 Southwood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2003 12:00:00 AM | 13 | Width 3ft | Permit Number 46258 | 5995599.60309 | 2092472.80372 | 37.7252795425123 | -122.45739705673 | (37.7252795425123, -122.45739705673) | |
| 2308 | 2308 | 193164 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 282 02nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6013490.496590001 | 2114117.3583299997 | 37.785722181364896 | -122.397066509426 | (37.7857221813649, -122.397066509426) | |||
| 2347 | 2347 | 195023 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6013717.57682 | 2113887.99977 | 37.785105053996396 | -122.396264789902 | (37.7851050539964, -122.396264789902) | |||
| 2359 | 2359 | 195027 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300X 02nd St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6013762.26581 | 2113837.6181400004 | 37.784969204212295 | -122.396106646824 | (37.7849692042123, -122.396106646824) | |||
| 2459 | 2459 | 219808 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 522 Douglass St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/1998 12:00:00 AM | 13 | Width 3ft | Permit Number 39569 | 6001164.78093 | 2103190.57053 | 37.7550260958884 | -122.43892655033702 | (37.7550260958884, -122.438926550337) | |
| 2493 | 2493 | 127969 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 73 Castle St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 1ft | 6011253.45973 | 2119573.0614099996 | 37.8005774500495 | -122.405190374142 | (37.8005774500495, -122.405190374142) | |||
| 2505 | 2505 | 127968 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 73 Castle St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 1ft | 6011251.91529 | 2119582.84216 | 37.8006042192626 | -122.405196407682 | (37.8006042192626, -122.405196407682) | |||
| 2520 | 2520 | 141903 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 900 MCALLISTER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6004752.7943 | 2111956.4883 | 37.7792986892944 | -122.42714251637699 | (37.7792986892944, -122.427142516377) | |||
| 2599 | 2599 | 56658 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2436 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 5987881.10051 | 2113316.56801 | 37.7820645490157 | -122.485607837735 | (37.7820645490157, -122.485607837735) | ||||
| 2625 | 2625 | 248771 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1 Cuesta Ct | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 8ft | 5999742.36883 | 2101773.9828 | 37.751055459558394 | -122.4437438777 | (37.7510554595584, -122.4437438777) | |||
| 2729 | 2729 | 141998 | DPW Maintained 3 | Tristania conferta :: 79 | 818 WEBSTER ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/1990 12:00:00 AM | 13 | Width 0ft | 6003974.6435 | 2111716.5903 | 37.778595953895795 | -122.42981734758699 | (37.7785959538958, -122.429817347587) | ||
| 2778 | 2778 | 246114 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1418 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | 13 | Width 0ft | Permit Number 47096 | 5998969.2151 | 2108370.2652 | 37.769123080801 | -122.44689211719 | (37.769123080801, -122.44689211719) | |
| 2780 | 2780 | 246115 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1410 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/2003 12:00:00 AM | 13 | Width 0ft | Permit Number 47096 | 5998952.8623 | 2108365.1171 | 37.769108011186106 | -122.446948309851 | (37.7691080111861, -122.446948309851) | |
| 2813 | 2813 | 229987 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 581 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/1980 12:00:00 AM | 13 | Width 2ft | Permit Number 18753 | 6003140.984180001 | 2095726.54341 | 37.734643853813296 | -122.431559437241 | (37.7346438538133, -122.431559437241) | |
| 2836 | 2836 | 229976 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 506 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/1983 12:00:00 AM | 13 | Width 2ft | Permit Number 20257 | 6003460.201330001 | 2096023.8631099998 | 37.7354783140686 | -122.430477003328 | (37.7354783140686, -122.430477003328) | |
| 2878 | 2878 | 57526 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 501 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/19/1981 12:00:00 AM | 13 | 3x3 | Permit Number 19437 | 6005352.078 | 2111299.9206 | 37.7775297860553 | -122.42502261513701 | (37.7775297860553, -122.425022615137) | |
| 2937 | 2937 | 142168 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1477 GROVE ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6000782.6842 | 2110659.1833 | 37.775511310355505 | -122.440783660256 | (37.7755113103555, -122.440783660256) | |||
| 2957 | 2957 | 238483 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 103 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | 13 | Width 3ft | Permit Number 37768 | 6003709.010969999 | 2108821.61027 | 37.7706320052989 | -122.430529650538 | (37.7706320052989, -122.430529650538) | |
| 3070 | 3070 | 116407 | Permitted Site 1 | Tree(s) :: 17 | 600 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 6010620.1417 | 2118945.4017 | 37.798818623722 | -122.40733765055599 | (37.798818623722, -122.407337650556) | ||||
| 3331 | 3331 | 140432 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1499 Turk St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 13 | Width 0ft | 6003204.3695 | 2112383.9326 | 37.7803846599605 | -122.432529697936 | (37.7803846599605, -122.432529697936) | |||
| 3334 | 3334 | 140424 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 TURK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 13 | Width 0ft | 6002981.8736 | 2112352.3525 | 37.7802853291655 | -122.43329715719 | (37.7802853291655, -122.43329715719) | |||
| 3343 | 3343 | 140423 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 TURK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 13 | Width 0ft | 6002956.7531 | 2112350.9171 | 37.7802799627924 | -122.43338395792802 | (37.7802799627924, -122.433383957928) | |||
| 3530 | 3530 | 123324 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 798 05th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Permit Number 780721 | 5994466.95086 | 2110266.43708 | 37.7740712286384 | -122.462602639066 | (37.7740712286384, -122.462602639066) | |||
| 3574 | 3574 | 127916 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1175 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6007863.0053199995 | 2121226.60678 | 37.8049275409425 | -122.417039987112 | (37.8049275409425, -122.417039987112) | |||
| 3589 | 3589 | 11167 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2655 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3X3 | 6006899.01173 | 2121433.76541 | 37.805442070952 | -122.42039071266501 | (37.805442070952, -122.420390712665) | |||
| 3659 | 3659 | 209947 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2400 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/22/1995 12:00:00 AM | 13 | Width 3ft | Permit Number 35554 | 5992051.55672 | 2099045.56782 | 37.7431222717841 | -122.47014058862301 | (37.7431222717841, -122.470140588623) | |
| 3682 | 3682 | 215670 | Undocumented 2 | Ulmus spp :: Elm Spp 215 | 100 Cortes Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2016 12:00:00 AM | 13 | Width 3ft | Permit Number 777819 | 5993206.76177 | 2099368.3728400003 | 37.7440753292166 | -122.46616968519899 | (37.7440753292166, -122.466169685199) | |
| 3710 | 3710 | 240036 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 4121 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6002205.0 | 2105251.0 | 37.7607426677704 | -122.435476567852 | (37.7607426677704, -122.435476567852) | |||
| 3880 | 3880 | 241545 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 116 Fairmount St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 5x12 | 6004745.13343 | 2097274.75809 | 37.7389856943281 | -122.426123530088 | (37.7389856943281, -122.426123530088) | |||
| 4252 | 4252 | 244056 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 401 Cole St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5997913.0484 | 2109110.0936 | 37.771094065570296 | -122.45059866498 | (37.7710940655703, -122.45059866498) | |||
| 4264 | 4264 | 107589 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2760 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6000110.02976 | 2118059.62225 | 37.7957926664564 | -122.443642277677 | (37.7957926664564, -122.443642277677) | |||
| 4265 | 4265 | 246125 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1546 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/02/1979 12:00:00 AM | 13 | Width 0ft | Permit Number 17701 | 5998276.9478 | 2108272.4514 | 37.7688149359981 | -122.44927957115101 | (37.7688149359981, -122.449279571151) | |
| 4278 | 4278 | 246148 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1504 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5998461.6736 | 2108298.4947 | 37.768897008730896 | -122.44864249661501 | (37.7688970087309, -122.448642496615) | |||
| 4385 | 4385 | 224618 | Planning Code 138.1 required 4 | Ficus microcarpa :: Chinese Banyan 94 | 165 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | Width 3ft | Permit Number 780743 | 6001936.24436 | 2096476.10277 | 37.7366336128599 | -122.435778235198 | (37.7366336128599, -122.435778235198) | ||
| 4401 | 4401 | 239088 | Planning Code 138.1 required 4 | Pyrus calleryana :: Ornamental Pear 9 | 3855 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 3x3 | Permit Number 780732 | 6004794.15723 | 2100737.4007099997 | 37.748496089721996 | -122.426200479689 | (37.748496089722, -122.426200479689) | ||
| 4602 | 4602 | 245382 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 3720 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | Width 0ft | 6005277.267000001 | 2096556.8057 | 37.7370444205252 | -122.42423260748899 | (37.7370444205252, -122.424232607489) | |||
| 4606 | 4606 | 142512 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 427 COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | Width 0ft | 6010331.5039 | 2118981.6421 | 37.798901972160294 | -122.40833899341601 | (37.7989019721603, -122.408338993416) | |||
| 4689 | 4689 | 95648 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1681 Greenwich St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6004869.27424 | 2119488.56695 | 37.799986470461 | -122.42727624513 | (37.799986470461, -122.42727624513) | |||
| 4768 | 4768 | 188475 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 255 12th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6007904.0486 | 2109028.3939900002 | 37.7714365370061 | -122.41603356660299 | (37.7714365370061, -122.416033566603) | |||
| 4847 | 4847 | 76692 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 423 Burrows St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/08/1988 12:00:00 AM | 13 | 6010109.0 | 2093148.0 | 37.7279562025478 | -122.407286823302 | (37.7279562025478, -122.407286823302) | ||
| 5132 | 5132 | 22967 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 545 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/28/1995 12:00:00 AM | 13 | 3x3 | 6006209.68052 | 2106410.0153 | 37.764151681274 | -122.421708472183 | (37.764151681274, -122.421708472183) | ||
| 5204 | 5204 | 123240 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 590 08th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | Permit Number 780398 | 5993479.44876 | 2111515.72827 | 37.777444527227004 | -122.46610935382499 | (37.777444527227, -122.466109353825) | ||
| 5756 | 5756 | 8772 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3434 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 3X3 | 5996377.3792 | 2112940.8578 | 37.781524320662 | -122.456187581392 | (37.781524320662, -122.456187581392) | |||
| 5846 | 5846 | 18671 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 99X Richardson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/1997 12:00:00 AM | 13 | 2X2 | 5999533.57531 | 2119335.56991 | 37.799263184406705 | -122.445728714712 | (37.7992631844067, -122.445728714712) | ||
| 6003 | 6003 | 98729 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 360 Grove St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 13 | 3x3 | 6006140.89781 | 2111454.63858 | 37.7779991309825 | -122.42230481531901 | (37.7779991309825, -122.422304815319) | |||
| 6032 | 6032 | 95646 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1681 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6004836.79342 | 2119482.75507 | 37.799968675576295 | -122.42738822690201 | (37.7999686755763, -122.427388226902) | |||
| 6062 | 6062 | 3195 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3700X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3X3 | 5996565.7886 | 2114644.13956 | 37.7862118928056 | -122.45565893343901 | (37.7862118928056, -122.455658933439) | |||
| 6173 | 6173 | 13020 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 423 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3X3 | 6010295.8571 | 2120595.8738 | 37.8033322591341 | -122.40857627636002 | (37.8033322591341, -122.40857627636) | |||
| 6400 | 6400 | 106204 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1600X Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 5x5 | 6003122.9413 | 2113972.2468 | 37.7847411535968 | -122.432924900964 | (37.7847411535968, -122.432924900964) | |||
| 6860 | 6860 | 93474 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1345 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x2 | 6008356.752640001 | 2116586.1732799998 | 37.792213826952704 | -122.41500266293501 | (37.7922138269527, -122.415002662935) | |||
| 6924 | 6924 | 2878 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1468 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/22/1995 12:00:00 AM | 13 | 3X3 | 6007323.82553 | 2116144.11795 | 37.7909419544596 | -122.41854525707701 | (37.7909419544596, -122.418545257077) | ||
| 7411 | 7411 | 23441 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2100x Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3X3 | 6006042.25764 | 2117640.51694 | 37.7949784589386 | -122.423085842334 | (37.7949784589386, -122.423085842334) | |||
| 7417 | 7417 | 27383 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2560 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 3X3 | 6006988.37342 | 2121139.78035 | 37.8046398981635 | -122.420060587734 | (37.8046398981635, -122.420060587734) | |||
| 7484 | 7484 | 11441 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2200X Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 3X3 | 6005093.38761 | 2117287.76065 | 37.7939562886077 | -122.42634394583901 | (37.7939562886077, -122.426343945839) | |||
| 7973 | 7973 | 107590 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2760 Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6000109.34681 | 2118076.29285 | 37.7958384005634 | -122.443645838983 | (37.7958384005634, -122.443645838983) | |||
| 8623 | 8623 | 93473 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1345 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x2 | 6008345.85317 | 2116585.5339599997 | 37.792211459052794 | -122.415040330141 | (37.7922114590528, -122.415040330141) | |||
| 8709 | 8709 | 95225 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2424@Vallejo Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2011 12:00:00 AM | 13 | 3x21 | Permit Number 767114 | 6004985.2378 | 2118090.67543 | 37.7961547748778 | -122.42677536142 | (37.7961547748778, -122.42677536142) | |
| 8758 | 8758 | 7287 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1850 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 3X3 | 6003043.7765 | 2114538.1757 | 37.786290560678204 | -122.433239236497 | (37.7862905606782, -122.433239236497) | |||
| 9022 | 9022 | 105217 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2100 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 5999896.62594 | 2116125.07257 | 37.7904687293982 | -122.44424160568998 | (37.7904687293982, -122.44424160569) | |||
| 9030 | 9030 | 98730 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 360 Grove St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 13 | 3x3 | 6006126.244940001 | 2111454.93961 | 37.777999130991205 | -122.42235552627899 | (37.7779991309912, -122.422355526279) | |||
| 9074 | 9074 | 164 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2790X 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 5991861.232316299 | 2096712.8875626998 | 37.7367063200182 | -122.470628807941 | (37.7367063200182, -122.470628807941) | |||
| 9199 | 9199 | 2213 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1180 Broderick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 5x6 | 6000873.9051 | 2112632.3017 | 37.78093418717 | -122.440609661528 | (37.78093418717, -122.440609661528) | |||
| 10498 | 10498 | 1239 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3702X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 3X5 | 5993039.27607 | 2087635.23978 | 37.711849369237 | -122.465896444163 | (37.711849369237, -122.465896444163) | |||
| 11190 | 11190 | 27222 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 371 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/25/1994 12:00:00 AM | 13 | 3x3 | 6003827.51824 | 2093508.67438 | 37.728592973182295 | -122.42902777912701 | (37.7285929731823, -122.429027779127) | ||
| 12142 | 12142 | 114553 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1235 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 4x4 | 5981162.8746 | 2106644.13 | 37.7633502628215 | -122.508353983735 | (37.7633502628215, -122.508353983735) | |||
| 12964 | 12964 | 44723 | Permitted Site 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1946 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/03/2001 12:00:00 AM | 13 | Permit Number 43842 | 5989432.8015 | 2102080.7043 | 37.751304216428 | -122.47941744514699 | (37.751304216428, -122.479417445147) | |
| 13821 | 13821 | 105161 | Significant Tree 6 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1600X Oakdale Ave | 2 | Front Yard : Cutout 8 | Tree 1 | Arts Commission 19 | 13 | 3x3 | 6014869.34112 | 2095641.8363700002 | 37.735069048787 | -122.39100428831499 | (37.735069048787, -122.391004288315) | |||
| 15218 | 15218 | 22292 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 4919 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3X3 | 6014853.8531 | 2095132.1894 | 37.733668802459896 | -122.39102222683 | (37.7336688024599, -122.39102222683) | |||
| 16599 | 16599 | 15189 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1077 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 3X3 | 6009592.13502 | 2111935.30817 | 37.779513008365605 | -122.410399657519 | (37.7795130083656, -122.410399657519) | |||
| 17105 | 17105 | 23993 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 288 West Portal Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 3x3 | 5992331.2652 | 2097223.6221 | 37.738135837236705 | -122.469040873258 | (37.7381358372367, -122.469040873258) | |||
| 17699 | 17699 | 73 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 880 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 3X3 | 6002985.89482 | 2107705.84522 | 37.767527397193795 | -122.432951190257 | (37.7675273971938, -122.432951190257) | |||
| 18264 | 18264 | 10085 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 648 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/1998 12:00:00 AM | 13 | 3x2 | 6005571.80442 | 2105186.7253099997 | 37.7607568250935 | -122.423827714701 | (37.7607568250935, -122.423827714701) | ||
| 18497 | 18497 | 22906 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 245 Valencia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/31/2015 12:00:00 AM | 13 | 3X3 | 6006112.52136 | 2108201.36754 | 37.7690648305187 | -122.422171793011 | (37.7690648305187, -122.422171793011) | ||
| 18821 | 18821 | 25266 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1738 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 3X3 | 5994668.335 | 2092363.0322 | 37.7249246023662 | -122.460608386003 | (37.7249246023662, -122.460608386003) |
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");