trees

736 rows where DBH = 3 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)
1751 121138 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 1388x Minna St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/08/2016 12:00:00 AM 3 3x3                      
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                    
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                    
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                      
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                    
8822 260549 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1190 Valencia St 4 Sidewalk: Curb side : Cutout Tree Private 2   02/15/2018 12:00:00 AM 3 3x3 Permit Number 776221                    
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                    
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                    
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                    
12861 253706 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 98X Shotwell St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2017 12:00:00 AM 3 3x4 Permit Number 775137                    
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                    
15566 121139 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 1388x Minna St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/08/2016 12:00:00 AM 3 3x3                      
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                    
17897 254369 Planning Code 138.1 required 2 Citrus spp :: Lemon: Orange: Lime 120 590X Orizaba Ave 2 Back Yard : Yard Tree Private 2   02/06/2018 12:00:00 AM 3   Permit Number 778929                    
18342 253705 Planning Code 138.1 required 2 Eriobotrya deflexa :: Bronze Loquat 8 98X Shotwell St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2017 12:00:00 AM 3 3x4 Permit Number 775137                    
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                    
100024 258333 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 215X Raccoon Dr 2 Sidewalk: Property side : Yard Tree Private 2   04/29/2019 12:00:00 AM 3 3X3 Permit Number 776074                    
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                    
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
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
141327 253287 Planning Code 138.1 required 2 Tree(s) :: 17 1237 Shafter Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/16/2017 12:00:00 AM 3 3x3 Permit Number 780510 6016839.12241 2092718.79414 37.7271520593202 -122.383990506478 (37.7271520593202, -122.383990506478) 10 3 8 58 1
15059 254699 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 650 Illinois St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3   Permit Number 778364 6015970.50894 2106056.61706 37.7637269088073 -122.387923622314 (37.7637269088073, -122.387923622314) 14 3 8 28856 29
96441 254702 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 650 Illinois St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3   Permit Number 778364 6015970.50894 2106056.61706 37.7637269088073 -122.387923622314 (37.7637269088073, -122.387923622314) 14 3 8 28856 29
145856 254700 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 650 Illinois St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3   Permit Number 778364 6015970.50894 2106056.61706 37.7637269088073 -122.387923622314 (37.7637269088073, -122.387923622314) 14 3 8 28856 29
191366 254701 Planning Code 138.1 required 2 Magnolia grandiflora :: Southern Magnolia 19 650 Illinois St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3   Permit Number 778364 6015970.50894 2106056.61706 37.7637269088073 -122.387923622314 (37.7637269088073, -122.387923622314) 14 3 8 28856 29
126777 254698 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 2051 03rd St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3   Permit Number 778364 6015756.78552 2106043.12781 37.763678027819 -122.388661890454 (37.763678027819, -122.388661890454) 14 3 8 28856 29
161423 254697 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 2051 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3   Permit Number 778364 6015756.78552 2106043.12781 37.763678027819 -122.388661890454 (37.763678027819, -122.388661890454) 14 3 8 28856 29
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
104520 105275 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 64 Townsend St 4 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015531.53579 2112438.89481 37.7812269075454 -122.389887748547 (37.7812269075454, -122.389887748547) 6 2 9 28856 6
29570 105276 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 64 Townsend St 5 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015520.22928 2112423.42174 37.7811837949483 -122.389925782657 (37.7811837949483, -122.389925782657) 6 2 9 28856 6
95774 105277 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 64 Townsend St 6 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015510.23316 2112419.28649 37.7811718861147 -122.38996007562 (37.7811718861147, -122.38996007562) 6 2 9 28856 6
1962 122597 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 42X Colin P Kelly Jr St 5 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480 2112413 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941) 6 2 9 28856 6
19209 122592 Planning Code 138.1 required 2 Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 189 72 Townsend St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480 2112413 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941) 6 2 9 28856 6
27168 75842 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 42X Colin P Kelly Jr St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480 2112413 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941) 6 2 9 28856 6
34241 122599 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 42X Colin P Kelly Jr St 7 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480 2112413 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941) 6 2 9 28856 6
60760 122593 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 72 Townsend St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480 2112413 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941) 6 2 9 28856 6
72432 122594 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 72 Townsend St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480 2112413 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941) 6 2 9 28856 6
100384 122598 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 42X Colin P Kelly Jr St 6 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480 2112413 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941) 6 2 9 28856 6
111086 122596 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 42X Colin P Kelly Jr St 4 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480 2112413 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941) 6 2 9 28856 6
118733 72480 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 42X Colin P Kelly Jr St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480 2112413 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941) 6 2 9 28856 6
180599 75872 Planning Code 138.1 required 2 Pyrus calleryana :: Ornamental Pear 44 42X Colin P Kelly Jr St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2016 12:00:00 AM 3 3x3 Permit Number 779103 6015480 2112413 37.781152948088 -122.390064228941 (37.781152948088, -122.390064228941) 6 2 9 28856 6
17276 72565 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 270 Brannan St 1 Sidewalk: Property side : Cutout Tree Private 2     3 4x4 Permit Number 770847 6015158 2112983 37.7827001752808 -122.391218053322 (37.7827001752808, -122.391218053322) 6 2 9 28856 6
122606 187947 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 8 Sidewalk: Curb side : Yard Tree Private 2     3     6015161.72984 2115222.99296 37.7888508922136 -122.391361788631 (37.7888508922136, -122.391361788631) 6 2 9 28855 6
149325 187946 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 7 Sidewalk: Curb side : Yard Tree Private 2     3     6015145.56326 2115239.56325 37.7888954931699 -122.391418882079 (37.7888954931699, -122.391418882079) 6 2 9 28855 6
73578 187945 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 6 Sidewalk: Curb side : Yard Tree Private 2     3     6015129.76051 2115255.3706 37.7889380194338 -122.391474663423 (37.7889380194338, -122.391474663423) 6 2 9 28855 6
133882 187944 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 5 Sidewalk: Curb side : Yard Tree Private 2     3     6015109.7038 2115276.55289 37.7889950679055 -122.391545539018 (37.7889950679055, -122.391545539018) 6 2 9 28855 6
71462 187943 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 4 Sidewalk: Curb side : Yard Tree Private 2     3     6015093.73077 2115293.30797 37.7890401869059 -122.391601975949 (37.7890401869059, -122.391601975949) 6 2 9 28855 6
34491 187942 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 3 Sidewalk: Curb side : Yard Tree Private 2     3     6015080.74918 2115307.92538 37.7890796023783 -122.391647913344 (37.7890796023783, -122.391647913344) 6 2 9 28855 6
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
110801 187940 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 1 Sidewalk: Curb side : Yard Tree Private 2     3     6015048.62855 2115342.19505 37.7891719160015 -122.391761444649 (37.7891719160015, -122.391761444649) 6 2 9 28855 6
30147 115348 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 399 Fremont St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 4x10 Permit Number 773314 6014915.48611 2114547.78532 37.7869832575075 -122.39216652446 (37.7869832575075, -122.39216652446) 6 2 9 28855 6
152753 115349 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 399 Fremont St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 4x10 Permit Number 773314 6014896.08459 2114567.05321 37.7870350854597 -122.392234997951 (37.7870350854597, -122.392234997951) 6 2 9 28855 6
101037 115350 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 399 Fremont St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 4x10 Permit Number 773314 6014880.23802 2114582.9179 37.7870777663613 -122.392290933986 (37.7870777663613, -122.392290933986) 6 2 9 28855 6
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
121157 257909 Planning Code 138.1 required 2 Tree(s) :: 17 199x Townsend St 2 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
193393 257908 Planning Code 138.1 required 2 Tree(s) :: 17 199x Townsend St 1 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
153202 115351 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 399 Fremont St 4 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 4x10 Permit Number 773314 6014858.41874 2114606.67601 37.7871417890985 -122.392368086818 (37.7871417890985, -122.392368086818) 6 2 9 28855 6
96508 115347 Planning Code 138.1 required 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 398X HARRISON ST 2 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 4x4 Permit Number 773314 6014854 2114630 37.7872055860551 -122.392385006805 (37.7872055860551, -122.392385006805) 6 2 9 28855 6
184398 115346 Planning Code 138.1 required 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 398X HARRISON ST 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 4x4 Permit Number 773314 6014854 2114630 37.7872055860551 -122.392385006805 (37.7872055860551, -122.392385006805) 6 2 9 28855 6
60187 115352 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 399 Fremont St 5 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 4x10 Permit Number 773314 6014845.33617 2114621.37484 37.7871814222392 -122.392414378515 (37.7871814222392, -122.392414378515) 6 2 9 28855 6
22052 115353 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 399 Fremont St 6 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 4x10 Permit Number 773314 6014819.91687 2114646.31579 37.7872484927813 -122.39250406973 (37.7872484927813, -122.39250406973) 6 2 9 28855 6
116898 115354 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 399 Fremont St 7 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 4x10 Permit Number 773314 6014804.62773 2114662.16926 37.7872911737029 -122.39255807669 (37.7872911737029, -122.39255807669) 6 2 9 28855 6
134726 113241 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 329 Brannan St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2015 12:00:00 AM 3 3x4 Permit Number 770912 6014742.36618 2112476.99378 37.7812877223957 -122.39262057329 (37.7812877223957, -122.39262057329) 6 2 9 28856 6
65353 115355 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 399 Fremont St 8 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 4x10 Permit Number 773314 6014786.34664 2114681.69198 37.7873437633547 -122.392622692086 (37.7873437633547, -122.392622692086) 6 2 9 28855 6
26350 115356 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 399 Fremont St 9 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 4x10 Permit Number 773314 6014763.69701 2114705.74438 37.7874085478076 -122.392702738938 (37.7874085478076, -122.392702738938) 6 2 9 28855 6
27935 253392 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 115 Steuart St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/30/2017 12:00:00 AM 3 3x3 Permit Number 771767 6014754.16338 2116767.09226 37.7930680031541 -122.392879995147 (37.7930680031541, -122.392879995147) 12 2 9 28855 6
70032 253393 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 115 Steuart St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/30/2017 12:00:00 AM 3 3x3 Permit Number 771767 6014754.16338 2116767.09226 37.7930680031541 -122.392879995147 (37.7930680031541, -122.392879995147) 12 2 9 28855 6
183902 253394 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 115 Steuart St 3 Sidewalk: Curb side : Cutout Tree Private 2   08/30/2017 12:00:00 AM 3 3x3 Permit Number 771767 6014754.16338 2116767.09226 37.7930680031541 -122.392879995147 (37.7930680031541, -122.392879995147) 12 2 9 28855 6
102133 113329 Planning Code 138.1 required 2 Platanus x hispanica :: Sycamore: London Plane 27 329 Brannan St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2015 12:00:00 AM 3 3x3 Permit Number 770912 6014656.6559 2112395.64308 37.7810595913673 -122.392911397837 (37.7810595913673, -122.392911397837) 6 2 9 28856 6
26571 150167 Planning Code 138.1 required 2 Pyrus kawakamii :: Evergreen Pear 83 333 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/20/2017 12:00:00 AM 3 Width 3ft Permit Number 779492 6014367.55242 2105483.96934 37.7620656102492 -122.393427719319 (37.7620656102492, -122.393427719319) 10 3 8 28856 29
115977 258090 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 1223 Hollister Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/06/2019 12:00:00 AM 3 4x6   6013685 2090528 37.7209617016481 -122.394740998302 (37.7209617016481, -122.394740998302) 10 3 8 58 1
4228 254718 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 900 16th St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 3x4   6013911 2107143 37.7665955668607 -122.39512298129 (37.7665955668607, -122.39512298129) 14 3 8 28856 20
49512 254717 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 900 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 3x4   6013911 2107143 37.7665955668607 -122.39512298129 (37.7665955668607, -122.39512298129) 14 3 8 28856 20
111570 254719 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 900 16th St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 3x4   6013911 2107143 37.7665955668607 -122.39512298129 (37.7665955668607, -122.39512298129) 14 3 8 28856 20
114018 254721 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 900 16th St 6 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 3x4   6013911 2107143 37.7665955668607 -122.39512298129 (37.7665955668607, -122.39512298129) 14 3 8 28856 20
126016 254720 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 900 16th St 5 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 3x4   6013911 2107143 37.7665955668607 -122.39512298129 (37.7665955668607, -122.39512298129) 14 3 8 28856 20
131987 254722 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 900 16th St 7 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 3x4   6013911 2107143 37.7665955668607 -122.39512298129 (37.7665955668607, -122.39512298129) 14 3 8 28856 20
162006 254723 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 900 16th St 8 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 3x4   6013911 2107143 37.7665955668607 -122.39512298129 (37.7665955668607, -122.39512298129) 14 3 8 28856 20
164068 254716 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 900 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 3x4   6013911 2107143 37.7665955668607 -122.39512298129 (37.7665955668607, -122.39512298129) 14 3 8 28856 20
6762 260431 Planning Code 138.1 required 2 Tree(s) :: 17 181 Fremont St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/27/2019 12:00:00 AM 3 3x3   6013986 2115554 37.7896944377585 -122.395452879395 (37.7896944377585, -122.395452879395) 12 2 9 28855 6
8436 260432 Planning Code 138.1 required 2 Tree(s) :: 17 181 Fremont St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/27/2019 12:00:00 AM 3 3x3   6013986 2115554 37.7896944377585 -122.395452879395 (37.7896944377585, -122.395452879395) 12 2 9 28855 6
139833 198581 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013801.3988 2107146.90693 37.7666001988537 -122.395502349162 (37.7666001988537, -122.395502349162) 14 3 8 28856 20
185470 198582 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013779.59756 2107146.17602 37.7665969792947 -122.395577705173 (37.7665969792947, -122.395577705173) 14 3 8 28856 20
24826 198583 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013760.46871 2107146.56354 37.7665969793027 -122.395643896153 (37.7665969793027, -122.395643896153) 14 3 8 28856 20
55756 198584 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013716.83628 2107143.63605 37.7665865138841 -122.395794609033 (37.7665865138841, -122.395794609033) 14 3 8 28856 20
158870 198585 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 5 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013694.72301 2107142.03178 37.7665808787261 -122.395870983078 (37.7665808787261, -122.395870983078) 14 3 8 28856 20
114716 198586 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 6 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013678.51918 2107141.48068 37.7665784640576 -122.39592699106 (37.7665784640576, -122.39592699106) 14 3 8 28856 20
59194 198587 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 7 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013654.04555 2107139.63113 37.7665720240075 -122.396011512024 (37.7665720240075, -122.396011512024) 14 3 8 28856 20
166195 198588 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 8 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013599.81261 2107136.62549 37.766560753709 -122.396198884879 (37.766560753709, -122.396198884879) 14 3 8 28856 20
189573 198589 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 9 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013524.37895 2107133.46335 37.76654787361 -122.396459576758 (37.76654787361, -122.396459576758) 14 3 8 28856 20
37035 198590 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 10 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013501.44813 2107135.10099 37.766551094089 -122.396539005766 (37.766551094089, -122.396539005766) 14 3 8 28856 20
72278 198591 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 11 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013476.96853 2107132.95858 37.7665438491392 -122.396623526764 (37.7665438491392, -122.396623526764) 14 3 8 28856 20
131688 198592 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 12 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013452.45897 2107129.35079 37.766532578853 -122.396708048633 (37.766532578853, -122.396708048633) 14 3 8 28856 20
93355 199442 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 189 Hubbell St 20 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013442.0065 2107543.23317 37.7676684261738 -122.396773220723 (37.7676684261738, -122.396773220723) 14 3 8 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)
);