trees

8,298 rows where qLegalStatus_id = 4 sorted by Zip Codes

✎ View and edit SQL

This data as json, CSV (advanced)

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes ▼ Neighborhoods (old)
767 100549 Undocumented 4 Acer spp :: Maple 88 290X Tehama St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 3x4                      
3669 103667 Undocumented 4 Tree(s) :: 17 350X Hickory St 6 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
4476 112909 Undocumented 4 Tree(s) :: 17 1899X Beach St 2 Sidewalk: Curb side : Cutout Tree Private 2                              
4983 112267 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X Geary St 1 Sidewalk: Curb side : Cutout Tree Private 2                              
5100 101532 Undocumented 4 Tree(s) :: 17 11323 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3                      
5748 115724 Undocumented 4 Syzygium paniculatum :: Brush Cherry 243 250x Octavia St 1 Side Yard : Yard Tree Dept of Real Estate 7                              
6238 103666 Undocumented 4 Tree(s) :: 17 350X Hickory St 5 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
7827 115725 Undocumented 4 Syzygium paniculatum :: Brush Cherry 243 250X Octavia St 2 Side Yard : Yard Tree Dept of Real Estate 7                              
9335 112908 Undocumented 4 Tree(s) :: 17 1899X Beach St 1 Sidewalk: Curb side : Cutout Tree Private 2                              
9557 112910 Undocumented 4 Tree(s) :: 17 1899X Beach St 3 Sidewalk: Curb side : Cutout Tree Private 2                              
10205 173902 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 601x Hearst Ave 2 Sidewalk: Curb side : Cutout Tree Private 2                              
10489 102839 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 1101X Portola Dr 2 Sidewalk: Property side : Yard Tree DPW 1                              
10516 102842 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 1101X Portola Dr 8 Sidewalk: Property side : Yard Tree DPW 1                              
10813 100543 Undocumented 4 Acer spp :: Maple 88 290X Tehama St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 3x4                      
10916 108180 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 835 Sacramento St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3                      
10998 100001 Undocumented 4 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 501X 01st St 2 Sidewalk: Curb side : Pot Tree Private 2         Address is 100 1st Street                    
11335 112269 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X Geary St 3 Sidewalk: Curb side : Cutout Tree Private 2                              
12733 102843 Undocumented 4 Acacia melanoxylon :: Blackwood Acacia 70 1101X Portola Dr 10 Sidewalk: Property side : Yard Tree DPW 1                              
14524 99746 Undocumented 4 Ligustrum lucidum :: Glossy Privet 57 4250 Clipper St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3                      
15154 102838 Undocumented 4 Pinus radiata :: Monterey Pine 15 1101X Portola Dr 1 Sidewalk: Property side : Yard Tree DPW 1                              
15233 109923 Undocumented 4 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 214 state st 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3                      
15258 103665 Undocumented 4 Tree(s) :: 17 350X Hickory St 4 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
16355 103663 Undocumented 4 Tree(s) :: 17 350X Hickory St 2 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
18064 103664 Undocumented 4 Tree(s) :: 17 350X Hickory St 3 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
18422 112268 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X Geary St 2 Sidewalk: Curb side : Cutout Tree Private 2                              
18674 103662 Undocumented 4 Tree(s) :: 17 350X Hickory St 1 Front Yard : Yard Tree DPW for City Agency 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
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
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
447 114683 Undocumented 4 Ficus Spp. :: 101 235 GEARY ST 3 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6010571 2114715 37.7872002104764 -122.407209329428 (37.7872002104764, -122.407209329428) 5 10 10 28852 6
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
2553 140071 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 601X Octavia St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6005402 2111410 37.7778348570605 -122.424857751543 (37.7778348570605, -122.424857751543) 7 9 11 28852 10
2733 107738 Undocumented 4 Tree(s) :: 17 155x HAYES ST 4 Sidewalk: Curb side : Cutout Tree Private 2   05/04/2016 12:00:00 AM 3 3x3 Permit Number 774227 6007127.8 2111172.9 37.7772811641179 -122.41887077508 (37.7772811641179, -122.41887077508) 7 9 9 28852 36
4754 101985 Undocumented 4 Tree(s) :: 17 205X Rose St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005538.6 2109749.6 37.7732835163003 -122.424267082997 (37.7732835163003, -122.424267082997) 7 9 11 28852 10
5012 261384 Undocumented 4 Potential Site :: Potential Site 48 246 Leavenworth St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008558 2113314 37.7832405398106 -122.41407474629 (37.7832405398106, -122.41407474629) 7 10 9 28852 36
5054 102983 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 555 Turk St 10 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007348.4 2112963.4 37.7822098643106 -122.41823462296 (37.7822098643106, -122.41823462296) 7 9 9 28852 36
5583 244247 Undocumented 4 :: 45 200 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6005673.0642 2110022.689 37.7740409443959 -122.423821374378 (37.7740409443959, -122.423821374378) 7 9 11 28852 10
6007 261051 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 770 Van Ness Ave 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006693 2113137 37.7826496144307 -122.420514344125 (37.7826496144307, -122.420514344125) 7 9 9 28852 36
9864 102975 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 555 Turk St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007348.4 2112963.4 37.7822098643106 -122.41823462296 (37.7822098643106, -122.41823462296) 7 9 9 28852 36
10626 117236 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 635 GROVE ST 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004711 2111132 37.7770324835269 -122.427228354699 (37.7770324835269, -122.427228354699) 7 9 11 28852 10
10726 113513 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 352 TURK ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008306 2113136 37.7827376375446 -122.414933965724 (37.7827376375446, -122.414933965724) 7 10 9 28852 36
10966 109166 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 51x OCTAVIA ST 5 Median : Cutout Tree DPW 1       3x20   6005650.4 2109419.7 37.772384002649 -122.423856888434 (37.772384002649, -122.423856888434) 7 9 11 28852 10
11452 110549 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 2x LILY ST 7 Sidewalk: Curb side : Cutout Tree Private 2       2.5x4   6006369 2110405 37.7751299410446 -122.421441165405 (37.7751299410446, -122.421441165405) 7 9 11 28852 10
11559 261050 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 770 Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006693 2113137 37.7826496144307 -122.420514344125 (37.7826496144307, -122.420514344125) 7 9 9 28852 36
11636 249410 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 698 Polk St 1 : Tree Private 2     17 Width 3ft   6007114.55441 2113257.76141 37.7830049436594 -122.419064511231 (37.7830049436594, -122.419064511231) 7 9 9 28852 36
12000 261047 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 750 Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006673 2113065 37.7824507928685 -122.420578423098 (37.7824507928685, -122.420578423098) 7 9 9 28852 36
12604 116259 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 155 LAGUNA ST 7 Sidewalk: Curb side : Cutout Tree Private 2       7x6   6005176 2109399 37.7723003725615 -122.425496410637 (37.7723003725615, -122.425496410637) 7 9 5 28852 10
13756 261045 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 750 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006673 2113065 37.7824507928685 -122.420578423098 (37.7824507928685, -122.420578423098) 7 9 9 28852 36
14793 114686 Undocumented 4 Ficus Spp. :: 101 235 GEARY ST 6 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6010571 2114715 37.7872002104764 -122.407209329428 (37.7872002104764, -122.407209329428) 5 10 10 28852 6
14967 108631 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 501 ELLIS ST 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6008465.6 2113811.6 37.7846016393538 -122.4144296353 (37.7846016393538, -122.4144296353) 7 10 9 28852 36
15238 261049 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 770 Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006693 2113137 37.7826496144307 -122.420514344125 (37.7826496144307, -122.420514344125) 7 9 9 28852 36
15598 112413 Undocumented 4 Callistemon citrinus :: Lemon Bottlebrush 67 469x IVY ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005169 2110996 37.7766849510116 -122.425634307332 (37.7766849510116, -122.425634307332) 7 9 11 28852 10
15642 102891 Undocumented 4 Tree(s) :: 17 115 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008968 2112966 37.7823080347026 -122.412631696322 (37.7823080347026, -122.412631696322) 7 10 9 28852 36
15734 102859 Undocumented 4 Tree(s) :: 17 696 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6009251 2115330 37.7888148901218 -122.411819735773 (37.7888148901218, -122.411819735773) 5 1 10 28852 21
16085 261385 Undocumented 4 Potential Site :: Potential Site 48 238 Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008591 2113342 37.7833192745132 -122.413962560517 (37.7833192745132, -122.413962560517) 7 10 9 28852 36
16405 114682 Undocumented 4 Ficus Spp. :: 101 235 GEARY ST 2 Sidewalk: Curb side : Pot Tree Private 2           6010571 2114715 37.7872002104764 -122.407209329428 (37.7872002104764, -122.407209329428) 5 10 10 28852 6
16787 105348 Undocumented 4 Photinia fraseri :: Photinia: Chinese photinia 166 651X Ivy St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6004248.77005 2110989.99433 37.7766164199227 -122.428817225763 (37.7766164199227, -122.428817225763) 7 9 11 28852 10
17663 101489 Undocumented 4 Ceratonia siliqua :: Carob 5 59X Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/26/2012 12:00:00 AM 1 3x3 Permit Number 769087 6005416.7 2109221 37.7718252244657 -122.424651142233 (37.7718252244657, -122.424651142233) 7 9 5 28852 10
18163 140072 Undocumented 4 Ficus retusa nitida :: Banyan Fig 54 601X Octavia St 3 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6005402 2111410 37.7778348570605 -122.424857751543 (37.7778348570605, -122.424857751543) 7 9 11 28852 10
18428 261048 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 770 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006693 2113137 37.7826496144307 -122.420514344125 (37.7826496144307, -122.420514344125) 7 9 9 28852 36
19924 114954 Undocumented 4 Ficus Spp. :: 101 601x OCTAVIA ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005348 2111368 37.7777164851071 -122.42504156742 (37.7777164851071, -122.42504156742) 7 9 11 28852 10
20378 116241 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 229x HAIGHT ST 4 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6005035 2109517 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154) 7 9 5 28852 10
21018 110553 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 2x LILY ST 11 Sidewalk: Curb side : Cutout Tree Private 2       2.5x4   6006369 2110405 37.7751299410446 -122.421441165405 (37.7751299410446, -122.421441165405) 7 9 11 28852 10
21249 112640 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 299X STOCKTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     15 6x9   6010693 2115178 37.7884783251045 -122.406819877074 (37.7884783251045, -122.406819877074) 5 1 10 28852 6
23806 108427 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 270X HAYES ST 12 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006095.6 2111028.7 37.7768270516853 -122.422431244298 (37.7768270516853, -122.422431244298) 7 9 11 28852 10
25215 117234 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 635 GROVE ST 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004711 2111132 37.7770324835269 -122.427228354699 (37.7770324835269, -122.427228354699) 7 9 11 28852 10
25732 116996 Undocumented 4 Pinus pinea :: Italian Stone Pine 63 606x FULTON ST   Front Yard : Yard Tree Private 2   09/29/2016 12:00:00 AM 3     6004628 2111737 37.7786889706302 -122.427558590519 (37.7786889706302, -122.427558590519) 7 9 11 28852 41
25929 102776 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 62X Leavenworth St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6008658 2112778 37.7817744284412 -122.413690860804 (37.7817744284412, -122.413690860804) 7 10 9 28852 36
27481 108924 Undocumented 4 Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 335-341 Oak St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 3x3   6005380.1 2110235.1 37.7746076306443 -122.424849903476 (37.7746076306443, -122.424849903476) 7 9 11 28852 10
28979 110554 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 2x LILY ST 12 Sidewalk: Curb side : Cutout Tree Private 2       2.5x4   6006369 2110405 37.7751299410446 -122.421441165405 (37.7751299410446, -122.421441165405) 7 9 11 28852 10
29178 129906 Undocumented 4 Lophostemon confertus :: Brisbane Box 11 536 Fell St 1 : Tree Private 2     16 Width 3ft   6004841.59685 2110577.9768 37.7755186559901 -122.426737115928 (37.7755186559901, -122.426737115928) 7 9 11 28852 10
29615 120137 Undocumented 4 Ficus nitida :: Laurel Fig 53 10X Grove St 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007842 2111812 37.7790761683861 -122.416445400738 (37.7790761683861, -122.416445400738) 7 10 9 28852 36
31946 245835 Undocumented 4 :: 45 451 Fell St 4 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 0ft   6005269.6444 2110584.5711 37.7755609539167 -122.4252568647 (37.7755609539167, -122.4252568647) 7 9 11 28852 10
32081 117240 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 635 GROVE ST 12 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004711 2111132 37.7770324835269 -122.427228354699 (37.7770324835269, -122.427228354699) 7 9 11 28852 10
32669 256769 Undocumented 4 Tilia cordata :: Littleleaf Linden 12 300X Octavia St 1 Median : Cutout Tree Private 2       3x3   6005602 2110303 37.774806598562 -122.424087136382 (37.774806598562, -122.424087136382) 7 9 11 28852 10
32994 257945 Undocumented 4 Tristania conferta :: 61 901x Gough St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005635 2113075 37.782419697088 -122.42417016492 (37.782419697088, -122.42417016492) 7 9 11 28852 41
33897 100566 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 312 Mason St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6009858 2114440 37.7864051976389 -122.409656748713 (37.7864051976389, -122.409656748713) 5 10 10 28852 36
34017 100567 Undocumented 4 Metrosideros excelsa :: New Zealand Xmas Tree 16 312 Mason St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6009858 2114440 37.7864051976389 -122.409656748713 (37.7864051976389, -122.409656748713) 5 10 10 28852 36
34250 120979 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 699X Polk St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007023 2113270 37.7830333917519 -122.419382121036 (37.7830333917519, -122.419382121036) 7 9 9 28852 36
35379 254803 Undocumented 4 Eucalyptus Spp :: Eucalyptus 52 525 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005345 2110923 37.7764944541895 -122.425020275756 (37.7764944541895, -122.425020275756) 7 9 11 28852 10
35784 108421 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 270X HAYES ST 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006095.6 2111028.7 37.7768270516853 -122.422431244298 (37.7768270516853, -122.422431244298) 7 9 11 28852 10
36000 104437 Undocumented 4 Ficus microcarpa :: Chinese Banyan 97 534 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2           6005464 2111103 37.7769954116482 -122.424621427703 (37.7769954116482, -122.424621427703) 7 9 11 28852 10
36097 115453 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 300 Octavia St Frontage East 4 Sidewalk: Curb side : Cutout Tree DPW 1       4x4   6005602 2110303 37.774806598562 -122.424087136382 (37.774806598562, -122.424087136382) 7 9 11 28852 10
36354 114684 Undocumented 4 Ficus Spp. :: 101 235 GEARY ST 4 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6010571 2114715 37.7872002104764 -122.407209329428 (37.7872002104764, -122.407209329428) 5 10 10 28852 6
36522 101983 Undocumented 4 Tree(s) :: 17 205X Rose St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005538.6 2109749.6 37.7732835163003 -122.424267082997 (37.7732835163003, -122.424267082997) 7 9 11 28852 10
37182 109162 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 51x OCTAVIA ST 1 Median : Cutout Tree DPW 1     6 3x20   6005650.4 2109419.7 37.772384002649 -122.423856888434 (37.772384002649, -122.423856888434) 7 9 11 28852 10
37353 108422 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 270X HAYES ST 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006095.6 2111028.7 37.7768270516853 -122.422431244298 (37.7768270516853, -122.422431244298) 7 9 11 28852 10
37445 118287 Undocumented 4 Pyrus kawakamii :: Evergreen Pear 83 240 IVY ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x2.5   6006177 2111293 37.7775573470216 -122.422168438332 (37.7775573470216, -122.422168438332) 7 9 11 28852 10
38409 110550 Undocumented 4 Prunus serrulata :: Ornamental Cherry 84 2x LILY ST 8 Sidewalk: Curb side : Cutout Tree Private 2       2.5x4   6006369 2110405 37.7751299410446 -122.421441165405 (37.7751299410446, -122.421441165405) 7 9 11 28852 10
38715 120144 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008026 2111839 37.7791606496002 -122.415810780563 (37.7791606496002, -122.415810780563) 7 10 9 28852 36
39065 117232 Undocumented 4 Platanus x hispanica :: Sycamore: London Plane 27 635 GROVE ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004711 2111132 37.7770324835269 -122.427228354699 (37.7770324835269, -122.427228354699) 7 9 11 28852 10
39077 103271 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 350 Page St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004879 2109882 37.7736097878739 -122.426558160091 (37.7736097878739, -122.426558160091) 7 9 11 28852 10
40305 114742 Undocumented 4 Olea europaea :: Olive Tree 9 188 BUCHANAN ST 5 Sidewalk: Curb side : Cutout Tree Private 2     2 4x4   6004735 2109327 37.7720777510232 -122.427016741179 (37.7720777510232, -122.427016741179) 7 9 5 28852 10
41602 114741 Undocumented 4 Olea europaea :: Olive Tree 9 188 BUCHANAN ST 4 Sidewalk: Curb side : Cutout Tree Private 2     2 4x4   6004735 2109327 37.7720777510232 -122.427016741179 (37.7720777510232, -122.427016741179) 7 9 5 28852 10
41773 120139 Undocumented 4 Ficus nitida :: Laurel Fig 53 10X Grove St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007842 2111812 37.7790761683861 -122.416445400738 (37.7790761683861, -122.416445400738) 7 10 9 28852 36
42257 115376 Undocumented 4 Corymbia ficifolia :: Red Flowering Gum 28 500 BUCHANAN ST 1 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6004637 2110246 37.7745955592359 -122.427421211008 (37.7745955592359, -122.427421211008) 7 9 11 28852 10
42356 105346 Undocumented 4 Photinia fraseri :: Photinia: Chinese photinia 166 651X Ivy St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6004248.77005 2110989.99433 37.7766164199227 -122.428817225763 (37.7766164199227, -122.428817225763) 7 9 11 28852 10
42496 116243 Undocumented 4 Olea europaea 'Fruitless' :: Fruitless Olive 177 229x HAIGHT ST 6 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6005035 2109517 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154) 7 9 5 28852 10
44701 102897 Undocumented 4 Tree(s) :: 17 40 Jones St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009201.8 2112650.6 37.7814551404658 -122.411800555351 (37.7814551404658, -122.411800555351) 14 10 9 28852 36
44883 220402 Undocumented 4 Acer palmatum 'Bloodgood' :: Bloodgood Japanese Maple 328 50 Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2       Width 2ft   6004328.50945 2108814.63576 37.7706479295788 -122.428386299898 (37.7706479295788, -122.428386299898) 7 9 11 28852 10
45829 131224 Undocumented 4 Melaleuca quinquenervia :: Cajeput 10 41 Jones St 2 Sidewalk: Curb side : Pot Tree Private 2     4 Width 4ft   6009083.28027 2112713.95456 37.7816224473696 -122.412215056906 (37.7816224473696, -122.412215056906) 7 10 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)
);