trees

434 rows where SiteOrder = 1 and qLegalStatus_id = 2 sorted by Supervisor Districts

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: Supervisor Districts, SiteOrder

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)
3879 260548 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1190 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/15/2018 12:00:00 AM 3 3x3 Permit Number 776221                    
5071 254119 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 150 Jennings St 1 Sidewalk: Property side : Yard Tree Private 2   01/02/2018 12:00:00 AM 3   Permit Number 781123                    
7193 254151 Planning Code 138.1 required 2 Tree(s) :: 17 201 Steuart St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/09/2018 12:00:00 AM 3 4x4 Permit Number 781165                    
8598 121137 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 1388x Minna St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/08/2016 12:00:00 AM 3 3x3                      
10143 256870 Planning Code 138.1 required 2 Cupressus macrocarpa :: Monterey Cypress 41 30X Bernal Heights Blvd 1 Back Yard : Cutout Tree Private 2       12x6                      
12808 254368 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 590X Orizaba Ave 1 Back Yard : Yard Tree Private 2   02/06/2018 12:00:00 AM 3   Permit Number 778929                    
14212 253124 Planning Code 138.1 required 2 Tree(s) :: 17 399x Lexington St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/19/2017 12:00:00 AM 3 3x3 Permit Number 780530                    
14753 259380 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 198X Eddy St 1 Sidewalk: Curb side : Cutout Tree DPW 1                              
172077 258332 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 215X Raccoon Dr 1 Sidewalk: Property side : Yard Tree Private 2   04/29/2019 12:00:00 AM 3 3X3 Permit Number 776074                    
12753 253419 Planning Code 138.1 required 2 :: 45 3499 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997570 2115996 37.7899813188913 -122.452282225129 (37.7899813188913, -122.452282225129) 11 6 1 54 31
15497 33110 Planning Code 138.1 required 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 2626 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/02/2020 12:00:00 AM 3   Permit Number 769981 6000381.41365 2118563.70291 37.7971922129921 -122.442739455458 (37.7971922129921, -122.442739455458) 13 9 1 57 17
17726 65839 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2328 North Point St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/03/2018 12:00:00 AM 3 6x6 Permit Number 772721 5999589.88517 2120533.82376 37.802556482867 -122.445620078411 (37.802556482867, -122.445620078411) 13 9 1 57 17
21074 256565 Planning Code 138.1 required 2 Acer buergeranum :: Trident Maple 110 2099X Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002352 2115365 37.7885215412843 -122.435691777518 (37.7885215412843, -122.435691777518) 13 6 1 29490 27
47145 95203 Planning Code 138.1 required 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 314 Walnut St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 3x3 Permit Number 769992 5998598.63338 2115400.15976 37.7884041728517 -122.44868032474 (37.7884041728517, -122.44868032474) 13 6 1 54 31
55452 35488 Planning Code 138.1 required 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 2655 Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2016 12:00:00 AM 3   Permit Number 770253 6000772.5656 2114469.8149 37.7859737553806 -122.441092113094 (37.7859737553806, -122.441092113094) 15 6 1 29490 27
60238 252840 Planning Code 138.1 required 2 Tree(s) :: 17 80 Blake St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997842 2113206 37.782336294689 -122.451139847811 (37.782336294689, -122.451139847811) 15 6 1 54 31
65206 116853 Planning Code 138.1 required 2 Eucalyptus sideroxylon :: Red Ironbark 127 1634 Pine St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/01/2016 12:00:00 AM 3 3X3 Permit Number 773331 6005973.81147 2115593.81965 37.7893548777914 -122.423177122971 (37.7893548777914, -122.423177122971) 13 9 1 28858 41
69912 250072 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 1599X Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6006083 2115238 37.7883840466687 -122.422774045373 (37.7883840466687, -122.422774045373) 13 9 1 28858 41
70470 146088 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 2828 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/13/2018 12:00:00 AM 3 3x3 Permit Number 777329 6003000.78966 2118372.69184 37.7968167208658 -122.433662110612 (37.7968167208658, -122.433662110612) 13 9 1 57 17
78803 256612 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2375 Ofarrell St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/07/2018 12:00:00 AM 3 3x3 Permit Number 780481 6000092 2112863 37.7815230689536 -122.443331223004 (37.7815230689536, -122.443331223004) 15 5 1 29490 16
79775 251140 Planning Code 138.1 required 2 Olea Majestic Beauty :: 183 138 Parker Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996904.98449 2113495.29925 37.783076941712 -122.454402393245 (37.783076941712, -122.454402393245) 11 6 1 54 31
84905 117112 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1650 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2   06/07/2016 12:00:00 AM 3 3x3 Permit Number 773961 6005683.22125 2117915.42136 37.7957130098979 -122.424347724294 (37.7957130098979, -122.424347724294) 13 9 1 28858 27
86670 146397 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 3318 Scott St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/28/2019 12:00:00 AM 3 Width 4ft Permit Number 780850 6000857.39871 2119780.85133 37.8005613036105 -122.441179804419 (37.8005613036105, -122.441179804419) 13 9 1 57 17
99037 253999 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 2500 Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/08/2017 12:00:00 AM 3 3x3 Permit Number 771961 6001313 2114572 37.7862850971301 -122.439229688457 (37.7862850971301, -122.439229688457) 13 6 1 29490 27
99613 256169 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 80 Terra Vista Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/07/2018 12:00:00 AM 3 3x3 Permit Number 780481 6000092 2112863 37.7815230689536 -122.443331223004 (37.7815230689536, -122.443331223004) 15 5 1 29490 16
118314 120115 Planning Code 138.1 required 2 Lyonothamnus floribundus subsp. asplenifolius :: Santa Cruz Ironwood 33 2225 Bay St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6000127.23839 2120216.52423 37.8017159270068 -122.443737765003 (37.8017159270068, -122.443737765003) 13 9 1 57 17
119152 5313 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 1785 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2016 12:00:00 AM 3 3X3 Permit Number 770253 6001045 2114480 37.786017234839 -122.440150297316 (37.786017234839, -122.440150297316) 15 6 1 29490 27
119169 117250 Planning Code 138.1 required 2 Prunus cerasifera :: Cherry Plum 7 2474 Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2   09/13/2016 12:00:00 AM 3 3x3 Permit Number 773044 6001780.62325 2117368.05955 37.7939889537763 -122.437812170719 (37.7939889537763, -122.437812170719) 13 9 1 57 27
135790 256689 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 2825 Lake St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/21/2018 12:00:00 AM 3   Permit Number 772474 5986729.50015 2114421.37847 37.7850308764656 -122.489673069254 (37.7850308764656, -122.489673069254) 11 6 1 55 33
136198 255789 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 2240 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003983 2116665 37.7921835181407 -122.430141547967 (37.7921835181407, -122.430141547967) 13 9 1 29490 27
139366 172746 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1230 Chestnut St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/05/2017 12:00:00 AM 3 4x3 Permit Number 778360 6006038.86692 2120389.38612 37.8025259652646 -122.423293075825 (37.8025259652646, -122.423293075825) 5 9 1 28858 32
143851 249555 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1450 Franklin St 1 : Tree Private 2   04/05/2017 12:00:00 AM 3 Width 4ft Permit Number 770925 6005893.0868 2115064.96247 37.7878982115887 -122.423418809148 (37.7878982115887, -122.423418809148) 13 9 1 28858 41
145251 108356 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 250X Pixley St 1 Sidewalk: Curb side : Cutout Tree Fire Dept 16   11/02/2018 12:00:00 AM 3 2x4 Permit Number 773698 6002158.91155 2118972.60439 37.7984161192732 -122.436618162405 (37.7984161192732, -122.436618162405) 13 9 1 57 17
148701 115559 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 2539 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6001373.79142 2117611.09107 37.7946331129763 -122.439237274207 (37.7946331129763, -122.439237274207) 13 9 1 57 27
157324 32045 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 2979 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/07/2018 12:00:00 AM 3   Permit Number 781325 5999951.23823 2116389.65594 37.7911983214916 -122.444071670681 (37.7911983214916, -122.444071670681) 13 6 1 29490 27
159609 102525 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 310 Walnut St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/30/2013 12:00:00 AM 0 3x3 Permit Number 769739 5998596.99117 2115413.44206 37.7884405486385 -122.448686963531 (37.7884405486385, -122.448686963531) 13 6 1 54 31
162323 107645 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1600X Franklin St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/01/2016 12:00:00 AM 3   Permit Number 773331 6005773.76538 2115716.99395 37.7896817924241 -122.423878022401 (37.7896817924241, -122.423878022401) 13 9 1 28858 41
169143 114980 Planning Code 138.1 required 2 Callistemon citrinus :: Lemon Bottlebrush 67 281 32ND AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       2x2   5985853 2114037 37.7839242715215 -122.492677119536 (37.7839242715215, -122.492677119536) 11 6 1 55 33
173695 121962 Planning Code 138.1 required 2 Tree(s) :: 17 20 16th Ave 1 Front Yard : Yard Tree Private 2   11/23/2016 12:00:00 AM 3 5x10 Permit Number 778592 5990850.71184 2114913.60159 37.7866221356037 -122.47545108088 (37.7866221356037, -122.47545108088) 11 6 1 54 33
175587 68987 Planning Code 138.1 required 2 Cordyline australis :: Dracena Palm 64 767 Marina Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   10/06/2016 12:00:00 AM 3 10x10 Permit Number 775182 5999291.63198947 2121477.34728573 37.8051301110493 -122.44672010757 (37.8051301110493, -122.44672010757) 13 9 1 57 17
184280 63407 Planning Code 138.1 required 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 2125 Broderick St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/29/2016 12:00:00 AM 3 3x3 Permit Number 770314 6000344.0086 2116075.34024 37.7903576909945 -122.442690122255 (37.7903576909945, -122.442690122255) 13 6 1 29490 27
5412 261620 Planning Code 138.1 required 2 Tree(s) :: 17 1633 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2020 12:00:00 AM 3 3x3   6006860 2117000 37.7932658708928 -122.420210847334 (37.7932658708928, -122.420210847334) 13 9 10 28858 32
78246 143041 Planning Code 138.1 required 2 Olea europaea 'Fruitless' :: Fruitless Olive 177 2000 Powell St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/29/2017 12:00:00 AM 3 Width 0ft Permit Number 780933 6009568.471 2120534.3867 37.8031226669303 -122.411089086343 (37.8031226669303, -122.411089086343) 3 1 10 308 23
104150 257920 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 1490x Green St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/04/2019 12:00:00 AM 3 3x3 Permit Number 779557 6005922 2118675 37.79781210117 -122.423575535726 (37.79781210117, -122.423575535726) 13 9 10 28858 32
160601 255300 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1238 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/07/2018 12:00:00 AM 3 3x3 Permit Number 777218 6006649 2115006 37.7877789501949 -122.420799295532 (37.7877789501949, -122.420799295532) 13 9 10 28858 21
171427 116774 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1106 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/28/2016 12:00:00 AM 3 3x3   6008811.21548 2117995.14613 37.7961080479024 -122.413529902601 (37.7961080479024, -122.413529902601) 5 1 10 308 21
179226 253869 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 1601 Larkin St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/27/2017 12:00:00 AM 3 3x3 Permit Number 56289 6007037 2116831 37.7928118105792 -122.419586418272 (37.7928118105792, -122.419586418272) 13 9 10 28858 32
7494 243413 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 77 Belgrave Ave 1 Sidewalk: Property side : Yard Tree Private 2   11/12/2019 12:00:00 AM 3 6x6 Permit Number 781419 5998151.68157 2104894.95588 37.7595340204918 -122.449469463666 (37.7595340204918, -122.449469463666) 15 5 11 28862 12
16386 262532 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 815 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/12/2020 12:00:00 AM 3 4x4 Permit Number 781917 5999987.51846 2111668.14853 37.7782363548085 -122.443606817465 (37.7782363548085, -122.443606817465) 15 5 11 29490 16
34845 119285 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 400 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/28/2016 12:00:00 AM 3 4x4   6005873 2111410 37.7778614491402 -122.423228396467 (37.7778614491402, -122.423228396467) 7 9 11 28852 10
46287 164504 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1241 Shrader St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/12/2018 12:00:00 AM 3 4x4 Permit Number 775664 5997725 2106255 37.7632439412228 -122.451043208712 (37.7632439412228, -122.451043208712) 15 5 11 29492 9
49446 257939 Planning Code 138.1 required 2 Tree(s) :: 17 65 Buena Vista Ave East 1 Sidewalk: Curb side : Cutout Tree Private 2   02/01/2019 12:00:00 AM 3 3x3 Permit Number 779175 6001128.17111 2108817.40029 37.7704739053605 -122.439456486198 (37.7704739053605, -122.439456486198) 15 5 11 29492 9
61488 254585 Planning Code 138.1 required 2 Olea europaea 'Fruitless' :: Fruitless Olive 177 1236 Arguello Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5995818 2107128 37.7655316119834 -122.457702020035 (37.7655316119834, -122.457702020035) 15 5 11 29492 12
81759 256725 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 432 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/05/2018 12:00:00 AM 3 3x3 Permit Number 781907 5993569.91313 2105305.27634 37.7603974888061 -122.465345170025 (37.7603974888061, -122.465345170025) 1 8 11 56 12
152234 255608 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 949 Fell St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002910 2110236 37.7744702748436 -122.433394524315 (37.7744702748436, -122.433394524315) 15 5 11 29492 10
153036 256778 Planning Code 138.1 required 2 Tree(s) :: 17 1231 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 4x4 Permit Number 782672 6001926.50082 2110819.32275 37.7760160870933 -122.436838397294 (37.7760160870933, -122.436838397294) 15 5 11 29492 10
161064 114972 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1431 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/07/2018 12:00:00 AM 3 3x3 Permit Number 777191 6000962.5 2110659.8 37.7755232425188 -122.440161680014 (37.7755232425188, -122.440161680014) 15 5 11 29492 10
173303 241645 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 472 Oak St 1 : Tree Private 2   09/17/2018 12:00:00 AM 3 Width 3ft Permit Number 774132 6004722.92891 2110216.20564 37.7745186107768 -122.427121843201 (37.7745186107768, -122.427121843201) 7 9 11 28852 10
12151 145130 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 218 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/24/2020 12:00:00 AM 3 4x4 Permit Number 785634 5992772.08387 2113986.425 37.7841875521538 -122.468736166845 (37.7841875521538, -122.468736166845) 11 6 2 54 11
16618 251060 Planning Code 138.1 required 2 Metrosideros excelsa :: New Zealand Xmas Tree 16 5418 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft Permit Number 777516 5990225.155 2112720.9896 37.7805655538274 -122.477455019941 (37.7805655538274, -122.477455019941) 11 6 2 55 26
17123 254549 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 170 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/04/2020 12:00:00 AM 3 3x3   5992784 2114350 37.7851865177567 -122.46872140612 (37.7851865177567, -122.46872140612) 11 6 2 54 11
20105 255010 Planning Code 138.1 required 2 :: 45 619 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x6   5989082.77589 2111106.98355 37.7760675897916 -122.481288779285 (37.7760675897916, -122.481288779285) 11 6 2 55 26
24808 254852 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2816 Clement St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/29/2018 12:00:00 AM 3 3x3   5986739 2113291 37.7819277358837 -122.48955705182 (37.7819277358837, -122.48955705182) 11 6 2 55 26
43838 253762 Planning Code 138.1 required 2 :: 45 520 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5993490 2111935 37.7785963431655 -122.466103329181 (37.7785963431655, -122.466103329181) 11 6 2 54 11
62537 121276 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 369 18th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 4.5x15 Permit Number 777516 5990184 2112906 37.781071152831 -122.477610920079 (37.781071152831, -122.477610920079) 11 6 2 55 26
79208 43753 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 350 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/26/2000 12:00:00 AM 10   Permit Number 781765 5991242.53743 2113051.18607 37.781531164196 -122.473959543362 (37.781531164196, -122.473959543362) 11 6 2 54 26
113032 111713 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 3038 CLEMENT ST 1 Sidewalk: Curb side : Cutout Tree Private 2   12/02/2015 12:00:00 AM 1 3x3 Permit Number 777015 5986051 2113265 37.7818161572934 -122.491935266217 (37.7818161572934, -122.491935266217) 11 6 2 55 26
139523 254363 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 634 45th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/06/2018 12:00:00 AM 3 3x3 Permit Number 772779 5981973.79907 2111426.3014 37.7765284742444 -122.505903875162 (37.7765284742444, -122.505903875162) 11 6 2 55 26
162442 255923 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 539 36th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/07/2018 12:00:00 AM 3   Permit Number 774708 5984698.21016 2112191.31166 37.7787889555839 -122.496535962511 (37.7787889555839, -122.496535962511) 11 6 2 55 26
176912 255710 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 70 Beaumont Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996728 2112568 37.7805206716372 -122.454947659336 (37.7805206716372, -122.454947659336) 11 6 2 54 16
178223 256896 Planning Code 138.1 required 2 Olea europaea 'Fruitless' :: Fruitless Olive 177 470 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/31/2018 12:00:00 AM 3 3x3 Permit Number 780643 5985651.17942 2112710.44444 37.7802701294342 -122.493277571063 (37.7802701294342, -122.493277571063) 11 6 2 55 26
2139 251538 Planning Code 138.1 required 2 Brahea edulis :: Guadalupe Palm 218 1746 Great Hwy 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5981086 2103156 37.753768326371 -122.508360924805 (37.753768326371, -122.508360924805) 1 8 3 56 35
4524 183636 Planning Code 138.1 required 2 Pittosporum crassifolium :: Karo Tree 95 1478 47th Ave 1 Sidewalk: Curb side : Yard Tree Private 2   07/02/2020 12:00:00 AM 3 3x9 Permit Number 781673 5981570.9282 2105017.3718 37.7589076903569 -122.506822015648 (37.7589076903569, -122.506822015648) 1 8 3 56 35
4820 253072 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 1350 46th Ave 1 Sidewalk: Property side : Yard Tree Private 2   12/18/2019 12:00:00 AM 3 6x10 Permit Number 780489 5981849.66657 2105897.22193 37.7613399178539 -122.50592325662 (37.7613399178539, -122.50592325662) 1 8 3 56 35
6587 261546 Planning Code 138.1 required 2 Olea europaea 'Fruitless' :: Fruitless Olive 177 1955 35th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/21/2020 12:00:00 AM 3 3X3 Permit Number 783144 5985360.77923 2101907.46183 37.750591180724 -122.493485992107 (37.750591180724, -122.493485992107) 1 8 3 29491 35
9544 261378 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1762 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/08/2020 12:00:00 AM 3 3x3 Permit Number 784740 5990006.33488 2103376.99766 37.7548967913393 -122.477528860126 (37.7548967913393, -122.477528860126) 1 8 3 56 35
14905 260579 Planning Code 138.1 required 2 Tree(s) :: 17 1662 36th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/03/2019 12:00:00 AM 3 3x3 Permit Number 782799 5985048 2103886 37.7560054004173 -122.494713443881 (37.7560054004173, -122.494713443881) 1 8 3 56 35
14929 256105 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1935 34th Ave 1 Sidewalk: Property side : Cutout Tree Private 2 Port 09/06/2018 12:00:00 AM 3 3x3 Permit Number 778629 5985666.45669 2102048.38182 37.7509959848908 -122.492439326416 (37.7509959848908, -122.492439326416) 1 8 3 29491 35
15585 258769 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 1633 Noriega St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/19/2019 12:00:00 AM 3 3x3   5988962.35654 2103065.4403 37.7539807026125 -122.481116375927 (37.7539807026125, -122.481116375927) 1 8 3 56 35
16409 54948 Planning Code 138.1 required 2 Metrosideros excelsa :: New Zealand Xmas Tree 16 1531 44th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/28/1972 12:00:00 AM 15 6x3 Permit Number 779312 5982470.8167 2104681.2673 37.7580377938942 -122.503684942327 (37.7580377938942, -122.503684942327) 1 8 3 56 35
20702 37086 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1426 46th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/22/2017 12:00:00 AM 3   Permit Number 780691 5981873.63686209 2105374.96731705 37.7599073668224 -122.505801636192 (37.7599073668224, -122.505801636192) 1 8 3 56 35
24135 254150 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 2123 30th Ave 1 Sidewalk: Property side : Cutout Tree Private 2   01/09/2018 12:00:00 AM 3 3x6 Permit Number 778310 5986951.71761 2100810.65655 37.7476725845461 -122.487903895201 (37.7476725845461, -122.487903895201) 1 8 3 29491 35
25630 255709 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 2458 40th Ave 1 Sidewalk: Property side : Cutout Tree Private 2   06/28/2018 12:00:00 AM 3 3x3 Permit Number 775348 5983968.47211 2098431.39968 37.740965323086 -122.498043953777 (37.740965323086, -122.498043953777) 1 8 3 29491 35
35612 255646 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1542 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/20/2018 12:00:00 AM 3 3x5 Permit Number 779777 5989956.05847 2104865.26605 37.7589802621415 -122.477811515827 (37.7589802621415, -122.477811515827) 1 8 3 56 35
35632 182616 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1856 28th Ave 1 Sidewalk: Curb side : Yard Tree Private 2   11/16/2018 12:00:00 AM 0 Width 0ft Permit Number 780914 5987553.0951 2102630.1854 37.7527035840583 -122.485957928463 (37.7527035840583, -122.485957928463) 1 8 3 56 35
36667 112972 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 4099x ULLOA ST 1 Sidewalk: Property side : Cutout Tree Private 2   10/20/2015 12:00:00 AM 1 3x3 Permit Number 773327 5983385 2098079 37.7399635032694 -122.500035309652 (37.7399635032694, -122.500035309652) 1 8 3 29491 35
37533 253101 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 3000x Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/25/2017 12:00:00 AM 3 3x3 Permit Number 778939 5986427 2106455 37.7631397866436 -122.490133427734 (37.7631397866436, -122.490133427734) 1 8 3 56 35
37901 251534 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1818 42nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/16/2017 12:00:00 AM 3 3x3   5983226 2102732 37.7527300247516 -122.500929082058 (37.7527300247516, -122.500929082058) 1 8 3 56 35
39420 253554 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 1855 30th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/22/2017 12:00:00 AM 3 3x3 Permit Number 778968 5986885.63083 2102641.2721 37.7526951056681 -122.488266922919 (37.7526951056681, -122.488266922919) 1 8 3 56 35
42827 253341 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1935 46th Ave 1 Sidewalk: Property side : Cutout Tree Private 2   08/23/2017 12:00:00 AM 3 3x3 Permit Number 769984 5981944.68101 2101921.14451 37.7504283278742 -122.505299944249 (37.7504283278742, -122.505299944249) 1 8 3 29491 35
49225 53968 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 1354 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/20/2015 12:00:00 AM   3x3 Permit Number 773113 5988678.33594659 2106104.92629407 37.7623097958053 -122.482321255458 (37.7623097958053, -122.482321255458) 1 8 3 56 35
53166 112854 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 2622 JUDAH ST 1 Sidewalk: Curb side : Cutout Tree Private 2   10/20/2015 12:00:00 AM   3x3 Permit Number 774112 5986417 2105735 37.7611622818619 -122.49011505097 (37.7611622818619, -122.49011505097) 1 8 3 56 35
64249 252820 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 2339 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/21/2017 12:00:00 AM 3 3x3   5983590.30233 2099230.68636 37.743137766616 -122.499410557243 (37.743137766616, -122.499410557243) 1 8 3 29491 35
64628 113721 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 1526 22nd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/08/2015 12:00:00 AM   3x3   5989360 2104938.6 37.7591470062831 -122.479878309336 (37.7591470062831, -122.479878309336) 1 8 3 56 35
77927 187639 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1671 34th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   02/22/2017 12:00:00 AM 3 3x6   5985585 2103854 37.7559489545124 -122.492853989295 (37.7559489545124, -122.492853989295) 1 8 3 56 35
81070 256613 Planning Code 138.1 required 2 Callistemon citrinus :: Lemon Bottlebrush 67 2214 36th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/13/2018 12:00:00 AM 3 3x3 Permit Number 781468 5985177 2100108 37.745639596763 -122.493988903155 (37.745639596763, -122.493988903155) 1 8 3 29491 35
82445 254665 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 1771 20th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/26/2018 12:00:00 AM 3 3x3 Permit Number 778441 5989948 2103325 37.7547506343258 -122.477726795598 (37.7547506343258, -122.477726795598) 1 8 3 56 35
84340 115405 Planning Code 138.1 required 2 Podocarpus macrophyllus :: Yew Pine 137 2050 43RD AVE 1 Sidewalk: Property side : Cutout Tree Private 2   01/29/2016 12:00:00 AM 3 3x3   5982969 2101168 37.7484206232379 -122.50170211889 (37.7484206232379, -122.50170211889) 1 8 3 29491 35
93370 255421 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 2727 34th Ave 1 Sidewalk: Curb side : Yard Tree Private 2   05/21/2018 12:00:00 AM 3 10x10 Permit Number 780223 5985829 2096861 37.7367623321138 -122.491495459369 (37.7367623321138, -122.491495459369) 1 8 3 29491 35
95009 173748 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 1259 21st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/13/2017 12:00:00 AM 3 3x3 Permit Number 773489 5989520 2106786 37.7642287625639 -122.479460118399 (37.7642287625639, -122.479460118399) 1 8 3 56 35

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