194,517 rows sorted by Police Districts descending

View and edit SQL

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);