trees

169 rows where DBH = "" and qLegalStatus_id = 2 sorted by Longitude

✎ View and edit SQL

This data as json, CSV (advanced)

DBH ✖

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)
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                      
14753 259380 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 198X Eddy St 1 Sidewalk: Curb side : Cutout Tree DPW 1                              
147146 256033 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1459 Shafter Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015639 2093574 37.7294338636754 -122.388199012441 (37.7294338636754, -122.388199012441) 10 3 8 58 1
20157 121528 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 333 Beale St 4 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
40138 121526 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 333 Beale St 2 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
52894 121531 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 333 Beale St 7 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
55960 121539 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 201 Folsom St 6 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
100470 121527 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 333 Beale St 3 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
103030 121533 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 333 Beale St 9 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6015114 2115064 37.7884116849322 -122.391515808663 (37.7884116849322, -122.391515808663) 6 2 9 28855 6
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
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
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
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
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
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
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
21732 121544 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 318 Main St 5 Sidewalk: Curb side : Cutout Tree Private 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 6 2 9 28855 6
30239 121540 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 318 Main St 1 Sidewalk: Curb side : Cutout Tree Private 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 6 2 9 28855 6
46657 121543 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 318 Main St 4 Sidewalk: Curb side : Cutout Tree Private 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 6 2 9 28855 6
48226 121547 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 318 Main St 8 Sidewalk: Curb side : Cutout Tree Private 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 6 2 9 28855 6
73712 121545 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 318 Main St 6 Sidewalk: Curb side : Cutout Tree Private 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 6 2 9 28855 6
117838 121542 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 318 Main St 3 Sidewalk: Curb side : Cutout Tree Private 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 6 2 9 28855 6
139844 121546 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 318 Main St 7 Sidewalk: Curb side : Cutout Tree Private 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 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
36960 113338 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2X STANFORD ST 3 Sidewalk: Property side : Cutout Tree Private 2   11/10/2015 12:00:00 AM   3x9 Permit Number 770912 6014727 2112481 37.7812978691674 -122.392674013487 (37.7812978691674, -122.392674013487) 6 2 9 28856 6
125850 113335 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2X STANFORD ST 1 Sidewalk: Property side : Cutout Tree Private 2   11/10/2015 12:00:00 AM   3x9 Permit Number 770912 6014727 2112481 37.7812978691674 -122.392674013487 (37.7812978691674, -122.392674013487) 6 2 9 28856 6
160249 113337 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2X STANFORD ST 2 Sidewalk: Property side : Cutout Tree Private 2   11/10/2015 12:00:00 AM   3x9 Permit Number 770912 6014727 2112481 37.7812978691674 -122.392674013487 (37.7812978691674, -122.392674013487) 6 2 9 28856 6
25972 121523 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 280 Beale St 2 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
43149 121513 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
62167 121518 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 13 Sidewalk: Property side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
63982 121515 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 10 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
80342 121514 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 9 Sidewalk: Property side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
80358 121522 Planning Code 138.1 required 2 Tilia cordata :: Littleleaf Linden 12 280 Beale St 1 Sidewalk: Curb side : Cutout Tree Private 2       6x10   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
81393 121521 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 16 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
101009 121510 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 5 Sidewalk: Property side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
102091 121512 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 7 Sidewalk: Property side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
106371 121516 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 11 Sidewalk: Property side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
107276 121511 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
149769 121517 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 300 Folsom St 12 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014751 2115177 37.7887018021562 -122.392779649259 (37.7887018021562, -122.392779649259) 6 2 9 28855 6
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
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
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
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
32270 118379 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 340 Fremont St 6 Sidewalk: Curb side : Cutout Tree Private 2       4x6   6014683 2114666 37.7872949366988 -122.392979154362 (37.7872949366988, -122.392979154362) 6 2 9 28855 6
42633 118377 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 340 Fremont St 4 Sidewalk: Curb side : Cutout Tree Private 2       4x6   6014683 2114666 37.7872949366988 -122.392979154362 (37.7872949366988, -122.392979154362) 6 2 9 28855 6
64723 118378 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 340 Fremont St 5 Sidewalk: Curb side : Cutout Tree Private 2       4x6   6014683 2114666 37.7872949366988 -122.392979154362 (37.7872949366988, -122.392979154362) 6 2 9 28855 6
75283 118380 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 340 Fremont St 7 Sidewalk: Curb side : Cutout Tree Private 2       4x6   6014683 2114666 37.7872949366988 -122.392979154362 (37.7872949366988, -122.392979154362) 6 2 9 28855 6
132870 118376 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 340 Fremont St 3 Sidewalk: Curb side : Cutout Tree Private 2       4x6   6014683 2114666 37.7872949366988 -122.392979154362 (37.7872949366988, -122.392979154362) 6 2 9 28855 6
6991 112084 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 99X Fremont St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/23/2015 12:00:00 AM     Permit Number 775592 6013631.8 2115864.7 37.7905278405438 -122.396700174955 (37.7905278405438, -122.396700174955) 12 2 9 28855 6
120325 112085 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 99X Fremont St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/23/2015 12:00:00 AM     Permit Number 775592 6013631.8 2115864.7 37.7905278405438 -122.396700174955 (37.7905278405438, -122.396700174955) 12 2 9 28855 6
56279 116967 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 480 Potrero Ave 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010335.4704597 2106068.8961361 37.7634468367565 -122.407414438937 (37.7634468367565, -122.407414438937) 8 4 8 28859 19
47024 120519 Planning Code 138.1 required 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 520 09th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010156 2108818 37.7709851997146 -122.408229076629 (37.7709851997146, -122.408229076629) 8 2 9 28853 34
90566 120518 Planning Code 138.1 required 2 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 520 09th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010156 2108818 37.7709851997146 -122.408229076629 (37.7709851997146, -122.408229076629) 8 2 9 28853 34
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
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
33539 114537 Planning Code 138.1 required 2 Prunus cerasifera :: Cherry Plum 7 1624 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/23/2015 12:00:00 AM   3x4   6009248.6 2099914.9 37.7464884538144 -122.41073895467 (37.7464884538144, -122.41073895467) 2 7 7 28859 2
180002 258222 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 2997 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/23/2019 12:00:00 AM   3x3   6009042 2101022 37.7495167187784 -122.41153156233 (37.7495167187784, -122.41153156233) 2 4 7 28859 19
36004 187698 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 2880 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008980.17665 2103937.78959 37.7575193538388 -122.41195137385 (37.7575193538388, -122.41195137385) 2 4 7 28859 19
80448 187677 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 2690 Harrison St 5 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
88053 187676 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 2690 Harrison St 4 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
119022 60277 Planning Code 138.1 required 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 2690 Harrison St 7 Sidewalk: Curb side : Cutout Tree Private 2   07/03/2008 12:00:00 AM   3x3 Permit Number 51145 6008898.65774693 2102801.94608421 37.7543960104367 -122.41215302657 (37.7543960104367, -122.41215302657) 2 4 7 28859 19
135962 187674 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 2690 Harrison St 2 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
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
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
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
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
4803 260955 Planning Code 138.1 required 2 Nyssa sylvatica :: Tupelo: Sour Gum 92 1296 Shotwell St 4 Sidewalk: Curb side : Cutout Tree Private 2       4x8   6008013 2100716 37.7486187391462 -122.4150682294 (37.7486187391462, -122.4150682294) 2 4 7 28859 19
11040 260952 Planning Code 138.1 required 2 Nyssa sylvatica :: Tupelo: Sour Gum 92 1296 Shotwell St 1 Sidewalk: Curb side : Cutout Tree Private 2       4x8   6008013 2100716 37.7486187391462 -122.4150682294 (37.7486187391462, -122.4150682294) 2 4 7 28859 19
11620 260954 Planning Code 138.1 required 2 Nyssa sylvatica :: Tupelo: Sour Gum 92 1296 Shotwell St 3 Sidewalk: Curb side : Cutout Tree Private 2       4x8   6008013 2100716 37.7486187391462 -122.4150682294 (37.7486187391462, -122.4150682294) 2 4 7 28859 19
13412 260953 Planning Code 138.1 required 2 Nyssa sylvatica :: Tupelo: Sour Gum 92 1296 Shotwell St 2 Sidewalk: Curb side : Cutout Tree Private 2       4x8   6008013 2100716 37.7486187391462 -122.4150682294 (37.7486187391462, -122.4150682294) 2 4 7 28859 19
22638 113651 Planning Code 138.1 required 2 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 98X 10TH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       4x6 Permit Number 773574 6007947 2110424 37.7752709556829 -122.415983842901 (37.7752709556829, -122.415983842901) 8 2 9 28853 34
26508 113650 Planning Code 138.1 required 2 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 98X 10TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       4x6 Permit Number 773574 6007947 2110424 37.7752709556829 -122.415983842901 (37.7752709556829, -122.415983842901) 8 2 9 28853 34
88035 113653 Planning Code 138.1 required 2 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 98X 10TH ST 5 Sidewalk: Curb side : Cutout Tree Private 2       4x6 Permit Number 773574 6007947 2110424 37.7752709556829 -122.415983842901 (37.7752709556829, -122.415983842901) 8 2 9 28853 34
121557 113652 Planning Code 138.1 required 2 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 98X 10TH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       4x6 Permit Number 773574 6007947 2110424 37.7752709556829 -122.415983842901 (37.7752709556829, -122.415983842901) 8 2 9 28853 34
130377 113654 Planning Code 138.1 required 2 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 98X 10TH ST 6 Sidewalk: Curb side : Cutout Tree Private 2       4x6 Permit Number 773574 6007947 2110424 37.7752709556829 -122.415983842901 (37.7752709556829, -122.415983842901) 8 2 9 28853 34
137539 113649 Planning Code 138.1 required 2 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 98X 10TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       4x6 Permit Number 773574 6007947 2110424 37.7752709556829 -122.415983842901 (37.7752709556829, -122.415983842901) 8 2 9 28853 34
129348 251179 Planning Code 138.1 required 2 Podocarpus gracilor :: Fern Pine 51 1043 Minna St 2 Sidewalk: Property side : Cutout Tree Private 2       3x3   6007668 2109797 37.7735336727503 -122.41690453761 (37.7735336727503, -122.41690453761) 8 2 9 28853 19
138609 251178 Planning Code 138.1 required 2 Podocarpus gracilor :: Fern Pine 51 1043 Minna St 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   6007668 2109797 37.7735336727503 -122.41690453761 (37.7735336727503, -122.41690453761) 8 2 9 28853 19
11346 261371 Planning Code 138.1 required 2 Syagrus romanzoffianum :: Queen Palm 85 105 Bache St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007217 2095358 37.7338620991787 -122.417441127318 (37.7338620991787, -122.417441127318) 2 7 7 28859 2
8190 261370 Planning Code 138.1 required 2 Eriobotrya japonica :: Edible Loquat 119 102 Bache St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007140 2095356 37.7338522748733 -122.417707198486 (37.7338522748733, -122.417707198486) 2 7 7 28859 2
6487 261445 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 339 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007092 2095790 37.7350412423636 -122.417903903871 (37.7350412423636, -122.417903903871) 2 7 7 28859 2
3329 260429 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 580 Capp St 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778605 6007240 2103949 37.7574523501876 -122.417970414127 (37.7574523501876, -122.417970414127) 2 4 7 28859 19
12438 260430 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 580 Capp St 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778605 6007240 2103949 37.7574523501876 -122.417970414127 (37.7574523501876, -122.417970414127) 2 4 7 28859 19
2941 261590 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 299x 14th St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006795 2107850 37.7681385292637 -122.41978620049 (37.7681385292637, -122.41978620049) 8 4 7 28853 19
12221 261589 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 299x 14th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006795 2107850 37.7681385292637 -122.41978620049 (37.7681385292637, -122.41978620049) 8 4 7 28853 19
76348 258086 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 381 Lexington St 1 Sidewalk: Property side : Cutout Tree Private 2       2x1   6006575 2103913 37.7573160533564 -122.420267699006 (37.7573160533564, -122.420267699006) 2 4 7 28859 19
3850 262121 Planning Code 138.1 required 2 Potential Site :: Potential Site 48 296x Day St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004047 2098716 37.7429035313116 -122.428640063872 (37.7429035313116, -122.428640063872) 2 7 5 63 22
7182 262122 Planning Code 138.1 required 2 Potential Site :: Potential Site 48 296x Day St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004047 2098716 37.7429035313116 -122.428640063872 (37.7429035313116, -122.428640063872) 2 7 5 63 22
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
502 251299 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 2190X Market St 3 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
58500 251298 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 2190X Market St 4 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
72617 251297 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 2190X Market St 5 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
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

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