trees
194,517 rows sorted by Police Districts descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts ▲ | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22 | 262394 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 66 Cleary Ct | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 11/13/2020 12:00:00 AM | 3 | 3x3 | 6004824 | 2113713 | 37.7841256623529 | -122.427021325889 | (37.7841256623529, -122.427021325889) | 13 | 9 | 11 | 28858 | 41 | ||
29 | 264952 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 2 | Front Yard : Yard | Tree | Private 2 | 11/13/2020 12:00:00 AM | 3 | 6004818 | 2113712 | 37.7841225773231 | -122.427042012496 | (37.7841225773231, -122.427042012496) | 13 | 9 | 11 | 28858 | 41 | |||
31 | 264951 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 1 | Front Yard : Yard | Tree | Private 2 | 11/13/2020 12:00:00 AM | 3 | 6004818 | 2113712 | 37.7841225773231 | -122.427042012496 | (37.7841225773231, -122.427042012496) | 13 | 9 | 11 | 28858 | 41 | |||
37 | 264963 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 275 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2020 12:00:00 AM | 3 | 3x3 | 6005706 | 2110306 | 37.7748207071365 | -122.423727591769 | (37.7748207071365, -122.423727591769) | 7 | 9 | 11 | 28852 | 10 | ||
45 | 134298 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1948 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2020 12:00:00 AM | 3 | Width 4ft | 6004784.56446 | 2117433.72769 | 37.7943396156388 | -122.427422908337 | (37.7943396156388, -122.427422908337) | 13 | 9 | 1 | 28858 | 27 | ||
64 | 264974 | Significant Tree 6 | Persea americana :: Avocado 34 | 1868 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003954 | 2119422 | 37.7997518904289 | -122.430438688757 | (37.7997518904289, -122.430438688757) | 13 | 9 | 1 | 57 | 17 | ||||
65 | 264979 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 2450 California St | 1 | Front Yard : Yard | Tree | MTA 3 | 6002592 | 2115500 | 37.7889058459562 | -122.434871073784 | (37.7889058459562, -122.434871073784) | 13 | 9 | 1 | 29490 | 27 | |||||
66 | 132469 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3135 Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001403 | 2119193 | 37.7989782820217 | -122.43924964791 | (37.7989782820217, -122.43924964791) | 13 | 9 | 1 | 57 | 17 | |||
69 | 126274 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1240 Lombard St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 6ft | 6006421.51674 | 2120105.21307 | 37.8017672864012 | -122.421948716173 | (37.8017672864012, -122.421948716173) | 5 | 9 | 1 | 28858 | 32 | |||
73 | 127010 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1931 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003752.87677 | 2118634.51429 | 37.7975782631807 | -122.431078412364 | (37.7975782631807, -122.431078412364) | 13 | 9 | 1 | 57 | 17 | |||
76 | 34164 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2500 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/22/1997 12:00:00 AM | 5 | Permit Number 38230 | 6001594.91074 | 2117340.13182 | 37.7939017096586 | -122.438452751501 | (37.7939017096586, -122.438452751501) | 13 | 9 | 1 | 57 | 27 | ||
116 | 113159 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 555 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005146 | 2111243 | 37.777361853017 | -122.425731455878 | (37.777361853017, -122.425731455878) | 7 | 9 | 11 | 28852 | 10 | ||||
117 | 108152 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2232 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003295.44003 | 2116396.66877 | 37.7914077834913 | -122.432501340527 | (37.7914077834913, -122.432501340527) | 13 | 9 | 1 | 29490 | 27 | |||||
123 | 221263 | DPW Maintained 1 | Betula spp :: Birch 55 | 1 Church St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6004132.36771 | 2108477.00924 | 37.7697097883113 | -122.429040680782 | (37.7697097883113, -122.429040680782) | 7 | 9 | 5 | 29492 | 10 | |||
130 | 13128 | DPW Maintained 1 | Tristania conferta :: 61 | 1714 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6004131.2449 | 2119777.2826 | 37.8007374433085 | -122.429850711739 | (37.8007374433085, -122.429850711739) | 13 | 9 | 1 | 57 | 17 | |||
149 | 244279 | Undocumented 4 | :: 45 | 585 Oak St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004230.7823 | 2110095.842 | 37.7741602789386 | -122.428815691218 | (37.7741602789386, -122.428815691218) | 7 | 9 | 11 | 28852 | 10 | |||
192 | 137920 | DPW Maintained 1 | :: 45 | 2028 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6002940.7431 | 2115305.2702 | 37.7883909617368 | -122.433650548643 | (37.7883909617368, -122.433650548643) | 13 | 9 | 1 | 29490 | 27 | |||
200 | 10663 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 963 Hayes St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1992 12:00:00 AM | 3 | 3x3 | 6003244.5235 | 2110652.1051 | 37.7756317694487 | -122.432267067771 | (37.7756317694487, -122.432267067771) | 15 | 9 | 11 | 29492 | 10 | ||
214 | 138888 | DPW Maintained 1 | :: 45 | 675 LINDEN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004166.2354 | 2110619.5066 | 37.7755944800015 | -122.429076315191 | (37.7755944800015, -122.429076315191) | 7 | 9 | 11 | 28852 | 10 | |||
219 | 131064 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1877 Greenwich St | 1 | : | Tree | Private 2 | 3 | Width 4ft | 6003926.06281 | 2119346.70194 | 37.7995435588443 | -122.430529985984 | (37.7995435588443, -122.430529985984) | 13 | 9 | 1 | 57 | 17 | |||
232 | 228435 | DPW Maintained 1 | :: 45 | 178 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004070 | 2107898 | 37.7681164387884 | -122.429215116616 | (37.7681164387884, -122.429215116616) | 7 | 9 | 5 | 28862 | 3 | |||
236 | 27345 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 664 Fell St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/01/2008 12:00:00 AM | 4 | 4x4 | 6004282.41706 | 2110648.93551 | 37.7756818605142 | -122.428676512776 | (37.7756818605142, -122.428676512776) | 7 | 9 | 11 | 28852 | 10 | ||
240 | 26863 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 637 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6004510.83387 | 2110645.31056 | 37.7756848318303 | -122.427886103845 | (37.7756848318303, -122.427886103845) | 7 | 9 | 11 | 28852 | 10 | |||
274 | 232433 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 100 Church St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6004078.25972 | 2108290.75217 | 37.7691953086514 | -122.429214555715 | (37.7691953086514, -122.429214555715) | 7 | 9 | 5 | 28862 | 3 | |||
280 | 8072 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 661 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6005345.6576 | 2111619.4154 | 37.7784066780298 | -122.425067563729 | (37.7784066780298, -122.425067563729) | 7 | 9 | 11 | 28852 | 10 | |||
281 | 136194 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 2914 Fillmore St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6002528.73575 | 2118269.03723 | 37.7965053162169 | -122.435288106477 | (37.7965053162169, -122.435288106477) | 13 | 9 | 1 | 57 | 17 | |||
282 | 119806 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 251X Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005545 | 2110174 | 37.7744491774234 | -122.424275134654 | (37.7744491774234, -122.424275134654) | 7 | 9 | 11 | 28852 | 10 | ||||
284 | 142846 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1249 POLK ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 8 | Width 0ft | 6006785.3377 | 2115265.4346 | 37.7884989771715 | -122.420346012985 | (37.7884989771715, -122.420346012985) | 13 | 9 | 10 | 28858 | 21 | |||
320 | 228444 | DPW Maintained 1 | :: 45 | 399 Haight St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6004268.91864 | 2109406.82097 | 37.7722705538615 | -122.428634644993 | (37.7722705538615, -122.428634644993) | 7 | 9 | 11 | 28852 | 10 | |||
326 | 228441 | DPW Maintained 1 | :: 45 | 419 Haight St | 1 | : | Tree | DPW 1 | 04/08/2008 12:00:00 AM | 6 | Width 3ft | 6004104.36681 | 2109385.12417 | 37.7722016657998 | -122.429202297052 | (37.7722016657998, -122.429202297052) | 7 | 9 | 11 | 29492 | 10 | ||
340 | 42995 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 436 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42871 | 6004515.16540478 | 2110012.02065503 | 37.7739462176361 | -122.42782598565 | (37.7739462176361, -122.42782598565) | 7 | 9 | 11 | 28852 | 10 | ||
349 | 253694 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 536 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005450 | 2111168 | 37.7771730951376 | -122.424674483112 | (37.7771730951376, -122.424674483112) | 7 | 9 | 11 | 28852 | 10 | ||||
352 | 98788 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3601X Laguna St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6003538.80686 | 2121150.47161 | 37.804474295204 | -122.431998903525 | (37.804474295204, -122.431998903525) | 13 | 9 | 1 | 57 | 17 | |||
354 | 141882 | DPW Maintained 1 | :: 45 | 1160 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6003839.6945 | 2112655.4467 | 37.7811661774464 | -122.430351190021 | (37.7811661774464, -122.430351190021) | 7 | 9 | 11 | 29490 | 41 | |||
376 | 33627 | Permitted Site 7 | Tree(s) :: 17 | 315 Lily St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/02/1996 12:00:00 AM | Permit Number 37728 | 6005028.27785393 | 2110030.93274628 | 37.7740271589488 | -122.426052389372 | (37.7740271589488, -122.426052389372) | 7 | 9 | 11 | 28852 | 10 | |||
381 | 136202 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 1337 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6004913.0684 | 2120534.02336 | 37.8028595013299 | -122.427199210075 | (37.8028595013299, -122.427199210075) | 13 | 9 | 1 | 57 | 17 | |||
386 | 143336 | DPW Maintained 1 | :: 45 | 1858 UNION ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 6004106.6848 | 2118733.7418 | 37.797870758582 | -122.429861223474 | (37.797870758582, -122.429861223474) | 13 | 9 | 1 | 57 | 17 | |||
395 | 246548 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 20x Octavia St | 2 | Median : Cutout | Tree | DPW 1 | 6 | Width 6ft | 6005741.17746 | 2109432.24964 | 37.7724235852138 | -122.423543772638 | (37.7724235852138, -122.423543772638) | 7 | 9 | 11 | 28852 | 10 | |||
412 | 121036 | Undocumented 4 | Pittosporum undulatum :: Victorian Box 36 | 1830 Polk St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006566 | 2117108 | 37.7935458417616 | -122.421235781398 | (37.7935458417616, -122.421235781398) | 13 | 9 | 10 | 28858 | 32 | ||||
414 | 8435 | Permitted Site 7 | Afrocarpus gracilior :: Fern Pine 89 | 1730 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/1997 12:00:00 AM | 13 | 3X3 | 6003010.73492 | 2113853.74303 | 37.784409407274 | -122.433304626878 | (37.784409407274, -122.433304626878) | 13 | 9 | 11 | 29490 | 13 | ||
436 | 120628 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 6004397 | 2113949 | 37.7847495050096 | -122.428515420401 | (37.7847495050096, -122.428515420401) | 13 | 9 | 11 | 29490 | 41 | |||||
469 | 245799 | DPW Maintained 1 | Corymbia calophylla :: 108 | 50 Church St | 1 | : | Tree | Private 2 | 21 | Width 6ft | 6004070.93701 | 2108481.83175 | 37.7697195522468 | -122.429253511635 | (37.7697195522468, -122.429253511635) | 7 | 9 | 5 | 29492 | 10 | |||
479 | 122586 | Undocumented 4 | Prunus spp :: Cherry 68 | 2500X Lyon St | 6 | Median : Cutout | Tree | Private 2 | 12 | 10x20 | 5999276 | 2117538 | 37.7943128273924 | -122.446490617691 | (37.7943128273924, -122.446490617691) | 13 | 9 | 1 | 57 | 27 | |||
480 | 225991 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 99 Laussat St | 2 | : | Tree | Private 2 | 1 | Width 3ft | 6004313.0789 | 2109253.93974 | 37.7718532783246 | -122.428470991768 | (37.7718532783246, -122.428470991768) | 7 | 9 | 11 | 28852 | 10 | |||
494 | 126450 | DPW Maintained 1 | Casuarina cunninghamiana :: Horsetail pine 112 | 2401 Broadway | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6002086.73219 | 2117346.55126 | 37.7939472989795 | -122.436751464412 | (37.7939472989795, -122.436751464412) | 13 | 9 | 1 | 29490 | 27 | |||
496 | 6869 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 170 Fell St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/22/2008 12:00:00 AM | 4 | 5x5 | 6006554.4326182 | 2110816.1011215 | 37.7762691791752 | -122.420828904096 | (37.7762691791752, -122.420828904096) | 7 | 9 | 11 | 28852 | 10 | ||
512 | 126120 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2843 Larkin St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6006458.53093 | 2121044.25925 | 37.8043477551992 | -122.421887372509 | (37.8043477551992, -122.421887372509) | 5 | 9 | 1 | 28858 | 32 | |||
526 | 262229 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 1970 Post St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6002649 | 2114114 | 37.7851034789316 | -122.434574718683 | (37.7851034789316, -122.434574718683) | 13 | 9 | 11 | 29490 | 13 | ||||
532 | 261313 | Permitted Site 7 | :: 45 | 2700 Broadway | 1 | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 12/31/2019 12:00:00 AM | 3 | 6x40 | 6000687.88763 | 2117206.96839 | 37.7934844433083 | -122.441581569821 | (37.7934844433083, -122.441581569821) | 13 | 9 | 1 | 57 | 27 | ||
563 | 100819 | Undocumented 4 | Platanus x hispanica :: Sycamore: London Plane 27 | 2430X Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6002728 | 2116798 | 37.7924775418689 | -122.434493377265 | (37.7924775418689, -122.434493377265) | 13 | 9 | 1 | 29490 | 27 | |||
615 | 262077 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 565 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Port 6 | Private | 04/16/2020 12:00:00 AM | 3 | 3x3 | 6003870.34162 | 2109702.301 | 37.7730593047529 | -122.430034440005 | (37.7730593047529, -122.430034440005) | 7 | 9 | 11 | 29492 | 10 | |
617 | 241734 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 161 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004159.0543 | 2107968.96381 | 37.7683163292566 | -122.428912146976 | (37.7683163292566, -122.428912146976) | 7 | 9 | 5 | 28862 | 3 | |||
632 | 23885 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1750X Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6003231.6817 | 2113926.646 | 37.7846221123784 | -122.432545437068 | (37.7846221123784, -122.432545437068) | 13 | 9 | 11 | 29490 | 13 | |||
633 | 9792 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 36 | 3x3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 | |||
640 | 222906 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 363 Page St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6004761.72453 | 2109824.22026 | 37.7734445081828 | -122.42695971791 | (37.7734445081828, -122.42695971791) | 7 | 9 | 11 | 28852 | 10 | |||
654 | 110662 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 650 Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6003107.0213 | 2110612.8975 | 37.7755163177511 | -122.43273991983 | (37.7755163177511, -122.43273991983) | 15 | 9 | 11 | 29492 | 10 | |||
714 | 129877 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 1800 Jefferson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6000546.03686 | 2121364.03146 | 37.8048905527229 | -122.442370961862 | (37.8048905527229, -122.442370961862) | 13 | 9 | 1 | 57 | 17 | |||
717 | 124802 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2720 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5999891.10935 | 2118493.83248 | 37.7969724043147 | -122.444431001117 | (37.7969724043147, -122.444431001117) | 13 | 9 | 1 | 57 | 17 | |||
739 | 38480 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2515 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/25/1998 12:00:00 AM | 9 | Permit Number 40479 | 5999797.20513 | 2119471.52027 | 37.7996515161494 | -122.444826245059 | (37.7996515161494, -122.444826245059) | 13 | 9 | 1 | 57 | 17 | ||
772 | 132391 | DPW Maintained 1 | Pittosporum eugenioides :: Tarata 138 | 2833 Larkin St | 2 | Side Yard : Yard | Tree | Private 2 | 31 | 6006489.42377 | 2120936.29447 | 37.8040530536607 | -122.421772791676 | (37.8040530536607, -122.421772791676) | 5 | 9 | 1 | 28858 | 32 | ||||
781 | 98761 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1500X North Point St | 16 | Sidewalk: Property side : Cutout | Tree | Private 2 | 11 | 3x3 | 6003198.92766 | 2121046.5425 | 37.8041696588781 | -122.433167654376 | (37.8041696588781, -122.433167654376) | 13 | 9 | 1 | 57 | 17 | |||
802 | 126843 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 400 Avila St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001073.31574 | 2121444.93358 | 37.8051427271077 | -122.440552066845 | (37.8051427271077, -122.440552066845) | 13 | 9 | 1 | 57 | 17 | |||
803 | 105089 | Significant Tree 6 | :: 45 | 344 Fulton St | 9 | Front Yard : Yard | Tree | Private 2 | 6006101.8 | 2111789.5 | 37.7789163735632 | -122.422463868572 | (37.7789163735632, -122.422463868572) | 7 | 9 | 11 | 28852 | 10 | |||||
817 | 132762 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3749 Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003038.53227 | 2121230.80772 | 37.8046665028104 | -122.43373589191 | (37.8046665028104, -122.43373589191) | 13 | 9 | 1 | 57 | 17 | |||
830 | 260440 | DPW Maintained 1 | Eucalyptus cinerea :: Ash-colored Eucalyptus 142 | 1840X Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003534.8 | 2115143.2 | 37.7879796472282 | -122.431583632877 | (37.7879796472282, -122.431583632877) | 13 | 9 | 11 | 29490 | 27 | ||||
842 | 261260 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 431 Hickory St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 2ft | 6004908 | 2110310 | 37.7747866111117 | -122.426488326031 | (37.7747866111117, -122.426488326031) | 7 | 9 | 11 | 28852 | 10 | ||||
846 | 115842 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1500 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6003573.21553 | 2120746.37029 | 37.8033666892713 | -122.431850957862 | (37.8033666892713, -122.431850957862) | 13 | 9 | 1 | 57 | 17 | |||
867 | 130823 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 2451 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6004083.73489 | 2117213.2991 | 37.7936947127019 | -122.429832130065 | (37.7936947127019, -122.429832130065) | 13 | 9 | 1 | 29490 | 27 | |||
877 | 140007 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 590 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6005073.8071 | 2111650.2628 | 37.778476017163 | -122.426010193621 | (37.778476017163, -122.426010193621) | 7 | 9 | 11 | 28852 | 41 | |||
880 | 139222 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1898 Geary Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6002698.0428 | 2113854.5755 | 37.7843939489044 | -122.434386491808 | (37.7843939489044, -122.434386491808) | 13 | 9 | 11 | 29490 | 13 | |||
897 | 136834 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2189 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6003723.70254 | 2116916.18398 | 37.7928585158644 | -122.43105665684 | (37.7928585158644, -122.43105665684) | 13 | 9 | 1 | 29490 | 27 | |||
898 | 262453 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2005 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6003839 | 2115372 | 37.7886251115209 | -122.43054748798 | (37.7886251115209, -122.43054748798) | 13 | 9 | 1 | 29490 | 27 | ||||
899 | 9520 | DPW Maintained 1 | Tristania conferta :: 61 | 1046 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/31/2000 12:00:00 AM | 3 | 3X3 | 6004532.0878 | 2112270.4724 | 37.7801483287397 | -122.427928412048 | (37.7801483287397, -122.427928412048) | 7 | 9 | 11 | 29490 | 41 | ||
935 | 132500 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2512 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6000920.49838 | 2118292.02212 | 37.796476965998 | -122.440854593363 | (37.796476965998, -122.440854593363) | 13 | 9 | 1 | 57 | 17 | |||
946 | 133881 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2864 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | Width 4ft | Permit Number 782825 | 5999916.99907 | 2117104.86853 | 37.7931601538699 | -122.444241554422 | (37.7931601538699, -122.444241554422) | 13 | 9 | 1 | 57 | 27 | ||
949 | 38398 | Permitted Site 7 | Tree(s) :: 17 | 1000 Van Ness Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/1998 12:00:00 AM | Permit Number 40450 | 6006538.75328643 | 2113902.05144478 | 37.7847415646224 | -122.421102312622 | (37.7847415646224, -122.421102312622) | 7 | 9 | 9 | 28858 | 36 | |||
978 | 8142 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 924 Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6003320.2078 | 2111406.4501 | 37.7777073047982 | -122.432059137251 | (37.7777073047982, -122.432059137251) | 15 | 9 | 11 | 29492 | 41 | |||
984 | 20145 | DPW Maintained 1 | Syagrus romanzoffianum :: Queen Palm 85 | 1006 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6002942.8987 | 2111794.0047 | 37.7787500346576 | -122.433392078669 | (37.7787500346576, -122.433392078669) | 15 | 9 | 11 | 29490 | 41 | |||
1018 | 41589 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 2601 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2013 12:00:00 AM | 4 | Permit Number 770702 | 6001047.66976 | 2117208.8358 | 37.7935100620898 | -122.440336832983 | (37.7935100620898, -122.440336832983) | 13 | 9 | 1 | 29490 | 27 | ||
1043 | 99282 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1500 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/14/2013 12:00:00 AM | 3 | 6003016.20305 | 2114040.83621 | 37.7849234280868 | -122.433299082538 | (37.7849234280868, -122.433299082538) | 13 | 9 | 11 | 29490 | 13 | |||
1044 | 139272 | DPW Maintained 1 | Pyrus kawakamii :: Evergreen Pear 83 | 765 FULTON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 6004185.2644 | 2111476.3212 | 37.7779481591061 | -122.429071593475 | (37.7779481591061, -122.429071593475) | 7 | 9 | 11 | 28852 | 10 | |||
1045 | 17359 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2221X Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005488.40666 | 2117587.01663 | 37.7948002909451 | -122.424998441372 | (37.7948002909451, -122.424998441372) | 13 | 9 | 1 | 28858 | 27 | |||
1047 | 42641 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 1651 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/07/2020 12:11:00 PM | 3 | 5x5 | Permit Number 42688 | 6005090.06351 | 2118821.98656 | 37.7981686950973 | -122.426464740961 | (37.7981686950973, -122.426464740961) | 13 | 9 | 1 | 57 | 17 |
1049 | 120626 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 6004397 | 2113949 | 37.7847495050096 | -122.428515420401 | (37.7847495050096, -122.428515420401) | 13 | 9 | 11 | 29490 | 41 | |||||
1073 | 108979 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3298 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2017 12:00:00 AM | 3 | 3x3 | 6001360.79576 | 2119668.58087 | 37.800281699894 | -122.43942979746 | (37.800281699894, -122.43942979746) | 13 | 9 | 1 | 57 | 17 | ||
1080 | 169338 | Planning Code 138.1 required 2 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1029 Geary St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/2019 12:00:00 AM | 3 | Width 4ft | 6006781.41851 | 2114264.09095 | 37.7857493130165 | -122.420288474132 | (37.7857493130165, -122.420288474132) | 13 | 9 | 9 | 28858 | 36 | ||
1099 | 138916 | DPW Maintained 1 | Tristania conferta :: 61 | 707 HAYES ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004396.0968 | 2110813.5411 | 37.7761402601039 | -122.428295000541 | (37.7761402601039, -122.428295000541) | 7 | 9 | 11 | 28852 | 10 | |||
1104 | 125224 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 2285 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6003837.08538 | 2116275.37223 | 37.7911054341186 | -122.430618599767 | (37.7911054341186, -122.430618599767) | 13 | 9 | 1 | 29490 | 27 | |||
1109 | 102184 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 1840X Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/19/2015 12:00:00 AM | 12 | 3x3 | 6003534.8 | 2115143.2 | 37.7879796472282 | -122.431583632877 | (37.7879796472282, -122.431583632877) | 13 | 9 | 11 | 29490 | 27 | ||
1115 | 238053 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 426 Lily St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6004459.53739 | 2109991.59452 | 37.7738869854343 | -122.428016956418 | (37.7738869854343, -122.428016956418) | 7 | 9 | 11 | 28852 | 10 | |||
1142 | 260393 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 550 Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005467 | 2111269 | 37.7774513766157 | -122.424622861078 | (37.7774513766157, -122.424622861078) | 7 | 9 | 11 | 28852 | 10 | ||||
1143 | 29069 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1002X Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/15/2005 12:00:00 AM | 15 | 3x3 | 6004818.3149515 | 2112301.2204093 | 37.7802489436872 | -122.4269404119 | (37.7802489436872, -122.4269404119) | 7 | 9 | 11 | 28852 | 41 | ||
1147 | 131409 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 2817 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6003467.33625 | 2118170.97636 | 37.796289323341 | -122.432033340382 | (37.796289323341, -122.432033340382) | 13 | 9 | 1 | 57 | 17 | |||
1163 | 127620 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 888 O'Farrell St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6007042.74082 | 2114007.27438 | 37.7850588791954 | -122.419366145639 | (37.7850588791954, -122.419366145639) | 13 | 9 | 9 | 28858 | 36 | |||
1167 | 33310 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 1549 Filbert St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/14/1996 12:00:00 AM | 8 | Permit Number 37457 | 6005491.84423 | 2119228.52143 | 37.7993076406048 | -122.425103401209 | (37.7993076406048, -122.425103401209) | 13 | 9 | 1 | 57 | 17 | |
1169 | 12272 | DPW Maintained 1 | Callistemon viminalis :: Weeping Bottlebrush 60 | 700X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/1997 12:00:00 AM | 3 | 3X3 | 6004950.3992 | 2111308.9655 | 37.7775319231116 | -122.426412801229 | (37.7775319231116, -122.426412801229) | 7 | 9 | 11 | 28852 | 10 | ||
1170 | 142055 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1340 EDDY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004095.0977 | 2112901.4306 | 37.7818560517417 | -122.429485169449 | (37.7818560517417, -122.429485169449) | 7 | 9 | 11 | 29490 | 41 | |||
1184 | 138898 | DPW Maintained 1 | Magnolia grandiflora :: Southern Magnolia 19 | 640 Linden St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6004115.5085 | 2110637.0852 | 37.7756398749162 | -122.429253045645 | (37.7756398749162, -122.429253045645) | 7 | 9 | 11 | 28852 | 10 | |||
1199 | 116255 | Undocumented 4 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 155 LAGUNA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7x6 | 6005176 | 2109399 | 37.7723003725615 | -122.425496410637 | (37.7723003725615, -122.425496410637) | 7 | 9 | 5 | 28852 | 10 | ||||
1237 | 35474 | Permitted Site 7 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 455 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/1998 12:00:00 AM | Permit Number 38887 | 6007396.82109854 | 2112616.81920427 | 37.7812609627381 | -122.418042529741 | (37.7812609627381, -122.418042529741) | 7 | 9 | 9 | 28852 | 36 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );