trees

1,011 rows where qLegalStatus_id = 2 sorted by PlantDate

✎ View and edit SQL

This data as json, CSV (advanced)

Police Districts ✖

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)
152110 239088 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 3855 26th St 1 Sidewalk: Curb side : Cutout Tree DPW 1     13 3x3 Permit Number 780732 6004794.15723 2100737.40071 37.748496089722 -122.426200479689 (37.748496089722, -122.426200479689) 2 4 5 63 22
152218 152308 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 3420 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 4x4   6006693.54336 2105565.92746 37.7618612870018 -122.419975023524 (37.7618612870018, -122.419975023524) 8 4 7 28859 19
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
152599 121532 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 333 Beale St 8 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
152958 258304 Planning Code 138.1 required 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 2946 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008567 2103911 37.7574226061115 -122.413378415329 (37.7574226061115, -122.413378415329) 2 4 7 28859 19
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
154592 109464 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 9 Sidewalk: Curb side : Cutout Tree Private 2     8 4x4 Permit Number 773752 6013338.99753 2109402.36294 37.7727674463814 -122.39725990323 (37.7727674463814, -122.39725990323) 14 2 9 310 20
156122 115979 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2x Olmstead St 4 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6011610.19593 2091240.25279 37.7228018257296 -122.401963063449 (37.7228018257296, -122.401963063449) 10 3 7 309 28
158236 116267 Planning Code 138.1 required 2 Acer japonicum :: Japanese Maple 124 717 PARIS ST 1 Front Yard : Yard Tree Private 2       3x3   6001138 2089523 37.7174966063475 -122.438040195581 (37.7174966063475, -122.438040195581) 9 7 6 28861 5
158751 115978 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2x Olmstead St 3 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6011623.9012 2091244.95295 37.7228154963084 -122.40191601721 (37.7228154963084, -122.40191601721) 10 3 7 309 28
160441 117453 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 236 Shipley St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 776408 6011539.59396 2111788.0027 37.779217520823 -122.403652162024 (37.779217520823, -122.403652162024) 14 2 9 28856 34
160718 117479 Planning Code 138.1 required 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 601 PACHECO ST 1 Sidewalk: Property side : Cutout Tree Private 2       3x9   5993107 2101833 37.7508368102529 -122.466693753982 (37.7508368102529, -122.466693753982) 1 8 4 29491 12
160771 187941 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 2 Sidewalk: Curb side : Yard Tree Private 2     3     6015065.49236 2115322.58848 37.7891190169896 -122.391701726057 (37.7891190169896, -122.391701726057) 6 2 9 28855 6
160922 121508 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 300 Folsom St 3 Sidewalk: Property side : Cutout Tree Private 2     6 3x3   6012258.9126 2112729.3972 37.7818425275943 -122.401229897449 (37.7818425275943, -122.401229897449) 6 2 9 28856 34
162044 247938 Planning Code 138.1 required 2 Prunus cerasifera :: Cherry Plum 7 29 Joy St 1 Unaccepted Street : Yard Tree DPW 1     9   Permit Number 775404 6010254.90659 2098918.71089 37.7438095066969 -122.407189031056 (37.7438095066969, -122.407189031056) 2 7 7 28859 2
163344 115976 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2x Olmstead St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6011653.53869 2091254.58415 37.7228435956385 -122.401814242757 (37.7228435956385, -122.401814242757) 10 3 7 309 28
164050 114792 Planning Code 138.1 required 2 Callistemon citrinus :: Lemon Bottlebrush 67 10 Linares Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x10   5993887.4 2102332.1 37.7522522176371 -122.464031307011 (37.7522522176371, -122.464031307011) 1 8 4 29491 40
164491 251061 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 5418 Geary Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft Permit Number 777516 5990182.6788 2112719.9143 37.7805601365444 -122.477601885097 (37.7805601365444, -122.477601885097) 11 6 2 55 26
165093 251522 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 173 Sanchez St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884) 7 9 5 28862 3
166298 251296 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 2190X Market St 2 Sidewalk: Curb side : Cutout Tree Private 2       4X4   6003624.7851 2107240.8343 37.7662868072343 -122.430708166736 (37.7662868072343, -122.430708166736) 7 4 5 28862 3
166329 117480 Planning Code 138.1 required 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 601 PACHECO ST 2 Sidewalk: Property side : Cutout Tree Private 2       3x9   5993107 2101833 37.7508368102529 -122.466693753982 (37.7508368102529, -122.466693753982) 1 8 4 29491 12
167011 254235 Planning Code 138.1 required 2 Syzygium australe :: Eugenia 228 454 Ralston St 1 Unaccepted Street : Cutout Tree Private 2       10x10   5992261 2090872 37.7206918008503 -122.468821743954 (37.7206918008503, -122.468821743954) 9 8 6 64 24
168121 121519 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 14 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
168906 109469 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 4x4 Permit Number 773752 6013484.3589 2109540.27035 37.7731542007368 -122.3967667483 (37.7731542007368, -122.3967667483) 14 2 9 310 20
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
169946 187675 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 2690 Harrison St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008898.65774693 2102801.94608421 37.7543960104367 -122.41215302657 (37.7543960104367, -122.41215302657) 2 4 7 28859 19
170182 258184 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 95 Laidley St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003372 2097903 37.74063299685 -122.430916015884 (37.74063299685, -122.430916015884) 2 7 5 63 7
170258 121530 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 333 Beale St 6 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
170362 187678 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 2690 Harrison St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008898.65774693 2102801.94608421 37.7543960104367 -122.41215302657 (37.7543960104367, -122.41215302657) 2 4 7 28859 19
171370 121537 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 201 Folsom St 4 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
172871 256721 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 1025 Powhattan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 776275 6009358 2098062 37.7414069300959 -122.410229861131 (37.7414069300959, -122.410229861131) 10 7 7 28859 2
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
177060 116640 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 270 Brannan St 2 Sidewalk: Property side : Cutout Tree Private 2     1 4x4   6015158 2112983 37.7827001752808 -122.391218053322 (37.7827001752808, -122.391218053322) 6 2 9 28856 6
178528 121507 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 300 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6012241.512 2112714.7441 37.7818013227969 -122.401289065763 (37.7818013227969, -122.401289065763) 6 2 9 28856 34
180615 122686 Planning Code 138.1 required 2 Podocarpus gracilor :: Fern Pine 51 3474 17th St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 3x3   6005720 2106109 37.7632975389877 -122.423380737252 (37.7632975389877, -122.423380737252) 8 4 5 28859 19
180665 152326 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 49 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 4x4   6006659.4536 2105583.0811 37.7619064662287 -122.420094144155 (37.7619064662287, -122.420094144155) 8 4 7 28859 19
181676 196592 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 43 Lafayette St 4 : Tree Private 2     8 Width 3ft Permit Number 772992 6007533.59843 2109642.31042 37.7731013709756 -122.417358489209 (37.7731013709756, -122.417358489209) 8 2 9 28853 19
183412 121520 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 15 Sidewalk: Property side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
184177 121536 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 201 Folsom St 3 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
184275 121529 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 333 Beale St 5 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
184372 117482 Planning Code 138.1 required 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 601 PACHECO ST 4 Sidewalk: Property side : Cutout Tree Private 2       3x9   5993107 2101833 37.7508368102529 -122.466693753982 (37.7508368102529, -122.466693753982) 1 8 4 29491 12
184490 253342 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 200 Arguello Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2       3x6 Permit Number 778434 5995550.18022 2114806.2223 37.7865985940285 -122.459184390305 (37.7865985940285, -122.459184390305) 11 6 1 54 31
185007 187679 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 2690 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008898.65774693 2102801.94608421 37.7543960104367 -122.41215302657 (37.7543960104367, -122.41215302657) 2 4 7 28859 19
185771 121538 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 201 Folsom St 5 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
186332 121541 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 318 Main St 2 Sidewalk: Curb side : Cutout Tree Private 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 6 2 9 28855 6
186896 114793 Planning Code 138.1 required 2 Tree(s) :: 17 10 Linares Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x10 Permit Number 777094 5993887.4 2102332.1 37.7522522176371 -122.464031307011 (37.7522522176371, -122.464031307011) 1 8 4 29491 40
187328 117481 Planning Code 138.1 required 2 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 601 PACHECO ST 3 Sidewalk: Property side : Cutout Tree Private 2       3x9   5993107 2101833 37.7508368102529 -122.466693753982 (37.7508368102529, -122.466693753982) 1 8 4 29491 12
187581 121535 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 201 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
188951 115977 Planning Code 138.1 required 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 2x Olmstead St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6011639.0005 2091249.90123 37.7228299259539 -122.40186416949 (37.7228299259539, -122.40186416949) 10 3 7 309 28
190355 121534 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 201 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
192715 121509 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
193110 109470 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 4x4 Permit Number 773752 6013467.61268 2109523.16527 37.7731063019529 -122.396823476633 (37.7731063019529, -122.396823476633) 14 2 9 310 20
194150 121524 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 280 Beale St 3 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
194230 251520 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 173 Sanchez St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x15   6003549.6097 2107381.8851 37.7666698392386 -122.430978251884 (37.7666698392386, -122.430978251884) 7 9 5 28862 3
194418 265072 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 2027 41st Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5983517.97374 2101348.17171 37.7489475550359 -122.499817124771 (37.7489475550359, -122.499817124771) 1 8 3 29491 35
4642 254121 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 150 Jennings St 3 Sidewalk: Property side : Yard Tree Private 2   01/02/2018 12:00:00 AM 3   Permit Number 781123                    
4781 254118 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 1 Newhall St 5 Sidewalk: Property side : Yard Tree Private 2   01/02/2018 12:00:00 AM 3   Permit Number 781123 6018720.08887 2097065.44422 37.739190920851 -122.377789500691 (37.739190920851, -122.377789500691) 10 3 8 58 1
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                    
9263 254120 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 150 Jennings St 2 Sidewalk: Property side : Yard Tree Private 2   01/02/2018 12:00:00 AM 3   Permit Number 781123                    
18507 254122 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 150 Jennings St 4 Sidewalk: Property side : Yard Tree Private 2   01/02/2018 12:00:00 AM 3   Permit Number 781123                    
48804 254117 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 1 Newhall St 4 Sidewalk: Property side : Yard Tree Private 2   01/02/2018 12:00:00 AM 3   Permit Number 781123 6018720.08887 2097065.44422 37.739190920851 -122.377789500691 (37.739190920851, -122.377789500691) 10 3 8 58 1
74634 254115 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 1 Newhall St 2 Sidewalk: Property side : Yard Tree Private 2   01/02/2018 12:00:00 AM 3   Permit Number 781123 6018720.08887 2097065.44422 37.739190920851 -122.377789500691 (37.739190920851, -122.377789500691) 10 3 8 58 1
75135 254116 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 1 Newhall St 3 Sidewalk: Property side : Yard Tree Private 2   01/02/2018 12:00:00 AM 3   Permit Number 781123 6018720.08887 2097065.44422 37.739190920851 -122.377789500691 (37.739190920851, -122.377789500691) 10 3 8 58 1
118980 254114 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 1 Newhall St 1 Sidewalk: Property side : Yard Tree Private 2   01/02/2018 12:00:00 AM 3   Permit Number 781123 6018720.08887 2097065.44422 37.739190920851 -122.377789500691 (37.739190920851, -122.377789500691) 10 3 8 58 1
99548 256905 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 338 Princeton St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/03/2019 12:00:00 AM 3 3x3 Permit Number 781421 6007824.5446 2092249.93927 37.7253622000817 -122.415120729164 (37.7253622000817, -122.415120729164) 9 3 7 309 28
34711 44001 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 2701X 17th St 5 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2016 12:00:00 AM   3x3 Permit Number 775718 6009464.30573862 2106385.10315991 37.7642662704227 -122.410449858863 (37.7642662704227, -122.410449858863) 8 4 7 28859 19
37180 44003 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 2701X 17th St 9 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2016 12:00:00 AM   3x3 Permit Number 775718 6009464.30573862 2106385.10315991 37.7642662704227 -122.410449858863 (37.7642662704227, -122.410449858863) 8 4 7 28859 19
72715 44010 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 405x Florida St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2016 12:00:00 AM   3x3 Permit Number 775718 6009464.30573862 2106385.10315991 37.7642662704227 -122.410449858863 (37.7642662704227, -122.410449858863) 8 4 7 28859 19
145930 44005 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 2701X 17th St 7 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2016 12:00:00 AM   3x3 Permit Number 775718 6009464.30573862 2106385.10315991 37.7642662704227 -122.410449858863 (37.7642662704227, -122.410449858863) 8 4 7 28859 19
176140 44012 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 405X Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2016 12:00:00 AM   3x3 Permit Number 775718 6009464.30573862 2106385.10315991 37.7642662704227 -122.410449858863 (37.7642662704227, -122.410449858863) 8 4 7 28859 19
177064 44004 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 2701X 17th St 8 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2016 12:00:00 AM   3x3 Permit Number 775718 6009464.30573862 2106385.10315991 37.7642662704227 -122.410449858863 (37.7642662704227, -122.410449858863) 8 4 7 28859 19
191118 44013 Planning Code 138.1 required 2 Jacaranda mimosifolia :: Jacaranda 50 2701X 17th St 6 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2016 12:00:00 AM   3x3 Permit Number 775718 6009464.30573862 2106385.10315991 37.7642662704227 -122.410449858863 (37.7642662704227, -122.410449858863) 8 4 7 28859 19
125325 256910 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 835 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/07/2019 12:00:00 AM 3 3x3   6007598 2104806 37.7598256170474 -122.416793017555 (37.7598256170474, -122.416793017555) 2 4 7 28859 19
4912 261377 Planning Code 138.1 required 2 Olea Majestic Beauty :: 183 3015 25th Ave 2 Sidewalk: Property side : Yard Tree Private 2   01/08/2020 12:00:00 AM 3 4x10 Permit Number 784883 5988814.87181 2095155.07295 37.7322523337557 -122.481047245899 (37.7322523337557, -122.481047245899) 1 8 4 64 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
17863 261376 Planning Code 138.1 required 2 Olea Majestic Beauty :: 183 3015 25th Ave 1 Sidewalk: Property side : Yard Tree Private 2   01/08/2020 12:00:00 AM 3 4x10 Permit Number 784883 5988814.87181 2095155.07295 37.7322523337557 -122.481047245899 (37.7322523337557, -122.481047245899) 1 8 4 64 35
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                    
8723 254152 Planning Code 138.1 required 2 Tree(s) :: 17 201 Steuart St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/09/2018 12:00:00 AM 3 4x4 Permit Number 781165                    
9600 254154 Planning Code 138.1 required 2 Tree(s) :: 17 201 Steuart St 4 Sidewalk: Curb side : Cutout Tree Private 2   01/09/2018 12:00:00 AM 3 4x4 Permit Number 781165                    
15617 254153 Planning Code 138.1 required 2 Tree(s) :: 17 201 Steuart St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/09/2018 12:00:00 AM 3 4x4 Permit Number 781165                    
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
174013 257892 Planning Code 138.1 required 2 Leptospermum scoparium 'Snow White' :: New Zealand White Tea Tree 493 91 Canyon Dr 1 Front Yard : Yard Tree Private 2   01/11/2019 12:00:00 AM 3 3x3   6002890 2086311 37.7087766368694 -122.43175513536 (37.7087766368694, -122.43175513536) 9 7 6 28861 5
57149 115098 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 537 Natoma St 4 Sidewalk: Curb side : Cutout Tree Private 2   01/12/2016 12:00:00 AM 2 2x4 Permit Number 769476 6010148.06204 2111925.42664 37.7795170247346 -122.408475763058 (37.7795170247346, -122.408475763058) 14 2 9 28853 34
98758 101942 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 537 Natoma St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/12/2016 12:00:00 AM 2 2x4 Permit Number 769476 6010108.29372 2111885.47528 37.7794051005107 -122.408610520167 (37.7794051005107, -122.408610520167) 14 2 9 28853 34
122740 115096 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 537 Natoma St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/12/2016 12:00:00 AM 2 2x4 Permit Number 769476 6010119.08101 2111896.4319 37.7794357889593 -122.408573975335 (37.7794357889593, -122.408573975335) 14 2 9 28853 34
183224 115097 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 537 Natoma St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/12/2016 12:00:00 AM 2 2x4 Permit Number 769476 6010133.89472 2111910.59383 37.779475503918 -122.408523727481 (37.779475503918, -122.408523727481) 14 2 9 28853 34
40028 57959 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 336 Hanover St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/13/2017 12:00:00 AM 3 3x3 Permit Number 774423 5999490.29697456 2086502.70799744 37.7091097236101 -122.443518692288 (37.7091097236101, -122.443518692288) 9 7 6 28861 5
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
639 261347 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 3300x Alemany Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1   01/13/2020 12:00:00 AM 3 3X3 Permit Number 780859 5994476 2087151 37.7106025369579 -122.460895688785 (37.7106025369579, -122.460895688785) 9 8 6 28861 24
13199 261348 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 3300x Alemany Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1   01/13/2020 12:00:00 AM 3 3X3 Permit Number 784323 5994476 2087151 37.7106025369579 -122.460895688785 (37.7106025369579, -122.460895688785) 9 8 6 28861 24
14258 261352 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 297 Sagamore St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/13/2020 12:00:00 AM 3 3x3 Permit Number 780859 5994172 2087374 37.7111973453091 -122.461962532307 (37.7111973453091, -122.461962532307) 9 8 6 28861 24
15290 25338 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 3300X Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/13/2020 12:00:00 AM 3 3X3 Permit Number 780859 5994476 2087151 37.7106025369579 -122.460895688785 (37.7106025369579, -122.460895688785) 9 8 6 28861 24
16027 261349 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 3300x Alemany Blvd 4 Sidewalk: Curb side : Cutout Tree DPW 1   01/13/2020 12:00:00 AM 3 3X3 Permit Number 784323 5994476 2087151 37.7106025369579 -122.460895688785 (37.7106025369579, -122.460895688785) 9 8 6 28861 24
19087 261350 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 299 Sagamore St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/13/2020 12:00:00 AM 3 3x3 Permit Number 784323 5994169 2087374 37.7111971725927 -122.461972900974 (37.7111971725927, -122.461972900974) 9 8 6 28861 24
19183 261351 Planning Code 138.1 required 2 Lagunaria patersonii :: Primrose Tree 6 299 Sagamore St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/13/2020 12:00:00 AM 3 3x3 Permit Number 784323 5994169 2087374 37.7111971725927 -122.461972900974 (37.7111971725927, -122.461972900974) 9 8 6 28861 24
38353 256715 Planning Code 138.1 required 2 Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 443 1540 17th Ave 1 Sidewalk: Property side : Cutout Tree Private 2   01/15/2019 12:00:00 AM 3 4x8 Permit Number 779534 5990911 2104908 37.7591529734205 -122.474512031039 (37.7591529734205, -122.474512031039) 1 8 4 56 12
6889 173762 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1405 Van Dyke Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   01/17/2017 12:00:00 AM 3 3x3 Permit Number 773007 6015436.02818 2092717.71929 37.727071439337 -122.388840955894 (37.727071439337, -122.388840955894) 10 3 8 58 1
31747 173761 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1405 Van Dyke Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/17/2017 12:00:00 AM 3 3x3 Permit Number 773007 6015436.02818 2092717.71929 37.727071439337 -122.388840955894 (37.727071439337, -122.388840955894) 10 3 8 58 1
32980 147589 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 369 18th Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2019 12:00:00 AM 3 Width 4ft Permit Number 777516 5990252.11416 2112971.56981 37.7812551417606 -122.477380075345 (37.7812551417606, -122.477380075345) 11 6 2 55 26
47139 257910 Planning Code 138.1 required 2 Tree(s) :: 17 199x Townsend St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2019 12:00:00 AM 3 3x3   6014800 2111540 37.778718149686 -122.392355631341 (37.778718149686, -122.392355631341) 6 2 9 28856 20

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