trees

736 rows where DBH = 3 and qLegalStatus_id = 2 sorted by Police Districts

✎ View and edit SQL

This data as json, CSV (advanced)

These facets timed out: 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                    
78246 143041 Planning Code 138.1 required 2 Olea europaea 'Fruitless' :: Fruitless Olive 177 2000 Powell St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/29/2017 12:00:00 AM 3 Width 0ft Permit Number 780933 6009568.471 2120534.3867 37.8031226669303 -122.411089086343 (37.8031226669303, -122.411089086343) 3 1 10 308 23
129695 116776 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1106 Pacific Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   04/28/2016 12:00:00 AM 3 3x3   6008776.88904 2117992.21481 37.7960980717264 -122.413648471894 (37.7960980717264, -122.413648471894) 5 1 10 308 21
136966 116777 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1106 Pacific Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   04/28/2016 12:00:00 AM 3 3x3   6008763.52683 2117990.43413 37.7960924320727 -122.413694581941 (37.7960924320727, -122.413694581941) 5 1 10 308 21
171427 116774 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1106 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/28/2016 12:00:00 AM 3 3x3   6008811.21548 2117995.14613 37.7961080479024 -122.413529902601 (37.7961080479024, -122.413529902601) 5 1 10 308 21
190292 116775 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1106 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   04/28/2016 12:00:00 AM 3 3x3   6008794.04431 2117993.28546 37.7961019747828 -122.413589186808 (37.7961019747828, -122.413589186808) 5 1 10 308 21
190939 13063 Planning Code 138.1 required 2 Olea europaea 'Fruitless' :: Fruitless Olive 177 590 Lombard St 2 Sidewalk: Curb side : Cutout Tree DPW 1   12/29/2017 12:00:00 AM 3 2X2 Permit Number 780933 6009554.3361 2120533.7978 37.803120257284 -122.411137959105 (37.803120257284, -122.411137959105) 3 1 10 308 23
3797 260871 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 198x Eddy St 4 Sidewalk: Curb side : Cutout Tree Private 2   10/16/2019 12:00:00 AM 3 3x3   6009475 2113668 37.7842640010762 -122.410927291409 (37.7842640010762, -122.410927291409) 14 10 9 28852 36
5118 169123 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 210 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2019 12:00:00 AM 3 Width 4ft   6009469.52117 2113800.26568 37.7846268637924 -122.410955591431 (37.7846268637924, -122.410955591431) 14 10 9 28852 36
9750 169122 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 210 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2019 12:00:00 AM 3 Width 4ft   6009478.56357 2113738.5186 37.7844578281201 -122.410919945006 (37.7844578281201, -122.410919945006) 14 10 9 28852 36
11471 260869 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 198x Eddy St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/16/2019 12:00:00 AM 3 3x3   6009475 2113668 37.7842640010762 -122.410927291409 (37.7842640010762, -122.410927291409) 14 10 9 28852 36
13730 260870 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 198x Eddy St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/16/2019 12:00:00 AM 3 3x3   6009475 2113668 37.7842640010762 -122.410927291409 (37.7842640010762, -122.410927291409) 14 10 9 28852 36
14869 117019 Planning Code 138.1 required 2 Metrosideros excelsa :: New Zealand Xmas Tree 16 168 Hyde St 3 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2016 12:00:00 AM 3 3x3 Permit Number 777550 6008121.68381 2113004.40875 37.782365960952 -122.415562303882 (37.782365960952, -122.415562303882) 7 10 9 28852 36
18437 260868 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 198x Eddy St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/16/2019 12:00:00 AM 3 3x3   6009475 2113668 37.7842640010762 -122.410927291409 (37.7842640010762, -122.410927291409) 14 10 9 28852 36
61797 117020 Planning Code 138.1 required 2 Metrosideros excelsa :: New Zealand Xmas Tree 16 168 Hyde St 4 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2016 12:00:00 AM 3 3x3 Permit Number 777550 6008118.25915 2113018.66588 37.7824049150971 -122.415575161466 (37.7824049150971, -122.415575161466) 7 10 9 28852 36
68035 117021 Planning Code 138.1 required 2 Metrosideros excelsa :: New Zealand Xmas Tree 16 168 Hyde St 5 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2016 12:00:00 AM 3 3x3 Permit Number 777550 6008114.19003 2113031.70239 37.7824404814865 -122.415590162171 (37.7824404814865, -122.415590162171) 7 10 9 28852 36
77658 94315 Planning Code 138.1 required 2 Metrosideros excelsa :: New Zealand Xmas Tree 16 399X Turk St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2016 12:00:00 AM 3 3x3 Permit Number 777550 6008122 2112982 37.7823044496932 -122.415559622955 (37.7823044496932, -122.415559622955) 7 10 9 28852 36
81347 117017 Planning Code 138.1 required 2 Metrosideros excelsa :: New Zealand Xmas Tree 16 168 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2016 12:00:00 AM 3 3x3 Permit Number 777550 6008130.7573 2112963.51283 37.7822541806174 -122.415528017206 (37.7822541806174, -122.415528017206) 7 10 9 28852 36
97662 117018 Planning Code 138.1 required 2 Metrosideros excelsa :: New Zealand Xmas Tree 16 168 Hyde St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2016 12:00:00 AM 3 3x3 Permit Number 777550 6008125.66458 2112987.05621 37.7823185388132 -122.415547303188 (37.7823185388132, -122.415547303188) 7 10 9 28852 36
642 260182 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 66x McCoppin St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/13/2019 12:00:00 AM 3 3x3   6006141 2109130 37.7716162396968 -122.422139269172 (37.7716162396968, -122.422139269172) 8 2 9 28853 19
728 102430 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 200 06th St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/25/2017 12:00:00 AM 3 4x4 Permit Number 770993 6010566.09371 2111909.33227 37.7794962351107 -122.407028471514 (37.7794962351107, -122.407028471514) 14 2 9 28853 34
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
6006 253478 Planning Code 138.1 required 2 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1222 Harrison St 4 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009984 2109753 37.7735428603255 -122.408890010762 (37.7735428603255, -122.408890010762) 8 2 9 28853 34
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
6978 253743 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1 Henry Adams St 9 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
8102 260181 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 66x McCoppin St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/13/2019 12:00:00 AM 3 3x3   6006141 2109130 37.7716162396968 -122.422139269172 (37.7716162396968, -122.422139269172) 8 2 9 28853 19
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
11745 260192 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1699 Market St 5 Sidewalk: Property side : Cutout Tree Private 2   08/13/2019 12:00:00 AM 3 4X4   6006124.91889 2109483.72494 37.7725865765291 -122.422220029928 (37.7725865765291, -122.422220029928) 8 2 9 28853 19
14403 260183 Planning Code 138.1 required 2 Olea europaea :: Olive Tree 9 66x McCoppin St 3 Sidewalk: Curb side : Cutout Tree Private 2   08/13/2019 12:00:00 AM 3 3x3   6006141 2109130 37.7716162396968 -122.422139269172 (37.7716162396968, -122.422139269172) 8 2 9 28853 19
14666 102429 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 200 06th St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/25/2017 12:00:00 AM 3 4x4 Permit Number 770993 6010552.49087 2111923.99595 37.7795357369219 -122.407076563634 (37.7795357369219, -122.407076563634) 14 2 9 28853 34
15918 255699 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 510 Townsend St 9 Sidewalk: Curb side : Cutout Tree Private 2   06/27/2018 12:00:00 AM 3 3x3   6012573 2109637 37.773369031352 -122.399926071367 (37.773369031352, -122.399926071367) 14 2 9 28853 34
16780 85805 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 210X Shipley St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011627 2111882 37.7794804977568 -122.403356401218 (37.7794804977568, -122.403356401218) 14 2 9 28856 34
16815 109466 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 11 Sidewalk: Curb side : Cutout Tree Private 2   03/15/2017 12:00:00 AM 3 4x4 Permit Number 773752 6013302.89282 2109368.02055 37.7726711397891 -122.397382385507 (37.7726711397891, -122.397382385507) 14 2 9 310 20
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
17501 251213 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 210X Shipley St 6 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011604 2111950 37.7796659253507 -122.403440753721 (37.7796659253507, -122.403440753721) 14 2 9 28856 34
17700 260555 Planning Code 138.1 required 2 Tree(s) :: 17 502 07th St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/23/2019 12:00:00 AM 3 3x3   6011196 2109910 37.7740417608934 -122.404708555539 (37.7740417608934, -122.404708555539) 14 2 9 28853 34
18138 260191 Planning Code 138.1 required 2 Tristaniopsis laurina :: Swamp Myrtle 1 1699 Market St 4 Sidewalk: Property side : Cutout Tree Private 2   08/13/2019 12:00:00 AM 3 4X4   6006124.91889 2109483.72494 37.7725865765291 -122.422220029928 (37.7725865765291, -122.422220029928) 8 2 9 28853 19
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
20988 201691 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 324 08th St 4 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009873.18605 2110010.6659 37.7742441430989 -122.40929152101 (37.7742441430989, -122.40929152101) 8 2 9 28853 34
21880 201692 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 324 08th St 5 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009893.13849 2109987.83278 37.7741825665069 -122.409220890035 (37.7741825665069, -122.409220890035) 8 2 9 28853 34
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
23724 15248 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1401X Mission St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/29/2016 12:00:00 AM 3 3X3 Permit Number 770901 6007914.86722 2110337.26914 37.7750310067149 -122.41608885424 (37.7750310067149, -122.41608885424) 8 2 9 28853 34
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
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
27322 201695 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 342 08th St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009961.08769 2109918.57103 37.7739961964126 -122.408980952704 (37.7739961964126, -122.408980952704) 8 2 9 28853 34
27368 109463 Planning Code 138.1 required 2 Koelreuteria bipinnata :: Chinese Flame Tree 164 360 Berry St 8 Sidewalk: Curb side : Cutout Tree Private 2   03/15/2017 12:00:00 AM 3 4x4 Permit Number 773752 6013357.96458 2109418.68041 37.7728133064148 -122.397195438039 (37.7728133064148, -122.397195438039) 14 2 9 310 20
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
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
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
31968 253741 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1 Henry Adams St 7 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
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
34271 251211 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 210X Shipley St 4 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011604 2111950 37.7796659253507 -122.403440753721 (37.7796659253507, -122.403440753721) 14 2 9 28856 34
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
34716 255695 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 510 Townsend St 5 Sidewalk: Curb side : Cutout Tree Private 2   06/27/2018 12:00:00 AM 3 3x3   6012573 2109637 37.773369031352 -122.399926071367 (37.773369031352, -122.399926071367) 14 2 9 28853 34
34894 253483 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
35262 253489 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 7 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
35619 85803 Planning Code 138.1 required 2 Ulmus parvifolia 'Drake' :: Drake's Chinese Elm 159 923 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 3x3 Permit Number 778048 6011427.0378 2111936.1074 37.779617893816 -122.40405196806 (37.779617893816, -122.40405196806) 14 2 9 28856 34
36333 253491 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 9 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
36458 113646 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1400 MISSION ST 3 Sidewalk: Curb side : Cutout Tree Private 2   02/09/2016 12:00:00 AM 3 4x6 Permit Number 773574 6007947 2110424 37.7752709556829 -122.415983842901 (37.7752709556829, -122.415983842901) 8 2 9 28853 34
39373 251291 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 33 08th St 5 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008734.11613 2111298.92197 37.7777175065003 -122.413322904728 (37.7777175065003, -122.413322904728) 8 2 9 28853 34
42190 253480 Planning Code 138.1 required 2 Acer rubrum 'Armstrong' :: Armstrong Red Maple 140 1222 Harrison St 6 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x6 Permit Number 772214 6009984 2109753 37.7735428603255 -122.408890010762 (37.7735428603255, -122.408890010762) 8 2 9 28853 34
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
48111 253753 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 2x Rhode Island St 7 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
50722 253485 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
50738 253752 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 2x Rhode Island St 6 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
52682 192595 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1321 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/07/1995 12:00:00 AM 3 Width 4ft Permit Number 770747 6008285.14461 2110684.68439 37.7760057386966 -122.414832573262 (37.7760057386966, -122.414832573262) 8 2 9 28853 34
52945 117454 Planning Code 138.1 required 2 Prunus cerasifera :: Cherry Plum 7 236 Shipley St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/15/2016 12:00:00 AM 3 3x3 Permit Number 776408 6011519 2111785 37.7792081256956 -122.403723194086 (37.7792081256956, -122.403723194086) 14 2 9 28856 34
57131 192563 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 33 08th St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 Width 3ft Permit Number 771124 6008747.97709 2111280.89227 37.7776687794229 -122.413273679445 (37.7776687794229, -122.413273679445) 8 2 9 28853 34
57241 253248 Planning Code 138.1 required 2 Washingtonia robusta :: Mexican Fan Palm 72 570 Jessie St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/09/2017 12:00:00 AM 3 3x3 Permit Number 775513 6009730.1467 2112442.13768 37.7809123781536 -122.409958002933 (37.7809123781536, -122.409958002933) 14 2 9 28853 34
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
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
61025 253495 Planning Code 138.1 required 2 Trachycarpus fortunei :: Windmill Palm 116 1x Gordon St 13 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2017 12:00:00 AM 3 3x3 Permit Number 772214 6009763 2109812 37.7736924789578 -122.409658650953 (37.7736924789578, -122.409658650953) 8 2 9 28853 34
61214 15236 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1321 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/27/2015 12:00:00 AM 3 3X3 Permit Number 770747 6008261.49106 2110663.48431 37.7759461992201 -122.414912896556 (37.7759461992201, -122.414912896556) 8 2 9 28853 34
61405 253746 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1 Henry Adams St 12 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
61672 15237 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 1321 Mission St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/27/2015 12:00:00 AM 3 3X3 Permit Number 770747 6008256.52807 2110680.03106 37.7759913537931 -122.414931236282 (37.7759913537931, -122.414931236282) 8 2 9 28853 34
62404 253750 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 2x Rhode Island St 4 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
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
67103 253756 Planning Code 138.1 required 2 Ginkgo biloba :: Maidenhair Tree 22 41x Division St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 5x5   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
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
71327 253751 Planning Code 138.1 required 2 Lophostemon confertus :: Brisbane Box 11 2x Rhode Island St 5 Sidewalk: Curb side : Cutout Tree Private 2   11/03/2017 12:00:00 AM 3 3x6   6011517 2108140 37.7691996810398 -122.403473604048 (37.7691996810398, -122.403473604048) 8 2 8 28853 20
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

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